From 82560ebb8d2472be5a916a6013deff89781b452d Mon Sep 17 00:00:00 2001 From: =?UTF-8?q?Gerhard=20H=C3=A4ring?= Date: Mon, 1 May 2006 15:14:48 +0000 Subject: 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. --- Doc/lib/sqlite3/mysumaggr.py | 20 ++++++++++++++++++++ 1 file changed, 20 insertions(+) create mode 100644 Doc/lib/sqlite3/mysumaggr.py (limited to 'Doc/lib/sqlite3/mysumaggr.py') diff --git a/Doc/lib/sqlite3/mysumaggr.py b/Doc/lib/sqlite3/mysumaggr.py new file mode 100644 index 0000000000..b3987261f9 --- /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] -- cgit v1.2.1