__license__ = "GNU GPL"
import sys
-from sqlobject import sqlhub
+from sqlobject import sqlhub, SQLObjectNotFound
from sqlobject.sqlbuilder import Insert
from xsetbg_conf import xsetbg_conf
from xsetbg_db import recreate_db
timestamp = convert_str(timestamp)
if fs_encoding != 'utf-8':
filename = filename.decode(fs_encoding).encode('utf-8')
- values = {'last_shown': timestamp, 'full_name': filename}
- if id:
- values['id'] = id
- query = txn.sqlrepr(Insert(xsetbg_db.sqlmeta.table, values=values))
- txn.query(query)
+ try:
+ row = xsetbg_db.byFull_name(filename)
+ except SQLObjectNotFound:
+ values = {'last_shown': timestamp, 'full_name': filename}
+ if id:
+ values['id'] = id
+ query = txn.sqlrepr(Insert(xsetbg_db.sqlmeta.table, values=values))
+ txn.query(query)
+ else:
+ assert row.id == id
+ assert row.last_shown == timestamp
txn.commit()
sqlhub.processConnection = connection