python定时任务运行过程的log留存
# -*- coding: utf-8 -*-
"""
Created on Fri Jan 17 15:02:46 2020
@author: wzj
"""
#log 测试
import pandas as pd
import pymysql
import traceback
import logging
from logging.handlers import TimedRotatingFileHandler
from logging import Formatter
def log_info():
log_file=(r'C:\Users\admin\Desktop\1.log')
handler = logging.handlers.RotatingFileHandler(log_file)
fmt = '%(asctime)s %(pathname)s %(lineno)d %(message)s'
formatter = logging.Formatter(fmt)
handler.setFormatter(formatter) # 为handler添加formatter
logger = logging.getLogger('INFO') # 获取名为tst的logger
logger.addHandler(handler) # 为logger添加handler
logger.setLevel(logging.INFO)
return logger
logprint = log_info().info
conn_mysql = pymysql.connect(host, user, passwd, db, port, charset)
cursor = conn_mysql.cursor()
sql = " "
try: