summaryrefslogtreecommitdiff
path: root/src/db/VideoTable.vala
diff options
context:
space:
mode:
Diffstat (limited to 'src/db/VideoTable.vala')
-rw-r--r--src/db/VideoTable.vala9
1 files changed, 9 insertions, 0 deletions
diff --git a/src/db/VideoTable.vala b/src/db/VideoTable.vala
index 8af1278..753e02a 100644
--- a/src/db/VideoTable.vala
+++ b/src/db/VideoTable.vala
@@ -158,6 +158,8 @@ public class VideoTable : DatabaseTable {
if (res != Sqlite.DONE) {
if (res != Sqlite.CONSTRAINT)
throw_error("VideoTable.add", res);
+
+ return VideoID();
}
// fill in ignored fields with database values
@@ -480,5 +482,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);
+ }
+ }
+
}