Gloria W wrote: > Hi all, > I am trying to use the session syntax to bind to an existing table, > but I am apparently missing something. I want my session to be bound > to this: > > my_table = sqlalchemy.Table('my_table', meta, autoload=True, > autoload_with=engine) > > and if I use the same engine here: > > session = sqlalchemy.orm.sessionmaker(bind=engine, autoflush=True, > transactional=True) > > isn't the session bound to the table? > > But when I run this: > > all_records = session.query(my_table).all() > > I get this error: > > Traceback (most recent call last): >[..zip...[ > AttributeError: 'PGCompiler' object has no attribute 'mapped_table' > > The docs I've seen only show session bindings using Table classes, so > please point me to a good example or give me the quick hint.
The ORM maps your Python classes to tables rather than working with tables directly. You're missing a step in the middle like: class MyClass(object): def my_stuff(self): self.yadayada sqlalchemy.orm.mapper(MyClass, my_table) all_records = session.query(MyClass).all() The ORM tutorial lays out the steps in more detail: http://www.sqlalchemy.org/docs/04/ormtutorial.html --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to sqlalchemy@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en -~----------~----~----~----~------~----~------~--~---