diff -r 8a99ccb99361 -r 28c80ae695dc db.py --- a/db.py Tue Oct 05 15:38:38 2010 +0200 +++ b/db.py Wed Oct 06 01:18:34 2010 +0200 @@ -93,6 +93,15 @@ con.commit() cur.close() +def update_where(db_file, table, dep_column, dep_value, set_column, set_value): + con, cur = session(db_file) + values = (set_value, dep_value) + sql = "update %s set %s=? where %s=?" % (table, set_column, dep_column) + cur.execute(sql, values) + con.commit() + cur.close() + test(db_file) + def find_last_project(db_file, time): con, cur = session(db_file) values = (time,)