summaryrefslogtreecommitdiff
path: root/src/db/PhotoTable.vala
diff options
context:
space:
mode:
authorJörg Frings-Fürst <debian@jff.email>2025-08-20 13:46:37 +0200
committerJörg Frings-Fürst <debian@jff.email>2025-08-20 13:46:37 +0200
commitf612c8e2a0aed0314cc4bfd9d082ceda43813929 (patch)
tree89feef860546b5400afca7e887956af768801525 /src/db/PhotoTable.vala
parent34852b296a372a81d0b97ab4c12f32be6d294cd3 (diff)
parenta71628d0b6bfa751f014b15fca5f1c1ff4989721 (diff)
Merge branch 'release/debian/0.32.13-1'debian/0.32.13-1
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);
+ }
+ }
}