Changes between Version 20 and Version 21 of TutorialDivingIn

Timestamp:

10/15/09 16:59:50 (4 years ago)

Author:

ged (IP: 77.109.114.23)

Comment:

--

TutorialDivingIn

@@ -111 +111 @@
 }}}
 
-This will tell SQLAlchemy to generate all of the SQL to insert the Movie into
-the database, and then execute that SQL. Now, to see a list of all the movies 
-in our database, simply type:
+This will tell SQLAlchemy to generate all of the SQL to insert the Movie into the database, and then execute that SQL and finally commit the current transaction. Now, to see a list of all the movies in our database, simply type:
 
 {{{
@@ -121 +119 @@
 }}}
 
-Not many, but exactly what we expected. This can be used to access your objects:
-
-{{{
-#!python
->>> movie = Movie.query.all()[0]
+Not many, but exactly what we expected. Now let us modify our test movie:
+
+{{{
+#!python
+>>> movie = Movie.query.first() # .first() is equivalent to (but nicer than) .all()[0]
 >>> movie.year = 1983
->>> movie = Movie.query.all()
+>>> session.commit()
+>>> Movie.query.all()
 [<Movie "Blade Runner" (1983)>]
 }}}
 
-Or even delete it:
-
-{{{
-#!python
->>> Movie.delete(movie)
+We can even delete it easily:
+
+{{{
+#!python
+>>> movie.delete()
+>>> session.commit()
 }}}
 
@@ -148 +148 @@
 Close the interpreter now and delete the database file (`movies.sqlite`)^4^, we will recreate and populate it in the next step.
 
-So far you've seen how to declare simple entities, create objects, store them, modify them, or even delete them,
-to the database and retrieve them again. Not too much magic, but a lot more 
-pleasant to the eye compared to calling lowlevel SQL-statements.
+So far you've seen how to declare simple entities, create objects, store them to the database and retrieve them again, modify them, or even delete them. Not too much magic, but a lot more pleasant to the eye compared to calling lowlevel SQL-statements.
 
 ^3^ ''Make sure, you're running your interpreter from the directory where you saved the `model.py` file.'' [[BR]]