def open_browser(self):
file_path = os.path.dirname(
os.path.abspath('.')) + '\\config2\\conf\\config.ini'
# 加载自己的配置文件类
config = Config(file_path)
browser = config.get_value(file_path, "Browser", "browserName")
url = config.get_value(file_path, "Server", "url")
if browser == "Firefox":
self.driver = webdriver.Firefox(self.firefox_driver_path)
logger.info('打开了Firefox浏览器')
elif browser == "Chrome":
self.driver = webdriver.Chrome(self.chrome_driver_path)
logger.info('打开了Chrome浏览器')
elif browser == "IE":
self.driver = webdriver.Ie(self.ie_driver_path)
logger.info('打开了IE浏览器')
else:
logger.info("找不到 %s 浏览器,你应该从这里面选取一个 'Firefox', 'Chrome', 'IE'" %
self.driver)
raise NameError(
"找不到 %s 浏览器,你应该从这里面选取一个 'Firefox', 'Chrome', 'IE'" %
self.driver)
self.driver.get(url)
logger.info('浏览器地址为：' + url)
self.driver.maximize_window()
logger.info('最大化浏览器')
return self.driver
def init_config():
config = Config(file)
configs = {
'url': config.get_value(file, 'base', 'url'),
'port': config.get_value(file, 'base', 'port'),
'project_name': config.get_value(file, 'base', 'project_name'),
}
return configs
def get_db():
config = Config(file)
my = MySQLHelper()
my.host = config.get_value(file, 'mysql', 'host')
my.user = config.get_value(file, 'mysql', 'user')
my.password = config.get_value(file, 'mysql', 'password')
my.database = config.get_value(file, 'mysql', 'database')
my.port = int(config.get_value(file, 'mysql', 'port'))
return my
class GoodsCase(LoginCase, Goods):
file = '../conf/config.ini'
def __init__(self):
self.config = Config(self.file)
def get_db(self):
my = MySQLHelper()
my.host = self.config.get_value(self.file, 'mysql', 'host')
my.user = self.config.get_value(self.file, 'mysql', 'user')
my.password = self.config.get_value(self.file, 'mysql', 'password')
my.database = self.config.get_value(self.file, 'mysql', 'database')
my.port = int(self.config.get_value(self.file, 'mysql', 'port'))
return my
# 进入商品列表的公共方法
def common(self):
LoginCase.test_login(self)
Goods.click_goods_menu(self)
Goods.out_frame(self)
Goods.into_frame(self)
# 按照分类下拉且输入关键字,2者组合查询
def search(self):
self.common()
Goods.input_by_keword(self)
Goods.all_category(self)
Goods.search_button(self)
# 添加商品
def add_goods(self):
self.common()
Goods.add_goods_button(self)
Goods.goods_name(self)
Goods.all_category(self)
Goods.submit(self)
sql = "select * from ecs_goods where goods_name='包包爱宝宝'"
logger.info('你执行的sql是:[' + sql + ']')
result = self.get_db().select(sql, 'one')
logger.info('执行结果是:%s' % str(result))
if result[3] == '包包爱宝宝':
print('ok')
logger.info('测试通过')
else:
print('fail')
# 下架
def goods_ground(self):
self.search()
sleep(2)
goods_id = Goods.get_goods_id(self)
print(goods_id)
#点击之前
before = Goods.get_src_path(self)
before_sql = "select is_on_sale from ecs_goods where goods_id=%d" % int(
goods_id)
before_result = self.get_db().select(before_sql, 'one')
print(before_result)
#点击
Goods.only_onclick(self)
sleep(2)
#点击之后
after = Goods.get_src_path(self)
after_sql = "select is_on_sale from ecs_goods where goods_id=%d" % int(
goods_id)
after_result = self.get_db().select(after_sql, 'one')
print(after_result)
#判断点击前后的结果,必须均不一致
if before != after and after_result[
0] == 0 and before_result[0] != after_result[0]:
print('ok')
else:
print('fail')
#
# url = 'http://192.168.1.5:8080/recruit.students/school/manage/addSchoolInfo'
# data = {
# 'schoolName':'蔡包子2',
# 'listSchoolType[0].id':'2',
# 'canRecruit':'1',
# 'remark':'3333'
# }
# cookies = {
# 'JSESSIONID':'4C7F9900296CCF401EA453523988978F'
# }
# response = post(url, data, cookies=cookies)
# # print(response)
# # print(response.text)
# # print(response.status_code)
# print(response.text)
# print(type(response.text))
#
# print(type(loads(response.text)))
# if loads(response.text)['code']==1:
# print()
import os
from utils.Config import Config
file_path = os.path.dirname(os.path.abspath('.')) + '\\conf\\config.ini'
config = Config(file_path)
browser = config.get_value(file_path, "Browser", "browserName")
print(browser)
print(config.getall_option(file_path, 'Cookies'))
def init_cookies():
config = Config(file)
cookie = {'JSESSIONID': config.get_value(file, 'cookies', 'JSESSIONID')}
return cookie
