Essential interface-model-database system to store the information about the books one reads.
Imagine that you read a lot of books. Imagine also that you have no idea about how databases and graphical user interfaces (GUIs) work but you would like to learn.
Well, I don't know about you, but I found myself in the situation above and I thought that the most logical thing to do would be just one: coding a simple system to store the information about the books I read. In a MySQL database. With a GUI.
To run this code, you should first download the files in the directory. You can do it manually or by cloning the repo:
git clone https://github.com/FilippoPisello/Books-Read-DB
First of all, you should add your database credentials in the file "db_credentials.json" in the folder "userdata".
Only for the first use, the schema and tables should be created with this command:
python -m database.db_creation
To run the actual tool, you should go in the directory and run the following command:
python -m book_db_logger
The GUI will pop up.
To correctly execute the code there are some DB requirements to be fulfilled and some external libraries to be installed.
For the code to run:
- MySQL should be installed on the device
- MySQL service should be running
The following external libraries are required:
- gooey
- mysql