Debian Codegraph @

resources/fts_triggers.sql

raw
1 CREATE TEMP TRIGGER IF NOT EXISTS fts_db_book_deleted_trg AFTER DELETE ON main.books BEGIN
2 DELETE FROM books_text WHERE book=OLD.id;
3 DELETE FROM dirtied_formats WHERE book=OLD.id;
4 END;
5
6 CREATE TEMP TRIGGER IF NOT EXISTS fts_db_format_deleted_trg AFTER DELETE ON main.data BEGIN
7 DELETE FROM books_text WHERE book=OLD.book AND format=OLD.format;
8 DELETE FROM dirtied_formats WHERE book=OLD.book AND format=OLD.format;
9 END;
10
11 CREATE TEMP TRIGGER IF NOT EXISTS fts_db_format_added_trg AFTER INSERT ON main.data BEGIN
12 INSERT OR IGNORE INTO dirtied_formats(book, format) VALUES (NEW.book, NEW.format);
13 END;
14
15 CREATE TEMP TRIGGER IF NOT EXISTS fts_db_format_updated_trg AFTER UPDATE ON main.data BEGIN
16 INSERT OR IGNORE INTO dirtied_formats(book, format) VALUES (NEW.book, NEW.format);
17 END;