From b6ab2a0912fc0528c4228f884c1a35b082030048 Mon Sep 17 00:00:00 2001
From: Bryan Newbold <bnewbold@robocracy.org>
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(-)

(limited to 'extra/journal_metadata')

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