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