import os
import sqlite3
from werkzeug.security import generate_password_hash

BASE_DIR = os.path.abspath(os.path.dirname(__file__))
DB_PATH = os.path.join(BASE_DIR, "users.db")

name = input("Nombre: ").strip()
email = input("Correo: ").strip()
password = input("Contraseña temporal: ").strip()
role = input("Rol [default=secos]: ").strip() or "secos"
status = input("Estado [active/inactive, default=active]: ").strip() or "active"

password_hash = generate_password_hash(password)

conn = sqlite3.connect(DB_PATH)
cur = conn.cursor()

try:
    cur.execute("""
        INSERT INTO users (name, email, password_hash, role, status)
        VALUES (?, ?, ?, ?, ?)
    """, (name, email, password_hash, role, status))
    conn.commit()
    print(f"Usuario creado correctamente: {email}")
except sqlite3.IntegrityError:
    print("Error: ya existe un usuario con ese correo.")
finally:
    conn.close()