import mysql.connector
 
# Connect to the MySQL database
def connect_to_db():
    return mysql.connector.connect(
        host="localhost",  # Change this to your database host
        user="root",       # Change to your MySQL username
        password="password",  # Change to your MySQL password
        database="todo_db"    # The name of your database
    )
 
# Create the database and table
def setup_database():
    conn = connect_to_db()
    cursor = conn.cursor()
    cursor.execute("CREATE DATABASE IF NOT EXISTS todo_db")
    cursor.execute("USE todo_db")
    cursor.execute("""
        CREATE TABLE IF NOT EXISTS tasks (
            id INT AUTO_INCREMENT PRIMARY KEY,
            task VARCHAR(255),
            status VARCHAR(50)
        )
    """)
    conn.commit()
    conn.close()
 
# Add a task
def add_task(task, status="Pending"):
    conn = connect_to_db()
    cursor = conn.cursor()
    cursor.execute("INSERT INTO tasks (task, status) VALUES (%s, %s)", (task, status))
    conn.commit()
    conn.close()
    print("Task added successfully!")
 
# View all tasks
def view_tasks():
    conn = connect_to_db()
    cursor = conn.cursor()
    cursor.execute("SELECT * FROM tasks")
    tasks = cursor.fetchall()
    conn.close()
    print("\nTo-Do List:")
    for task in tasks:
        print(f"ID: {task[0]}, Task: {task[1]}, Status: {task[2]}")
 
# Update a task's status
def update_task_status(task_id, status):
    conn = connect_to_db()
    cursor = conn.cursor()
    cursor.execute("UPDATE tasks SET status = %s WHERE id = %s", (status, task_id))
    conn.commit()
    conn.close()
    print("Task updated successfully!")
 
# Delete a task
def delete_task(task_id):
    conn = connect_to_db()
    cursor = conn.cursor()
    cursor.execute("DELETE FROM tasks WHERE id = %s", (task_id,))
    conn.commit()
    conn.close()
    print("Task deleted successfully!")
 
# Main menu
def main_menu():
    setup_database()
    while True:
        print("\nTo-Do List Menu:")
        print("1. Add Task")
        print("2. View Tasks")
        print("3. Update Task Status")
        print("4. Delete Task")
        print("5. Exit")
 
        choice = input("Enter your choice: ")
 
        if choice == "1":
            task = input("Enter the task: ")
            add_task(task)
        elif choice == "2":
            view_tasks()
        elif choice == "3":
            task_id = int(input("Enter task ID to update: "))
            status = input("Enter new status (Pending/Completed): ")
            update_task_status(task_id, status)
        elif choice == "4":
            task_id = int(input("Enter task ID to delete: "))
            delete_task(task_id)
        elif choice == "5":
            print("Exiting To-Do List. Goodbye!")
            break
        else:
            print("Invalid choice. Please try again.")
 
# Run the application
if __name__ == "__main__":
    main_menu()

