Final Exam V1 - IMPROV
You are building a web application that will allow different users to complete the same story (see HTML below for examples)
The very first page displays all available stories, and once the user picks the story, he is taken to another page that lists all of the text for this story and lets user continue
Queries to use in the program
- Name the .py file with your first and last name, if you are placing your files in a folder, then there should be only one .py file and folder must be named with your name as well
- Using one of: WSGI, HTTPServer, Flask (I used WSGI) servers
- For extra 10% of the exam grade:
(5%) create a data visualization for your project using either TKINTER or HTML/public web services (ex. Google Charts). Display one full story on the canvas or any other visualization of choice. Has to use improv data
(5%) test program and handle SQL injection (submit a proof of SQL injection handled in the program - comment it) - Grade breakdown
Connection to database and database operations work correctly - 25%
Web Page is displayed as expected - 25%
Web page to server operation works correctly - 25%
Exceptions/Errors as described below are handled correctly - 15%
Code is clean, well commented and does not contain unneeded copy-pasted chunks (Python code only, I don't care for HTML) - 10%
You are building a web application that will allow different users to complete the same story (see HTML below for examples)
The very first page displays all available stories, and once the user picks the story, he is taken to another page that lists all of the text for this story and lets user continue
Queries to use in the program
- to select all existing stories: SELECT DISTINCT STORY FROM IMPROV
- to select all text for a given story: SELECT * FROM IMPROV WHERE STORY='About a girl' ORDER BY rowid
- to insert a row back into the DB: INSERT INTO IMPROV (text, story) VALUES ('But she did not know how to...', 'About a girl')
INITIAL PAGE:
SECONDARY PAGE:
IMPROV
One night only
Once upon a time
there was a Python student
She had only one night to complete
Continue the story:
Download HTML and SQLite files here:
| improv_files.zip |