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 test(self):
print('>>>>>>>>>>>>>>>>>>>未填收货地址 >> 跳转至收货地址填写<<<<<<<<<<<<<<<<<<<<<<')
# 环境检测
intializating.initialization.environmentPrepar(self)
time.sleep(1)
# 清空收货地址
MySql.db_NotQuery(self, dict_load['mysql']['清空收货地址db'],
dict_load['mysql']['清空收货地址sql'])
time.sleep(1)
# 选取商品
get_goods.get_goods(self)
time.sleep(1)
loc = (By.CSS_SELECTOR, dict_load['商品']['立即兑换'])
WebDriverWait(self.driver, 5).until(
expected_conditions.visibility_of_element_located(loc))
means.click(self, 'css', dict_load['商品']['立即兑换'])
time.sleep(1)
# 获取跳转收货地址填写页面截图
means.get_img(self)
time.sleep(1)
# 获取收货地址页面元素
text = means.get_text(self, 'css', dict_load['C端页面元素']['收货地址页面'])
text1 = re.search(r"^(....)", str(text))
text2 = text1.group()
time.sleep(1)
print(
'********************************状态*******************************************'
)
print('跳转到页面信息：', format(str(text)))
print(
'********************************断言*******************************************'
)
# 断言
assert text2 == '收货地址'
print('用例通过！')
def wipe_data(self):
MySql.db_NotQuery(self, dict_load['mysql']['清空所有订单db'],
dict_load['mysql']['清空所有订单sql'])
