[sqlalchemy] Difference between this SQL query and this sqlalchemy one?

2014-08-02 Thread Elliot
I am using sqlalchemy on a database of Google Transit Feed data. The models are from pygtfs: https://github.com/jarondl/pygtfs/blob/master/pygtfs/gtfs_entities.py Basically, StopTime is related both to Stop and Trip. I want all of the stoptimes of all of the trips which have one StopTime

Re: [sqlalchemy] Difference between this SQL query and this sqlalchemy one?

2014-08-02 Thread Ryan Kelly
On Sat, Aug 2, 2014 at 9:11 PM, Elliot offonoffoffon...@gmail.com wrote: I am using sqlalchemy on a database of Google Transit Feed data. The models are from pygtfs: https://github.com/jarondl/pygtfs/blob/master/pygtfs/gtfs_entities.py Basically, StopTime is related both to Stop and Trip. I

Re: [sqlalchemy] Specifying a Row Check Constraint and Compound Primary Keys

2014-08-02 Thread Michael Bayer
On Aug 1, 2014, at 6:57 AM, Wolfgang Keller felip...@gmx.net wrote: Celko's books are great but surrogate integer PKs are an unavoidable practice within relational databases, they are a requirement of most DBAs I've dealt with Those guys don't even have a faint clue how clueless they are.

Re: [sqlalchemy] Difference between this SQL query and this sqlalchemy one?

2014-08-02 Thread ...
Ha, I needed to get st2 instead of the filtered stoptimes. Works great now. -- You received this message because you are subscribed to the Google Groups sqlalchemy group. To unsubscribe from this group and stop receiving emails from it, send an email to