From 902b3e342b842e7422be728d7d89d6786fd434f9 Mon Sep 17 00:00:00 2001 From: Galen Charlton Date: Fri, 6 Jan 2017 14:49:16 -0500 Subject: [PATCH] LP#1638299: sample LC and MeSH authority records Signed-off-by: Galen Charlton Signed-off-by: Galen Charlton Signed-off-by: Kathy Lussier --- Open-ILS/tests/datasets/sql/auth_lc.sql | 1076 +++++++++++++++++++++++++++++ Open-ILS/tests/datasets/sql/auth_mesh.sql | 284 ++++++++ Open-ILS/tests/datasets/sql/load_all.sql | 6 + 3 files changed, 1366 insertions(+) create mode 100644 Open-ILS/tests/datasets/sql/auth_lc.sql create mode 100644 Open-ILS/tests/datasets/sql/auth_mesh.sql diff --git a/Open-ILS/tests/datasets/sql/auth_lc.sql b/Open-ILS/tests/datasets/sql/auth_lc.sql new file mode 100644 index 0000000000..21f300f3ed --- /dev/null +++ b/Open-ILS/tests/datasets/sql/auth_lc.sql @@ -0,0 +1,1076 @@ +\set xact_id '''IMPORT LC AUTHORITIES''' + +INSERT INTO authority.record_entry(marc, last_xact_id) VALUES ($$ + 01182cz a2200157n 4500 + gf2014026111 + DLC + 20151207162657.6 + 141201|| anznnbabn |a ana c + + gf2014026111 + + + IlChALCS + eng + DLC + lcgft + DLC + + + Illustrated works + + + Pictorial works + + + Genre terms : a thesaurus for use in rare book and special collections cataloging, via WWW, Aug. 5, 2014 + (Illustrated works. NT Allegories; Alphabet books; Anatomical atlases; Anthropomorphic letters; Armorials; Artists' books; Big little books; Blow books; Books of hours; Brand books; Caricatures; Cartoons; Catchpenny prints; Coloring books; Comic books; Cries; Cruise book; Dance of death; Drawing books; Emblem books; Flip books; Herbals; Livres d'artistes; Metamorphic pictures; Painted books; Pattern books; Picture novels; Posters; Toy books; Viewbooks) + + + Art & architecture thesaurus online, Aug. 5, 2014 + (illustrated books. Books that include visual images to explain, augment, or embellish the text.) + + + Works that consist entirely or largely of images or that include images that explain, augment, or embellish text or other content. + +$$, :xact_id); +INSERT INTO authority.record_entry(marc, last_xact_id) VALUES ($$ + 03922cz a2200361n 4500 + gf2014026266 + DLC + 20160204142514.9 + 141201|| anznnbabn |a ana c + + gf2014026266 + + + IlChALCS + eng + DLC + lcgft + DLC + + + Comics (Graphic works) + + + Art, Sequential + + + Comic books, strips, etc. + + + Comic magazines + + + Comic papers + + + Comic strips + + + Comicbooks + + + Comix + + + Funnies (Comics) + + + Magazines, Comic + + + Papers, Comic + + + Sequential art + + + Serial picture books + + + g + Illustrated works + + + g + Literature + + + Lyga, A.A.W. Graphic novels in your media center, 2004: + p. 17 (Comic book: used to describe both the medium itself and the periodical form. As a result, all graphic novels are comic books, but not all comic books are graphic novels. Comic: Used interchangeably with "comic book." Graphic novel: Used to describe the specific format of a comic book that has greater production values and longer narrative. Can also describe the trade paperback format.) + + + Miller, S. Developing and promoting graphic novel collections, c2005: + p. 118 (comic strip: sequence of cartoons that relates a narrative story. The key here is that drawings are in a specific sequence that tells a story; comic book: sequences of comic strips, often relating a single story, bound as a magazine. Although a comic book contains collections of comic strips, this does not constitute a graphic novel. A comic book is properly categorized as a serial; graphic novel: a book presenting a fictional story told in a comic-strip format; expresses a single story through comic art; for practical purposes, it is common to refer to an original graphic novel with chapters and a bound collection with episodes as graphic novels) + + + Wikipedia, Dec. 5, 2012: + Comic book (A comic book or comicbook, also called comic paper or comic magazine (often shortened to simply comic or comics) is a magazine made up of "comics"--narrative artwork in the form of separate panels that represent individual scenes, often accompanied by dialog (usually in word balloons, emblematic of the comic book art form) as well as including brief descriptive prose.) Comics (A comic, often known collectively as comics, is a hybrid medium in which illustrations are strongly blended with other types of communicative representations, usually written words (see comics vocabulary), in order to convey information or narrative, thus seeking synergy by using both visual and verbal (or otherwise communicative) elements in interaction; comic strips; comic books) Comic strip (A comic strip is a sequence of drawings arranged in interrelated panels to display brief humor or form a narrative, often serialized, with text in balloons and captions. Traditionally, throughout the 20th century and into the 21st, these were published in newspapers, with horizontal strips printed in black-and-white in daily newspapers, while Sunday newspapers offered longer sequences in special color comics sections; cartoonist Will Eisner has suggested that 'sequential art' would be a better name) + + + Oxford dictionaries website, Dec. 6, 2012 + (comic noun 2. a periodical containing comic strips, intended chiefly for children; (comics) North American comic strips; comix: comic books and comic strips, especially ones written for adults or of an underground or alternative nature. Origin: alteration of comics; comic strip: a sequence of drawings in boxes that tell an amusing story, typically printed in a newspaper or magazine) + + + Encyclopedia of American comics, 1990. + + + Carrier, D. The aesthetics of comics, 2000. + + + Narrative works that employ sequential art, and often prose, to tell the story. + +$$, :xact_id); +INSERT INTO authority.record_entry(marc, last_xact_id) VALUES ($$ + 01587cz a2200253n 4500 + gf2014026362 + DLC + 20151214152523.8 + 141201|| anznnbabn |a ana c + + gf2014026362 + + + IlChALCS + eng + DLC + lcgft + DLC + + + Graphic novels + + + Comic book novels + + + Graphic albums + + + Graphic novellas + + + Novellas, Graphic + + + Novels, Comic book + + + Novels, Graphic + + + g + Comics (Graphic works) + + + Fletcher-Spear, K. Library collections for teens : manga and graphic novels, c2011: + p. 4 (A graphic novel is a book-length narrative, of any genre, for any audience, which uses sequential art, either by itself or in combination with text elements, in order to tell a story.) + + + Lyga, A.A.W. Graphic novels in your media center, 2004: + p. 17 (GN: An abbreviation for graphic novel. A typical abbreviation in the industry for graphic novel, usually used as part of a title to indicate to a reader or browser that the title in question is not a periodical.) + + + Goldsmith, F. The readers' advisory guide to graphic novels, 2010: + p. 3 (The graphic novel, as a narrative publication, can be found on the continuum of sequential art that also comprises comic strips, comic books, and Latin American fotonovelas.) + + + LCSH, Oct. 22, 2014 + (Graphic novels. UF Comic book novels; Graphic albums; Graphic novellas) + + + Book-length narratives of any genre that consist of sequential art, either by itself or in combination with text. + +$$, :xact_id); +INSERT INTO authority.record_entry(marc, last_xact_id) VALUES ($$ + 00518nz a2200133n 4500 + mp2013015079 + DLC + 20140224113448.7 + 011228|| annnnbabn |a ana + + mp2013015079 + + + DLC + eng + DLC + lcmpt + + + bell + + + g + percussion idiophone + + + New Grove Online March 20, 2013: + Under Bells i (idiophone consisting of a hollow object, usually of metal but in some cultures of hard clay or even glass, which when struck emits a sound by the vibration of most of its mass) + +$$, :xact_id); +INSERT INTO authority.record_entry(marc, last_xact_id) VALUES ($$ + 00505nz a2200145n 4500 + mp2013015187 + DLC + 20140224113453.3 + 860211|| annnnbabn |a ana + + mp2013015187 + + + DLC + eng + DLC + lcmpt + + + cowbell + + + g + bell + + + New Grove Online April 1, 2013: + (clapperless bell. Graduated sets of cowbells have been used in most periods of jazz history) + + + A percussion instrument similar to bells worn by livestock, but without a clapper. + +$$, :xact_id); +INSERT INTO authority.record_entry(marc, last_xact_id) VALUES ($$ + 07681cz a2201717n 4500 + n78095332 + DLC + 20160211093456.0 + 831215n| azannaabn |b aab + + n 78095332 + sh 85120820 + + + (OCoLC)oca00230409 + + + DLC + eng + rda + DLC + DLC + MH + OCoLC + NjP + IU + WU + DLC + OCoLC + WU + DLC + DLC-OK + Uk + SG-SiILA + CU-HE + Uk + DLC + InU + OCoLC + CSt + OCoLC + CSt + UPB + DFo + WU + DFo + DLC + + + [..1564-04-26] + 1616-04-23 + edtf + + + 1564-04-26 + 1616-04-23 + edtf + + + PR2750 + PR3112 + + + Shakespeare, William, + 1564-1616 + + + Stratford-upon-Avon (England) + Stratford-upon-Avon (England) + Great Britain + England + London (England) + Stratford-upon-Avon (England) + naf + + + Drama + Poetry + Acting + lcsh + + + Theatre + + + Poets + Dramatists + Actors + lcsh + + + Poets + Dramatists + Actors + itoamc + + + male + + + eng + + + Shakspeare, William, + 1564-1616 + + + Šekʻspiri, Uiliam, + 1564-1616 + + + Saixpēr, Gouilliam, + 1564-1616 + + + Shakspere, William, + 1564-1616 + + + Shikisbīr, Wilyam, + 1564-1616 + + + Szekspir, Wiliam, + 1564-1616 + + + Šekspyras, + 1564-1616 + + + Shekspir, Vilʹi͡am, + 1564-1616 + + + Šekspir, Viljem, + 1564-1616 + + + Tsikinya-chaka, + 1564-1616 + + + Sha-shih-pi-ya, + 1564-1616 + + + Shashibiya, + 1564-1616 + + + Sheḳspir, Ṿilyam, + 1564-1616 + + + Shaḳspir, Ṿilyam, + 1564-1616 + + + Syeiksŭpʻio, + 1564-1616 + + + Shekspir, V. + (Vilʹi͡am), + 1564-1616 + + + Szekspir, William, + 1564-1616 + + + Shakespeare, Guglielmo, + 1564-1616 + + + Shake-speare, William, + 1564-1616 + + + Sha-ō, + 1564-1616 + + + Şekspir, + 1564-1616 + + + Shekspir, Uiliam, + 1564-1616 + + + Shekspir, U. + (Uiliam), + 1564-1616 + + + Šekspir, Vilijam, + 1564-1616 + + + Ṣēkspiyar, Viliyam, + 1564-1616 + + + Shakspir, + 1564-1616 + + + Shekspyr, Vyli͡em, + 1564-1616 + + + Şekspir, Velyam, + 1564-1616 + + + Ṣēkspiyar, Villiyam, + 1564-1616 + + + Shēkʻspʻiyr, Vlilliam, + 1564-1616 + + + Ṣēkspiyar, + 1564-1616 + + + Ṣēkspiyar Mahākavi, + 1564-1616 + + + Ṣēkspiyar Mahākaviya, + 1564-1616 + + + Sheḳspier, Ṿilyam, + 1564-1616 + + + Shēkʻspir, + 1564-1616 + + + Shakespeare, + 1564-1616 + + + Śeksper, + 1564-1616 + + + Шекспир, Вильям, + 1564-1616 + + + Шекспир, Уильям, + 1564-1616 + + + שייקספיר, וויליאם, + 1564-1616 + + + שייקספיר, וו., + 1564-1616 + + + שיקספיר, וויליאם + + + שיקספיר, ויליאם + + + שיקספיר, ויליאם, + 1564-1616 + + + שכספיר, ויליאם, + 1564-1616 + + + שכספיר, וילים, + 1564-1616 + + + שכספיר, ו׳ + + + שעפקספיר, וויליאם, + 1564-1616 + + + שעקספיער, וויליאם + + + שעקספיער, וויליאם, + 1564-1616 + + + שעקספיער, ווילליאם + 1564-1616 + + + שעקספיער, וו., + 1564-1616 + + + שעקספיר + + + שעקספיר, וו + + + שעקספיר, וויליאם, + 1564-1616 + + + שעקספיר, וויליאמ + + + שעקספיר, ווילליאם + + + שעקספיר, ווילליאם, + 1564-1616 + + + שעקספיר, וו., + 1564-1616 + + + שעקספיר, װיליאם, + 1564-1616 + + + שעקספיר, װילליאם, + 1564-1616 + + + שעקספיר, װ., + 1564-1616 + + + שעקספער + + + שעקספער, וויליאמ + + + שקספיר + + + שקספיר, וו + + + שקספיר, וויליאם + + + שקספיר, וויליאם, + 1564-1616 + + + שקספיר, ווילים, + 1564-1616 + + + שקספיר, וילאם + + + שקספיר, ויליאם + + + שקספיר, ויליאם, + 1564-1616 + + + שקספיר, ויליים, + 1564-1616 + + + שקספיר, וילים + + + שקספיר, וילים, + 1564-1616 + + + شاكسبير، وليم + + + شاكسپير، وليم + + + شكسبير، وليام + + + شكسبير، وليم + + + شكسبير، وليم، + 1564-1616 + + + شكسبير، و. + + + شكسپير، وليم + + + شكسپير، ويليام + + + شيكسبير، وليام + + + شيكسبير، وليام.، + 1564-1616 + + + شيكسبير، وليم + + + شکسبير، وليم + + + وليم شکسبير + + + 沙士北亞威廉姆, + 1564-1616 + + + 沙士比亞威廉姆, + 1564-1616 + + + 莎士比亞威廉姆, + 1564-1616 + + + 莎士比亞威廉, + 1564-1616 + + + 莎士比亞, + 1564-1616 + + + Machine-derived non-Latin script reference project. + + + Non-Latin script references not evaluated. + + + Plessow, G. L. Um Shakespeares nordentum, 1937. + + + Sha-shih-pi-ya yen chiu wen chi, 1982 (subj.) + t.p. (Sha-shih-pi-ya) cover p. 4 (Shashibiya) + + + The plays and poems of William Shakspeare, 1966: + t.p. (William Shakspeare) + + + Hamleṭ ṿe-Sheḳspir, c1983: + p. 19 (Ṿilyam Sheḳspir; b. 4-26-1564; d. 4-25-1616) + + + Syeiksŭpʻio, 1978: + t.p. (Syeiksŭpʻio) + + + Iskusstvo klassicheskogo monologa [SR] 19--: + label (V. Shekspir) + + + Uiliam Šekʻspiri, 1996. + + + Helsztyński, S. Wizerunek Williama Szekspira, 1947. + + + nuc86-2792: Doccioli, M. Fonti italiane dei drammi di Guglielmo Shakespeare [MI] 1914 + (hdg.: on NIC rept.: Shakespeare, William) + + + His Shake-speares sonnets, 1984: + t.p. (William Shake-speare) + + + His Toroirasu to Kureshida, 1927: + p. 290 (Sha-ō) + + + Nihon kokugo d.j. + (Sha-ō: Shakespeare William) + + + His Kral Lir, 1912: + t.p. (Şekspir; W. Shakespeare [in rom.]) + + + Uiliam Shekspir, 1982: + t.p. (Uiliam Shekspir) cover (U. Shekspir) + + + Obradović, M. "Narodna demokratija" u Jugoslaviji, 1995: + p. [5] (Vilijam Šekspir) + + + Hāmleṭ, 1962: + t.p (Viliyam Ṣēkspiyar) + + + Nāy Shakspir, 1972. + + + BL auth. file, 10 Nov. 2004 + (refs.: Shekspyr, Vyli͡em, 1564-1616; Şekspir, Velyam, 1564-1616) + + + SILAS database, Dec. 28, 2004 + (hdg.: Shakespeare, William, 1564-1616; usages: Villiyam Ṣēkspiyar; Ṣēkspiyar) + + + Ru̇miyoo Ju̇liy-e qoyar, 1988: + t.p. (Śeksper) + + + LC database, Dec. 28, 2004 + (hdg.: Shakespeare, William, 1564-1616; usages: Ṣēkspiyar Mahākavi; Ṣēkspiyar Mahākaviya) + + + Yulius Tsezar, 1918: + t.p. (Ṿilyam Sheḳspier [part. voc.]) + + + Hṛomēos ew Ciwleēdda, 1866: + p. 9 (Vlilliam Shēkʻspʻiyr) + + + Arkʻay Lir, 2006: + t.p. (Shēkʻspir) + + + Hark, hark the lark, 1934 + (Shakespeare) + + + Encyclopedia Britannica, via WWW, Aug. 31, 2012 + (William Shakespeare; William Shakspere; byname Bard of Avon or Swan of Avon; baptized Apr. 26, 1564 in Stratford-upon-Avon, Warwickshire, Eng.; d. Apr. 23, 1616 in Stratford-upon-Avon; English poet, dramatist, and actor; worked in London from around 1592) + + + William Shakespeare (1564-1616) was an English poet, playwright, and actor. + +$$, :xact_id); +INSERT INTO authority.record_entry(marc, last_xact_id) VALUES ($$ + 01626cz a2200349n 4500 + n82011242 + DLC + 20141218120412.0 + 820202n| azannaabn |a aaa + + n 82011242 + + + (OCoLC)oca00708521 + + + DLC + eng + rda + DLC + DLC + OOC + DLC + WaU + DLC + + + Shakespeare, William, + 1564-1616. + Macbeth + + + Shakespeare, William, + 1564-1616. + Illustrated Macbeth + + + Shakespeare, William, + 1564-1616. + Macbeth for young people + + + Shakespeare, William, + 1564-1616. + Shakespeare's Macbeth + + + Shakespeare, William, + 1564-1616. + Shakespeare's The tragedie of Macbeth + + + Shakespeare, William, + 1564-1616. + Shakespeare's tragedy of Macbeth + + + Shakespeare, William, + 1564-1616. + Tragedie of Macbeth + + + Shakespeare, William, + 1564-1616. + Tragedy of Macbeth + + + Shakespeare, William, + 1564-1616. + William Shakespeare's Macbeth + + + Shakespeare, William, + 1564-1616. + Works of William Shakespeare. + 7. + Macbeth + + + r + Derivative (work): + Sciarrino, Salvatore. + Macbeth + + + His The illustrated Macbeth, 1982. + + + His The tragedy of Macbeth, 1982, c1966. + + + His Shakespeare's The tragedie of Macbeth, 1923: + t.p. (Shakespeare's The tragedie of Macbeth) + + + His Macbeth for young people, 1986. + + + His Macbeth, 1993. + + + His The tragedie of Macbeth, 1996. + + + Shakespeare's Macbeth, 1900. + + + William Shakespeare's Macbeth, 2005. + + + His Shakespeare's tragedy of Macbeth, 1896. + +$$, :xact_id); +INSERT INTO authority.record_entry(marc, last_xact_id) VALUES ($$ + 00487nz a2200145n 4500 + no2006000014 + DLC + 20060103071003.0 + 060102n| acannaabn |n ana c + + no2006000014 + + + (OCoLC)oca06817999 + + + PPi-MA + eng + PPi-MA + + + Harry Potter and the goblet of fire (Motion picture) + + + Doyle, P. Harry Potter and the goblet of fire [SR] p2005. + + + Internet Movie Database, Jan. 2, 2006 + (Harry Potter and the goblet of fire (2005)) + + $$, :xact_id); +INSERT INTO authority.record_entry(marc, last_xact_id) VALUES ($$ + 00373cz a2200145n 4500 + sh85075772 + DLC + 20110606093614.0 + 860211i| anannbabn |a ana + + sh 85075772 + + + DLC + DLC + DLC- + + + B127.L43 + + + Legalism (Chinese philosophy) + + + Legalist school of Chinese philosophy + + + g + Philosophy, Chinese + + $$, :xact_id); +INSERT INTO authority.record_entry(marc, last_xact_id) VALUES ($$ + 00573cz 2200193n 4500 + sh85100861 + DLC + 19861014080741.3 + 860211|| anannbab| |b ana ||| + + sh 85100861 + + + DLC + DLC + DLC + + + B108 + B708 + + + Philosophy, Ancient + + + Ancient philosophy + + + Greek philosophy + + + Philosophy, Greek + + + Philosophy, Roman + + + Roman philosophy + + + Here are entered works dealing with ancient philosophy in general and with Greek and Roman philosophy in particular. + + $$, :xact_id); +INSERT INTO authority.record_entry(marc, last_xact_id) VALUES ($$ + 00279cz 2200121n 4500 + sh85100886 + DLC + 19921229081229.9 + 860211|| anannbab| |a ana ||| + + sh 85100886 + + + DLC + DLC + DLC + + + Philosophy, Chinese + + + Chinese philosophy + + $$, :xact_id); +INSERT INTO authority.record_entry(marc, last_xact_id) VALUES ($$ + 00395nz 2200157n 4500 + sh96001809 + DLC + 19960329113616.3 + 960221|| anannbab| |a ana ||| c + + sh 96001809 + + + UkOxU + DLC + + + Epicureans (Greek philosophy) + + + g + Philosophy, Ancient + + + Work cat.: The Epicurean philosphers, 1995. + + + OED. + + + Web. 3. + + $$, :xact_id); +INSERT INTO authority.record_entry(marc, last_xact_id) VALUES ($$ + 00248nz 2200121n 4500 + sj96005301 + DLC + 19960516123921.6 + 960507|| anbnnbab| |a ana ||| + + sj 96005301 + + + DLC + DLC + + + Dogs + + + Puppies + + $$, :xact_id); diff --git a/Open-ILS/tests/datasets/sql/auth_mesh.sql b/Open-ILS/tests/datasets/sql/auth_mesh.sql new file mode 100644 index 0000000000..c60f0ea566 --- /dev/null +++ b/Open-ILS/tests/datasets/sql/auth_mesh.sql @@ -0,0 +1,284 @@ +\set xact_id '''IMPORT MESH AUTHORITIES''' + +INSERT INTO authority.record_entry(marc, last_xact_id) VALUES ($$ + 00957nz a2200301n 4500 + D000136 + DNLM + 20160202000000.0 + 990101 n ancnnbabn || ana + + DNLM + DNLM + + + QU 105 + + + G2. + 111. + 29 + + + G2. + 300. + 176 + + + G3. + 30 + + + G7. + 700. + 345. + 110 + + + G9. + 188. + 50 + + + Acid-Base Equilibrium + + + nnna + Acid-Base Balance + + + Anion Gap + + + nnna + Acid Base Balance + + + nnna + Acid Base Equilibrium + + + nnna + Anion Gaps + + + nnna + Balance, Acid-Base + + + nnna + Equilibrium, Acid-Base + + + nnna + Gap, Anion + + + nnna + Gaps, Anion + + + consider also ACID-BASE IMBALANCE + + + The balance between acids and bases in the BODY FLUIDS. The pH (HYDROGEN-ION CONCENTRATION) of the arterial BLOOD provides an index for the total body acid-base balance. + +$$, :xact_id); +INSERT INTO authority.record_entry(marc, last_xact_id) VALUES ($$ + 00231nz a2200097n 4500 + D000136Q000187 + DNLM + 20160202000000.0 + 990101 n ancnnbabn n ana + + DNLM + DNLM + + + Acid-Base Equilibrium + drug effects + +$$, :xact_id); +INSERT INTO authority.record_entry(marc, last_xact_id) VALUES ($$ + 00227nz a2200097n 4500 + D000136Q000235 + DNLM + 20160202000000.0 + 990101 n ancnnbabn n ana + + DNLM + DNLM + + + Acid-Base Equilibrium + genetics + +$$, :xact_id); +INSERT INTO authority.record_entry(marc, last_xact_id) VALUES ($$ + 00229nz a2200097n 4500 + D000136Q000276 + DNLM + 20160202000000.0 + 990101 n ancnnbabn n ana + + DNLM + DNLM + + + Acid-Base Equilibrium + immunology + +$$, :xact_id); +INSERT INTO authority.record_entry(marc, last_xact_id) VALUES ($$ + 00229nz a2200097n 4500 + D000136Q000502 + DNLM + 20160202000000.0 + 990101 n ancnnbabn n ana + + DNLM + DNLM + + + Acid-Base Equilibrium + physiology + +$$, :xact_id); +INSERT INTO authority.record_entry(marc, last_xact_id) VALUES ($$ + 00236nz a2200097n 4500 + D000136Q000528 + DNLM + 20160202000000.0 + 990101 n ancnnbabn n ana + + DNLM + DNLM + + + Acid-Base Equilibrium + radiation effects + +$$, :xact_id); +INSERT INTO authority.record_entry(marc, last_xact_id) VALUES ($$ + 00720nz a2200205n 4500 + D000138 + DNLM + 20160202000000.0 + 990101 n ancnnbabn || ana + + DNLM + DNLM + + + C18. + 452. + 76. + 176 + + + Acidosis + + + nnna + Metabolic Acidosis + + + nnna + Acidoses + + + nnna + Acidoses, Metabolic + + + nnna + Acidosis, Metabolic + + + nnna + Metabolic Acidoses + + + Acid-Base Equilibrium + + + general or unspecified; prefer specifics + + + A pathologic condition of acid accumulation or depletion of base in the body. The two main types are RESPIRATORY ACIDOSIS and metabolic acidosis, due to metabolic acid build up. + +$$, :xact_id); +INSERT INTO authority.record_entry(marc, last_xact_id) VALUES ($$ + 00218nz a2200097n 4500 + D000138Q000469 + DNLM + 20160202000000.0 + 990101 n ancnnbabn n ana + + DNLM + DNLM + + + Acidosis + parasitology + +$$, :xact_id); +INSERT INTO authority.record_entry(marc, last_xact_id) VALUES ($$ + 00216nz a2200097n 4500 + D000138Q000276 + DNLM + 20160202000000.0 + 990101 n ancnnbabn n ana + + DNLM + DNLM + + + Acidosis + immunology + +$$, :xact_id); +INSERT INTO authority.record_entry(marc, last_xact_id) VALUES ($$ + 00218nz a2200097n 4500 + D000138Q000382 + DNLM + 20160202000000.0 + 990101 n ancnnbabn n ana + + DNLM + DNLM + + + Acidosis + microbiology + +$$, :xact_id); +INSERT INTO authority.record_entry(marc, last_xact_id) VALUES ($$ + 00215nz a2200097n 4500 + D000138Q000175 + DNLM + 20160202000000.0 + 990101 n ancnnbabn n ana + + DNLM + DNLM + + + Acidosis + diagnosis + +$$, :xact_id); +INSERT INTO authority.record_entry(marc, last_xact_id) VALUES ($$ + 00221nz a2200097n 4500 + D000138Q000503 + DNLM + 20160202000000.0 + 990101 n ancnnbabn n ana + + DNLM + DNLM + + + Acidosis + physiopathology + +$$, :xact_id); diff --git a/Open-ILS/tests/datasets/sql/load_all.sql b/Open-ILS/tests/datasets/sql/load_all.sql index 472795d7e4..df4e532af2 100644 --- a/Open-ILS/tests/datasets/sql/load_all.sql +++ b/Open-ILS/tests/datasets/sql/load_all.sql @@ -30,6 +30,12 @@ BEGIN; -- load RDA bibs \i bibs_rda.sql +-- load LC authorities +\i auth_lc.sql + +-- load MeSH authorities +\i auth_mesh.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; -- 2.11.0