Final Exam V5 - PROGRAMMING TEST
You are building a web application that asks the user questions and stores answers to the database
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
- Download the database and supporting files below
- 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 number of questions vs number of answers (2 bars) visualization on canvas, or any other visualization of your choice
(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 asks the user questions and stores answers to the database
Queries to use in the program
- to retrieve questions: SELECT rowid, shortdescription FROM programmingtest
- to retrieve questions details: SELECT ShortDescription, LongDescription FROM PRogrammingTest WHERE rowid=2
- to save an answer: UPDATE programmingtest SET solution = 'user answer' WHERE rowid=1
INITIAL PAGE:
PROGRAMMING TEST
Click on one of the questions below:
How to exist Python shell?
Can you explicitly type a variable in Python?
How does garbage collection in Python work?
Generator Function
SECONDARY PAGE:
SECONDARY PAGE:
PROGRAMMING TEST
How to exist Python shell?
How do you exit Python Shell?
Download HTML and SQLite files here:
programming_test.zip |