from sqlalchemy import func

from .engine import db
from .types import StringUUID


class ExternalApplication(db.Model):
    __tablename__ = "external_applications"
    __table_args__ = (
        db.PrimaryKeyConstraint("id", name="external_application_pkey"),
    )

    EXTERNAL_APPLICATION_TYPE_LIST = ["QUESTION_ANSWER", "SEARCH", "RECOMMEND"]

    id = db.Column(StringUUID, server_default=db.text("uuid_generate_v4()"))
    name = db.Column(db.String(255), nullable=False)
    type = db.Column(db.String(255), nullable=False)
    url = db.Column(db.String(255), nullable=False)
    method = db.Column(db.String(255), nullable=False)
    status = db.Column(db.Boolean, nullable=False, server_default=db.text("true"))
    created_by = db.Column(StringUUID, nullable=False)
    created_at = db.Column(db.DateTime, nullable=False, server_default=func.current_timestamp())
    updated_by = db.Column(StringUUID, nullable=True)
    updated_at = db.Column(db.DateTime, nullable=False, server_default=func.current_timestamp())