HWexpencetracker.py

import sqlite3

conn = sqlite3.connect("expenses.db")
c = conn.cursor()

c.execute("""
CREATE TABLE IF NOT EXISTS expenses (
    id INTEGER PRIMARY KEY AUTOINCREMENT,
    name TEXT,
    date TEXT,
    amount REAL
)
""")
conn.commit()

def add_expense():
    name = input("Enter expense name: ")
    date = input("Enter expense date (dd-mm-yyyy): ")
    amount = float(input("Enter expense amount: "))

    c.execute("INSERT INTO expenses (name, date, amount) VALUES (?, ?, ?)",
              (name, date, amount))
    conn.commit()
    print("✅ Expense added successfully!")

def view_expenses():
    c.execute("SELECT * FROM expenses")
    rows = c.fetchall()
    if not rows:
        print("No expenses found!")
    else:
        print("\n All Expenses ")
        for row in rows:
            print(f"ID: {row[0]}, Name: {row[1]}, Date: {row[2]}, Amount: {row[3]}")
        print("\n")

def total_expenses():
    c.execute("SELECT SUM(amount) FROM expenses")
    total = c.fetchone()[0]
    if total is None:
        total = 0
    print(f"\n Total Expenses: {total}\n")
def main():
    while True:
        print("\n Expense Tracker ")
        print("1. Add Expense")
        print("2. View Expenses")
        print("3. Show Total Expenses")
        print("4. Exit")

        choice = input("Enter your choice: ")

        if choice == "1":
            add_expense()
        elif choice == "2":
            view_expenses()
        elif choice == "3":
            total_expenses()
        elif choice == "4":
            print("Exiting... Goodbye! 👋")
            break
        else:
            print("Invalid choice! Please try again.")

    conn.close()
if __name__ == "__main__":
    main()