user interface
database schema
System Structure
input user's information
dps website
terminal
database schema1
availability schedule for driving test
email notification

Our program is based on Ruby on Rails, developed by Python, web interface is produced by Bootstrap. The main purpose of our project is to build a notification system, when the driving test appointment of a specific DPS is available to be scheduled, our system will send a notification email to customer’s mailbox. In the website, customer could type in their desired test time and place (with further development of the program). Then these information will be transmit to our database and stored in it until the customer has made the appointment successfully. The main idea of our project is to help new drivers to schedule a driving test as soon as possible, especially when some city (like Bryan of Texas) has too many people want to have a driving test, but only can get an available one more than three months later. However part of the scheduled appointments will be released when some others no longer want them, but no one know that of course no one make use of them. We think that is a waste of government resource, to avoid these things happening, we designed the notification system, which could not only help our customers but also make the government’s driving test more efficient.

HackUTD : Find Available Driving Test Appointment

Required Environment

Firefox Browser
Ruby on Rails
Ruby(4.2.2)
Python

How to setup the App

downlowad the code

Open the terminal:

Clone the repo:

$git clone https://github.com/njuyangyang/sample_app-1.git ~/sample_app

Change directory:

$cd ~/sample_app

Set the front-end environment

Installing Rails with a specific version number:

gem install rails -v 4.2.2

install the gems using:

$bundle install —-without production

migrate the database:

$ bundle exec rake db:migrate

run the local web server:

$rails s

terminal

Now the application should be available on the local server:

http://localhost:3000

UI1

Click the button:Get Started Now!

UI2

Enter Your Information: Your name, Your email, and the expected date you want to take the driving license test(According to the website of DPS, you can only input the date 90 days from now) And then click create

Start the back-end

Change directory:

$cd ~/sample_app/db

execute the controller.py:

$python controller.py

Top structure of Database

DateBase

DB1

Availibility Table

DB2

Tips

warnning

You will receive a notification only if your expecting date is available. For test purpose, You should check the available date in DPS website or our datebase before you type in your information.
so far, this application is used for Byran DPS only.

DPS