From 31eab3e3daf5f937254447cff29d0968c0b85037 Mon Sep 17 00:00:00 2001 From: Bill Erickson Date: Tue, 3 Apr 2018 11:10:38 -0400 Subject: [PATCH] JBAS-1969 Disable sqitch verify Disable the 'verify' option and remove all of the stub verify scripts. We've never used it. Signed-off-by: Bill Erickson --- KCLS/sql/schema/sqitch.conf | 5 ++-- KCLS/sql/schema/verify/01.2.4.1-2.5.7-upgrade.sql | 7 ------ .../schema/verify/02.collection-hq-items-2.5.sql | 7 ------ KCLS/sql/schema/verify/2.10-to-2.12-upgrade.sql | 7 ------ KCLS/sql/schema/verify/2.5-to-2.7-upgrade.sql | 7 ------ KCLS/sql/schema/verify/2.7-auth-reingest.sql | 7 ------ .../schema/verify/2.7-to-2.9-upgrade-part-2.sql | 7 ------ KCLS/sql/schema/verify/2.7-to-2.9-upgrade.sql | 7 ------ .../schema/verify/2.9-to-2.10-upgrade-reingest.sql | 7 ------ KCLS/sql/schema/verify/2.9-to-2.10-upgrade.sql | 7 ------ ...1765-reingest-causing-false-browse-headings.sql | 7 ------ .../verify/KMAIN_1448_Bug_from_KMAIN_268.sql | 7 ------ .../verify/KMAIN_1729_Bug_from_KMAIN_268.sql | 7 ------ KCLS/sql/schema/verify/aged-circs-api.sql | 7 ------ KCLS/sql/schema/verify/at-purge-interval-data.sql | 7 ------ KCLS/sql/schema/verify/at-purge-interval.sql | 7 ------ KCLS/sql/schema/verify/audit-table-maint.sql | 7 ------ KCLS/sql/schema/verify/auth-prop-mods-bib-meta.sql | 7 ------ .../schema/verify/auth-prop-partial-matches.sql | 7 ------ .../schema/verify/backstage-exports-continued.sql | 7 ------ .../schema/verify/blanket-po-print-template.sql | 7 ------ KCLS/sql/schema/verify/blanket-po.sql | 7 ------ KCLS/sql/schema/verify/browse-mattype-filter.sql | 7 ------ .../schema/verify/checkout-ok-2.10-recovery.sql | 7 ------ .../schema/verify/collection-hq-floating-case.sql | 7 ------ KCLS/sql/schema/verify/connexion-auth-imports.sql | 7 ------ KCLS/sql/schema/verify/copy-stat-checkout-ok.sql | 8 ------- KCLS/sql/schema/verify/copy-status-alerts.sql | 7 ------ KCLS/sql/schema/verify/dob-as-date.sql | 12 ---------- KCLS/sql/schema/verify/drop-cc-cols.sql | 7 ------ KCLS/sql/schema/verify/hold-queue-pos-func.sql | 7 ------ .../schema/verify/hold-queue-pos-materialized.sql | 7 ------ KCLS/sql/schema/verify/hold-targeter-v2.sql | 7 ------ KCLS/sql/schema/verify/ingram-edi-mods.sql | 7 ------ KCLS/sql/schema/verify/insert-on-deploy.sql | 7 ------ KCLS/sql/schema/verify/kcls-2.4-base-prod.sql | 7 ------ KCLS/sql/schema/verify/new-headings-mattype.sql | 7 ------ KCLS/sql/schema/verify/new-headings-report.sql | 7 ------ KCLS/sql/schema/verify/org-phones.sql | 7 ------ KCLS/sql/schema/verify/org-unit-addrs-copy.sql | 7 ------ KCLS/sql/schema/verify/outreach-si-profile.sql | 7 ------ .../schema/verify/patron-co-history-stage-1.sql | 7 ------ .../schema/verify/patron-co-history-stage-2.sql | 7 ------ KCLS/sql/schema/verify/patron-merge-co-history.sql | 7 ------ KCLS/sql/schema/verify/patron-self-reg-mods.sql | 27 ---------------------- .../schema/verify/payflow-hosted-org-settings.sql | 7 ------ .../payflow-hosted-static-silent-post-url.sql | 7 ------ KCLS/sql/schema/verify/pg-9.6-prep.sql | 7 ------ .../schema/verify/po-print-li-count-and-date.sql | 7 ------ KCLS/sql/schema/verify/purge-holds.sql | 7 ------ KCLS/sql/schema/verify/purge-user-activity.sql | 7 ------ .../schema/verify/revert-custom-hold-counts.sql | 7 ------ KCLS/sql/schema/verify/revert-custom-qstats.sql | 7 ------ .../schema/verify/search-strip-apos-recover.sql | 8 ------- .../schema/verify/self-reg-net-access-level.sql | 7 ------ .../sql/schema/verify/selfcheck-email-receipts.sql | 7 ------ KCLS/sql/schema/verify/sip-act-type-freegalsip.sql | 7 ------ KCLS/sql/schema/verify/sip-activity-types.sql | 7 ------ KCLS/sql/schema/verify/student-groups.sql | 7 ------ .../schema/verify/subject-browse-entry-dashes.sql | 7 ------ KCLS/sql/schema/verify/teacher-group.sql | 7 ------ KCLS/sql/schema/verify/vand-auth-edit-date.sql | 7 ------ .../schema/verify/vand-delete-speed-indexes.sql | 7 ------ .../schema/verify/vand-import-edit-date-fix.sql | 7 ------ 64 files changed, 2 insertions(+), 471 deletions(-) delete mode 100644 KCLS/sql/schema/verify/01.2.4.1-2.5.7-upgrade.sql delete mode 100644 KCLS/sql/schema/verify/02.collection-hq-items-2.5.sql delete mode 100644 KCLS/sql/schema/verify/2.10-to-2.12-upgrade.sql delete mode 100644 KCLS/sql/schema/verify/2.5-to-2.7-upgrade.sql delete mode 100644 KCLS/sql/schema/verify/2.7-auth-reingest.sql delete mode 100644 KCLS/sql/schema/verify/2.7-to-2.9-upgrade-part-2.sql delete mode 100644 KCLS/sql/schema/verify/2.7-to-2.9-upgrade.sql delete mode 100644 KCLS/sql/schema/verify/2.9-to-2.10-upgrade-reingest.sql delete mode 100644 KCLS/sql/schema/verify/2.9-to-2.10-upgrade.sql delete mode 100644 KCLS/sql/schema/verify/KMAIN-1765-reingest-causing-false-browse-headings.sql delete mode 100644 KCLS/sql/schema/verify/KMAIN_1448_Bug_from_KMAIN_268.sql delete mode 100644 KCLS/sql/schema/verify/KMAIN_1729_Bug_from_KMAIN_268.sql delete mode 100644 KCLS/sql/schema/verify/aged-circs-api.sql delete mode 100644 KCLS/sql/schema/verify/at-purge-interval-data.sql delete mode 100644 KCLS/sql/schema/verify/at-purge-interval.sql delete mode 100644 KCLS/sql/schema/verify/audit-table-maint.sql delete mode 100644 KCLS/sql/schema/verify/auth-prop-mods-bib-meta.sql delete mode 100644 KCLS/sql/schema/verify/auth-prop-partial-matches.sql delete mode 100644 KCLS/sql/schema/verify/backstage-exports-continued.sql delete mode 100644 KCLS/sql/schema/verify/blanket-po-print-template.sql delete mode 100644 KCLS/sql/schema/verify/blanket-po.sql delete mode 100644 KCLS/sql/schema/verify/browse-mattype-filter.sql delete mode 100644 KCLS/sql/schema/verify/checkout-ok-2.10-recovery.sql delete mode 100644 KCLS/sql/schema/verify/collection-hq-floating-case.sql delete mode 100644 KCLS/sql/schema/verify/connexion-auth-imports.sql delete mode 100644 KCLS/sql/schema/verify/copy-stat-checkout-ok.sql delete mode 100644 KCLS/sql/schema/verify/copy-status-alerts.sql delete mode 100644 KCLS/sql/schema/verify/dob-as-date.sql delete mode 100644 KCLS/sql/schema/verify/drop-cc-cols.sql delete mode 100644 KCLS/sql/schema/verify/hold-queue-pos-func.sql delete mode 100644 KCLS/sql/schema/verify/hold-queue-pos-materialized.sql delete mode 100644 KCLS/sql/schema/verify/hold-targeter-v2.sql delete mode 100644 KCLS/sql/schema/verify/ingram-edi-mods.sql delete mode 100644 KCLS/sql/schema/verify/insert-on-deploy.sql delete mode 100644 KCLS/sql/schema/verify/kcls-2.4-base-prod.sql delete mode 100644 KCLS/sql/schema/verify/new-headings-mattype.sql delete mode 100644 KCLS/sql/schema/verify/new-headings-report.sql delete mode 100644 KCLS/sql/schema/verify/org-phones.sql delete mode 100644 KCLS/sql/schema/verify/org-unit-addrs-copy.sql delete mode 100644 KCLS/sql/schema/verify/outreach-si-profile.sql delete mode 100644 KCLS/sql/schema/verify/patron-co-history-stage-1.sql delete mode 100644 KCLS/sql/schema/verify/patron-co-history-stage-2.sql delete mode 100644 KCLS/sql/schema/verify/patron-merge-co-history.sql delete mode 100644 KCLS/sql/schema/verify/patron-self-reg-mods.sql delete mode 100644 KCLS/sql/schema/verify/payflow-hosted-org-settings.sql delete mode 100644 KCLS/sql/schema/verify/payflow-hosted-static-silent-post-url.sql delete mode 100644 KCLS/sql/schema/verify/pg-9.6-prep.sql delete mode 100644 KCLS/sql/schema/verify/po-print-li-count-and-date.sql delete mode 100644 KCLS/sql/schema/verify/purge-holds.sql delete mode 100644 KCLS/sql/schema/verify/purge-user-activity.sql delete mode 100644 KCLS/sql/schema/verify/revert-custom-hold-counts.sql delete mode 100644 KCLS/sql/schema/verify/revert-custom-qstats.sql delete mode 100644 KCLS/sql/schema/verify/search-strip-apos-recover.sql delete mode 100644 KCLS/sql/schema/verify/self-reg-net-access-level.sql delete mode 100644 KCLS/sql/schema/verify/selfcheck-email-receipts.sql delete mode 100644 KCLS/sql/schema/verify/sip-act-type-freegalsip.sql delete mode 100644 KCLS/sql/schema/verify/sip-activity-types.sql delete mode 100644 KCLS/sql/schema/verify/student-groups.sql delete mode 100644 KCLS/sql/schema/verify/subject-browse-entry-dashes.sql delete mode 100644 KCLS/sql/schema/verify/teacher-group.sql delete mode 100644 KCLS/sql/schema/verify/vand-auth-edit-date.sql delete mode 100644 KCLS/sql/schema/verify/vand-delete-speed-indexes.sql delete mode 100644 KCLS/sql/schema/verify/vand-import-edit-date-fix.sql diff --git a/KCLS/sql/schema/sqitch.conf b/KCLS/sql/schema/sqitch.conf index f3ce0432dc..51791cda15 100644 --- a/KCLS/sql/schema/sqitch.conf +++ b/KCLS/sql/schema/sqitch.conf @@ -6,9 +6,8 @@ [engine "pg"] target = evergreen [deploy] - verify = true # only revert the last (failed) change by default. # this helps avoid an unintended chain reaction of reverts. mode = change -[rebase] - verify = true +[add] + with_verify = false diff --git a/KCLS/sql/schema/verify/01.2.4.1-2.5.7-upgrade.sql b/KCLS/sql/schema/verify/01.2.4.1-2.5.7-upgrade.sql deleted file mode 100644 index c2e33bc16e..0000000000 --- a/KCLS/sql/schema/verify/01.2.4.1-2.5.7-upgrade.sql +++ /dev/null @@ -1,7 +0,0 @@ --- Verify kcls-evergreen:01.2.4.1-2.5.7-upgrade on pg - -BEGIN; - --- NO VERIFY FOR PRE-SQITCH DEPLOYMENTS - -ROLLBACK; diff --git a/KCLS/sql/schema/verify/02.collection-hq-items-2.5.sql b/KCLS/sql/schema/verify/02.collection-hq-items-2.5.sql deleted file mode 100644 index 55dc62a775..0000000000 --- a/KCLS/sql/schema/verify/02.collection-hq-items-2.5.sql +++ /dev/null @@ -1,7 +0,0 @@ --- Verify kcls-evergreen:02.collection-hq-items-2.5 on pg - -BEGIN; - --- NO VERIFY FOR PRE-SQITCH DEPLOYMENTS - -ROLLBACK; diff --git a/KCLS/sql/schema/verify/2.10-to-2.12-upgrade.sql b/KCLS/sql/schema/verify/2.10-to-2.12-upgrade.sql deleted file mode 100644 index b77183bc9e..0000000000 --- a/KCLS/sql/schema/verify/2.10-to-2.12-upgrade.sql +++ /dev/null @@ -1,7 +0,0 @@ --- Verify kcls-evergreen:2.10-to-2.12-upgrade on pg - -BEGIN; - --- XXX Add verifications here. - -ROLLBACK; diff --git a/KCLS/sql/schema/verify/2.5-to-2.7-upgrade.sql b/KCLS/sql/schema/verify/2.5-to-2.7-upgrade.sql deleted file mode 100644 index 2d30c77f5e..0000000000 --- a/KCLS/sql/schema/verify/2.5-to-2.7-upgrade.sql +++ /dev/null @@ -1,7 +0,0 @@ --- Verify kcls-evergreen:2.5-to-2.7-upgrade on pg - -BEGIN; - --- XXX Add verifications here. - -ROLLBACK; diff --git a/KCLS/sql/schema/verify/2.7-auth-reingest.sql b/KCLS/sql/schema/verify/2.7-auth-reingest.sql deleted file mode 100644 index ee751361b9..0000000000 --- a/KCLS/sql/schema/verify/2.7-auth-reingest.sql +++ /dev/null @@ -1,7 +0,0 @@ --- Verify kcls-evergreen:2.7-auth-reingest on pg - -BEGIN; - --- XXX Add verifications here. - -ROLLBACK; diff --git a/KCLS/sql/schema/verify/2.7-to-2.9-upgrade-part-2.sql b/KCLS/sql/schema/verify/2.7-to-2.9-upgrade-part-2.sql deleted file mode 100644 index 858087a687..0000000000 --- a/KCLS/sql/schema/verify/2.7-to-2.9-upgrade-part-2.sql +++ /dev/null @@ -1,7 +0,0 @@ --- Verify kcls-evergreen:2.7-to-2.9-upgrade-part-2 on pg - -BEGIN; - --- XXX Add verifications here. - -ROLLBACK; diff --git a/KCLS/sql/schema/verify/2.7-to-2.9-upgrade.sql b/KCLS/sql/schema/verify/2.7-to-2.9-upgrade.sql deleted file mode 100644 index 98447d4d54..0000000000 --- a/KCLS/sql/schema/verify/2.7-to-2.9-upgrade.sql +++ /dev/null @@ -1,7 +0,0 @@ --- Verify kcls-evergreen:2.7-to-2.9-upgrade on pg - -BEGIN; - --- XXX Add verifications here. - -ROLLBACK; diff --git a/KCLS/sql/schema/verify/2.9-to-2.10-upgrade-reingest.sql b/KCLS/sql/schema/verify/2.9-to-2.10-upgrade-reingest.sql deleted file mode 100644 index 713a5cb966..0000000000 --- a/KCLS/sql/schema/verify/2.9-to-2.10-upgrade-reingest.sql +++ /dev/null @@ -1,7 +0,0 @@ --- Verify kcls-evergreen:2.9-to-2.10-upgrade-reingest on pg - -BEGIN; - --- XXX Add verifications here. - -ROLLBACK; diff --git a/KCLS/sql/schema/verify/2.9-to-2.10-upgrade.sql b/KCLS/sql/schema/verify/2.9-to-2.10-upgrade.sql deleted file mode 100644 index 48888c9586..0000000000 --- a/KCLS/sql/schema/verify/2.9-to-2.10-upgrade.sql +++ /dev/null @@ -1,7 +0,0 @@ --- Verify kcls-evergreen:2.9-to-2.10-upgrade on pg - -BEGIN; - --- XXX Add verifications here. - -ROLLBACK; diff --git a/KCLS/sql/schema/verify/KMAIN-1765-reingest-causing-false-browse-headings.sql b/KCLS/sql/schema/verify/KMAIN-1765-reingest-causing-false-browse-headings.sql deleted file mode 100644 index 3778ace173..0000000000 --- a/KCLS/sql/schema/verify/KMAIN-1765-reingest-causing-false-browse-headings.sql +++ /dev/null @@ -1,7 +0,0 @@ --- Verify kcls-evergreen:KMAIN-1765-reingest-causing-false-browse-headings on pg - -BEGIN; - --- NO VERIFY FOR PRE-SQITCH DEPLOYMENTS - -ROLLBACK; diff --git a/KCLS/sql/schema/verify/KMAIN_1448_Bug_from_KMAIN_268.sql b/KCLS/sql/schema/verify/KMAIN_1448_Bug_from_KMAIN_268.sql deleted file mode 100644 index aba3bff51f..0000000000 --- a/KCLS/sql/schema/verify/KMAIN_1448_Bug_from_KMAIN_268.sql +++ /dev/null @@ -1,7 +0,0 @@ --- Verify kcls-evergreen:KMAIN_1448_Bug_from_KMAIN_268 on pg - -BEGIN; - --- NO VERIFY FOR PRE-SQITCH DEPLOYMENTS - -ROLLBACK; diff --git a/KCLS/sql/schema/verify/KMAIN_1729_Bug_from_KMAIN_268.sql b/KCLS/sql/schema/verify/KMAIN_1729_Bug_from_KMAIN_268.sql deleted file mode 100644 index 45d6793948..0000000000 --- a/KCLS/sql/schema/verify/KMAIN_1729_Bug_from_KMAIN_268.sql +++ /dev/null @@ -1,7 +0,0 @@ --- Verify kcls-evergreen:KMAIN_1729_Bug_from_KMAIN_268 on pg - -BEGIN; - --- NO VERIFY FOR PRE-SQITCH DEPLOYMENTS - -ROLLBACK; diff --git a/KCLS/sql/schema/verify/aged-circs-api.sql b/KCLS/sql/schema/verify/aged-circs-api.sql deleted file mode 100644 index a065ff079a..0000000000 --- a/KCLS/sql/schema/verify/aged-circs-api.sql +++ /dev/null @@ -1,7 +0,0 @@ --- Verify kcls-evergreen:aged-circs-api on pg - -BEGIN; - --- XXX Add verifications here. - -ROLLBACK; diff --git a/KCLS/sql/schema/verify/at-purge-interval-data.sql b/KCLS/sql/schema/verify/at-purge-interval-data.sql deleted file mode 100644 index f06b6791d7..0000000000 --- a/KCLS/sql/schema/verify/at-purge-interval-data.sql +++ /dev/null @@ -1,7 +0,0 @@ --- Verify kcls-evergreen:at-purge-interval-data on pg - -BEGIN; - --- XXX Add verifications here. - -ROLLBACK; diff --git a/KCLS/sql/schema/verify/at-purge-interval.sql b/KCLS/sql/schema/verify/at-purge-interval.sql deleted file mode 100644 index f8bbc4e5ee..0000000000 --- a/KCLS/sql/schema/verify/at-purge-interval.sql +++ /dev/null @@ -1,7 +0,0 @@ --- Verify kcls-evergreen:at-purge-interval on pg - -BEGIN; - --- XXX Add verifications here. - -ROLLBACK; diff --git a/KCLS/sql/schema/verify/audit-table-maint.sql b/KCLS/sql/schema/verify/audit-table-maint.sql deleted file mode 100644 index 8556645ee4..0000000000 --- a/KCLS/sql/schema/verify/audit-table-maint.sql +++ /dev/null @@ -1,7 +0,0 @@ --- Verify kcls-evergreen:audit-table-maint on pg - -BEGIN; - --- XXX Add verifications here. - -ROLLBACK; diff --git a/KCLS/sql/schema/verify/auth-prop-mods-bib-meta.sql b/KCLS/sql/schema/verify/auth-prop-mods-bib-meta.sql deleted file mode 100644 index f883579fda..0000000000 --- a/KCLS/sql/schema/verify/auth-prop-mods-bib-meta.sql +++ /dev/null @@ -1,7 +0,0 @@ --- Verify kcls-evergreen:auth-prop-mods-bib-meta on pg - -BEGIN; - --- XXX Add verifications here. - -ROLLBACK; diff --git a/KCLS/sql/schema/verify/auth-prop-partial-matches.sql b/KCLS/sql/schema/verify/auth-prop-partial-matches.sql deleted file mode 100644 index c22d24f723..0000000000 --- a/KCLS/sql/schema/verify/auth-prop-partial-matches.sql +++ /dev/null @@ -1,7 +0,0 @@ --- Verify kcls-evergreen:auth-prop-partial-matches on pg - -BEGIN; - --- XXX Add verifications here. - -ROLLBACK; diff --git a/KCLS/sql/schema/verify/backstage-exports-continued.sql b/KCLS/sql/schema/verify/backstage-exports-continued.sql deleted file mode 100644 index 50058dae78..0000000000 --- a/KCLS/sql/schema/verify/backstage-exports-continued.sql +++ /dev/null @@ -1,7 +0,0 @@ --- Verify kcls-evergreen:backstage-exports-continued on pg - -BEGIN; - --- XXX Add verifications here. - -ROLLBACK; diff --git a/KCLS/sql/schema/verify/blanket-po-print-template.sql b/KCLS/sql/schema/verify/blanket-po-print-template.sql deleted file mode 100644 index a39394335a..0000000000 --- a/KCLS/sql/schema/verify/blanket-po-print-template.sql +++ /dev/null @@ -1,7 +0,0 @@ --- Verify kcls-evergreen:blanket-po-print-template on pg - -BEGIN; - --- XXX Add verifications here. - -ROLLBACK; diff --git a/KCLS/sql/schema/verify/blanket-po.sql b/KCLS/sql/schema/verify/blanket-po.sql deleted file mode 100644 index 6197e656ce..0000000000 --- a/KCLS/sql/schema/verify/blanket-po.sql +++ /dev/null @@ -1,7 +0,0 @@ --- Verify kcls-evergreen:blanket-po on pg - -BEGIN; - -SELECT blanket FROM acq.invoice_item_type WHERE FALSE; - -ROLLBACK; diff --git a/KCLS/sql/schema/verify/browse-mattype-filter.sql b/KCLS/sql/schema/verify/browse-mattype-filter.sql deleted file mode 100644 index e5ef04cc91..0000000000 --- a/KCLS/sql/schema/verify/browse-mattype-filter.sql +++ /dev/null @@ -1,7 +0,0 @@ --- Verify kcls-evergreen:browse-mattype-filter on pg - -BEGIN; - --- XXX Add verifications here. - -ROLLBACK; diff --git a/KCLS/sql/schema/verify/checkout-ok-2.10-recovery.sql b/KCLS/sql/schema/verify/checkout-ok-2.10-recovery.sql deleted file mode 100644 index 4445149398..0000000000 --- a/KCLS/sql/schema/verify/checkout-ok-2.10-recovery.sql +++ /dev/null @@ -1,7 +0,0 @@ --- Verify kcls-evergreen:checkout-ok-2.10-recovery on pg - -BEGIN; - --- XXX Add verifications here. - -ROLLBACK; diff --git a/KCLS/sql/schema/verify/collection-hq-floating-case.sql b/KCLS/sql/schema/verify/collection-hq-floating-case.sql deleted file mode 100644 index 9c511930e4..0000000000 --- a/KCLS/sql/schema/verify/collection-hq-floating-case.sql +++ /dev/null @@ -1,7 +0,0 @@ --- Verify kcls-evergreen:collection-hq-floating-case on pg - -BEGIN; - --- XXX Add verifications here. - -ROLLBACK; diff --git a/KCLS/sql/schema/verify/connexion-auth-imports.sql b/KCLS/sql/schema/verify/connexion-auth-imports.sql deleted file mode 100644 index 4966b27299..0000000000 --- a/KCLS/sql/schema/verify/connexion-auth-imports.sql +++ /dev/null @@ -1,7 +0,0 @@ --- Verify kcls-evergreen:connexion-auth-imports on pg - -BEGIN; - --- XXX Add verifications here. - -ROLLBACK; diff --git a/KCLS/sql/schema/verify/copy-stat-checkout-ok.sql b/KCLS/sql/schema/verify/copy-stat-checkout-ok.sql deleted file mode 100644 index ebe27efeb9..0000000000 --- a/KCLS/sql/schema/verify/copy-stat-checkout-ok.sql +++ /dev/null @@ -1,8 +0,0 @@ --- Verify kcls-evergreen:copy-stat-checkout-ok on pg - -BEGIN; - --- will fail if new column does not exist -SELECT checkout_ok FROM config.copy_status WHERE FALSE; - -ROLLBACK; diff --git a/KCLS/sql/schema/verify/copy-status-alerts.sql b/KCLS/sql/schema/verify/copy-status-alerts.sql deleted file mode 100644 index dc0421ffcb..0000000000 --- a/KCLS/sql/schema/verify/copy-status-alerts.sql +++ /dev/null @@ -1,7 +0,0 @@ --- Verify kcls-evergreen:copy-status-alerts on pg - -BEGIN; - --- XXX Add verifications here. - -ROLLBACK; diff --git a/KCLS/sql/schema/verify/dob-as-date.sql b/KCLS/sql/schema/verify/dob-as-date.sql deleted file mode 100644 index a187e66cce..0000000000 --- a/KCLS/sql/schema/verify/dob-as-date.sql +++ /dev/null @@ -1,12 +0,0 @@ --- Verify kcls-evergreen:dob-as-date on pg - -BEGIN; - -SELECT 1/COUNT(*) - FROM information_schema.columns - WHERE column_name = 'dob' - AND table_name = 'usr' - AND table_schema = 'actor' - AND data_type = 'date'; - -ROLLBACK; diff --git a/KCLS/sql/schema/verify/drop-cc-cols.sql b/KCLS/sql/schema/verify/drop-cc-cols.sql deleted file mode 100644 index f28328420d..0000000000 --- a/KCLS/sql/schema/verify/drop-cc-cols.sql +++ /dev/null @@ -1,7 +0,0 @@ --- Verify kcls-evergreen:drop-cc-cols on pg - -BEGIN; - --- XXX Add verifications here. - -ROLLBACK; diff --git a/KCLS/sql/schema/verify/hold-queue-pos-func.sql b/KCLS/sql/schema/verify/hold-queue-pos-func.sql deleted file mode 100644 index 075a2b4915..0000000000 --- a/KCLS/sql/schema/verify/hold-queue-pos-func.sql +++ /dev/null @@ -1,7 +0,0 @@ --- Verify kcls-evergreen:hold-queue-pos-func on pg - -BEGIN; - --- XXX Add verifications here. - -ROLLBACK; diff --git a/KCLS/sql/schema/verify/hold-queue-pos-materialized.sql b/KCLS/sql/schema/verify/hold-queue-pos-materialized.sql deleted file mode 100644 index 2547cccbef..0000000000 --- a/KCLS/sql/schema/verify/hold-queue-pos-materialized.sql +++ /dev/null @@ -1,7 +0,0 @@ --- Verify kcls-evergreen:hold-queue-pos-materialized on pg - -BEGIN; - --- XXX Add verifications here. - -ROLLBACK; diff --git a/KCLS/sql/schema/verify/hold-targeter-v2.sql b/KCLS/sql/schema/verify/hold-targeter-v2.sql deleted file mode 100644 index e841b83278..0000000000 --- a/KCLS/sql/schema/verify/hold-targeter-v2.sql +++ /dev/null @@ -1,7 +0,0 @@ --- Verify kcls-evergreen:hold-targeter-v2 on pg - -BEGIN; - --- XXX Add verifications here. - -ROLLBACK; diff --git a/KCLS/sql/schema/verify/ingram-edi-mods.sql b/KCLS/sql/schema/verify/ingram-edi-mods.sql deleted file mode 100644 index d6c523cf6d..0000000000 --- a/KCLS/sql/schema/verify/ingram-edi-mods.sql +++ /dev/null @@ -1,7 +0,0 @@ --- Verify kcls-evergreen:ingram-edi-mods on pg - -BEGIN; - --- XXX Add verifications here. - -ROLLBACK; diff --git a/KCLS/sql/schema/verify/insert-on-deploy.sql b/KCLS/sql/schema/verify/insert-on-deploy.sql deleted file mode 100644 index aa1dc1d107..0000000000 --- a/KCLS/sql/schema/verify/insert-on-deploy.sql +++ /dev/null @@ -1,7 +0,0 @@ --- Verify kcls-evergreen:insert-on-deploy on pg - -BEGIN; - -SELECT has_function_privilege('evergreen.insert_on_deploy()', 'execute'); - -ROLLBACK; diff --git a/KCLS/sql/schema/verify/kcls-2.4-base-prod.sql b/KCLS/sql/schema/verify/kcls-2.4-base-prod.sql deleted file mode 100644 index ae478f33da..0000000000 --- a/KCLS/sql/schema/verify/kcls-2.4-base-prod.sql +++ /dev/null @@ -1,7 +0,0 @@ --- Verify kcls-evergreen:kcls-2.4-base-prod on pg - -BEGIN; - --- NO VERIFY FOR PRE-SQITCH DEPLOYMENTS - -ROLLBACK; diff --git a/KCLS/sql/schema/verify/new-headings-mattype.sql b/KCLS/sql/schema/verify/new-headings-mattype.sql deleted file mode 100644 index 5cbdcf1081..0000000000 --- a/KCLS/sql/schema/verify/new-headings-mattype.sql +++ /dev/null @@ -1,7 +0,0 @@ --- Verify kcls-evergreen:new-headings-mattype on pg - -BEGIN; - --- XXX Add verifications here. - -ROLLBACK; diff --git a/KCLS/sql/schema/verify/new-headings-report.sql b/KCLS/sql/schema/verify/new-headings-report.sql deleted file mode 100644 index 1ee44e2bd7..0000000000 --- a/KCLS/sql/schema/verify/new-headings-report.sql +++ /dev/null @@ -1,7 +0,0 @@ --- Verify kcls-evergreen:new-headings-report on pg - -BEGIN; - --- XXX Add verifications here. - -ROLLBACK; diff --git a/KCLS/sql/schema/verify/org-phones.sql b/KCLS/sql/schema/verify/org-phones.sql deleted file mode 100644 index 913e81821a..0000000000 --- a/KCLS/sql/schema/verify/org-phones.sql +++ /dev/null @@ -1,7 +0,0 @@ --- Verify kcls-evergreen:org-phones on pg - -BEGIN; - --- XXX Add verifications here. - -ROLLBACK; diff --git a/KCLS/sql/schema/verify/org-unit-addrs-copy.sql b/KCLS/sql/schema/verify/org-unit-addrs-copy.sql deleted file mode 100644 index 6c106b15f5..0000000000 --- a/KCLS/sql/schema/verify/org-unit-addrs-copy.sql +++ /dev/null @@ -1,7 +0,0 @@ --- Verify kcls-evergreen:org-unit-addrs-copy on pg - -BEGIN; - --- XXX Add verifications here. - -ROLLBACK; diff --git a/KCLS/sql/schema/verify/outreach-si-profile.sql b/KCLS/sql/schema/verify/outreach-si-profile.sql deleted file mode 100644 index ff67bb3b38..0000000000 --- a/KCLS/sql/schema/verify/outreach-si-profile.sql +++ /dev/null @@ -1,7 +0,0 @@ --- Verify kcls-evergreen:outreach-si-profile on pg - -BEGIN; - --- XXX Add verifications here. - -ROLLBACK; diff --git a/KCLS/sql/schema/verify/patron-co-history-stage-1.sql b/KCLS/sql/schema/verify/patron-co-history-stage-1.sql deleted file mode 100644 index 34c191039d..0000000000 --- a/KCLS/sql/schema/verify/patron-co-history-stage-1.sql +++ /dev/null @@ -1,7 +0,0 @@ --- Verify kcls-evergreen:patron-co-history-stage-1 on pg - -BEGIN; - --- XXX Add verifications here. - -ROLLBACK; diff --git a/KCLS/sql/schema/verify/patron-co-history-stage-2.sql b/KCLS/sql/schema/verify/patron-co-history-stage-2.sql deleted file mode 100644 index 101b1e0e75..0000000000 --- a/KCLS/sql/schema/verify/patron-co-history-stage-2.sql +++ /dev/null @@ -1,7 +0,0 @@ --- Verify kcls-evergreen:patron-co-history-table on pg - -BEGIN; - --- XXX Add verifications here. - -ROLLBACK; diff --git a/KCLS/sql/schema/verify/patron-merge-co-history.sql b/KCLS/sql/schema/verify/patron-merge-co-history.sql deleted file mode 100644 index dd031879c5..0000000000 --- a/KCLS/sql/schema/verify/patron-merge-co-history.sql +++ /dev/null @@ -1,7 +0,0 @@ --- Verify kcls-evergreen:patron-merge-co-history on pg - -BEGIN; - --- XXX Add verifications here. - -ROLLBACK; diff --git a/KCLS/sql/schema/verify/patron-self-reg-mods.sql b/KCLS/sql/schema/verify/patron-self-reg-mods.sql deleted file mode 100644 index 96e9e3d2fc..0000000000 --- a/KCLS/sql/schema/verify/patron-self-reg-mods.sql +++ /dev/null @@ -1,27 +0,0 @@ --- Verify kcls-evergreen:patron-self-reg-mods on pg - -BEGIN; - -SELECT ident_value2 FROM staging.user_stage LIMIT 1; - --- Test inserted data if needed -DO $$ -BEGIN - IF evergreen.insert_on_deploy() THEN - - PERFORM 1 / COUNT(*) FROM config.org_unit_setting_type - WHERE name = 'opac.self_register.profile'; - - PERFORM 1 / COUNT(*) FROM actor.org_unit_setting - WHERE name = 'opac.self_register.profile'; - - PERFORM 1 / COUNT(*) FROM actor.org_unit_setting - WHERE name = 'opac.allow_pending_user'; - - PERFORM 1 / COUNT(*) FROM actor.org_unit_setting - WHERE name = 'ui.patron.edit.au.ident_value2.show'; - END IF; - -END $$; - -ROLLBACK; diff --git a/KCLS/sql/schema/verify/payflow-hosted-org-settings.sql b/KCLS/sql/schema/verify/payflow-hosted-org-settings.sql deleted file mode 100644 index b399ad2315..0000000000 --- a/KCLS/sql/schema/verify/payflow-hosted-org-settings.sql +++ /dev/null @@ -1,7 +0,0 @@ --- Verify kcls-evergreen:payflow-hosted-org-settings on pg - -BEGIN; - --- XXX Add verifications here. - -ROLLBACK; diff --git a/KCLS/sql/schema/verify/payflow-hosted-static-silent-post-url.sql b/KCLS/sql/schema/verify/payflow-hosted-static-silent-post-url.sql deleted file mode 100644 index 889168e7f9..0000000000 --- a/KCLS/sql/schema/verify/payflow-hosted-static-silent-post-url.sql +++ /dev/null @@ -1,7 +0,0 @@ --- Verify kcls-evergreen:payflow-hosted-org-settings-urls on pg - -BEGIN; - --- XXX Add verifications here. - -ROLLBACK; diff --git a/KCLS/sql/schema/verify/pg-9.6-prep.sql b/KCLS/sql/schema/verify/pg-9.6-prep.sql deleted file mode 100644 index 1e182f2532..0000000000 --- a/KCLS/sql/schema/verify/pg-9.6-prep.sql +++ /dev/null @@ -1,7 +0,0 @@ --- Verify kcls-evergreen:pg-9.6-prep on pg - -BEGIN; - --- XXX Add verifications here. - -ROLLBACK; diff --git a/KCLS/sql/schema/verify/po-print-li-count-and-date.sql b/KCLS/sql/schema/verify/po-print-li-count-and-date.sql deleted file mode 100644 index 616f02c574..0000000000 --- a/KCLS/sql/schema/verify/po-print-li-count-and-date.sql +++ /dev/null @@ -1,7 +0,0 @@ --- Verify kcls-evergreen:po-print-li-count-and-date on pg - -BEGIN; - --- XXX Add verifications here. - -ROLLBACK; diff --git a/KCLS/sql/schema/verify/purge-holds.sql b/KCLS/sql/schema/verify/purge-holds.sql deleted file mode 100644 index fd7a2fc063..0000000000 --- a/KCLS/sql/schema/verify/purge-holds.sql +++ /dev/null @@ -1,7 +0,0 @@ --- Verify kcls-evergreen:purge-holds on pg - -BEGIN; - --- XXX Add verifications here. - -ROLLBACK; diff --git a/KCLS/sql/schema/verify/purge-user-activity.sql b/KCLS/sql/schema/verify/purge-user-activity.sql deleted file mode 100644 index 4587b5bc0c..0000000000 --- a/KCLS/sql/schema/verify/purge-user-activity.sql +++ /dev/null @@ -1,7 +0,0 @@ --- Verify kcls-evergreen:purge-user-activity on pg - -BEGIN; - --- XXX Add verifications here. - -ROLLBACK; diff --git a/KCLS/sql/schema/verify/revert-custom-hold-counts.sql b/KCLS/sql/schema/verify/revert-custom-hold-counts.sql deleted file mode 100644 index 9845c3bb6b..0000000000 --- a/KCLS/sql/schema/verify/revert-custom-hold-counts.sql +++ /dev/null @@ -1,7 +0,0 @@ --- Verify kcls-evergreen:revert-custom-hold-counts on pg - -BEGIN; - --- XXX Add verifications here. - -ROLLBACK; diff --git a/KCLS/sql/schema/verify/revert-custom-qstats.sql b/KCLS/sql/schema/verify/revert-custom-qstats.sql deleted file mode 100644 index 78d1abdb67..0000000000 --- a/KCLS/sql/schema/verify/revert-custom-qstats.sql +++ /dev/null @@ -1,7 +0,0 @@ --- Verify kcls-evergreen:revert-custom-qstats on pg - -BEGIN; - --- XXX Add verifications here. - -ROLLBACK; diff --git a/KCLS/sql/schema/verify/search-strip-apos-recover.sql b/KCLS/sql/schema/verify/search-strip-apos-recover.sql deleted file mode 100644 index 69efbac4db..0000000000 --- a/KCLS/sql/schema/verify/search-strip-apos-recover.sql +++ /dev/null @@ -1,8 +0,0 @@ --- Verify kcls-evergreen:search-strip-apos-recover on pg - -BEGIN; - --- XXX Add verifications here. - - -ROLLBACK; diff --git a/KCLS/sql/schema/verify/self-reg-net-access-level.sql b/KCLS/sql/schema/verify/self-reg-net-access-level.sql deleted file mode 100644 index 554a6b8635..0000000000 --- a/KCLS/sql/schema/verify/self-reg-net-access-level.sql +++ /dev/null @@ -1,7 +0,0 @@ --- Verify kcls-evergreen:self-reg-net-access-level on pg - -BEGIN; - -ALTER TABLE staging.user_stage DROP COLUMN net_access_level; - -ROLLBACK; diff --git a/KCLS/sql/schema/verify/selfcheck-email-receipts.sql b/KCLS/sql/schema/verify/selfcheck-email-receipts.sql deleted file mode 100644 index 07d91ea167..0000000000 --- a/KCLS/sql/schema/verify/selfcheck-email-receipts.sql +++ /dev/null @@ -1,7 +0,0 @@ --- Verify kcls-evergreen:selfcheck-email-receipts on pg - -BEGIN; - --- XXX Add verifications here. - -ROLLBACK; diff --git a/KCLS/sql/schema/verify/sip-act-type-freegalsip.sql b/KCLS/sql/schema/verify/sip-act-type-freegalsip.sql deleted file mode 100644 index 2f8d701e74..0000000000 --- a/KCLS/sql/schema/verify/sip-act-type-freegalsip.sql +++ /dev/null @@ -1,7 +0,0 @@ --- Verify kcls-evergreen:sip-act-type-freegalsip on pg - -BEGIN; - --- XXX Add verifications here. - -ROLLBACK; diff --git a/KCLS/sql/schema/verify/sip-activity-types.sql b/KCLS/sql/schema/verify/sip-activity-types.sql deleted file mode 100644 index 2e38c99a16..0000000000 --- a/KCLS/sql/schema/verify/sip-activity-types.sql +++ /dev/null @@ -1,7 +0,0 @@ --- Verify kcls-evergreen:sip-activity-types on pg - -BEGIN; - --- XXX Add verifications here. - -ROLLBACK; diff --git a/KCLS/sql/schema/verify/student-groups.sql b/KCLS/sql/schema/verify/student-groups.sql deleted file mode 100644 index d6316508db..0000000000 --- a/KCLS/sql/schema/verify/student-groups.sql +++ /dev/null @@ -1,7 +0,0 @@ --- Verify kcls-evergreen:student-groups on pg - -BEGIN; - --- XXX Add verifications here. - -ROLLBACK; diff --git a/KCLS/sql/schema/verify/subject-browse-entry-dashes.sql b/KCLS/sql/schema/verify/subject-browse-entry-dashes.sql deleted file mode 100644 index 645e3998c6..0000000000 --- a/KCLS/sql/schema/verify/subject-browse-entry-dashes.sql +++ /dev/null @@ -1,7 +0,0 @@ --- Verify kcls-evergreen:subject-browse-entry-dashes on pg - -BEGIN; - --- XXX Add verifications here. - -ROLLBACK; diff --git a/KCLS/sql/schema/verify/teacher-group.sql b/KCLS/sql/schema/verify/teacher-group.sql deleted file mode 100644 index b7422b836f..0000000000 --- a/KCLS/sql/schema/verify/teacher-group.sql +++ /dev/null @@ -1,7 +0,0 @@ --- Verify kcls-evergreen:teacher-group on pg - -BEGIN; - --- XXX Add verifications here. - -ROLLBACK; diff --git a/KCLS/sql/schema/verify/vand-auth-edit-date.sql b/KCLS/sql/schema/verify/vand-auth-edit-date.sql deleted file mode 100644 index 7535d389dc..0000000000 --- a/KCLS/sql/schema/verify/vand-auth-edit-date.sql +++ /dev/null @@ -1,7 +0,0 @@ --- Verify kcls-evergreen:vand-auth-edit-date on pg - -BEGIN; - --- XXX Add verifications here. - -ROLLBACK; diff --git a/KCLS/sql/schema/verify/vand-delete-speed-indexes.sql b/KCLS/sql/schema/verify/vand-delete-speed-indexes.sql deleted file mode 100644 index f8e50e61c1..0000000000 --- a/KCLS/sql/schema/verify/vand-delete-speed-indexes.sql +++ /dev/null @@ -1,7 +0,0 @@ --- Verify kcls-evergreen:vand-delete-speed-indexes on pg - -BEGIN; - --- XXX Add verifications here. - -ROLLBACK; diff --git a/KCLS/sql/schema/verify/vand-import-edit-date-fix.sql b/KCLS/sql/schema/verify/vand-import-edit-date-fix.sql deleted file mode 100644 index 97ce27004b..0000000000 --- a/KCLS/sql/schema/verify/vand-import-edit-date-fix.sql +++ /dev/null @@ -1,7 +0,0 @@ --- Verify kcls-evergreen:vand-import-edit-date-fix on pg - -BEGIN; - --- XXX Add verifications here. - -ROLLBACK; -- 2.11.0