~ubuntu-branches/ubuntu/precise/python3.2/precise-proposed

« back to all changes in this revision

Viewing changes to Doc/includes/sqlite3/rowclass.py

  • Committer: Package Import Robot
  • Author(s): Matthias Klose
  • Date: 2012-03-09 18:40:39 UTC
  • mfrom: (30.1.2 sid)
  • Revision ID: package-import@ubuntu.com-20120309184039-j3yk2emxr1plyo21
Tags: 3.2.3~rc1-1
* Python 3.2.3 release candidate 1.
* Update to 20120309 from the 3.2 branch.
* Fix libpython.a symlink. Closes: #660146.
* Build-depend on xauth.
* Run the gdb tests for the debug build only.

Show diffs side-by-side

added added

removed removed

Lines of Context:
1
1
import sqlite3
2
2
 
3
 
con = sqlite3.connect("mydb")
 
3
con = sqlite3.connect(":memory:")
4
4
con.row_factory = sqlite3.Row
5
5
 
6
6
cur = con.cursor()
7
 
cur.execute("select name_last, age from people")
 
7
cur.execute("select 'John' as name, 42 as age")
8
8
for row in cur:
9
 
    assert row[0] == row["name_last"]
10
 
    assert row["name_last"] == row["nAmE_lAsT"]
 
9
    assert row[0] == row["name"]
 
10
    assert row["name"] == row["nAmE"]
11
11
    assert row[1] == row["age"]
12
12
    assert row[1] == row["AgE"]