aW1wb3J0IG15c3FsLmNvbm5lY3RvcgoKIyBDb25uZWN0IHRvIHRoZSBNeVNRTCBkYXRhYmFzZQpkZWYgY29ubmVjdF90b19kYigpOgogICAgcmV0dXJuIG15c3FsLmNvbm5lY3Rvci5jb25uZWN0KAogICAgICAgIGhvc3Q9ImxvY2FsaG9zdCIsICAjIENoYW5nZSB0aGlzIHRvIHlvdXIgZGF0YWJhc2UgaG9zdAogICAgICAgIHVzZXI9InJvb3QiLCAgICAgICAjIENoYW5nZSB0byB5b3VyIE15U1FMIHVzZXJuYW1lCiAgICAgICAgcGFzc3dvcmQ9InBhc3N3b3JkIiwgICMgQ2hhbmdlIHRvIHlvdXIgTXlTUUwgcGFzc3dvcmQKICAgICAgICBkYXRhYmFzZT0idG9kb19kYiIgICAgIyBUaGUgbmFtZSBvZiB5b3VyIGRhdGFiYXNlCiAgICApCgojIENyZWF0ZSB0aGUgZGF0YWJhc2UgYW5kIHRhYmxlCmRlZiBzZXR1cF9kYXRhYmFzZSgpOgogICAgY29ubiA9IGNvbm5lY3RfdG9fZGIoKQogICAgY3Vyc29yID0gY29ubi5jdXJzb3IoKQogICAgY3Vyc29yLmV4ZWN1dGUoIkNSRUFURSBEQVRBQkFTRSBJRiBOT1QgRVhJU1RTIHRvZG9fZGIiKQogICAgY3Vyc29yLmV4ZWN1dGUoIlVTRSB0b2RvX2RiIikKICAgIGN1cnNvci5leGVjdXRlKCIiIgogICAgICAgIENSRUFURSBUQUJMRSBJRiBOT1QgRVhJU1RTIHRhc2tzICgKICAgICAgICAgICAgaWQgSU5UIEFVVE9fSU5DUkVNRU5UIFBSSU1BUlkgS0VZLAogICAgICAgICAgICB0YXNrIFZBUkNIQVIoMjU1KSwKICAgICAgICAgICAgc3RhdHVzIFZBUkNIQVIoNTApCiAgICAgICAgKQogICAgIiIiKQogICAgY29ubi5jb21taXQoKQogICAgY29ubi5jbG9zZSgpCgojIEFkZCBhIHRhc2sKZGVmIGFkZF90YXNrKHRhc2ssIHN0YXR1cz0iUGVuZGluZyIpOgogICAgY29ubiA9IGNvbm5lY3RfdG9fZGIoKQogICAgY3Vyc29yID0gY29ubi5jdXJzb3IoKQogICAgY3Vyc29yLmV4ZWN1dGUoIklOU0VSVCBJTlRPIHRhc2tzICh0YXNrLCBzdGF0dXMpIFZBTFVFUyAoJXMsICVzKSIsICh0YXNrLCBzdGF0dXMpKQogICAgY29ubi5jb21taXQoKQogICAgY29ubi5jbG9zZSgpCiAgICBwcmludCgiVGFzayBhZGRlZCBzdWNjZXNzZnVsbHkhIikKCiMgVmlldyBhbGwgdGFza3MKZGVmIHZpZXdfdGFza3MoKToKICAgIGNvbm4gPSBjb25uZWN0X3RvX2RiKCkKICAgIGN1cnNvciA9IGNvbm4uY3Vyc29yKCkKICAgIGN1cnNvci5leGVjdXRlKCJTRUxFQ1QgKiBGUk9NIHRhc2tzIikKICAgIHRhc2tzID0gY3Vyc29yLmZldGNoYWxsKCkKICAgIGNvbm4uY2xvc2UoKQogICAgcHJpbnQoIlxuVG8tRG8gTGlzdDoiKQogICAgZm9yIHRhc2sgaW4gdGFza3M6CiAgICAgICAgcHJpbnQoZiJJRDoge3Rhc2tbMF19LCBUYXNrOiB7dGFza1sxXX0sIFN0YXR1czoge3Rhc2tbMl19IikKCiMgVXBkYXRlIGEgdGFzaydzIHN0YXR1cwpkZWYgdXBkYXRlX3Rhc2tfc3RhdHVzKHRhc2tfaWQsIHN0YXR1cyk6CiAgICBjb25uID0gY29ubmVjdF90b19kYigpCiAgICBjdXJzb3IgPSBjb25uLmN1cnNvcigpCiAgICBjdXJzb3IuZXhlY3V0ZSgiVVBEQVRFIHRhc2tzIFNFVCBzdGF0dXMgPSAlcyBXSEVSRSBpZCA9ICVzIiwgKHN0YXR1cywgdGFza19pZCkpCiAgICBjb25uLmNvbW1pdCgpCiAgICBjb25uLmNsb3NlKCkKICAgIHByaW50KCJUYXNrIHVwZGF0ZWQgc3VjY2Vzc2Z1bGx5ISIpCgojIERlbGV0ZSBhIHRhc2sKZGVmIGRlbGV0ZV90YXNrKHRhc2tfaWQpOgogICAgY29ubiA9IGNvbm5lY3RfdG9fZGIoKQogICAgY3Vyc29yID0gY29ubi5jdXJzb3IoKQogICAgY3Vyc29yLmV4ZWN1dGUoIkRFTEVURSBGUk9NIHRhc2tzIFdIRVJFIGlkID0gJXMiLCAodGFza19pZCwpKQogICAgY29ubi5jb21taXQoKQogICAgY29ubi5jbG9zZSgpCiAgICBwcmludCgiVGFzayBkZWxldGVkIHN1Y2Nlc3NmdWxseSEiKQoKIyBNYWluIG1lbnUKZGVmIG1haW5fbWVudSgpOgogICAgc2V0dXBfZGF0YWJhc2UoKQogICAgd2hpbGUgVHJ1ZToKICAgICAgICBwcmludCgiXG5Uby1EbyBMaXN0IE1lbnU6IikKICAgICAgICBwcmludCgiMS4gQWRkIFRhc2siKQogICAgICAgIHByaW50KCIyLiBWaWV3IFRhc2tzIikKICAgICAgICBwcmludCgiMy4gVXBkYXRlIFRhc2sgU3RhdHVzIikKICAgICAgICBwcmludCgiNC4gRGVsZXRlIFRhc2siKQogICAgICAgIHByaW50KCI1LiBFeGl0IikKCiAgICAgICAgY2hvaWNlID0gaW5wdXQoIkVudGVyIHlvdXIgY2hvaWNlOiAiKQoKICAgICAgICBpZiBjaG9pY2UgPT0gIjEiOgogICAgICAgICAgICB0YXNrID0gaW5wdXQoIkVudGVyIHRoZSB0YXNrOiAiKQogICAgICAgICAgICBhZGRfdGFzayh0YXNrKQogICAgICAgIGVsaWYgY2hvaWNlID09ICIyIjoKICAgICAgICAgICAgdmlld190YXNrcygpCiAgICAgICAgZWxpZiBjaG9pY2UgPT0gIjMiOgogICAgICAgICAgICB0YXNrX2lkID0gaW50KGlucHV0KCJFbnRlciB0YXNrIElEIHRvIHVwZGF0ZTogIikpCiAgICAgICAgICAgIHN0YXR1cyA9IGlucHV0KCJFbnRlciBuZXcgc3RhdHVzIChQZW5kaW5nL0NvbXBsZXRlZCk6ICIpCiAgICAgICAgICAgIHVwZGF0ZV90YXNrX3N0YXR1cyh0YXNrX2lkLCBzdGF0dXMpCiAgICAgICAgZWxpZiBjaG9pY2UgPT0gIjQiOgogICAgICAgICAgICB0YXNrX2lkID0gaW50KGlucHV0KCJFbnRlciB0YXNrIElEIHRvIGRlbGV0ZTogIikpCiAgICAgICAgICAgIGRlbGV0ZV90YXNrKHRhc2tfaWQpCiAgICAgICAgZWxpZiBjaG9pY2UgPT0gIjUiOgogICAgICAgICAgICBwcmludCgiRXhpdGluZyBUby1EbyBMaXN0LiBHb29kYnllISIpCiAgICAgICAgICAgIGJyZWFrCiAgICAgICAgZWxzZToKICAgICAgICAgICAgcHJpbnQoIkludmFsaWQgY2hvaWNlLiBQbGVhc2UgdHJ5IGFnYWluLiIpCgojIFJ1biB0aGUgYXBwbGljYXRpb24KaWYgX19uYW1lX18gPT0gIl9fbWFpbl9fIjoKICAgIG1haW5fbWVudSgp