class Job_Monitoring(db.Model): __tablename__ = "job_monitoring" starttime = db.Column(db.String(100)) #palitan ng datetime duration_mins = db.Column(db.String(100)) tasklabel = db.Column(db.String(50)) id = db.Column(db.String(200), primary_key=True) status = db.Column(db.String(10))
class Dly_Prp_Acct(db.Model): __tablename__ = "dly_prp_acct_stats" cre_dt = db.Column(db.String(10), ) brand = db.Column(db.String(50), primary_key=True) total_bal = db.Column(db.String(10)) total_count = db.Column(db.String(10)) def __repr__(self): self.cre_dt = cre_dt self.brand = brand self.total_bal = total_bal self.total_count = total_count
class topsku_prod(db.Model): __tablename__ = "top_sku_prod" txn_date = db.Column(db.String(10), ) processing_dttm = db.Column(db.String(10)) brand = db.Column(db.String(20), primary_key=True) txn_amount = db.Column(db.String(20)) topup_cnt = db.Column(db.String(20)) def __repr__(self): self.txn_date = txn_date self.processing_dttm = processing_dttm self.brand = brand self.txn_amount = txn_amount self.topup_cnt = topup_cnt
class Dly_Pcodes(db.Model): __tablename__ = "dly_pcodes_prp_stats" txn_dt = db.Column(db.String(10), ) brand = db.Column(db.String(50), primary_key=True) total_topup = db.Column(db.String(20)) count_topup = db.Column(db.String(20)) total_count = db.Column(db.String(20)) def __repr__(self): self.txn_dt = txn_dt self.brand = brand self.total_topup = total_topup self.count_topup = count_topup self.total_count = total_count
class topsku_talend(db.Model): __tablename__ = "top_sku_talendfc" txn_date = db.Column(db.String(10), ) processing_dttm = db.Column(db.String(50)) brand = db.Column(db.String(20)) txn_amount = db.Column(db.String(20)) topup_cnt = db.Column(db.String(20), primary_key=True) def __repr__(self): self.txn_date = txn_date self.processing_dttm = processing_dttm self.brand = brand self.txn_amount = txn_amount self.topup_cnt = topup_cnt # class manifest_oracle_monitoring(db.Model): # __tablename__ = "manifest_oracle_monitoring" # file_date = db.Column(db.String(10), primary_key=True) # processing_hour = db.Column(db.String(50), primary_key=True) # cdr_type = db.Column(db.String(20), primary_key=True) # ocs_manifest = db.Column(db.String(20)) # t1_oracle = db.Column(db.String(20)) # variance = db.Column(db.String(20)) # def __repr__(self): # self.file_date = file_date # self.processing_hour = processing_hour # self.cdr_type = cdr_type # self.ocs_manifest = ocs_manifest # self.t1_oracle = t1_oracle # self.variance = variance # class manifest_hive_monitoring(db.Model): # __tablename__ = "manifest_hive_monitoring" # file_date = db.Column(db.String(10), primary_key=True) # processing_hour = db.Column(db.String(50), primary_key=True) # cdr_type = db.Column(db.String(20), primary_key=True) # ocs_manifest = db.Column(db.String(20)) # t1_hive = db.Column(db.String(20)) # variance = db.Column(db.String(20)) # def __repr__(self): # self.file_date = file_date # self.processing_hour = processing_hour # self.cdr_type = cdr_type # self.ocs_manifest = ocs_manifest # self.t1_hive = t1_hive # self.variance = variance
class Job_BCA(db.Model): __tablename__ = "job_bca_monitoring" RunDate = db.Column(db.String(10), primary_key=True) Dly_Prp_Acct = db.Column(db.String(10)) Dly_PCODES = db.Column(db.String(10)) UsageType_Total = db.Column(db.String(10)) UsageType_DataDeducts = db.Column(db.String(10)) UsageType_SMSDeducts = db.Column(db.String(10)) UsageType_VoiceDeducts = db.Column(db.String(10)) UsageType_VasDeducts = db.Column(db.String(10)) UsageType_Topup = db.Column(db.String(10)) UsageType_Expiration = db.Column(db.String(10)) def __repr__(self): self.RunDate = RunDate self.Dly_Prp_Acct = Dly_Prp_Acct self.Dly_PCODES = Dly_PCODES self.UsageType_Total = UsageType_Total self.UsageType_DataDeducts = UsageType_DataDeducts self.UsageType_SMSDeducts = UsageType_SMSDeducts self.UsageType_VoiceDeducts = UsageType_VoiceDeducts self.UsageType_VasDeducts = UsageType_VasDeducts self.UsageType_Topup = UsageType_Topup self.UsageType_Expiration = UsageType_Expiration
class Dly_Usagetype(db.Model): __tablename__ = "dly_usagetype_stats" txn_dt = db.Column(db.String(10), ) usage_type_class = db.Column(db.String(50), primary_key=True) total_count = db.Column(db.String(10)) TOTAL_DEDUCT = db.Column(db.String(10)) USAGE_TYPE_DESC = db.Column(db.String(10)) DEDUCTED_WALLET_DESC = db.Column(db.String(10)) UOM_OF_WALLET = db.Column(db.String(10)) INTERNATIONAL_TAG = db.Column(db.String(10)) ROAMING_TAG = db.Column(db.String(10)) def __repr__(self): self.RunDate = RunDate self.usage_type_class = usage_type_class self.total_count = total_count self.TOTAL_DEDUCT = TOTAL_DEDUCT self.USAGE_TYPE_DESC = USAGE_TYPE_DESC self.DEDUCTED_WALLET_DESC = DEDUCTED_WALLET_DESC self.UOM_OF_WALLET = UOM_OF_WALLET self.INTERNATIONAL_TAG = INTERNATIONAL_TAG self.ROAMING_TAG = ROAMING_TAG