Further integration of the documentation for the sqlite3 module. There's still

quite some content to move over from the pysqlite manual, but it's a start now.

1 files changed, 20 insertions, 0 deletions

diff --git a/Doc/lib/sqlite3/mysumaggr.py b/Doc/lib/sqlite3/mysumaggr.py
new file mode 100644
index 0000000..b398726
--- /dev/null
+++ b/Doc/lib/sqlite3/mysumaggr.py
@@ -0,0 +1,20 @@
+import sqlite3

+

+class MySum:

+    def __init__(self):

+        self.count = 0

+

+    def step(self, value):

+        self.count += value

+

+    def finalize(self):

+        return self.count

+

+con = sqlite3.connect(":memory:")

+con.create_aggregate("mysum", 1, MySum)

+cur = con.cursor()

+cur.execute("create table test(i)")

+cur.execute("insert into test(i) values (1)")

+cur.execute("insert into test(i) values (2)")

+cur.execute("select mysum(i) from test")

+print cur.fetchone()[0]