[Python-checkins] r67118 - python/trunk/Doc/library/sqlite3.rst

Thu Nov 6 11:19:11 CET 2008

Author: georg.brandl
Date: Thu Nov 6 11:19:11 2008
New Revision: 67118
Log:
#4267: small fixes in sqlite3 docs.
Modified:
 python/trunk/Doc/library/sqlite3.rst
Modified: python/trunk/Doc/library/sqlite3.rst
==============================================================================

--- python/trunk/Doc/library/sqlite3.rst	(original)
+++ python/trunk/Doc/library/sqlite3.rst	Thu Nov 6 11:19:11 2008
@@ -64,10 +64,10 @@
 c.execute('select * from stocks where symbol=?', t)
 
 # Larger example
- for t in (('2006-03-28', 'BUY', 'IBM', 1000, 45.00),
+ for t in [('2006-03-28', 'BUY', 'IBM', 1000, 45.00),
 ('2006-04-05', 'BUY', 'MSOFT', 1000, 72.00),
 ('2006-04-06', 'SELL', 'IBM', 500, 53.00),
- ):
+ ]:
 c.execute('insert into stocks values (?,?,?,?,?)', t)
 
 To retrieve data after executing a SELECT statement, you can either treat the
@@ -426,10 +426,9 @@
 import sqlite3, os
 
 con = sqlite3.connect('existing_db.db')
- full_dump = os.linesep.join(con.iterdump())
- f = open('dump.sql', 'w')
- f.writelines(full_dump)
- f.close()
+ with open('dump.sql', 'w') as f:
+ for line in con.iterdump():
+ f.write('%s\n' % line)
 
 
 .. _sqlite3-cursor-objects:
@@ -813,8 +812,8 @@
 If you want **autocommit mode**, then set :attr:`isolation_level` to None.
 
 Otherwise leave it at its default, which will result in a plain "BEGIN"
-statement, or set it to one of SQLite's supported isolation levels: DEFERRED,
-IMMEDIATE or EXCLUSIVE.
+statement, or set it to one of SQLite's supported isolation levels: "DEFERRED",
+"IMMEDIATE" or "EXCLUSIVE".
 
 
 
