Hackbright Academy - Summer 2013 class assignment (WEB.md)

gistfile1.txt

Hackbright Academy - Summer 2013 class assignment
--

Instructions are here: https://github.com/chriszf/sql_lesson/blob/master/WEB.md

--
NOTES
--

Type and run in terminal >> "pip install flask"

HOWTO setup virtual environment >> http://docs.python-guide.org/en/latest/dev/virtualenvs.html

Task #1 works: http://localhost:5000/student?github=chriszf

Task #2 works: http://127.0.0.1:5000/student?github=chriszf

SELECT * from GradesView;

Charles|Ruhland|Markov|50
Charles|Ruhland|Pyglet|100
Angie|Chang|Python|50
Kate|Odell|SQL Lesson|49
Christian|Fernandez|Markov|10
Christian|Fernandez|Pyglet|2

SELECT * from Students;

Charles|Ruhland|cruhland
Angie|Chang|thisgirlangie
Kate|Odell|kateodell
Christian|Fernandez|chriszf
Bob|Barker|bobbark
Billy|Bob|billybob

SELECT * FROM GradesView JOIN Students on GradesView.first_name=Students.first_name WHERE GradesView.last_name=Students.last_name;

Charles|Ruhland|Markov|50|Charles|Ruhland|cruhland
Charles|Ruhland|Pyglet|100|Charles|Ruhland|cruhland
Angie|Chang|Python|50|Angie|Chang|thisgirlangie
Kate|Odell|SQL Lesson|49|Kate|Odell|kateodell
Christian|Fernandez|Markov|10|Christian|Fernandez|chriszf
Christian|Fernandez|Pyglet|2|Christian|Fernandez|chriszf

SELECT Students.first_name, Students.last_name, grade, github FROM GradesView JOIN Students on GradesView.first_name=Students.first_name WHERE GradesView.last_name=Students.last_name;

Charles|Ruhland|50|cruhland
Charles|Ruhland|100|cruhland
Angie|Chang|50|thisgirlangie
Kate|Odell|49|kateodell
Christian|Fernandez|10|chriszf
Christian|Fernandez|2|chriszf

Task #3 works: http://localhost:5000/students_and_grades?project=Pyglet

To active VENV in any shell:

source venv/bin/activate

To de-activate VENV in any shell:

deactivate

Task #4 complete: "You have successfully added a student to the database!"

Reminder: Cynthia says to look at Jinja documentation on how it handles Flasky things, like where to put images and how it reads HTML files out of any folder

Task #5, #6, #7, #8 completed! Making it pretty, iteratively.