Context 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.

Querying ¶

# 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[0].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.