dong的博客

#--conding:utf-8-- from openpyxl import Workbook from openpyxl import load_workbook import os filepath = '/home/public/a.xlsx' newfilepath = '/home/public/b.xlsx' output = '/home/public/output' #打开工作薄 wb = load_workbook(filepath) #获取活动中的表格 ws = wb.activ

# -*- coding:utf-8 -*- import os import time import shutil import schedule import datetime DB_HOST = '127.0.0.1' DB_USER = 'root' DB_USER_PASSWD = '1234' DB_NAME = r'/home/public/wangyadong/mysql/mysqlAll.txt' BACKUP_PATH = '/home/public/wangyadong/mysql/'

# -*- coding:utf-8 -*- import re import os import pymysql from datetime import datetime, date, timedelta import time import shutil import sys import _thread # 连接数据库 #def dbh_connect(databaseName): # global cur # global conn # conn = pymysql.conne

# -*- coding:UTF-8 -*- import sys import os reload(sys) sys.setdefaultencoding('utf-8') sys.setrecursionlimit(100000) arr = [] def find_data(name,files,gPath): '''递归寻找文件的地址''' for filePath in files: fileList = {} dirList = {}

#!/bin/bash percent=`df -k | grep -v Filesystem| awk '{print int($5)}'` #oldIFS=$IFS #IFS='' percents=($percent) per=`df -k | grep -v Filesystem| awk '{print $6}'` pers=($per) local_host="`hostname --fqdn`" local_ip=`host $local_host 2>/dev/null | awk