db.py ======== The db module handles database connectivity. The application usese MySQL for data storage, and the *mysql.connector* library to interface between Python and MySQL. Examples from the documentation are located here_. .. _here: https://dev.mysql.com/doc/connector-python/en/connector-python-example-cursor-select.html The basic flow: - Connect to the database - Create a cursor from the connection - Define SQL statement - Execute the query (response is stored in the cursor) - Optionally commit the transaction (if it is an insert or update) - Close the connection - Return the results .. automodule:: db :members: :undoc-members: