Spaces:
Paused
Paused
File size: 2,028 Bytes
ad6916c | 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 | #!/usr/bin/env python3
"""
Promote an existing user to admin by email.
Uses DATABASE_URL from the environment (same as the API).
Usage (from repo root):
python scripts/set_admin.py your@email.com
On Railway (API service, with Postgres linked):
railway run python scripts/set_admin.py your@email.com
Alternative (from backend/):
python -m app.cli.promote_admin --email your@email.com
"""
from __future__ import annotations
import asyncio
import sys
from pathlib import Path
# Allow `import app` when run from repo root
_BACKEND = Path(__file__).resolve().parent.parent / "backend"
if str(_BACKEND) not in sys.path:
sys.path.insert(0, str(_BACKEND))
from sqlalchemy import func, select
from app.db.database import AsyncSessionLocal
from app.db.models import User
async def set_admin(email: str) -> int:
normalized = email.strip().lower()
if not normalized:
print("Error: email is required.", file=sys.stderr)
return 1
async with AsyncSessionLocal() as db:
try:
result = await db.execute(
select(User).where(func.lower(User.email) == normalized)
)
user = result.scalar_one_or_none()
if not user:
print(f"Error: no user found with email {normalized}", file=sys.stderr)
return 1
if user.role == "admin":
print(f"OK: {normalized} is already admin (id={user.id}).")
return 0
user.role = "admin"
await db.commit()
print(f"Success: promoted user id={user.id} ({normalized}) to admin.")
return 0
except Exception as exc:
await db.rollback()
print(f"Error: {exc}", file=sys.stderr)
return 1
def main() -> None:
if len(sys.argv) != 2:
print("Usage: python scripts/set_admin.py <email>", file=sys.stderr)
raise SystemExit(1)
raise SystemExit(asyncio.run(set_admin(sys.argv[1])))
if __name__ == "__main__":
main()
|