summaryrefslogtreecommitdiff
path: root/src/database/models/comment.py
blob: 0110e7557165b56f8e393a47bf26695e6f722aa9 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
from sqlalchemy import BigInteger, String, DateTime, Text, ForeignKey
from sqlalchemy.orm import mapped_column, Mapped, relationship
from src.database import db


class Comment(db.Model):
    __tablename__ = 'comments'

    id = mapped_column(BigInteger, primary_key=True)
    content: Mapped[str] = mapped_column(Text)
    language: Mapped[str] = mapped_column(String(16), nullable=False)
    email: Mapped[str] = mapped_column(String(256))
    post: Mapped[str] = mapped_column(String(1024), nullable=False)
    blog_id: Mapped[int] = mapped_column(ForeignKey('blogs.id'), index=True)
    blog = relationship('Blog', back_populates='comments')
    created_at = mapped_column(DateTime)
    updated_at = mapped_column(DateTime)