This is a flask web application that allows user to perform SQL CRUD fuctions. SELECT,CREATE, INSERT, DELETE, UPDATE, ALTER and DROP.
- Create your virtual environment by running
virtualenv venv - Activate the virtual environment:
- For windows users ->
.\venv\Scripts\activate - For mac users ->
source env/bin/activate- Once virtualenv has been activated. Run
pip install -r requirements.txt. NOTE If you install a new package, make sure to runpip freeze > requirements.txtto update the requirements.txt file.
- Once virtualenv has been activated. Run
- For windows users ->
- Create a .env file with the database credentials. NOTE The .env file is already in the .gitignore file so it will not be pushed to github.
MYSQL_HOST = ""MYSQL_USER = ""MYSQL_PASSWORD = ""MYSQL_DATABASE= ""MYSQL_PORT = 3306
- For development purposes, Run
python app.pyto start the application. - For production purposes, Run
waitress-serve --listen=0.0.0.0:5000 app:appto start the application.