[sqlalchemy] Problems with back_ports

2010-10-07 Thread Richard Poettler
Hi, I am trying to get my back_ports working since one day, and doesn't seem to miss something there. In my example i am trying to allow one author to have one note at maximum and one note to have at maximum one author. If one author has a note the corresponding entries should reference each

[sqlalchemy] Create a list out of multiple columns

2010-10-05 Thread Richard Poettler
Hi, I got no idea, whether this is possible with SA (version 0.6.4), but I want to map multiple columns as one list into the resulting object. I have the following code: location_table = Table('loc_location', metadata, Column('LOC_ID', Integer, primary_key=True), Column('LOC_L1',

[sqlalchemy] Transform property names for the mapping

2010-09-29 Thread Richard Poettler
Hi, I am new to SqlAlchemy and like it very much. I want to use it on a pretty acient database schema, wich has prefixed all column names with a unique prefix for that table. E.g.: address_table = Table('a_address', metadata, Column('A_ID', Integer, primary_key=True),