July 18, 2017
Still having some trouble wrapping my head around sqlalchemy’s orm, putting things into postgres and then querying it. The flow isn’t clear to me yet.
# Automaps the database here. d = sps.Database() # Tables are available in the classes property Inventory = d.base.classes.inventory # Creates a list of sqlalchemy object with all the rows (that's how my query_all method is implemented) data = d.query_all(Inventory) # I can access each row with this. first_color = data.product first_color > u'Alaska Cream 3cm'
This should work for now. Took me a good 8 hours to understand this. SQLalchemy is hard to grok for me.