[sqlalchemy] can not us backref name twice:why?

2009-05-17 Thread robert rottermann
hi there, I am using sqlalchemy 0.5.3 with the following declaration: # membership class tblMembershiptype(Base2): __table__ = tables2[tblMembershiptype] company_members = relation( tblCompany, secondary=tables2[tblMembership], backref='membershiptyp', )

[sqlalchemy] Re: Generating INTEGER PRIMARY KEY AUTOINCREMENT column in sqlite

2009-05-17 Thread paniq303
Hello, how is the progress with this feature - how can I use it? My application strongly depends on AUTOINCREMENT being available. To explain: Without AUTOINCREMENT, a deleted primary key will be reassigned. As an example: three records are created, with ids 1, 2 and 3. Now the record with id

[sqlalchemy] Re: Generating INTEGER PRIMARY KEY AUTOINCREMENT column in sqlite

2009-05-17 Thread Michael Bayer
the correct patch would be just a slight modification of what's provided on ticket 1016, adding table.kwargs['sqlite_autoincrement'] == True to the checks provided. I would also remove all the len(pk.columns) == 1 and Integer checks since if the user is adding this flag they should know

[sqlalchemy] Re: JOIN in alchemy 0.5.3

2009-05-17 Thread Michael Bayer
On May 16, 2009, at 3:42 PM, stud200...@gmail.com wrote: I'm having some problems using join operation and I'd like to confirm if I use it properly. I do it this way(for 3 tables in which table A has keys to other tables): someMappedTableA.join(someMappedTableB, someMappedTableA.c.BID