Traffic App back end completion

You are provided with:
1. A complete browser based front-end for the app that makes use of HTML, CSS and Javascript. You will not need to modify this code. Or to understand how it operates, other than how it interacts with the server.
2. A skeleton backend framework for the app written in Python that provides the core web server functionality.

You are required to:
1. Create a suitable sqlite3 database to hold all the required data.
2. Extend the skeleton code to complete the app functionality by adding code as required. Where it is expected you will extend/modify the code is indicated by the use of ‘##’ in comments. You may alter the code elsewhere if you wish.
3. Create two additional programs able to extract summarised data from the database as CSV files. Along with two support programs to allow these to be tested.