From b6ab2a0912fc0528c4228f884c1a35b082030048 Mon Sep 17 00:00:00 2001 From: Bryan Newbold Date: Tue, 30 Jul 2019 20:50:38 -0700 Subject: chocula: fix wikidata_qid inclusion --- extra/journal_metadata/chocula.py | 2 ++ extra/journal_metadata/chocula_schema.sql | 2 +- 2 files changed, 3 insertions(+), 1 deletion(-) diff --git a/extra/journal_metadata/chocula.py b/extra/journal_metadata/chocula.py index ad999f14..e54a017a 100755 --- a/extra/journal_metadata/chocula.py +++ b/extra/journal_metadata/chocula.py @@ -1100,6 +1100,8 @@ class ChoculaDatabase(): if irow['slug'] in ('crossref',): out['has_dois'] = True # TODO: other DOI registrars (japan, datacite) + if irow['slug'] == 'wikidata': + out['wikidata_qid'] = irow['identifier'] for k in ('name',): if not out.get(k) and irow[k]: out[k] = irow[k] diff --git a/extra/journal_metadata/chocula_schema.sql b/extra/journal_metadata/chocula_schema.sql index 24adb5e5..b3c7c2fb 100644 --- a/extra/journal_metadata/chocula_schema.sql +++ b/extra/journal_metadata/chocula_schema.sql @@ -1,10 +1,10 @@ - CREATE TABLE IF NOT EXISTS journal (issnl TEXT NOT NULL PRIMARY KEY, issne TEXT, issnp TEXT, fatcat_ident TEXT, + wikidata_qid TEXT, name TEXT, publisher TEXT, country TEXT, -- cgit v1.2.3