From 954bb310efd5ee54d819ae85ad18c3bc1fab8e22 Mon Sep 17 00:00:00 2001 From: Bill Erickson Date: Wed, 4 Sep 2013 09:26:23 -0400 Subject: [PATCH] Fiction records / copies test data Adds 17 (mostly) fiction bib records w/ copies to OpenILS/tests/datasets/sql/. New items are loaded via load_all.sql. Special thanks to Rogan Hamby for donating (and I believe creating) these records many moons ago. For reference: The father hunt; Southern Gods / The winter of our discontent / CliffsNotes Steinbeck's Of mice and men / The rum diary Blueberry girl / Stardust Coraline Objective-C programming : The swordsman of Mars / Ghost story The Avengers Throne of the Crescent Moon / The walking dead. Kraken : The crow The running man / Signed-off-by: Bill Erickson Signed-off-by: Ben Shum --- Open-ILS/tests/datasets/sql/assets_fic.sql | 28 ++++++++++++++++++++++ Open-ILS/tests/datasets/sql/bibs_fic.sql | 22 +++++++++++++++++ Open-ILS/tests/datasets/sql/load_all.sql | 6 +++++ 3 files changed, 56 insertions(+) create mode 100644 Open-ILS/tests/datasets/sql/assets_fic.sql create mode 100644 Open-ILS/tests/datasets/sql/bibs_fic.sql diff --git a/Open-ILS/tests/datasets/sql/assets_fic.sql b/Open-ILS/tests/datasets/sql/assets_fic.sql new file mode 100644 index 0000000000..617dff331e --- /dev/null +++ b/Open-ILS/tests/datasets/sql/assets_fic.sql @@ -0,0 +1,28 @@ +-- Create call numbers +SELECT evergreen.populate_call_number(4, 'FIC ', 'IMPORT FIC', NULL); -- BR1 +SELECT evergreen.populate_call_number(5, 'FIC ', 'IMPORT FIC', NULL); -- BR2 +SELECT evergreen.populate_call_number(6, 'FIC ', 'IMPORT FIC', NULL); -- BR3 +SELECT evergreen.populate_call_number(7, 'FIC ', 'IMPORT FIC', NULL); -- BR4 +SELECT evergreen.populate_call_number(9, 'FIC ', 'IMPORT FIC', NULL); -- BM1 + +-- Create copies +SELECT evergreen.populate_copy(4, 4, 'FIC40000', 'FIC'); -- BR1 +SELECT evergreen.populate_copy(5, 5, 'FIC50000', 'FIC'); -- BR2 +SELECT evergreen.populate_copy(6, 6, 'FIC60000', 'FIC'); -- BR3 +SELECT evergreen.populate_copy(7, 7, 'FIC70000', 'FIC'); -- BR4 +SELECT evergreen.populate_copy(9, 9, 'FIC90000', 'FIC'); -- BM1 + +SELECT evergreen.populate_copy(4, 4, 'FIC41000', 'FIC'); -- BR1 +SELECT evergreen.populate_copy(4, 4, 'FIC42000', 'FIC'); -- BR1 +SELECT evergreen.populate_copy(4, 4, 'FIC43000', 'FIC'); -- BR1 +SELECT evergreen.populate_copy(4, 4, 'FIC44000', 'FIC'); -- BR1 +SELECT evergreen.populate_copy(4, 4, 'FIC45000', 'FIC'); -- BR1 +SELECT evergreen.populate_copy(4, 4, 'FIC46000', 'FIC'); -- BR1 +SELECT evergreen.populate_copy(4, 4, 'FIC47000', 'FIC'); -- BR1 +SELECT evergreen.populate_copy(4, 4, 'FIC48000', 'FIC'); -- BR1 +SELECT evergreen.populate_copy(4, 4, 'FIC49000', 'FIC'); -- BR1 + +SELECT evergreen.populate_copy(5, 5, 'FIC51000', 'FIC'); -- BR2 +SELECT evergreen.populate_copy(6, 6, 'FIC61000', 'FIC'); -- BR3 +SELECT evergreen.populate_copy(7, 7, 'FIC71000', 'FIC'); -- BR4 +SELECT evergreen.populate_copy(9, 9, 'FIC91000', 'FIC'); -- BM1 diff --git a/Open-ILS/tests/datasets/sql/bibs_fic.sql b/Open-ILS/tests/datasets/sql/bibs_fic.sql new file mode 100644 index 0000000000..c6e50f08e2 --- /dev/null +++ b/Open-ILS/tests/datasets/sql/bibs_fic.sql @@ -0,0 +1,22 @@ +\set bib_tag '''IMPORT FIC''' + +INSERT INTO marcxml_import (tag, marc) VALUES + +(:bib_tag,'00962cam a22002891 4500CONS20130416184900.0701012s1968 nyu 000 1 eng 690 68021584 //r933(SC LENDS)27848PZ3.S8894FatFICSTOStout, Rex,1886-1975The father hunt;a Nero Wolfe novel.New York,Viking Press[1968]183 p.21 cm.Twenty-two-year-old Amy Denovo needs Nero Wolfe''s help. She is determined to learn the identity of her father, a secret her mother scrupulously guarded — and took to her grave when struck by a hit-and-run driver. Now Wolfe and his sidekick, Archie, have just one clue to go on: a note from Amy''s mother and a box with over 50,000. Seems every month since Amy''s birth, her mother received ,000 from an unknown source and saved it for Amy''s future. It''s easily enough for Amy to afford Wolfe''s services, and he grudgingly agrees. But as the weeks go by, Wolfe realizes this may be one of his most challenging cases ever. Someone doesn''t want Amy''s pedigree discovered, and that someone appears to wield great power. It isn''t long before Wolfe and Archie come to believe that Amy''s mother was murdered — and that Amy could be next.Wolfe, Nero (Fictitious character)Fiction.Goodwin, Archie (Fictitious character)Fiction.Private investigatorsNew York (N.Y.)Fiction.New York (NY.)Fiction.Detective and mystery stories.gsafd[MYS] BCAF[MYS] HHAF03/23/199403/21/20003690690biblio'), +(:bib_tag,'00942cam a2200229Ka 4500687CONS20130416184621.0110401s2011 cau 000 1 eng d9781597802857(SC LENDS)1981659\FIC\JACJacobs, John Hornor.Southern Gods /John Hornor Jacobs.San Francisco, CA :Night Shade Books,2011.270 p. ;22 cm.Recent World War II veteran Bull Ingram is working as muscle when a Memphis DJ hires him to find Ramblin'' John Hastur. The mysterious blues man''s dark, driving music broadcast at ever-shifting frequencies by a phantom radio station is said to make living men insane and dead men rise.Blues musiciansFiction.Blues (Music)Fiction.Cthulhu MythosFiction.Horror FictionFiction.Suspense fiction.gsafd.687687biblio'), +(:bib_tag,'00959cam a2200253Ia 4500680CONS20130416184354.0950227s1995 nyu 000 0 eng d(SC LENDS)1121347Steinbeck, John,1902-1968.The winter of our discontent /John Steinbeck.New York :Book-of-the-Month Club,1961.311 p. ;22 cm.In awarding John Steinbeck the 1962 Nobel Prize in Literature, the Nobel committee stated that with The Winter of Our Discontent, he had "resumed his position as an independent expounder of the truth, with an unbiased instinct for what is genuinely American. Ethan Allen Hawley, the novel''s protagonist, works as a clerk in a grocery store that his prominent family once owned. Without status in the town, his wife is restless, and his teenage children are hungry for the tantalizing material comforts he cannot provide. Then one day, in a moment of moral crisis, Ethan decides to take a holiday from his own scrupulous standards. In The Winter of Our Discontent, John Steinbeck, perhaps the master writer of the American working class, explores the cultural malaise of the 1960s and its far-ranging implications: social, familial, and personal.New York (N.Y.)Fiction.EthicsFiction.Conduct of lifeFiction.American CultureFiction.F Steinbeck, JohnASISBAFI$25.0024781726X0SAL2 4680680biblio'), +(:bib_tag,'01055nam a2200337 a 4500679CONS20130416183812.0000811s2001 cau b 001 0 eng 00107749 9780764586767 (pbk. : alk. paper)(SC LENDS)1450806PS3537.T3234O475 2001813/.5221813.52Van KirkVan Kirk, Susan,1946-CliffsNotes Steinbeck''s Of mice and men /by Susan Van Kirk.Steinbeck''s Of mice and menOf mice and menFoster City, CA :IDG Books Worldwide,c2001.iv, 74 p. ;22 cm.Includes bibliographical references (p. [67]-69) and index.The original CliffsNotes study guides offer expert commentary on major themes, plots, characters, literary devices, and historical background. The latest generation of titles in the series also feature glossaries and visual elements that complement the classic, familiar format.Steinbeck, John,1902-1968.679679biblio'), +(:bib_tag,'03103cgm a2200601Ia 4500678CONS20130416184001.0111220s2012 cau120 vleng dvd cvaizq04339639491939491Columbia TriStar Home Entertainment(SC LENDS)1987537TEFMTTEFMTTEFMR0TEFengengspaengnwpr---PN1997.2.R86 2012791.43/7223DVDRUMThe rum diary[videorecording] /Film District and GK Films/Infinitum Nihil/Film Engine production ; produced by Johnny Depp, Christi Dembrowski ; screenplay by Bruce Robinson ; directed by Bruce Robinson.Culver City, CA :Sony Pictures Home Entertainment,c2011.1 videodisc (120 min.) :sd., col. ;4 3/4 in.DVD ; anamorphic widescreen (1.85:1) presentation ; Dolby digital 5.1 surround.In English, with optional subtitles in English or Spanish.Closed-captioned.Johnny Depp, Giovanni Ribisi, Aaron Eckhart, Amber Heard, Michael Rispoli, Richard Jenkins.Music, Christopher Young ; editor, Carol Littleton ; director of photography, Dariusz Wolski.Based on the novel by Hunter S. Thompson.DVD release of the 2011 motion picture.MPAA rating: R; for language, brief drug use and sexuality.Tired of the noise and madness of New York, journalist Paul Kemp moves to Puerto Rico to write for a local newspaper. Adopting the rum-soaked life of the island, Kemp becomes obsessed with the fiancee of Sanderson, a businessman involved in shady property development deals. When he is recruited by Sanderson to write favorably about his latest unsavory scheme, Kemp is presented with the choice to use his words for the corrupt businessman''s financial benefit, or use them to take him down.Video recordings.DVD-Video discs.JournalistsPuerto RicoDrama.Comedy films.lcgftDepp, Johnny.Eckhart, Aaron.Thompson, Hunter S.Rum Diary.Sony Pictures Home Entertainment (Firm)678678biblio'), +(:bib_tag,'01819nam a22005178a 4500692CONS20130416183107.0070119s2009 nyua j 000 1 eng 20061004412329777139780060838089 (trade bdg.)0060838086 (trade bdg.)9780060838096 (lib. bdg.)0060838094 (lib. bdg.)AU@000041229075NZ111217654IG#9780060838089(SC LENDS)1473635[E]22FICGAIGaiman, Neil.Blueberry girl /written by Neil Gaiman ; illustrated by Charles Vess.1st ed.New York :HarperCollinsPublishers,2009.1 v. (unpaged) :col. ill. ;13 cm.A poem written by Neil Gaiman on the occasion of his friend Tori Amos having a daughter. The poem takes the form of well wishes and advice on how to live life fully. Illustrated by Gaiman''s collaborator on the popular Stardust comics Charles Vess.GirlsFiction.Stories in rhyme.Picture books.Vess, Charles,ill.692692biblio'), +(:bib_tag,'01347nim a2200397Ia 4500681CONS20130416182817.0sd fungnnmmned060831s2006 nyunnn f eng d006115392397800611539219780061153921UACD 5520(5)Harper Audio(SC LENDS)1448052GECGECGECBAKERSCFAhq lc tv FICGAIBCDGaimanGaiman, Neil.Stardust[sound recording] /Neil Gaiman.Unabridged.[New York] :Harper Audio,p2006..5 sound discs (6 hr.) :digital ;4 3/4 in.Compact disc.Read by the author.The story of young Tristran Thorn and his adventures in the land of Faerie. He has fallen in love with beautiful Victoria Forester and in order to win her hand, he must retrieve a fallen star and deliver it to her. Young adult.Young menFiction.EnglandFiction.Fantasy fiction.gsafdAdventure stories.gsafdLove stories.gsafdAudiobooks.681681biblio'), +(:bib_tag,'01351pam a2200301 a 4500682CONS20130416182356.0030320t20032002meua jd 000 1 eng 20030478419780786255429 (lg print : hc)0786255420(SC LENDS)140801FICGAIGaiman, Neil.Coraline [Large Print] /Neil Gaiman ; with illustrations by Dave McKean.Large print ed.Waterville, ME :Thorndike Press,2003.184 p. (large print) :ill. ;22 cm.Thorndike Press large print young adult seriesOriginally published: New York : HarperCollins, 2002.Looking for excitement, Coraline ventures through a mysterious door into a world that is similar, yet disturbingly different from her own, where she must challenge a gruesome entity in order to save herself, her parents, and the souls of three others.Supernatural Juvenile fiction.Large type books Juvenile fiction.Horror stories Juvenile fiction.McKean, Dave,ill.2682682biblio'), +(:bib_tag,'02035cam a2200373Ia 4500689CONS20130416182209.09780321706287 0321706285 (sc)(SC LENDS)1991139BCL-BEAYCL-RHQA76.73.C15H55 2011QA76.73.O115H55 2011005.11722005.117Hillegass, Aaron.Objective-C programming :the Big Nerd Ranch guide /Aaron Hillegass.Objective-C programmingAtlanta, GA :Big Nerd Ranch,c2011.ix, 272 p. :ill. ;23 cm.Big Nerd Ranch guidesIncludes index.I. Getting started. You and this book -- Your first program -- II. How programming works. Variables and types -- if/else -- Functions -- Numbers -- Loops -- Addresses and pointers -- Pass by reference -- Structs -- The heap -- III. Objective-C and foundations. Objects -- more messages -- NSString -- NSArray -- Developer documentation -- Your first class -- Inheritance -- Object instance variables -- Preventing memory leaks -- Collection classes -- Constants -- Writing files with NSString and NSData -- Callbacks -- Protocols -- Property lists -- IV. Event-driven applications. Your first iOS application -- Your first Cocoa application -- V. Advanced Objective-C. init -- Properties -- Categories -- Blocks -- VI. Advanced C. C strings -- C arrays -- Command-line arguments -- Switch statements.Objective-C (Computer program language)Object-oriented programming.689689biblio'), +(:bib_tag,'01300cam a2200421 a 4500688CONS20130416181822.0080115s2008 wau e 000 f eng9781616648107 (hbk.)1616648104 (hbk.)(SC LENDS)1527082813/.5222FIC KLISF KlineSCFKline, Otis Adelbert.The swordsman of Mars /by Otis Adelbert Kline ; introduction by Michael Moorcock ; cover by Daren Bader.Bellevue, Wash. :Paizo Publishing,2008.229 p. ;22 cm.Planet stories library ;bk. 12PLANET STORIES is an imprint of Paizo Publishing, Bellevue, Washington.In Swordsman of Mars, Harry Thorne, outcast scion of a wealthy East Coast family, seeks the greatest adventure of his life. He exchanges bodies with his look-alike, Martian Sheb Takkor, and is transported millions of years into the past to a Mars peopled with mighty warriors, beautiful women, and fearsome beasts. Sheb Takkor, a great swordsman in his own right, must fight his way across the deserts and jungles of ancient Mars to save the lovely Princess Thane and to defeat his arch-enemy Sel Han - or die trying! Edgar Rice Burroughs was the first great writer of planetary adventures. His one true rival and equal at writing planet stories was Otis Adelbert Kline. Kline was on the original editorial staff of Weird Tales, and was literary agent to Robert E. Howard of Conan fame.Rebels on the red planet! Considered by many to be the only true equal of Edgar Rice Burroughs, Otis Adelbert Kline was a master of the sword and planet genre. From his position on the original editorial staff of Weird Tales and as the literary agent for Conan creator Robert E. Howard, Kline helped shape the face of science fiction as we know it. Now, in its first complete edition since 1933, Kline brings us the story of Harry Thorne, outcast scion of a wealthy East Coast family, who agrees to swap bodies with a Martian noble, thrusting him into a fierce and vibrant world of strange beasts and stranger people, where a man''s future is determined by the strength of his sword arm. Tasked with tracking down and neutralizing another Earthman before he establishes a corrupt empire, and trapped between the love of two beautiful and dangerous women, will Harry Thorne wind up a slave in the dolorous baridium mines, or will he step forward and claim his destiny as a swordsman of Mars?Life on other planets.Mars (Planet)Fiction.Science fiction.Moorcock, Michael,introd.Bader, Daren,ill.688688biblio'), +(:bib_tag,'02356cim a2200553La 4500686CONS20130416181618.0m h cz nza||||||||sz zunznnnznzu110906r20112011ohunnnn q f n eng d9781449846541144984654856987Recorded Books(SC LENDS)1979076RECBXRECBXWV1n-us-ilZJIBPS3602.U85G48 2011f813/.622PLAYAWAY - BUTButcher, Jim,1971-Ghost story[electronic resource] /Jim Butcher.Unabridged.[Solon, Ohio] :Playaway Digital Audio ;Prince Frederick, MD :[Distributed exclusively by] Recorded Books, LLC :[Manufactured by] Findaway World, LLC,[2011], p2011.1 sound media player (18 hr.) :digital, HD audio ;3 3/8 x 2 1/8 in.A novel of the Dresden filesTitle from container."HDAUDIO."Narrated by John Glover.Release date supplied by publisher.Recording originally produced by Penguin Audio, p2011, and released by Recorded Books, LLC.Issued on Playaway, a dedicated media audio player.One set of earphones and one AAA battery required for playback.Wizard detective Harry Dresden is in a tough spot--he''s dead. Murdered by an unknown assassin, Harry is no less determined to help his imperiled friends. The problem is he must do it without any assistance from magic. And complicating matters further, several dark spirits are roaming Chicago, looking for revenge against their powerless adversary.Dresden, Harry (Fictitious character)Fiction.WizardsFiction.Chicago (Ill.)Fiction.Occult fiction.gsafdFantasy fiction.gsafdUrban fantasy.gsafdAudiobooks.lcgftGlover, John,1944-nrtRecorded Books, LLC.Penguin Audio (Firm)Playaway Digital Audio.Butcher, Jim,1971-Dresden files (Audio)686686biblio'), +(:bib_tag,'01490cgm a2200229Ka 4500685CONS20130416181241.0vd cvaizq070101s2010 cau090 vleng d07806668528839291595292000043788Warner Brothers(SCLENDS)1970730DVD FIC AVEThe Avengers[videorecording] /Warners Bros. Pictures ; directed by Jeremiah Chechik.WidescreenBurbank, CA :Warner Brothers,2010.1 videodisc (90 min.) :sd., col. ;4 3/4 in.Originally released as a motion picture in 1998.Ralph Fiennes, Uma Thurman, Sean Connery, Jim Broadbent.Rated PG-13DVD, Dolby digital.Closed-captioned for the hearing impaired.English, French.Feature films.Video recordings for the hearing impaired.Video recordings.DVD-Video discs.Steed, John (Fictitious character)Fiction.Peel, Emma (Fictitious character)Fiction.Chechik, Jeremiah.Fiennes, Ralph.Thurman, Uma.Connery, Sean.685685biblio'), +(:bib_tag,'00895cam a2200289Ia 4500691CONS20130416180823.0120125s2012 nyu 000 1 eng 7277031919780756407117 (hc.)0756407117 (hc.)(SC LENDS)1986488FIC - SALAhmed, Saladin.Throne of the Crescent Moon /Saladin Ahmed.New York :DAW Books,c2012.274 p. ;23 cm.The Crescent Moon Kingdoms ;bk. 1From Saladin Ahmed, finalist for the Nebula and Campbell Awards, comes one of the year''s most anticipated fantasy debuts, THRONE OF THE CRESCENT MOON, a fantasy adventure with all the magic of The Arabian Nights.The Crescent Moon Kingdoms, land of djenn and ghuls, holy warriors and heretics, Khalifs and killers, is at the boiling point of a power struggle between the iron-fisted Khalif and the mysterious master thief known as the Falcon Prince. In the midst of this brewing rebellion a series of brutal supernatural murders strikes at the heart of the Kingdoms. It is up to a handful of heroes to learn the truth behind these killings:Doctor Adoulla Makhslood, "The last real ghul hunter in the great city of Dhamsawaat," just wants a quiet cup of tea. Three score and more years old, he has grown weary of hunting monsters and saving lives, and is more than ready to retire from his dangerous and demanding vocation. But when an old flame''s family is murdered, Adoulla is drawn back to the hunter''s path.Raseed bas Raseed, Adoulla''s young assistant, a hidebound holy warrior whose prowess is matched only by his piety, is eager to deliver God''s justice. But even as Raseed''s sword is tested by ghuls and manjackals, his soul is tested when he and Adoulla cross paths with the tribeswoman Zamia.Zamia Badawi, Protector of the Band, has been gifted with the near-mythical power of the Lion-Shape, but shunned by her people for daring to take up a man''s title. She lives only to avenge her father''s death. Until she learns that Adoulla and his allies also hunt her father''s killer. Until she meets Raseed.When they learn that the murders and the Falcon Prince''s brewing revolution are connected, the companions must race against time--and struggle against their own misgivings--to save the life of a vicious despot. In so doing they discover a plot for the Throne of the Crescent Moon that threatens to turn Dhamsawaat, and the world itself, into a blood-soaked ruin. - Amazon.com.Have you ever read a book and wanted it to be better than it was? No, not just in a “I’m spending my precious time on this” way but for external reasons as well? I’ve spent six months reading The Throne of the Crescent Moon. It is true I don’t get a lot of time to read but I also found this book easy to put down and interrupt with … well, most things. Now, I must admit my bias. I have a deep affection for mythic Arabian settings so this book appealed to me. I was also glad to have a book that wasn’t marketed as part of a trilogy or longer series. Additionally, this book was on several best of the year lists for 2012 so my hopes were high. Icarus found out what happens when things fly too high.The failings of Throne of the Crescent Moon are damning and easily enumerated. One, the characters are flat - they do not grow or change or surprise you. The dervish''s growth is a farce - you know what will happen to him in vague strokes within the first few pages of the book and by the time the bedouin girl is introduced you can guess the exact ending (and you will be right). Two, the plot is thin; the twists have nothing to surprise you much less go “wow I would have never thought of that.” And it’s third sin is that it isn''t a world, The Throne of the Crescent Moon is really a great Dungeons and Dragons campaign setting and if the author hasn’t played plenty of D&D in his life I would be shocked. I won’t list the details here but players of D&D will recognize the subtle conventions he obeys and the structures he fits things into. That is not a sin in and of itself - The Gentleman Bastard books show how you can take a gaming campaign and tell compelling stories in it. But, when you supply that kind of structure you are telling stories as you do in a game and the writer takes the place of the Dungeon Master. It’s a dangerous gamble because not only does the writer get to stack the deck but there aren’t really any players to make choices. To make the story that comes out of it compelling the writer has to be gifted enough to create that illusion. And that is where this failed. The characters are likeable to but too flat with no surprises and as a reader you never feel so invested that you cheer for them or feel as if their failures harm you. The structure is that of a classic adventure and that’s not a great thing for a novel. The threat is massive but fits into too small a story’s space. The book is too small. The book I was thrilled to see as a stand alone novel was resolved in half the space it should have been. It felt like we jumped from the prelude with the foot soldiers straight to killing the big bad without any twists in the plot. The challenges along the way are ... not significant. I bought into the grandeur of the kingdom and that made the adventure too small. The resolution feels like a deus ex machina. Perhaps the frustration is that the writer does know his craft. His sense of language is good and engaging. There are elements of the world’s construction that are forced and others that draw you in. The characters are too flat (is that the third time I’ve mentioned that?) but likeable and while not unique are not cliches either. There was enough good here that I want to read more in this world and I want to read more from this writer. There was enough good that I want to see him grow and be there to read his work as it improves. Did this debut novel blow me away? No, but it was a throw away enjoyable read in the end if disappointing because there at times hints of it’s greater potential. Heck, it was better than Steinbeck’s first book, Cup of Gold! Finally, there is something compelling about a writer with the cojones to just throw out there “here is my pseudo Muslim world of good versus evil and the good guys are good because they are the faithful of God.” Maybe that’s what I find hard to define but I like so far about the author’s attitude: he has audacity and a voice and sometimes those are the hardest things for an author to have. - http://www.goodreads.com/review/show/511797866Fantasy fiction.Adventure stories.Arabian Nights fiction.Fantasy fiction.Adventure stories.Ahmed, Saladin.Crescent Moon Kingdoms ;bk. 1.=852 4\gaaagplYCL-RHYCL-RHAdult FictionFIC 691691biblio'), +(:bib_tag,'01540nam a22003254a 4500684CONS20130416180316.0090420s2008 caua e 00 c eng d9781582406725 (pbk.)1582406723 (pbk.)(SC LENDS)1948733741.597322FIC - KIRGN - WALKING Kirkman, Robert.The walking dead.[Vol. 1]Days gone bye /Robert Kirkman, creator, writer, letterer ; Tony Moore, penciler, inker, gray tones ; Cliff Rathburn, additional gray tones].Days gone bye.Title on half title page:Image Comics presents the Walking dead.Orange, Calif. :Image Comics,c2008.1 v. (unpaged) :ill. ;26 cm.Police officer Rick Grimes is shot on the job and wakes up a month later to find that the world that he knows is gone. Zombies have taken over and are killing and eating those who are still alive. He sets out toward Atlanta in the hope that his family is still alive and endures may horrors along the way."Title, author and illustrators from cover."Originally published in single magazine format as the Walking dead, #1 - #6."...T.P. verso.ZombiesComic books, strips, etc.CannibalismComic books, strips, etc.Survival HorrorComic books, strips, etc.Post ApocalypticComic books, strips, etc.Horror comic books, strips, etc.gsafd.Comic books, strips, etc.gsafdGraphic novels.Moore, Tony.Rathburn, Cliff.Image Comics.684684biblio'), +(:bib_tag,'02002cam a2200481 a 4500693CONS20130416180042.0100402s2010 nyu 000 f eng20100138939780345497499 (hardcover : alk. paper)034549749X (hardcover : alk. paper)(SC LENDS)1520630e-uk-enPR6063.I265K73 2010823/.91422FIC - MiéMiéville, China.Kraken :an anatomy /China Miéville.1st ed.New York :Del Rey/Ballantine Books,c2010.1006509 p. ;25 cm.Being chased by cults, a maniac, and the sorcerers of the Fundamentalist and Sect-Related Crime Unit, cephalopod specialist Billy Harrow inadvertently learns that he holds the key to finding a missing squid that went missing against all logic.Museum curatorsEnglandFiction.Giant squidsFiction.MagicFiction.CephalapodsFiction.CultsFiction.Weird Fiction, English.Comedy, English.Fantasy fiction.693693biblio'), +(:bib_tag,'01872cjm a2200385 a 4500676CONS20130416175533.0940516s1994 nyumpn eng dsd zunznnmmneu9577384207567825192482519-2Atlantic(SC LENDS)1946843792.6 CROThe crow[sound recording] :original motion picture soundtrack.Music CDNew York :Atlantic Recording Corp.,p1994.1 sound disc :digital ;4 3/4 in.Various artists.Burn (the Cure) (6:39) -- Golgotha tenement blues (Machines of Loving Grace) (3:58) -- Big empty (Stone Temple Pilots) (4:55) -- Dead souls (Nine Inch Nails) (4:52) -- Darkness (Rage Against the Machine) (3:41) -- Color me once (Violent Femmes) (4:10) -- Ghostrider (Rollins Band) (5:44) -- Milktoast (Helmet) (3:59) -- The badge (Pantera) (3:53) -- Slip slide melting (For Love not Lisa) (5:45) -- After the flesh (My Life with the Thrill Kill Kult) (2:58) -- Snakedriver (the Jesus and Mary Chain) (3:39) -- Time baby III (Medicine) (3:50) -- It can''t rain all the time (Jane Siberry) (5:34).Motion picture music.Industrial music1991-2000.Grunge music1991-2000.Crow (Motion picture)676676biblio'), +(:bib_tag,'00456cam a2200181 a 4500675CONS20130416175204.0000515s1982 nyua 000 1 eng d0451115082(SCLENDS)656898FIC BACFIC/BACBachman, Richard.The running man /Richard Bachman.New York :Signet Book,c1982.219 p.Stephen King (writing as Richard Bachman) crafted The Running Man early in his career, though after such mega-hits as Carrie and The Shining. A bit of a departure from the supernatural horror that is most frequently associated with his work, the novel describes a science fiction dystopia where market capitalism and television game shows have spiraled out of control, and the separation between the haves and the have-nots has been formalized with separate currencies. King establishes characters quickly, creating sympathy in the first few pages for Ben Richards--whose 18-month-old baby girl is suffering from a horrible cough, perhaps pneumonia. Not able to afford medicine, Richards enters himself in the last-chance money-making scheme of the Free-Vee games. The games include Treadmill to Bucks, in which heart-attack prone contestants struggle to outlast a progressively demanding treadmill, or the accurately named Swim the Crocodiles. After a rigorous battery of physical and mental examinations, Richards is assigned "Elevator Six"--the path of a chosen few--that leads to The Running Man game. In this game, the stakes and the prizes are raised. Success means a life of luxury. Failure means death. Unfortunately, few ever win the game; in fact, as the producer tells Richards, in six years no one has survived.Horror tales, American.Adventure stories.Horror stories.King, Stephen.675675biblio') +; diff --git a/Open-ILS/tests/datasets/sql/load_all.sql b/Open-ILS/tests/datasets/sql/load_all.sql index feeae28266..4d051fa612 100644 --- a/Open-ILS/tests/datasets/sql/load_all.sql +++ b/Open-ILS/tests/datasets/sql/load_all.sql @@ -21,6 +21,9 @@ BEGIN; -- load graphic 880 field bibs \i bibs_graphic_880.sql +-- load fiction bibs +\i bibs_fic.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; @@ -34,6 +37,9 @@ INSERT INTO biblio.record_entry (marc, last_xact_id) -- load graphic 880 field copies, etc \i assets_graphic_880.sql +-- load fiction copies, etc. +\i assets_fic.sql + -- load sample patrons \i users_patrons_100.sql -- 2.43.2