models.py

from datetime import datetime
from uuid import UUID

from sqlalchemy import func, Column, Uuid, ForeignKey, JSON
from sqlalchemy.orm import Mapped, mapped_column
from sqlalchemy.types import ARRAY
from sqlalchemy.orm import relationship

from db import Base


class User(Base):
    __tablename__ = 'users'

    id: Mapped[int] = mapped_column(primary_key=True, index=True)
    user_id: Mapped[UUID] = mapped_column(unique=True)
    found_at: Mapped[datetime] = mapped_column(server_default=func.now())
    updated_at: Mapped[datetime] = mapped_column(server_default=func.now(), onupdate=func.now())

    created_at: Mapped[datetime] = mapped_column(nullable=True)
    username: Mapped[str] = mapped_column(unique=True)
    display_name: Mapped[str]
    followers: Mapped[int]
    following: Mapped[int]
    posts: Mapped[int]
    verified: Mapped[bool]
    has_itdp: Mapped[bool] = mapped_column(default=False)
    following_users: Mapped[str]
    followed_by_users: Mapped[str]
    # following_users = Column(ARRAY(Uuid), default=[]) # brooo why i cant just mapped[list[UUID]] so stupid arrays
    # followed_by_users = Column(ARRAY(Uuid), default=[])
    avatar: Mapped[str] = mapped_column(default='?')
    exists: Mapped[bool] = mapped_column(default=True)


# class Post(Base):
#     __tablename__ = 'posts'

#     id: Mapped[int] = mapped_column(primary_key=True, index=True)
#     post_id: Mapped[UUID] = mapped_column(unique=True)
#     found_at: Mapped[datetime] = mapped_column(server_default=func.now())

#     created_at: Mapped[datetime] = mapped_column(nullable=True)
#     author_id = ForeignKey('users.id')
#     content: Mapped[str]
#     spans = Column(ARRAY(JSON))

#     author = relationship('User', foreign_keys='User.id', back_populates='posts')