def del_collection(platform_user_profile_uuid):
"""
根据系统用户uuid，删除催收人员
"""
mydb.delete(
la.DB, 'Tbl_PlatformUserProfileCollection',
'platform_user_profile_uuid="{}"'.format(platform_user_profile_uuid))
def del_group():
# 删除分组
group_ids = MysqlClent.select_col(DB_CONN, 'fk_gps_group', 'id',
'POSITION("{}" IN group_name)'.format(loginAction.sign))
MysqlClent.delete(DB_CONN, 'fk_gps_group', 'POSITION("{}" IN group_name)'.format(loginAction.sign))
for group_id in group_ids:
MysqlClent.delete(DB_CONN, 'fk_gps_group_relation', 'group_id={}'.format(group_id))
def test_30_delete_test_user(self):
# test-API
user_uuids = MysqlClent.select(loginAction.DB, 'Tbl_PlatformUserProfile', 'platform_user_profile_uuid',
'name like "%test-API%"')
MysqlClent.delete(loginAction.DB, 'Tbl_PlatformUserProfile', 'name like "%test-API%"')
for user_uuid in user_uuids:
MysqlClent.delete(loginAction.DB, 'Tbl_PlatformUserPrivilegeRelation',
'platform_user_uuid="{}"'.format(user_uuid))
def del_manage_user():
# 删除运营人员
MysqlClent.delete(DB_CONN, 'sys_manage',
'POSITION("{}" IN name)'.format(loginAction.sign))
for manage_id in get_manage_user_ids():
# 删除运营人员权限
MysqlClent.delete(DB_CONN, 'sys_manage_role',
'manage_id="{}"'.format(manage_id))
def del_user():
# 删除管理员
user_ids = get_manage_user_ids()
MysqlClent.delete(
DB_CONN, 'biz_company_user',
'POSITION("{0}" IN user_email) or POSITION("{1}" IN user_name)'.format(
loginAction.sign, loginAction.sign))
for user_id in user_ids:
MysqlClent.delete(DB_CONN, 'biz_company_user_device',
'company_user_id="{}"'.format(user_id))
def del_gps():
# 删除gps
gps_ids = MysqlClent.select_col(DB_CONN, 'fk_gps', 'id', 'POSITION("{}" IN code)'.format(loginAction.sign))
gps_codes = MysqlClent.select_col(DB_CONN, 'fk_gps', 'code', 'POSITION("{}" IN code)'.format(loginAction.sign))
MysqlClent.delete(DB_CONN, 'fk_gps', 'POSITION("{}" IN code)'.format(loginAction.sign))
for gps_id in gps_ids:
MysqlClent.delete(DB_CONN, 'fk_gps_finance', 'gps_id={}'.format(gps_id))
MysqlClent.delete(DB_CONN, 'fk_gps_group_relation', 'gps_id={}'.format(gps_id))
for gps_code in gps_codes:
MysqlClent.delete(DB_CONN, 'fk_risk_except', 'gps_code={}'.format(gps_code))
MysqlClent.delete(DB_CONN, 'fk_gps_location', 'gps_code={}'.format(gps_code))
def delete_user(user_name):
# 根据用户名删除用户
user_ids = mydb.select(
conn=DB_CONN,
table='Tbl_User',
column='id',
condition='position("{}" in realname)'.format(user_name))
for user_id in user_ids:
mydb.delete(conn=DB_CONN,
table='Tbl_User',
condition='id = "{}"'.format(user_id[0]))
def update_contract_machine_telephone_check(contract_uuid):
"""
删除电审信息，修改订单为初审通过状态
:param contract_uuid: 订单UUID
:return:
"""
condtion = "contract_uuid='{0}'".format(contract_uuid)
la.LOGGER.info(condtion)
mydb.delete(la.DB, 'Tbl_TelephoneCheckLog', condtion)
contract_state = {"qifa_machine_audit": "风控规则预置通过", "submit_state": "提交成功",
"contract_state": "生效", "first_check": "初审通过", "telephone_check": "电核中"}
update_contract_state(contract_uuid, contract_state)
def delete_role(role_name):
# 根据角色名删除角色
role_ids = mydb.select(
conn=DB_CONN,
table='Tbl_Role',
column='id',
condition='position("{}" in name)'.format(role_name))
for role_id in role_ids:
mydb.delete(conn=DB_CONN,
table='Tbl_Role_Permission',
condition='role_id = {}'.format(role_id[0]))
mydb.delete(conn=DB_CONN,
table='Tbl_Role',
condition='id = {}'.format(role_id[0]))
def drop_db():
# 查询数据库名称
db_names = MysqlClent.select_join(
DB_CONN, 'biz_company_datasource as a,biz_company as b', 'a.db_name',
'a.company_id = b.id',
'POSITION("{}" IN b.name)'.format(loginAction.sign))
# 删除biz_company表中的企业
MysqlClent.delete(DB_CONN, 'biz_company',
'POSITION("{}" IN name)'.format(loginAction.sign))
# 删除 biz_company_datasource表中的数据库id
for db_name in db_names:
MysqlClent.delete(DB_CONN, 'biz_company_datasource',
'db_name="{}"'.format(db_name[0]))
# 删除数据库
MysqlClent.drop_database(DB_CONN, db_name[0])
def del_finance():
# 删除financeid
finance_ids = MysqlClent.select_col(DB_CONN, 'fk_finance', 'id', 'POSITION("{}" IN owner)'.format(loginAction.sign))
MysqlClent.delete(DB_CONN, 'fk_finance', 'POSITION("{}" IN owner)'.format(loginAction.sign))
for finance_id in finance_ids:
MysqlClent.delete(DB_CONN, 'fk_gps_finance', 'finance_id={}'.format(finance_id))
MysqlClent.delete(DB_CONN, 'fk_risk_except', 'finance_id={}'.format(finance_id))
MysqlClent.delete(DB_CONN, 'fk_gps_location', 'finance_id={}'.format(finance_id))
def delete_infos(table_names, condition_column, condition_value_list):
if isinstance(table_names, str):
table_names = [table_names]
for table_name in table_names:
if condition_value_list is None:
continue
if len(condition_value_list) > 1:
condition = '{0} IN {1}'.format(condition_column, tuple(condition_value_list))
elif len(condition_value_list) == 1:
value = condition_value_list[0]
if isinstance(value, str):
condition = '{0}="{1}"'.format(condition_column, value)
else:
condition = '{0}={1}'.format(condition_column, value)
else:
continue
mydb.delete(la.DB, table_name, condition)
def delete_user(user_name):
# 根据用户名删除用户
if user_name == '' or user_name == ' ' or user_name is None or len(
user_name.strip()) == 0:
user_ids = mydb.select(conn=DB_CONN,
table='Tbl_User',
column='id',
condition='"{}" = realname'.format(user_name))
else:
user_ids = mydb.select(
conn=DB_CONN,
table='Tbl_User',
column='id',
condition='position("{}" in realname)'.format(user_name))
for user_id in user_ids:
mydb.delete(conn=DB_CONN,
table='Tbl_User',
condition='id = "{}"'.format(user_id[0]))
def del_user():
# 删除角色
user_ids = MysqlClent.select_col(DB_CONN, 'fk_user', 'id', 'POSITION("{}" IN name)'.format(loginAction.sign))
MysqlClent.delete(DB_CONN, 'fk_user', 'POSITION("{}" IN name)'.format(loginAction.sign))
for user_id in user_ids:
MysqlClent.delete(DB_CONN, 'fk_user_jurisdiction', 'user_id={}'.format(user_id))
condition = 'user_id={0} AND company_id={1}'.format(user_id, ManageSql.get_company_id())
company_user_id = MysqlClent.select_col(ManageSql.DB_CONN, 'biz_company_user', 'id', condition)
MysqlClent.delete(ManageSql.DB_CONN, 'biz_company_user', condition)
MysqlClent.delete(ManageSql.DB_CONN, 'biz_company_user_device',
'company_user_id IN ({})'.format(tuple(company_user_id)))
def delete_role(role_name):
if role_name == '' or role_name == ' ' or role_name is None or len(
role_name) == 0:
role_ids = mydb.select(conn=DB_CONN,
table='Tbl_Role',
column='id',
condition='name = {} '.format(role_name))
else:
role_ids = mydb.select(
conn=DB_CONN,
table='Tbl_Role',
column='id',
condition='position("{}" in name)'.format(role_name))
for role_id in role_ids:
mydb.delete(conn=DB_CONN,
table='Tbl_Role_Permission',
condition='role_id = {}'.format(role_id[0]))
mydb.delete(conn=DB_CONN,
table='Tbl_Role',
condition='id = {}'.format(role_id[0]))
def delete_tanant_admi(business_name, tenant_name, adm_name):
# 清除“消费分期”机构管理员测试数据，但不清除“消费分期”机构
business_id = mydb.select_one(
conn=DB_CONN,
table='Tbl_Business_System',
column='id',
condition='position("{}" in name)'.format(business_name))
tenant_id = mydb.select_one(conn=DB_CONN,
table='Tbl_Tenant',
column='id',
condition='business_system_id = {} and '
'position("{}" in name)'.format(
business_id, tenant_name))
mydb.delete(conn=DB_CONN,
table='Tbl_Tenant',
condition='id = "{}"'.format(tenant_id))
mydb.delete(conn=DB_CONN,
table='Tbl_Tenant_Administrator',
condition='business_system_id = {} and '
'tenant_id = {} and position("{}" in name)'.format(
business_id, tenant_id, adm_name))
def delete_system(business_name):
# 根据系统名称删除所有测试数据
if business_name == '' or business_name == ' ' or business_name is None or len(
business_name) == 0:
business_ids = mydb.select(
conn=DB_CONN,
table='Tbl_Business_System',
column='id',
condition='name = "{}"'.format(business_name))
else:
business_ids = mydb.select(
conn=DB_CONN,
table='Tbl_Business_System',
column='id',
condition='position("{}" in name)'.format(business_name))
for business_id in business_ids:
mydb.delete(conn=DB_CONN,
table='Tbl_Business_System_Permission',
condition='business_system_id = {}'.format(business_id[0]))
mydb.delete(conn=DB_CONN,
table='Tbl_Business_System_Config',
condition='business_system_id = {}'.format(business_id[0]))
mydb.delete(conn=DB_CONN,
table='Tbl_Business_System',
condition='id = {}'.format(business_id[0]))
def delete_tanant_adm(business_name, tenant_name, adm_name):
# 清除机构管理员测试数据
business_ids = mydb.select(
conn=DB_CONN,
table='Tbl_Business_System',
column='id',
condition='position("{}" in name)'.format(business_name))
for business_id in business_ids:
tenant_ids = mydb.select(
conn=DB_CONN,
table='Tbl_Tenant',
column='id',
condition='business_system_id = {} and position("{}" in name)'.
format(business_id[0], tenant_name))
for tenant_id in tenant_ids:
mydb.delete(
conn=DB_CONN,
table='Tbl_Tenant_Administrator',
condition=
'business_system_id = {} and tenant_id = {} and position("{}" in name)'
.format(business_id[0], tenant_id[0], adm_name))
mydb.delete(conn=DB_CONN,
table='Tbl_Tenant',
condition='id = "{}"'.format(tenant_id[0]))
mydb.delete(conn=DB_CONN,
table='Tbl_Business_System',
condition='position("{}" in name)'.format(business_name))
def delete_databases(tanant_name):
# 根据机构名删除Tbl_PlatformUser表中对应数据、删除Tbl_CompanyDataSource表中对应数据，
# 并删除数据库，删除Tbl_Business表中数据
tenantUuids = mydb.select(
conn=DB_CONN,
table='Tbl_Business',
column='tenantUuid',
condition='position("{}" in name)'.format(tanant_name))
for tenantUuid in tenantUuids:
# 查询dbname
dbname = mydb.select(conn=DB_CONN,
table='Tbl_CompanyDataSource',
column='db_name',
condition='tenantUuid = "{}"'.format(
tenantUuid[0]))
# 根据dbname删除db
mydb.drop_database(conn=DB_CONN,
database_name="{}".format(dbname[0][0]))
# 删除Tbl_CompanyDataSource表中删除db的记录数据
mydb.delete(conn=DB_CONN,
table='Tbl_CompanyDataSource',
condition='tenantUuid = "{}"'.format(tenantUuid[0]))
# 删除Tbl_PlatformUser表中该机构的用户
mydb.delete(conn=DB_CONN,
table='Tbl_PlatformUser',
condition='tenantUuid = "{}" '.format(tenantUuid[0]))
# 删除Tbl_Business表中name为tanant_name的数据
mydb.delete(conn=DB_CONN,
table='Tbl_Business',
condition='position("{}" in name)'.format(tanant_name))
def del_role():
# 删除角色
roles = MysqlClent.select_col(DB_CONN, 'fk_role', 'id', 'POSITION("{}" IN name)'.format(loginAction.sign))
MysqlClent.delete(DB_CONN, 'fk_role', 'POSITION("{}" IN name)'.format(loginAction.sign))
for role_id in roles:
MysqlClent.delete(DB_CONN, 'fk_role_moudel', 'role_id={}'.format(role_id))
MysqlClent.delete(DB_CONN, 'fk_role_user', 'role_id={}'.format(role_id))
def del_org():
# 删除组织机构信息
org_codes = MysqlClent.select_col(DB_CONN, 'fk_org', 'company_code',
'POSITION("{}" IN name)'.format(loginAction.sign))
MysqlClent.delete(DB_CONN, 'fk_org', 'POSITION("{}" IN name)'.format(loginAction.sign))
for org_code in org_codes:
MysqlClent.delete(DB_CONN, 'fk_org_invalid', 'org_code={}'.format(org_code))
MysqlClent.delete(DB_CONN, 'fk_user', 'org_code={}'.format(org_code))
MysqlClent.delete(DB_CONN, 'fk_user_jurisdiction', 'org_code={}'.format(org_code))
MysqlClent.delete(DB_CONN, 'fk_rule', 'org_code={}'.format(org_code))
MysqlClent.delete(DB_CONN, 'fk_role', 'org_code={}'.format(org_code))
MysqlClent.delete(DB_CONN, 'fk_risk_except', 'org_code={}'.format(org_code))
MysqlClent.delete(DB_CONN, 'fk_risk', 'org_code={}'.format(org_code))
MysqlClent.delete(DB_CONN, 'fk_gps_group', 'org_code={}'.format(org_code))
MysqlClent.delete(DB_CONN, 'fk_gps', 'org_code={}'.format(org_code))
MysqlClent.delete(DB_CONN, 'fk_finance', 'org_code={}'.format(org_code))
def delete_info(table_name, condition):
mydb.delete(la.DB, table_name, condition)
def update_contract_machine_pass(contract_uuid, user_uuid):
"""
修改订单状态，绕过机审和签订合同
:param contract_uuid: 订单UUID
:param user_uuid: 用户UUID
:return:
"""
la.LOGGER.info('contract_uuid : {0} user_uuid : {1}'.format(contract_uuid, user_uuid))
contract_state = {"qifa_machine_audit": "风控规则预置通过", "submit_state": "提交成功",
"contract_state": "生效"}
update_contract_state(contract_uuid, contract_state)
get_uuid = lambda x: ''.join(str(x).split('-'))
contract_info_col = ['contract_info_uuid', 'contract_uuid', 'fdd_number', 'contract_name', 'type', 'platform',
'sign_state', 'view_url', 'download_url', 'state']
contract_name = ["分期还款服务合同", "委托付款函", "通知函"]
condtion = ['contract_uuid="{}"'.format(contract_uuid)]
for _name in contract_name:
_edtion = 'contract_name="{}"'.format(_name)
condtion.append(_edtion)
contract_info_rows = mydb.select_rows(la.DB, 'Tbl_ContractInfo', 'id', ' AND '.join(condtion))
if contract_info_rows == 0:
contract_info = mydb.select(la.DB, 'Tbl_ContractInfo', ','.join(contract_info_col), condtion[1])[0]
la.LOGGER.info('查询Tbl_ContractInfo中"{0}"的值{1}'.format(_name, contract_info))
contract_info[0:2] = get_uuid(uuid.uuid1()), contract_uuid
la.LOGGER.info('插入Tbl_ContractInfo中"{0}"的值{1}'.format(_name, contract_info))
mydb.insert(la.DB, 'Tbl_ContractInfo', dict(zip(contract_info_col, contract_info)))
condtion.remove(_edtion)
translog_rows = mydb.select_rows(la.DB, 'Tbl_TransLog', 'id', "user_id='{}'".format(user_uuid))
if translog_rows == 0:
translog_col = ['out_id', 'trans_log_uuid', 'trans_seq_id', 'user_id', 'cust_id', 'trans_type',
'trans_amt', 'fee_amt', 'trans_state', 'resp_code', 'err_code', 'chk_state',
'bank_state', 'oper_seq_id', 'trans_name', 'trans_obj', 'card_acct_type', 'card_id',
'card_opening_bank', 'card_acct_name', 'card_line_num', 'bank_remark',
'bank_seq_id', 'acct_seq_id', 'ret_fee', 'bank_proc_desc',
'gate_id', 'pay_channel_id', 'cash_type', 'state', 'business_data']
translog_value = mydb.select(la.DB, 'Tbl_TransLog', ','.join(translog_col))[0]
translog_dict = dict(zip(translog_col, translog_value))
la.LOGGER.info('查询Tbl_TransLog的值{}'.format(translog_value))
translog_dict['trans_log_uuid'], translog_dict['user_id'] = get_uuid(uuid.uuid1()), user_uuid
translog_dict['trans_amt'], translog_dict['fee_amt'], translog_dict['bank_state'] = 1000, 0.0, 'bank_state_S'
translog_dict['trans_state'], translog_dict['chk_state'], = 'trans_state_S', 'chk_state_S'
la.LOGGER.info('插入Tbl_TransLog的值{}'.format(translog_dict))
# 交易流水表 新增数据
mydb.insert(la.DB, 'Tbl_TransLog', translog_dict)
qifamachinelog_rows = mydb.select_rows(la.DB, 'Tbl_QifaMachineLog', 'id', condtion[0])
if qifamachinelog_rows == 0:
qifamachinelog_col = ['qifa_machine_log_uuid', 'contract_uuid', 'qifa_machine_audit', 'score',
'risk_warning', 'state']
qifamachinelog_value = [get_uuid(uuid.uuid1()), contract_uuid, 'qifa_merchant_audit_pass', '67',
'中风险，建议核查', 'enabled']
la.LOGGER.info('插入Tbl_QifaMachineLog的值{}'.format(qifamachinelog_value))
# 系统机审表 新增数据
mydb.insert(la.DB, 'Tbl_QifaMachineLog', dict(zip(qifamachinelog_col, qifamachinelog_value)))
condtion.append('user_uuid="{}"'.format(user_uuid))
user_ocr_info_rows = mydb.select_rows(la.DB, 'Tbl_UserOcrInfo', 'id', ' AND '.join(condtion))
if user_ocr_info_rows == 0:
user_ocr_info_col = ['user_ocr_uuid', 'contract_uuid', 'user_uuid', 'first_key', 'second_key', 'third_key',
'qiniu_config_id', 'authentication_state', 'state', 'note']
user_ocr_info_value = mydb.select(la.DB, 'Tbl_UserOcrInfo', ','.join(user_ocr_info_col), 'note IS NOT NULL')[0]
la.LOGGER.info('查询Tbl_UserOcrInfo的值{}'.format(user_ocr_info_value))
user_ocr_info_value[0:3] = get_uuid(uuid.uuid1()), contract_uuid, user_uuid
user_ocr_info_value[-1] = str(user_ocr_info_value[-1]).replace('\"', '\\\"')
la.LOGGER.info('插入bl_UserOcrInfo的值{}'.format(user_ocr_info_value))
# 客户OCR信息表 新增人脸识别数据
mydb.insert(la.DB, 'Tbl_UserOcrInfo', dict(zip(user_ocr_info_col, user_ocr_info_value)))
user_personal_info_rows = mydb.select_rows(la.DB, 'Tbl_UserPersonalInfo', 'id', ' AND '.join(condtion))
if user_personal_info_rows == 0:
user_personal_info_col = ['user_person_uuid', 'contract_uuid', 'user_uuid', 'datum_type_marry_id',
'datum_type_education_id', 'datum_type_housing_id', 'live_province',
'live_province_name', 'live_city', 'live_city_name', 'live_region',
'live_region_name', 'live_detail', 'state']
user_personal_info_value = mydb.select(la.DB, 'Tbl_UserPersonalInfo', ','.join(user_personal_info_col))[0]
la.LOGGER.info('查询Tbl_UserPersonalInfo的值{}'.format(user_personal_info_value))
user_personal_info_value[0:3] = get_uuid(uuid.uuid1()), contract_uuid, user_uuid
la.LOGGER.info('插入Tbl_UserPersonalInfo的值{}'.format(user_personal_info_value))
# 客户个人信息表 新增和订单关联的数据
mydb.insert(la.DB, 'Tbl_UserPersonalInfo', dict(zip(user_personal_info_col, user_personal_info_value)))
user_work_info_rows = mydb.select_rows(la.DB, 'Tbl_UserWorkInfo', 'id', ' AND '.join(condtion))
if user_work_info_rows == 0:
user_work_info_col = ['user_work_uuid', 'contract_uuid', 'user_uuid', 'company_name', 'position',
'work_phone', 'datum_type_income_id', 'datum_type_worktime_id', 'company_province',
'company_province_name', 'company_city', 'company_city_name', 'company_region',
'company_region_name', 'company_detail', 'state']
user_work_info_value = mydb.select(la.DB, 'Tbl_UserWorkInfo', ','.join(user_work_info_col))[0]
la.LOGGER.info('查询Tbl_UserWorkInfo的值{}'.format(user_work_info_value))
user_work_info_value[0:3] = get_uuid(uuid.uuid1()), contract_uuid, user_uuid
la.LOGGER.info('插入Tbl_UserWorkInfo的值{}'.format(user_work_info_value))
# 客户工作信息表 新增和订单关联的数据
mydb.insert(la.DB, 'Tbl_UserWorkInfo', dict(zip(user_work_info_col, user_work_info_value)))
user_contact_info_rows = mydb.select_rows(la.DB, 'Tbl_UserContactInfo', 'id', ' AND '.join(condtion))
user_contact_info_col = ['user_contact_uuid', 'contract_uuid', 'user_uuid', 'name', 'phone',
'datum_type_contact_id', 'state']
user_contact_info_value = mydb.select(la.DB, 'Tbl_UserContactInfo', ','.join(user_contact_info_col))[0]
la.LOGGER.info('查询Tbl_UserContactInfo的值{}'.format(user_contact_info_value))
user_contact_info_value[0:3] = get_uuid(uuid.uuid1()), contract_uuid, user_uuid
if user_contact_info_rows == 0:
# 客户联系人信息表 新增和订单关联的数据
la.LOGGER.info('插入Tbl_UserContactInfo的值{}'.format(user_contact_info_value))
mydb.insert(la.DB, 'Tbl_UserContactInfo', dict(zip(user_contact_info_col, user_contact_info_value)))
elif user_contact_info_rows > 1:
mydb.delete(la.DB, 'Tbl_UserContactInfo',
"contract_uuid='{0}' AND user_uuid='{1}'".format(contract_uuid, user_uuid))
la.LOGGER.info('插入Tbl_UserContactInfo的值{}'.format(user_contact_info_value))
mydb.insert(la.DB, 'Tbl_UserContactInfo', dict(zip(user_contact_info_col, user_contact_info_value)))
def delete_info(table_name, condition):
mydb.delete(DB_CONN, table_name, condition)
def update_contract_machine_pass(contract_uuid, user_uuid):
"""
修改订单状态，绕过机审和签订合同
:param contract_uuid: 订单UUID
:param user_uuid: 用户UUID
:return:
"""
la.LOGGER.info('contract_uuid : {0} user_uuid : {1}'.format(
contract_uuid, user_uuid))
contract_state = {
"qifa_machine_audit": "风控规则预置通过",
"submit_state": "提交成功",
"contract_state": "生效"
}
update_contract_state(contract_uuid, contract_state)
value_dict = {"loan_periods": 3}
mydb.update_dict(la.DB, 'Tbl_Contract', value_dict,
'contract_uuid="{}"'.format(contract_uuid))
get_uuid = lambda x: ''.join(str(x).split('-'))
# contract_info_col = ['contract_info_uuid', 'contract_uuid', 'fdd_number', 'contract_name', 'type', 'platform',
# 'sign_state', 'view_url', 'download_url', 'state']
# contract_name = ["分期还款服务合同", "委托付款函", "通知函"]
contract_name = {
'服务完结确认书_QA.pdf': "A",
'应收账款转让协议书_QA.pdf': "B",
'债权转让通知书_QA.pdf': "C",
'居间服务协议_QA.pdf': "D",
'医疗美容项目服务合同_QA.pdf': "E"
}
condtion = ['contract_uuid="{}"'.format(contract_uuid)]
for _name in contract_name.keys():
_edtion = 'contract_name="{}"'.format(_name)
condtion.append(_edtion)
contract_info_rows = mydb.select_rows(la.DB, 'Tbl_ContractInfo', 'id',
' AND '.join(condtion))
if contract_info_rows == 0:
insert_dict = {
'contract_info_uuid': str(uuid.uuid1()).split('-'),
'contract_uuid': contract_uuid,
'fdd_number': "2020011618014346820480_" + contract_name[_name],
'contract_name': _name,
'type': '1',
'platform': '1',
'sign_state': '0',
'view_url': '',
'download_url': '',
'state': 'enabled'
}
# contract_info = mydb.select(la.DB, 'Tbl_ContractInfo', ','.join(contract_info_col), condtion[1])[0]
# la.LOGGER.info('查询Tbl_ContractInfo中"{0}"的值{1}'.format(_name, contract_info))
# contract_info[0:2] = get_uuid(uuid.uuid1()), contract_uuid
# la.LOGGER.info('插入Tbl_ContractInfo中"{0}"的值{1}'.format(_name, contract_info))
# mydb.insert(la.DB, 'Tbl_ContractInfo', dict(zip(contract_info_col, contract_info)))
mydb.insert(la.DB, 'Tbl_ContractInfo', insert_dict)
condtion.remove(_edtion)
translog_rows = mydb.select_rows(la.DB, 'Tbl_TransLog', 'id',
"user_id='{}'".format(user_uuid))
if not translog_rows:
translog_dict = {
'out_id': '2019112910110111420480',
'trans_log_uuid': get_uuid(uuid.uuid1()),
'trans_seq_id': '2019112911111294628672',
'user_id': user_uuid,
'cust_id': '',
'trans_type': 'trans_type_P001',
'trans_amt': 1000,
'fee_amt': 0.0,
'trans_state': 'trans_state_S',
'resp_code': '',
'err_code': '',
'chk_state': 'chk_state_S',
'bank_state': 'bank_state_S',
'oper_seq_id': '',
'trans_name': 'testAPI',
'trans_obj': 'testAPI',
'card_acct_type': 'card_acct_type_private',
'card_id': '213105529995110',
'card_opening_bank': '招商银行',
'card_acct_name': 'testAPI',
'card_line_num': '34646546',
'bank_remark': 'testAPI',
'bank_seq_id': '',
'acct_seq_id': '',
'ret_fee': 'ret_fee_no',
'bank_proc_desc': '',
'gate_id': '',
'pay_channel_id': '',
'cash_type': 'cash_type_T0',
'state': 'enabled',
'business_data': ''
}
la.LOGGER.info('插入Tbl_TransLog的值{}'.format(translog_dict))
# 交易流水表 新增数据
mydb.insert(la.DB, 'Tbl_TransLog', translog_dict)
qifamachinelog_rows = mydb.select_rows(la.DB, 'Tbl_QifaMachineLog', 'id',
condtion[0])
if qifamachinelog_rows == 0:
qifamachinelog_col = [
'qifa_machine_log_uuid', 'contract_uuid', 'qifa_machine_audit',
'score', 'risk_warning', 'state'
]
qifamachinelog_value = [
get_uuid(uuid.uuid1()), contract_uuid, 'qifa_merchant_audit_pass',
'67', '中风险，建议核查', 'enabled'
]
la.LOGGER.info('插入Tbl_QifaMachineLog的值{}'.format(qifamachinelog_value))
# 系统机审表 新增数据
mydb.insert(la.DB, 'Tbl_QifaMachineLog',
dict(zip(qifamachinelog_col, qifamachinelog_value)))
condtion.append('user_uuid="{}"'.format(user_uuid))
user_ocr_info_rows = mydb.select_rows(la.DB, 'Tbl_UserOcrInfo', 'id',
' AND '.join(condtion))
if user_ocr_info_rows == 0:
user_ocr_info_col = [
'user_ocr_uuid', 'contract_uuid', 'user_uuid', 'first_key',
'second_key', 'third_key', 'qiniu_config_id',
'authentication_state', 'state', 'note'
]
user_ocr_info_value = mydb.select(la.DB, 'Tbl_UserOcrInfo',
','.join(user_ocr_info_col),
'note IS NOT NULL')[0]
la.LOGGER.info('查询Tbl_UserOcrInfo的值{}'.format(user_ocr_info_value))
user_ocr_info_value[0:3] = get_uuid(
uuid.uuid1()), contract_uuid, user_uuid
user_ocr_info_value[-1] = str(user_ocr_info_value[-1]).replace(
'\"', '\\\"')
la.LOGGER.info('插入bl_UserOcrInfo的值{}'.format(user_ocr_info_value))
# 客户OCR信息表 新增人脸识别数据
mydb.insert(la.DB, 'Tbl_UserOcrInfo',
dict(zip(user_ocr_info_col, user_ocr_info_value)))
user_personal_info_rows = mydb.select_rows(la.DB, 'Tbl_UserPersonalInfo',
'id', ' AND '.join(condtion))
if user_personal_info_rows == 0:
user_personal_info_col = [
'user_person_uuid', 'contract_uuid', 'user_uuid',
'datum_type_marry_id', 'datum_type_education_id',
'datum_type_housing_id', 'live_province', 'live_province_name',
'live_city', 'live_city_name', 'live_region', 'live_region_name',
'live_detail', 'state'
]
user_personal_info_value = mydb.select(
la.DB, 'Tbl_UserPersonalInfo', ','.join(user_personal_info_col))[0]
la.LOGGER.info(
'查询Tbl_UserPersonalInfo的值{}'.format(user_personal_info_value))
user_personal_info_value[0:3] = get_uuid(
uuid.uuid1()), contract_uuid, user_uuid
la.LOGGER.info(
'插入Tbl_UserPersonalInfo的值{}'.format(user_personal_info_value))
# 客户个人信息表 新增和订单关联的数据
mydb.insert(
la.DB, 'Tbl_UserPersonalInfo',
dict(zip(user_personal_info_col, user_personal_info_value)))
user_work_info_rows = mydb.select_rows(la.DB, 'Tbl_UserWorkInfo', 'id',
' AND '.join(condtion))
if user_work_info_rows == 0:
user_work_info_col = [
'user_work_uuid', 'contract_uuid', 'user_uuid', 'company_name',
'position', 'work_phone', 'datum_type_income_id',
'datum_type_worktime_id', 'company_province',
'company_province_name', 'company_city', 'company_city_name',
'company_region', 'company_region_name', 'company_detail', 'state'
]
user_work_info_value = mydb.select(la.DB, 'Tbl_UserWorkInfo',
','.join(user_work_info_col))[0]
la.LOGGER.info('查询Tbl_UserWorkInfo的值{}'.format(user_work_info_value))
user_work_info_value[0:3] = get_uuid(
uuid.uuid1()), contract_uuid, user_uuid
la.LOGGER.info('插入Tbl_UserWorkInfo的值{}'.format(user_work_info_value))
# 客户工作信息表 新增和订单关联的数据
mydb.insert(la.DB, 'Tbl_UserWorkInfo',
dict(zip(user_work_info_col, user_work_info_value)))
user_contact_info_rows = mydb.select_rows(la.DB, 'Tbl_UserContactInfo',
'id', ' AND '.join(condtion))
user_contact_info_col = [
'user_contact_uuid', 'contract_uuid', 'user_uuid', 'name', 'phone',
'datum_type_contact_id', 'state'
]
user_contact_info_value = mydb.select(la.DB, 'Tbl_UserContactInfo',
','.join(user_contact_info_col))[0]
la.LOGGER.info('查询Tbl_UserContactInfo的值{}'.format(user_contact_info_value))
user_contact_info_value[0:3] = get_uuid(
uuid.uuid1()), contract_uuid, user_uuid
if user_contact_info_rows == 0:
# 客户联系人信息表 新增和订单关联的数据
la.LOGGER.info(
'插入Tbl_UserContactInfo的值{}'.format(user_contact_info_value))
mydb.insert(la.DB, 'Tbl_UserContactInfo',
dict(zip(user_contact_info_col, user_contact_info_value)))
elif user_contact_info_rows > 1:
mydb.delete(
la.DB, 'Tbl_UserContactInfo',
"contract_uuid='{0}' AND user_uuid='{1}'".format(
contract_uuid, user_uuid))
la.LOGGER.info(
'插入Tbl_UserContactInfo的值{}'.format(user_contact_info_value))
mydb.insert(la.DB, 'Tbl_UserContactInfo',
dict(zip(user_contact_info_col, user_contact_info_value)))
def del_risks():
# 删除风险点
MysqlClent.delete(DB_CONN, 'fk_risk', 'POSITION("{}" IN name)'.format(loginAction.sign))
