diff sat/memory/sqlite.py @ 2918:21cf8395616c

memory (sqlite): fixed fileUpdate when original value is not set (NULL)
author Goffi <goffi@goffi.org>
date Fri, 26 Apr 2019 11:57:26 +0200
parents 1a23547f95fd
children e4715a609d75
line wrap: on
line diff
--- a/sat/memory/sqlite.py	Fri Apr 26 11:57:26 2019 +0200
+++ b/sat/memory/sqlite.py	Fri Apr 26 11:57:26 2019 +0200
@@ -905,11 +905,18 @@
                 older_value_raw = cursor.fetchone()[0]
             except TypeError:
                 raise exceptions.NotFound
-            value = json.loads(older_value_raw)
+            if older_value_raw is None:
+                value = {}
+            else:
+                value = json.loads(older_value_raw)
             update_cb(value)
             value_raw = json.dumps(value)
-            update_query = 'UPDATE files SET {column}=? WHERE id=? AND {column}=?'.format(column=column)
-            update_args = (value_raw, file_id, older_value_raw)
+            if older_value_raw is None:
+                update_query = 'UPDATE files SET {column}=? WHERE id=? AND {column} is NULL'.format(column=column)
+                update_args = (value_raw, file_id)
+            else:
+                update_query = 'UPDATE files SET {column}=? WHERE id=? AND {column}=?'.format(column=column)
+                update_args = (value_raw, file_id, older_value_raw)
             try:
                 cursor.execute(update_query, update_args)
             except sqlite3.Error: