summaryrefslogtreecommitdiff
path: root/src/db/VideoTable.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/VideoTable.vala
parent5b7b3b1dfd5ce7c275881098310667b09562ad27 (diff)
New upstream version 0.32.13upstream/0.32.13upstream
Diffstat (limited to 'src/db/VideoTable.vala')
-rw-r--r--src/db/VideoTable.vala7
1 files changed, 7 insertions, 0 deletions
diff --git a/src/db/VideoTable.vala b/src/db/VideoTable.vala
index 8af1278..67c50ba 100644
--- a/src/db/VideoTable.vala
+++ b/src/db/VideoTable.vala
@@ -480,5 +480,12 @@ public class VideoTable : DatabaseTable {
}
}
+ public static void clean_comments() throws DatabaseError {
+ var result = db.exec("UPDATE VideoTable SET comment = regexp_replace('^charset=\\w+\\s*', comment, '') WHERE comment like 'charset=%'");
+ if (result != Sqlite.OK) {
+ throw_error("Cleaning comments from charset", result);
+ }
+ }
+
}