From 05df9c099d497a017a03f37f5116750691d01087 Mon Sep 17 00:00:00 2001 From: Bill Erickson Date: Tue, 31 May 2011 12:16:16 -0400 Subject: [PATCH] Repaired typo on schema and upgrade SQL ARRAY_ACUM is not a defined function. Per Dan Scott, replaced with ARRAY_AGG instead of the correctly spelled ARRAY_ACCUM, since we'll be using that function in place of ARRAY_ACCUM going forward. Thanks, Dan. Minor syntax/cleanup repairs Remove tmp seed data file. T'was replaced with upgrade script Signed-off-by: Bill Erickson --- Open-ILS/src/sql/Pg/002.schema.config.sql | 4 +- .../upgrade/0526.schema.upgrade-dep-tracking.sql | 4 +- .../XXXX.vandelay-record-matching-and-quality.sql | 6 +- Open-ILS/src/sql/Pg/upgrade/renumber_me.sql | 572 --------------------- 4 files changed, 6 insertions(+), 580 deletions(-) delete mode 100644 Open-ILS/src/sql/Pg/upgrade/renumber_me.sql diff --git a/Open-ILS/src/sql/Pg/002.schema.config.sql b/Open-ILS/src/sql/Pg/002.schema.config.sql index 80b7a65832..d9ad34950d 100644 --- a/Open-ILS/src/sql/Pg/002.schema.config.sql +++ b/Open-ILS/src/sql/Pg/002.schema.config.sql @@ -882,8 +882,8 @@ Upgrade script % can not be applied: deprecated by % superseded by %', my_db_patch, - deprecates, - supersedes, + ARRAY_AGG(evergreen.upgrade_list_applied_deprecates(my_db_patch)), + ARRAY_AGG(evergreen.upgrade_list_applied_supersedes(my_db_patch)), evergreen.upgrade_list_applied_deprecated(my_db_patch), evergreen.upgrade_list_applied_superseded(my_db_patch); END IF; diff --git a/Open-ILS/src/sql/Pg/upgrade/0526.schema.upgrade-dep-tracking.sql b/Open-ILS/src/sql/Pg/upgrade/0526.schema.upgrade-dep-tracking.sql index 86b381de57..16ff50d700 100644 --- a/Open-ILS/src/sql/Pg/upgrade/0526.schema.upgrade-dep-tracking.sql +++ b/Open-ILS/src/sql/Pg/upgrade/0526.schema.upgrade-dep-tracking.sql @@ -101,8 +101,8 @@ Upgrade script % can not be applied: deprecated by % superseded by %', my_db_patch, - deprecates, - supersedes, + ARRAY_AGG(evergreen.upgrade_list_applied_deprecates(my_db_patch)), + ARRAY_AGG(evergreen.upgrade_list_applied_supersedes(my_db_patch)), evergreen.upgrade_list_applied_deprecated(my_db_patch), evergreen.upgrade_list_applied_superseded(my_db_patch); END IF; diff --git a/Open-ILS/src/sql/Pg/upgrade/XXXX.vandelay-record-matching-and-quality.sql b/Open-ILS/src/sql/Pg/upgrade/XXXX.vandelay-record-matching-and-quality.sql index 56154dfb12..5093d5f722 100644 --- a/Open-ILS/src/sql/Pg/upgrade/XXXX.vandelay-record-matching-and-quality.sql +++ b/Open-ILS/src/sql/Pg/upgrade/XXXX.vandelay-record-matching-and-quality.sql @@ -6,7 +6,7 @@ BEGIN; -- check whether patch can be applied -SELECT evergreen.upgrade_deps_block_check('XXXX', :eg_version); +--SELECT evergreen.upgrade_deps_block_check('XXXX', :eg_version); CREATE OR REPLACE FUNCTION evergreen.array_remove_item_by_value(inp ANYARRAY, el ANYELEMENT) RETURNS anyarray AS $$ SELECT ARRAY_ACCUM(x.e) FROM UNNEST( $1 ) x(e) WHERE x.e <> $2; $$ LANGUAGE SQL; @@ -53,7 +53,7 @@ CREATE UNIQUE INDEX vmsq_def_once_per_set ON vandelay.match_set_quality (match_s -- ALTER TABLEs... ALTER TABLE vandelay.queue ADD COLUMN match_set INT REFERENCES vandelay.match_set (id) ON UPDATE CASCADE ON DELETE SET NULL DEFERRABLE INITIALLY DEFERRED; -ALTER TABLE vandelay.queue_record ADD COLUMN quality INT NOT NULL DEFAULT 0; +ALTER TABLE vandelay.queued_record ADD COLUMN quality INT NOT NULL DEFAULT 0; ALTER TABLE vandelay.bib_attr_definition DROP COLUMN ident; CREATE TABLE vandelay.import_error ( @@ -144,7 +144,6 @@ BEGIN END; $func$ LANGUAGE PLPGSQL; -CREATE TYPE biblio.record_ff_map AS (record BIGINT, ff_name TEXT, ff_value TEXT); CREATE OR REPLACE FUNCTION vandelay.marc21_extract_all_fixed_fields( marc TEXT ) RETURNS SETOF biblio.record_ff_map AS $func$ DECLARE tag_data TEXT; @@ -180,7 +179,6 @@ BEGIN END; $func$ LANGUAGE PLPGSQL; -CREATE TYPE biblio.marc21_physical_characteristics AS ( id INT, record BIGINT, ptype TEXT, subfield INT, value INT ); CREATE OR REPLACE FUNCTION vandelay.marc21_physical_characteristics( marc TEXT) RETURNS SETOF biblio.marc21_physical_characteristics AS $func$ DECLARE rowid INT := 0; diff --git a/Open-ILS/src/sql/Pg/upgrade/renumber_me.sql b/Open-ILS/src/sql/Pg/upgrade/renumber_me.sql deleted file mode 100644 index 5396747d95..0000000000 --- a/Open-ILS/src/sql/Pg/upgrade/renumber_me.sql +++ /dev/null @@ -1,572 +0,0 @@ -BEGIN; - -INSERT INTO config.upgrade_log (version) VALUES ('test'); -- phasefx - -INSERT INTO action_trigger.hook (key,core_type,description,passive) VALUES ( - 'vandelay.queued_bib_record.print', - 'vqbr', - oils_i18n_gettext( - 'vandelay.queued_bib_record.print', - 'Print output has been requested for records in an Importer Bib Queue.', - 'ath', - 'description' - ), - FALSE - ) - ,( - 'vandelay.queued_bib_record.csv', - 'vqbr', - oils_i18n_gettext( - 'vandelay.queued_bib_record.csv', - 'CSV output has been requested for records in an Importer Bib Queue.', - 'ath', - 'description' - ), - FALSE - ) - ,( - 'vandelay.queued_bib_record.email', - 'vqbr', - oils_i18n_gettext( - 'vandelay.queued_bib_record.email', - 'An email has been requested for records in an Importer Bib Queue.', - 'ath', - 'description' - ), - FALSE - ) - ,( - 'vandelay.queued_auth_record.print', - 'vqar', - oils_i18n_gettext( - 'vandelay.queued_auth_record.print', - 'Print output has been requested for records in an Importer Authority Queue.', - 'ath', - 'description' - ), - FALSE - ) - ,( - 'vandelay.queued_auth_record.csv', - 'vqar', - oils_i18n_gettext( - 'vandelay.queued_auth_record.csv', - 'CSV output has been requested for records in an Importer Authority Queue.', - 'ath', - 'description' - ), - FALSE - ) - ,( - 'vandelay.queued_auth_record.email', - 'vqar', - oils_i18n_gettext( - 'vandelay.queued_auth_record.email', - 'An email has been requested for records in an Importer Authority Queue.', - 'ath', - 'description' - ), - FALSE - ) - ,( - 'vandelay.import_items.print', - 'vii', - oils_i18n_gettext( - 'vandelay.import_items.print', - 'Print output has been requested for Import Items from records in an Importer Bib Queue.', - 'ath', - 'description' - ), - FALSE - ) - ,( - 'vandelay.import_items.csv', - 'vii', - oils_i18n_gettext( - 'vandelay.import_items.csv', - 'CSV output has been requested for Import Items from records in an Importer Bib Queue.', - 'ath', - 'description' - ), - FALSE - ) - ,( - 'vandelay.import_items.email', - 'vii', - oils_i18n_gettext( - 'vandelay.import_items.email', - 'An email has been requested for Import Items from records in an Importer Bib Queue.', - 'ath', - 'description' - ), - FALSE - ) -; - -INSERT INTO action_trigger.event_definition ( - id, - active, - owner, - name, - hook, - validator, - reactor, - group_field, - granularity, - template - ) VALUES ( - 38, - TRUE, - 1, - 'Print Output for Queued Bib Records', - 'vandelay.queued_bib_record.print', - 'NOOP_True', - 'ProcessTemplate', - 'queue.owner', - 'print-on-demand', -$$ -[%- USE date -%] -
-Queue ID: [% target.0.queue.id %]
-Queue Name: [% target.0.queue.name %]
-Queue Type: [% target.0.queue.queue_type %]
-Complete? [% target.0.queue.complete %]
-
-    [% FOR vqbr IN target %]
-=-=-=
- Title of work    | [% helpers.get_queued_bib_attr('title',vqbr.attributes) %]
- Author of work   | [% helpers.get_queued_bib_attr('author',vqbr.attributes) %]
- Language of work | [% helpers.get_queued_bib_attr('language',vqbr.attributes) %]
- Pagination       | [% helpers.get_queued_bib_attr('pagination',vqbr.attributes) %]
- ISBN             | [% helpers.get_queued_bib_attr('isbn',vqbr.attributes) %]
- ISSN             | [% helpers.get_queued_bib_attr('issn',vqbr.attributes) %]
- Price            | [% helpers.get_queued_bib_attr('price',vqbr.attributes) %]
- Accession Number | [% helpers.get_queued_bib_attr('rec_identifier',vqbr.attributes) %]
- TCN Value        | [% helpers.get_queued_bib_attr('eg_tcn',vqbr.attributes) %]
- TCN Source       | [% helpers.get_queued_bib_attr('eg_tcn_source',vqbr.attributes) %]
- Internal ID      | [% helpers.get_queued_bib_attr('eg_identifier',vqbr.attributes) %]
- Publisher        | [% helpers.get_queued_bib_attr('publisher',vqbr.attributes) %]
- Publication Date | [% helpers.get_queued_bib_attr('pubdate',vqbr.attributes) %]
- Edition          | [% helpers.get_queued_bib_attr('edition',vqbr.attributes) %]
- Item Barcode     | [% helpers.get_queued_bib_attr('item_barcode',vqbr.attributes) %]
-
-    [% END %]
-
-$$ - ) -; - -INSERT INTO action_trigger.environment ( event_def, path) VALUES ( - 38, 'attributes') - ,( 38, 'queue') -; - -INSERT INTO action_trigger.event_definition ( - id, - active, - owner, - name, - hook, - validator, - reactor, - group_field, - granularity, - template - ) VALUES ( - 39, - TRUE, - 1, - 'CSV Output for Queued Bib Records', - 'vandelay.queued_bib_record.csv', - 'NOOP_True', - 'ProcessTemplate', - 'queue.owner', - 'print-on-demand', -$$ -[%- USE date -%] -"Title of work","Author of work","Language of work","Pagination","ISBN","ISSN","Price","Accession Number","TCN Value","TCN Source","Internal ID","Publisher","Publication Date","Edition","Item Barcode" -[% FOR vqbr IN target %]"[% helpers.get_queued_bib_attr('title',vqbr.attributes) | replace('"', '""') %]","[% helpers.get_queued_bib_attr('author',vqbr.attributes) | replace('"', '""') %]","[% helpers.get_queued_bib_attr('language',vqbr.attributes) | replace('"', '""') %]","[% helpers.get_queued_bib_attr('pagination',vqbr.attributes) | replace('"', '""') %]","[% helpers.get_queued_bib_attr('isbn',vqbr.attributes) | replace('"', '""') %]","[% helpers.get_queued_bib_attr('issn',vqbr.attributes) | replace('"', '""') %]","[% helpers.get_queued_bib_attr('price',vqbr.attributes) | replace('"', '""') %]","[% helpers.get_queued_bib_attr('rec_identifier',vqbr.attributes) | replace('"', '""') %]","[% helpers.get_queued_bib_attr('eg_tcn',vqbr.attributes) | replace('"', '""') %]","[% helpers.get_queued_bib_attr('eg_tcn_source',vqbr.attributes) | replace('"', '""') %]","[% helpers.get_queued_bib_attr('eg_identifier',vqbr.attributes) | replace('"', '""') %]","[% helpers.get_queued_bib_attr('publisher',vqbr.attributes) | replace('"', '""') %]","[% helpers.get_queued_bib_attr('pubdate',vqbr.attributes) | replace('"', '""') %]","[% helpers.get_queued_bib_attr('edition',vqbr.attributes) | replace('"', '""') %]","[% helpers.get_queued_bib_attr('item_barcode',vqbr.attributes) | replace('"', '""') %]" -[% END %] -$$ - ) -; - -INSERT INTO action_trigger.environment ( event_def, path) VALUES ( - 39, 'attributes') - ,( 39, 'queue') -; - -INSERT INTO action_trigger.event_definition ( - id, - active, - owner, - name, - hook, - validator, - reactor, - group_field, - granularity, - template - ) VALUES ( - 40, - TRUE, - 1, - 'Email Output for Queued Bib Records', - 'vandelay.queued_bib_record.email', - 'NOOP_True', - 'SendEmail', - 'queue.owner', - NULL, -$$ -[%- USE date -%] -[%- SET user = target.0.queue.owner -%] -To: [%- params.recipient_email || user.email || 'root@localhost' %] -From: [%- params.sender_email || default_sender %] -Subject: Bibs from Import Queue - -Queue ID: [% target.0.queue.id %] -Queue Name: [% target.0.queue.name %] -Queue Type: [% target.0.queue.queue_type %] -Complete? [% target.0.queue.complete %] - - [% FOR vqbr IN target %] -=-=-= - Title of work | [% helpers.get_queued_bib_attr('title',vqbr.attributes) %] - Author of work | [% helpers.get_queued_bib_attr('author',vqbr.attributes) %] - Language of work | [% helpers.get_queued_bib_attr('language',vqbr.attributes) %] - Pagination | [% helpers.get_queued_bib_attr('pagination',vqbr.attributes) %] - ISBN | [% helpers.get_queued_bib_attr('isbn',vqbr.attributes) %] - ISSN | [% helpers.get_queued_bib_attr('issn',vqbr.attributes) %] - Price | [% helpers.get_queued_bib_attr('price',vqbr.attributes) %] - Accession Number | [% helpers.get_queued_bib_attr('rec_identifier',vqbr.attributes) %] - TCN Value | [% helpers.get_queued_bib_attr('eg_tcn',vqbr.attributes) %] - TCN Source | [% helpers.get_queued_bib_attr('eg_tcn_source',vqbr.attributes) %] - Internal ID | [% helpers.get_queued_bib_attr('eg_identifier',vqbr.attributes) %] - Publisher | [% helpers.get_queued_bib_attr('publisher',vqbr.attributes) %] - Publication Date | [% helpers.get_queued_bib_attr('pubdate',vqbr.attributes) %] - Edition | [% helpers.get_queued_bib_attr('edition',vqbr.attributes) %] - Item Barcode | [% helpers.get_queued_bib_attr('item_barcode',vqbr.attributes) %] - - [% END %] - -$$ - ) -; - -INSERT INTO action_trigger.environment ( event_def, path) VALUES ( - 40, 'attributes') - ,( 40, 'queue') - ,( 40, 'queue.owner') -; - -INSERT INTO action_trigger.event_definition ( - id, - active, - owner, - name, - hook, - validator, - reactor, - group_field, - granularity, - template - ) VALUES ( - 41, - TRUE, - 1, - 'Print Output for Queued Authority Records', - 'vandelay.queued_auth_record.print', - 'NOOP_True', - 'ProcessTemplate', - 'queue.owner', - 'print-on-demand', -$$ -[%- USE date -%] -
-Queue ID: [% target.0.queue.id %]
-Queue Name: [% target.0.queue.name %]
-Queue Type: [% target.0.queue.queue_type %]
-Complete? [% target.0.queue.complete %]
-
-    [% FOR vqar IN target %]
-=-=-=
- Record Identifier | [% helpers.get_queued_auth_attr('rec_identifier',vqar.attributes) %]
-
-    [% END %]
-
-$$ - ) -; - -INSERT INTO action_trigger.environment ( event_def, path) VALUES ( - 41, 'attributes') - ,( 41, 'queue') -; - -INSERT INTO action_trigger.event_definition ( - id, - active, - owner, - name, - hook, - validator, - reactor, - group_field, - granularity, - template - ) VALUES ( - 42, - TRUE, - 1, - 'CSV Output for Queued Authority Records', - 'vandelay.queued_auth_record.csv', - 'NOOP_True', - 'ProcessTemplate', - 'queue.owner', - 'print-on-demand', -$$ -[%- USE date -%] -"Record Identifier" -[% FOR vqar IN target %]"[% helpers.get_queued_auth_attr('rec_identifier',vqar.attributes) | replace('"', '""') %]" -[% END %] -$$ - ) -; - -INSERT INTO action_trigger.environment ( event_def, path) VALUES ( - 42, 'attributes') - ,( 42, 'queue') -; - -INSERT INTO action_trigger.event_definition ( - id, - active, - owner, - name, - hook, - validator, - reactor, - group_field, - granularity, - template - ) VALUES ( - 43, - TRUE, - 1, - 'Email Output for Queued Authority Records', - 'vandelay.queued_auth_record.email', - 'NOOP_True', - 'SendEmail', - 'queue.owner', - NULL, -$$ -[%- USE date -%] -[%- SET user = target.0.queue.owner -%] -To: [%- params.recipient_email || user.email || 'root@localhost' %] -From: [%- params.sender_email || default_sender %] -Subject: Authorities from Import Queue - -Queue ID: [% target.0.queue.id %] -Queue Name: [% target.0.queue.name %] -Queue Type: [% target.0.queue.queue_type %] -Complete? [% target.0.queue.complete %] - - [% FOR vqar IN target %] -=-=-= - Record Identifier | [% helpers.get_queued_auth_attr('rec_identifier',vqar.attributes) %] - - [% END %] - -$$ - ) -; - -INSERT INTO action_trigger.environment ( event_def, path) VALUES ( - 43, 'attributes') - ,( 43, 'queue') - ,( 43, 'queue.owner') -; - -INSERT INTO action_trigger.event_definition ( - id, - active, - owner, - name, - hook, - validator, - reactor, - group_field, - granularity, - template - ) VALUES ( - 44, - TRUE, - 1, - 'Print Output for Import Items from Queued Bib Records', - 'vandelay.import_items.print', - 'NOOP_True', - 'ProcessTemplate', - 'record.queue.owner', - 'print-on-demand', -$$ -[%- USE date -%] -
-Queue ID: [% target.0.record.queue.id %]
-Queue Name: [% target.0.record.queue.name %]
-Queue Type: [% target.0.record.queue.queue_type %]
-Complete? [% target.0.record.queue.complete %]
-
-    [% FOR vii IN target %]
-=-=-=
- Import Item ID         | [% vii.id %]
- Title of work          | [% helpers.get_queued_bib_attr('title',vii.record.attributes) %]
- ISBN                   | [% helpers.get_queued_bib_attr('isbn',vii.record.attributes) %]
- Attribute Definition   | [% vii.definition %]
- Import Error           | [% vii.import_error %]
- Import Error Detail    | [% vii.error_detail %]
- Owning Library         | [% vii.owning_lib %]
- Circulating Library    | [% vii.circ_lib %]
- Call Number            | [% vii.call_number %]
- Copy Number            | [% vii.copy_number %]
- Status                 | [% vii.status.name %]
- Shelving Location      | [% vii.location.name %]
- Circulate              | [% vii.circulate %]
- Deposit                | [% vii.deposit %]
- Deposit Amount         | [% vii.deposit_amount %]
- Reference              | [% vii.ref %]
- Holdable               | [% vii.holdable %]
- Price                  | [% vii.price %]
- Barcode                | [% vii.barcode %]
- Circulation Modifier   | [% vii.circ_modifier %]
- Circulate As MARC Type | [% vii.circ_as_type %]
- Alert Message          | [% vii.alert_message %]
- Public Note            | [% vii.pub_note %]
- Private Note           | [% vii.priv_note %]
- OPAC Visible           | [% vii.opac_visible %]
-
-    [% END %]
-
-$$ - ) -; - -INSERT INTO action_trigger.environment ( event_def, path) VALUES ( - 44, 'record') - ,( 44, 'record.attributes') - ,( 44, 'record.queue') - ,( 44, 'record.queue.owner') -; - -INSERT INTO action_trigger.event_definition ( - id, - active, - owner, - name, - hook, - validator, - reactor, - group_field, - granularity, - template - ) VALUES ( - 45, - TRUE, - 1, - 'CSV Output for Import Items from Queued Bib Records', - 'vandelay.import_items.csv', - 'NOOP_True', - 'ProcessTemplate', - 'record.queue.owner', - 'print-on-demand', -$$ -[%- USE date -%] -"Import Item ID","Title of work","ISBN","Attribute Definition","Import Error","Import Error Detail","Owning Library","Circulating Library","Call Number","Copy Number","Status","Shelving Location","Circulate","Deposit","Deposit Amount","Reference","Holdable","Price","Barcode","Circulation Modifier","Circulate As MARC Type","Alert Message","Public Note","Private Note","OPAC Visible" -[% FOR vii IN target %]"[% vii.id | replace('"', '""') %]","[% helpers.get_queued_bib_attr('title',vii.record.attributes) | replace('"', '""') %]","[% helpers.get_queued_bib_attr('isbn',vii.record.attributes) | replace('"', '""') %]","[% vii.definition | replace('"', '""') %]","[% vii.import_error | replace('"', '""') %]","[% vii.error_detail | replace('"', '""') %]","[% vii.owning_lib | replace('"', '""') %]","[% vii.circ_lib | replace('"', '""') %]","[% vii.call_number | replace('"', '""') %]","[% vii.copy_number | replace('"', '""') %]","[% vii.status.name | replace('"', '""') %]","[% vii.location.name | replace('"', '""') %]","[% vii.circulate | replace('"', '""') %]","[% vii.deposit | replace('"', '""') %]","[% vii.deposit_amount | replace('"', '""') %]","[% vii.ref | replace('"', '""') %]","[% vii.holdable | replace('"', '""') %]","[% vii.price | replace('"', '""') %]","[% vii.barcode | replace('"', '""') %]","[% vii.circ_modifier | replace('"', '""') %]","[% vii.circ_as_type | replace('"', '""') %]","[% vii.alert_message | replace('"', '""') %]","[% vii.pub_note | replace('"', '""') %]","[% vii.priv_note | replace('"', '""') %]","[% vii.opac_visible | replace('"', '""') %]" -[% END %] -$$ - ) -; - -INSERT INTO action_trigger.environment ( event_def, path) VALUES ( - 45, 'record') - ,( 45, 'record.attributes') - ,( 45, 'record.queue') - ,( 45, 'record.queue.owner') -; - -INSERT INTO action_trigger.event_definition ( - id, - active, - owner, - name, - hook, - validator, - reactor, - group_field, - granularity, - template - ) VALUES ( - 46, - TRUE, - 1, - 'Email Output for Import Items from Queued Bib Records', - 'vandelay.import_items.email', - 'NOOP_True', - 'SendEmail', - 'record.queue.owner', - NULL, -$$ -[%- USE date -%] -[%- SET user = target.0.record.queue.owner -%] -To: [%- params.recipient_email || user.email || 'root@localhost' %] -From: [%- params.sender_email || default_sender %] -Subject: Import Items from Import Queue - -Queue ID: [% target.0.record.queue.id %] -Queue Name: [% target.0.record.queue.name %] -Queue Type: [% target.0.record.queue.queue_type %] -Complete? [% target.0.record.queue.complete %] - - [% FOR vii IN target %] -=-=-= - Import Item ID | [% vii.id %] - Title of work | [% helpers.get_queued_bib_attr('title',vii.record.attributes) %] - ISBN | [% helpers.get_queued_bib_attr('isbn',vii.record.attributes) %] - Attribute Definition | [% vii.definition %] - Import Error | [% vii.import_error %] - Import Error Detail | [% vii.error_detail %] - Owning Library | [% vii.owning_lib %] - Circulating Library | [% vii.circ_lib %] - Call Number | [% vii.call_number %] - Copy Number | [% vii.copy_number %] - Status | [% vii.status.name %] - Shelving Location | [% vii.location.name %] - Circulate | [% vii.circulate %] - Deposit | [% vii.deposit %] - Deposit Amount | [% vii.deposit_amount %] - Reference | [% vii.ref %] - Holdable | [% vii.holdable %] - Price | [% vii.price %] - Barcode | [% vii.barcode %] - Circulation Modifier | [% vii.circ_modifier %] - Circulate As MARC Type | [% vii.circ_as_type %] - Alert Message | [% vii.alert_message %] - Public Note | [% vii.pub_note %] - Private Note | [% vii.priv_note %] - OPAC Visible | [% vii.opac_visible %] - - [% END %] -$$ - ) -; - -INSERT INTO action_trigger.environment ( event_def, path) VALUES ( - 46, 'record') - ,( 46, 'record.attributes') - ,( 46, 'record.queue') - ,( 46, 'record.queue.owner') -; - -COMMIT; - --- BEGIN; DELETE FROM action_trigger.event WHERE event_def IN (38,39,40,41,42,43,44,45,46); DELETE FROM action_trigger.environment WHERE event_def IN (38,39,40,41,42,43,44,45,46); DELETE FROM action_trigger.event_definition WHERE id IN (38,39,40,41,42,43,44,45,46); DELETE FROM action_trigger.hook WHERE key IN ('vandelay.queued_bib_record.print','vandelay.queued_bib_record.csv','vandelay.queued_bib_record.email','vandelay.queued_auth_record.print','vandelay.queued_auth_record.csv','vandelay.queued_auth_record.email','vandelay.import_items.print','vandelay.import_items.csv','vandelay.import_items.email'); DELETE FROM action_trigger.event_output WHERE id IN ((SELECT template_output FROM action_trigger.event WHERE event_def IN (38,39,40,41,42,43,44,45,46))UNION(SELECT error_output FROM action_trigger.event WHERE event_def IN (38,39,40,41,42,43,44,45,46))); DELETE FROM config.upgrade_log WHERE version = 'test'; COMMIT; -- 2.11.0