Backend / model.py
AhmedKing241's picture
Upload 17 files
2d11463 verified
Raw History Blame Contribute Delete
1.7 kB
from sqlalchemy import Column, String, Boolean, DateTime, ForeignKey, Text
from sqlalchemy.orm import relationship
from database import Base
from datetime import datetime, timezone
import uuid
# User model
class User(Base):
__tablename__ = "users"
id = Column(String, primary_key=True, default=lambda: str(uuid.uuid4()))
username = Column(String(50), unique=True, index=True, nullable=False)
email = Column(String(120), unique=True, index=True, nullable=False)
hashed_password = Column(String(255), nullable=False)
is_online = Column(Boolean, default=False)
last_seen = Column(DateTime)
# Optional: relationship to messages
sent_messages = relationship("Message", back_populates="sender", foreign_keys='Message.sender_id')
received_messages = relationship("Message", back_populates="receiver", foreign_keys='Message.receiver_id')
# Message model
class Message(Base):
__tablename__ = "messages"
id = Column(String, primary_key=True, default=lambda: str(uuid.uuid4()))
sender_id = Column(String, ForeignKey("users.id"), nullable=False, index=True)
receiver_id = Column(String, ForeignKey("users.id"), nullable=False, index=True)
text = Column(Text)
media_url = Column(String(255))
media_type = Column(String(50))
file_name = Column(String(255))
created_at = Column(DateTime, default=datetime.utcnow)
edited = Column(Boolean, default=False)
edited_at = Column(DateTime)
# Relationships
sender = relationship("User", back_populates="sent_messages", foreign_keys=[sender_id])
receiver = relationship("User", back_populates="received_messages", foreign_keys=[receiver_id])