aboutsummaryrefslogtreecommitdiffhomepage
path: root/backend/db/queries/articles.sql
diff options
context:
space:
mode:
Diffstat (limited to 'backend/db/queries/articles.sql')
-rw-r--r--backend/db/queries/articles.sql6
1 files changed, 6 insertions, 0 deletions
diff --git a/backend/db/queries/articles.sql b/backend/db/queries/articles.sql
index 5acdada..2c00678 100644
--- a/backend/db/queries/articles.sql
+++ b/backend/db/queries/articles.sql
@@ -71,3 +71,9 @@ SELECT EXISTS(
SELECT 1 FROM articles
WHERE feed_id = ? AND guid = ?
) as article_exists;
+
+-- name: CheckArticleExistsByGUID :one
+SELECT EXISTS(
+ SELECT 1 FROM articles
+ WHERE guid = ?
+) as article_exists;