def generate_customer(): """生成客户id""" # ALTER TABLE pyner_customer AUTO_INCREMENT = 1000000001; select_insert(generateSQL) """生成平台客户ID""" update(updatePlatformCredInfoUSCCSQL) update(updatePlatformCredInfoBLCSQL) select_insert(generatePlatformSQL) print('generate_customer Finish', datetime.now())
def init_should_repay_assert_period_range_report(): """资产质量-已到期资产期限分布报表""" # 1天-30天 select_insert(initShouldRepayAssertPeriodRangeSQL1.format(1, 30)) # 30天-90天 select_insert(initShouldRepayAssertPeriodRangeSQL1.format(30, 90)) # 90天-180天 select_insert(initShouldRepayAssertPeriodRangeSQL1.format(90, 180)) # 180天- select_insert(initShouldRepayAssertPeriodRangeSQL2.format(180)) print('init_assert_period_range_report Finish!')
def init_should_repay_assert_amount_range_report(): """资产质量-已到期标的金额分布报表""" # 小于100元 select_insert(initShouldRepayAssertAmountRangeSQL0.format(100)) # 100-500元 select_insert(initShouldRepayAssertAmountRangeSQL1.format(100, 500)) # 500-1000元 select_insert(initShouldRepayAssertAmountRangeSQL1.format(500, 1000)) # 大于1000元 select_insert(initShouldRepayAssertAmountRangeSQL2.format(1000)) print('init_should_repay_assert_amount_range_report Finish!')
def init_should_repay_assert_rate_range_report(): """资产质量-已到期资产期限分布报表""" # 0%-6% select_insert(initShouldRepayAssertRateRangeSQL1.format(0, 0.06)) # 6%-10% select_insert(initShouldRepayAssertRateRangeSQL1.format(0.06, 0.1)) # 10%-15% select_insert(initShouldRepayAssertRateRangeSQL1.format(0.1, 0.15)) # 15%以上 select_insert(initShouldRepayAssertRateRangeSQL2.format(0.15)) print('init_assert_rate_range_report Finish!')
def init_normal_repay_assert_rate_range_report(): # TODO 未测试 """资产质量-正常还款资产期限分布报表""" # 0%-6% select_insert(initNormalRepayAssertRateRangeSQL1.format(0, 0.06)) # 6%-10% select_insert(initNormalRepayAssertRateRangeSQL1.format(0.06, 0.1)) # 10%-15% select_insert(initNormalRepayAssertRateRangeSQL1.format(0.1, 0.15)) # 15%以上 select_insert(initNormalRepayAssertRateRangeSQL2.format(0.15)) print('init_normal_repay_assert_rate_range_report Finish!')
def init_normal_repay_assert_amount_range_report(): # TODO 未测试 """资产质量-正常还款标的金额分布报表""" # 小于100元 select_insert(initNormalRepayAssertAmountRangeSQL0.format(100)) # 100-500元 select_insert(initNormalRepayAssertAmountRangeSQL1.format(100, 500)) # 500-1000元 select_insert(initNormalRepayAssertAmountRangeSQL1.format(500, 1000)) # 大于1000元 select_insert(initNormalRepayAssertAmountRangeSQL2.format(1000)) print('init_normal_repay_assert_amount_range_report Finish!')
def init_normal_repay_assert_period_range_report(): # TODO 未测试 """资产质量-正常还款资产期限分布报表""" # 1天-30天 select_insert(initNormalRepayAssertPeriodRangeSQL1.format(1, 30)) # 30天-90天 select_insert(initNormalRepayAssertPeriodRangeSQL1.format(30, 90)) # 90天-180天 select_insert(initNormalRepayAssertPeriodRangeSQL1.format(90, 180)) # 180天- select_insert(initNormalRepayAssertPeriodRangeSQL2.format(180)) print('init_normal_repay_assert_period_range_report Finish!')
def init_enterprise_antifraud_task(): """初始化企业反欺诈任务""" select_insert(initEnterpriseAntifraudTaskSQL) print('init_enterprise_antifraud_task Finish!')
def init_enterprise_antifraud_info(): """初始化企业反欺诈信息""" select_insert(initEnterpriseAntifraudInfoSQL) print('init_enterprise_antifraud_info Finish!')
def init_user_scale_report(): """初始化用户规模报表信息""" select_insert(initUserScaleReportSQL) print('init_user_scale_report Finish!')
def init_granted_report(): """放款金额报表""" select_insert(initGrantedReportSQL) print('init_granted_report Finish!')
def init_custopt_gender_report(): """用户性别总数(日/累计)报表""" select_insert(initCustoptGenderSQL) print('init_custopt_gender_report Finish!')
def init_custopt_address_report(): """地区(日/累计)报表""" select_insert(initCustoptAddressSQL) print('init_custopt_address_report Finish!')
def generate_user_report(): """生成用户报表基础信息""" select_insert(createUserReportSQL) print('create_user_report Finish')
def init_should_repay_compensation_repayed_report(): # TODO 未测试 """逾期表现-还代偿金额""" select_insert(initShouldRepayCompensationRepayedSQL) print('init_should_repay_compensation_repayed_report Finish!')
def init_overdue_bid_amount_report(): # TODO 未测试 """逾期表现-所有标的金额""" select_insert(initOverdueBidAmountSQL) print('init_overdue_bid_amount_report Finish!')
def init_overdue_repayed_report(): # TODO 未测试 """逾期表现-逾期还款金额""" select_insert(initOverdueRepayedSQL) print('init_overdue_repayed_report Finish!')