Using sqlalchemy.sql with a Declarative ORM

Question

The sqlalchemy.sql module seems to assume that I've created Table instances, but I've specified my ORM using the Declarative style. Is there a way to extract the table instances from the Declarative classes? using session.query() seems to have worse syntax than the sqlalchemy.sql methods do.

could you provide some sample code?

miku
– miku

2009-12-21 09:45:42 +00:00
Commented Dec 21, 2009 at 9:45 — miku
– miku, Commented Dec 21, 2009 at 9:45

Christopher Mahan · Accepted Answer · 2010-01-12 10:36:41Z

3

You can get it from __table__ attribute of your model class:

# Some code is omitted

class Model(Base):
    __tablename__ = 'models'
    id = Column(Integer, primary_key=True)

print repr(Model.__table__)

Outputs:

Table('models', MetaData(None), Column('id', Integer(), table=<models>, 
primary_key=True, nullable=False), schema=None)

edited Jan 12, 2010 at 10:36

Christopher Mahan

7,6299 gold badges55 silver badges66 bronze badges

answered Dec 21, 2009 at 15:24

Denis Otkidach

33.5k8 gold badges86 silver badges102 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Using sqlalchemy.sql with a Declarative ORM

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related