symbian-qemu-0.9.1-12/python-2.6.1/Doc/includes/sqlite3/parse_colnames.py
author William Roberts <williamr@symbian.org>
Fri, 07 Aug 2009 11:20:16 +0100
changeset 7 b016402e601c
parent 1 2fb8b9db1c86
permissions -rw-r--r--
Fix E32PATH to make bootstrap compile correctly, tidy up other extension option paths
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)