LP#1541559: Stamping upgrade scripts for e-book integration
authorKathy Lussier <klussier@masslnc.org>
Tue, 21 Feb 2017 02:15:47 +0000 (21:15 -0500)
committerKathy Lussier <klussier@masslnc.org>
Tue, 21 Feb 2017 02:15:47 +0000 (21:15 -0500)
Missed this commit when pushing the e-book integration work.

Signed-off-by: Kathy Lussier <klussier@masslnc.org>
Open-ILS/src/sql/Pg/002.schema.config.sql
Open-ILS/src/sql/Pg/upgrade/1027.data.org-setting.ebook-api-oneclickdigital.sql [new file with mode: 0644]
Open-ILS/src/sql/Pg/upgrade/1028.data.org-setting.ebook-api-overdrive.sql [new file with mode: 0644]
Open-ILS/src/sql/Pg/upgrade/XXXX.data.org-setting.ebook-api-oneclickdigital.sql [deleted file]
Open-ILS/src/sql/Pg/upgrade/XXXX.data.org-setting.ebook-api-overdrive.sql [deleted file]

index 946ca60..06928cd 100644 (file)
@@ -91,7 +91,7 @@ CREATE TRIGGER no_overlapping_deps
     BEFORE INSERT OR UPDATE ON config.db_patch_dependencies
     FOR EACH ROW EXECUTE PROCEDURE evergreen.array_overlap_check ('deprecates');
 
