From 2c4cca63614b9231702c4c85dcd9acd1ad5766ed Mon Sep 17 00:00:00 2001 From: Owen Leonard Date: Thu, 31 Aug 2023 12:02:59 +0000 Subject: [PATCH] Bug 34661: FOR TESTING ONLY, a database update to configure MARC plugins This patch is for testing purposes only: An update to change the default framework's plugin settings for various fields in order to make all the updated UNIMARC plugin available. --- ...-34661-update-default-unimarc-framework.pl | 81 +++++++++++++++++++ 1 file changed, 81 insertions(+) create mode 100644 installer/data/mysql/atomicupdate/DO_NOT_PUSH_bug-34661-update-default-unimarc-framework.pl diff --git a/installer/data/mysql/atomicupdate/DO_NOT_PUSH_bug-34661-update-default-unimarc-framework.pl b/installer/data/mysql/atomicupdate/DO_NOT_PUSH_bug-34661-update-default-unimarc-framework.pl new file mode 100644 index 0000000000..d126321fc2 --- /dev/null +++ b/installer/data/mysql/atomicupdate/DO_NOT_PUSH_bug-34661-update-default-unimarc-framework.pl @@ -0,0 +1,81 @@ +use Modern::Perl; + +return { + bug_number => "34661", + description => "Update default UNIMARC framwork for testing purposes", + up => sub { + my ($args) = @_; + my ( $dbh, $out ) = @$args{qw(dbh out)}; + + # Do you stuffs here + $dbh->do( + q{ UPDATE marc_subfield_structure SET value_builder = 'unimarc_field_127.pl', hidden = 0, tab = '1' WHERE frameworkcode = '' AND tagfield = '127' AND tagsubfield = 'a' } + ); + $dbh->do( + q{ UPDATE marc_subfield_structure SET value_builder = 'unimarc_field_128b.pl', hidden = 0, tab = '1' WHERE frameworkcode = '' AND tagfield = '128' AND tagsubfield = 'b' } + ); + $dbh->do( + q{ UPDATE marc_subfield_structure SET value_builder = 'unimarc_field_128c.pl', hidden = 0, tab = '1' WHERE frameworkcode = '' AND tagfield = '128' AND tagsubfield = 'c' } + ); + $dbh->do( + q{ UPDATE marc_subfield_structure SET value_builder = 'unimarc_field_146b.pl', hidden = 0, tab = '1' WHERE frameworkcode = '' AND tagfield = '146' AND tagsubfield = 'b' } + ); + $dbh->do( + q{ UPDATE marc_subfield_structure SET value_builder = 'unimarc_field_146c.pl', hidden = 0, tab = '1' WHERE frameworkcode = '' AND tagfield = '146' AND tagsubfield = 'c' } + ); + $dbh->do( + q{ UPDATE marc_subfield_structure SET value_builder = 'unimarc_field_146d.pl', hidden = 0, tab = '1' WHERE frameworkcode = '' AND tagfield = '146' AND tagsubfield = 'd' } + ); + $dbh->do( + q{ UPDATE marc_subfield_structure SET value_builder = 'unimarc_field_146e.pl', hidden = 0, tab = '1' WHERE frameworkcode = '' AND tagfield = '146' AND tagsubfield = 'e' } + ); + $dbh->do( + q{ UPDATE marc_subfield_structure SET value_builder = 'unimarc_field_146f.pl', hidden = 0, tab = '1' WHERE frameworkcode = '' AND tagfield = '146' AND tagsubfield = 'f' } + ); + $dbh->do( + q{ UPDATE marc_subfield_structure SET value_builder = 'unimarc_field_146h.pl', hidden = 0, tab = '1' WHERE frameworkcode = '' AND tagfield = '146' AND tagsubfield = 'h' } + ); + $dbh->do( + q{ UPDATE marc_subfield_structure SET value_builder = 'unimarc_field_146i.pl', hidden = 0, tab = '1' WHERE frameworkcode = '' AND tagfield = '146' AND tagsubfield = 'i' } + ); + $dbh->do( + q{ UPDATE marc_subfield_structure SET value_builder = 'unimarc_field_181-2.pl', hidden = 0, tab = '1' WHERE frameworkcode = '' AND tagfield = '181' AND tagsubfield = '2' } + ); + $dbh->do( + q{ UPDATE marc_subfield_structure SET value_builder = 'unimarc_field_181a.pl', hidden = 0, tab = '1' WHERE frameworkcode = '' AND tagfield = '181' AND tagsubfield = 'a' } + ); + $dbh->do( + q{ UPDATE marc_subfield_structure SET value_builder = 'unimarc_field_181b.pl', hidden = 0, tab = '1' WHERE frameworkcode = '' AND tagfield = '181' AND tagsubfield = 'b' } + ); + $dbh->do( + q{ UPDATE marc_subfield_structure SET value_builder = 'unimarc_field_182-2.pl', hidden = 0, tab = '1' WHERE frameworkcode = '' AND tagfield = '182' AND tagsubfield = 'a' } + ); + $dbh->do( + q{ UPDATE marc_subfield_structure SET value_builder = 'unimarc_field_182a.pl', hidden = 0, tab = '1' WHERE frameworkcode = '' AND tagfield = '182' AND tagsubfield = 'a' } + ); + $dbh->do( + q{ UPDATE marc_subfield_structure SET value_builder = 'unimarc_field_182c.pl', hidden = 0, tab = '1' WHERE frameworkcode = '' AND tagfield = '182' AND tagsubfield = 'c' } + ); + $dbh->do( + q{ UPDATE marc_subfield_structure SET value_builder = 'unimarc_field_183-2.pl', hidden = 0, tab = '1' WHERE frameworkcode = '' AND tagfield = '183' AND tagsubfield = '2' } + ); + $dbh->do( + q{ UPDATE marc_subfield_structure SET value_builder = 'unimarc_field_183a.pl', hidden = 0, tab = '1' WHERE frameworkcode = '' AND tagfield = '183' AND tagsubfield = 'a' } + ); + $dbh->do( + q{ UPDATE marc_subfield_structure SET value_builder = 'unimarc_field_225a.pl', hidden = 0, tab = '2' WHERE frameworkcode = '' AND tagfield = '225' AND tagsubfield = 'a' } + ); + $dbh->do( + q{ UPDATE marc_subfield_structure SET value_builder = 'unimarc_field_283-2.pl', hidden = 0, tab = '2' WHERE frameworkcode = '' AND tagfield = '283' AND tagsubfield = '2' } + ); + $dbh->do( + q{ UPDATE marc_subfield_structure SET value_builder = 'unimarc_field_283a.pl', hidden = 0, tab = '2' WHERE frameworkcode = '' AND tagfield = '283' AND tagsubfield = 'a' } + ); + $dbh->do( + q{ UPDATE marc_subfield_structure SET value_builder = 'unimarc_field_325h.pl', hidden = 0, tab = '3' WHERE frameworkcode = '' AND tagfield = '325' AND tagsubfield = 'h' } + ); + $dbh->do( + q{ UPDATE marc_subfield_structure SET value_builder = 'unimarc_field_325j.pl', hidden = 0, tab = '3' WHERE frameworkcode = '' AND tagfield = '325' AND tagsubfield = 'j' } + ); + }, +} -- 2.30.2