|
|
""" |
|
|
User model for authentication and profile. |
|
|
""" |
|
|
from datetime import datetime |
|
|
from typing import Optional |
|
|
from uuid import UUID, uuid4 |
|
|
|
|
|
from sqlmodel import Column, DateTime, Field, SQLModel |
|
|
from sqlalchemy import text |
|
|
|
|
|
|
|
|
class User(SQLModel, table=True): |
|
|
""" |
|
|
User model representing application users. |
|
|
|
|
|
Attributes: |
|
|
id: Unique user identifier (UUID) |
|
|
name: User's full name |
|
|
email: User's email address (unique) |
|
|
password_hash: Bcrypt hashed password |
|
|
avatar_url: Optional Cloudinary avatar URL |
|
|
created_at: Account creation timestamp |
|
|
updated_at: Last update timestamp |
|
|
""" |
|
|
|
|
|
__tablename__ = 'users' |
|
|
|
|
|
id: UUID = Field( |
|
|
default_factory=uuid4, |
|
|
primary_key=True, |
|
|
index=True, |
|
|
description='Unique user identifier', |
|
|
) |
|
|
name: str = Field(max_length=255, description="User's full name") |
|
|
email: str = Field( |
|
|
unique=True, |
|
|
index=True, |
|
|
max_length=255, |
|
|
description="User's email address", |
|
|
) |
|
|
password_hash: str = Field(max_length=255, description='Bcrypt hashed password', exclude=True) |
|
|
avatar_url: Optional[str] = Field( |
|
|
default=None, max_length=500, description='Cloudinary avatar URL' |
|
|
) |
|
|
created_at: datetime = Field( |
|
|
default_factory=datetime.utcnow, |
|
|
sa_column=Column(DateTime(), server_default=text('CURRENT_TIMESTAMP')), |
|
|
description='Account creation timestamp', |
|
|
) |
|
|
updated_at: datetime = Field( |
|
|
default_factory=datetime.utcnow, |
|
|
sa_column=Column( |
|
|
DateTime(), |
|
|
server_default=text('CURRENT_TIMESTAMP'), |
|
|
onupdate=text('CURRENT_TIMESTAMP'), |
|
|
), |
|
|
description='Last update timestamp', |
|
|
) |
|
|
|
|
|
def __repr__(self) -> str: |
|
|
return f'<User {self.email}>' |
|
|
|
|
|
|
|
|
|
|
|
__all__ = ['User'] |
|
|
|
