API tools faq
paste
Advertisement
Guest User

mkrecordscopies.sql

a guest
Sep 29th, 2016
248
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PostgreSQL 10.79 KB | None | 0 0
raw download clone embed print report
  1. DO $$
  2. DECLARE
  3.     bib_id INTEGER;
  4.     acn_id INTEGER;
  5. BEGIN
  6.  
  7. INSERT INTO biblio.record_entry
  8. (marc, last_xact_id)
  9. VALUES(
  10. '<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>06887cgm a2200985Ia 4500</leader><controlfield tag="001">2307731</controlfield><controlfield tag="003">CWMARS</controlfield><controlfield tag="005">20060411152816.0</controlfield><controlfield tag="007">vd cvaizq</controlfield><controlfield tag="008">040506p20051984xxu119            vaeng d</controlfield><datafield tag="020" ind1=" " ind2=" "><subfield code="z">0788824002</subfield></datafield><datafield tag="024" ind1="1" ind2=" "><subfield code="a">786936175240</subfield></datafield><datafield tag="028" ind1="4" ind2="1"><subfield code="a">25344</subfield><subfield code="b">Walt Disney Home Entertainment</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(OCoLC)55090755 </subfield></datafield><datafield tag="040" ind1=" " ind2=" "><subfield code="a">TEFMT</subfield><subfield code="c">TEFMT</subfield><subfield code="d">RCS</subfield><subfield code="d">SXP</subfield><subfield code="d">WEL</subfield><subfield code="d">WCM</subfield><subfield code="d">UMC</subfield><subfield code="d">DRB</subfield><subfield code="d">OCL</subfield><subfield code="d">DRB</subfield><subfield code="d">VP@</subfield><subfield code="d">MBB</subfield><subfield code="d">M1F</subfield></datafield><datafield tag="041" ind1="1" ind2=" "><subfield code="a">jpn</subfield><subfield code="a">eng</subfield><subfield code="b">eng</subfield></datafield><datafield tag="049" ind1=" " ind2=" "><subfield code="a">M1FA</subfield></datafield><datafield tag="082" ind1="0" ind2="4"><subfield code="a">791.43/72</subfield><subfield code="2">22</subfield></datafield><datafield tag="090" ind1=" " ind2=" "><subfield code="a">PN1997.5</subfield><subfield code="b">.K39 2005</subfield></datafield><datafield tag="245" ind1="0" ind2="0"><subfield code="a">Kaze no tani no Naushika</subfield><subfield code="h">[videorecording] =</subfield><subfield code="b">Nausica&#xE4; of the Valley of the Wind /</subfield><subfield code="c">Tokuma Shoten and Hakuhodo present ; a Top Craft production ; Walt Disney home Entertainment presents ; a Studio Ghibli film ; original story and screenplay by Hayao Miyazaki ; producer Isao Takahata ; director, Hayao Miyazaki.</subfield></datafield><datafield tag="246" ind1="3" ind2="1"><subfield code="a">Nausica&#xE4; of the Valley of the Wind</subfield></datafield><datafield tag="260" ind1=" " ind2=" "><subfield code="a">[United States] :</subfield><subfield code="b">Walt Disney Home Entertainment ;</subfield><subfield code="a">Burbank, CA :</subfield><subfield code="b">Distributed by Buena Vista Home Entertainment,</subfield><subfield code="c">2005.</subfield></datafield><datafield tag="300" ind1=" " ind2=" "><subfield code="a">2 videodiscs (119 min.) :</subfield><subfield code="b">sd., col. ;</subfield><subfield code="c">4 3/4 in.</subfield></datafield><datafield tag="538" ind1=" " ind2=" "><subfield code="a">DVD, region 1; Dolby digital THX.</subfield></datafield><datafield tag="546" ind1=" " ind2=" "><subfield code="a">Dialogue in English with optional sound track in Japanese with optional English subtitles; closed-captioned.</subfield></datafield><datafield tag="511" ind1="0" ind2=" "><subfield code="a">English voices: Uma Thurman, Patrick Stewart, Alison Lohman, Edward James Olmos.</subfield></datafield><datafield tag="508" ind1=" " ind2=" "><subfield code="a">Music ; Joe Hisaishi ; producer ; Isao Takahata.</subfield></datafield><datafield tag="500" ind1=" " ind2=" "><subfield code="a">Based on the serial graphic novel.</subfield></datafield><datafield tag="500" ind1=" " ind2=" "><subfield code="a">Originally released as a motion picture in 1984.</subfield></datafield><datafield tag="520" ind1=" " ind2=" "><subfield code="a">Nausica&#xE4; is the princess of a rural valley that lives at peace on the edge of a deadly fungal wasteland, until a ship carrying a weapon from a bygone industrial age crashes nearby. When warriors from a far country come to retrieve the artifact, their invasion draws Nausica&#xE4; and her people into a sprawling political conflict. Set 1,000 years after a global war that nearly destroyed all life on Earth.</subfield></datafield><datafield tag="500" ind1=" " ind2=" "><subfield code="a">Special features: disc 1: Behind the microphone with voice talent from the film: Alison Lohman, Uma Thurman, Patrick Stewart and Edward James Olmos; original Japanese trailers; The birth of Studio Ghibli featurette (28 min.). disc 2: complete storyboards.</subfield></datafield><datafield tag="650" ind1=" " ind2="0"><subfield code="a">Animated films</subfield><subfield code="z">Japan.</subfield></datafield><datafield tag="650" ind1=" " ind2="0"><subfield code="a">Feature films.</subfield></datafield><datafield tag="650" ind1=" " ind2="0"><subfield code="a">Science fiction films.</subfield></datafield><datafield tag="650" ind1=" " ind2="0"><subfield code="a">Video recordings for the hearing impaired.</subfield></datafield><datafield tag="650" ind1=" " ind2="0"><subfield code="a">Princesses</subfield><subfield code="v">Drama.</subfield></datafield><datafield tag="650" ind1=" " ind2="0"><subfield code="a">Peace</subfield><subfield code="v">Drama.</subfield></datafield><datafield tag="655" ind1=" " ind2="0"><subfield code="a">Anime.</subfield></datafield><datafield tag="700" ind1="1" ind2=" "><subfield code="a">Miyazaki, Hayao,</subfield><subfield code="d">1941-</subfield></datafield><datafield tag="700" ind1="1" ind2=" "><subfield code="a">Takahata, Isao.</subfield></datafield><datafield tag="700" ind1="1" ind2=" "><subfield code="a">Thurman, Uma.</subfield></datafield><datafield tag="700" ind1="1" ind2=" "><subfield code="a">Stewart, Patrick,</subfield><subfield code="d">1940-</subfield></datafield><datafield tag="700" ind1="1" ind2=" "><subfield code="a">Lohman, Alison,</subfield><subfield code="d">1979-</subfield></datafield><datafield tag="700" ind1="1" ind2=" "><subfield code="a">Olmos, Edward James.</subfield></datafield><datafield tag="700" ind1="1" ind2=" "><subfield code="a">Hisaishi, Joe.</subfield><subfield code="4">cmp</subfield></datafield><datafield tag="710" ind1="2" ind2=" "><subfield code="a">Tokuma Shoten.</subfield></datafield><datafield tag="710" ind1="2" ind2=" "><subfield code="a">Hakuh&#x14D;d&#x14D;.</subfield></datafield><datafield tag="710" ind1="2" ind2=" "><subfield code="a">Sutajio Jiburi, Kabushiki Kaisha.</subfield></datafield><datafield tag="710" ind1="2" ind2=" "><subfield code="a">Walt Disney Home Entertainment (Firm)</subfield></datafield><datafield tag="710" ind1="2" ind2=" "><subfield code="a">Buena Vista Home Entertainment (Firm)</subfield></datafield><datafield tag="907" ind1=" " ind2=" "><subfield code="a">.b3273279x</subfield><subfield code="b">multi</subfield><subfield code="c">-</subfield></datafield><datafield tag="902" ind1=" " ind2=" "><subfield code="a">120511</subfield></datafield><datafield tag="998" ind1=" " ind2=" "><subfield code="b">35</subfield><subfield code="c">060412</subfield><subfield code="d">m</subfield><subfield code="e">v</subfield><subfield code="f">-</subfield><subfield code="g">0</subfield></datafield></record>',
  11. 'TEST-IMPORT') RETURNING id INTO bib_id;
  12.  
  13. INSERT INTO asset.call_number
  14. (creator, editor, record, owning_lib, label, label_class)
  15. VALUES (1, 1, bib_id, 4, 'Nausicaä of the Valley of the Wind', 1)
  16. RETURNING id INTO acn_id;
  17.  
  18. INSERT INTO asset.copy
  19. (circ_lib, creator, call_number, editor, loan_duration, fine_level, barcode,
  20.  active_date)
  21. VALUES ( 4, 1, acn_id, 1, 1, 1, 'A17015689393', now());
  22.  
  23. -- record #2
  24.  
  25. INSERT INTO biblio.record_entry
  26. (marc, last_xact_id)
  27. VALUES(
  28. '<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>00834cam a2200265Ia 4500</leader><controlfield tag="001">2426736</controlfield><controlfield tag="003">CWMARS</controlfield><controlfield tag="005">20070423100035.0</controlfield><controlfield tag="008">060828s1983    enk           000 0 eng d</controlfield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">0862321107 (pbk.)</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">9780862321109 (pbk.)</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(OCoLC)71196714 </subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(OCoLC)71196714</subfield></datafield><datafield tag="040" ind1=" " ind2=" "><subfield code="a">NJM</subfield><subfield code="c">NJM</subfield><subfield code="d">YDXCP</subfield><subfield code="d">OCLCQ</subfield><subfield code="d">CWJ</subfield></datafield><datafield tag="041" ind1="1" ind2=" "><subfield code="a">eng</subfield><subfield code="h">ara</subfield></datafield><datafield tag="049" ind1=" " ind2=" "><subfield code="a">CWJA</subfield></datafield><datafield tag="050" ind1="0" ind2="0"><subfield code="a">PJ7862.A3</subfield><subfield code="b">W6 1983</subfield></datafield><datafield tag="100" ind1="1" ind2=" "><subfield code="a">Sa&#x2BB;d&#x101;w&#x12B;, Naw&#x101;l.</subfield></datafield><datafield tag="245" ind1="1" ind2="0"><subfield code="a">Woman at point zero /</subfield><subfield code="c">Nawal El Saadawi ; translated by Sherif Hetata.</subfield></datafield><datafield tag="260" ind1=" " ind2=" "><subfield code="a">London ;</subfield><subfield code="a">New York :</subfield><subfield code="b">Zed Books,</subfield><subfield code="c">1983.</subfield></datafield><datafield tag="300" ind1=" " ind2=" "><subfield code="a">iv, 108 p. ;</subfield><subfield code="c">20 cm.</subfield></datafield><datafield tag="650" ind1=" " ind2="0"><subfield code="a">Arabs in literature.</subfield></datafield><datafield tag="907" ind1=" " ind2=" "><subfield code="a">.b34635981</subfield><subfield code="b">no00 </subfield><subfield code="c">-</subfield></datafield><datafield tag="902" ind1=" " ind2=" "><subfield code="a">120507</subfield></datafield><datafield tag="998" ind1=" " ind2=" "><subfield code="b">0</subfield><subfield code="c">990101</subfield><subfield code="d">m</subfield><subfield code="e">a</subfield><subfield code="f">-</subfield><subfield code="g">0</subfield></datafield></record>',
  29. 'TEST-IMPORT')
  30. RETURNING id INTO bib_id;
  31.  
  32. INSERT INTO asset.call_number
  33. (creator, editor, record, owning_lib, label, label_class)
  34. VALUES (1, 1, bib_id, 4, 'YF 1983 (Shelved under Saʻdāwī, Nawāl)', 1)
  35. RETURNING id INTO acn_id;
  36.  
  37. INSERT INTO asset.copy
  38. (circ_lib, creator, call_number, editor, loan_duration, fine_level, barcode,
  39.  active_date)
  40. VALUES ( 4, 1, acn_id, 1, 1, 1, 'A17015361842', now());
  41.  
  42. END
  43. $$;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!