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