The code in this directory builds the various data files used by the example programs. There are three build programs:

• build_temp_data_csv.py
• build_temp_data_sqlite.py
• build_author_book_publisher_sqlite.py

The build_temp_data_csv.py file builds a CSV data file (temp_data.csv) in the data directory containing temperature samples taken by students in a class. The top row contains the labels, the students name followed by a date value for each Wednesday of the week for a year.

It then creates data for each sample based on a table of temperature data, +/- 10 to make the data look variable and reasonable.

The build_temp_data_sqlite.py file builds a Sqlite database from the previously created temp_data.csv file called temp_data.db in the data directory.

The build_author_book_publisher_sqlite.py file builds a database from the data/author_book_publisher.csv file. This database contains the tables necessary to describe the data and the relationships between the data necessary for the examples.

The directory structure is set up in such a way the build programs (as well as the examples) can find the data files needed for each one.

• Activate your Python virtualenv
• cd into the build/code directory
• python build_temp_data_csv.py - builds the csv data file
• python build_temp_data_sqlite.py - builds the temperature data from the csv file
• python build_author_book_publisher_sqlite.py - builds the author_book_publisher.db database file