models.py

from flask_sqlalchemy import SQLAlchemy
from datetime import datetime

db = SQLAlchemy()  # SQLAlchemy를 사용해 데이터베이스 저장


class Member(db.Model):
    user_id = db.Column(db.String(30), primary_key=True)
    pwd = db.Column(db.String(150), nullable=False)
    name = db.Column(db.String(50), nullable=False)
    fail_count = db.Column(db.Integer,default=0)

    def __repr__(self):
        return f'Member(user_id={self.user_id}, name={self.name})'


class Board(db.Model):
    board_id = db.Column(db.Integer, primary_key=True, autoincrement=True)
    title = db.Column(db.String(300), nullable=False)
    content = db.Column(db.Text, nullable=False)
    created_dttm = db.Column(db.DateTime, default=datetime.utcnow)
    updated_dttm = db.Column(db.DateTime, default=datetime.utcnow)
    image_url = db.Column(db.String(300), nullable=True)
    user_id = db.Column(db.String, db.ForeignKey(
        'member.user_id'), nullable=False)
    member = db.relationship('Member', backref=db.backref('boards', lazy=True))

    def __repr__(self):
        return f'Board(title={self.title}, content={self.content}, user_id={self.user_id})'


class Board_Reply(db.Model):
    reply_id = db.Column(db.Integer, primary_key=True, autoincrement=True)
    content = db.Column(db.Text, nullable=False)  # NOT NULL
    created_dttm = db.Column(db.DateTime, default=datetime.utcnow)
    updated_dttm = db.Column(db.DateTime, default=datetime.utcnow)
    board_id = db.Column(db.Integer, db.ForeignKey(
        'board.board_id'), nullable=False)
    board = db.relationship('Board', backref=db.backref(
        'replies', lazy=True))  # TODO: replies 양방향 참조 필요한 경우 확인
    user_id = db.Column(db.String, db.ForeignKey(
        'member.user_id'), nullable=False)
    member = db.relationship('Member')  # TODO: relationship 에 대한 정리

    def __repr__(self):
        return f'BoardReply(content={self.content}, board_id={self.board_id}, user_id={self.user_id})'


class Message(db.Model):
    msg_id = db.Column(db.Integer, primary_key=True, autoincrement=True)
    message = db.Column(db.String(255), nullable=False)
    timestamp = db.Column(db.DateTime, default=datetime.utcnow)
    user_id = db.Column(db.String, db.ForeignKey('member.user_id'), nullable=False)
    member = db.relationship('Member', backref=db.backref('messages', lazy=True))

    def __repr__(self):
        return f"<Message {self.msg_id}>"