From 8b8a84aeadc6f18c49373efb69d5bd821959f9bb Mon Sep 17 00:00:00 2001 From: Bill Erickson Date: Fri, 19 Aug 2016 16:27:43 -0400 Subject: [PATCH] JBAS-1541 Freegalsip user activity type Signed-off-by: Bill Erickson --- KCLS/sql/schema/deploy/sip-act-type-freegalsip.sql | 18 ++++++++++++++++++ KCLS/sql/schema/revert/sip-act-type-freegalsip.sql | 14 ++++++++++++++ KCLS/sql/schema/sqitch.plan | 1 + KCLS/sql/schema/verify/sip-act-type-freegalsip.sql | 7 +++++++ 4 files changed, 40 insertions(+) create mode 100644 KCLS/sql/schema/deploy/sip-act-type-freegalsip.sql create mode 100644 KCLS/sql/schema/revert/sip-act-type-freegalsip.sql create mode 100644 KCLS/sql/schema/verify/sip-act-type-freegalsip.sql diff --git a/KCLS/sql/schema/deploy/sip-act-type-freegalsip.sql b/KCLS/sql/schema/deploy/sip-act-type-freegalsip.sql new file mode 100644 index 0000000000..da966f33b5 --- /dev/null +++ b/KCLS/sql/schema/deploy/sip-act-type-freegalsip.sql @@ -0,0 +1,18 @@ +-- Deploy kcls-evergreen:sip-act-type-freegalsip to pg +-- requires: payflow-hosted-org-settings + +BEGIN; + +DO $$ +BEGIN + IF evergreen.insert_on_deploy() THEN + INSERT INTO config.usr_activity_type + (ewho, ewhat, ehow, label, egroup, enabled, transient) + VALUES + ('freegalsip', 'verify', 'sip2', + 'Freegal User Verification (via SIP)', 'authz', TRUE, FALSE); + END IF; +END $$; + + +COMMIT; diff --git a/KCLS/sql/schema/revert/sip-act-type-freegalsip.sql b/KCLS/sql/schema/revert/sip-act-type-freegalsip.sql new file mode 100644 index 0000000000..622e7d8448 --- /dev/null +++ b/KCLS/sql/schema/revert/sip-act-type-freegalsip.sql @@ -0,0 +1,14 @@ +-- Revert kcls-evergreen:sip-act-type-freegalsip from pg + +BEGIN; + +DELETE FROM actor.usr_activity + WHERE etype IN ( + SELECT id + FROM config.usr_activity_type + WHERE ewho IN ('freegalsip'); + ); + +DELETE FROM config.usr_activity_type WHERE ewho IN ('freegalsip') + +COMMIT; diff --git a/KCLS/sql/schema/sqitch.plan b/KCLS/sql/schema/sqitch.plan index b3188da038..cb65197949 100644 --- a/KCLS/sql/schema/sqitch.plan +++ b/KCLS/sql/schema/sqitch.plan @@ -28,3 +28,4 @@ connexion-auth-imports [sip-activity-types] 2016-05-11T15:10:49Z Bill Erickson,, purge-user-activity [sip-activity-types] 2016-04-29T17:07:46Z Bill Erickson # Clean up actor.usr_activity vand-auth-edit-date [purge-user-activity] 2016-06-01T18:24:54Z Bill Erickson # Vandelay authority import sets edit[or|_date] payflow-hosted-org-settings [vand-auth-edit-date] 2016-07-06T18:39:40Z Bill Erickson # PayflowPro Hosted Pages org unit settings +sip-act-type-freegalsip [payflow-hosted-org-settings] 2016-08-19T20:24:01Z Bill Erickson # User activity type for freegalsip login diff --git a/KCLS/sql/schema/verify/sip-act-type-freegalsip.sql b/KCLS/sql/schema/verify/sip-act-type-freegalsip.sql new file mode 100644 index 0000000000..2f8d701e74 --- /dev/null +++ b/KCLS/sql/schema/verify/sip-act-type-freegalsip.sql @@ -0,0 +1,7 @@ +-- Verify kcls-evergreen:sip-act-type-freegalsip on pg + +BEGIN; + +-- XXX Add verifications here. + +ROLLBACK; -- 2.11.0