Changeset 16226

Timestamp:

2008-06-27T15:24:51+12:00 (15 years ago)

Author:

mdewsnip

Message:

Changed a "DELETE FROM" then "INSERT INTO" into a "INSERT OR REPLACE", for simplicity (and hopefully efficiency too).

File:

• gsdl/trunk/perllib/dbutil.pm (modified) (1 diff)

gsdl/trunk/perllib/dbutil.pm

@@ -285 +285 @@
 
     my $safe_infodb_key = &sqlite_safe($infodb_key);
-    print $infodb_handle "DELETE FROM data WHERE key='" . $safe_infodb_key . "';\n";
-    print $infodb_handle "INSERT INTO data (key, value) VALUES ('" . $safe_infodb_key . "', '" . &sqlite_safe($infodb_entry_value) . "');\n";
+    print $infodb_handle "INSERT OR REPLACE INTO data (key, value) VALUES ('" . $safe_infodb_key . "', '" . &sqlite_safe($infodb_entry_value) . "');\n";
 
     # If this infodb entry is for a document, add all the interesting document metadata to the