Open-ILS/src/sql/Pg/t/lp1588543_marc_record_attributes.pg

   1 -- tests to verify that the expected record attributes are
   2 -- parsed during record ingest; note that this is expected
   3 -- to fluctuate as seed data for record attributes definitions
   4 -- get updated.
   5 BEGIN;
   6
   7 SELECT plan(2);
   8
   9 INSERT INTO biblio.record_entry (last_xact_id, marc) VALUES (
  10     'marc-attr-test',
  11     $record$<record xmlns="http://www.loc.gov/MARC21/slim">
  12   <leader>02137cam a2200457 a 4500</leader>
  13   <controlfield tag="001">ocn694080497</controlfield>
  14   <controlfield tag="003">OCoLC</controlfield>
  15   <controlfield tag="005">20160729104757.0</controlfield>
  16   <controlfield tag="008">101217s2011    txu      b    001 0 eng  </controlfield>
  17   <datafield tag="010" ind1=" " ind2=" ">
  18     <subfield code="a">  2010053400</subfield>
  19   </datafield>
  20   <datafield tag="040" ind1=" " ind2=" ">
  21     <subfield code="a">DLC</subfield>
  22     <subfield code="b">eng</subfield>
  23     <subfield code="c">DLC</subfield>
  24     <subfield code="d">RCJ</subfield>
  25     <subfield code="d">CLU</subfield>
  26     <subfield code="d">YDXCP</subfield>
  27     <subfield code="d">BWX</subfield>
  28     <subfield code="d">YLS</subfield>
  29     <subfield code="d">CDX</subfield>
  30     <subfield code="d">ONA</subfield>
  31     <subfield code="d">OCLCF</subfield>
  32     <subfield code="d">OCLCO</subfield>
  33     <subfield code="d">OCL</subfield>
  34     <subfield code="d">OCLCQ</subfield>
  35     <subfield code="d">OCLCO</subfield>
  36   </datafield>
  37   <datafield tag="020" ind1=" " ind2=" ">
  38     <subfield code="a">9780735587786</subfield>
  39   </datafield>
  40   <datafield tag="020" ind1=" " ind2=" ">
  41     <subfield code="a">0735587787</subfield>
  42   </datafield>
  43   <datafield tag="020" ind1=" " ind2=" ">
  44     <subfield code="a">9780735587793</subfield>
  45     <subfield code="q">(pbk. ;</subfield>
  46     <subfield code="q">teacher&apos;s manual)</subfield>
  47   </datafield>
  48   <datafield tag="020" ind1=" " ind2=" ">
  49     <subfield code="a">0735587795</subfield>
  50     <subfield code="q">(pbk. ;</subfield>
  51     <subfield code="q">teacher&apos;s manual)</subfield>
  52   </datafield>
  53   <datafield tag="035" ind1=" " ind2=" ">
  54     <subfield code="a">(OCoLC)694080497</subfield>
  55   </datafield>
  56   <datafield tag="042" ind1=" " ind2=" ">
  57     <subfield code="a">pcc</subfield>
  58   </datafield>
  59   <datafield tag="043" ind1=" " ind2=" ">
  60     <subfield code="a">n-us---</subfield>
  61   </datafield>
  62   <datafield tag="050" ind1="0" ind2="0">
  63     <subfield code="a">KF9619</subfield>
  64     <subfield code="b">.C62 2011</subfield>
  65   </datafield>
  66   <datafield tag="082" ind1="0" ind2="0">
  67     <subfield code="a">345.73/05</subfield>
  68     <subfield code="2">22</subfield>
  69   </datafield>
  70   <datafield tag="049" ind1=" " ind2=" ">
  71     <subfield code="a">EQNX</subfield>
  72   </datafield>
  73   <datafield tag="245" ind1="0" ind2="0">
  74     <subfield code="a">Comprehensive criminal procedure /</subfield>
  75     <subfield code="c">Ronald Jay Allen [and others].</subfield>
  76   </datafield>
  77   <datafield tag="250" ind1=" " ind2=" ">
  78     <subfield code="a">3rd ed.</subfield>
  79   </datafield>
  80   <datafield tag="260" ind1=" " ind2=" ">
  81     <subfield code="a">Austin :</subfield>
  82     <subfield code="b">Wolters Kluwer Law &amp; Business,</subfield>
  83     <subfield code="c">©2011.</subfield>
  84   </datafield>
  85   <datafield tag="300" ind1=" " ind2=" ">
  86     <subfield code="a">xxxvi, 1699 pages ;</subfield>
  87     <subfield code="c">26 cm +</subfield>
  88     <subfield code="e">teacher&apos;s manual.</subfield>
  89   </datafield>
  90   <datafield tag="336" ind1=" " ind2=" ">
  91     <subfield code="a">text</subfield>
  92     <subfield code="b">txt</subfield>
  93     <subfield code="2">rdacontent</subfield>
  94   </datafield>
  95   <datafield tag="337" ind1=" " ind2=" ">
  96     <subfield code="a">unmediated</subfield>
  97     <subfield code="b">n</subfield>
  98     <subfield code="2">rdamedia</subfield>
  99   </datafield>
 100   <datafield tag="338" ind1=" " ind2=" ">
 101     <subfield code="a">volume</subfield>
 102     <subfield code="b">nc</subfield>
 103     <subfield code="2">rdacarrier</subfield>
 104   </datafield>
 105   <datafield tag="490" ind1="1" ind2=" ">
 106     <subfield code="a">Aspen casebook series</subfield>
 107   </datafield>
 108   <datafield tag="504" ind1=" " ind2=" ">
 109     <subfield code="a">Includes bibliographical references and index.</subfield>
 110   </datafield>
 111   <datafield tag="505" ind1="0" ind2=" ">
 112     <subfield code="a">Introduction to the criminal justice &quot;system&quot; -- The idea of due process -- The right to counsel and other assistance -- The rise and fall of Boyd v. United States -- The Fourth Amendment -- The Fifth Amendment -- Complex investigations in the Fourth Amendment&apos;s shadow -- Bail and pretrial detention -- The charging decision -- Pretrial screening and the grand jury -- The scope of the prosecution -- Discovery and disclosure -- Guilty pleas and plea bargaining -- The jury and the criminal trial -- Sentencing -- Double jeopardy -- Appellate and collateral review.</subfield>
 113   </datafield>
 114   <datafield tag="650" ind1=" " ind2="0">
 115     <subfield code="a">Criminal procedure</subfield>
 116     <subfield code="z">United States.</subfield>
 117   </datafield>
 118   <datafield tag="650" ind1=" " ind2="7">
 119     <subfield code="a">Criminal procedure.</subfield>
 120     <subfield code="2">fast</subfield>
 121     <subfield code="0">(OCoLC)fst00883421</subfield>
 122   </datafield>
 123   <datafield tag="651" ind1=" " ind2="7">
 124     <subfield code="a">United States.</subfield>
 125     <subfield code="2">fast</subfield>
 126     <subfield code="0">(OCoLC)fst01204155</subfield>
 127   </datafield>
 128   <datafield tag="655" ind1=" " ind2="7">
 129     <subfield code="a">Casebooks.</subfield>
 130     <subfield code="2">fast</subfield>
 131     <subfield code="0">(OCoLC)fst01774238</subfield>
 132   </datafield>
 133   <datafield tag="655" ind1=" " ind2="7">
 134     <subfield code="a">Casebooks.</subfield>
 135     <subfield code="2">lcgft</subfield>
 136   </datafield>
 137   <datafield tag="700" ind1="1" ind2=" ">
 138     <subfield code="a">Allen, Ronald J.</subfield>
 139     <subfield code="q">(Ronald Jay),</subfield>
 140     <subfield code="d">1948-</subfield>
 141   </datafield>
 142   <datafield tag="830" ind1=" " ind2="0">
 143     <subfield code="a">Aspen casebook series.</subfield>
 144   </datafield>
 145 </record>$record$);
 146
 147 SELECT cmp_ok(
 148     (SELECT attrs FROM metabib.record_attr WHERE id=(SELECT CURRVAL('biblio.record_entry_id_seq'))),
 149     '@>',
 150     $attr$
 151         "conf"=>"0",
 152         "cont"=>"b",
 153         "ctry"=>"txu",
 154         "fest"=>"0",
 155         "ills"=>" ",
 156         "indx"=>"1",
 157         "cont1"=>"b",
 158         "date1"=>"2011",
 159         "date2"=>"9999",
 160         "ills1"=>" ",
 161         "audience"=>" ",
 162         "cat_form"=>"a",
 163         "language"=>"eng",
 164         "lit_form"=>"0",
 165         "bib_level"=>"m",
 166         "item_lang"=>"eng",
 167         "item_type"=>"a",
 168         "media_type"=>"unmediated",
 169         "pub_status"=>"s",
 170         "icon_format"=>"book",
 171         "carrier_type"=>"volume",
 172         "content_type"=>"text",
 173         "search_format"=>"book",
 174         "mr_hold_format"=>"book"
 175     $attr$,
 176     'all expected record attributes found'
 177 );
 178
 179 SELECT cmp_ok(
 180     (SELECT attrs FROM metabib.record_attr WHERE id=(SELECT CURRVAL('biblio.record_entry_id_seq'))),
 181     '<@',
 182     $attr$
 183         "conf"=>"0",
 184         "cont"=>"b",
 185         "ctry"=>"txu",
 186         "fest"=>"0",
 187         "ills"=>" ",
 188         "indx"=>"1",
 189         "cont1"=>"b",
 190         "date1"=>"2011",
 191         "date2"=>"9999",
 192         "ills1"=>" ",
 193         "audience"=>" ",
 194         "cat_form"=>"a",
 195         "language"=>"eng",
 196         "lit_form"=>"0",
 197         "bib_level"=>"m",
 198         "item_lang"=>"eng",
 199         "item_type"=>"a",
 200         "media_type"=>"unmediated",
 201         "pub_status"=>"s",
 202         "icon_format"=>"book",
 203         "carrier_type"=>"volume",
 204         "content_type"=>"text",
 205         "search_format"=>"book",
 206         "mr_hold_format"=>"book"
 207     $attr$,
 208     'no extra record attributes found'
 209 );
 210
 211 ROLLBACK;