aboutsummaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authorBryan Newbold <bnewbold@robocracy.org>2019-07-30 20:50:38 -0700
committerBryan Newbold <bnewbold@robocracy.org>2019-07-30 20:50:38 -0700
commitb6ab2a0912fc0528c4228f884c1a35b082030048 (patch)
treef69a820fda1fceaf3a6c1146f4fd80f0a5900e68
parent7bdcfe04fc4dbbe7fbe14ef6c45a80e09c78450f (diff)
downloadfatcat-b6ab2a0912fc0528c4228f884c1a35b082030048.tar.gz
fatcat-b6ab2a0912fc0528c4228f884c1a35b082030048.zip
chocula: fix wikidata_qid inclusion
-rwxr-xr-xextra/journal_metadata/chocula.py2
-rw-r--r--extra/journal_metadata/chocula_schema.sql2
2 files changed, 3 insertions, 1 deletions
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,