[sqlalchemy] Relationship between objects which inherit the same parent

2011-05-17 Thread roderick
Hi, I have a problem with relationships between objects which inherit the same parent: class Person(DeclarativeBase): __tablename__ = 'person' id = Column(Integer, primary_key=True) name = Column(Unicode(100), nullable=False def __init__(self, name): self.name = name

Re: [sqlalchemy] select table from other schema

2011-05-17 Thread Michael Bayer
to allow proper quoting of names the schema portion of the name is separate from the name of the table: class AttributeConversion(Base): __tablename__ = 'attribute_conversion' __table_args__ = {'schema':'test'} On May 16, 2011, at 9:02 AM, Ivan wrote: I have table from schema test

Re: [sqlalchemy] Queue pool overflow error.

2011-05-17 Thread Michael Bayer
On May 16, 2011, at 2:29 AM, abhishek wrote: Dear group, I am getting Queue pool overflow error very frequently in one of the websites in production. The production server is running two cherrypy sites (one for mobile access and another for PC access) targeting same database. My query

Re: [sqlalchemy] Relationship between objects which inherit the same parent

2011-05-17 Thread Michael Bayer
On May 17, 2011, at 4:50 AM, roderick wrote: Hi, I have a problem with relationships between objects which inherit the same parent: class Person(DeclarativeBase): __tablename__ = 'person' id = Column(Integer, primary_key=True) name = Column(Unicode(100), nullable=False

[sqlalchemy] problem with nested column_property's label in subquery

2011-05-17 Thread Yap Sok Ann
With the following code: # from sqlalchemy.engine import create_engine from sqlalchemy.ext.declarative import declarative_base from sqlalchemy.orm import column_property, relation from sqlalchemy.orm import scoped_session, sessionmaker from

Re: [sqlalchemy] problem with nested column_property's label in subquery

2011-05-17 Thread Michael Bayer
On May 18, 2011, at 12:33 AM, Yap Sok Ann wrote: author_name = column_property( select( [Author.name], author_id == Author.id, ).label('author_name') ) Base.metadata.create_all(engine) Session.query(Book).order_by('id').all()

Re: [sqlalchemy] problem with nested column_property's label in subquery

2011-05-17 Thread Michael Bayer
On May 18, 2011, at 1:13 AM, Michael Bayer wrote: now that is interesting, and its a bug, and why its unusual is because you've got a column_property() deriving from another column_property(). But the bug is interestingly a very simple one inside the select() construct. I still