aboutsummaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
-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,