From 60e637ea18f90a309b09e0014921f05d85931fe7 Mon Sep 17 00:00:00 2001 From: Dan Scott Date: Sat, 5 Jan 2013 20:49:27 -0500 Subject: [PATCH] Add test records for graphic 880 field display MIME-Version: 1.0 Content-Type: text/plain; charset=utf8 Content-Transfer-Encoding: 8bit "--load-all" in eg_db_config.pl will load these records with call numbers of "G880 ", so you can shelf-browse, or search by title: * Tu shuo Zhongguo jie * Matsumoto Shigeharu * Schrödinger operators * Breathing, feeding, and neuroprotection * Data warehousing and knowledge discovery Signed-off-by: Dan Scott Signed-off-by: Kathy Lussier Signed-off-by: Ben Shum --- .../tests/datasets/sql/assets_graphic_880.sql | 19 +++++++++++++++++++ .../tests/datasets/sql/bibs_graphic_880.sql | 9 +++++++++ Open-ILS/tests/datasets/sql/load_all.sql | 6 ++++++ 3 files changed, 34 insertions(+) create mode 100644 Open-ILS/tests/datasets/sql/assets_graphic_880.sql create mode 100644 Open-ILS/tests/datasets/sql/bibs_graphic_880.sql diff --git a/Open-ILS/tests/datasets/sql/assets_graphic_880.sql b/Open-ILS/tests/datasets/sql/assets_graphic_880.sql new file mode 100644 index 0000000000..d97cb66910 --- /dev/null +++ b/Open-ILS/tests/datasets/sql/assets_graphic_880.sql @@ -0,0 +1,19 @@ +-- Create call numbers +SELECT evergreen.populate_call_number(4, 'G880 ', 'IMPORT G880', NULL); -- BR1 +SELECT evergreen.populate_call_number(5, 'G880 ', 'IMPORT G880', NULL); -- BR2 +SELECT evergreen.populate_call_number(6, 'G880 ', 'IMPORT G880', NULL); -- BR3 +SELECT evergreen.populate_call_number(7, 'G880 ', 'IMPORT G880', NULL); -- BR4 +SELECT evergreen.populate_call_number(9, 'G880 ', 'IMPORT G880', NULL); -- BM1 + +-- Create copies +SELECT evergreen.populate_copy(4, 4, 'G88040000', 'G880'); -- BR1 +SELECT evergreen.populate_copy(5, 5, 'G88050000', 'G880'); -- BR2 +SELECT evergreen.populate_copy(6, 6, 'G88060000', 'G880'); -- BR3 +SELECT evergreen.populate_copy(7, 7, 'G88070000', 'G880'); -- BR4 +SELECT evergreen.populate_copy(9, 9, 'G88090000', 'G880'); -- BM1 + +SELECT evergreen.populate_copy(4, 4, 'G88041000', 'G880'); -- BR1 +SELECT evergreen.populate_copy(5, 5, 'G88051000', 'G880'); -- BR2 +SELECT evergreen.populate_copy(6, 6, 'G88061000', 'G880'); -- BR3 +SELECT evergreen.populate_copy(7, 7, 'G88071000', 'G880'); -- BR4 +SELECT evergreen.populate_copy(9, 9, 'G88091000', 'G880'); -- BM1 diff --git a/Open-ILS/tests/datasets/sql/bibs_graphic_880.sql b/Open-ILS/tests/datasets/sql/bibs_graphic_880.sql new file mode 100644 index 0000000000..5bf269c73e --- /dev/null +++ b/Open-ILS/tests/datasets/sql/bibs_graphic_880.sql @@ -0,0 +1,9 @@ +\set bib_tag '''IMPORT G880''' + +INSERT INTO marcxml_import (tag, marc) VALUES +(:bib_tag, '01702nam a2200445Ia 45002741359NOBLE20090921105246.0090424s2009 cc a 000 0 chi d97875004738177500473818(OCoLC)319126686HUAHUANOGa-cc---NOGAGT4883.A2D326 2009$1880-01Da, Qiao.880-02Tu shuo Zhongguo jie =Tushuo Zhongguojie /Da Qiao bian zhu.880-03Zhongguo jie.Tushuo Zhongguojie.880-04Di 1 ban.880-05Beijing :Zhongguo she hui ke xue chu ban she,2009.4, 231 p. :ill. (some col.) ;24 cm.FestivalsChina.Chinese language materials.ChinaSocial life and customs.HolidaysChina.TalesChina.100-01/$1大乔.245-02/$1图说中国节 =Tushuo Zhongguojie /大乔编著.246-03/$1中国节.250-04/$1第1版.260-05/$1北京 :中国社会科学出版社,2009.120426109092101-0C0NOGnobbc 09-21-2009b27413597III2741359biblio'), +(:bib_tag, '01750 am a2200481Ia 45002784593CONIFER20121031173514.0121026s2012 ja ac 001 0beng d97849249713324924971332engjpnDS890.M442K3513 2012 880-01Kaimai, Jun,1957-Matsumoto Shigeharu :bearing witness /Kaimai Jun ; English adaptation by Waku Miller.Bearing witness1st English ed.Tokyo :International House of Japan,2012.xviii, 219 p., [1] leaf of plates :ill., portraits ;24 cm.LTCB international library selection ; no. 31Translation of: Matsumoto Shigeharu den : saigo no riberarisuto.Includes index.880-03Matsumoto, Shigeharu,1899-1989.880-04Dōmei Tsūshinsha.LiberalsJapanBiography.JournalistsJapanBiography.Miller, Waku.LTCB international library selection ;no. 31.100-01開米潤,1957-240-02松本重治伝.English600-03松本重治,1899-1989.610-04同盟通信社.5894462OCoLC2784593biblio'), +(:bib_tag, '01964cam a2200397Ia 45002802833CONIFER20110408114902.0m d cr unu||||||||090106s1979 gw ob 001 0 eng d9780387095141 (New York)0387095144 (New York)9783540095149 (Berlin)3540095144 (Berlin)(OCoLC)ocn297188498SPLNMSPLNMGW5XECaOWAQA3.L28 no. 727QA377$1880-01Saitō, Yoshimi.Spectral representations for Schrödinger operators with long-range potentials[electronic resource] /Yoshimi Saitō.Berlin ;New York :Springer-Verlag,1979.148 p. ;25 cm.Lecture notes in mathematics,0075-8434 ;727Includes bibliographical references (p. [141]-144) and index.Access restricted to users with a valid University of Windsor ID ; Ontario Council of University Libraries ; Springer Science+Business Media, LLC.OWADifferential equations, Elliptic.SpringerSP(before 2005)_2012_11_3349.mrc.2012_11_5Schrödinger operator.Scattering (Mathematics)Spectral theory (Mathematics)Print version:Saitō, Yoshimi.Spectral representations for Schrödinger operators with long-range potentials.Berlin ; New York : Springer-Verlag, 19790387095144(DLC) 79015958(OCoLC)5101219Lecture notes in mathematics (Springer-Verlag) ;727.http://ezproxy.uwindsor.ca/login?url=http://books.scholarsportal.info/viewdoc.html?id=/ebooks/ebooks2/springer/2011-04-14/2/3540095144Available OnlineWINDSYShttp://ezproxy.uwindsor.ca/login?url=http://dx.doi.org/10.1007/BFb0070997Available OnlineWINDSYS100-01/$1齋藤, 義實297188498OCoLC2802833biblio'), +(:bib_tag, '02921nam a2200625Ia 4500892053CONIFER20081125080111.0m d cr cn| 081017s2006 ja a sb 001 0 eng d97844312877594431287752(OCoLC)ocn262693560(OCoLC)262693560978-4-431-28774-2Springerhttp://www.springerlink.comGW5XEengGW5XEMAINQP123.B68 2006eb2006 G-560WF 102I608b 2006$1QPlcco612.222880-01Breathing, feeding, and neuroprotection[electronic resource] /I . Homma, S. Shioda, eds.880-02Tokyo ;New York :Springer,c2006.xvi, 148 p. :ill. ;24 cm.Includes bibliographical references and index.Central regulation of breathing -- Neurogeneration and neuroprotection -- Brain functions in health and disease -- Brain functions by the Dipole Tracing method.Electronic reproduction.New York :Springer,2008.Mode of access: World Wide Web.System requirements: Web browser.Title from title screen (viewed on Oct. 10, 2008).Access may be restricted to users at subscribing institutions.RespirationRegulation.Blood-brain barrier.Neurophysiology.Respiratory MechanicsphysiologyCongresses.Respiratory TransportphysiologyCongresses.Biological ClocksCongresses.Blood-Brain BarrierinnervationCongresses.Brain StemphysiologyCongresses.Nerve RegenerationphysiologyCongresses.880-03Nō.jlabsh/3Electronic books.local880-04Homma, Ikuo.880-00Shioda, S.(Seiji)SpringerLink (Online service)Original44312877449784431287742(DLC) 2006923431(OCoLC)69982830Available online from SpringerLinkhttp://librweb.laurentian.ca/login?url=http://dx.doi.org/10.1007/4-431-28775-2LUSYSAvailable online from ScholarsPortalhttp://librweb.laurentian.ca/login?url=http://resolver.scholarsportal.info/isbn/9784431287759LUSYS245-01/$1Breathing，Feeding，and，Neuroprotection／[electronic resource]I。Homma；S。Shioda［編］。260-02/$1［東京］：［シュプリンガー・フェアラーク東京］，c2006。650-03/$1脳jlabsh/3700-00/$1本間生夫700-04/$1塩田清二92ONTCL1a892053Sirsi_Auto892053biblio'), +(:bib_tag, '02737nam a2200589Ia 4500925636CONIFER20081125083147.0m d cr cn| 081017s2002 gw a sb 100 0 eng d 9783540461456 3540461450(OCoLC)ocn262687400(OCoLC)262687400978-3-540-44123-6Springerhttp://www.springerlink.comGW5XEengGW5XEMAINQA76.9.D37D396 2002eb$1Qlcco658.4/038/028557422DaWaK 2002(2002 :Aix-en-Provence, France)Data warehousing and knowledge discovery[electronic resource] :4th international conference, DaWaK 2002, Aix-en-Provence, France, September 4-6, 2002 : proceedings /Yahiko Kambayashi, Werner Winiwarter, Masatoshi Arikawa (eds.).Berlin ;New York :Springer,2002.xiii, 337 p. :ill. ;24 cm.Lecture notes in computer science ;2114Includes bibliographical references.Electronic reproduction.New York :Springer,2008.Mode of access: World Wide Web.System requirements: Web browser.Title from title screen (viewed on Oct. 10, 2008).Access may be restricted to users at subscribing institutions.Data warehousingCongresses.Database searchingCongresses.BANCO DE DADOS (CONGRESSOS)larpcalREDES E COMUNICAÇÃO DE DADOS (CONGRESSOS)larpcalRECUPERAÇÃO DA INFORMAÇÃO (CONGRESSOS)larpcalData-analyse.gttKennismanagement.gttData warehouse.gttBases de donnéesInterrogationCongrès.Entrepôts de données (Informatique)Congrès.Electronic books.localKambayashi, Y.Winiwarter, Werner.880-01Arikawa, Masatoshi.SpringerLink (Online service)Original35404412399783540441236(DLC) 2002030275(OCoLC)50291185Available online from SpringerLinkhttp://librweb.laurentian.ca/login?url=http://dx.doi.org/10.1007/3-540-46145-0LUSYShttp://link.springer-ny.com/link/service/series/0558/tocs/t2454.htmRestricted to Springer LINK subscribersAvailable online from Scholars Portalhttp://librweb.laurentian.ca/login?url=http://resolver.scholarsportal.info/isbn/9783540461456LUSYS700-01/$1有川, 正俊92ONTCL1a925636Sirsi_Auto925636biblio') +; diff --git a/Open-ILS/tests/datasets/sql/load_all.sql b/Open-ILS/tests/datasets/sql/load_all.sql index 43bbd443c7..25bddb4250 100644 --- a/Open-ILS/tests/datasets/sql/load_all.sql +++ b/Open-ILS/tests/datasets/sql/load_all.sql @@ -15,6 +15,9 @@ BEGIN; -- load map bibs \i bibs_maps.sql +-- load graphic 880 field bibs +\i bibs_graphic_880.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; @@ -25,6 +28,9 @@ INSERT INTO biblio.record_entry (marc, last_xact_id) -- load french copies, etc. \i assets_fre.sql +-- load graphic 880 field copies, etc +\i assets_graphic_880.sql + -- load sample patrons \i users_patrons_100.sql -- 2.43.2