This console script is responsible for asking questions about the database connection, to create the db.ini file and to create the tables in the database.
What database technology do you want to use?
sqlite: this will create a file in the current folder and use it as DB
mysql: this will connect to a local or remote mysql server, additional information is then required:
hostname: of the mysql server, defaults to 127.0.0.1
database: must already exist on hostname
username: as registered in the privileged users of the mysql server
password: his password
prefix: useful when users have only access to a single database. Similar to the way wordpress handles prefixes. The tables will be named
%prefix%_config(etc) instead of
config, for example.
The SQLite choice will create a xxx.sqlite file in the current (project) folder, while, for MySQL, one has to create an empty database first on the mysql server, see how to do this .
To run this script:
msnoise db init --help Usage: [OPTIONS] This command initializes the current folder to be a MSNoise Project by creating a database and a db.ini file. Options: --tech TEXT Database technology: 1=SQLite 2=MySQL 3=PostgreSQL --help Show this message and exit.
The credentials will be saved in a flat text file in the current directory. It’s not very safe, but until now we haven’t thought of another solution.