symbian-qemu-0.9.1-12/python-2.6.1/Doc/includes/sqlite3/parse_colnames.py
author Jani Hyvonen<jani.hyvonen@nokia.com>
Wed, 22 Sep 2010 16:51:17 +0300
branchgraphics-phase-3
changeset 110 52ce3e8fba90
parent 1 2fb8b9db1c86
permissions -rw-r--r--
Header and class name changes
Ignore whitespace changes - Everywhere: Within whitespace: At end of lines:
1
2fb8b9db1c86 Initial QEMU (symbian-qemu-0.9.1-12) import
martin.trojer@nokia.com
parents:
diff changeset
     1
import sqlite3
2fb8b9db1c86 Initial QEMU (symbian-qemu-0.9.1-12) import
martin.trojer@nokia.com
parents:
diff changeset
     2
import datetime
2fb8b9db1c86 Initial QEMU (symbian-qemu-0.9.1-12) import
martin.trojer@nokia.com
parents:
diff changeset
     3
2fb8b9db1c86 Initial QEMU (symbian-qemu-0.9.1-12) import
martin.trojer@nokia.com
parents:
diff changeset
     4
con = sqlite3.connect(":memory:", detect_types=sqlite3.PARSE_COLNAMES)
2fb8b9db1c86 Initial QEMU (symbian-qemu-0.9.1-12) import
martin.trojer@nokia.com
parents:
diff changeset
     5
cur = con.cursor()
2fb8b9db1c86 Initial QEMU (symbian-qemu-0.9.1-12) import
martin.trojer@nokia.com
parents:
diff changeset
     6
cur.execute('select ? as "x [timestamp]"', (datetime.datetime.now(),))
2fb8b9db1c86 Initial QEMU (symbian-qemu-0.9.1-12) import
martin.trojer@nokia.com
parents:
diff changeset
     7
dt = cur.fetchone()[0]
2fb8b9db1c86 Initial QEMU (symbian-qemu-0.9.1-12) import
martin.trojer@nokia.com
parents:
diff changeset
     8
print dt, type(dt)