Database Cleaning Strategies

• CS322 Project
• Tech Stack: Python, Postgresql
• Dataset and ERD taken from here
• UI: Figma

Dependencies:

• python: Install
• pipenv: pip install pipenv
• postgresql: Install

Get Started:

Make a .env file like .env.example
Import Database:

• Linux: pg_restore -c -i -U <username> -d dvdrental -v "/location/to/dvdrental.tar" -W
• Windows: Import via pgadmin

pipenv shell
pipenv install
python app.py

To schedule the cron job:

• Windows: Use Task Scheduler and make a cron.bat file as described in cron.bat.example
• Linux: Use crontab