def test_01api_78dk_platform_tm_first_viewFirstCheckContract(self): # 初审信息查询 # {'uid': '合同uuid'} # contract_uuid = '1e9fe3d0be2344e2acfda1a025a607e2' sql = 'contract_uuid="' + contract_uuid + '" and state ="enabled"' channelid = MysqlClent.select(loginAction.DB, 'Tbl_Contract', condition=sql) # print(type(channelid[0]),channelid[0]) # 查询商户名称 sql = 'id="' + str(channelid[0][4]) + '" and state ="enabled"' merchantname = MysqlClent.select_one(loginAction.DB, 'Tbl_MerchantProfile', 'name', sql) # 查询资金包 sql = 'id="' + str(channelid[0][6]) + '" and state ="enabled"' fundname = MysqlClent.select_one(loginAction.DB, 'Tbl_FundPackage', 'name', sql) print(merchantname, fundname, channelid[0][22]) # fundSideName 资方名称 sql = 'select Tbl_FundSide.name from Tbl_FundSide ,Tbl_FundPackage,Tbl_FundSidePackageRelation WHERE ' \ 'Tbl_FundPackage.id={} and Tbl_FundPackage.id=Tbl_FundSidePackageRelation.fund_package_id and ' \ 'Tbl_FundSide.id=Tbl_FundSidePackageRelation.fund_side_id ;'.format(channelid[0][6]) fundsidename = MysqlClent.executed_one(loginAction.DB, sql) res = PlatformAction.test_api_78dk_platform_tm_first_viewFirstCheckContract( contract_uuid) # # 法大大地址: contract_uuidurl = 'select Tbl_ContractInfo.view_url from Tbl_ContractInfo,Tbl_Contract where ' \ 'Tbl_Contract.contract_uuid=\'{}\' and Tbl_Contract.id=Tbl_ContractInfo.contract_id' \ .format(contract_uuid) contract_uuid1 = MysqlClent.executed_one(loginAction.DB, contract_uuidurl) # # 分数 score = 'select score from Tbl_QifaMachineLog where contract_uuid=\'{}\';'.format( contract_uuid) score1 = MysqlClent.executed_all(loginAction.DB, score) # 查询门店信息 storenamesql = 'select Tbl_Store.business_address from Tbl_Store,Tbl_Contract where ' \ 'Tbl_Contract.storm_id={} and Tbl_Contract.storm_id=Tbl_Store.id and ' \ 'Tbl_Contract.contract_uuid=\'{}\';'.format(channelid[0][5], contract_uuid) storename = MysqlClent.executed_all(loginAction.DB, storenamesql) Assertion.verity(json.loads(res)['msg'], '成功') Assertion.verity(json.loads(res)['code'], '10000') Assertion.verity(json.loads(res)['data']['fddUrl'], contract_uuid1) Assertion.verity( json.loads(res)['data']['earlyRepaymentSupport'], channelid[0][21]) Assertion.verity(json.loads(res)['data']['merchantName'], merchantname) # Assertion.verity(json.loads(res)['data']['aliscore'], '550000.00000000') Assertion.verity( json.loads(res)['data']['contractNumber'], channelid[0][8]) Assertion.verity(json.loads(res)['data']['fundPackageName'], fundname) # Assertion.verity(json.loads(res)['data']['score'], str(score1[0][0])) Assertion.verity(json.loads(res)['data']['fundSideName'], fundsidename) # Assertion.verity(json.loads(res)['data']['repaymentMethod'], 'DBDX') # Assertion.verity(json.loads(res)['data']['storeName'], storename[0][0]) # 查询商户贴息费率 discount_rate discountRatesql = 'select discount_rate FROM Tbl_Contract WHERE contract_uuid="{}" ' \ 'and state ="enabled" '.format(contract_uuid) discountRate = MysqlClent.executed_all(loginAction.DB, discountRatesql) print('bbbbbbbbbbbbbbbbb', discountRate) # Assertion.verity(json.loads(res)['data']['discountRate'], discountRate[0][0]) # 查询产品名称 productNamesql = ' select Tbl_ProductDetail.name from Tbl_ProductDetail,Tbl_Contract where ' \ 'Tbl_Contract.product_id=Tbl_ProductDetail.id and Tbl_Contract.contract_uuid=\'{}\'; ' \ .format(contract_uuid) productName = MysqlClent.executed_all(loginAction.DB, productNamesql) Assertion.verity( json.loads(res)['data']['productName'], productName[0][0]) Assertion.verity(json.loads(res)['data']['aliOpinion'], '网商审核通过') # 查询期数信息 loanPeriodssql = 'SELECT loan_periods FROM Tbl_Contract where contract_uuid=\'{}\';'.format( contract_uuid) loanPeriods = MysqlClent.executed_all(loginAction.DB, loanPeriodssql) Assertion.verity( json.loads(res)['data']['loanPeriods'], loanPeriods[0][0]) # 查询个人基本资料 personsql = 'SELECT tpb.* FROM Tbl_Contract tc, Tbl_ContractPersonBasicRelation tcpr, Tbl_PersonBasicInfo tpb ' \ 'where tc.contract_uuid=\'{}\' and tc.id=tcpr.contract_id and tcpr.person_basic_info_id=tpb.id;' \ .format(contract_uuid) person = MysqlClent.executed_all(loginAction.DB, personsql) # Assertion.verity(json.loads(res)['data']['person'], '个人基本资料') Assertion.verity( json.loads(res)['data']['person']['homeType'], person[0][6]) Assertion.verity( json.loads(res)['data']['person']['idCardNumber'], person[0][3]) Assertion.verity( json.loads(res)['data']['person']['immediateFamilyName'], person[0][7]) Assertion.verity( json.loads(res)['data']['person']['immediateFamilyPhone'], person[0][9]) Assertion.verity( json.loads(res)['data']['person']['immediateFamilyRelation'], person[0][8]) Assertion.verity( json.loads(res)['data']['person']['name'], person[0][2]) Assertion.verity( json.loads(res)['data']['person']['phone'], person[0][4]) Assertion.verity( json.loads(res)['data']['person']['typeOfJob'], person[0][5]) # 查询 overdue_handling_fee_rate 逾期手续费率 - 手续费' overdue_handling_fee_ratesql = 'SELECT overdue_handling_fee_rate FROM Tbl_Contract where contract_uuid=\'{}\';' \ .format(contract_uuid) overdueHandlingFeeRate = MysqlClent.executed_all( loginAction.DB, overdue_handling_fee_ratesql) # Assertion.verity(json.loads(res)['data']['overdueHandlingFeeRate'], overdueHandlingFeeRate[0][0]) # 提前还款手续费 earlyRepaymentHandlingFeesql = 'SELECT early_repayment_handling_fee FROM Tbl_Contract where contract_uuid=\'{}\';' \ .format(contract_uuid) earlyRepaymentHandlingFee = MysqlClent.executed_all( loginAction.DB, earlyRepaymentHandlingFeesql) # Assertion.verity(json.loads(res)['data']['earlyRepaymentHandlingFee'], earlyRepaymentHandlingFee[0][0]) # submit_state submitStatesql = 'SELECT submit_state FROM Tbl_Contract where contract_uuid=\'{}\';'.format( contract_uuid) submitState = MysqlClent.executed_all(loginAction.DB, submitStatesql) # Assertion.verity(json.loads(res)['data']['submitState'], submitState[0][0]) # 用户签订日期查询 signingDatesql = 'SELECT signing_date FROM Tbl_Contract where contract_uuid=\'{}\';'.format( contract_uuid) signingDate = MysqlClent.executed_all(loginAction.DB, signingDatesql) # Assertion.verity(json.loads(res)['data']['signingDate'], signingDate[0][0]) # 查询分期手续费率 精度问题 periodRatesql = 'SELECT period_rate FROM Tbl_Contract where contract_uuid=\'{}\';'.format( contract_uuid) periodRate = MysqlClent.executed_all(loginAction.DB, periodRatesql) # Assertion.verity(json.loads(res)['data']['periodRate'], periodRate[0][0]) # 查询宽限期 gracePeriodsql = 'SELECT grace_period FROM Tbl_Contract where contract_uuid=\'{}\';'.format( contract_uuid) gracePeriod = MysqlClent.executed_all(loginAction.DB, gracePeriodsql) # Assertion.verity(json.loads(res)['data']['gracePeriod'], gracePeriod[0][0]) # 查询贷款金额 loan_amount 精度问题 '20000' != Decimal('20000.00000000') loan_amountsql = 'SELECT loan_amount FROM Tbl_Contract where contract_uuid=\'{}\';'.format( contract_uuid) loanAmount = MysqlClent.executed_all(loginAction.DB, loan_amountsql) # Assertion.verity(json.loads(res)['data']['loanAmount'], loanAmount[0][0]) # 查询 逾期手续费率 - 本金 overduePrincipalRatesql = 'SELECT overdue_principal_rate FROM Tbl_Contract where contract_uuid=\'{}\';'.format( contract_uuid) overduePrincipalRate = MysqlClent.executed_all( loginAction.DB, overduePrincipalRatesql) # Assertion.verity(json.loads(res)['data']['overduePrincipalRate'], overduePrincipalRate[0][0]) # 提前还款周期 earlyRepaymentFreeCyclesql = 'SELECT early_repayment_free_cycle FROM Tbl_Contract where contract_uuid=\'{}\';'.format( contract_uuid) earlyRepaymentFreeCycle = MysqlClent.executed_all( loginAction.DB, earlyRepaymentFreeCyclesql) # 支付宝审核日志 alipayAuditLogssql = 'SELECT talog.opinion,talog.alipay_audit FROM Tbl_Contract tc ,Tbl_AlipayAuditLog talog ' \ 'where tc.contract_uuid=\'{}\' and talog.contract_id=tc.id;'.format(contract_uuid) alipayAuditLogs = MysqlClent.executed_all(loginAction.DB, alipayAuditLogssql) Assertion.verity( json.loads(res)['data']['alipayAuditLogs']['opinion'], alipayAuditLogs[0][0]) # 影响资料信息 contractImagessql = 'SELECT tcim.* FROM Tbl_Contract tc ,Tbl_ContractImage tcim where tc.contract_uuid=\'{}\'' \ ' and tc.id=tcim.contract_id ORDER BY tcim.id ASC;'.format(contract_uuid) contractImages = MysqlClent.executed_all(loginAction.DB, contractImagessql) # 身份证照片(正面) Assertion.verity( json.loads(res)['data']['contractImages'][0]['key'], contractImages[0][4]) Assertion.verity( json.loads(res)['data']['contractImages'][0]['keyName'], contractImages[0][6]) # 身份证照片(反面) Assertion.verity( json.loads(res)['data']['contractImages'][1]['key'], contractImages[1][4]) Assertion.verity( json.loads(res)['data']['contractImages'][1]['keyName'], contractImages[1][6])
def get_permission_id(): # 返回一个 id = mydb.executed_one(conn=DB_CONN, query='select {} from {}'.format( 'id', 'Tbl_Role_Permission')) return id