from datetime import datetime, timezone
from app.extensions import db
from sqlalchemy.sql import func


class SubscriptionOptionsItems(db.Model):
    __tablename__ = 'subscription_options_items'

    id = db.Column(db.Integer, primary_key=True, autoincrement=True)
    uid = db.Column(db.String(150), nullable=True)
    description = db.Column(db.String(100), nullable=False)
    option_name = db.Column(db.String(100), nullable=False)
    list_order = db.Column(db.Integer, nullable=True, default=0)
    status = db.Column(db.Integer, nullable=True, default=1)
    added = db.Column(db.DateTime(timezone=False), server_default=func.now())


    @classmethod
    def get_subscription_item(cls, option_name):
        sub_options = cls.query.filter_by(option_name=option_name).all()
        if not sub_options:
            return None
        return sub_options

    def to_dict(self):
        return {
            "id": self.id,
            "uid": self.uid,
            "description": self.description,
            "status": self.status,
            "added": self.added.isoformat() if self.added else None
        }

    def __repr__(self):
        return f'<SubscriptionOptionsItems {self.id} - {self.amount}>'