From 71a836c41bcbd856cbedfa22033684b7579c5d06 Mon Sep 17 00:00:00 2001 From: Bryan Newbold Date: Wed, 2 Sep 2020 10:37:57 -0700 Subject: do not create hathitrust-only journal rows --- chocula/database.py | 3 ++- 1 file changed, 2 insertions(+), 1 deletion(-) diff --git a/chocula/database.py b/chocula/database.py index c432b76..3e8db57 100644 --- a/chocula/database.py +++ b/chocula/database.py @@ -434,7 +434,8 @@ class ChoculaDatabase: counts: Counter = Counter() cur = self.db.cursor() self.db.row_factory = sqlite3.Row - index_issnls = list(cur.execute("SELECT DISTINCT issnl FROM directory")) + # don't include new journals if they are *only* in hathitrust KBART + index_issnls = list(cur.execute("SELECT DISTINCT issnl FROM directory WHERE slug != 'hathitrust'")) fatcat_issnls = list( cur.execute( "SELECT DISTINCT issnl FROM fatcat_container WHERE issnl IS NOT null" -- cgit v1.2.3