My User table stores 'zipcode' as a key in an hstore called 'profile.' I'd
like to join users with a table I just created called zipcodes. What is
the best way to do this?
Thanks!
class User(PsqlBase):
__tablename__ = "users"
__table_args__ = {'autoload': True, 'autoload_with': psql.engine,
'extend_existing': True}
class Zipcode(PsqlBase):
__tablename__ = "zipcodes"
zipcode = Column(String(5), primary_key=True)
lat = Column(Float(8))
lon = Column(Float(8))
median_income = Column(Float(8))
--
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/sqlalchemy.
For more options, visit https://groups.google.com/d/optout.
