From 0d1944aa77d511b656eb1cf9ab17a1e4fe693f84 Mon Sep 17 00:00:00 2001 From: Martha Driscoll Date: Wed, 19 Feb 2020 15:34:39 -0500 Subject: [PATCH] LP#1818144: Add upgrade script and seed data Added a database upgrade script and updated seed data with a new config.org_unit_setting_type for ebook_api.overdrive.availability_base_uri. --- Open-ILS/src/sql/Pg/950.data.seed-values.sql | 16 +++++++++++++ ...p1818144-org-setting-ebook-api-availability.sql | 28 ++++++++++++++++++++++ 2 files changed, 44 insertions(+) create mode 100644 Open-ILS/src/sql/Pg/upgrade/XXXX.data.lp1818144-org-setting-ebook-api-availability.sql diff --git a/Open-ILS/src/sql/Pg/950.data.seed-values.sql b/Open-ILS/src/sql/Pg/950.data.seed-values.sql index a49cf02de8..fc2c26b3c7 100644 --- a/Open-ILS/src/sql/Pg/950.data.seed-values.sql +++ b/Open-ILS/src/sql/Pg/950.data.seed-values.sql @@ -17361,6 +17361,22 @@ VALUES ( 'ebook_api', 'string' ),( + 'ebook_api.overdrive.availability_base_uri', + oils_i18n_gettext( + 'ebook_api.overdrive.availability_base_uri', + 'OverDrive Circulation API Base URI', + 'coust', + 'label' + ), + oils_i18n_gettext( + 'ebook_api.overdrive.availability_base_uri', + 'Base URI for OverDrive Availability API (defaults to https://api.overdrive.com/v2). Using HTTPS here is strongly encouraged.', + 'coust', + 'description' + ), + 'ebook_api', + 'string' +),( 'ebook_api.overdrive.account_id', oils_i18n_gettext( 'ebook_api.overdrive.account_id', diff --git a/Open-ILS/src/sql/Pg/upgrade/XXXX.data.lp1818144-org-setting-ebook-api-availability.sql b/Open-ILS/src/sql/Pg/upgrade/XXXX.data.lp1818144-org-setting-ebook-api-availability.sql new file mode 100644 index 0000000000..7a3a5fbfff --- /dev/null +++ b/Open-ILS/src/sql/Pg/upgrade/XXXX.data.lp1818144-org-setting-ebook-api-availability.sql @@ -0,0 +1,28 @@ +-- Evergreen DB patch XXXX.data.lp1818144-org-setting-ebook-api-availability.sql +-- +BEGIN; + +-- check whether patch can be applied +SELECT evergreen.upgrade_deps_block_check('XXXX', :eg_version); + +INSERT INTO config.org_unit_setting_type + (name, label, description, grp, datatype) +VALUES ( + 'ebook_api.overdrive.availability_base_uri', + oils_i18n_gettext( + 'ebook_api.overdrive.availability_base_uri', + 'OverDrive Availability API Base URI', + 'coust', + 'label' + ), + oils_i18n_gettext( + 'ebook_api.overdrive.availability_base_uri', + 'Base URI for OverDrive Availability API (defaults to https://api.overdrive.com/v2). Using HTTPS here is strongly encouraged.', + 'coust', + 'description' + ), + 'ebook_api', + 'string' +); + +COMMIT; -- 2.11.0