from app.extensions import db

class SimbrellaCustomer(db.Model):
    __tablename__ = "simbrella_customers"

    customerid = db.Column(db.String(500), primary_key=True)
    acct_opn_date = db.Column(db.DateTime)
    gender = db.Column(db.String(20))
    birth_date = db.Column(db.DateTime)
    msisdn = db.Column(db.String(100))
    isbvnvalid = db.Column(db.String(100))
    datebvnvalidated = db.Column(db.DateTime)
    iscrmsvalid = db.Column(db.String(100))
    datecrmsvalidated = db.Column(db.DateTime)
    iscrcvalid = db.Column(db.String(100))
    datecrcvalidated = db.Column(db.DateTime)


    def __repr__(self):
        return f"<SimbrellaCustomer {self.customerid}>"
    

    def to_dict(self):
        return {
            "customerid": self.customerid,
            "acct_opn_date": self.acct_opn_date,
            "gender": self.gender,
            "birth_date": self.birth_date,
            "msisdn": self.msisdn,
            "isbvnvalid": self.isbvnvalid,
            "datebvnvalidated": self.datebvnvalidated,
            "iscrmsvalid": self.iscrmsvalid,
            "datecrmsvalidated": self.datecrmsvalidated,
            "iscrcvalid": self.iscrcvalid,
            "datecrcvalidated": self.datecrcvalidated,
        }