From: Jason Etheridge Date: Fri, 23 Aug 2019 20:57:30 +0000 (-0400) Subject: for convenience, see which file has which function X-Git-Url: http://git.equinoxoli.org/?p=migration-tools.git;a=commitdiff_plain;h=5f2f0b8c313ee10c00829689d89676482ee4fb54 for convenience, see which file has which function --- diff --git a/sql/base/MANIFEST b/sql/base/MANIFEST new file mode 100755 index 0000000..1d3f621 --- /dev/null +++ b/sql/base/MANIFEST @@ -0,0 +1,149 @@ +#!/bin/bash +grep -i 'CREATE OR REPLACE FUNCTION' *.sql | perl -ne 'if (/^(.+?):.*(migration_tools.+?)[ \(].*$/) { print "# $1:$2\n"; }' | sort + +# 00-infrastructure.sql:migration_tools.build +# 00-infrastructure.sql:migration_tools.build_base_staging_tables +# 00-infrastructure.sql:migration_tools.build_specific_base_staging_table +# 00-infrastructure.sql:migration_tools.create_linked_legacy_table_from +# 00-infrastructure.sql:migration_tools.init +# 00-infrastructure.sql:migration_tools.production_tables +# 01-marc.sql:migration_tools.consolidate_tag +# 01-marc.sql:migration_tools.get_marc_leader +# 01-marc.sql:migration_tools.get_marc_tag +# 01-marc.sql:migration_tools.get_marc_tags +# 01-marc.sql:migration_tools.get_marc_tags_filtered +# 01-marc.sql:migration_tools.insert_tags +# 01-marc.sql:migration_tools.insert_tags +# 01-marc.sql:migration_tools.make_stub_bib +# 01-marc.sql:migration_tools.make_stub_bib +# 01-marc.sql:migration_tools.marc_parses +# 01-marc.sql:migration_tools.merge_marc_fields +# 01-marc.sql:migration_tools.merge_sf9 +# 01-marc.sql:migration_tools.munge_sf9 +# 01-marc.sql:migration_tools.munge_sf9_qualifying_match +# 01-marc.sql:migration_tools.owner_change_sf9_substring_match +# 01-marc.sql:migration_tools.owner_change_sf9_substring_match2 +# 01-marc.sql:migration_tools.set_008 +# 01-marc.sql:migration_tools.set_008 +# 01-marc.sql:migration_tools.set_indicator +# 01-marc.sql:migration_tools.set_leader +# 01-marc.sql:migration_tools.set_leader +# 01-marc.sql:migration_tools.strip_tag +# 01-marc.sql:migration_tools.strip_tag +# 02-barcodes.sql:migration_tools.add_codabar_checkdigit +# 02-barcodes.sql:migration_tools.add_code39mod43_checkdigit +# 02-barcodes.sql:migration_tools.add_mod16_checkdigit +# 02-barcodes.sql:migration_tools.expand_barcode +# 02-barcodes.sql:migration_tools.rebarcode +# 03-items.sql:migration_tools.change_call_number +# 03-items.sql:migration_tools.change_owning_lib +# 03-items.sql:migration_tools.change_owning_lib +# 04-names.sql:migration_tools.name_parse_out_first_middle_last_comma_suffix +# 04-names.sql:migration_tools.name_parse_out_fuller_last_first_middle_and_random_affix +# 04-names.sql:migration_tools.name_parse_out_fuller_last_first_middle_and_random_affix2 +# 04-names.sql:migration_tools.name_parse_out_last_comma_prefix_first_middle_suffix +# 04-names.sql:migration_tools.name_parse_out_last_first_middle_and_random_affix +# 05-addresses.sql:migration_tools.attempt_phone +# 05-addresses.sql:migration_tools._normalize_address_suffix +# 05-addresses.sql:migration_tools.normalize_address_suffix +# 05-addresses.sql:migration_tools.parse_out_address +# 05-addresses.sql:migration_tools.parse_out_address2 +# 05-addresses.sql:migration_tools.zip_to_city_state_county +# 06-ils-specific.sql:migration_tools.attempt_hz_date +# 06-ils-specific.sql:migration_tools.attempt_sierra_timestamp +# 06-ils-specific.sql:migration_tools.generate_koha_holding_tag +# 06-ils-specific.sql:migration_tools.openbiblio2marc +# 07-eg-specific.sql:migration_tools.apply_circ_matrix +# 07-eg-specific.sql:migration_tools.apply_circ_matrix_to_specific_circ +# 07-eg-specific.sql:migration_tools.assign_standing_penalties +# 07-eg-specific.sql:migration_tools.check_ou_depth +# 07-eg-specific.sql:migration_tools.create_cards +# 07-eg-specific.sql:migration_tools.create_staff_user +# 07-eg-specific.sql:migration_tools.duplicate_template +# 07-eg-specific.sql:migration_tools.duplicate_template_but_change_delay +# 07-eg-specific.sql:migration_tools.duplicate_templates +# 07-eg-specific.sql:migration_tools.find_circ_matrix_matchpoint +# 07-eg-specific.sql:migration_tools.find_hold_matrix_matchpoint +# 07-eg-specific.sql:migration_tools.find_hold_matrix_matchpoint2 +# 07-eg-specific.sql:migration_tools.get_copy_price +# 07-eg-specific.sql:migration_tools.insert_metarecords_for_incumbent_database +# 07-eg-specific.sql:migration_tools.insert_metarecords_for_pristine_database +# 07-eg-specific.sql:migration_tools.is_staff_profile +# 07-eg-specific.sql:migration_tools.reset_event +# 07-eg-specific.sql:migration_tools.simple_export_library_config +# 07-eg-specific.sql:migration_tools.simple_import_library_config +# 08-casting-and-validation.sql:migration_tools.attempt_cast +# 08-casting-and-validation.sql:migration_tools.attempt_date +# 08-casting-and-validation.sql:migration_tools.attempt_money +# 08-casting-and-validation.sql:migration_tools.attempt_money6 +# 08-casting-and-validation.sql:migration_tools.attempt_money_from_pennies +# 08-casting-and-validation.sql:migration_tools.attempt_money_from_pennies6 +# 08-casting-and-validation.sql:migration_tools.attempt_timestamptz +# 09-misc.sql:migration_tools.is_blank +# 10-staging.sql:migration_tools.simple_import_new_rows_by_value +# 10-staging.sql:migration_tools.split_rows_on_column_with_delimiter +# 10-staging.sql:migration_tools.stage_not_applicable_asset_stat_cats +# 99-deprecated.sql:migration_tools.apply_circ_matrix_after_20 +# 99-deprecated.sql:migration_tools.apply_circ_matrix_before_20 +# 99-deprecated.sql:migration_tools.attempt_phone +# 99-deprecated.sql:migration_tools.base_circ_field_map +# 99-deprecated.sql:migration_tools.base_copy_location_map +# 99-deprecated.sql:migration_tools.base_item_dynamic_field_map +# 99-deprecated.sql:migration_tools.insert_856_9 +# 99-deprecated.sql:migration_tools.insert_856_9_conditional +# 99-deprecated.sql:migration_tools.is_staff_profile +# 99-deprecated.sql:migration_tools.map_base_circ_table_dynamic +# 99-deprecated.sql:migration_tools.map_base_item_table_dynamic +# 99-deprecated.sql:migration_tools.map_base_item_table_locations +# 99-deprecated.sql:migration_tools.map_base_patron_profile +# 99-deprecated.sql:migration_tools.refresh_opac_visible_copies +# base.sql:migration_tools.assert +# base.sql:migration_tools.assert +# base.sql:migration_tools.assert +# base.sql:migration_tools.btrim_columns +# base.sql:migration_tools.btrim_lcolumns +# base.sql:migration_tools.build +# base.sql:migration_tools.build_base_staging_tables +# base.sql:migration_tools.build_specific_base_staging_table +# base.sql:migration_tools.country_code +# base.sql:migration_tools.create_linked_legacy_table_from +# base.sql:migration_tools.debug_exec +# base.sql:migration_tools.exec +# base.sql:migration_tools.find_mig_shelf +# base.sql:migration_tools.find_shelf +# base.sql:migration_tools.handle_actor_barcode_collisions +# base.sql:migration_tools.handle_actor_barcode_collisions2 +# base.sql:migration_tools.handle_actor_sc_and_sce +# base.sql:migration_tools.handle_asset_barcode_collisions +# base.sql:migration_tools.handle_asset_barcode_collisions2 +# base.sql:migration_tools.handle_asset_sc_and_sce +# base.sql:migration_tools.handle_barred_or_blocked +# base.sql:migration_tools.handle_circmod +# base.sql:migration_tools.handle_item_barcode +# base.sql:migration_tools.handle_link +# base.sql:migration_tools.handle_link2 +# base.sql:migration_tools.handle_link3 +# base.sql:migration_tools.handle_link3_concat_skip_null +# base.sql:migration_tools.handle_link3_skip_false +# base.sql:migration_tools.handle_link3_skip_null +# base.sql:migration_tools.handle_link3_skip_null_or_empty_string +# base.sql:migration_tools.handle_link3_skip_true +# base.sql:migration_tools.handle_not_migrate +# base.sql:migration_tools.handle_org +# base.sql:migration_tools.handle_profile +# base.sql:migration_tools._handle_shelf +# base.sql:migration_tools.handle_shelf +# base.sql:migration_tools.handle_status +# base.sql:migration_tools.handle_user_barcode +# base.sql:migration_tools.init +# base.sql:migration_tools.insert_base_into_production +# base.sql:migration_tools.insert_into_production +# base.sql:migration_tools.is_circ_rule_safe_to_delete +# base.sql:migration_tools.log +# base.sql:migration_tools.null_empty_columns +# base.sql:migration_tools.null_empty_lcolumns +# base.sql:migration_tools.production_tables +# base.sql:migration_tools.push_bib_sequence +# base.sql:migration_tools.set_salted_passwd +# base.sql:migration_tools.vivicate_actor_sc_and_sce +# base.sql:migration_tools.vivicate_asset_sc_and_sce