VivianDee
36 lines
1.2 KiB
Python
36 lines
1.2 KiB
Python
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,
|
|
} |