Removed references to c_id in get_next_customer. Instead, query selects customers with blank value in 'called' column. (in load_data, '00/00/00' code not working, so db has blank vals for non-called customers
IT WORKS. Goes customer by customer, starting with customers who have not been called. Key was to look for customers WHERE called = ''
Drop orders table, recreate table with load_data adding in num_watermelons and num_othermelons
Added function to create an orders view to pre-select top orders (20 melons or more)
Move make_top_customers_view into load_data.py so it will only run once.
Commented out DROP VIEW code (errored if view did not exist yet). Rearranged order to create both customers and orders tables before view.
Removed references to top_customers view in call.py, replaced it with LEFT JOIN inside get_next_cus query. Commented out make_top_customers_view in load_data.
Added attr to customer object with number of melons purchased, to double-check that customer meets standards. WORKS.