Mike, the subquery() method in the ORM may be slightly misleading to some people coming from SQL. For me a sub-query is a select statement contained in a where claus and a derived table is select statement contained in a from clause...
Good talk, covers the fundamentals. Unfortunately it only covers CR but not UD. Updating tables that have established relationships through backref is unintuitive, and something I've been struggling with for a while. I was hoping this talk would go into more depth on update operations but it doesn't cover updates hardly at all.
skip to 11:30 for start of preso
second half starts at 1:57:58
Here are the 2013 slides: speakerdeck.com/zzzeek/introduction-to-sqlalchemy-pycon-2013 The sliderepl install instructions are on the third slide
Great video, though am used django orm, sqlalchemy provides both low level and high level tools, really nice!
advanced orm starts at 2:56:00
The code starts at 24:50
Mike, the subquery() method in the ORM may be slightly misleading to some people coming from SQL. For me a sub-query is a select statement contained in a where claus and a derived table is select statement contained in a from clause...
Good talk, covers the fundamentals. Unfortunately it only covers CR but not UD. Updating tables that have established relationships through backref is unintuitive, and something I've been struggling with for a while. I was hoping this talk would go into more depth on update operations but it doesn't cover updates hardly at all.
Can anyone else please confirm this?
Can anyone else please confirm this?
Can anyone else please confirm this?
Awesome! Thanks