CUNYFirst/RateMyProfessors Hybrid
A project done in SQL, HTML, CSS, and Node.JS


==========How to get this project to work==========

1) Make sure your terminal is in the same directory as this readme.txt file.

2) Open mysql on your terminal and run 'source db.sql;', 'source procedure.sql;', and 'source trigger.sql;'

3) Open "app.js" in your preferred text editor. On lines 13-18, edit the code to the information you use to login to your personal mysql database. You probably only need to change the password as everything else should be correct.

4) Make sure you have "Node.JS" installed. Execute in the terminal "node app.js"

5) If you connected the database correctly, the terminal should say "Connected" and not "Error connecting to database" If you see "Error connecting to database" you didn't properly edit lines 13-18 in "app.js" Go to the next step once you're successfully "Connected"

6) Go to your internet browser and type in the address bar: "127.0.0.1:8080" or "localhost:8080" which is your computers local host on port 8080. If everything went okay, our website should load onto this page.

7) Play around with the website! Be sure to login. There's a custom Username and password you can use to login. Username: JCisAwesome, Password: SQLGod. If you want to log in as someone else, you can find the data in the users table. Mess around with the search feature, and click around on the results page. It's perfectly normal to have the search page refresh if you put an invalid input as it's programmed to do so (the terminal leaves a message for an incorrect input). To go back a page, you can use your browsers "Go Back One Page" button. There are many new additions this time to mess around with so have fun!
==================================================

============= Updates ==============
The database is in 3NF along with an implementation of triggers and procedures described in the next sections. Added a user login to the website, and you cannot do anything unless you're logged in. You can still search for classes the same way as before. You are able to 'enroll' into a course by clicking 'Add' on the results page. It will not let you enroll if the class has 0 seats left though. When you are enrolled, you are able to see it on your enrolled classes page, which can been seen on the brand new top navigation bar. You can drop the class at will as well. On each specific class details page (when you click on a search result), you are able to view everything like before but this time you can add a review for that professor and everything will update accordingly due to the triggers.
==============================================

=================== Triggers ===================

1) before_insert_enrolled: this trigger checks if the course you're trying to enroll into has at least a spot available, if so, you can enroll. Else, you can't.

2) after_insert_enrolled: this trigger decreases the seats available for a class by 1 after someone enrolls in it.

3) after_delete_enrolled: after someone drops the course, the seat count will increase by 1.

===============================================


=============== Stored Procedures ===============

1) rateProf: takes professors_id and a new rating as the input, then it will average out the professor's rating to account for the new rating.

2) diffProf: does the same thing as rateProf, but for the difficulty of the professor.

3) wtaProf: does the same thing as rateProf and diffProf, but for the would take again attribute of the professor.

=================================================