1 import Database from 'better-sqlite3';
2 import {RSSParser} from 'src/parsers/rss';
3 import { v4 as uuidv4 } from 'uuid';
6 export const writer = new Database(DB, {
11 writer.prepare('drop table if exists feed_items').run();
12 writer.prepare('drop table feedlist').run();
15 create table feedlist (
25 create table feed_items (
33 read_at number default 0
42 link: 'http://scripting.com/rss.xml',
46 title: 'Hacker News Front Page',
47 link: 'https://hnrss.org/frontpage'
52 link: 'https://xangelo.ca/posts/index.xml'
56 writer.prepare('insert into feedlist (id, title, link) values (?,?,?), (?, ?, ?), (?,?,?)').run(
57 feeds[0].id, feeds[0].title, feeds[0].link,
58 feeds[1].id, feeds[1].title, feeds[1].link,
59 feeds[2].id, feeds[2].title, feeds[2].link
62 const insert = writer.prepare(`insert into feed_items (id, feed_id, guid, title, link, pub_date, content) values (?, ?, ?, ?, ?, ?, ?)`);
63 const rss = new RSSParser();
64 feeds.forEach(async feed => {
65 const data = await rss.parse(feed.link);
66 data.items.forEach(item => {
68 insert.run(id, feed.id, item.guid, item.title, item.link, item.pubDate, item.content);