CS 204: Software Design
Web application, stage 3: data from the database
For this phase:
- Put all of your files in a directory called webapp3, and call your main page
index.py instead of webapp.py or whatever it's called now.
- Get your data into a MySQL database.
- Modify your Python code to use MySQLdb to extract data from the database. Assuming you
have a DataSource class designed as described in last week's assignment, you should be
able to put all the MySQLdb code in DataSource.
- Complete at least two of the highest priority features you listed in your original
project description.
Here is a sample Python script using MySQLdb. There are also
some MySQLdb links in the navigation panel on the course page,
Here is the script I used to convert from CSV to MySQL statements for my city data.
Hand in by putting files in webapp3, and loading your data into your MySQL database on cs-research1.