def init_sqlfield(f,sheetname):
sqlfield=[]
try:
field_list=open_excel.excel_table_by_name(f,by_name = sheetname)
for i in field_list:
if i['VERIFY'] == 'y' or i['VERIFY'] == 'Y':
#i['SQLCMD'] = field_list[1]['SQLCMD']
#i['DestroyData'] = field_list[1]['DestroyData']
#i['FIELD1_VALUE'] = field_list[1]['field1_value']
sqlfield.append(i)
except Exception, e:
print e
log.error('%s' %e)
return sqlfield
def init(file):
'''解析excel文件用例'''
log.info('解析excel文件数据')
cases_list=[]
try:
module_list=open_excel.excel_table_by_index(file)
except Exception, e:
print e
log.error('%s文件打开失败'%file)
log.info('解析excel文件接口模块对应的表单数据')
for m in module_list:
if m['Flag']==u'√':
try:
case_list=open_excel.excel_table_by_name(file,by_name=m['Module'])
except Exception, e:
print e
log.error('找不到接口模块对应的用例表单%s'%m['Module'])
if m['SQL_FILE']:
f=CURRENT_PATH+'data'+os.path.sep+"ews_sql_fields"+os.path.sep+str(m['SQL_FILE'])
sqlfield=init_sqlfield(f)
else:
sqlfield=None
for case in case_list:
if not case['TestCaseName']==u'用例名称':
case['URL']=m['URL']
case['SQLFIELD']=sqlfield
case['SQLConfig']=m['SQLConfig']
#case['password']=m['password']
def init(file):
'''解析excel文件用例'''
log.info('解析excel文件数据')
cases_list=[]
try:
interface_list=open_excel.excel_table_by_index(file)
except Exception, e:
print e
log.error('%s文件打开失败' %file)
log.info('解析excel文件接口模块对应的表单数据')
for m in interface_list:
if m['FLAG']=='Y' or m['FLAG']=='y':
try:
case_list=open_excel.excel_table_by_name(file,by_name=m['INTER_NAME'])
except Exception, e:
print e
log.error('找不到接口模块对应的用例表单%s'%m['INTER_NAME'])
if m['SQL_FILE']:
f=CURRENT_PATH + 'data' + os.path.sep + "ice_sql_fields" + os.path.sep + 'output_param.xls'
sqlfield=init_sqlfield(f,m['SQL_FILE'])
else:
sqlfield=None
for case in case_list:
if not case['TestCaseName']=='用例名称':
case['INTER_NAME']=m['INTER_NAME']
case['CONNECT']=m['CONNECT']
case['SQLFIELD']=sqlfield
