import sqlite3
import os

db_path = r'c:\Users\shera\Desktop\FYP Swiftcart\instance\swiftcart_cloud.db'

def reset_db():
    if not os.path.exists(db_path):
        print("Database not found!")
        return

    confirm = input("Are you sure you want to RESET all Products and Categories? (y/n): ")
    if confirm.lower() != 'y':
        print("Aborted.")
        return

    conn = sqlite3.connect(db_path)
    cursor = conn.cursor()

    try:
        # Clear main tables
        cursor.execute("DELETE FROM product")
        cursor.execute("DELETE FROM category")
        cursor.execute("DELETE FROM order_item")
        cursor.execute("DELETE FROM `order` ")
        
        conn.commit()
        print("Database Resetted Successfully! (Products, Categories, and Orders cleared)")
    except Exception as e:
        print(f"Error: {e}")
    finally:
        conn.close()

if __name__ == "__main__":
    reset_db()