# HG changeset patch # User Tero Marttila # Date 1246568398 -10800 # Node ID c226063eeb659111b4f8c17cc8e181037815bb73 # Parent bf26e43c79ea4bf44e94351e26522f2b3fc9ca12 remove obsolete db.py diff -r bf26e43c79ea -r c226063eeb65 degal/db.py --- a/degal/db.py Thu Jul 02 23:58:17 2009 +0300 +++ /dev/null Thu Jan 01 00:00:00 1970 +0000 @@ -1,64 +0,0 @@ -import sqlite3 - -try : - conn = sqlite3.connect("db/degal.db") - -except sqlite3.OperationalError : - conn = None - -def execute (expr, *args) : - c = conn.cursor() - c.execute(expr, args) - - return c - -def execute_many (expr, iter) : - c = conn.cursor() - c.executemany(expr, iter) - - return c - -def insert (expr, *args) : - return execute_commit(expr, *args).lastrowid - -def insert_many (cb, expr, iter) : - """ - Perform an executemany with the given iterator (which must yield (cb_val, args) tuples), calling the given callback with the args (cb_val, row_id) - """ - - c = conn.cursor() - - c.executemany(expr, _lastrowid_adapter(c, iter, cb)) - - return commit(c) - -def _lastrowid_adapter (c, iter, cb) : - for val, args in iter : - yield args - - cb(val, c.lastrowid) - -def commit (cursor) : - try : - cursor.execute("COMMIT") - except sqlite3.OperationalError : - pass # ffs. INSERT just doesn't do anything otherwise - - return cursor - -def execute_commit (expr, *args) : - return commit(execute(expr, *args)) - -def execute_commit_many (expr, iter) : - return commit(execute_many(expr, iter)) - -select = execute - -delete = execute_commit - -delete_many = execute_commit_many - -if conn : - cursor = conn.cursor - -