2017年8月13日

LOGGING = { 'disable_existing_loggers': False, 'version': 1, 'handlers': {     'console_handler': {         # logging handler that outputs log messages to terminal
         'class': 'logging.StreamHandler',         'level': 'DEBUG',  # message level to be written to console
         'formatter': 'simple',
     },     'default_handler': {         'level': 'DEBUG',         'class': 'logging.handlers.RotatingFileHandler',         'filename': 'log/all.log',  # 日志输出文件
         'maxBytes': 1024 * 1024 * 5,  # 文件大小
         'backupCount': 5,  # 备份份数
         "encoding": "utf-8",         'formatter': 'standard',  # 使用哪种formatters日志格式
     },     'error_handler': {         'level': 'ERROR',         'class': 'logging.handlers.RotatingFileHandler',         'filename': 'log/error.log',         'maxBytes': 1024 * 1024 * 5,         "encoding": "utf-8",         'backupCount': 5,         'formatter': 'standard',
     },     'login_logout_handler': {         'level': 'DEBUG',         'class': 'logging.handlers.RotatingFileHandler',         'filename': 'log/login_logout.log',         'maxBytes': 1024 * 1024 * 5,         "encoding": "utf-8",         'backupCount': 5,         'formatter': 'standard',
     }
 }, 'formatters': {     'standard': {         'format': '%(asctime)s [%(threadName)s:%(thread)d] [%(name)s:%(lineno)d] [%(module)s:%(funcName)s] [%(levelname)s]- %(message)s'},     'simple': {         'format': '%(levelname)s %(message)s'},
 }, 'loggers': {     # 所有django应用下的日志使用DEBUG级别
     'django': {         # this sets root level logger to log debug and higher level
         # logs to console. All other loggers inherit settings from
         # root level logger.
         'handlers': ['console_handler', "default_handler", 'error_handler'],         'level': 'DEBUG',         # 'propagate': True,  # this tells logger to send logging message
         # to its parent (will send if set to True)
     },     # 所有django.template下的日志使用INFO级别，并且不向上（django日志)传递，
     # 原因是如果使用DEBUG级别，碰到不存在的变量会在debug里打印错误栈帧
     'django.template': {         'handlers': ['console_handler', "default_handler", 'error_handler'],         'level': 'INFO',         'propagate': False,
     },     # 所有djanog.template下的日志使用DEBGUG级别打印日志
     'chameleon': {         'handlers': ['console_handler', "default_handler", 'error_handler'],         'level': 'DEBUG',
     },     # 登录登出系统专门用login_logout_handeler记录，并且会继续向上(chameleon)传递，记录到完整的里面
     'chameleon.views.views_login_logout': {         'handlers': ['login_logout_handler'],         'level': 'DEBUG',         'propagate': True,
     }
 },
}

import xml.etree.cElementTree as ETfrom jinja2 import Template
xml_root_cache = Nonedef get_sql_from_xml(xml, tag, **kwargs):
 logger.info(f"sql-info:get   {tag}   from {xml} kwargs: {kwargs}") global xml_root_cache if DEBUG:
     root = ET.ElementTree(file=xml).getroot() else:     if xml_root_cache is None:
         root = ET.ElementTree(file=xml).getroot()
         xml_root_cache = root     else:
         root = xml_root_cache
 t = root.find(tag) if not hasattr(t, "text"):     return ""
 template = Template(t.text)
 sql = template.render(**kwargs) return sql

from django.db import connection, transactiondef db_execute_with_trasaction(sql, *param):
 with connection.cursor() as cursor:
     cursor.execute(sql, *param)
     transaction.commit()def db_execute_with_trasaction(sql, *param):
 with connection.cursor() as cursor:
     cursor.execute(sql, *param)
     transaction.commit()def db_select_all(sql, *params):
 with connection.cursor() as cursor:
     cursor.execute(sql, *params)
     col_names = [desc[0] for desc in cursor.description]
     rows = cursor.fetchall()
     row = [dict(zip(col_names, r)) for r in rows]
 logging.info(f"sql-result:  {row}") return rowdef db_select_one(sql, *params):
 with connection.cursor() as cursor:
     cursor.execute(sql, *params)
     col_names = [desc[0] for desc in cursor.description]
     row = cursor.fetchone()     if row:
         row = dict(zip(col_names, row))     else:
         row = None
 logging.info(f"sql-result:  {row}") return row