def start():
row_date = 1
andf = 1
fromt = 1
andm = 1
tot =1
bb = ''
file = 'D:\work\code\ctriptest\datebase1.xls'
data = read_excel.open_excel(file)
table = data.sheet_by_name('type')
typelist = []
for row_date in range(1, read_excel.rownum(file,'type')):
bb = table.cell(row_date, read_excel.find_colum(file,'type','keyword')).value
#bb = 'shanghai'
reload(sys)
sys.setdefaultencoding('utf-8')
bb = str(bb)
#time.sleep(2)
aa = urllib.quote(bb)
url = 'http://10.2.25.24:8180/appautocomplete/search?keyword='+aa+'&action=autocomplete&source=globalapp63&lon=121.35801673&lat=31.22016018&districtid=2'
lennum = http.lendate(url)
num = 0
for num in range(lennum):
#print http.get_key_vlue(url,num,"type")
if http.get_key_vlue(url,num,"type") not in typelist:
typelist.append(http.get_key_vlue(url,num,"type"))
print http.get_key_vlue(url,num,"word"), http.get_key_vlue(url,num,"type")
def start():
row_date = 1
andf = 1
fromt = 1
andm = 1
tot =1
bb = ''
file = 'D:\work\code\ctriptest\datebase1.xls'
data = read_excel.open_excel(file)
table = data.sheet_by_name('all')
f = open('ok.txt', 'w')
f1 = open('no1.txt', 'w')
f2 = open('no2.txt', 'w')
f3 = open('no.txt', 'w')
for row_date in range(1, read_excel.rownum(file,'all')):
bb = table.cell(row_date, read_excel.find_colum(file,'all','keyword')).value
#bb = 'shanghai'
reload(sys)
sys.setdefaultencoding('utf-8')
bb = str(bb)
result = Language_result(bb)
time.sleep(1)
if result[0] == "1":
f.write(result[1])
f.write("\n")
else:
f1.write("############################################")
f1.write("\n")
f1.write(result[1])
f1.write("\n")
f1.write("############################################")
f1.write("\n")
f1.write(result[2].replace(",","\n"))
f1.write("\n")
f2.write("############################################")
f2.write("\n")
f2.write(result[1])
f2.write("\n")
f2.write("############################################")
f2.write("\n")
f2.write(result[3].replace(",","\n"))
f2.write("\n")
f3.write(result[1])
f3.write("\n")
f.close()
f1.close()
f2.close()
f3.close()
#b:多保险公司
#c:多保险类型
#k:目的地+多保险公司
#h:目的地+多保险类型
#i:多保险类型+多保险公司
#j:目的地+多保险类型+多保险公司
#测试每条case的errcode，word，insurance，url中含的destination，FeatureList，CompanyList个数和值，mobileweb可以测url跳转后值界面的值是否正确
#输出每个globalapp63的url和keyword，用来跳转用
#报告输出格式为：成功
# 失败：关键字+失败的内容+应该的值+目前的值
###################################################
file = testcasedata.RegressionTestDate()
data = read_excel.open_excel(file)
c = "globalapp64"
#c = "mobileweb"
keyword = ''
def test_case_a(data,c):
keywordvlue = "destination"
#keywordvlue = "CompanyList"
#keywordvlue = "FeatureList"
table = data.sheet_by_name('url')
urlhttp = table.cell(1, read_excel.find_colum(file,'url','url')).value+"action=autocomplete&source=globalapp64&lon=121.35801673&lat=31.22016018&districtid=2"+"&keyword="+keyword
for row_date in range(1, read_excel.rownum(file,'insurance')):
table = data.sheet_by_name('insurance')
bb = table.cell(row_date, read_excel.find_colum(file,'insurance',keywordvlue)).value
reload(sys)
sys.setdefaultencoding('utf-8')
bb = str(bb)