#!/usr/bin/env python3

"""

CLI helper to create users in SQLite (bypasses Streamlit UI).

Example:

ENV=development python scripts/create_user.py \\

--username admin --email admin@example.com --name "Admin" --password secret

"""

from __future__ import annotations

import argparse

import sys

from pathlib import Path

# Allow running from repo root

sys.path.insert(0, str(Path(__file__).resolve().parent.parent))

from auth.auth_handler import hash_password

from database import db_manager

from utils.encryption import ensure_development_key_file

import config

def main() -> int:

parser = argparse.ArgumentParser(description="Create a user in the SQLite database.")

parser.add_argument("--username", required=True)

parser.add_argument("--email", required=True)

parser.add_argument("--name", required=True)

parser.add_argument("--password", required=True)

args = parser.parse_args()

if config.IS_DEVELOPMENT:

ensure_development_key_file()

if db_manager.username_exists(args.username):

print(f"User already exists: {args.username}", file=sys.stderr)

return 1

user = db_manager.create_user(

username=args.username,

email=args.email,

name=args.name,

password_hash=hash_password(args.password),

)

print(f"Created user_id={user.user_id} username={user.username}")

return 0

if __name__ == "__main__":

raise SystemExit(main())