books.sql

DROP TABLE IF EXISTS books;

CREATE TABLE books (
  id SERIAL PRIMARY KEY,
  title VARCHAR(255),
  author VARCHAR(255),
  isbn VARCHAR(255),
  image_url VARCHAR(255),
  description TEXT,
  bookshelf VARCHAR(255)
);

INSERT INTO books (title, author, isbn, image_url, description, bookshelf) VALUES (
  'Dune',
  'Frank Herbert',
  'ISBN_13 9780441013593',
  'http://books.google.com/books/content?id=B1hSG45JCX4C&printsec=frontcover&img=1&zoom=5&edge=curl&source=gbs_api',
  'Follows the adventures of Paul Atreides, the son of a betrayed duke given up for dead on a treacherous desert planet and adopted by its fierce, nomadic people, who help him unravel his most unexpected destiny.',
  'Fantasy'
);

INSERT INTO books (title, author, isbn, image_url, description, bookshelf) VALUES (
  'What Alice Forgot',
  'Liane Moriarty',
  'ISBN_13 1101515376',
  'http://books.google.com/books/content?id=8iBGzeqj45YC&printsec=frontcover&img=1&zoom=5&edge=curl&source=gbs_api',
  'Alice Love is twenty-nine, crazy about her husband, and pregnant with her first child. So imagine Alice''s surprise when she comes to on the floor of a gym (a gym! She HATES the gym) and is whisked off to the hospital where she discovers the honeymoon is truly over—she''s getting divorced, she has three kids, and she''s actually 39 years old. Alice must reconstruct the events of a lost decade, and find out whether it''s possible to reconstruct her life at the same time. She has to figure out why her sister hardly talks to her, and how is it that she''s become one of those super skinny moms with really expensive clothes. Ultimately, Alice must discover whether forgetting is a blessing or a curse, and whether it''s possible to start over...',
  'Fiction'
);

INSERT INTO books (title, author, isbn, image_url, description, bookshelf) VALUES (
  'Unsouled',
  'Will Wight',
  'ISBN_13 9780989671767',
  'http://books.google.com/books/content?id=OjYJtAEACAAJ&printsec=frontcover&img=1&zoom=5&source=gbs_api',
  'Sacred artists follow a thousand Paths to power, using their souls to control the forces of the natural world. Lindon is Unsouled, forbidden to learn the sacred arts of his clan. When faced with a looming fate he cannot ignore, he must rise beyond anything he''s ever known...and forge his own Path.',
  'SciFi'
);

INSERT INTO books (title, author, isbn, image_url, description, bookshelf) VALUES (
  'The Stand',
  'Stephen King',
  'ISBN_13 9780385528856',
  'http://books.google.com/books/content?id=UbfnTcmkaKkC&printsec=frontcover&img=1&zoom=5&edge=curl&source=gbs_api',
  'Stephen King''s apocalyptic vision of a world blasted by plague and tangled in an elemental struggle between good and evil remains as riveting and eerily plausible as when it was first published. A patient escapes from a biological testing facility, unknowingly carrying a deadly weapon: a mutated strain of super-flu that will wipe out 99 percent of the world''s population within a few weeks. Those who remain are scared, bewildered, and in need of a leader. Two emerge—Mother Abagail, the benevolent 108-year-old woman who urges them to build a peaceful community in Boulder, Colorado; and Randall Flagg, the nefarious "Dark Man," who delights in chaos and violence. As the dark man and the peaceful woman gather power, the survivors will have to choose between them—and ultimately decide the fate of all humanity.',
  'Drama'
);

INSERT INTO books (title, author, isbn, image_url, description, bookshelf) VALUES (
  'Sweet Thursday',
  'John Steinbeck',
  'ISBN_13 978144063549',
  'http://books.google.com/books/content?id=zer-bEoDL-EC&printsec=frontcover&img=1&zoom=5&edge=curl&source=gbs_api',
  'In Monterey, on the California coast, Sweet Thursday is what they call the day after Lousy Wednesday, which is one of those days that are just naturally bad. Returning to the scene of Cannery Row—the weedy lots and junk heaps and flophouses of Monterey, John Steinbeck once more brings to life the denizens of a netherworld of laughter and tears—from Doc, based on Steinbeck''s lifelong friend Ed Ricketts, to Fauna, new headmistress of the local brothel, to Hazel, a bum whose mother must have wanted a daughter. This Penguin Classics edition features an introduction and notes by Robert DeMott. For more than seventy years, Penguin has been the leading publisher of classic literature in the English-speaking world. With more than 1,700 titles, Penguin Classics represents a global bookbookshelf of the best works throughout history and across genres and disciplines. Readers trust the series to provide authoritative texts enhanced by introductions and notes by distinguished scholars and contemporary authors, as well as up-to-date translations by award-winning translators. From the Trade Paperback edition.',
  'Classics'
);

