Faking miniquiz sql_hitch data solutions(probably) ./sql_hitch.sql

> python sql_hitch_fake.py -u 5000 -t 50000

Creates a file user_trip.data.sql to insert the data into a Postgres database.

Use psql to create a database

psql -c 'create database hitchminiquiz;'

Setup schema

psql -d hitchminiquiz -f ./setup_schema.sql

Create fake data

pip install fake-factory
python sql_hitch_fake.py --user-count <int> --trip-count <int>

Populate db

psql -d hitchminiquiz -f ./user_trip.data.sql

These fields are currently blank:

• client_rating
• driver_rating
• estimated_eta
• actual_eta
• admin emails ([email protected])