1.1 --- a/db.py	Tue Oct 05 15:38:38 2010 +0200
     1.2 +++ b/db.py	Wed Oct 06 01:18:34 2010 +0200
     1.3 @@ -93,6 +93,15 @@
     1.4  	con.commit()
     1.5  	cur.close()
     1.6  
     1.7 +def update_where(db_file, table, dep_column, dep_value, set_column, set_value):
     1.8 +	con, cur = session(db_file)
     1.9 +	values = (set_value, dep_value)	
    1.10 +	sql = "update %s set %s=? where %s=?" % (table, set_column, dep_column)
    1.11 +	cur.execute(sql, values)
    1.12 +	con.commit()
    1.13 +	cur.close()
    1.14 +	test(db_file)
    1.15 +
    1.16  def find_last_project(db_file, time):
    1.17  	con, cur = session(db_file)
    1.18  	values = (time,)