Library_app.py

import sqlite3

# Connect to the database (or create it if it doesn't exist)
conn = sqlite3.connect("Library.db")
cursor = conn.cursor()

# Create the table for storing book information
cursor.execute("""
CREATE TABLE IF NOT EXISTS books (
    id INTEGER PRIMARY KEY AUTOINCREMENT,
    title TEXT,
    author TEXT,
    price REAL,
    stock INTEGER
)
""")

# Insert your books into the table
cursor.execute("DELETE FROM books")
cursor.executemany("""
INSERT INTO books (title, author, price, stock)
VALUES (?, ?, ?, ?)
""", [
    ("Negative Self-Talk", "Shad Helmstetter", 15.5, 10),
    ("How The Secret Changed My Life", "Rhonda Byrne", 12.0, 6),
    ("The Little Prince", "Antoine de Saint-Exupéry", 9.8, 23)
])

# Commit the changes
conn.commit()

# Code for reading and displaying data
cursor.execute("SELECT * FROM books")
rows = cursor.fetchall()

for row in rows:
    print(row)

# close the connection

conn.close()