Open-ILS/tests/datasets/sql/bibs_ebook_api.sql

   1 \set bib_tag '''IMPORT EBOOK_API'''
   2
   3 INSERT INTO marcxml_import (tag, marc) VALUES
   4 (:bib_tag,'<record    xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"    xsi:schemaLocation="http://www.loc.gov/MARC21/slim http://www.loc.gov/standards/marcxml/schema/MARC21slim.xsd"    xmlns="http://www.loc.gov/MARC21/slim"><leader>00620nam a22      i 4500</leader><controlfield tag="005">20161210000052.0</controlfield><controlfield tag="008">070101s                o           eng d</controlfield><datafield tag="040" ind1=" " ind2=" "><subfield code="a">SITKA</subfield><subfield code="b">eng</subfield><subfield code="e">rda</subfield><subfield code="c">SITKA</subfield></datafield><datafield tag="100" ind1="1" ind2=" "><subfield code="a">Tolkien, J. R. R.</subfield><subfield code="q">(John Ronald Reuel),</subfield><subfield code="d">1892-1973,</subfield><subfield code="e">author.</subfield></datafield><datafield tag="245" ind1="1" ind2=" "><subfield code="a">The fellowship of the ring /</subfield><subfield code="c">by J.R.R. Tolkien.</subfield></datafield><datafield tag="250" ind1=" " ind2=" "><subfield code="a">2nd ed.</subfield></datafield><datafield tag="336" ind1=" " ind2=" "><subfield code="a">text</subfield><subfield code="2">rdacontent</subfield></datafield><datafield tag="337" ind1=" " ind2=" "><subfield code="a">computer</subfield><subfield code="2">rdamedia</subfield></datafield><datafield tag="338" ind1=" " ind2=" "><subfield code="a">online resource</subfield><subfield code="2">rdacarrier</subfield></datafield><datafield tag="490" ind1="1" ind2=" "><subfield code="a">The Lord of the rings / J.R.R. Tolkien ;</subfield><subfield code="v">pt. 1</subfield></datafield><datafield tag="800" ind1="1" ind2=" "><subfield code="a">Tolkien, J. R. R.</subfield><subfield code="q">(John Ronald Reuel),</subfield><subfield code="d">1892-1973.</subfield><subfield code="t">Lord of the rings</subfield></datafield><datafield tag="856" ind1="4" ind2="0"><subfield code="u">http://example.com/ebookapi/t/001</subfield><subfield code="y">Click to access online</subfield><subfield code="9">CONS</subfield></datafield></record>'),
   5 (:bib_tag,'<record    xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"    xsi:schemaLocation="http://www.loc.gov/MARC21/slim http://www.loc.gov/standards/marcxml/schema/MARC21slim.xsd"    xmlns="http://www.loc.gov/MARC21/slim"><leader>00620nam a22      i 4500</leader><controlfield tag="005">20161210000052.0</controlfield><controlfield tag="008">070101s                o           eng d</controlfield><datafield tag="040" ind1=" " ind2=" "><subfield code="a">SITKA</subfield><subfield code="b">eng</subfield><subfield code="e">rda</subfield><subfield code="c">SITKA</subfield></datafield><datafield tag="100" ind1="1" ind2=" "><subfield code="a">Tolkien, J. R. R.</subfield><subfield code="q">(John Ronald Reuel),</subfield><subfield code="d">1892-1973,</subfield><subfield code="e">author.</subfield></datafield><datafield tag="245" ind1="1" ind2=" "><subfield code="a">The two towers /</subfield><subfield code="c">by J.R.R. Tolkien.</subfield></datafield><datafield tag="250" ind1=" " ind2=" "><subfield code="a">2nd ed.</subfield></datafield><datafield tag="336" ind1=" " ind2=" "><subfield code="a">text</subfield><subfield code="2">rdacontent</subfield></datafield><datafield tag="337" ind1=" " ind2=" "><subfield code="a">computer</subfield><subfield code="2">rdamedia</subfield></datafield><datafield tag="338" ind1=" " ind2=" "><subfield code="a">online resource</subfield><subfield code="2">rdacarrier</subfield></datafield><datafield tag="490" ind1="1" ind2=" "><subfield code="a">The Lord of the rings / J.R.R. Tolkien ;</subfield><subfield code="v">pt. 2</subfield></datafield><datafield tag="800" ind1="1" ind2=" "><subfield code="a">Tolkien, J. R. R.</subfield><subfield code="q">(John Ronald Reuel),</subfield><subfield code="d">1892-1973.</subfield><subfield code="t">Lord of the rings</subfield></datafield><datafield tag="856" ind1="4" ind2="0"><subfield code="u">http://example.com/ebookapi/t/002</subfield><subfield code="y">Click to access online</subfield><subfield code="9">CONS</subfield></datafield></record>'),
   6 (:bib_tag,'<record    xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"    xsi:schemaLocation="http://www.loc.gov/MARC21/slim http://www.loc.gov/standards/marcxml/schema/MARC21slim.xsd"    xmlns="http://www.loc.gov/MARC21/slim"><leader>00620nam a22      i 4500</leader><controlfield tag="005">20161210000052.0</controlfield><controlfield tag="008">070101s                o           eng d</controlfield><datafield tag="040" ind1=" " ind2=" "><subfield code="a">SITKA</subfield><subfield code="b">eng</subfield><subfield code="e">rda</subfield><subfield code="c">SITKA</subfield></datafield><datafield tag="100" ind1="1" ind2=" "><subfield code="a">Tolkien, J. R. R.</subfield><subfield code="q">(John Ronald Reuel),</subfield><subfield code="d">1892-1973,</subfield><subfield code="e">author.</subfield></datafield><datafield tag="245" ind1="1" ind2=" "><subfield code="a">The return of the king /</subfield><subfield code="c">by J.R.R. Tolkien.</subfield></datafield><datafield tag="250" ind1=" " ind2=" "><subfield code="a">2nd ed.</subfield></datafield><datafield tag="336" ind1=" " ind2=" "><subfield code="a">text</subfield><subfield code="2">rdacontent</subfield></datafield><datafield tag="337" ind1=" " ind2=" "><subfield code="a">computer</subfield><subfield code="2">rdamedia</subfield></datafield><datafield tag="338" ind1=" " ind2=" "><subfield code="a">online resource</subfield><subfield code="2">rdacarrier</subfield></datafield><datafield tag="490" ind1="1" ind2=" "><subfield code="a">The Lord of the rings / J.R.R. Tolkien ;</subfield><subfield code="v">pt. 3</subfield></datafield><datafield tag="800" ind1="1" ind2=" "><subfield code="a">Tolkien, J. R. R.</subfield><subfield code="q">(John Ronald Reuel),</subfield><subfield code="d">1892-1973.</subfield><subfield code="t">Lord of the rings</subfield></datafield><datafield tag="856" ind1="4" ind2="0"><subfield code="u">http://example.com/ebookapi/t/003</subfield><subfield code="y">Click to access online</subfield><subfield code="9">CONS</subfield></datafield></record>'),
   7 (:bib_tag,'<record    xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"    xsi:schemaLocation="http://www.loc.gov/MARC21/slim http://www.loc.gov/standards/marcxml/schema/MARC21slim.xsd"    xmlns="http://www.loc.gov/MARC21/slim"><leader>00620nam a22      i 4500</leader><controlfield tag="005">20161210000052.0</controlfield><controlfield tag="008">070101s                o           eng d</controlfield><datafield tag="040" ind1=" " ind2=" "><subfield code="a">SITKA</subfield><subfield code="b">eng</subfield><subfield code="e">rda</subfield><subfield code="c">SITKA</subfield></datafield><datafield tag="100" ind1="1" ind2=" "><subfield code="a">Tolkien, J. R. R.</subfield><subfield code="q">(John Ronald Reuel),</subfield><subfield code="d">1892-1973,</subfield><subfield code="e">author.</subfield></datafield><datafield tag="245" ind1="1" ind2=" "><subfield code="a">The hobbit, or, There and back again /</subfield><subfield code="c">by J.R.R. Tolkien.</subfield></datafield><datafield tag="250" ind1=" " ind2=" "><subfield code="a">New ed.</subfield></datafield><datafield tag="336" ind1=" " ind2=" "><subfield code="a">text</subfield><subfield code="2">rdacontent</subfield></datafield><datafield tag="337" ind1=" " ind2=" "><subfield code="a">computer</subfield><subfield code="2">rdamedia</subfield></datafield><datafield tag="338" ind1=" " ind2=" "><subfield code="a">online resource</subfield><subfield code="2">rdacarrier</subfield></datafield><datafield tag="856" ind1="4" ind2="0"><subfield code="u">http://example.com/ebookapi/t/004</subfield><subfield code="y">Click to access online</subfield><subfield code="9">CONS</subfield></datafield></record>')
   8 ;