# @/crud/user.py from sqlalchemy import select, exists, func from sqlalchemy.orm import Session from sqlalchemy.exc import IntegrityError from models.user import User from exceptions import UserNotFoundError, UserAlreadyExistsError from auth.security import hash_password def get_users(db: Session) -> list[User]: stmt = select(User) users = db.scalars(stmt).all() if not users: raise UserNotFoundError(f"No users in Database") return users def get_user_by_id(db: Session, user_id: int) -> User: stmt = select(User).where(User.id == user_id) user = db.scalars(stmt).first() if user is None: raise UserNotFoundError(f"User with id: {user_id} not found") return user def get_user_by_email(db: Session, email: str) -> User: stmt = select(User).where(func.lower(User.email) == func.lower(email)) user = db.scalars(stmt).first() if user is None: raise UserNotFoundError(f"User with email: {email} not found") return user def create_user(db: Session, email: str, password: str, role: bool = "user") -> User: hashed = hash_password(password) user = User(email=email, password=hashed, role=role) try: db.add(user) db.commit() db.refresh(user) return user except IntegrityError as err: db.rollback() raise UserAlreadyExistsError(f"User with email: '{email}' already exists") from err def update_user(db: Session, user_id: int, user_data: dict) -> User: user = get_user_by_id(db, user_id) if not user: raise UserNotFoundError(f"User with ID {user_id} not found") # Passwort hashen, falls es im Update enthalten ist if "password" in user_data and user_data["password"] is not None: user_data["password"] = hash_password(user_data.pop("password")) # Nur die mitgeschickten Felder auf dem Objekt setzen for field, value in user_data.items(): setattr(user, field, value) try: db.commit() db.refresh(user) return user except IntegrityError as err: db.rollback() raise UserAlreadyExistsError("Email is already in use") from err def delete_user(db: Session, user_id: int) -> User: user = get_user_by_id(db, user_id) if user is None: raise UserNotFoundError(f"User with id: {user_id} not found") db.delete(user) db.commit() return user