- MySQL for Windows. IMPORTANT!!! " C:\Program Files\MySQL\MySQL Server 8.0\bin " NEEDS TO BE ADDED TO PATH FOR BACKUPS TO WORK
- Python, with the additional libraries:
- Flask
- Flask-MySQLdb
- faker (for data generation)
- Flask-WTForms and email-validator (a more involved method of input validation)
Use pip3 install <package_name> to install each individual Python package (library) directly for the entire system, or create a virtual environment with the venv module. The necessary packages for this app are listed in requirements.txt and can be installed all together via pip install -r requirements.txt.
- Clone repository through git or GitHub Desktop
- Make sure all dependenies are met
- Run the following :
- myslq -u root -p
- source C:...\DB-Course\sql-scripts\mysql-library-schema.sql;
- source C:...\DB-Course\sql-scripts\mysql-library-insert-data.sql;
- (or run the sql files through mysql workbench)
- Run run.py in the dbdemo folder
- Connect to the website