| Georg Brandl | 116aa62 | 2007-08-15 14:28:22 +0000 | [diff] [blame] | 1 | import sqlite3 |
| 2 | |
| Petri Lehtinen | 1ca9395 | 2012-02-15 22:17:21 +0200 | [diff] [blame] | 3 | con = sqlite3.connect(":memory:") |
| Georg Brandl | 116aa62 | 2007-08-15 14:28:22 +0000 | [diff] [blame] | 4 | con.row_factory = sqlite3.Row |
| 5 | |
| 6 | cur = con.cursor() |
| Petri Lehtinen | 1ca9395 | 2012-02-15 22:17:21 +0200 | [diff] [blame] | 7 | cur.execute("select 'John' as name, 42 as age") |
| Georg Brandl | 116aa62 | 2007-08-15 14:28:22 +0000 | [diff] [blame] | 8 | for row in cur: |
| Petri Lehtinen | 1ca9395 | 2012-02-15 22:17:21 +0200 | [diff] [blame] | 9 | assert row[0] == row["name"] |
| 10 | assert row["name"] == row["nAmE"] |
| Georg Brandl | 116aa62 | 2007-08-15 14:28:22 +0000 | [diff] [blame] | 11 | assert row[1] == row["age"] |
| 12 | assert row[1] == row["AgE"] |
| Xtreak | 287b84d | 2019-05-20 03:22:20 +0530 | [diff] [blame] | 13 | |
| 14 | con.close() |