01 2021 档案
摘要:def merge_excel_data(folder_path, result_file_path, file_name_list): """ :param folder_path: 文件夹路径 :param result_file_path: 汇总文件绝对路径 :param file_name_
阅读全文
摘要:def get_target_date(): start_date = str(date.today() - timedelta(45)) end_date = str(date.today() - timedelta(15)) return start_date, end_date
阅读全文
摘要:import datetime def get_month_zone(before_day): today = datetime.date.today() day = today.day year = today.year month = today.month if day > before_da
阅读全文
摘要:import pymysql class MyDBConnector: def __init__(self, logger, host, user, password, schema, charset): self.logger = logger self.host = host self.user
阅读全文
摘要:mysql5.7 root账号的密码忘记,重置(会删除数据,慎用!)此方法相当于重装。mysql需要在本机安装。 1、cmd命令行停掉mysql net stop mysql2、清除mysql安装目录下的data目录下的所有数据3、cmd执行: mysqld --initialize-insecur
阅读全文
摘要:import win32.win32api as win32api import win32.lib.win32con as win32con keyboard_one = params_list[0] #第二个按键 keyboard_two = params_list[1] # keyboard_
阅读全文
摘要:import win32.win32gui as win32gui import win32.lib.win32con as win32con class cWindow: def __init__(self): self._hwnd = None def SetAsForegroundWindow
阅读全文