RE: [sqlalchemy] Complex foreign key constraint

2011-12-06 Thread Jackson, Cameron
o: sqlalchemy@googlegroups.com<mailto:sqlalchemy@googlegroups.com> Subject: RE: [sqlalchemy] Complex foreign key constraint Thanks Mike. Might put this on the back-burner for now, and I'll look into it again when I get the time. Cheers. Cameron Jackson Engineering Intern Air Operations Th

Re: [sqlalchemy] Complex foreign key constraint

2011-12-06 Thread Michael Bayer
cameron.jack...@thalesgroup.com.au | www.thalesgroup.com.au > From: sqlalchemy@googlegroups.com [mailto:sqlalchemy@googlegroups.com] On > Behalf Of Jackson, Cameron > Sent: Tuesday, 6 December 2011 1:29 PM > To: sqlalchemy@googlegroups.com > Subject: RE: [sqlalchemy] Complex foreign

RE: [sqlalchemy] Complex foreign key constraint

2011-12-05 Thread Jackson, Cameron
p.com.au> | www.thalesgroup.com.au<http://www.thalesgroup.com.au> From: sqlalchemy@googlegroups.com [mailto:sqlalchemy@googlegroups.com] On Behalf Of Jackson, Cameron Sent: Tuesday, 6 December 2011 1:29 PM To: sqlalchemy@googlegroups.com Subject: RE: [sqlalchemy] Complex foreign key constr

RE: [sqlalchemy] Complex foreign key constraint

2011-12-05 Thread Jackson, Cameron
r 2011 1:13 PM To: sqlalchemy@googlegroups.com Subject: Re: [sqlalchemy] Complex foreign key constraint On Dec 5, 2011, at 7:40 PM, Jackson, Cameron wrote: I have two tables, SystemVariables and VariableOptions. SystemVariables is self-explanatory, and VariableOptions contains all of the possible value

Re: [sqlalchemy] Complex foreign key constraint

2011-12-05 Thread Michael Bayer
On Dec 5, 2011, at 7:40 PM, Jackson, Cameron wrote: > I have two tables, SystemVariables and VariableOptions. SystemVariables is > self-explanatory, and VariableOptions contains all of the possible values for > all of the variables. > > VariableOptions has a foreign key, variable_id, which st

[sqlalchemy] Complex foreign key constraint

2011-12-05 Thread Jackson, Cameron
I have two tables, SystemVariables and VariableOptions. SystemVariables is self-explanatory, and VariableOptions contains all of the possible values for all of the variables. VariableOptions has a foreign key, variable_id, which states which variable it is an option for. SystemVariables has a f