You will have to have docker installed in your computer to start up application.
- Python
- Flask
- Postgres (PSQL)
- Docker
Most SQL statements, queries and/or transactions for this project can be found in folder sql_.
- Open project folder using terminal.
- Execute:
docker-compose up --build - Open a browser and go into:
- localhost:8001
- 127.0.0.1:8001
By default, biggest data set from demo_data is added. If smaller set of demo data wanted, then uncomment SOURCE_DATA: 'demo_data' line in docker-compose.yml.
For data persistence on this project, after executing docker-compose up --build a file dbs will be created on the inmediate up level from the directory where command was executed.
On a separate terminal, you can run: docker exec -it jaunty_jalopies_db bash -c "psql postgres postgres"
Go into docker-compose.yml and uncomment line with environment variable RESET_DB. Then stand up your containers with docker-compose up.
If you see PostgreSQL Database directory appears to contain a database; Skipping initialization when trying to recreate a new volume,
execute this command: docker-compose down --volumes and docker-compose up --build afterwards.
Go into docker-compose.yml and uncomment line command: postgres -c log_statement=all.
There is information about it here: https://www.psycopg.org/docs/sql.html#module-usage.
Try login in with this user: johnDoe'; DROP TABLE ServiceWriter; SELECT PrivilegedUser WHERE username='peter
VIN Numbers were gotten from here: https://vingenerator.org/brand
For the owner role to be able to take any role, at the time of creating an owner it is necessary to add her/him to all existing user tables.
Design is a constant process, you change your design while you code and test. During phase3 we changed schema from phase2 of project and the new schema
is located in sql_/team121_p3_schema.sql. To see changes, do a diff against
archive/Phase_2/team121_p2_schema.sql.
The relation for the previous schema is located on: archive/Phase_2/team121_p2_eer2rel.pdf, while the relation for the new schema is located on: docs/team121_p3_updatedEerRel.pdf.
| Vehicle Type | SUV | Convertible | Car | Van | Truck |
|---|---|---|---|---|---|
| VIN Number | WA19FAFL8DA202124 | 1GCFG15X471203088 | JT2AL22G0C4449167 | WDBSK7BA6BF161906 | 1N6BA0CC0AN303535 |
| Description | 2021 Audi Q7 | 2021 Chevrolet Camaro | 2022 Toyota Camry | 2022 Mercedes Benz Metris | 2021 Nissan Titan XD |
| Invoice Price | 54950 | 25000 | 25295 | 33920 | 45430 |
| Model Name | Q7 | Camaro | Camry | Metris | Titan XD |
| Model Year | 2021 | 2021 | 2022 | 2022 | 2021 |
| Manufacturer | Audi | Chevrolet | Toyota | Mercedes Benz | Nissan |
| Color(s) | Blue | White,Black | Grey | Black | Red |
| # Cupholders | 6 | ||||
| Drivetrain Type | FWD | ||||
| Back Seat Count | 2 | ||||
| Roof Type | detachable hardtop | ||||
| # Doors | 4 | ||||
| Has Driver Side Backdoor | No | ||||
| Cargo Capacity | 2400 | ||||
| Cargo Cover Type | high impact plastic lid | ||||
| # Rear Axles | 2 |
| Customer Type | Individual | Business |
|---|---|---|
| ID | JD93-647-829-102-9 | 123-45-678 |
| Address | 2021 Example Rd. | 2021 Georgia Tech St. |
| Phone Number | +1(813)763-9808 | +1(305)987-1023 |
| Email Address | [email protected] | [email protected] |
| Firstname | John | |
| Lastname | Doe | |
| Business Name | Example One | |
| Primary Contact Name | Steve Jovs | |
| Primary Contact Title | Employee 0 |
| Username | Type | Password |
|---|---|---|
| ding | Service Writer | staycurious |
| om | Manager | beproductive |
| yinan | Sales Person | simplyawesome |
| leo | Sales Person | markthisday |
| rolan | Owner | imtheceo |
| luis | Inventory Clerk | wh4t3v3r |
| Username | Type | Password |
|---|---|---|
| roland | Owner | roland |
| user01 | Sales Person | pass01 |
| user02 | Manager | pass02 |
| user03 | Inventory Clerk | pass03 |
| user12 | Service Writer | pass12 |
- Ding Yuan email: [email protected]
- Om Sachdev email: [email protected]
- Yinan Yang email: [email protected]
- Luis Humberto Orozco Cabrera email: [email protected]