def order_status(self):
db_PartnerOrderNO = MySql.db_Query(self,
dict_load['mysql']['查询新订单号db'],
dict_load['mysql']['查询新订单号sql'])
c_OrderNO = table.read(self, 4)
assert db_PartnerOrderNO[0] == c_OrderNO
# 5>>
table.write(self, 5, '待发货')
def get_newOrderNumber_On_B_h5(self):
self.driver.get(dict_load['url']['B端URL'])
self.driver.find_element_by_css_selector(
dict_load['B端页面元素']['兑换订单']).click()
sleep(2)
b_orderNumber = means.get_text(self, 'css',
dict_load['B端页面元素']['B端待发货列表新增商品单号'])
# 3>>>
table.write(self, 3, b_orderNumber)
def environmentPrepar(self):
mobile_emulation = {'deviceName': 'iPhone 5'}
options = webdriver.ChromeOptions()
options.add_experimental_option("mobileEmulation", mobile_emulation)
self.driver = webdriver.Chrome(executable_path='chromedriver.exe',
chrome_options=options)
self.driver.implicitly_wait(15)
self.driver.maximize_window()
self.driver.get(dict_load['url']['C端URL'])
sleep(1)
loc = (By.CSS_SELECTOR, dict_load['C端页面元素']['用户积分'])
WebDriverWait(self.driver, 10).until(
expected_conditions.visibility_of_element_located(loc))
u1 = means.get_text(self, 'css', dict_load['C端页面元素']['用户积分'])
u2 = re.findall(r"(......+?)", str(u1))
u3 = str(u2).replace(',', '')
# C端用户下单前用户积分
u4 = u3[2:-2]
# 0>>>
table.cretaTable(self)
table.write(self, 0, u4)
sleep(4)
if int(u4) <= 4000:
print('用户积分不足，请充值积分！')
elif int(u4) > 4000:
print('积分充足！准备执行用例......')
else:
print('用户积分为0，请检查环境！')
# 数据库初始化
self.db = pymysql.connect(
host=dict_load['mysql']['host'],
user=dict_load['mysql']['user'],
password=dict_load['mysql']['pwd'],
)
try:
self.db
print('数据库连接成功！准备执行用例......')
except:
print('数据库连接失败！请检查！')
self.cursor = self.db.cursor()
self.cursor.execute('SHOW DATABASES')
c = MySql.db_Query(self, dict_load['mysql']['商家菜籽db'],
dict_load['mysql']['查询商家菜籽sql'])
c1 = re.findall(r"[(]'(.......+?).", str(c))
if int(c1[0]) <= 1000000:
MySql.db_NotQuery(self, dict_load['mysql']['商家菜籽db'],
dict_load['mysql']['加菜籽sql'])
print('菜籽充足！准备执行用例......')
else:
print('菜籽充足！准备执行用例......')
def get_pay_caizi_values(self):
self.driver.get(dict_load['url']['B端URL'])
self.driver.find_element_by_css_selector(
dict_load['B端页面元素']['兑换订单']).click()
sleep(1)
loc = (By.CSS_SELECTOR, dict_load['B端页面元素']['待发货列表商品1'])
WebDriverWait(self.driver, 5).until(
expected_conditions.visibility_of_element_located(loc))
self.driver.find_element_by_css_selector(
dict_load['B端页面元素']['待发货列表商品1']).click()
sleep(1)
p1 = self.driver.find_element_by_css_selector(
dict_load['B端页面元素']['B端支付菜籽']).text
p2 = re.findall(r"^(......)", str(p1))
p3 = str(p2).replace(',', '')
pay = p3[2:-2]
# 2>>>
table.write(self, 2, pay)
def get_jifen_AfterValues(self):
mobile_emulation = {'deviceName': 'iPhone 5'}
options = webdriver.ChromeOptions()
options.add_experimental_option("mobileEmulation", mobile_emulation)
self.driver = webdriver.Chrome(executable_path='chromedriver.exe',
chrome_options=options)
self.driver.implicitly_wait(15)
self.driver.maximize_window()
self.driver.get(dict_load['url']['C端URL'])
sleep(1)
loc = (By.CSS_SELECTOR, dict_load['C端页面元素']['用户积分'])
WebDriverWait(self.driver, 10).until(
expected_conditions.visibility_of_element_located(loc))
q1 = means.get_text(self, 'css', dict_load['C端页面元素']['用户积分'])
q2 = re.findall(r"(......+?)", str(q1))
q3 = str(q2).replace(',', '')
q4 = q3[2:-2]
# 1>>
table.write(self, 1, q4)
def test1(self):
table.write(self, 0, 'chen')
table.write(self, 1, 'yong')
table.write(self, 2, 'yan')