--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/roundup/backends/back_sqlite.py	Wed Sep 18 05:07:49 2002 +0000
@@ -0,0 +1,90 @@
+# $Id: back_sqlite.py,v 1.1 2002-09-18 05:07:47 richard Exp $
+__doc__ = '''
+See https://pysqlite.sourceforge.net/ for pysqlite info
+'''
+import base64, marshal
+from roundup.backends.rdbms_common import *
+import sqlite
+
+class Database(Database):
+    # char to use for positional arguments
+    arg = '%s'
+
+    def open_connection(self):
+        # ensure files are group readable and writable
+        os.umask(0002)
+        db = os.path.join(self.config.DATABASE, 'db')
+        self.conn = sqlite.connect(db=db)
+        cursor = self.conn.cursor()
+        try:
+            self.database_schema = self.load_dbschema(cursor)
+        except sqlite.DatabaseError, error:
+            if str(error) != 'no such table: schema':
+                raise
+            self.database_schema = {}
+            cursor = self.conn.cursor()
+            cursor.execute('create table schema (schema varchar)')
+            cursor.execute('create table ids (name varchar, num integer)')
+
+    def __repr__(self):
+        return '<roundlite 0x%x>'%id(self)
+
+    def sql_fetchone(self, cursor):
+        ''' Fetch a single row. If there's nothing to fetch, return None.
+        '''
+        return cursor.fetchone()
+
+    def sql_commit(self):
+        ''' Actually commit to the database.
+
+            Ignore errors if there's nothing to commit.
+        '''
+        try:
+            self.conn.commit()
+        except sqlite.DatabaseError, error:
+            if str(error) != 'cannot commit - no transaction is active':
+                raise
+
+    def save_dbschema(self, cursor, schema):
+        ''' Save the schema definition that the database currently implements
+        '''
+        s = repr(self.database_schema)
+        self.sql(cursor, 'insert into schema values (%s)', (s,))
+
+    def load_dbschema(self, cursor):
+        ''' Load the schema definition that the database currently implements
+        '''
+        cursor.execute('select schema from schema')
+        return eval(cursor.fetchone()[0])
+
+    def save_journal(self, cursor, classname, cols, nodeid, journaldate,
+            journaltag, action, params):
+        ''' Save the journal entry to the database
+        '''
+        # make the params db-friendly
+        params = repr(params)
+        entry = (nodeid, journaldate, journaltag, action, params)
+
+        # do the insert
+        a = self.arg
+        sql = 'insert into %s__journal (%s) values (%s,%s,%s,%s,%s)'%(classname,
+            cols, a, a, a, a, a)
+        if __debug__:
+            print >>hyperdb.DEBUG, 'addjournal', (self, sql, entry)
+        cursor.execute(sql, entry)
+
+    def load_journal(self, cursor, classname, cols, nodeid):
+        ''' Load the journal from the database
+        '''
+        # now get the journal entries
+        sql = 'select %s from %s__journal where nodeid=%s'%(cols, classname,
+            self.arg)
+        if __debug__:
+            print >>hyperdb.DEBUG, 'getjournal', (self, sql, nodeid)
+        cursor.execute(sql, (nodeid,))
+        res = []
+        for nodeid, date_stamp, user, action, params in cursor.fetchall():
+            params = eval(params)
+            res.append((nodeid, date.Date(date_stamp), user, action, params))
+        return res
+