OK, you can see what ive done so far in rev 1709, over at:
http://www.sqlalchemy.org/trac/changeset/1709
unit tests work for postgres, sqlite, and mysql so far, including
composite foreign key reflection. oracle/mssql/firebird probably work
at least as good as they used to.
for example, you can go totally explicit like this:
employees = Table('employees', metadata,
Column('id', Integer),
Column('soc', String(40)),
Column('name', String(30)),
PrimaryKeyConstraint('id', 'soc')
)
elements = Table('elements', metadata,
Column('id', Integer),
Column('stuff', String(30)),
Column('emp_id', Integer),
Column('emp_soc', String(40)),
PrimaryKeyConstraint('id'),
ForeignKeyConstraint(['emp_id', 'emp_soc'],
['employees.id', 'employees.soc'])
)
-------------------------------------------------------------------------
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job easier
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
_______________________________________________
Sqlalchemy-users mailing list
Sqlalchemy-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/sqlalchemy-users
