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!')
