Open-ILS/src/sql/Pg/live_t/0847.auth_overlay_generator.pg

   1 \set ECHO
   2 \set QUIET 1
   3 -- Turn off echo and keep things quiet.
   4
   5 -- Format the output for nice TAP.
   6 \pset format unaligned
   7 \pset tuples_only true
   8 \pset pager
   9
  10 -- Revert all changes on failure.
  11 \set ON_ERROR_ROLLBACK 1
  12 \set ON_ERROR_STOP true
  13 \set QUIET 1
  14
  15 -- let's do this thing
  16 BEGIN;
  17
  18 SELECT plan(1);
  19
  20 SELECT is(
  21     $$<record xmlns="http://www.loc.gov/MARC21/slim"><leader>00881nam a2200193   4500</leader><datafield tag="600" ind1="1" ind2=" "><subfield xmlns="http://www.loc.gov/MARC21/slim" code="a">Girdlestone, Cuthbert Morton,</subfield><subfield xmlns="http://www.loc.gov/MARC21/slim" code="d">1895-1975</subfield></datafield><datafield tag="100" ind1="1" ind2=" "><subfield xmlns="http://www.loc.gov/MARC21/slim" code="a">Girdlestone, Cuthbert Morton,</subfield><subfield xmlns="http://www.loc.gov/MARC21/slim" code="d">1895-1975</subfield></datafield><datafield tag="700" ind1="1" ind2=" "><subfield xmlns="http://www.loc.gov/MARC21/slim" code="a">Girdlestone, Cuthbert Morton,</subfield><subfield xmlns="http://www.loc.gov/MARC21/slim" code="d">1895-1975</subfield></datafield><datafield tag="800" ind1="1" ind2=" "><subfield xmlns="http://www.loc.gov/MARC21/slim" code="a">Girdlestone, Cuthbert Morton,</subfield><subfield xmlns="http://www.loc.gov/MARC21/slim" code="d">1895-1975</subfield></datafield><datafield tag="905" ind1=" " ind2=" "><subfield code="r">600abcdfklmnopqrstvxyz[0~\)1$],100abcdfklmnopqrstvxyz[0~\)1$],700abcdfklmnopqrstvxyz[0~\)1$],800abcdfklmnopqrstvxyz[0~\)1$]</subfield></datafield></record>$$,
  22     (select authority.generate_overlay_template(marc) from authority.record_entry where id = 1),
  23     'authority.generate_overlay_template includes indicators and excludes junk tags'
  24 );
  25
  26
  27 SELECT * FROM finish();
  28 ROLLBACK;
  29