Python for Pharmacy Technicians

import sqlite3

# Connect to SQLite database
conn = sqlite3.connect("pharmacy.db")
cursor = conn.cursor()

cursor.execute("""
CREATE TABLE IF NOT EXISTS medicines (
    id INTEGER PRIMARY KEY AUTOINCREMENT,
    name TEXT NOT NULL,
    quantity INTEGER NOT NULL,
    price REAL NOT NULL
)""")
conn.commit()

def add_medicine(name, quantity, price):
    cursor.execute(
        "INSERT INTO medicines VALUES (?,?,?)",
        (name, quantity, price))
    conn.commit()
    print(f"✅ Added {name}")

def update_quantity(name, quantity):
    cursor.execute(
        "UPDATE medicines SET quantity=? WHERE name=?",
        (quantity, name))
    print(f"🔄 Updated {name}")

def list_medicines():
    cursor.execute("SELECT * FROM medicines")
    for row in cursor.fetchall():
        print(f"{row[1]}: {row[2]} @ ${row[3]:.2f}")

if __name__ == "__main__":
    add_medicine("Paracetamol", 50, 0.25)
    add_medicine("Amoxicillin", 30, 0.50)
    update_quantity("Paracetamol", 45)
    list_medicines()

conn.close()