LP#1665626: adding new records to the meta group and breaking into new file
authorRogan Hamby <rogan.hamby@gmail.com>
Mon, 20 Feb 2017 19:11:18 +0000 (14:11 -0500)
committerBen Shum <ben@evergreener.net>
Tue, 21 Feb 2017 21:49:28 +0000 (16:49 -0500)
Signed-off-by: Rogan Hamby <rogan.hamby@gmail.com>
Signed-off-by: Ben Shum <ben@evergreener.net>
Open-ILS/tests/datasets/sql/assets_mr.sql [new file with mode: 0644]
Open-ILS/tests/datasets/sql/bibs_mr.sql [new file with mode: 0644]
Open-ILS/tests/datasets/sql/load_all.sql

diff --git a/Open-ILS/tests/datasets/sql/assets_mr.sql b/Open-ILS/tests/datasets/sql/assets_mr.sql
new file mode 100644 (file)
index 0000000..2fafd63
--- /dev/null
@@ -0,0 +1,28 @@
+-- Create call numbers
+SELECT evergreen.populate_call_number(4, 'MR ', 'IMPORT MR', NULL); -- BR1
+SELECT evergreen.populate_call_number(5, 'MR ', 'IMPORT MR', NULL); -- BR2
+SELECT evergreen.populate_call_number(6, 'MR ', 'IMPORT MR', NULL); -- BR3
+SELECT evergreen.populate_call_number(7, 'MR ', 'IMPORT MR', NULL); -- BR4
+SELECT evergreen.populate_call_number(9, 'MR ', 'IMPORT MR', NULL); -- BM1
+
+-- Create copies
+SELECT evergreen.populate_copy(4, 4, 'MR40000', 'MR'); -- BR1
+SELECT evergreen.populate_copy(5, 5, 'MR50000', 'MR'); -- BR2
+SELECT evergreen.populate_copy(6, 6, 'MR60000', 'MR'); -- BR3
+SELECT evergreen.populate_copy(7, 7, 'MR70000', 'MR'); -- BR4
+SELECT evergreen.populate_copy(9, 9, 'MR90000', 'MR'); -- BM1
+
+SELECT evergreen.populate_copy(4, 4, 'MR41000', 'MR'); -- BR1
+SELECT evergreen.populate_copy(4, 4, 'MR42000', 'MR'); -- BR1
+SELECT evergreen.populate_copy(4, 4, 'MR43000', 'MR'); -- BR1
+SELECT evergreen.populate_copy(4, 4, 'MR44000', 'MR'); -- BR1
+SELECT evergreen.populate_copy(4, 4, 'MR45000', 'MR'); -- BR1
+SELECT evergreen.populate_copy(4, 4, 'MR46000', 'MR'); -- BR1
+SELECT evergreen.populate_copy(4, 4, 'MR47000', 'MR'); -- BR1
+SELECT evergreen.populate_copy(4, 4, 'MR48000', 'MR'); -- BR1
+SELECT evergreen.populate_copy(4, 4, 'MR49000', 'MR'); -- BR1
+
+SELECT evergreen.populate_copy(5, 5, 'MR51000', 'MR'); -- BR2
+SELECT evergreen.populate_copy(6, 6, 'MR61000', 'MR'); -- BR3
+SELECT evergreen.populate_copy(7, 7, 'MR71000', 'MR'); -- BR4
+SELECT evergreen.populate_copy(9, 9, 'MR91000', 'MR'); -- BM1
diff --git a/Open-ILS/tests/datasets/sql/bibs_mr.sql b/Open-ILS/tests/datasets/sql/bibs_mr.sql
new file mode 100644 (file)
index 0000000..04f4895
--- /dev/null
@@ -0,0 +1,12 @@
+\set bib_tag '''IMPORT MR'''
+
+INSERT INTO marcxml_import (tag, marc) VALUES
+
+(:bib_tag,'<record><leader>00918nim a22002535  4500</leader><controlfield tag="001">2838534</controlfield><controlfield tag="005">20131130185904.0</controlfield><controlfield tag="007">sd|uungnnmmneu</controlfield><controlfield tag="008">130904                             eng  </controlfield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">9781482926323 (CMD)</subfield><subfield code="c">$19.95</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">1482926326 (CMD)</subfield><subfield code="c">$19.95</subfield></datafield><datafield tag="037" ind1=" " ind2=" "><subfield code="b">Blackstone Audio Inc, Special Markets Po Box 969, Ashland, OR, USA, 97520, (541)4886035</subfield><subfield code="n">SAN 173-2811</subfield></datafield><datafield tag="040" ind1=" " ind2=" "><subfield code="d">UtOrBLW</subfield></datafield><datafield tag="082" ind1="0" ind2=" "><subfield code="a">813</subfield></datafield><datafield tag="092" ind1=" " ind2=" "><subfield code="a">813.0000</subfield></datafield><datafield tag="100" ind1="1" ind2=" "><subfield code="a">Lovecraft, H. P./ Herrmann, Edward (NRT)</subfield></datafield><datafield tag="245" ind1="1" ind2="0"><subfield code="a">At the Mountains of Madness</subfield><subfield code="h">[sound recording].</subfield></datafield><datafield tag="264" ind1=" " ind2="1"><subfield code="a">[Place of publication not identified] :</subfield><subfield code="b">Blackstone Audio Inc,</subfield><subfield code="c">2013.</subfield></datafield><datafield tag="336" ind1=" " ind2=" "><subfield code="a">spoken word</subfield><subfield code="2">rdacontent</subfield></datafield><datafield tag="337" ind1=" " ind2=" "><subfield code="a">audio</subfield><subfield code="2">rdamedia</subfield></datafield><datafield tag="338" ind1=" " ind2=" "><subfield code="a">audio disc</subfield><subfield code="2">rdacarrier</subfield></datafield></record>'),
+(:bib_tag,'<record><leader>01423pam a2200373 a 4500</leader><controlfield tag="001">3079565</controlfield><controlfield tag="005">20080108231100.0</controlfield><controlfield tag="008">080108s2005    nyu      b    001 1 eng  </controlfield><datafield tag="010" ind1=" " ind2=" "><subfield code="a">2005-041555</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">0812974417 (pbk.) :</subfield><subfield code="c">$15.95</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(DLC)2005041555</subfield></datafield><datafield tag="040" ind1=" " ind2=" "><subfield code="a">DLC</subfield><subfield code="c">DLC</subfield><subfield code="d">DLC</subfield></datafield><datafield tag="043" ind1=" " ind2=" "><subfield code="a">t------</subfield></datafield><datafield tag="082" ind1="0" ind2="0"><subfield code="a">813/.52</subfield><subfield code="2">22</subfield></datafield><datafield tag="099" ind1=" " ind2=" "><subfield code="a">F</subfield><subfield code="a">LOVECRAFT</subfield></datafield><datafield tag="100" ind1="1" ind2=" "><subfield code="a">Lovecraft, H. P.</subfield><subfield code="q">(Howard Phillips),</subfield><subfield code="d">1890-1937.</subfield></datafield><datafield tag="245" ind1="1" ind2="0"><subfield code="a">At the mountains of madness /</subfield><subfield code="c">H.P. Lovecraft ; introduction by China Mie ville.</subfield></datafield><datafield tag="250" ind1=" " ind2=" "><subfield code="a">Definitive ed.</subfield></datafield><datafield tag="260" ind1=" " ind2=" "><subfield code="a">New York :</subfield><subfield code="b">Modern Library,</subfield><subfield code="c">2005.</subfield></datafield><datafield tag="300" ind1=" " ind2=" "><subfield code="a">xxv, 186 p. ;</subfield><subfield code="c">20 cm.</subfield></datafield><datafield tag="501" ind1=" " ind2=" "><subfield code="a">MARCIVE 12/19/07</subfield></datafield><datafield tag="504" ind1=" " ind2=" "><subfield code="a">Includes bibliographical references (p. xxiv-xxv) and index.</subfield></datafield><datafield tag="505" ind1="0" ind2=" "><subfield code="a">At the mountains of madness -- Supernatural horror in literature.</subfield></datafield><datafield tag="650" ind1=" " ind2="0"><subfield code="a">Fossils</subfield><subfield code="x">Collection and preservation</subfield><subfield code="v">Fiction.</subfield></datafield><datafield tag="650" ind1=" " ind2="0"><subfield code="a">Scientific expeditions</subfield><subfield code="v">Fiction.</subfield></datafield><datafield tag="650" ind1=" " ind2="0"><subfield code="a">Supernatural in literature.</subfield></datafield><datafield tag="650" ind1=" " ind2="0"><subfield code="a">Stone carving</subfield><subfield code="v">Fiction.</subfield></datafield><datafield tag="651" ind1=" " ind2="0"><subfield code="a">Antarctica</subfield><subfield code="v">Fiction.</subfield></datafield><datafield tag="655" ind1=" " ind2="7"><subfield code="a">Fantasy fiction.</subfield><subfield code="2">gsafd</subfield></datafield><datafield tag="655" ind1=" " ind2="7"><subfield code="a">Horror fiction.</subfield><subfield code="2">gsafd</subfield></datafield><datafield tag="700" ind1="1" ind2="2"><subfield code="a">Lovecraft, H. P.</subfield><subfield code="q">(Howard Phillips),</subfield><subfield code="d">1890-1937.</subfield><subfield code="t">Supernatural horror in literature.</subfield></datafield></record>'),
+(:bib_tag,'<record><leader>01639nim a2200445 a 4500</leader><controlfield tag="001">4101339</controlfield><controlfield tag="005">20140714090509.0</controlfield><controlfield tag="007">sd fungnnmmned</controlfield><controlfield tag="008">140709s2012    tnunnnn        f  n eng d</controlfield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">9781843795940</subfield></datafield><datafield tag="028" ind1="0" ind2="1"><subfield code="a">DD10435</subfield><subfield code="b">Recorded Books</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(CtWfDGI)rdd90010435</subfield></datafield><datafield tag="040" ind1=" " ind2=" "><subfield code="a">CtWfDGI</subfield><subfield code="b">eng</subfield><subfield code="c">CtWfDGI</subfield></datafield><datafield tag="043" ind1=" " ind2=" "><subfield code="a">t------</subfield></datafield><datafield tag="050" ind1="1" ind2="4"><subfield code="a">PS3523.O833</subfield><subfield code="b">A96 2012b</subfield></datafield><datafield tag="082" ind1="0" ind2="4"><subfield code="a">813/.52</subfield><subfield code="2">23</subfield></datafield><datafield tag="098" ind1="1" ind2="4"><subfield code="a">V</subfield><subfield code="a">LOVE</subfield><subfield code="a">AMM</subfield><subfield code="a">R 35</subfield></datafield><datafield tag="100" ind1="1" ind2=" "><subfield code="a">Lovecraft, H. P.</subfield><subfield code="q">(Howard Phillips),</subfield><subfield code="d">1890-1937.</subfield></datafield><datafield tag="245" ind1="1" ind2="0"><subfield code="a">At the mountains of madness</subfield><subfield code="h">[sound recording] /</subfield><subfield code="c">H.P. Lovecraft.</subfield></datafield><datafield tag="250" ind1=" " ind2=" "><subfield code="a">Unabridged.</subfield></datafield><datafield tag="260" ind1=" " ind2=" "><subfield code="a">Franklin, TN :</subfield><subfield code="b">Naxos AudioBooks ;</subfield><subfield code="a">Prince Frederick, MD :</subfield><subfield code="b">Distributed by Recorded Books,</subfield><subfield code="c">p2012.</subfield></datafield><datafield tag="300" ind1=" " ind2=" "><subfield code="a">4 sound discs (5 hr.) :</subfield><subfield code="b">digital ;</subfield><subfield code="c">4 3/4 in.</subfield></datafield><datafield tag="500" ind1=" " ind2=" "><subfield code="a">Title from container.</subfield></datafield><datafield tag="500" ind1=" " ind2=" "><subfield code="a">Compact disc.</subfield></datafield><datafield tag="500" ind1=" " ind2=" "><subfield code="a">In container (17 cm.).</subfield></datafield><datafield tag="511" ind1="0" ind2=" "><subfield code="a">Read by William Roberts.</subfield></datafield><datafield tag="520" ind1=" " ind2=" "><subfield code="a">An old man consents to a radio interview and a number of terrible truths are revealed about an expedition of Antarctica in the 1920&apos;s where everyone died horribly.</subfield></datafield><datafield tag="650" ind1=" " ind2="0"><subfield code="a">Scientific expeditions</subfield><subfield code="v">Fiction.</subfield></datafield><datafield tag="650" ind1=" " ind2="0"><subfield code="a">Stone carving</subfield><subfield code="v">Fiction.</subfield></datafield><datafield tag="650" ind1=" " ind2="0"><subfield code="a">Supernatural in literature.</subfield></datafield><datafield tag="650" ind1=" " ind2="0"><subfield code="a">Fossils</subfield><subfield code="x">Collection and preservation</subfield><subfield code="v">Fiction.</subfield></datafield><datafield tag="651" ind1=" " ind2="0"><subfield code="a">Antarctica</subfield><subfield code="v">Fiction.</subfield></datafield><datafield tag="655" ind1=" " ind2="7"><subfield code="a">Horror fiction.</subfield><subfield code="2">gsafd</subfield></datafield><datafield tag="655" ind1=" " ind2="7"><subfield code="a">Fantasy fiction.</subfield><subfield code="2">gsafd</subfield></datafield><datafield tag="655" ind1=" " ind2="7"><subfield code="a">Audiobooks.</subfield><subfield code="2">lcgft</subfield></datafield><datafield tag="700" ind1="1" ind2=" "><subfield code="a">Roberts, William,</subfield><subfield code="d">1943-</subfield><subfield code="4">nrt</subfield></datafield><datafield tag="710" ind1="2" ind2=" "><subfield code="a">Naxos AudioBooks, Ltd.</subfield></datafield><datafield tag="710" ind1="2" ind2=" "><subfield code="a">Recorded Books, LLC.</subfield></datafield></record>'),
+(:bib_tag,'<record><leader>01132cam a2200337Ka 4500</leader><controlfield tag="001">9403800</controlfield><controlfield tag="005">20170130113807.0</controlfield><controlfield tag="008">160622s2017    nyu     d     000 1 eng d</controlfield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(OCoLC)952384050</subfield></datafield><datafield tag="040" ind1=" " ind2=" "><subfield code="a">BTCTA</subfield><subfield code="b">eng</subfield><subfield code="c">BTCTA</subfield><subfield code="d">BDX</subfield><subfield code="d">TEFBT</subfield><subfield code="d">OCLCO</subfield><subfield code="d">OCLCF</subfield><subfield code="d">TEFBT</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">9781524755614</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">1524755613</subfield></datafield><datafield tag="049" ind1=" " ind2=" "><subfield code="a">HQBA</subfield></datafield><datafield tag="082" ind1="0" ind2="4"><subfield code="a">813/.6</subfield><subfield code="2">23</subfield></datafield><datafield tag="099" ind1=" " ind2=" "><subfield code="a">LP</subfield><subfield code="a">CLINE</subfield></datafield><datafield tag="100" ind1="1" ind2=" "><subfield code="a">Cline, Ernest.</subfield></datafield><datafield tag="245" ind1="1" ind2="0"><subfield code="a">Ready player one /</subfield><subfield code="c">Ernest Cline.</subfield></datafield><datafield tag="260" ind1=" " ind2=" "><subfield code="a">[New York] :</subfield><subfield code="b">Random House Large Print,</subfield><subfield code="c">[2017]</subfield></datafield><datafield tag="300" ind1=" " ind2=" "><subfield code="a">608 p. (large print) ;</subfield><subfield code="c">24 cm.</subfield></datafield><datafield tag="650" ind1=" " ind2="0"><subfield code="a">Regression (Civilization)</subfield><subfield code="v">Fiction.</subfield></datafield><datafield tag="650" ind1=" " ind2="0"><subfield code="a">Virtual reality</subfield><subfield code="v">Fiction.</subfield></datafield><datafield tag="650" ind1=" " ind2="0"><subfield code="a">Shared virtual environments</subfield><subfield code="v">Fiction.</subfield></datafield><datafield tag="650" ind1=" " ind2="0"><subfield code="a">Utopias</subfield><subfield code="v">Fiction.</subfield></datafield><datafield tag="650" ind1=" " ind2="0"><subfield code="a">Puzzles</subfield><subfield code="v">Fiction.</subfield></datafield><datafield tag="650" ind1=" " ind2="0"><subfield code="a">Large type books.</subfield></datafield><datafield tag="655" ind1=" " ind2="7"><subfield code="a">Fantasy fiction.</subfield><subfield code="2">gsafd</subfield></datafield><datafield tag="929" ind1=" " ind2=" "><subfield code="a">B&amp;T</subfield></datafield></record>');
+(:bib_tag,'<record><leader>01817cim a2200481 i 4500</leader><controlfield tag="001">9206381</controlfield><controlfield tag="005">20120814110343.0</controlfield><controlfield tag="006">m        h        </controlfield><controlfield tag="007">cr una||||||||</controlfield><controlfield tag="007">sz usnnnn|||ed</controlfield><controlfield tag="008">111201s2011    nyunnnn o      ||   eng d</controlfield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">9780307913166 (electronic audio bk.)</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(TLC)erc0000004936</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(OCoLC)749998216</subfield></datafield><datafield tag="037" ind1=" " ind2=" "><subfield code="a">F9F9D65D-C3C8-445C-AE9D-D82B72C241D0</subfield><subfield code="b">OverDrive, Inc.</subfield><subfield code="n">http://www.overdrive.com</subfield></datafield><datafield tag="040" ind1=" " ind2=" "><subfield code="a">TLC</subfield><subfield code="c">TLC</subfield><subfield code="d">TLC</subfield><subfield code="e">rda</subfield></datafield><datafield tag="050" ind1="0" ind2="0"><subfield code="a">PS3603.L548</subfield><subfield code="b">R43 2011</subfield></datafield><datafield tag="082" ind1="0" ind2="0"><subfield code="a">813/.6</subfield><subfield code="2">22</subfield></datafield><datafield tag="100" ind1="1" ind2=" "><subfield code="a">Cline, Ernest,</subfield><subfield code="e">author.</subfield></datafield><datafield tag="245" ind1="1" ind2="0"><subfield code="a">Ready player one</subfield><subfield code="h">[electronic resource] /</subfield><subfield code="c">Ernest Cline.</subfield></datafield><datafield tag="264" ind1=" " ind2="1"><subfield code="a">New York :</subfield><subfield code="b">Crown Publishers</subfield></datafield><datafield tag="264" ind1=" " ind2="4"><subfield code="c">©2011</subfield></datafield><datafield tag="300" ind1=" " ind2=" "><subfield code="a">1 sound file :</subfield><subfield code="b">digital</subfield></datafield><datafield tag="336" ind1=" " ind2=" "><subfield code="a">spoken word</subfield><subfield code="b">spw</subfield><subfield code="2">rdacontent</subfield></datafield><datafield tag="337" ind1=" " ind2=" "><subfield code="a">computer</subfield><subfield code="b">c</subfield><subfield code="2">rdamedia</subfield></datafield><datafield tag="338" ind1=" " ind2=" "><subfield code="a">online resource</subfield><subfield code="b">cr</subfield><subfield code="2">rdacarrier</subfield></datafield><datafield tag="347" ind1=" " ind2=" "><subfield code="a">audio file</subfield><subfield code="2">rda</subfield></datafield><datafield tag="380" ind1=" " ind2=" "><subfield code="a">eAudiobook</subfield><subfield code="2">tlcgt</subfield></datafield><datafield tag="385" ind1=" " ind2=" "><subfield code="a">General</subfield><subfield code="2">tlctarget</subfield></datafield><datafield tag="500" ind1=" " ind2=" "><subfield code="a">Electronic audio file.</subfield></datafield><datafield tag="533" ind1=" " ind2=" "><subfield code="a">Electronic reproduction.</subfield><subfield code="b">New York</subfield><subfield code="c">Penguin Random House Audio Publishing Group</subfield><subfield code="d">2011</subfield><subfield code="n">Available via World Wide Web.</subfield></datafield><datafield tag="650" ind1=" " ind2="0"><subfield code="a">Regression (Civilization)</subfield><subfield code="v">Fiction.</subfield></datafield><datafield tag="650" ind1=" " ind2="0"><subfield code="a">Virtual reality</subfield><subfield code="v">Fiction.</subfield></datafield><datafield tag="650" ind1=" " ind2="0"><subfield code="a">Utopias</subfield><subfield code="v">Fiction.</subfield></datafield><datafield tag="650" ind1=" " ind2="0"><subfield code="a">Puzzles</subfield><subfield code="v">Fiction.</subfield></datafield><datafield tag="655" ind1=" " ind2="7"><subfield code="a">Fantasy fiction.</subfield><subfield code="2">gsafd</subfield></datafield><datafield tag="655" ind1=" " ind2="7"><subfield code="a">Electronic audio books.</subfield><subfield code="2">local</subfield></datafield><datafield tag="710" ind1="2" ind2=" "><subfield code="a">OverDrive, Inc.,</subfield><subfield code="e">distributor.</subfield></datafield></record>');
+(:bib_tag,'<record><leader>01619cam a2200409Ia 4500</leader><controlfield tag="001">9150274</controlfield><controlfield tag="005">20120530113527.0</controlfield><controlfield tag="007">sd fungnnmmned</controlfield><controlfield tag="008">110523s2011    mdu    e      000 1 eng d</controlfield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">9780307970060 :</subfield><subfield code="c">40.00</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">030797006X :</subfield><subfield code="c">40.00</subfield></datafield><datafield tag="028" ind1="0" ind2="2"><subfield code="a">RHA3179</subfield><subfield code="b">Books on Tape</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">3760223</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(OCoLC)726753599</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">3760223</subfield></datafield><datafield tag="037" ind1=" " ind2=" "><subfield code="b">Books on Tape</subfield><subfield code="n">http://library.booksontape.com</subfield></datafield><datafield tag="040" ind1=" " ind2=" "><subfield code="a">TEFBT</subfield><subfield code="c">TEFBT</subfield><subfield code="d">TEFBT</subfield></datafield><datafield tag="050" ind1="1" ind2="4"><subfield code="a">PS3603.L548</subfield><subfield code="b">R43 2011ab</subfield></datafield><datafield tag="082" ind1="0" ind2="4"><subfield code="a">813/.6</subfield><subfield code="2">23</subfield></datafield><datafield tag="092" ind1=" " ind2=" "><subfield code="a">BCD Cline</subfield></datafield><datafield tag="100" ind1="1" ind2=" "><subfield code="a">Cline, Ernest</subfield></datafield><datafield tag="245" ind1="1" ind2="0"><subfield code="a">Ready player one /</subfield><subfield code="c">Ernest Cline.</subfield><subfield code="h">[sound recording] </subfield></datafield><datafield tag="250" ind1=" " ind2=" "><subfield code="a">Unabridged sound recording</subfield></datafield><datafield tag="260" ind1=" " ind2=" "><subfield code="a">[Westminster, Md.] :</subfield><subfield code="b">Books on Tape,</subfield><subfield code="c">p2011.</subfield></datafield><datafield tag="300" ind1=" " ind2=" "><subfield code="a">13 sound discs ; 15 hours, 41 minutes :</subfield><subfield code="b">digital ;</subfield><subfield code="c">4 3/4 in.</subfield></datafield><datafield tag="500" ind1=" " ind2=" "><subfield code="a">Unabridged.</subfield></datafield><datafield tag="511" ind1="0" ind2=" "><subfield code="a">Read by Wil Wheaton.</subfield></datafield><datafield tag="520" ind1=" " ind2=" "><subfield code="a">At once wildly original and stuffed with irresistible nostalgia, READY PLAYER ONE is a spectacularly genre-busting, ambitious, and charming debut-- part quest novel, part love story, and part virtual space opera set in a universe where spell-slinging mages battle giant Japanese robots, entire planets are inspired by Blade Runner, and flying DeLoreans achieve light speed.</subfield></datafield><datafield tag="650" ind1=" " ind2="0"><subfield code="a">Regression (Civilization)</subfield><subfield code="v">Fiction.</subfield></datafield><datafield tag="650" ind1=" " ind2="0"><subfield code="a">Virtual reality</subfield><subfield code="v">Fiction.</subfield></datafield><datafield tag="650" ind1=" " ind2="0"><subfield code="a">Utopias</subfield><subfield code="v">Fiction.</subfield></datafield><datafield tag="650" ind1=" " ind2="0"><subfield code="a">Puzzles</subfield><subfield code="v">Fiction.</subfield></datafield><datafield tag="655" ind1=" " ind2="0"><subfield code="a">Audiobooks.</subfield></datafield><datafield tag="655" ind1=" " ind2="7"><subfield code="a">Fantasy fiction</subfield></datafield></record>');
+(:bib_tag,'<record><leader>00975pam a2200337 a 4500</leader><controlfield tag="001">8112628</controlfield><controlfield tag="005">20110823130500.0</controlfield><controlfield tag="008">110422s2011    nyu           000 1 eng  </controlfield><datafield tag="010" ind1=" " ind2=" "><subfield code="a">  2011015247</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">9780307887436 :</subfield><subfield code="c">$24.00</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">030788743X :</subfield><subfield code="c">$24.00</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(DLC)  2011015247</subfield></datafield><datafield tag="040" ind1=" " ind2=" "><subfield code="a">DLC</subfield><subfield code="c">DLC</subfield><subfield code="d">NjBwBT</subfield><subfield code="d">GCmBT</subfield></datafield><datafield tag="042" ind1=" " ind2=" "><subfield code="a">pcc</subfield></datafield><datafield tag="050" ind1="0" ind2="0"><subfield code="a">PS3603.L548</subfield><subfield code="b">R43 2011</subfield></datafield><datafield tag="082" ind1="0" ind2="0"><subfield code="a">813/.6</subfield><subfield code="2">22</subfield></datafield><datafield tag="100" ind1="1" ind2=" "><subfield code="a">Cline, Ernest.</subfield></datafield><datafield tag="245" ind1="1" ind2="0"><subfield code="a">Ready player one /</subfield><subfield code="c">Ernest Cline.</subfield></datafield><datafield tag="250" ind1=" " ind2=" "><subfield code="a">1st ed.</subfield></datafield><datafield tag="260" ind1=" " ind2=" "><subfield code="a">New York :</subfield><subfield code="b">Crown Publishers,</subfield><subfield code="c">c2011.</subfield></datafield><datafield tag="300" ind1=" " ind2=" "><subfield code="a">374 p. ;</subfield><subfield code="c">25 cm.</subfield></datafield><datafield tag="650" ind1=" " ind2="0"><subfield code="a">Regression (Civilization)</subfield><subfield code="v">Fiction.</subfield></datafield><datafield tag="650" ind1=" " ind2="0"><subfield code="a">Virtual reality</subfield><subfield code="v">Fiction.</subfield></datafield><datafield tag="650" ind1=" " ind2="0"><subfield code="a">Utopias</subfield><subfield code="v">Fiction.</subfield></datafield><datafield tag="650" ind1=" " ind2="0"><subfield code="a">Puzzles</subfield><subfield code="v">Fiction.</subfield></datafield><datafield tag="655" ind1=" " ind2="7"><subfield code="a">Fantasy fiction.</subfield><subfield code="2">gsafd</subfield></datafield><datafield tag="850" ind1=" " ind2=" "><subfield code="b">1</subfield></datafield></record>')
+;
index 50ea078..821a7b5 100644 (file)
@@ -1,4 +1,4 @@
-BEGIN;
+N;
 
 -- stop on error
 \set ON_ERROR_STOP on
@@ -30,6 +30,12 @@ BEGIN;
 -- load RDA bibs
 \i bibs_rda.sql
 
+-- load EbookAPI bibs
+\i bibs_ebook_api.sql
+
+-- load metarecord bibs
+\i bibs_mr.sql
+
 -- insert all loaded bibs into the biblio.record_entry in insert order
 INSERT INTO biblio.record_entry (marc, last_xact_id) 
     SELECT marc, tag FROM marcxml_import ORDER BY id;
@@ -49,6 +55,9 @@ INSERT INTO biblio.record_entry (marc, last_xact_id)
 -- load RDA copies, etc.
 \i assets_rda.sql
 
+-- load MR copies, etc.
+\i assets_mr.sql
+
 -- load copy-related data
 \i assets_extras.sql