def query_scanmock_result(barcode):
u'''
功能描述: MOCK结果查询
'''
result = Result()
try:
sqltest = RHOracle(
usr=EnvSetting.WEB_DEFAULT_DIC["uw"]["db_dbcheck_usr"],
pwd=EnvSetting.WEB_DEFAULT_DIC["uw"]["db_pwd"],
ip=EnvSetting.WEB_DEFAULT_DIC["uw"]["db_host"],
port=EnvSetting.WEB_DEFAULT_DIC["uw"]["db_port"],
db=EnvSetting.WEB_DEFAULT_DIC["uw"]["db_name"])
sql = EnvSetting.SQL_DIC["UW_SCANMOCK_RESULT"] % barcode + "%'"
result.flag = sqltest.check_query_count(sql)
# logger.info("SQL scanmock query success,result: " + str(result.flag))
except Exception, e:
print e
def uw_query_ins_or_prem(apply_bar_code, dic_args):
u'''
功能描述: 查询保费保额
'''
try:
sqltest = RHOracle(
usr=EnvSetting.WEB_DEFAULT_DIC["uw"]["db_dbcheck_usr"],
pwd=EnvSetting.WEB_DEFAULT_DIC["uw"]["db_pwd"],
ip=EnvSetting.WEB_DEFAULT_DIC["uw"]["db_host"],
port=EnvSetting.WEB_DEFAULT_DIC["uw"]["db_port"],
db=EnvSetting.WEB_DEFAULT_DIC["uw"]["db_name"])
sql_applyno = EnvSetting.SQL_DIC["UW_QUERY_APPLY_NO"] % (
apply_bar_code)
apply_no = sqltest.fetchone_query(sql_applyno)[0]
product_num = len(
sqltest.fetchall_query(
EnvSetting.SQL_DIC["UW_QUERY_INS_AND_PREM"] %
('sum_insured', apply_no)))
dic_args["sumInsured"] = unicode(
sqltest.fetchone_query(
EnvSetting.SQL_DIC["UW_QUERY_INS_AND_PREM"] %
('sum_insured', apply_no))[0])
dic_args["mainAnnStandardPrem"] = unicode(
sqltest.fetchone_query(
EnvSetting.SQL_DIC["UW_QUERY_INS_AND_PREM"] %
('ann_standard_prem', apply_no))[0])
dic_args["fillInPrem"] = dic_args["mainAnnStandardPrem"]
k = 2
while k < product_num + 1:
dic_args["addSumInsured%s" % (k - 2)] = unicode(
sqltest.fetchone_query(
EnvSetting.SQL_DIC["UW_QUERY_INS_AND_PREM"] %
('sum_insured', apply_no) + " and prod_seq='%s'" % k)[0])
dic_args["addAnnStandardPrem%s" % (k - 2)] = unicode(
sqltest.fetchone_query(
EnvSetting.SQL_DIC["UW_QUERY_INS_AND_PREM"] %
('ann_standard_prem', apply_no) +
" and prod_seq='%s'" % k)[0])
dic_args["fillInPrem"] = unicode(
float(dic_args["fillInPrem"]) +
float(dic_args["addAnnStandardPrem%s" % (k - 2)]))
k = k + 1
except Exception, e:
print e
def dml_sql(sql_list, db_usr, db_pwd, db_ip, db_name, param=[]):
sqlobj = RHOracle(usr=db_usr, pwd=db_pwd, ip=db_ip, db=db_name)
sqlobj.execute_rollback_sql(sql_list, param)
def check_sql(sql_list, db_usr, db_pwd, db_ip, db_name, param=[]):
sqlobj = RHOracle(usr=db_usr, pwd=db_pwd, ip=db_ip, db=db_name)
result = sqlobj.execute_query_many(sql_list, param)
return result
def generate_applyno():
sql = "select nbucde.l_uw_bia_interface.get_dummy_apply_bar_code('02','01') as applyno from dual"
default_dic = EnvSetting.ENV_DEF_DIC
sqlobj = RHOracle(usr=default_dic.get("db_bia_usr"), ip=default_dic.get("db_ip"))
result = sqlobj.fetchone_query(sql)[0]
return result
def fin_check(pono, db_usr, db_pwd, db_ip, db_name):
sqlobj = RHOracle(usr=db_usr, pwd=db_pwd, ip=db_ip, db=db_name)
result = sqlobj.fin_check(pono)
return result
def biab_to_core(pono, db_usr, db_pwd, db_ip, db_name):
sqlobj = RHOracle(usr=db_usr, pwd=db_pwd, ip=db_ip, db=db_name)
result = sqlobj.biab_to_core_batch(pono)
return result
def connect_db(version, sid):
sqlobj = RHOracle(usr=EnvSetting.ENV_DB_DIC.get(sid)["db_usr"],
pwd=EnvSetting.ENV_DB_DIC.get(sid)["db_pwd"],
ip=EnvSetting.VERSION.get(version)[sid + "_db_ip"],
db=EnvSetting.ENV_DB_DIC.get(sid)["db_name"])
return sqlobj