add hg and python

1 files changed, 12 insertions, 0 deletions

diff --git a/sys/src/cmd/python/Doc/lib/sqlite3/rowclass.py b/sys/src/cmd/python/Doc/lib/sqlite3/rowclass.py
new file mode 100644
index 000000000..3fa0b8738
--- /dev/null
+++ b/sys/src/cmd/python/Doc/lib/sqlite3/rowclass.py
@@ -0,0 +1,12 @@
+import sqlite3
+
+con = sqlite3.connect("mydb")
+con.row_factory = sqlite3.Row
+
+cur = con.cursor()
+cur.execute("select name_last, age from people")
+for row in cur:
+    assert row[0] == row["name_last"]
+    assert row["name_last"] == row["nAmE_lAsT"]
+    assert row[1] == row["age"]
+    assert row[1] == row["AgE"]