INSERT INTO books (title, author, isbn, image_url, description, bookshelf) VALUES (
  'The New Jim Crow',
  'Michelle Alexander',
  'ISBN_13 9781595588197',
  'http://books.google.com/books/content?id=reDzBZ3pXqsC&printsec=frontcover&img=1&zoom=5&edge=curl&source=gbs_api',
  'Once in a great while a book comes along that changes the way we see the world and helps to fuel a nationwide social movement. The New Jim Crow is such a book. Praised by Harvard Law professor Lani Guinier as "brave and bold,"" this book directly challenges the notion that the election of Barack Obama signals a new era of colorblindness. With dazzling candor, legal scholar Michelle Alexander argues that "we have not ended racial caste in America; we have merely redesigned it." By targeting black men through the War on Drugs and decimating communities of color, the U.S. criminal justice system functions as a contemporary system of racial control—relegating millions to a permanent second-class status—even as it formally adheres to the principle of colorblindness. In the words of Benjamin Todd Jealous, president and CEO of the NAACP, this book is a "call to action." Called "stunning" by Pulitzer Prize–winning historian David Levering Lewis, "invaluable" by the Daily Kos, "explosive" by Kirkus, and "profoundly necessary" by the Miami Herald, this updated and revised paperback edition of The New Jim Crow, now with a foreword by Cornel West, is a must-read for all people of conscience.',
  'Culture'
);

INSERT INTO books (title, author, isbn, image_url, description, bookshelf) VALUES (
  'The Boys in the Boat',
  'Daniel James Brown',
  'ISBN_13 9781101622742',
  'http://books.google.com/books/content?id=2p3YPpiA2pEC&printsec=frontcover&img=1&zoom=5&edge=curl&source=gbs_api',
  'For readers of Unbroken, out of the depths of the Depression comes an irresistible story about beating the odds and finding hope in the most desperate of times—the improbable, intimate account of how nine working-class boys from the American West showed the world at the 1936 Olympics in Berlin what true grit really meant. It was an unlikely quest from the start. With a team composed of the sons of loggers, shipyard workers, and farmers, the University of Washington''s eight-oar crew team was never expected to defeat the elite teams of the East Coast and Great Britain, yet they did, going on to shock the world by defeating the German team rowing for Adolf Hitler. The emotional heart of the tale lies with Joe Rantz, a teenager without family or prospects, who rows not only to regain his shattered self-regard but also to find a real place for himself in the world. Drawing on the boys'' own journals and vivid memories of a once-in-a-lifetime shared dream, Brown has created an unforgettable portrait of an era, a celebration of a remarkable achievement, and a chronicle of one extraordinary young man''s personal quest. From the Trade Paperback edition.',
  'Inspirational'
);

INSERT INTO books (title, author, isbn, image_url, description, bookshelf) VALUES (
  'The Fellowship of the Ring',
  'John Ronald Reuel Tolkien',
  'ISBN_13 9780007522903',
  'http://books.google.com/books/content?id=f3q6mwEACAAJ&printsec=frontcover&img=1&zoom=5&source=gbs_api',
  'When they were first published, THE HOBBIT and THE LORD OF THE RINGS became instant classics. Treasured by readers young and old, these works of sweeping fantasy, steeped in unrivalled magic and otherworldliness have sold more than 150 million copies around the world. This new boxed set contains both titles and features brand new cover designs. It offers readers a new opportunity to discover Tolkien''s remarkable world of Middle-earth and to follow the complete story of Bilbo Baggins and the Hobbits'' part in the epic quest for the Ring beginning with Bilbo''s fateful visit from Gandalf and culminating in the dramatic climax between Frodo and Gollum atop Mount Doom.',
  'Fantasy'
);

INSERT INTO books (title, author, isbn, image_url, description, bookshelf) VALUES (
  'Animal Farm',
  'George Orwell',
  'ISBN_13 9780573605383',
  'http://books.google.com/books/content?id=T0L2nUOPUqAC&printsec=frontcover&img=1&zoom=5&edge=curl&source=gbs_api',
  'Animal Farm is a fable with a sting. Millions of words have been written about the threat of Totalitarianism, but it remained to the late George Orwell, farsighted British author of the brilliant and frightening 1984, to expose the Russian experiment for what it really is: an idealist''s dream, converted by realists into a nightmare. In Nelson Bond''s simple staged dramatic reading version of this timely allegory you will meet beasts whose prototypes have dominated news headlines for a half hundred fearful years. Opening on a note of joyous triumph for the creatures who have emancipated themselves from the cruel mastery of a human owner, the reading mounts inexorably to a climax of disillusionment in which the other animals discover themselves now subject to the rule of even more ruthless autocrats: the greedy, cunning pigs.',
  'Satire'
);

INSERT INTO books (title, author, isbn, image_url, description, bookshelf) VALUES (
  'The Great Gatsby',
  'Francis Scott Fitzgerald',
  'ISBN_13 9786050418156',
  'http://books.google.com/books/content?id=meVxCwAAQBAJ&printsec=frontcover&img=1&zoom=5&source=gbs_api',
  'The main events of the novel take place in the summer of 1922. Nick Carraway, a Yale graduate and World War I veteran from the Midwest – who serves as the novel''s narrator – takes a job in New York as a bond salesman. He rents a small house on Long Island, in the (fictional) village of West Egg, next door to the lavish mansion of Jay Gatsby, a mysterious millionaire who holds extravagant parties but does not participate in them. Nick drives around the bay to East Egg for dinner at the home of his cousin, Daisy Fay Buchanan, and her husband, Tom, a college acquaintance of Nick''s. They introduce Nick to Jordan Baker, an attractive, cynical young golfer with whom Nick begins a romantic relationship. She reveals to Nick that Tom has a mistress, Myrtle Wilson, who lives in the "valley of ashes": an industrial dumping ground between West Egg and New York City. Not long after this revelation, Nick travels to New York City with Tom and Myrtle to an apartment they keep for their affair. At the apartment, a vulgar and bizarre party takes place. It ends with Tom breaking Myrtle''s nose after she annoys him by saying Daisy''s name several times.',
  'Classics'
);