From fc1976c012b09299ff8c05ad4c142c76dfd683fe Mon Sep 17 00:00:00 2001
From: Nicolas Boisselier <nicolas.boisselier@gmail.com>
Date: Tue, 3 Jul 2018 02:17:05 +0100
Subject: [PATCH] lib/postgres/article.sql

---
 lib/postgres/article.sql | 17 +++++++++++++++++
 1 file changed, 17 insertions(+)
 create mode 100644 lib/postgres/article.sql

diff --git a/lib/postgres/article.sql b/lib/postgres/article.sql
new file mode 100644
index 00000000..59daf3f5
--- /dev/null
+++ b/lib/postgres/article.sql
@@ -0,0 +1,17 @@
+--DROP TABLE IF EXISTS article;
+CREATE TABLE IF NOT EXISTS article (
+  url varchar(200) PRIMARY KEY,
+  website varchar(200),
+  title varchar(200),
+  date timestamp,
+  content varchar(10000),
+  enable BOOLEAN DEFAULT 'f'
+);
+CREATE TEMPORARY TABLE _article AS SELECT * FROM article LIMIT 0;
+BEGIN TRANSACTION;
+DELETE FROM _article;
+COPY _article FROM PROGRAM '. /etc/profile && psql data -Atc "select rss from website" \
+| xargs -n 1 rss-feedparser | sed "s/\$/\tf/"
+' WITH (format 'text', NULL ''); 
+INSERT INTO article SELECT * FROM _article ON CONFLICT (url) DO NOTHING;
+COMMIT;
-- 
2.47.3