Re: [sqlalchemy] Set up a composite key using a foreign key and another column with Python

2017-08-23 Thread Joshua Peppeman
That worked! I'd still like to know about orderinglist though. Am I going to run into problems if I end up with a lot of data? -- SQLAlchemy - The Python SQL Toolkit and Object Relational Mapper http://www.sqlalchemy.org/ To post example code, please provide an MCVE: Minimal, Complete, and V

Re: [sqlalchemy] Set up a composite key using a foreign key and another column with Python

2017-08-23 Thread Joshua Peppeman
Hey Mike, thanks for getting back with me. I have to go to work soon but I'll try that out as soon as possible. Can you elaborate a little on what you mean by getting tripped up if I push it too far? On Tuesday, August 22, 2017 at 9:26:42 PM UTC-5, Mike Bayer wrote: > > On Tue, Aug 22, 2017 at 9

Re: [sqlalchemy] Set up a composite key using a foreign key and another column with Python

2017-08-22 Thread Mike Bayer
On Tue, Aug 22, 2017 at 9:42 PM, Joshua Peppeman wrote: > Hello, > > I asked this question on Reddit and StackOverflow without any luck getting > an answer. Here is the StackOverflow question. I'll paste it below again. > > > I have two tables set up in Python with sqlalchemy using mySQL. They loo

[sqlalchemy] Set up a composite key using a foreign key and another column with Python

2017-08-22 Thread Joshua Peppeman
Hello, I asked this question on Reddit and StackOverflow without any luck getting an answer. Here is the StackOverflow question . I'll paste it below again. I have t