def test_wuliu_testcase08_citylist_diaoduquery_crud(self): driver = self.driver driver.get(self.base_url + "/") loginclick=driver.find_element_by_css_selector("div#container.container h3.text-center.text-primary a.btn.btn-success.text-center") ActionChains(driver).double_click(loginclick).perform() driver.find_element_by_id("username").clear() driver.find_element_by_id("username").send_keys(USER_NAME) driver.find_element_by_id("password").clear() driver.find_element_by_id("password").send_keys(PASS_WORD) driver.find_element_by_id("login-submit").click() time.sleep(2) #driver.find_element_by_css_selector("div.container nav.collapse.navbar-collapse.bs-navbar-collapse ul.nav.navbar-nav li:nth-child(8).active a").click() #driver.find_element_by_css_selector("div.container > nav > ul > li:nth-child("+str(9)+") >a").click() driver.find_element_by_css_selector("div.container > nav > ul > li:nth-child("+appobjectwuliu.wuliutabnine_citylist+") >a").click() time.sleep(1) conn=MySQLdb.connect(host=mysqlhostname,user=mysqlusername,passwd=mysqlpassword,db=mysqlrongchangdb,charset="utf8") global cursor cursor = conn.cursor() self.assertEqual(driver.title, u"物流") #driver.find_element_by_link_text(u"新建城市").click() #driver.find_elements_by_css_selector("div#container.container a.btn.btn-infos").click() '''driver.find_element_by_xpath("/html/body/div/a").click() time.sleep(1) cityidname=driver.find_element_by_css_selector("div#container.container div.panel.panel-primary div.panle-body div.orders_container form#new_map_city.form-horizontal.new_map_city div.form-inputs div.form-group.select.required.map_city_api_city_id div.col-sm-8 select#map_city_api_city_id.select.required.form-control option:nth-child(2)").text print cityidname Select(driver.find_element_by_id("map_city_api_city_id")).select_by_visible_text(cityidname) driver.find_element_by_id("map_city_center_lat").clear() driver.find_element_by_id("map_city_center_lat").send_keys("-5") driver.find_element_by_id("map_city_center_lng").clear() driver.find_element_by_id("map_city_center_lng").send_keys("-3") driver.find_element_by_id("map_city_search_radius").clear() driver.find_element_by_id("map_city_search_radius").send_keys("-5") driver.find_element_by_id("map_city_gaode_map_code").clear() driver.find_element_by_id("map_city_gaode_map_code").send_keys("beijinggaode") driver.find_element_by_name("commit").click() time.sleep(1) #self.assertTrue(driver.title, u"物流") self.assertEqual(driver.title, u"物流") addsuccess=driver.find_element_by_css_selector("div#container.container div.alert.fade.in.alert-success").text print addsuccess''' #shtml body div#container.container>div:nth-child(2)>a.btn.btn-default time.sleep(1) driver.find_element_by_css_selector("div.container nav.collapse.navbar-collapse.bs-navbar-collapse ul.nav.navbar-nav li:nth-child("+appobjectwuliu.wuliutabnine_citylist+").active a").click() self.assertEqual(driver.title, u"物流") driver.find_element_by_css_selector("div#container.container div.panel.panel-primary.checkout-order table.table.table-striped.city-table tbody tr:nth-child(2) td:nth-child(2).btn-link a:nth-child(2)").click() #.btn.btn-success self.assertEqual(driver.title, u"物流") cursor.execute("UPDATE ims_washing_order SET fanxidan_id='0',status_delivery='3',STATUS='7',paytype='1' WHERE ordersn='"+wuliu_utiltools.ordersnnumber+"'") conn.commit() # n = cursor.execute("SELECT ordersn ,username,tel,address ,status_delivery,STATUS ,fanxidan_id FROM ims_washing_order WHERE status_delivery='3' AND ordersn='"+wuliu_utiltools.ordersnnumber+"'") # for i in xrange(cursor.rowcount): # ordersn ,username,tel,address,status_delivery,STATUS ,fanxidan_id = cursor.fetchone() # print ordersn ,username,tel,address,status_delivery,STATUS ,fanxidan_id # # driver.find_element_by_id("order_search_form_ordersn").clear() # driver.find_element_by_id("order_search_form_ordersn").send_keys(wuliu_utiltools.ordersnnumber) Select(driver.find_element_by_id("order_search_form_delivery_status")).select_by_visible_text(u"客户签收") driver.find_element_by_name("commit").click() time.sleep(1) #html body div#container.container div.checkout-order div.panle-body div.panel.panel-primary form.form-horizontal.batch_update table.table.table-striped tbody tr:first-child td:nth-child(2) a queryordernumber=driver.find_element_by_css_selector("div#container.container div.checkout-order div.panle-body div.panel.panel-primary form.form-horizontal.batch_update table.table.table-striped tbody tr:first-child td:nth-child(2) a ").text print " the queryordernumber is ",queryordernumber time.sleep(1) driver.find_element_by_link_text(queryordernumber).click() time.sleep(1) winBeforeHandle = driver.current_window_handle print "winBeforeHandle==",winBeforeHandle winHandles = driver.window_handles print "winHandles==",winHandles for handle in winHandles: if winBeforeHandle != handle: driver.switch_to_window(handle) driver.find_element_by_xpath("//div[@id='container']/div/div[4]/div/div/div[2]/div/div/button").click() time.sleep(2) if EC.alert_is_present: print("Alert exists") alert=self.driver.switch_to_alert() #sprint "alert.text",(alert.text)# alert.accept print("Alert accepted") else: print("NO alert exists") # winBeforeHandle = driver.current_window_handle # print "winBeforeHandle==",winBeforeHandle # winHandles = driver.window_handles # print "winHandles==",winHandles # for handle in winHandles: # if winBeforeHandle != handle: # driver.switch_to_window(handle) #print " the dialog windows is ",driver.switch_to_alert() ''' driver.execute_script("var doc=document.getElementsByClassName('wuliu_form modal fade');doc.setAttribute('aria-hidden','');") if EC.alert_is_present: print("Alert exists") alert=self.driver.switch_to_alert() #sprint "alert.text",(alert.text)# alert.accept print("Alert accepted") else: print("NO alert exists") #driver.switch_to_alert().accept() time.sleep(2) #Alert alert =driver.switchTo().alert(); wuliudiaodumodify=driver.find_element_by_css_selector("html body.modal-open div#container.container div.alert.fade.in.alert-success").text print " the wuliudiaodumodify is ",wuliudiaodumodify time.sleep(1) # driver.find_element_by_id("kehu_message_form_username").clear() # driver.find_element_by_id("kehu_message_form_username").send_keys(u"监控w23311") # driver.find_element_by_id("kehu_message_form_tel").clear() # driver.find_element_by_id("kehu_message_form_tel").send_keys("16155555555111") # time.sleep(1) # driver.find_element_by_css_selector("#new_kehu_message_form_2822532 > div.text-center > input[name=\"commit\"]").click() # driver.find_element_by_css_selector("#new_kehu_message_form_2822532 > div.text-center > input[name=\"commit\"]").click() # driver.find_element_by_css_selector("#new_kehu_message_form_2822532 > div.text-center > input[name=\"commit\"]").click() # time.sleep(1) # driver.find_element_by_xpath("(//button[@type='button'])[3]").click() # driver.find_element_by_name("commit").click() time.sleep(1) #self.assertTrue(driver.title, u"物流") self.assertEqual(driver.title, u"物流") #driver.find_element_by_css_selector("div#container.container> div#paidan_list_container> div.panel.panel-primary.tab-content> div>form> table.table> tbody tr:first-child> td:nth-child(2)> a").click() driver.find_element_by_css_selector("div#container.container div.checkout-order div.panle-body div.panel.panel-primary form.form-horizontal.batch_update table.table.table-striped tbody tr:first-child td:nth-child(2) a").click() #html body div#container.container div.checkout-order div.panle-body div.panel.panel-primary form.form-horizontal.batch_update table.table.table-striped tbody tr:first-child td:nth-child(2) a #html body div#container.container div#paidan_list_container div.panel.panel-primary.tab-content div#order_1039373 form#form_1039373.single_order_form table.table tbody tr:first-child td:nth-child(2) a #cursor.execute("UPDATE ims_washing_order SET status_delivery='3' ,STATUS='1' ,fanxidan_id=0 WHERE ordersn='"+ordersn+"'") #n = cursor.execute("SELECT ordersn ,username,tel,address ,status_delivery,STATUS ,fanxidan_id FROM ims_washing_order WHERE status_delivery=3 AND fanxidan_id=0 AND bagsn IS NOT NULL AND id=(SELECT MIN(id) FROM ims_washing_order) ORDER BY id") #for i in xrange(cursor.rowcount): # ordersn ,username,tel,address,status_delivery,STATUS ,fanxidan_id = cursor.fetchone() #print ordersn ,username,tel,address,status_delivery,STATUS ,fanxidan_id #print driver.title #cursor.execute("DELETE FROM map_cities WHERE gaode_map_code LIKE 'beijinggaode%'") # winBeforeHandle = driver.current_window_handle # print "winBeforeHandle==",winBeforeHandle # winHandles = driver.window_handles # print "winHandles==",winHandles # for handle in winHandles: # if winBeforeHandle != handle: # driver.switch_to_window(handle) # #/html/body/div[1]/form/table/tbody/tr[11]/td[2]/input ''' #self.assertTrue(driver.title, u"物流") self.assertEqual(driver.title, u"物流") cursor.execute("UPDATE ims_washing_order SET fanxidan_id='0',paytype='1',pay_status='1',fan_id='"+wuliu_utiltools.fansfanidnumber+"',status_delivery='3' WHERE ordersn='"+wuliu_utiltools.ordersnnumber+"'") conn.commit() wuliuconn=MySQLdb.connect(host=mysqlhostname,user=mysqlusername,passwd=mysqlpassword,db=mysqlwuliudb,charset="utf8") global wuliucursor wuliucursor = wuliuconn.cursor() wuliucursor.execute("DELETE FROM map_cities WHERE gaode_map_code LIKE 'beijinggaode%'") wuliuconn.commit() wuliucursor.close() cursor.close() wuliuconn.close() conn.close() wuliu_utiltools.getcloseconn()
def test_wuliu_testcase00_EditSitePermission(self): driver = self.driver driver.get(self.base_url + "/") loginclick = driver.find_element_by_css_selector( "div#container.container h3.text-center.text-primary a.btn.btn-success.text-center" ) ActionChains(driver).double_click(loginclick).perform() driver.find_element_by_id("username").clear() driver.find_element_by_id("username").send_keys(USER_NAME) driver.find_element_by_id("password").clear() driver.find_element_by_id("password").send_keys(PASS_WORD) driver.find_element_by_id("login-submit").click() print " the testcase WuliuTestcase00EditSitePermission is ", driver.title self.assertEqual(driver.title, u"物流") time.sleep(2) wuliu_utiltools.updateSignNumber() driver.find_element_by_css_selector( "div.container nav.collapse.navbar-collapse.bs-navbar-collapse ul.nav.navbar-nav li:nth-child(1).dropdown a" ).click() self.assertEqual(driver.title, u"物流") driver.find_element_by_xpath( "/html/body/header/div/nav/ul/li[1]/ul/li[1]/a").click() self.assertEqual(driver.title, u"物流") driver.find_element_by_id("bagsn").clear() driver.find_element_by_id("bagsn").send_keys( wuliu_utiltools.signbagnumber) driver.find_element_by_name("commit").click() self.assertEqual(driver.title, u"物流") time.sleep(2) #html body div#container.container div.panel.panel-primary p.text-center b#check_in_msg qianshouresult = driver.find_element_by_css_selector( "div#container.container>div.panel.panel-primary>p.text-center>b#check_in_msg" ).text print " the qianshouresult failed is ", qianshouresult assert u"签收失败!" in qianshouresult # qianshou success for 00 permission conn = MySQLdb.connect(host=mysqlhostname, user=mysqlusername, passwd=mysqlpassword, db=mysqlrongchangdb, charset="utf8") global cursor cursor = conn.cursor() cursor.execute( "UPDATE ims_washing_order SET status_delivery='1' ,qianshoudian_id= NULL WHERE bagsn='E0000000006'" ) conn.commit() n = cursor.execute( "SELECT ordersn,bagsn,status_delivery,jiagongdian_id,qianshoudian_id FROM ims_washing_order WHERE bagsn='E0000000006'" ) for i in xrange(cursor.rowcount): ordersn, bagsn, status_delivery, jiagongdian_id, qianshoudian_id = cursor.fetchone( ) print ordersn, bagsn, status_delivery, jiagongdian_id, qianshoudian_id time.sleep(1) driver.find_element_by_id("bagsn").clear() driver.find_element_by_id("bagsn").send_keys(bagsn) driver.find_element_by_name("commit").click() self.assertEqual(driver.title, u"物流") qianshouresult = driver.find_element_by_css_selector( "div#container.container>div.panel.panel-primary>p.text-center>b#check_in_msg" ).text print " the qianshouresult success is ", qianshouresult # assert u"签收成功!" in qianshouresult time.sleep(2) driver.find_element_by_link_text(u"站点出入库管理").click() driver.find_element_by_link_text(u"出库").click() driver.find_element_by_id("order_key").clear() driver.find_element_by_id("order_key").send_keys("E0000000006") driver.find_element_by_name("commit").click() self.assertEqual(driver.title, u"物流") # zhandianchukuresult=driver.find_element_by_css_selector("html body div#container.container div.panel.panel-primary p.text-center b#check_in_msg").text # print " the zhandianchukuresult null is ",zhandianchukuresult # assert u"出库成功" in zhandianchukuresult time.sleep(2) # driver.find_element_by_link_text(u"站点出入库管理").click() # driver.find_element_by_link_text(u"出库").click() # driver.find_element_by_id("order_key").clear() # driver.find_element_by_id("order_key").send_keys("") # driver.find_element_by_name("commit").click() zhandianchukuresult = driver.find_element_by_css_selector( "html body div#container.container div.panel.panel-primary p.text-center b#check_in_msg" ).text print " the zhandianchukuresult null is ", zhandianchukuresult assert u"出库成功" in zhandianchukuresult time.sleep(2) driver.find_element_by_link_text(u"站点出入库管理").click() driver.find_element_by_link_text(u"出入库查询").click() # driver.find_element_by_name("commit").click() self.assertEqual(driver.title, u"物流") Select(driver.find_element_by_id( "in_out_type")).select_by_visible_text(u"出库") driver.find_element_by_name("commit").click() self.assertEqual(driver.title, u"物流") Select(driver.find_element_by_id( "target_type")).select_by_visible_text(u"加工店") driver.find_element_by_name("commit").click() self.assertEqual(driver.title, u"物流") wuliu_utiltools.getcloseconn()
def test_wuliu_testcase08_citylist_diaoduquery_fanxidan(self): driver = self.driver driver.get(self.base_url + "/") loginclick = driver.find_element_by_css_selector( "div#container.container h3.text-center.text-primary a.btn.btn-success.text-center" ) ActionChains(driver).double_click(loginclick).perform() driver.find_element_by_id("username").clear() driver.find_element_by_id("username").send_keys(USER_NAME) driver.find_element_by_id("password").clear() driver.find_element_by_id("password").send_keys(PASS_WORD) driver.find_element_by_id("login-submit").click() time.sleep(2) #driver.find_element_by_css_selector("div.container nav.collapse.navbar-collapse.bs-navbar-collapse ul.nav.navbar-nav li:nth-child(8).active a").click() driver.find_element_by_css_selector( "div.container > nav > ul > li:nth-child(8) >a").click() time.sleep(1) conn = MySQLdb.connect(host=mysqlhostname, user=mysqlusername, passwd=mysqlpassword, db=mysqlrongchangdb, charset="utf8") global cursor cursor = conn.cursor() self.assertEqual(driver.title, u"物流") #driver.find_element_by_link_text(u"新建城市").click() #driver.find_elements_by_css_selector("div#container.container a.btn.btn-infos").click() driver.find_element_by_xpath("/html/body/div/a").click() time.sleep(1) cityidname = driver.find_element_by_css_selector( "div#container.container div.panel.panel-primary div.panle-body div.orders_container form#new_map_city.form-horizontal.new_map_city div.form-inputs div.form-group.select.required.map_city_api_city_id div.col-sm-8 select#map_city_api_city_id.select.required.form-control option:nth-child(2)" ).text print cityidname Select(driver.find_element_by_id( "map_city_api_city_id")).select_by_visible_text(cityidname) driver.find_element_by_id("map_city_center_lat").clear() driver.find_element_by_id("map_city_center_lat").send_keys("-5") driver.find_element_by_id("map_city_center_lng").clear() driver.find_element_by_id("map_city_center_lng").send_keys("-3") driver.find_element_by_id("map_city_search_radius").clear() driver.find_element_by_id("map_city_search_radius").send_keys("-5") driver.find_element_by_id("map_city_gaode_map_code").clear() driver.find_element_by_id("map_city_gaode_map_code").send_keys( "beijinggaode") driver.find_element_by_name("commit").click() time.sleep(1) #self.assertTrue(driver.title, u"物流") self.assertEqual(driver.title, u"物流") addsuccess = driver.find_element_by_css_selector( "div#container.container div.alert.fade.in.alert-success").text print addsuccess #shtml body div#container.container>div:nth-child(2)>a.btn.btn-default time.sleep(1) driver.find_element_by_css_selector( "div.container nav.collapse.navbar-collapse.bs-navbar-collapse ul.nav.navbar-nav li:nth-child(8).active a" ).click() self.assertEqual(driver.title, u"物流") driver.find_element_by_css_selector( "div#container.container div.panel.panel-primary.checkout-order table.table.table-striped.city-table tbody tr:nth-child(2) td:nth-child(2).btn-link a:nth-child(2)" ).click() #.btn.btn-success self.assertEqual(driver.title, u"物流") cursor.execute( "UPDATE ims_washing_order SET fanxidan_id='0',status_delivery='3',STATUS='7',paytype='1' WHERE ordersn='" + wuliu_utiltools.ordersnnumber + "'") conn.commit() n = cursor.execute( "SELECT ordersn ,username,tel,address ,status_delivery,STATUS ,fanxidan_id FROM ims_washing_order WHERE status_delivery='3' AND ordersn='" + wuliu_utiltools.ordersnnumber + "'") for i in xrange(cursor.rowcount): ordersn, username, tel, address, status_delivery, STATUS, fanxidan_id = cursor.fetchone( ) print ordersn, username, tel, address, status_delivery, STATUS, fanxidan_id driver.find_element_by_id("order_search_form_ordersn").clear() driver.find_element_by_id("order_search_form_ordersn").send_keys( wuliu_utiltools.ordersnnumber) driver.find_element_by_name("commit").click() time.sleep(1) #self.assertTrue(driver.title, u"物流") self.assertEqual(driver.title, u"物流") #driver.find_element_by_css_selector("div#container.container> div#paidan_list_container> div.panel.panel-primary.tab-content> div>form> table.table> tbody tr:first-child> td:nth-child(2)> a").click() driver.find_element_by_css_selector( "div#container.container div.checkout-order div.panle-body div.panel.panel-primary form.form-horizontal.batch_update table.table.table-striped tbody tr:first-child td:nth-child(2) a" ).click() #html body div#container.container div.checkout-order div.panle-body div.panel.panel-primary form.form-horizontal.batch_update table.table.table-striped tbody tr:first-child td:nth-child(2) a #html body div#container.container div#paidan_list_container div.panel.panel-primary.tab-content div#order_1039373 form#form_1039373.single_order_form table.table tbody tr:first-child td:nth-child(2) a #cursor.execute("UPDATE ims_washing_order SET status_delivery='3' ,STATUS='1' ,fanxidan_id=0 WHERE ordersn='"+ordersn+"'") #n = cursor.execute("SELECT ordersn ,username,tel,address ,status_delivery,STATUS ,fanxidan_id FROM ims_washing_order WHERE status_delivery=3 AND fanxidan_id=0 AND bagsn IS NOT NULL AND id=(SELECT MIN(id) FROM ims_washing_order) ORDER BY id") #for i in xrange(cursor.rowcount): # ordersn ,username,tel,address,status_delivery,STATUS ,fanxidan_id = cursor.fetchone() #print ordersn ,username,tel,address,status_delivery,STATUS ,fanxidan_id #print driver.title #cursor.execute("DELETE FROM map_cities WHERE gaode_map_code LIKE 'beijinggaode%'") # winBeforeHandle = driver.current_window_handle # print "winBeforeHandle==",winBeforeHandle # winHandles = driver.window_handles # print "winHandles==",winHandles # for handle in winHandles: # if winBeforeHandle != handle: # driver.switch_to_window(handle) # self.assertEqual(driver.title, u"物流") time.sleep(1) driver.find_element_by_css_selector( "div#container.container>a#fanxi_button.btn.btn-info").click() driver.find_element_by_xpath("//*[@id='fanxi_button']").click() #driver.find_element_by_css_selector("div#container.container>a#fanxi_button.btn.btn-info").click() # html body div#container.container a#f''anxi_button.btn.btn-info time.sleep(1) self.assertEqual(driver.title, u"物流") #html body div#container.container a#fanxi_button.btn.btn-info #submit to database fanxiwashingtime = driver.find_element_by_xpath( "/html/body/div[1]/form/table/tbody/tr[8]/td[2]/div/div/select/option[2]" ).text #fanxiwashingtime=driver.find_element_by_css_selector("div#container.container form#new_fanxi_order_form_1039230.form-horizontal.new_fanxi_order_form table.table.table-striped.search-table tbody tr:nth-last-child(4) td:last-child div.form-group.select.required.fanxi_order_form_washing_time div.col-sm-8 select#fanxi_order_form_washing_time.select.required.form-control option:nth-child(2)").text print " the fanxiwashingtime is ", fanxiwashingtime Select(driver.find_element_by_id("fanxi_order_form_washing_time") ).select_by_visible_text(fanxiwashingtime) driver.find_element_by_id("fanxi_order_form_remark").clear() driver.find_element_by_id("fanxi_order_form_remark").send_keys( "beijingjiangtailu") driver.find_element_by_id("fanxi_order_form_washing_date").clear() driver.find_element_by_id("fanxi_order_form_washing_date").send_keys( str(wuliu_utiltools.get_day_of_day(2))) #driver.find_element_by_css_selector("div#container.container form#new_fanxi_order_form_254.form-horizontal.new_fanxi_order_form table.table.table-striped.search-table tbody tr:last-child td:last-child input.button.btn.btn-info.btn-style-width").click() driver.find_element_by_xpath("//input[@type='submit']").click() #/html/body/div[1]/form/table/tbody/tr[11]/td[2]/input #self.assertTrue(driver.title, u"物流") self.assertEqual(driver.title, u"物流") cursor.execute( "UPDATE ims_washing_order SET fanxidan_id='0',paytype='1',pay_status='1',fan_id='" + wuliu_utiltools.fansfanidnumber + "',status_delivery='3' WHERE ordersn='" + wuliu_utiltools.ordersnnumber + "'") conn.commit() wuliuconn = MySQLdb.connect(host=mysqlhostname, user=mysqlusername, passwd=mysqlpassword, db=mysqlwuliudb, charset="utf8") global wuliucursor wuliucursor = wuliuconn.cursor() wuliucursor.execute( "DELETE FROM map_cities WHERE gaode_map_code LIKE 'beijinggaode%'" ) wuliuconn.commit() wuliucursor.close() cursor.close() wuliuconn.close() conn.close() wuliu_utiltools.getcloseconn()
def test_wuliu_testcase08_citylist_diaoduquery_fanxidan(self): driver = self.driver driver.get(self.base_url + "/") loginclick=driver.find_element_by_css_selector("div#container.container h3.text-center.text-primary a.btn.btn-success.text-center") ActionChains(driver).double_click(loginclick).perform() driver.find_element_by_id("username").clear() driver.find_element_by_id("username").send_keys(USER_NAME) driver.find_element_by_id("password").clear() driver.find_element_by_id("password").send_keys(PASS_WORD) driver.find_element_by_id("login-submit").click() time.sleep(2) #driver.find_element_by_css_selector("div.container nav.collapse.navbar-collapse.bs-navbar-collapse ul.nav.navbar-nav li:nth-child(8).active a").click() driver.find_element_by_css_selector("div.container > nav > ul > li:nth-child(8) >a").click() time.sleep(1) conn=MySQLdb.connect(host=mysqlhostname,user=mysqlusername,passwd=mysqlpassword,db=mysqlrongchangdb,charset="utf8") global cursor cursor = conn.cursor() self.assertEqual(driver.title, u"物流") #driver.find_element_by_link_text(u"新建城市").click() #driver.find_elements_by_css_selector("div#container.container a.btn.btn-infos").click() driver.find_element_by_xpath("/html/body/div/a").click() time.sleep(1) cityidname=driver.find_element_by_css_selector("div#container.container div.panel.panel-primary div.panle-body div.orders_container form#new_map_city.form-horizontal.new_map_city div.form-inputs div.form-group.select.required.map_city_api_city_id div.col-sm-8 select#map_city_api_city_id.select.required.form-control option:nth-child(2)").text print cityidname Select(driver.find_element_by_id("map_city_api_city_id")).select_by_visible_text(cityidname) driver.find_element_by_id("map_city_center_lat").clear() driver.find_element_by_id("map_city_center_lat").send_keys("-5") driver.find_element_by_id("map_city_center_lng").clear() driver.find_element_by_id("map_city_center_lng").send_keys("-3") driver.find_element_by_id("map_city_search_radius").clear() driver.find_element_by_id("map_city_search_radius").send_keys("-5") driver.find_element_by_id("map_city_gaode_map_code").clear() driver.find_element_by_id("map_city_gaode_map_code").send_keys("beijinggaode") driver.find_element_by_name("commit").click() time.sleep(1) #self.assertTrue(driver.title, u"物流") self.assertEqual(driver.title, u"物流") addsuccess=driver.find_element_by_css_selector("div#container.container div.alert.fade.in.alert-success").text print addsuccess #shtml body div#container.container>div:nth-child(2)>a.btn.btn-default time.sleep(1) driver.find_element_by_css_selector("div.container nav.collapse.navbar-collapse.bs-navbar-collapse ul.nav.navbar-nav li:nth-child(8).active a").click() self.assertEqual(driver.title, u"物流") driver.find_element_by_css_selector("div#container.container div.panel.panel-primary.checkout-order table.table.table-striped.city-table tbody tr:nth-child(2) td:nth-child(2).btn-link a:nth-child(2)").click() #.btn.btn-success self.assertEqual(driver.title, u"物流") cursor.execute("UPDATE ims_washing_order SET fanxidan_id='0',status_delivery='3',STATUS='7',paytype='1' WHERE ordersn='"+wuliu_utiltools.ordersnnumber+"'") conn.commit() n = cursor.execute("SELECT ordersn ,username,tel,address ,status_delivery,STATUS ,fanxidan_id FROM ims_washing_order WHERE status_delivery='3' AND ordersn='"+wuliu_utiltools.ordersnnumber+"'") for i in xrange(cursor.rowcount): ordersn ,username,tel,address,status_delivery,STATUS ,fanxidan_id = cursor.fetchone() print ordersn ,username,tel,address,status_delivery,STATUS ,fanxidan_id driver.find_element_by_id("order_search_form_ordersn").clear() driver.find_element_by_id("order_search_form_ordersn").send_keys(wuliu_utiltools.ordersnnumber) driver.find_element_by_name("commit").click() time.sleep(1) #self.assertTrue(driver.title, u"物流") self.assertEqual(driver.title, u"物流") #driver.find_element_by_css_selector("div#container.container> div#paidan_list_container> div.panel.panel-primary.tab-content> div>form> table.table> tbody tr:first-child> td:nth-child(2)> a").click() driver.find_element_by_css_selector("div#container.container div.checkout-order div.panle-body div.panel.panel-primary form.form-horizontal.batch_update table.table.table-striped tbody tr:first-child td:nth-child(2) a").click() #html body div#container.container div.checkout-order div.panle-body div.panel.panel-primary form.form-horizontal.batch_update table.table.table-striped tbody tr:first-child td:nth-child(2) a #html body div#container.container div#paidan_list_container div.panel.panel-primary.tab-content div#order_1039373 form#form_1039373.single_order_form table.table tbody tr:first-child td:nth-child(2) a #cursor.execute("UPDATE ims_washing_order SET status_delivery='3' ,STATUS='1' ,fanxidan_id=0 WHERE ordersn='"+ordersn+"'") #n = cursor.execute("SELECT ordersn ,username,tel,address ,status_delivery,STATUS ,fanxidan_id FROM ims_washing_order WHERE status_delivery=3 AND fanxidan_id=0 AND bagsn IS NOT NULL AND id=(SELECT MIN(id) FROM ims_washing_order) ORDER BY id") #for i in xrange(cursor.rowcount): # ordersn ,username,tel,address,status_delivery,STATUS ,fanxidan_id = cursor.fetchone() #print ordersn ,username,tel,address,status_delivery,STATUS ,fanxidan_id #print driver.title #cursor.execute("DELETE FROM map_cities WHERE gaode_map_code LIKE 'beijinggaode%'") # winBeforeHandle = driver.current_window_handle # print "winBeforeHandle==",winBeforeHandle # winHandles = driver.window_handles # print "winHandles==",winHandles # for handle in winHandles: # if winBeforeHandle != handle: # driver.switch_to_window(handle) # self.assertEqual(driver.title, u"物流") time.sleep(1) driver.find_element_by_css_selector("div#container.container>a#fanxi_button.btn.btn-info").click() driver.find_element_by_xpath("//*[@id='fanxi_button']").click() #driver.find_element_by_css_selector("div#container.container>a#fanxi_button.btn.btn-info").click() # html body div#container.container a#f''anxi_button.btn.btn-info time.sleep(1) self.assertEqual(driver.title, u"物流") #html body div#container.container a#fanxi_button.btn.btn-info #submit to database fanxiwashingtime=driver.find_element_by_xpath("/html/body/div[1]/form/table/tbody/tr[8]/td[2]/div/div/select/option[2]").text #fanxiwashingtime=driver.find_element_by_css_selector("div#container.container form#new_fanxi_order_form_1039230.form-horizontal.new_fanxi_order_form table.table.table-striped.search-table tbody tr:nth-last-child(4) td:last-child div.form-group.select.required.fanxi_order_form_washing_time div.col-sm-8 select#fanxi_order_form_washing_time.select.required.form-control option:nth-child(2)").text print " the fanxiwashingtime is ",fanxiwashingtime Select(driver.find_element_by_id("fanxi_order_form_washing_time")).select_by_visible_text(fanxiwashingtime) driver.find_element_by_id("fanxi_order_form_remark").clear() driver.find_element_by_id("fanxi_order_form_remark").send_keys("beijingjiangtailu") driver.find_element_by_id("fanxi_order_form_washing_date").clear() driver.find_element_by_id("fanxi_order_form_washing_date").send_keys(str(wuliu_utiltools.get_day_of_day(2))) #driver.find_element_by_css_selector("div#container.container form#new_fanxi_order_form_254.form-horizontal.new_fanxi_order_form table.table.table-striped.search-table tbody tr:last-child td:last-child input.button.btn.btn-info.btn-style-width").click() driver.find_element_by_xpath("//input[@type='submit']").click() #/html/body/div[1]/form/table/tbody/tr[11]/td[2]/input #self.assertTrue(driver.title, u"物流") self.assertEqual(driver.title, u"物流") cursor.execute("UPDATE ims_washing_order SET fanxidan_id='0',paytype='1',pay_status='1',fan_id='"+wuliu_utiltools.fansfanidnumber+"',status_delivery='3' WHERE ordersn='"+wuliu_utiltools.ordersnnumber+"'") conn.commit() wuliuconn=MySQLdb.connect(host=mysqlhostname,user=mysqlusername,passwd=mysqlpassword,db=mysqlwuliudb,charset="utf8") global wuliucursor wuliucursor = wuliuconn.cursor() wuliucursor.execute("DELETE FROM map_cities WHERE gaode_map_code LIKE 'beijinggaode%'") wuliuconn.commit() wuliucursor.close() cursor.close() wuliuconn.close() conn.close() wuliu_utiltools.getcloseconn()
def test_wuliu_testcase00_EditSitePermission(self): driver = self.driver driver.get(self.base_url + "/") loginclick=driver.find_element_by_css_selector("div#container.container h3.text-center.text-primary a.btn.btn-success.text-center") ActionChains(driver).double_click(loginclick).perform() driver.find_element_by_id("username").clear() driver.find_element_by_id("username").send_keys(USER_NAME) driver.find_element_by_id("password").clear() driver.find_element_by_id("password").send_keys(PASS_WORD) driver.find_element_by_id("login-submit").click() print " the testcase WuliuTestcase00EditSitePermission is ",driver.title self.assertEqual(driver.title, u"物流") time.sleep(2) wuliu_utiltools.updateSignNumber() driver.find_element_by_css_selector("div.container nav.collapse.navbar-collapse.bs-navbar-collapse ul.nav.navbar-nav li:nth-child(1).dropdown a").click() self.assertEqual(driver.title, u"物流") driver.find_element_by_xpath("/html/body/header/div/nav/ul/li[1]/ul/li[1]/a").click() self.assertEqual(driver.title, u"物流") driver.find_element_by_id("bagsn").clear() driver.find_element_by_id("bagsn").send_keys(wuliu_utiltools.signbagnumber) driver.find_element_by_name("commit").click() self.assertEqual(driver.title, u"物流") time.sleep(2) #html body div#container.container div.panel.panel-primary p.text-center b#check_in_msg qianshouresult=driver.find_element_by_css_selector("div#container.container>div.panel.panel-primary>p.text-center>b#check_in_msg").text print " the qianshouresult failed is ",qianshouresult assert u"签收失败!" in qianshouresult # qianshou success for 00 permission conn=MySQLdb.connect(host=mysqlhostname,user=mysqlusername,passwd=mysqlpassword,db=mysqlrongchangdb,charset="utf8") global cursor cursor = conn.cursor() cursor.execute("UPDATE ims_washing_order SET status_delivery='1' ,qianshoudian_id= NULL WHERE bagsn='E0000000006'") conn.commit() n = cursor.execute("SELECT ordersn,bagsn,status_delivery,jiagongdian_id,qianshoudian_id FROM ims_washing_order WHERE bagsn='E0000000006'") for i in xrange(cursor.rowcount): ordersn ,bagsn,status_delivery,jiagongdian_id,qianshoudian_id = cursor.fetchone() print ordersn ,bagsn,status_delivery,jiagongdian_id,qianshoudian_id time.sleep(1) driver.find_element_by_id("bagsn").clear() driver.find_element_by_id("bagsn").send_keys(bagsn) driver.find_element_by_name("commit").click() self.assertEqual(driver.title, u"物流") qianshouresult=driver.find_element_by_css_selector("div#container.container>div.panel.panel-primary>p.text-center>b#check_in_msg").text print " the qianshouresult success is ",qianshouresult # assert u"签收成功!" in qianshouresult time.sleep(2) driver.find_element_by_link_text(u"站点出入库管理").click() driver.find_element_by_link_text(u"出库").click() driver.find_element_by_id("order_key").clear() driver.find_element_by_id("order_key").send_keys("E0000000006") driver.find_element_by_name("commit").click() self.assertEqual(driver.title, u"物流") # zhandianchukuresult=driver.find_element_by_css_selector("html body div#container.container div.panel.panel-primary p.text-center b#check_in_msg").text # print " the zhandianchukuresult null is ",zhandianchukuresult # assert u"出库成功" in zhandianchukuresult time.sleep(2) # driver.find_element_by_link_text(u"站点出入库管理").click() # driver.find_element_by_link_text(u"出库").click() # driver.find_element_by_id("order_key").clear() # driver.find_element_by_id("order_key").send_keys("") # driver.find_element_by_name("commit").click() zhandianchukuresult=driver.find_element_by_css_selector("html body div#container.container div.panel.panel-primary p.text-center b#check_in_msg").text print " the zhandianchukuresult null is ",zhandianchukuresult assert u"出库成功" in zhandianchukuresult time.sleep(2) driver.find_element_by_link_text(u"站点出入库管理").click() driver.find_element_by_link_text(u"出入库查询").click() # driver.find_element_by_name("commit").click() self.assertEqual(driver.title, u"物流") Select(driver.find_element_by_id("in_out_type")).select_by_visible_text(u"出库") driver.find_element_by_name("commit").click() self.assertEqual(driver.title, u"物流") Select(driver.find_element_by_id("target_type")).select_by_visible_text(u"加工店") driver.find_element_by_name("commit").click() self.assertEqual(driver.title, u"物流") wuliu_utiltools.getcloseconn()