CS 225 Proj

version 0.03 test to get some of the front end working with a local SQL

• Bootstrap
• Leaflet
• jquery
• MySQL workbench
• npm
• NodeJS

Presentation

YouTube Presentation

Instructions

1. Install npm,node and nodemon
2. Install MySQL workbench
3. In MySQL workbench create a new sql connection called agops with the password password
4. (Note) if you change the name/password, edit them in sqltest.js file
5. In MySQL workbench, click schemas>agops>Tables>Table Data Import Wizard and import the files in the csvfiles directory of this github branch. The tables the create should follow the same name as the title of the file. Else the API might not work.
6. Run nodemon ./sqltest.js or node ./sqltest.js and in a browser go to localhost:3000 and the webpage should be there.

Currently working is submitting orders. There is no implementation of the completion of orders on the document page.

Students

• Abenezer Wudenhe
• Joel Borja
• Nicholas Kory
• Zhuocheng Shang

Sources

• Super Helpful video on getting started with node
• SQL & Java Script
• Javascript creating HTML Elements
• Boostrap list group element class
• Using CSV & MySQL Work Bench
• Date & Time w/ Bootstrap
• SQL date & time formats
• Bootstrap list styles class
• Boostrap grid system