Re: [Sqlalchemy-users] Multi-column foreign keys

2006-06-14 Thread Arnar Birgisson
Ok, thanks! Arnar On 6/13/06, Michael Bayer <[EMAIL PROTECTED]> wrote: > you can define them for the purposes of querying and mapping just as > separate ForeignKey objects (i.e ForeignKey(customer_id) on > customer_id, ForeignKey(username) on username), and it will figure > out all the appropriat

Re: [Sqlalchemy-users] Multi-column foreign keys

2006-06-13 Thread Michael Bayer
you can define them for the purposes of querying and mapping just as separate ForeignKey objects (i.e ForeignKey(customer_id) on customer_id, ForeignKey(username) on username), and it will figure out all the appropriate join conditions connected by AND. for the purposes of having the metadat

[Sqlalchemy-users] Multi-column foreign keys

2006-06-13 Thread Arnar Birgisson
Hi there.. Is is it possible to describe multi-column foreign keys with SA metadata? I.e. create table customers ( customer_id string, primary key (customer_id) ) create table users ( customer_id string, username string, primary key (customer_id, username), foreign key (customer_id) references

[Sqlalchemy-users] Multi-column foreign keys

2006-02-24 Thread Robert Leftwich
SQLAlchemy supports multi-column primary keys, but doesn't support their 'mirror image' of multi-column foreign keys. I was just about to write up a ticket, but thought I would check to make sure I hadn't missed anything (esp. in light of the large amount of recent activity!). Adding support f