def __new__(cls):
log_path = LOG_DIR
name = my_config.get('log', 'name')
all_level = my_config.get('log', 'all_level')
ls_level = my_config.get('log', 'ls_level')
fs_level = my_config.get('log', 'fs_level')
# log_path = my_config.get('log', 'log_path')
my_log = logging.getLogger(name)
my_log.setLevel(all_level)
my_ls = logging.StreamHandler()
my_ls.setLevel(ls_level)
my_lf = logging.FileHandler(
f"{log_path}{time.strftime('log_%Y_%m_%d_%H', time.localtime())}.log",
encoding='utf8')
my_lf.setLevel(fs_level)
format = '%(asctime)s | %(process)s | [%(filename)s-->line:%(lineno)d] | %(levelname)-5s: %(message)s'
my_format = logging.Formatter(format)
my_ls.setFormatter(my_format)
my_lf.setFormatter(my_format)
my_log.addHandler(my_ls)
my_log.addHandler(my_lf)
return my_log
def my_replace(string, content=None, split='#'):
while split in string:
pattern = f"{split}(.+?){split}"
try:
arg = re.search(pattern, string).group(1)
word = my_config.get('account', arg)
except configparser.NoOptionError:
word = content if content is not None else getattr(ParmTemp, arg)
string = re.sub(pattern, word, string, count=1)
return string
def __init__(self):
section = 'database'
host = my_config.get(section, 'host')
user = my_config.get(section, 'user')
password = my_config.get(section, 'password')
database = my_config.get(section, 'database')
port = my_config.get(section, 'port')
charset = my_config.get(section, 'charset')
self.con = pymysql.connect(host=host, user=user, password=password, database=database, port=eval(port),
charset=charset)
self.cur = self.con.cursor()
import json
import unittest
from package_301.common.R_r_config import my_config
from package_301.common.R_r_excel import ReadExcel
from package_301.common.R_r_log import my_log
from package_301.common.R_r_os import DATA_DIR, CONF_DIR
from package_301.common.R_request import HttpRequestNoCookie, HttpRequest
from package_301.common.generate import Generate
from package_301.library.ddt import ddt, data
file_name = my_config.get('excel', 'file_name')
file_path = f'{DATA_DIR}{file_name}'
sheet_name = 'withdraw'
columns_read = my_config.get('excel', 'columns_read')
testRequestNoCookie = HttpRequestNoCookie()
testRequest = HttpRequest()
my_generate = Generate(file_path,
sheet_name,
yaml_file=f'{CONF_DIR}parms.yaml')
my_generate.generate()
wb = ReadExcel(file_path, sheet_name)
# cases = wb.r_data_obj_from_column(eval(columns_read))
cases = wb.read_data_obj()
@ddt
class WithdrawTestCase(unittest.TestCase):
import json
import random
import unittest
from package_301.common.R_r_config import my_config
from package_301.common.R_r_excel import ReadExcel
from package_301.common.R_r_log import my_log
from package_301.common.R_r_os import DATA_DIR, CONF_DIR
from package_301.common.R_r_re import my_replace, ParmTemp
from package_301.common.R_r_sql import Mysql
from package_301.common.R_r_sql import my_sql
from package_301.common.R_request import HttpRequestNoCookie, HttpRequest
from package_301.library.ddt import ddt, data
api = my_config.get('env', 'api')
file_name = my_config.get('excel', 'file_name')
file_path = f'{DATA_DIR}{file_name}'
yaml_file = f'{CONF_DIR}parms.yaml'
# sheet_name = 'login'
testRequestNoCookie = HttpRequestNoCookie()
testRequest = HttpRequest()
def one_number(number):
head = '139'
for _ in range(number - len(head)):
head += str(random.randint(0, 9))
return head