Building data-driven web apps with Pyramid and SQLAlchemy Transcripts
Chapter: Using SQLAchemy
Lecture: Concept: Database updates

Login or purchase this course to watch this video and the rest of the course contents.
0:00 In order to update existing data, we start
0:03 like we always do, we get a session, and then we
0:05 retrieve one or more records from the database.
0:08 Here we're just getting one package.
0:10 We're going to get this package back, and if we make
0:12 changes to it, so we set the author value to a new name
0:16 and we set the author email to a new email
0:18 SQLAlchemy will track within the session that
0:22 that record is dirty and it needs to be updated
0:25 because we've changed some fields.
0:27 And then, when we're ready to actually
0:29 save it, push all the changes back.
0:32 I could apply this to as many entities as we'd like
0:34 it doesn't have to just be one, then we're going to
0:37 commit the unit to work, and it's going to look
0:39 at the changes, do all the changes in a single
0:42 transaction, back to the database.
0:44 We use the unit of work to do
0:46 our updates just like we do the inserts.