diff options
Diffstat (limited to 'src/db/VideoTable.vala')
| -rw-r--r-- | src/db/VideoTable.vala | 9 |
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); + } + } + } |
