[sqlalchemy] Re: Single table polymorphic scheme with different column types

2010-08-06 Thread anthony
Sorry for the double post but I forgot to ask the question! Is there a way to do what I want and if not, is there something I should do instead? Thanks again, Anthony On Aug 5, 8:06 pm, anthony anth...@yelp.com wrote: Hi, First message here in the sqlalchemy mailing list. I was working with

Re: [sqlalchemy] Single table polymorphic scheme with different column types

2010-08-06 Thread Michael Bayer
On Aug 5, 2010, at 11:06 PM, anthony wrote: Hi, First message here in the sqlalchemy mailing list. I was working with a previous version of sqlalchemy (0.6beta1) and while updating sqlalchemy, ran into a problem with polymorphic classes. Basically we're using a single table inheritance

[sqlalchemy] Opened ticket 1866 to provide SA support for APSW driver for SQLite

2010-08-06 Thread phrrn...@googlemail.com
I would like to use the backup API from SA (as part of our testing infrastructure for setting up :memory: databases from a known, persisted state). Also, UDFs (both scalar and aggregate) and virtual tables are very nicely suported by APSW. pjjH http://www.sqlalchemy.org/trac/ticket/1866

[sqlalchemy] Error creating backref

2010-08-06 Thread Michael Hipp
Can someone help me figure out why I keep getting the error below. Here are my 3 models. It's a simple many-one on banks-dealer and reps-dealer. class Dealer(Base): __tablename__ = 'dealers' id_ = Column(Integer, primary_key=True) reps = relationship('Rep', order_by='Rep.lname',