Few small changes to sql scripts, including to make urls a text[] instead of a text column. Added sql connection code to rhetoracle.py so that it returns json results for /q1.
Ajax-ified the Q1 form's input and made it so that the chart updates using data from the DB. Q1's Flask view uses a hardcoded sql query at the moment..
Gave all 4 of our visualizations their own event handlers in drawVisualization.js. Only the first works. The other three need some their Python views fleshed out.
Q1 form now informs the query for the Q1 visualization. Q2 in progress.
fixed rhetoracle.py's view functions for q1 and q2, which both now work. Added a .sql file with an example query for Q2 for reference.
Intermediate check-in, switching to some new tasks related to our new topics.
Updated existing sql queries to reflect the data we want to analysis (as of this morning). Update q1 visualization to answer the first question. The Go button basically refreshes the chart against the DB. The other three graphs are still broken and are placeholders only. The query string in rhetoracle.py is still hard coded.
Question 1 and 2 visualizations both work when pushing their go buttons. Second row of visualiztions hidden until we figure out what we want those to be. Added sql query for second question as well.