From 3b62f904d6d3fdad168d3b212ff7c465c01b50f4 Mon Sep 17 00:00:00 2001 From: Frédéric Guillot Date: Fri, 19 Jan 2018 18:43:27 -0800 Subject: Do not crawl existing entry URLs --- storage/entry.go | 8 ++++++++ 1 file changed, 8 insertions(+) (limited to 'storage') diff --git a/storage/entry.go b/storage/entry.go index c6058d0..d1e8798 100644 --- a/storage/entry.go +++ b/storage/entry.go @@ -226,3 +226,11 @@ func (s *Storage) MarkAllAsRead(userID int64) error { return nil } + +// EntryURLExists returns true if an entry with this URL already exists. +func (s *Storage) EntryURLExists(userID int64, entryURL string) bool { + var result int + query := `SELECT count(*) as c FROM entries WHERE user_id=$1 AND url=$2` + s.db.QueryRow(query, userID, entryURL).Scan(&result) + return result >= 1 +} -- cgit v1.2.3