Downloaded files from skills3 to start first trial
Create meloninfo.db, add tables in sqlite3 for orders and customers
Populated db customers table using function in python. Had to remove 'id' from query string for itto work.
Move INSERT query functions to separate python script for loading data
In data_load.py, added line to readline and get headers (avoid data type errors). Refine columns into which to insert data. Add .decode('utf-8') to orders function.
Added CREATE TABLE to functions that create customers and orders tables in load_data, containing all info needed to recreate tables as needed
Using customer id to get customer record out of db (using hardcoded example to start with)
Added to get_next_customer - set properties of customer instance with data from returned row
IT WORKS... changed update_customer_called to add value to customer.called (also now included in Customer class). Added date module to get today's date.