summaryrefslogtreecommitdiff
path: root/src/db/PhotoTable.vala
diff options
context:
space:
mode:
authorJörg Frings-Fürst <debian@jff.email>2025-06-09 10:49:17 +0200
committerJörg Frings-Fürst <debian@jff.email>2025-06-09 10:49:17 +0200
commit7868ff68cff97b21fe6d8681f8bc0334849c4d38 (patch)
tree0df9dca31bec8cf01fe0395818d148befec136ab /src/db/PhotoTable.vala
parent5b7b3b1dfd5ce7c275881098310667b09562ad27 (diff)
New upstream version 0.32.13upstream/0.32.13upstream
Diffstat (limited to 'src/db/PhotoTable.vala')
-rw-r--r--src/db/PhotoTable.vala7
1 files changed, 7 insertions, 0 deletions
diff --git a/src/db/PhotoTable.vala b/src/db/PhotoTable.vala
index 420b209..d74cbd1 100644
--- a/src/db/PhotoTable.vala
+++ b/src/db/PhotoTable.vala
@@ -1123,6 +1123,13 @@ public class PhotoTable : DatabaseTable {
throw_error("PhotoTable.upgrade_for_unset_timestamp", res);
}
}
+
+ public static void clean_comments() throws DatabaseError {
+ var result = db.exec("UPDATE PhotoTable SET comment = regexp_replace('^charset=\\w+\\s*', comment, '') WHERE comment like 'charset=%'");
+ if (result != Sqlite.OK) {
+ throw_error("Cleaning comments from charset", result);
+ }
+ }
}