基本范式如下:try: do-something-blockexcept: logger.exception("Exception Logged")
def setLogger(): # 创建loger可以考虑如何包装它 logger = logging.getLogger('mylogger') logger.setLevel(logging.DEBUG) # 创建handler,用于写日志文件 fh = logging.FileHandler(os.path.join(os.getcwd(), 'log.txt')) fh.setLevel(logging.DEBUG) # 再创建一个handler,用于输出到控制台 ch = logging.StreamHandler() ch.setLevel(logging.DEBUG) # 定义handler输出格式 formatter = logging.Formatter('%(asctime)s - %(module)s.%(funcName)s.%(lineno)d - %(levelname)s - %(message)s') fh.setFormatter(formatter) ch.setFormatter(formatter) # 添加logerhandler logger.addHandler(fh) logger.addHandler(ch) # 记录日志 logger.info('hello world, i\'m log helper in python, may i help you') return logger #将一个元组插入单个表,其定义是 def insertOneData(conn,tableName,listColumn,lData): try: cursor=conn.cursor() sql="insert into "+tableName+"(" i=0 length=len(listColumn) for column in listColumn: if(i!=(length-1)): sql=sql+column+"," else: sql=sql+column+") values(" i=i+1 for i in range(0,length): if(i!=(length-1)): sql=sql+"%s," else: sql=sql+"%s);" logger.info(sql) logger.info(lData) cursor.execute(sql,lData); conn.commit() except: logger.exception("Exception Logged")