Skip to content

MySQL database created to manage bus drivers, buses, and routes. The simple Python interface allows users to quickly interact with the database hosted either locally or on the cloud.

License

Notifications You must be signed in to change notification settings

RyanRussell00/Complete-Bus-System

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

Complete-Bus-System

Created by Team MS Excel: Ryan Russell, Illarion Eremenko, Phillip Ovanesyan, Mitchell Dang

Overview

The Complete Bus System is connected and deployed to Amazon Web Services (AWS). To start the program just run the UserInterface.py file using the command: python3 UserInterface.py

User Interface (UI)

Requirements

Running the UI

  1. Navigate to the CBS folder (Complete-Bus-System/CBS-Programs/venv/CBS)
  2. Open a terminal in that folder and type: python3 UserInterface.py

Automated Testing Program

Requirements

Running the Automated Tests

  1. Navigate to the Testing folder (Complete-Bus-System/CBS-Programs/venv/Testing/)
  2. Open a terminal in that folder and type: python3 tests.py
  3. Modify the tests in the directory: Complete-Bus-System/CBS-Programs/auto-test-files/

.Tests Files

  • Files containing the queries to be executed must end in the extension: .Tests
  • All statements must end with a semicolon ';'
  • Multi-line statements are allowed but the line must not break in the middle of words.
  • ONLY USE # or -- FOR COMMENTS.
  • The query will expect the output at the same position in the expected file.
  • For example: The 3rd query in this file will expect the 3rd line in the 'Expected' file to be its output.

.Expected Files

  • Expected outputs must end in .Expected
  • Type output EXACTLY as you'd see it on output. No semicolons, no quotes (unless expected), etc.
  • ONLY USE # or -- FOR COMMENTS.
  • The queries will expect the output at the same position in the expected file. (line numbers dont matter)
  • For example: The 3rd query in the queries file will expect the 3rd line in this file to be its output.

FORMATTING FOR EXPECTED

  • DO NOT END WITH SEMICOLON
  • If expecting multiple columns: Use a comma to seperate values, keep expected result on 1 single line
  • Strings: use a single quote around the 'string'
  • DateTime: If single digit day/month DO NOT put 0 in front.
  • DateTime: USE THIS FORMAT EXACTLY: datetime.date(YYYY, (M)M, (D)D)
  • Do not put 0 in front of single digit Month or Day
  • For NULL values write: None
  • Parentheses around expected output is optional

About

MySQL database created to manage bus drivers, buses, and routes. The simple Python interface allows users to quickly interact with the database hosted either locally or on the cloud.

Resources

License

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Contributors 4

  •  
  •  
  •  
  •