def __init__(self): self.logger_level = configuration(project_path.config_path).read_str( 'LOG', 'logger_level') self.file_level = configuration(project_path.config_path).read_str( 'LOG', 'file_level') self.file_name = configuration(project_path.config_path).read_str( 'LOG', 'file_name') self.formatter = configuration(project_path.config_path).read_str( 'LOG', 'formatter')
def __init__(self): # self.logger_name=configuration('D:\pycharm\python14\log_lx\log.ini').read_str('LOG','logger_name') self.logger_level = configuration(project_path.config_path).read_str( 'LOG', 'logger_level') self.file_level = configuration(project_path.config_path).read_str( 'LOG', 'file_level') self.file_name = configuration(project_path.config_path).read_str( 'LOG', 'file_name') self.formatter = configuration(project_path.config_path).read_str( 'LOG', 'formatter')
class getdata: '''可以用来动态的更改 删除 获取数据''' cookies = '' NUM = '' #标ID YUE = '' #提现前的余额 MONEY = '' #充值前的余额 mobilephone = configuration(project_path.config_path).read_str( 'data', 'mobilephone') password = configuration(project_path.config_path).read_str( 'data', 'password') memberid = configuration(project_path.config_path).read_str( 'data', 'memberid')
def select_mysql(self, query, flag=1): '''链接数据库''' db_future = configuration(project_path.config_path).read_else( 'DBCONFIG', 'db_data') db = connector.connect(**db_future) '''获取游标,获取操作权限''' cursor = db.cursor() '''操作数据库,查询标ID''' cursor.execute(query) if flag == 1: res = cursor.fetchone() else: res = cursor.fetchall() db.close() return res
def select_db(self, query, falg=1): '''这是一个查询数据库在函数 query表示需要输入的查询语句 falg表示需要显示的条数 1表示一条,2表示多条''' db_data = configuration(project_path.config_path).read_else( 'DBCONFIG', 'db_data') #打开数据库连接 db = pymysql.connect(**db_data) # 使用 cursor() 方法创建一个游标对象 cursor cursor = db.cursor() # 使用 execute() 方法执行 SQL 查询 cursor.execute(query) if falg == 1: # 使用 fetchone() 方法获取单条数据 data = cursor.fetchone() else: # 使用 fetchall() 方法获取多条数据 data = cursor.fetchall() db.close() return data
# -*- coding:utf-8 -*- from openpyxl import load_workbook from API_D.Common.public.read_ini import configuration from API_D.Common.public import project_path # from openpyxl import Workbook button = configuration(project_path.config_path).read_str('CASE', 'button') class DoExcel: '''这个类的作用是完成Excel数据的读写 新建表单的操作''' def __init__(self, file_name): self.file_name = file_name def read_Excel(self, sheet_name): '''读取指定表单的数据''' wb = load_workbook(self.file_name) sheet = wb[sheet_name] '''新建列表用于接收所有数据''' max_list = [] '''遍历Excel文件中表单的数据''' for i in range(2, sheet.max_row + 1): row_list = [] '''新建列表用于接收每行的数据''' for j in range(1, sheet.max_column + 1): '''将数据添加到列表中''' row_list.append(sheet.cell(i, j).value) max_list.append(row_list) #执行配置文件中的测试用例 list = [] if button == 'all': list = max_list