GET /api/v2/video/246
HTTP 200 OK Vary: Accept Content-Type: text/html; charset=utf-8 Allow: GET, PUT, PATCH, HEAD, OPTIONS
{ "category": "PyCon US 2010", "language": "English", "slug": "pycon-2010-advanced-sql-alchemy", "speakers": [ "Michael Bayer" ], "tags": [ "advanced", "pycon", "pycon2010", "sqlalchemy", "tutorial" ], "id": 246, "state": 1, "title": "PyCon 2010:Advanced SQL Alchemy", "summary": "", "description": "Advanced SQLAlchemy\n\nPresented by Michael Bayer\n\nSQLAlchemy is the premier SQL toolkit for Python. SQLAlchemy exposes the full\npower of SQL while remaining easy to use for the basics, and is flexible\nenough to work with existing database schemas as well as fresh designs.\nSQLAlchemy is used in production by leading Python web frameworks Pylons and\nTurboGears as well as many other web and non-web developers.\n\nThis tutorial discusses current data mapping techniques, advanced Query\ntechniques, Session/transaction usage, and maximizing schema usage with\nSQLAlchemy's event model.\n\nIntended Audience\n\nPython experience: intermediate. You should already have some hands-on\nexperience with Python and be comfortable reading modern Python code.\n\nSQL experience: intermediate. We will use subselects and outer joins as part\nof the SQL layer.\n\nORM experience: prior experience with SQLAlchemy is recommended.\n\nClass Outline\n\nDeclarative Mapping\n\n * Initial configuration \n * Basic mapping \n * Building a many-to-many relation \n * Using late-evaluated configuration arguments \n\nAdvanced queries\n\n * Selecting objects, selecting columns \n * Thinking generatively \n * Joining like a Pro \n * Power Eager Loading \n * Selecting from Anything \n\nSession Techniques\n\n * Transaction lifecycle \n * Scoping objects in and out of caches using merge() \n\nInheritance Mapping\n\n * Single Table Inheritance \n * Joined Table Inheritance \n * High Level/Low Level Joined Queries \n\nExtending SQL\n\n * Creating new SQL constructs \n * Creating new DDL constructs \n\nExtending the ORM\n\n * Using SessionExtension to populate denormalized views \n * Subclassing Query to Suit Your Needs \n\n", "quality_notes": "", "copyright_text": "Creative Commons Attribution-NonCommercial-ShareAlike 3.0", "embed": "", "thumbnail_url": "", "duration": null, "video_ogv_length": 926558095, "video_ogv_url": "", "video_ogv_download_only": false, "video_mp4_length": null, "video_mp4_url": null, "video_mp4_download_only": false, "video_webm_length": null, "video_webm_url": null, "video_webm_download_only": false, "video_flv_length": null, "video_flv_url": null, "video_flv_download_only": false, "source_url": "", "whiteboard": "", "recorded": "2010-02-19", "added": "2012-02-23T04:20:00", "updated": "2014-04-08T20:28:28.172" }