reset_admin.py

import sqlite3
from werkzeug.security import generate_password_hash
import os

def reset_admin_password():
    db_path = os.path.join(os.path.dirname(__file__), 'placement.db')
    if not os.path.exists(db_path):
        print("Database not found.")
        return

    new_password = input("Enter new admin password: ").strip()
    if not new_password:
        print("Password cannot be empty.")
        return

    conn = sqlite3.connect(db_path)
    cur = conn.cursor()
    
    hashed = generate_password_hash(new_password)
    cur.execute("UPDATE admin SET password = ? WHERE username = 'admin'", (hashed,))
    conn.commit()
    conn.close()
    
    print("Admin password successfully reset.")

if __name__ == "__main__":
    reset_admin_password()