from app.extensions import db
from datetime import datetime

class PlanfixToken(db.Model):
    __tablename__ = "planfix_tokens"
    id         = db.Column(db.Integer, primary_key=True)
    api_login  = db.Column(db.String(255), nullable=False)
    api_token  = db.Column(db.String(255), nullable=False)
    is_active  = db.Column(db.Boolean, default=True)
    created_at = db.Column(db.DateTime, default=datetime.utcnow)
    updated_at = db.Column(db.DateTime, default=datetime.utcnow,
                           onupdate=datetime.utcnow)

class PlanfixCompany(db.Model):
    __tablename__ = "planfix_companies"
    id            = db.Column(db.Integer, primary_key=True)
    pf_company_id = db.Column(db.Integer, unique=True, nullable=False)
    name          = db.Column(db.String(255), nullable=False)
    pay_status    = db.Column(db.Enum(
        'Сплачений', 'Постоплата', 'Не сплачений',
        'Очікує оплати', 'Призупинений'
    ), nullable=False)
    updated_at    = db.Column(db.DateTime, default=datetime.utcnow,
                              onupdate=datetime.utcnow)