1 import Database from 'better-sqlite3';
5 export const writer = new Database(DB, {
8 export const reader = new Database(DB, {
13 export const query = {
14 addFeed: writer.prepare('insert into feedlist (id, title, link) values (?, ?, ?)'),
15 getFeedList: reader.prepare('select * from feedlist'),
16 getFeedInfo: reader.prepare('select * from feedlist where id = ?'),
17 getFeedItemInfo: reader.prepare('select * from feed_items where id = ? and feed_id = ?'),
18 addFeedItem: writer.prepare('insert into feed_items (id, feed_id, guid, title, link, pub_date, content) values (?, ?, ?, ?, ?, ?, ?)'),
19 getFeedsFor: reader.prepare('select id, feed_id, guid, title, link, pub_date,read_at from feed_items where feed_id = ? and pub_date > ? order by pub_date desc'),
20 readItem: writer.prepare('update feed_items set read_at = ? where id = ? and read_at = 0'),
21 getUnreadCountForAll: reader.prepare('select count(id) as unread, feed_id from feed_items where read_at = 0 group by feed_id'),
22 readAllItems: writer.prepare(`update feed_items set read_at = datetime('now') where feed_id = ?`),
23 _deleteFeedItems: writer.prepare(`delete from feed_items where feed_id = ?`),
24 _deleteFeed: writer.prepare(`delete from feedlist where id = ?`),
26 run: (feed_id: string) => {
27 query._deleteFeedItems.run(feed_id);
28 query._deleteFeed.run(feed_id)