Dear All,
I am not being able to figure out how relate to a table having composite
primary key. To illustrate my problem, I am giving below a schema. Any
guidence on how to code this in SQLAlchemy (and in ActiveMapper, if
possible) is more than appreciable. I would prefer autoloding Tables, rather
that defining all columns in the code.
Employees
(
company_id PK,
employee_no PK,
name
)
Dependents
(
company_id PK,
employee_no PK,
dependent_no PK,
name,
FOREIGN KEY (company_id, employee_no) REFERRING Employees
)
Thanks a lot
Sanjay
-------------------------------------------------------------------------
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
