From 2ad87814f6d7bc908051e184ff538e493126b9fe Mon Sep 17 00:00:00 2001 From: Jason Etheridge Date: Fri, 7 Apr 2017 10:53:13 -0400 Subject: [PATCH] some useful wrappers for loading bre's --- sql/templates/bib_fast_template.sql | 3 +++ sql/templates/bib_slow_template.sql | 21 +++++++++++++++++++++ 2 files changed, 24 insertions(+), 0 deletions(-) create mode 100644 sql/templates/bib_fast_template.sql create mode 100644 sql/templates/bib_slow_template.sql diff --git a/sql/templates/bib_fast_template.sql b/sql/templates/bib_fast_template.sql new file mode 100644 index 0000000..1b56773 --- /dev/null +++ b/sql/templates/bib_fast_template.sql @@ -0,0 +1,3 @@ +SET CLIENT_ENCODING TO 'UNICODE'; + +\COPY biblio.record_entry (active,create_date,creator,deleted,edit_date,editor,fingerprint,id,last_xact_id,marc,quality,source,tcn_source,tcn_value,owner,share_depth) FROM 'XXX' diff --git a/sql/templates/bib_slow_template.sql b/sql/templates/bib_slow_template.sql new file mode 100644 index 0000000..6d29f5b --- /dev/null +++ b/sql/templates/bib_slow_template.sql @@ -0,0 +1,21 @@ +SET CLIENT_ENCODING TO 'UNICODE'; + +BEGIN; + +UPDATE + config.internal_flag +SET + enabled = 't' +WHERE + name IN ('ingest.assume_inserts_only','ingest.disable_located_uri','ingest.metarecord_mapping.skip_on_insert'); + +\COPY biblio.record_entry (active,create_date,creator,deleted,edit_date,editor,fingerprint,id,last_xact_id,marc,quality,source,tcn_source,tcn_value,owner,share_depth) FROM 'XXX' + +UPDATE + config.internal_flag +SET + enabled = 'f' +WHERE + name IN ('ingest.assume_inserts_only','ingest.disable_located_uri','ingest.metarecord_mapping.skip_on_insert'); + +COMMIT; -- 1.7.2.5