- Install Python 3
- Install Faker
pip3 install Faker
An initialized database can be found in a.db. If you would like to re-initialize the database, there are two methods.
Execute the init.py script:
python3 init.py
This creates tables and initializes them with dummy data. The new database is stored in a.db. This is the recommended method because it is extremely fast.
If method 1 doesn't work, you can create a new database and execute these SQL scripts:
- queries/create.sql (create tables)
- queries/init.sql (insert data, may take a long time to run)
To execute queries from the CPs as well as various insert/delete queries, run
main.py. Note that this will call init.py
at the start of the
script:
python3 main.py
If method 1 doesn't work, you can manually execute these SQL scripts:
- queries/cp.sql (various queries from CPs)
- queries/insert.sql (inserting items, orders, sellers, and buyers)
- queries/delete.sql (deleting items, orders, sellers, and buyers)