def test_kefu_testcase03_orderlist_createorder(self): driver = self.driver #driver.get(self.base_url + "/orders/new") driver.get(self.base_url + "/") #driver.find_element_by_link_text(u"登陆").click() driver.find_element_by_css_selector("div#container.container h3.text-center.text-primary a.btn.btn-success.text-center").click() 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 test_kefu_testcase03_orderlist_createorder is ",driver.title,USER_NAME,PASS_WORD self.assertEqual(driver.title,u"客服系统") time.sleep(1) driver.find_element_by_css_selector("div.container>div.navbar-collapse.collapse.navbar-responsive-collapse>ul.nav.navbar-nav>li:nth-child("+appobjectkefu.kefu_tab_orderlist+")>a").click() self.assertEqual(driver.title,u"客服系统") #html body div#container.container>div#content-container>a.btn.btn-info.col-md-1 #createorderclick=driver.find_element_by_css_selector("div#container.container>div#content-container>a.btn.btn-info.col-md-1") createorderclick=driver.find_element_by_xpath("/html/body/div[2]/div/form/a[1]") ActionChains(driver).double_click(createorderclick).perform() self.assertEqual(driver.title,u"客服系统") #driver.find_element_by_css_selector(css_selector) #html body div#container.container div.sidebar_container form#new_new_order_form.form-horizontal.new_new_order_form div.form-group.select.required.new_order_form_good div.col-sm-8 select#new_order_form_good.select.required.form-control option #html body div#container.container div.sidebar_container form#new_new_order_form.form-horizontal.new_new_order_form div.form-group.select.optional.new_order_form_good div.col-sm-8 select#new_order_form_good.select.optional.form-control option:nth-child(2) goodnanemtext=driver.find_element_by_css_selector("div#container.container>div.sidebar_container>form>div>div.col-sm-8>select>option:nth-child(2)").text print " the goodnanemtext is ",goodnanemtext Select(driver.find_element_by_id("new_order_form_good")).select_by_visible_text(goodnanemtext) driver.find_element_by_id("new_order_form_totalnum").clear() driver.find_element_by_id("new_order_form_totalnum").send_keys("10") driver.find_element_by_id("new_order_form_coupon_sn").clear() driver.find_element_by_id("new_order_form_coupon_sn").send_keys("82170") Select(driver.find_element_by_id("new_order_form_user_type")).select_by_visible_text(u"客服下单") driver.find_element_by_id("new_order_form_username").clear() driver.find_element_by_id("new_order_form_username").send_keys("testlukeuser") driver.find_element_by_id("new_order_form_tel").clear() driver.find_element_by_id("new_order_form_tel").send_keys("121323232") Select(driver.find_element_by_id("new_order_form_city")).select_by_visible_text(u"北京") #html body div#container.container div.sidebar_container form#new_new_order_form.form-horizontal.new_new_order_form div.form-group.select.required.new_order_form_area div.col-sm-8 select#new_order_form_area.select.required.form-control option:first-child cityareaname=driver.find_element_by_css_selector("div#container.container div.sidebar_container form#new_new_order_form.form-horizontal.new_new_order_form div.form-group.select.required.new_order_form_area div.col-sm-8 select#new_order_form_area.select.required.form-control option:first-child").text print " the cityareaname is ",cityareaname Select(driver.find_element_by_id("new_order_form_area")).select_by_visible_text(cityareaname) driver.find_element_by_id("new_order_form_address").clear() driver.find_element_by_id("new_order_form_address").send_keys("beijingjiangtailu") #driver.find_element_by_id("new_order_form_washing_date").click() #driver.find_element_by_link_text("29").click() datestr=str(PythonDateUtils.get_day_of_day(2)) print " the datestr is ",datestr datestrfinalstr=str(datestr[-2:]) print " the datestrfinalstr is ",datestrfinalstr driver.find_element_by_id("new_order_form_washing_date").send_keys(datestr) driver.find_element_by_link_text(datestrfinalstr).click() # time.sleep(1) # winBeforeHandle = driver.current_window_handle # winHandles = driver.window_handles # for handle in winHandles: # if winBeforeHandle != handle: # driver.switch_to_window(handle) # driver.find_element_by_id(datestrfinalstr).click() time.sleep(1) Select(driver.find_element_by_id("new_order_form_washing_time")).select_by_visible_text("08:00-10:00") time.sleep(1) driver.find_element_by_id("new_order_form_remark").clear() driver.find_element_by_id("new_order_form_remark").send_keys("hellodedaixi") time.sleep(1) #driver.find_element_by_name("commit").click() #driver.find_element_by_css_selector("input.button.btn.btn-info.btn-style-width").send_keys(Keys.ENTER) #html body div#container.container div.alert.fade.in.alert-success #createorderresult=driver.find_element_by_css_selector("div#container.container div.alert.fade.in.alert-success").text #driver.find_element_by_css_selector("input.button.btn.btn-info.btn-style-width").click() #driver.find_element_by_xpath("/html/body/div[2]/div/form/input").click() driver.execute_script("window.scrollBy(0,200)","") # driver.execute_script("window.scrollBy(0,document.body.scrollHeight)","") time.sleep(2) driver.find_element_by_css_selector("input.button.btn.btn-info.btn-style-width").click() #html body div#container.container div.sidebar_container form#new_new_order_form.form-horizontal.new_new_order_form input.button.btn.btn-info.btn-style-width #html body div#container.container div.sidebar_container form#new_new_order_form.form-horizontal.new_new_order_form input.button.btn.btn-info.btn-style-width self.assertEqual(driver.title,u"客服系统") try: wearesorrytext=driver.find_element_by_css_selector("body > div > h1").text print " the wearesorrytext result is ",wearesorrytext if wearesorrytext in "We're sorry, but something went wrong": raise "We are Sorry" else: finalresult=driver.find_element_by_css_selector("html body div#container.container div.alert.fade.in.alert-success").text print " the finalresult is ",finalresult assert u"订单已添加" in finalresult except Exception,e: #print Exception,":",e pass finalresult=driver.find_element_by_css_selector("html body div#container.container div.alert.fade.in.alert-success").text print " the finalresult is ",finalresult assert u"订单已添加" in finalresult
def test_kefu_testcase03_orderlist_createfanxiorder(self): driver = self.driver #driver.get(self.base_url + "/orders/new") driver.get(self.base_url + "/") #driver.find_element_by_link_text(u"登陆").click() driver.find_element_by_css_selector("div#container.container h3.text-center.text-primary a.btn.btn-success.text-center").click() 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 test_kefu_testcase03_orderlist_createfanxiorder is ",driver.title #self.assertEqual(driver.title,u"客服系统") time.sleep(1) driver.find_element_by_css_selector("div.container>div.navbar-collapse.collapse.navbar-responsive-collapse>ul.nav.navbar-nav>li:nth-child(3)>a").click() conn=MySQLdb.connect(host=mysqlhostname,user=mysqlusername,passwd=mysqlpassword,db=mysqldatabase,charset="utf8") global cursor cursor = conn.cursor() # n = cursor.execute("SELECT ordersn,fan_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") # #print " the cursor.fetchone() is ",cursor.fetchone() # for i in xrange(cursor.rowcount): # ordersn,fan_id=cursor.fetchone() # #print " the cursor.fetchone() is ",cursor.fetchone() # print "ordersn,fan_id is ",ordersn,fan_id # # global ordernumber # cursor.execute("SELECT ordersn,fan_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,fan_id = cursor.fetchone() # #print ordersn,fan_id # ordernumber=ordersn # global ordersn # n = cursor.execute("SELECT ordersn 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 = cursor.fetchone() # ordervrnum=ordersn # print ordervrnum # cursor.execute("UPDATE ims_washing_order SET status_delivery='3' ,STATUS='1' ,fanxidan_id=0 WHERE ordersn='"+ordersn+"'") #This is test data for kefu create fanxidan business #ordersn="0723821336144" driver.find_element_by_id("order_search_form_ordersn").clear() driver.find_element_by_id("order_search_form_ordersn").send_keys(PythonDateUtils.fanxiordersnnumber) driver.find_element_by_name("commit").click() self.assertEqual(driver.title,u"客服系统") print " the PythonDateUtils.fanxiordersnnumber is ",PythonDateUtils.fanxiordersnnumber time.sleep(1) driver.find_element_by_css_selector("div#container.container div#content-container div#content div.panel.panel-primary form.form-horizontal.batch_update table.table.table-striped tbody tr:first-child td:nth-child(2) a").click() self.assertEqual(driver.title,u"客服系统") driver.find_element_by_css_selector("div#container.container a#fanxi_button.btn.btn-info").click() self.assertEqual(driver.title,u"客服系统") winBeforeHandle = driver.current_window_handle winHandles = driver.window_handles for handle in winHandles: if winBeforeHandle != handle: driver.switch_to_window(handle) #datestr=str(PythonDateUtils.get_day_of_day(1))[-2:] datestr=str(PythonDateUtils.get_day_of_day(3)) print " the datestr is ",datestr driver.find_element_by_id("fanxi_order_form_washing_date").clear() driver.find_element_by_id("fanxi_order_form_washing_date").send_keys(datestr) driver.find_element_by_id("fanxi_order_form_washing_date").click() #driver.find_element_by_link_text(datestr).click() fanxiwashingtime=driver.find_element_by_xpath("/html/body/div[2]/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_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() #driver.find_elements(By.XPATH, "//input[@type='submit']").click() self.assertEqual(driver.title,u"客服系统") createfanxidanresult=driver.find_element_by_css_selector("div#container.container div.alert.fade.in.alert-success").text print " the createfanxidanresult is ",createfanxidanresult #self.assertEqual(createfanxidanresult,u"客服系统") cursor.execute("UPDATE ims_washing_order SET status_delivery='3' ,STATUS='1' ,fanxidan_id=0,fan_id='"+PythonDateUtils.fanstableidnumber+"' WHERE ordersn='"+PythonDateUtils.ordersnnumber+"'") #提交到数据库执行 conn.commit() cursor.close() conn.close() PythonDateUtils.getcloseconn()
def test_kefu_testcase03_orderlist_createorder(self): driver = self.driver #driver.get(self.base_url + "/orders/new") driver.get(self.base_url + "/") #driver.find_element_by_link_text(u"登陆").click() driver.find_element_by_css_selector("div#container.container h3.text-center.text-primary a.btn.btn-success.text-center").click() 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 driver.title self.assertEqual(driver.title,u"客服系统") driver.find_element_by_css_selector("div.container>div.navbar-collapse.collapse.navbar-responsive-collapse>ul.nav.navbar-nav>li:nth-child(3)>a").click() self.assertEqual(driver.title,u"客服系统") #html body div#container.container>div#content-container>a.btn.btn-info.col-md-1 #createorderclick=driver.find_element_by_css_selector("div#container.container>div#content-container>a.btn.btn-info.col-md-1") createorderclick=driver.find_element_by_xpath("/html/body/div[2]/div/form/a[1]") ActionChains(driver).double_click(createorderclick).perform() self.assertEqual(driver.title,u"客服系统") #driver.find_element_by_css_selector(css_selector) #html body div#container.container div.sidebar_container form#new_new_order_form.form-horizontal.new_new_order_form div.form-group.select.required.new_order_form_good div.col-sm-8 select#new_order_form_good.select.required.form-control option #html body div#container.container div.sidebar_container form#new_new_order_form.form-horizontal.new_new_order_form div.form-group.select.optional.new_order_form_good div.col-sm-8 select#new_order_form_good.select.optional.form-control option:nth-child(2) goodnanemtext=driver.find_element_by_css_selector("div#container.container>div.sidebar_container>form>div>div.col-sm-8>select>option:nth-child(2)").text print " the goodnanemtext is ",goodnanemtext Select(driver.find_element_by_id("new_order_form_good")).select_by_visible_text(goodnanemtext) driver.find_element_by_id("new_order_form_totalnum").clear() driver.find_element_by_id("new_order_form_totalnum").send_keys("10") driver.find_element_by_id("new_order_form_coupon_sn").clear() driver.find_element_by_id("new_order_form_coupon_sn").send_keys("8217005292233") Select(driver.find_element_by_id("new_order_form_user_type")).select_by_visible_text(u"客服下单") driver.find_element_by_id("new_order_form_username").clear() driver.find_element_by_id("new_order_form_username").send_keys("testlukeuser") driver.find_element_by_id("new_order_form_tel").clear() driver.find_element_by_id("new_order_form_tel").send_keys("beijingjiangtailu") Select(driver.find_element_by_id("new_order_form_city")).select_by_visible_text(u"北京") #html body div#container.container div.sidebar_container form#new_new_order_form.form-horizontal.new_new_order_form div.form-group.select.required.new_order_form_area div.col-sm-8 select#new_order_form_area.select.required.form-control option:first-child cityareaname=driver.find_element_by_css_selector("div#container.container div.sidebar_container form#new_new_order_form.form-horizontal.new_new_order_form div.form-group.select.required.new_order_form_area div.col-sm-8 select#new_order_form_area.select.required.form-control option:first-child").text print " the cityareaname is ",cityareaname Select(driver.find_element_by_id("new_order_form_area")).select_by_visible_text(cityareaname) driver.find_element_by_id("new_order_form_address").clear() driver.find_element_by_id("new_order_form_address").send_keys("beijingjiangtailu") #driver.find_element_by_id("new_order_form_washing_date").click() #driver.find_element_by_link_text("29").click() datestr=str(PythonDateUtils.get_day_of_day(2)) print " the datestr is ",datestr driver.find_element_by_id("new_order_form_washing_date").send_keys(datestr) Select(driver.find_element_by_id("new_order_form_washing_time")).select_by_visible_text("08:00-10:00") driver.find_element_by_id("new_order_form_remark").clear() driver.find_element_by_id("new_order_form_remark").send_keys("hellodedaixi") driver.find_element_by_name("commit").click() #driver.find_element_by_css_selector("input.button.btn.btn-info.btn-style-width").send_keys(Keys.ENTER) #html body div#container.container div.alert.fade.in.alert-success #createorderresult=driver.find_element_by_css_selector("div#container.container div.alert.fade.in.alert-success").text self.assertEqual(driver.title,u"客服系统")