makingdb.py

import sqlite3


def create_books():
    
    con = sqlite3.connect('database.db')
    con.execute('CREATE TABLE books(isbn INT PRIMARY KEY,name TEXT, retail_price REAL, date TEXT, trade_price REAL, author TEXT, description TEXT, quantity INT,image TEXT )')
    
    con.close()
    
    con = sqlite3.connect('database.db')
    
    
    con.execute("INSERT INTO books values(?,?,?,?,?,?,?,?,?);",('1', 'The BFG', '25.99', '1982', '30.00', 'Roald Dahls', 'A young girl, Sophie, befriends a giant, who is an outcast because, unlike others of his kind, he refuses to hurt humans. However, things change after the other giants decide to hunt down Sophie.', '5', 'book-cover/bfg.jpg'))
    con.execute("INSERT INTO books values(?,?,?,?,?,?,?,?,?);",('2', 'Harry Potter and the Chamber of secrets', '25.99', '1998', '34.99', 'J.K. Rowling', 'Harry Potters summer has included the worst birthday ever, doomy warnings from a house-elf called Dobby, and rescue from the Dursleys by his friend Ron Weasley in a magical flying car! Back at Hogwarts School of Witchcraft and Wizardry for his second year, Harry hears strange whispers echo through empty corridors - and then the attacks start. Students are found as though turned to stone... Dobbys sinister predictions seem to be coming true.', '10', 'book-cover/chamber-of-secrets.jpg'))
    con.execute("INSERT INTO books values(?,?,?,?,?,?,?,?,?);",('3', 'Harry Potter and the half blood prince', '25.99', '2005', '34.99', 'J.K. Rowling', 'When Dumbledore arrives at Privet Drive one summer night to collect Harry Potter, his wand hand is blackened and shrivelled, but he does not reveal why.', '8', 'book-cover/half-blood-prince.jpg'))
    con.execute("INSERT INTO books values(?,?,?,?,?,?,?,?,?);",('4', 'Harry Potter and the Philosopher Stone', '25.99', '1997', '34.99', 'J.K. Rowling', 'Harry Potter is a wizard, and he has a place at Hogwarts School of Witchcraft and Wizardry. An incredible adventure is about to begin! ', '2', 'book-cover/philosopher-stone.jpg'))
    con.execute("INSERT INTO books values(?,?,?,?,?,?,?,?,?);",('5', 'Harry Potter and the Deathly Hallows', '25.99', '2007', '34.99', 'J.K. Rowling', 'The Dark Lord is breathing fear into everything Harry loves and to stop him Harry will have to find and destroy the remaining Horcruxes. The final battle must begin - Harry must stand and face his enemy....  ', '10', 'book-cover/deathly-hallows.jpg'))
    con.execute("INSERT INTO books values(?,?,?,?,?,?,?,?,?);",('6', 'Lord of the Rings', '29.99', '1954', '44.99', 'J. R. R. Tolkien', 'Sauron, the Dark Lord, has gathered to him all the Rings of Power - the means by which he intends to rule Middle-earth. All he lacks in his plans for dominion is the One Ring - the ring that rules them all - which has fallen into the hands of the hobbit, Bilbo Baggins. ', '3', 'book-cover/lord-of-the-rings.jpg'))
    con.execute("INSERT INTO books values(?,?,?,?,?,?,?,?,?);",('7', 'Golden Compass', '4.99', '1995', '9.99', 'Philip Pullman', 'Lyra Belacqua is a young orphan who journeys to the far North, accompanied by Gyptians and an armoured bear. She is on a mission to rescue her best friend and other kidnapped children. ', '7', 'book-cover/golden-compass.jpg'))
    con.execute("INSERT INTO books values(?,?,?,?,?,?,?,?,?);",('8', 'Charlie and the chocolate factory', '7.99', '1971', '11.99', 'Roald Dahls', 'A factory owner gives 5 children a chance to win a lifetime supply of sweets. Charlie, along with four odious children enter the factory. Disasters befall each of the children. Will Charlie survive? ', '8', 'book-cover/charlie.jpg'))
    con.execute("INSERT INTO books values(?,?,?,?,?,?,?,?,?);",('9', 'Fantastic Mr Fox', '7.99', '1970', '9.99', 'Roald Dahls', 'Now the farmers have hatched a plan to BANG-BANG-BANG shoot Mr Fox dead! But, just when they think Mr Fox cant possibly escape, he makes a FANTASTIC plan of his own . . . ', '1', 'book-cover/fox.jpg'))
    con.execute("INSERT INTO books values(?,?,?,?,?,?,?,?,?);",('10', 'Matilda', '5.99', '1988', '7.99', 'Roald Dahls', 'She immediately shows amazing precocity, learning to speak at age one and to read at age three and a half, perusing all the childrens books in the library by the age of four and three months and moving on to longer classics such as Great Expectations and Jane Eyre.', '1', 'book-cover/matilda.jpg'))
    


    con.commit()
    con.close()

create_books()