From 4189e53a881e52de0945375a72b8748143c5bd13 Mon Sep 17 00:00:00 2001
From: Kali Kaneko <kali@futeisha.org>
Date: Mon, 4 Feb 2013 19:20:12 +0900
Subject: initial commit

---
 doc/includes/sqlite3/row_factory.py | 13 +++++++++++++
 1 file changed, 13 insertions(+)
 create mode 100644 doc/includes/sqlite3/row_factory.py

(limited to 'doc/includes/sqlite3/row_factory.py')

diff --git a/doc/includes/sqlite3/row_factory.py b/doc/includes/sqlite3/row_factory.py
new file mode 100644
index 0000000..bfbc64d
--- /dev/null
+++ b/doc/includes/sqlite3/row_factory.py
@@ -0,0 +1,13 @@
+from pysqlite2 import dbapi2 as sqlite3
+
+def dict_factory(cursor, row):
+    d = {}
+    for idx, col in enumerate(cursor.description):
+        d[col[0]] = row[idx]
+    return d
+
+con = sqlite3.connect(":memory:")
+con.row_factory = dict_factory
+cur = con.cursor()
+cur.execute("select 1 as a")
+print cur.fetchone()["a"]
-- 
cgit v1.2.3