I did some restructuring today. Figured out that the best approach would be to keep all my main objects in the sps.py file.

So I deleted database.py and moved it into a Database class in the sps module. I create a Scraper object and a Database object to use. Now it’s a cleaner interface, yay.

import sps

scraper = sps.Scraper()

database = sps.Database()

report = scraper.inventory_report()

database.add_report(report)

Keep it as simple as possible, until I’m forced to bring in complexity.

Next steps is to figure out how to get the add_report (a wrapper around to_sql pandas method) method to use the already-defined schemas in models.py.

Right now, a schema is created based on the pandas dataframe, which is not ideal.