[sqlalchemy] Many-to-many secondaryjoin with filter

2012-09-06 Thread Kuba Dolecki
Hello, I have been struggling for a few hours with the following issue. First, the models: stack_resources = db.Table('stack_resources', db.Column('stack_id', db.Integer, db.ForeignKey('stack.id')), db.Column('resource_id', db.Integer, db.ForeignKey('resource.id')) ) class

[sqlalchemy] Re: Many-to-many secondaryjoin with filter

2012-09-06 Thread Kuba Dolecki
Oh, and Stack has __tablename__ = stack and Resource has __tablename__ = resource just to reduce any confusion. On Thursday, September 6, 2012 6:55:22 PM UTC-4, Kuba Dolecki wrote: Hello, I have been struggling for a few hours with the following issue. First, the models: stack_resources

[sqlalchemy] Single table inheritance - column not mapped

2012-08-15 Thread Kuba Dolecki
Hi, We've used joined table inheritance up to this point, but performance issues are making us explore single table inheritance. I'm running into a problem with mapper configuration. Using SQLAlchemy 0.7.8, Flask-SQLAlchemy 0.16, and Flask 0.8. Here is the inheritance: class

Re: [sqlalchemy] Single table inheritance - column not mapped

2012-08-15 Thread Kuba Dolecki
, Michael Bayer wrote: On Aug 15, 2012, at 10:45 AM, Kuba Dolecki wrote: Hi, We've used joined table inheritance up to this point, but performance issues are making us explore single table inheritance. I'm running into a problem with mapper configuration. Using SQLAlchemy 0.7.8, Flask-SQLAlchemy

Re: [sqlalchemy] Single table inheritance - column not mapped

2012-08-15 Thread Kuba Dolecki
explanatory according to your input. On Wednesday, August 15, 2012 12:22:59 PM UTC-4, Michael Bayer wrote: On Aug 15, 2012, at 11:41 AM, Kuba Dolecki wrote: You responded! Woot. Thanks. Here's some additional info: 1. __tablename__ is generated automatically based on the class name. Flask