From ff85f2e9c354de2a296442e115d44a4dc718453d Mon Sep 17 00:00:00 2001 From: Dan Scott Date: Tue, 15 Apr 2014 13:55:15 -0400 Subject: [PATCH] LP# 1308768 Make RDA bibs loadable for testing purposes Squash the RDA records into XML loading format via the magic of 'yaz-marcdump -i marc -o marcxml' and some judicious regular expressions. Signed-off-by: Dan Scott Signed-off-by: Ben Shum --- Open-ILS/tests/datasets/sql/assets_rda.sql | 28 ++++++++++++++++++++++ Open-ILS/tests/datasets/sql/bibs_rda.sql | 14 +++++++++++ Open-ILS/tests/datasets/sql/load_all.sql | 6 +++++ 3 files changed, 48 insertions(+) create mode 100644 Open-ILS/tests/datasets/sql/assets_rda.sql create mode 100644 Open-ILS/tests/datasets/sql/bibs_rda.sql diff --git a/Open-ILS/tests/datasets/sql/assets_rda.sql b/Open-ILS/tests/datasets/sql/assets_rda.sql new file mode 100644 index 0000000000..fbd2b53ad7 --- /dev/null +++ b/Open-ILS/tests/datasets/sql/assets_rda.sql @@ -0,0 +1,28 @@ +-- Create call numbers +SELECT evergreen.populate_call_number(4, 'RDA ', 'IMPORT RDA', NULL); -- BR1 +SELECT evergreen.populate_call_number(5, 'RDA ', 'IMPORT RDA', NULL); -- BR2 +SELECT evergreen.populate_call_number(6, 'RDA ', 'IMPORT RDA', NULL); -- BR3 +SELECT evergreen.populate_call_number(7, 'RDA ', 'IMPORT RDA', NULL); -- BR4 +SELECT evergreen.populate_call_number(9, 'RDA ', 'IMPORT RDA', NULL); -- BM1 + +-- Create copies +SELECT evergreen.populate_copy(4, 4, 'RDA40000', 'RDA'); -- BR1 +SELECT evergreen.populate_copy(5, 5, 'RDA50000', 'RDA'); -- BR2 +SELECT evergreen.populate_copy(6, 6, 'RDA60000', 'RDA'); -- BR3 +SELECT evergreen.populate_copy(7, 7, 'RDA70000', 'RDA'); -- BR4 +SELECT evergreen.populate_copy(9, 9, 'RDA90000', 'RDA'); -- BM1 + +SELECT evergreen.populate_copy(4, 4, 'RDA41000', 'RDA'); -- BR1 +SELECT evergreen.populate_copy(4, 4, 'RDA42000', 'RDA'); -- BR1 +SELECT evergreen.populate_copy(4, 4, 'RDA43000', 'RDA'); -- BR1 +SELECT evergreen.populate_copy(4, 4, 'RDA44000', 'RDA'); -- BR1 +SELECT evergreen.populate_copy(4, 4, 'RDA45000', 'RDA'); -- BR1 +SELECT evergreen.populate_copy(4, 4, 'RDA46000', 'RDA'); -- BR1 +SELECT evergreen.populate_copy(4, 4, 'RDA47000', 'RDA'); -- BR1 +SELECT evergreen.populate_copy(4, 4, 'RDA48000', 'RDA'); -- BR1 +SELECT evergreen.populate_copy(4, 4, 'RDA49000', 'RDA'); -- BR1 + +SELECT evergreen.populate_copy(5, 5, 'RDA51000', 'RDA'); -- BR2 +SELECT evergreen.populate_copy(6, 6, 'RDA61000', 'RDA'); -- BR3 +SELECT evergreen.populate_copy(7, 7, 'RDA71000', 'RDA'); -- BR4 +SELECT evergreen.populate_copy(9, 9, 'RDA91000', 'RDA'); -- BM1 diff --git a/Open-ILS/tests/datasets/sql/bibs_rda.sql b/Open-ILS/tests/datasets/sql/bibs_rda.sql new file mode 100644 index 0000000000..6c638cc5e7 --- /dev/null +++ b/Open-ILS/tests/datasets/sql/bibs_rda.sql @@ -0,0 +1,14 @@ +\set bib_tag '''IMPORT RDA''' + +INSERT INTO marcxml_import (tag, marc) VALUES +(:bib_tag, '01534cjm a22003977i 45001789689820140205190136.0sd fsngnnmnned130924p20122012bl ppnn n por 7cbcorignew3ncip20y-soundrecacquire1 shelf copypolicy defaultwr07 2013-09-24 to MBRSqr30 2014-01-31qr30 2014-01-31 201333528350999949467279494672EMIDLCengDLCrdaDLClcodes-bl---SDC 31600Cláudia,1948-Cláudia.[Rio de Janeiro, Brazil] :EMI,[2012]℗20121 audio disc :CD audio ;4 3/4 in.performed musicrdacontentaudiordamediaaudio discrdacarrierSuper divasSung in Portuguese."AA1000"--Container.Lyrics inserted in container.Compact disc.Deixa eu dizer --Eu não sou causa, sou consequência --Soy latino-americano --Desacato --Garra --Peter Gunn --Apenas um rapaz latino-americano --Eu robot --Espanta o grilo --Com mais de trinta --Memória livre de Leila --O circo --O cavaleiro e os moinhos --Gamboa --Só que deram zero pro Bedeu --Minha voz virá do sol da América.Production level cataloging.Popular musicBrazil1971-1980.ODE-rj '), +(:bib_tag, '04927cgm a2200781 i 45001655778120120112135234.0vd msaiz|co mga||||||||101130t20082009cau229 | mleng 7cbcorignewuncip20y-movingimqm02 2010-11-30 2010600022143592125904339626417526417Sony Pictures Home EntertainmentDLCengDLCrdaDLCengfrespaporthaengengfrespaporchikorthaindn-us---DVC 4301 (viewing copy)Pineapple express /Columbia Pictures presents, in association with Relativity Media, an Apatow Company production ; produced by Judd Apatow, Shauna Robertson ; screenplay by Seth Rogen & Evan Goldberg ; directed by David Gordon Green.Unrated special edition.United States.Culver City, California :Sony Pictures Home Entertainment,2008, ©2009.viewing copy.1 videodisc (theatrical version approximately 112 min., extended version approximately 117 min.) :sound, color with introductory black and white sequence ;4 3/4 in. +1 computer disc (4 3/4 in.)two-dimensional moving imagerdacontentvideocomputerrdamediavideodisccomputer discrdacarrierBlu-ray disc; regions A, B, C.DVD-ROM drive required; compatible with PC, PSP, Mac, or iPod; Internet connection required.Video specifications: 1080p high definition, wide screen (2.40:1); some special features in standard definition.Audio specifications: Dolby TrueHD 5.1 (English, French), 5.1 Dolby Digital (Spanish, Portuguese, Thai).Executive producers, Seth Rogen, Evan Goldberg ; story by Judd Apatow and Seth Rogen & Evan Goldberg ; director of photography, Tim Orr ; music by Graeme Revell ; edited by Craig Alpert ; production designer, Chris Spellman.Seth Rogen, James Franco, Gary Cole, Rosie Perez, Danny McBride.Feature film: English; optional French, Spanish, Portuguese, Thai language tracks; optional English, French, Spanish, Portuguese, Chinese, Korean, Thai, Indonesian subtitles.Special features: English; optional Spanish, Portuguese, Chinese, Korean, Thai subtitles."A lazy stoner (Seth Rogen) is the sole witness to a murder by an evil drug lord (Gary Cole) and a corrupt cop (Rosie Perez). Marked for death, he runs for his life, dragging his dazed dealer (James Franco) and his supplier (Danny McBride) with him on a hilarious pot-fueled adventure"--Container.MPAA rating: R (theatrical version); extended version, special features are unrated.Special features: Includes Both theatrical and extended versions of the film; Commentary with Filmmakers and Cast; Deleted Scenes; Extended & Alternate Scenes; The Making of Pineapple Express; The Action of Pineapple Express; Phone Booth; Line-O-Rama; Direct-O-Rama; Gag Reel; Item 9; Saul's Apartment; Raw Footage; Begley's Best; Red and Jessica's Guide to Marriage; Injury Report; Stuntmaster Ken; Rehearsal Footage; First Table Read; Comic-Con Panel; BD-Live.LC copy is incomplete; computer disc is missing.DLCPartially viewed.Sources used: Internet movie database WWW site, viewed November 30, 2010; Sony Pictures WWW site, viewed November 30, 2010.SlackersUnited StatesDrama.Drug dealersUnited StatesDrama.MarijuanaUnited StatesDrama.Drug trafficUnited StatesDrama.Police corruptionUnited StatesDrama.Feature films.lcgftFiction films.lcgftCrime films.lcgftComedy films.lcgftAction and adventure films.lcgftApatow, Judd,1967-film producer.Robertson, Shauna,film producer.Rogen, Seth,1982-screenwriter,film producer,actor.Goldberg, Evan,screenwriterfilm producer.Green, David Gordon,1975-film director.Franco, James,1978-actor.Cole, Gary,1956-actor.Perez, Rosie,actor.McBride, Danny,1976-actor.Columbia Pictures,production company.Relativity Media,production company.Apatow Company,production company.Sony Pictures Home Entertainment (Firm),video distributor.Anonymous Donor Collection (Library of Congress)DLCPineapple express (Motion picture)Pineapple express (Motion picture)Extended version of '), +(:bib_tag, '02185cgm a22004695i 45001811280220140415111154.0vd mvaizk140411m20132012bl 093 g vlpor 0ibcorigres2ncip20y-movingimacquire1 shelf copypolicy defaultwr07 2014-04-11 z-processorwr07 2014-04-15 to MBRS-MI 20143400807892141647564049CBRDLCengDLCrdaporgerengfrespalcodes-bl---Jorge Mautner :o filho do Holocausto /Globo Filmes, Canal Brasil, Pedro Bial e UNIP apresentam ; produção, Carlos Wanderley ; um filme de Pedro Bial e Heitor Alincourt.Filho do HolocaustoBrazil.[Rio de Janeiro, Brazil] :[publisher not identified],℗2012.©2013viewing copy1 videodisc (93 min.) :sound, color ;4 3/4 in.two-dimensional moving imagetdirdacontentvideovrdamediavideodiscvdrdacarrierColeção Canal BrasilThe Brazilian singer, violinist and writer Jorge Mautner, the son of holocaust survivors, is a something of a sensation in Brazil, having collaborated with Caetano Veloso and Gilberto Gil. This film documents his life from birth to age 17. His nanny introduced him to Candomblé; Mautner then became a precursor of the Tropicália, contributing to the construction of a Brazilian musical identity.DVD; 16x9 format; 5.1 surround and 2.0 stereo.In Portuguese and some German, with optional English, French and Spanish subtitles.Not viewed.Mautner, Jorge,1941-Documentary films.lcgftWanderley, Carlos,film producer.Bial, Pedro,1958?-film director.D'Alincourt, Heitor,film director.Mautner, Jorge Henrique,actor.Globo Filmes (Firm)film distributor.Canal Brasil (Firm)film distributor.ODE-rj '), +(:bib_tag, '01228cem a2200349 i 45001763107520130220112822.0aj canzn130220s2012 nmu a 1 eng 7cbcorigcopuncip20y-geogmapsga09 2013-02-20 sent to CMT 2013585177aDLCengDLCrdaG4324.T2 2012.T34324T2Taos news.2012 Enchanted Circle :tourist map : Taos Ski Valley, Taos Canyon, Eagle Nest, Angel Fire, Cimarron, Red River, Costilla, Questa, Raton /Taos news.Title within map border:Taos, New MexicoScale not given.[Taos] :Taos news,2012.1 map :both sides, color ;on sheet 57 x 89 cm, folded to 23 x 14 cmcartographic imagerdacontentunmediatedrdamediasheetrdacarrierPictorial map.Shows Taos region of New Mexico.Title from panel.Printed in 11 segments.Includes location map and color illustrations.Taos Region (N.M.)Maps.Pictorial maps.lcgft '), +(:bib_tag, '01295ckmaa2200349 i 45001759166720140331133353.0130115s19uu cc nnn an 7cbcorignew1ncip20y-gencatlgacquire1 shelf copypolicy defaultcg09 2013-01-15cg04 2013-04-10 to Asian Div. 2011432135DLCengDLCrdaDLCpcca-cc-tiBF1714.B7S75 1900zSrid pa ho.[Tibet] :[producer not identified],[not before 1900]1 sheet ;79 x 55 cmstill imagerdacontentunmediatedrdamediavolumerdacarrierAlso available in digital form on the Library of Congress Web site.20th century Tibetan Buddhist astrological thangka on cloth depicting auspicious symbols, including 12 animals of the 60 year calendar cycle."Tibetan Collection/Thangka no. 4" on cover of box.Inscription in Tibetan.Buddhist astrology.Buddhist astrologyPictorial works.http://hdl.loc.gov/loc.wdl/wdl.3167wdlpmpulldigital files not viewed; td12 2013-7-16 '), +(:bib_tag, '07649ccm a2200913 i 45001802102220140128084328.0140128s2013 nyuopk| defhi n | ita d 201356518697814803285321480328537884088883249HL50498721Hal Leonard(bk.)HL50490487Hal Leonard(cd.)HL50486260Hal Leonard(cd.)63011108Hal Leonard(diction coach 1)63011109Hal Leonard(diction coach 2)63014792Hal Leonard(CD 1)63014793Hal Leonard(CD 2)(OCoLC)ocn826076986(OCoLC)826076986YDXCPengrdaYDXCPCLENUIMYGDLCitagerfreengitagerfreengenglccopycatvf01ka01M1507.A+Arias for bass :complete package : with diction coach and accompaniment CDs /compiled and edited by Robert L. Larsen.New York, NY :G. Schirmer, Inc.,2013.Milwaukee, WI :Distributed by Hal Leonard Corporation1 score (263 pages) ;31 cm +4 sound discs (digital ; 4 3/4 in.)notated musicntmrdacontentperformed musicprmrdacontentunmediatednrdamediaaudiosrdamediavolumencrdacarrieraudio discsdrdacarrierG. Schirmer opera anthologystaff notationItalian, French, German, and English words; non-English texts also printed with English translations.Opera arias; acc. arr. for piano.William Billingham, pianist on CDs.disc 1-2 diction coach -- disc 3-4 accompaniment CDs.Il barbiere di Siviglia. La calunnia / Gioachino Rossini -- La Bohè̀me. Vecchia zimarra, senti / Giacomo Puccini -- La Cenerentola. Miei rampolli femminini / Gioachino Rossini -- Don Giovanni. Madamina! Il catalogo è questo / Wolfgang Amadeus Mozart -- Don Pasquale. Ah! Un foco insolito / Gaetano Donizetti -- Die Entführung aus dem Serail. O, wie will ich triumphiren / Wolfgang Amadeus Mozart -- Ernani. Infelice! E tuo credevi / Giuseppe Verdi -- Eugene Onegin. Gremin's aria / Pyotr Il'yich Tchaikovsky -- Faust. Le veau d'or ; Vous qui faites l'endormie / Charles Gounod -- Der Freischütz. Schweig'! Schweig'! Damit dich niemand warnt / Carl Maria von Weber -- Les huguenots. Pour le couvents c'est fini (Piff, paff) / Giacomo Meyerbeer -- La jolie fille de Perth. Quand la flamme de l'amour / Georges Bizet -- Lucia di Lammermoor. Dalle stanze ove Lucia / Gaetano Donizetti -- Die lustigen Weiber von Windsor. Als Büblein klein / Otto Nicolai -- Macbeth. Come dal ciel precipita / Giuseppe Verdi -- Manon. Épouse quelque brave fille / Jules Massenet -- The mother of us all. What what is it / Virgil Thomson -- Le nozze di Figaro. La vendetta ; Se vuol ballare ; Non più andrai ; Aprite un po' quegl'occhi / Wolfgang Amadeus Mozart -- Simon Boccanegra. Il lacerato spirito / Giuseppe Verdi -- La sonnambula. Vi ravviso / Vincenzo Bellini -- Street scene. Let things be like they always was / Kurt Weill -- I vespri siciliani. O tu, Palermo / Giuseppe Verdi -- Die Zauberflöte. O Isis und Osiris ; In diesen heil'gen Hallen / Wolfgang Amadeus Mozart.OperasExcerptsVocal scores with piano.Recorded accompaniments (Low voice)Larsen, Robert L.,1934-editor,compiler.Billingham, William,performer.Contains (expression):Rossini, Gioacchino,1792-1868.Barbiere di Siviglia.Calunnia è un venticello.Vocal score.Contains (expression):Puccini, Giacomo,1858-1924.Bohème.Vecchia zimarra.Vocal score.Contains (expression):Rossini, Gioacchino,1792-1868.Cenerentola.Miei rampolli femminini.Vocal score.Contains (expression):Mozart, Wolfgang Amadeus,1756-1791.Don Giovanni.Madamina, il catalogo è questo.Vocal score.Contains (expression):Donizetti, Gaetano,1797-1848.Don Pasquale.Foco insolito.Vocal score.Contains (expression):Mozart, Wolfgang Amadeus,1756-1791.Entführung aus dem Serail.Ha! wie will ich triumphieren.Vocal score.Contains (expression):Verdi, Giuseppe,1813-1901.Ernani.Infelice! e tu credevi.Vocal score.Contains (expression):Tchaikovsky, Peter Ilich,1840-1893.Evgeniĭ Onegin.Arii︠a︡ kni︠a︡zi︠a︡.Vocal score.Contains (expression):Gounod, Charles,1818-1893.Faust.Veau d'or est toujours debout.Vocal score.Contains (expression):Gounod, Charles,1818-1893.Faust.Vous qui faites l'endormie.Vocal score.Contains (expression):Weber, Carl Maria von,1786-1826.Freischütz.Schweig', schweig'! damit dich niemand warnt.Vocal score.Contains (expression):Meyerbeer, Giacomo,1791-1864.Huguenots.Piff, paff.Vocal score.Contains (expression):Bizet, Georges,1838-1875.Jolie fille de Perth.Quand la flamme de l'amour.Vocal score.Contains (expression):Donizetti, Gaetano,1797-1848.Lucia di Lammermoor.Dalle stanze ove Lucia.Vocal score.Contains (expression):Nicolai, Otto,1810-1849.Lustigen Weiber von Windsor.Als Büblein klein.Vocal score.Contains (expression):Verdi, Giuseppe,1813-1901.Macbeth.Come dal ciel precipita.Vocal score.Contains (expression):Massenet, Jules,1842-1912.Manon.Épouse quelque brave fille.Vocal score.Contains (expression):Thomson, Virgil,1896-1989.Mother of us all.What what is it.Vocal score.Contains (expression):Mozart, Wolfgang Amadeus,1756-1791.Nozze di Figaro.Vendetta.Vocal score.Contains (expression):Mozart, Wolfgang Amadeus,1756-1791.Nozze di Figaro.Se vuol ballare, signor contino.Vocal score.Contains (expression):Mozart, Wolfgang Amadeus,1756-1791.Nozze di Figaro.Non più andrai farfallone.Vocal score.Contains (expression):Mozart, Wolfgang Amadeus,1756-1791.Nozze di Figaro.Aprite un po' quegl' occhi.Vocal score.Contains (expression):Verdi, Giuseppe,1813-1901.Simon Boccanegra.Lacerato spirito.Vocal score.Contains (expression):Bellini, Vincenzo,1801-1835.Sonnambula.Vi ravviso, o luoghi ameni.Vocal score.Contains (expression):Weill, Kurt,1900-1950.Street scene.Let things be like they always was.Vocal score.Contains (expression):Verdi, Giuseppe,1813-1901.Vêpres siciliennes.Et toi Palerme.Italian.Vocal score.Contains (expression):Mozart, Wolfgang Amadeus,1756-1791.Zauberflöte.O Isis und Osiris (Aria and chorus)O Isis und Osiris.Vocal score.Contains (expression):Mozart, Wolfgang Amadeus,1756-1791.Zauberflöte.In diesen heil'gen Hallen.Vocal score.G. Schirmer opera anthology.0parcopycat2ncip20y-genmusicacquire2 shelf copiespolicy defaultvl34 2014-01-28 z-clientvl34 2014-01-28vl34 2014-01-28 4 sound disc to MBRS for shelf labelvl34 2014-01-28 copy 2, 4 sound disc to MBRS for shelf label '), +(:bib_tag, '07199ccm a2200829 i 45001802185120140128141932.0140128s2013 nyuopk| n | mul d 201356519097814803284711480328472884088883164HL50498715Hal Leonard(bk.)63010268Hal Leonard(CD)63011100Hal Leonard(CD)63014780Hal Leonard(CD)63014781Hal Leonard(CD)(OCoLC)ocn825047719(OCoLC)825047719YDXCPengrdaYDXCPCLEMYGZQPDLClccopycatM1507.A+Arias for soprano :complete package : with diction coach and accompaniment CDs /compiled and edited by Robert L. Larsen.New York, NY :G. Schirmer, Inc.,2013.Milwaukee, WI :Distributed by Hal Leonard Corporation1 vocal score (269 pages) ;31 cm +4 sound discs (digital ; 4 3/4 in.)notated musicntmrdacontentperformed musicprmrdacontentunmediatednrdamediaaudiosrdamediavolumencrdacarrieraudio discsdrdacarrierG. Schirmer opera anthologyThe ballad of Baby Doe. Willow song. The silver aria / Douglas Moore -- Un ballo in maschera. Saper vorreste / Giuseppe Verdi -- La Bohème. Mi chiamano Mimì ; Quando men vo ; Donde lieta / Giacomo Puccini -- Carmen. Je dis que rien ne m'épouvante / Georges Bizet -- Les contes d'Hoffmann. Elle a fui, la tourterelle! / Jacques Offenbach -- Don Giovanni. Batti, batti, o bel Masetto ; Vedrai, carino / Wolfgang Amadeus Mozart -- Falstaff. Sul fil d'un soffio etesio / Giuseppe Verdi -- Faust. Ah! Je ris de me voir (The jewel song) / Charles Gounod -- Fidelio. O wär' ich schon mit dir vereint / Ludwig van Beethoven -- Der Freischütz. Kommt ein schlanker Bursch gegangen / Carl Maria von Weber -- Gianni Schicchi. O mio babbino caro / Giacomo Puccini -- Giulio Cesare. V'adoro, pupille / George Frideric Handel -- Madama Butterfly. Un bel di vedremo / Giacomo Puccini -- Manon. Adieu, notre petite table / Jules Massenet -- The medium. The black swan ; Monica's waltz / Gian Carlo Menotti -- Le nozze di Figaro. Porgi, amor ; Dove sono i bei momenti ; Deh vieni, non tardar / Wolfgang Amadeus Mozart -- I pagliacci. Stridono lassù / Ruggero Leoncavallo -- Rigoletto. Caro nome / Giuseppe Verdi -- Roméo et Juliette. Ah! Je veux vivre / Charles Gounod -- Der Schauspieldirektor. Bester Jüngling / Wolfgang Amadeus Mozart -- Tartuffe. Fair Robin I love / Kirke Mecham -- Turandot. Signore, ascolta! ; Tu che di gel sei cinta / Giacomo Puccini -- Die Zauberflöte. Ach ich fühl's / Wolfgang Amadeus Mozart.OperasExcerptsVocal scores with piano.Recorded accompaniments (High voice)Larsen, Robert L.,1934-Contains (expression):Moore, Douglas,1893-1969.Ballad of Baby Doe.Willow song.Vocal score.Contains (expression):Moore, Douglas,1893-1969.Ballad of Baby Doe.Gold is a fine thing.Vocal score.Contains (expression):Verdi, Giuseppe,1813-1901.Ballo in maschera.Saper vorreste.Vocal score.Contains (expression):Puccini, Giacomo,1858-1924.Bohème.Sì, mi chiamano Mimì.Vocal score.Contains (expression):Puccini, Giacomo,1858-1924.Bohème.Quando me'n vo.Vocal score.Contains (expression):Puccini, Giacomo,1858-1924.Bohème.Donde lieta uscì.Vocal score.Contains (expression):Bizet, Georges,1838-1875.Carmen.Je dis que rien ne m'épouvante.Vocal score.Contains (expression):Offenbach, Jacques,1819-1880.Contes d'Hoffmann.Elle a fui, la tourterelle.Vocal score.Contains (expression):Mozart, Wolfgang Amadeus,1756-1791.Don Giovanni.Batti, batti, o bel Masetto.Vocal score.Contains (expression):Mozart, Wolfgang Amadeus,1756-1791.Don Giovanni.Vedrai, carino, se sei buonino.Vocal score.Contains (expression):Verdi, Giuseppe,1813-1901.Falstaff.Sul fil d'un soffio etesio.Vocal score.Contains (expression):Gounod, Charles,1818-1893.Faust.Je ris de me voir si belle.Vocal score.Contains (expression):Beethoven, Ludwig van,1770-1827.Fidelio(1814).O wär ich schon mit dir vereint.Vocal score.Contains (expression):Weber, Carl Maria von,1786-1826.Freischütz.Kommt ein schlanker Bursch gegangen.Vocal score.Contains (expression):Puccini, Giacomo,1858-1924.Trittico.Gianni Schicchi.O mio babbino caro.Vocal score.Contains (expression):Handel, George Frideric,1685-1759.Giulio Cesare.V'adoro, pupille.Vocal score.Contains (expression):Puccini, Giacomo,1858-1924.Madama Butterfly.Un bel dì, vedremo.Vocal score.Contains (expression):Massenet, Jules,1842-1912.Manon.Adieu, notre petite table.Vocal score.Contains (expression):Menotti, Gian Carlo,1911-2007.Medium.Black swan.Vocal score.Contains (expression):Menotti, Gian Carlo,1911-2007.Medium.Monica's waltz.Vocal score.Contains (expression):Mozart, Wolfgang Amadeus,1756-1791.Nozze di Figaro.Porgi amor.Vocal score.Contains (expression):Mozart, Wolfgang Amadeus,1756-1791.Nozze di Figaro.Dove sono?Vocal score.Contains (expression):Mozart, Wolfgang Amadeus,1756-1791.Nozze di Figaro.Deh vieni, non tardar.Vocal score.Contains (expression):Leoncavallo, Ruggiero,1858-1919.Pagliacci.Hui! stridono lassù.Vocal score.Contains (expression):Verdi, Giuseppe,1813-1901.Rigoletto.Caro nome.Vocal score.Contains (expression):Gounod, Charles,1818-1893.Roméo et Juliette.Je veux vivre dans le rêve.Vocal score.Contains (expression):Mozart, Wolfgang Amadeus,1756-1791.Schauspieldirektor.Bester Jüngling.Vocal score.Contains (expression):Mechem, Kirke.Tartuffe.Fair Robin I love.Vocal score.Contains (expression):Puccini, Giacomo,1858-1924.Turandot.Signore, ascolta!Vocal score.Contains (expression):Puccini, Giacomo,1858-1924.Turandot.Tu che di gel sei cinta.Vocal score.Contains (expression):Mozart, Wolfgang Amadeus,1756-1791.Zauberflöte.Ach, ich fühl's, es ist verschwunden.Vocal score.G. Schirmer opera anthology.0parcopycat2ncip20y-genmusicacquire2 shelf copiespolicy defaultvl34 2014-01-28 z-clientvl34 2014-01-28vl34 2014-01-28 4 sound disc to MBRS for shelf labelvl34 2014-01-28 copy 2, 4 sound disc to MBRS for shelf label '), +(:bib_tag, '01182ccm a22003254i 45001801834920140307095439.0140124s2013 flusta| he n | zxx 7cbcorignew3ncip20y-genmusicacquire2 shelf copiespolicy defaultvk13 2014-01-24vl34 2014-02-27 to Music Divisionvl34 2014-02-27 c. 2 to Music Divisionvl39 2014-3-7 to BCCD c.1 20135684039781574632255884088872281HL00114421Hal LeonardDLCengrdaDLCengMT485.I58 2013Intermediate studies for developing artists on the tuba /[compiled] by Howard Hilliard.First edition.Del Ray Beach, Florida :Meredith Music Publications,2013.Milwaukee, WI :Exclusively distributed by Hal Leonard©20131 score (48 pages) ;31 cmnotated musicrdacontentunmediatedrdamediavolumerdacarrierStaff notation.TubaStudies and exercises.Hilliard, Howard,compiler. '), +(:bib_tag, '01995ccm a22004935i 45001805732120140306100536.0140306t20142014gw sga i n ger d0ibccopycat3ncip20y-gencatlgacquire1 shelf copiespolicy defaultfd08 2014-03-06 z-processor 20134931959783890077772 (hd. bd.)3890077773 (hd. bd.)9784890077773(OCoLC)ocn867509274OHXengOHXrdaOCLCQKLMWTUZCUTDFOCLCODLCgerenglccopycatML96.5.B8 op.49, no. 4 2014Brahms, Johannes,1833-1897,composer.Lieder,op. 49.WiegenliedWiegenlied :Guten Abend, gut' Nacht, Opus 49, Nr. 4 : Faksimile nach dem Autograph des Glinka-Nationalmuseums für Musikkultur, Moskau /von Johannes Brahms ; mit einem Geleitwort von Brigitte Fassbaender und einer Einführung von Wolfgang Sandberger.Laaber :Laaber-Verlag,[2014]©20141 score (14 pages, [4] pages of music) :4 facsimiles ;17 x 25 cm.notated musicntmrdacontentunmediatednrdamediavolumencrdacarrierMeisterwerke der Musik im Faksimile ;Bd. 30For voice and piano.German words.Facsimile reprint.Staff notation.Preface and introduction in German and English.Songs with piano.Lullabies.MusicManuscriptsFacsimiles.Brahms, Johannes,1833-1897ManuscriptsFacsimiles.Fassbaender, Brigitte,writer of added commentary.Sandberger, Wolfgang,writer of added commentary.Meisterwerke der Musik im Faksimile ;Bd. 30.8675092742014013133240793001286 '), +(:bib_tag, '00854cas a22002295i 45001756839920130213162001.0121219cuuuu9999xxu | | 0 0eng 0ibcserials*ncip20z-ilssercaacquire1 shelf copiespolicy defaultrh13 2012-12-19 to Selection OfficerDLCengDLCrdapccIEEE International conference on software testing, verification and validation :[proceedings].(ICST)Piscataway, NJ :Institute of Electrical and Electronic Engineers, Inc.volumes :illustrations ;cmtextrdacontentunmediatedrdamediavolumerdacarrierDescription based on: 5th, (ICST 2012).Institute of Electrical and Electronic Engineers, Inc.') +; diff --git a/Open-ILS/tests/datasets/sql/load_all.sql b/Open-ILS/tests/datasets/sql/load_all.sql index 0589baccb1..22947fc0f7 100644 --- a/Open-ILS/tests/datasets/sql/load_all.sql +++ b/Open-ILS/tests/datasets/sql/load_all.sql @@ -27,6 +27,9 @@ BEGIN; -- load fiction bibs \i bibs_fic.sql +-- load RDA bibs +\i bibs_rda.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; @@ -43,6 +46,9 @@ INSERT INTO biblio.record_entry (marc, last_xact_id) -- load fiction copies, etc. \i assets_fic.sql +-- load RDA copies, etc. +\i assets_rda.sql + -- load sample patrons \i users_patrons_100.sql -- 2.43.2