You will be familiar with the basics of Flask from Chapter 9, Building a Web Server. Once again, we will be using this framework to create a website that can interact with a database.
You can always refer to the Flask documentation site if you find a feature you wish to learn more about: http://flask.pocoo.org/docs/0.10/
Our project will involve creating a number of web forms that can update our SQLite database with information on what items are stocked in our inventory.
First, we need to create a database to store our inventory data in.
In our previous SQL example, we logged in to SQLite to create the database. We can in fact write our SQL in a separate file and dump this into SQLite. This makes managing our source code a lot easier, and we can also re-run it against an empty database whenever we wish.
So we will therefore take our existing data model from Chapter 9, Building a Web Server and convert it into an SQL file. We will also include the...