-INSERT INTO config.upgrade_log (version, applied_to) VALUES ('1026', :eg_version); -- gmcharlt/kmlussier
+INSERT INTO config.upgrade_log (version, applied_to) VALUES ('1028', :eg_version); -- jeffdavis/kmlussier
 
 CREATE TABLE config.bib_source (
        id              SERIAL  PRIMARY KEY,
diff --git a/Open-ILS/src/sql/Pg/upgrade/1027.data.org-setting.ebook-api-oneclickdigital.sql b/Open-ILS/src/sql/Pg/upgrade/1027.data.org-setting.ebook-api-oneclickdigital.sql
new file mode 100644 (file)
index 0000000..ebe9b26
--- /dev/null
@@ -0,0 +1,42 @@
+BEGIN;
+
+SELECT evergreen.upgrade_deps_block_check('1027', :eg_version);
+
+INSERT INTO config.org_unit_setting_type
+    (name, label, description, grp, datatype) 
+VALUES (
+    'ebook_api.oneclickdigital.library_id',
+    oils_i18n_gettext(
+        'ebook_api.oneclickdigital.library_id',
+        'OneClickdigital Library ID',
+        'coust',
+        'label'
+    ),
+    oils_i18n_gettext(
+        'ebook_api.oneclickdigital.library_id',
+        'Identifier assigned to this library by OneClickdigital',
+        'coust',
+        'description'
+    ),
+    'ebook_api',
+    'string'
+),(
+    'ebook_api.oneclickdigital.basic_token',
+    oils_i18n_gettext(
+        'ebook_api.oneclickdigital.basic_token',
+        'OneClickdigital Basic Token',
+        'coust',
+        'label'
+    ),
+    oils_i18n_gettext(
+        'ebook_api.oneclickdigital.basic_token',
+        'Basic token for client authentication with OneClickdigital API (supplied by OneClickdigital)',
+        'coust',
+        'description'
+    ),
+    'ebook_api',
+    'string'
+);
+
+COMMIT;
+
diff --git a/Open-ILS/src/sql/Pg/upgrade/1028.data.org-setting.ebook-api-overdrive.sql b/Open-ILS/src/sql/Pg/upgrade/1028.data.org-setting.ebook-api-overdrive.sql
new file mode 100644 (file)
index 0000000..17778b2
--- /dev/null
@@ -0,0 +1,141 @@
+BEGIN;
+
+SELECT evergreen.upgrade_deps_block_check('1028', :eg_version);
+
+INSERT INTO config.settings_group (name, label)
+    VALUES ('ebook_api', 'Ebook API Integration');
+
+INSERT INTO config.org_unit_setting_type
+    (name, label, description, grp, datatype) 
+VALUES (
+    'ebook_api.overdrive.discovery_base_uri',
+    oils_i18n_gettext(
+        'ebook_api.overdrive.discovery_base_uri',
+        'OverDrive Discovery API Base URI',
+        'coust',
+        'label'
+    ),
+    oils_i18n_gettext(
+        'ebook_api.overdrive.discovery_base_uri',
+        'Base URI for OverDrive Discovery API (defaults to https://api.overdrive.com/v1). Using HTTPS here is strongly encouraged.',
+        'coust',
+        'description'
+    ),
+    'ebook_api',
+    'string'
+),(
+    'ebook_api.overdrive.circulation_base_uri',
+    oils_i18n_gettext(
+        'ebook_api.overdrive.circulation_base_uri',
+        'OverDrive Circulation API Base URI',
+        'coust',
+        'label'
+    ),
+    oils_i18n_gettext(
+        'ebook_api.overdrive.circulation_base_uri',
+        'Base URI for OverDrive Circulation API (defaults to https://patron.api.overdrive.com/v1). Using HTTPS here is strongly encouraged.',
+        'coust',
+        'description'
+    ),
+    'ebook_api',
+    'string'
+),(
+    'ebook_api.overdrive.account_id',
+    oils_i18n_gettext(
+        'ebook_api.overdrive.account_id',
+        'OverDrive Account ID',
+        'coust',
+        'label'
+    ),
+    oils_i18n_gettext(
+        'ebook_api.overdrive.account_id',
+        'Account ID (a.k.a. Library ID) for this library, as assigned by OverDrive',
+        'coust',
+        'description'
+    ),
+    'ebook_api',
+    'string'
+),(
+    'ebook_api.overdrive.websiteid',
+    oils_i18n_gettext(
+        'ebook_api.overdrive.websiteid',
+        'OverDrive Website ID',
+        'coust',
+        'label'
+    ),
+    oils_i18n_gettext(
+        'ebook_api.overdrive.websiteid',
+        'Website ID for this library, as assigned by OverDrive',
+        'coust',
+        'description'
+    ),
+    'ebook_api',
+    'string'
+),(
+    'ebook_api.overdrive.authorizationname',
+    oils_i18n_gettext(
+        'ebook_api.overdrive.authorizationname',
+        'OverDrive Authorization Name',
+        'coust',
+        'label'
+    ),
+    oils_i18n_gettext(
+        'ebook_api.overdrive.authorizationname',
+        'Authorization name for this library, as assigned by OverDrive',
+        'coust',
+        'description'
+    ),
+    'ebook_api',
+    'string'
+),(
+    'ebook_api.overdrive.basic_token',
+    oils_i18n_gettext(
+        'ebook_api.overdrive.basic_token',
+        'OverDrive Basic Token',
+        'coust',
+        'label'
+    ),
+    oils_i18n_gettext(
+        'ebook_api.overdrive.basic_token',
+        'Basic token for client authentication with OverDrive API (supplied by OverDrive)',
+        'coust',
+        'description'
+    ),
+    'ebook_api',
+    'string'
+),(
+    'ebook_api.overdrive.granted_auth_redirect_uri',
+    oils_i18n_gettext(
+        'ebook_api.overdrive.granted_auth_redirect_uri',
+        'OverDrive Granted Authorization Redirect URI',
+        'coust',
+        'label'
+    ),
+    oils_i18n_gettext(
+        'ebook_api.overdrive.granted_auth_redirect_uri',
+        'URI provided to OverDrive for use with granted authorization',
+        'coust',
+        'description'
+    ),
+    'ebook_api',
+    'string'
+),(
+    'ebook_api.overdrive.password_required',
+    oils_i18n_gettext(
+        'ebook_api.overdrive.password_required',
+        'OverDrive Password Required',
+        'coust',
+        'label'
+    ),
+    oils_i18n_gettext(
+        'ebook_api.overdrive.password_required',
+        'Does this library require a password when authenticating patrons with the OverDrive API?',
+        'coust',
+        'description'
+    ),
+    'ebook_api',
+    'bool'
+);
+
+COMMIT;
+
diff --git a/Open-ILS/src/sql/Pg/upgrade/XXXX.data.org-setting.ebook-api-oneclickdigital.sql b/Open-ILS/src/sql/Pg/upgrade/XXXX.data.org-setting.ebook-api-oneclickdigital.sql
deleted file mode 100644 (file)
index 754dac0..0000000
+++ /dev/null
@@ -1,42 +0,0 @@
-BEGIN;
-
-SELECT evergreen.upgrade_deps_block_check('XXXX', :eg_version);
-
-INSERT INTO config.org_unit_setting_type
-    (name, label, description, grp, datatype) 
-VALUES (
-    'ebook_api.oneclickdigital.library_id',
-    oils_i18n_gettext(
-        'ebook_api.oneclickdigital.library_id',
-        'OneClickdigital Library ID',
-        'coust',
-        'label'
-    ),
-    oils_i18n_gettext(
-        'ebook_api.oneclickdigital.library_id',
-        'Identifier assigned to this library by OneClickdigital',
-        'coust',
-        'description'
-    ),
-    'ebook_api',
-    'string'
-),(
-    'ebook_api.oneclickdigital.basic_token',
-    oils_i18n_gettext(
-        'ebook_api.oneclickdigital.basic_token',
-        'OneClickdigital Basic Token',
-        'coust',
-        'label'
-    ),
-    oils_i18n_gettext(
-        'ebook_api.oneclickdigital.basic_token',
-        'Basic token for client authentication with OneClickdigital API (supplied by OneClickdigital)',
-        'coust',
-        'description'
-    ),
-    'ebook_api',
-    'string'
-);
-
-COMMIT;
-
diff --git a/Open-ILS/src/sql/Pg/upgrade/XXXX.data.org-setting.ebook-api-overdrive.sql b/Open-ILS/src/sql/Pg/upgrade/XXXX.data.org-setting.ebook-api-overdrive.sql
deleted file mode 100644 (file)
index bbcf92c..0000000
+++ /dev/null
@@ -1,141 +0,0 @@
-BEGIN;
-
-SELECT evergreen.upgrade_deps_block_check('XXXX', :eg_version);
-
-INSERT INTO config.settings_group (name, label)
-    VALUES ('ebook_api', 'Ebook API Integration');
-
-INSERT INTO config.org_unit_setting_type
-    (name, label, description, grp, datatype) 
-VALUES (
-    'ebook_api.overdrive.discovery_base_uri',
-    oils_i18n_gettext(
-        'ebook_api.overdrive.discovery_base_uri',
-        'OverDrive Discovery API Base URI',
-        'coust',
-        'label'
-    ),
-    oils_i18n_gettext(
-        'ebook_api.overdrive.discovery_base_uri',
-        'Base URI for OverDrive Discovery API (defaults to https://api.overdrive.com/v1). Using HTTPS here is strongly encouraged.',
-        'coust',
-        'description'
-    ),
-    'ebook_api',
-    'string'
-),(
-    'ebook_api.overdrive.circulation_base_uri',
-    oils_i18n_gettext(
-        'ebook_api.overdrive.circulation_base_uri',
-        'OverDrive Circulation API Base URI',
-        'coust',
-        'label'
-    ),
-    oils_i18n_gettext(
-        'ebook_api.overdrive.circulation_base_uri',
-        'Base URI for OverDrive Circulation API (defaults to https://patron.api.overdrive.com/v1). Using HTTPS here is strongly encouraged.',
-        'coust',
-        'description'
-    ),
-    'ebook_api',
-    'string'
-),(
-    'ebook_api.overdrive.account_id',
-    oils_i18n_gettext(
-        'ebook_api.overdrive.account_id',
-        'OverDrive Account ID',
-        'coust',
-        'label'
-    ),
-    oils_i18n_gettext(
-        'ebook_api.overdrive.account_id',
-        'Account ID (a.k.a. Library ID) for this library, as assigned by OverDrive',
-        'coust',
-        'description'
-    ),
-    'ebook_api',
-    'string'
-),(
-    'ebook_api.overdrive.websiteid',
-    oils_i18n_gettext(
-        'ebook_api.overdrive.websiteid',
-        'OverDrive Website ID',
-        'coust',
-        'label'
-    ),
-    oils_i18n_gettext(
-        'ebook_api.overdrive.websiteid',
-        'Website ID for this library, as assigned by OverDrive',
-        'coust',
-        'description'
-    ),
-    'ebook_api',
-    'string'
-),(
-    'ebook_api.overdrive.authorizationname',
-    oils_i18n_gettext(
-        'ebook_api.overdrive.authorizationname',
-        'OverDrive Authorization Name',
-        'coust',
-        'label'
-    ),
-    oils_i18n_gettext(
-        'ebook_api.overdrive.authorizationname',
-        'Authorization name for this library, as assigned by OverDrive',
-        'coust',
-        'description'
-    ),
-    'ebook_api',
-    'string'
-),(
-    'ebook_api.overdrive.basic_token',
-    oils_i18n_gettext(
-        'ebook_api.overdrive.basic_token',
-        'OverDrive Basic Token',
-        'coust',
-        'label'
-    ),
-    oils_i18n_gettext(
-        'ebook_api.overdrive.basic_token',
-        'Basic token for client authentication with OverDrive API (supplied by OverDrive)',
-        'coust',
-        'description'
-    ),
-    'ebook_api',
-    'string'
-),(
-    'ebook_api.overdrive.granted_auth_redirect_uri',
-    oils_i18n_gettext(
-        'ebook_api.overdrive.granted_auth_redirect_uri',
-        'OverDrive Granted Authorization Redirect URI',
-        'coust',
-        'label'
-    ),
-    oils_i18n_gettext(
-        'ebook_api.overdrive.granted_auth_redirect_uri',
-        'URI provided to OverDrive for use with granted authorization',
-        'coust',
-        'description'
-    ),
-    'ebook_api',
-    'string'
-),(
-    'ebook_api.overdrive.password_required',
-    oils_i18n_gettext(
-        'ebook_api.overdrive.password_required',
-        'OverDrive Password Required',
-        'coust',
-        'label'
-    ),
-    oils_i18n_gettext(
-        'ebook_api.overdrive.password_required',
-        'Does this library require a password when authenticating patrons with the OverDrive API?',
-        'coust',
-        'description'
-    ),
-    'ebook_api',
-    'bool'
-);
-
-COMMIT;
-