本文共 5231 字，大约阅读时间需要 17 分钟。

开启查询记录

D:\shen\python\PythonWebDev\web_develop\network\networkconsole-master\networkconsole\settings.py

# 日志配置LOGGING = {    'version': 1,    'disable_existing_loggers': False,    'formatters': {        'standard': {            'format': '[%(asctime)s] [%(module)s:%(funcName)s] %(message)s'        },    },    'handlers': {        'request_handler': {            'level': 'DEBUG',            'class': 'logging.handlers.RotatingFileHandler',            'filename': conf.LOG_REQUEST_ERROR_PATH,            'maxBytes': 1024*1024*50,            'backupCount': 5,            'formatter': 'standard',            'encoding': 'utf-8',        },        'message_handler': {            'level': 'DEBUG',            'class': 'logging.handlers.RotatingFileHandler',            'filename': conf.MESSAGE_PATH,            'maxBytes': 1024*1024*50,            'backupCount': 5,            'formatter': 'standard',            'encoding': 'utf-8',        },        'sql_handler': {            'level': 'DEBUG',            'class': 'logging.handlers.RotatingFileHandler',            'filename': conf.LOG_SQL_PATH,            'maxBytes': 1024*1024*50,            'backupCount': 5,            'formatter': 'standard',            'encoding': 'utf-8',        },    },    'loggers': {        'django.request': {            'handlers': ['request_handler'],            'level': 'DEBUG',            'propagate': False,        },        'message': {            'handlers': ['message_handler'],            'level': 'DEBUG',            'propagate': False,        },        'django.db.backends': {            'level': 'DEBUG',            'handlers': ['sql_handler'],            'propagate': True,        }    },}

日志路径

D:\shen\python\PythonWebDev\web_develop\network\networkconsole-master\networkconsole\conf.py

import osDEBUG = TrueALLOWED_HOSTS = ['*']DB_NAME = os.getenv("DB_NAME", "nms_console")DB_USER = os.getenv("DB_USER", 'root')DB_PASSWORD = os.getenv("DB_PASSWORD", '')DB_HOST = os.getenv("DB_HOST", "localhost")DB_PORT = int(os.getenv("DB_PORT", "3306"))REDIS_HOST = os.getenv("REDIS_HOST", '127.0.0.1')REDIS_PORT = int(os.getenv("REDIS_PORT", '6379'))LDAP_SERVER_URI = os.getenv("LDAP_SERVER_URI", 'ldap://10.222.10.244:389')LDAP_PASSWORD = os.getenv("LDAP_PASSWORD", 'OUm6Wau+VuBX')LOCK_FILE_PATH = '/ikglobal/lock/'MESSAGE_PATH = '/ikglobal/logs/message.log'LOG_REQUEST_ERROR_PATH = '/ikglobal/logs/request_error.log'LOG_SQL_PATH = '/ikglobal/logs/sql.log'

界面操作：

url

sql打印：

[root@localhost ~]# tail -f /ikglobal/logs/sql.log

[2019-09-13 01:11:10,578] [utils:execute] (0.000) SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED; args=None[2019-09-13 01:11:10,581] [utils:execute] (0.002) SELECT `django_session`.`session_key`, `django_session`.`session_data`, `django_session`.`expire_date` FROM `django_session` WHERE (`django_session`.`expire_date` > '2019-09-12 17:11:10.574839' AND `django_session`.`session_key` = 'mbzgih42y6kci24hjpozevptli65gsb1'); args=('2019-09-12 17:11:10.574839', 'mbzgih42y6kci24hjpozevptli65gsb1')[2019-09-13 01:11:10,594] [utils:execute] (0.009) SELECT `auth_user`.`id`, `auth_user`.`password`, `auth_user`.`last_login`, `auth_user`.`is_superuser`, `auth_user`.`username`, `auth_user`.`first_name`, `auth_user`.`last_name`, `auth_user`.`email`, `auth_user`.`is_staff`, `auth_user`.`is_active`, `auth_user`.`date_joined` FROM `auth_user` WHERE `auth_user`.`id` = 1; args=(1,)[2019-09-13 01:11:10,606] [utils:execute] (0.007) SELECT `common_room`.`uuid`, `common_room`.`name`, `common_room`.`enable_qy`, `common_room`.`enable_route`, `common_room`.`server_url`, `common_room`.`username`, `common_room`.`secret_key`, `common_room`.`weight` FROM `common_room` WHERE `common_room`.`uuid` = '8ec033429d0448d08cb4a4c49af5132a'; args=('8ec033429d0448d08cb4a4c49af5132a',)[2019-09-13 01:11:10,626] [utils:execute] (0.007) SELECT `in_community_line`.`room_id`, `in_community_line`.`uuid`, `in_community_line`.`name`, `in_community_line`.`parent_id`, `in_community_line`.`lft`, `in_community_line`.`rght`, `in_community_line`.`tree_id`, `in_community_line`.`level` FROM `in_community_line` WHERE (`in_community_line`.`name` > 'test2' AND `in_community_line`.`parent_id` IS NULL AND NOT (`in_community_line`.`uuid` = 'a100d100989b4fbaa954bf60c832d6ea')) ORDER BY `in_community_line`.`name` ASC, `in_community_line`.`tree_id` ASC LIMIT 1; args=('test2', 'a100d100989b4fbaa954bf60c832d6ea')[2019-09-13 01:11:10,644] [utils:execute] (0.015) SELECT MAX(`in_community_line`.`tree_id`) AS `tree_id__max` FROM `in_community_line`; args=()[2019-09-13 01:11:10,648] [utils:execute] (0.002) INSERT INTO `in_community_line` (`room_id`, `uuid`, `name`, `parent_id`, `lft`, `rght`, `tree_id`, `level`) VALUES ('8ec033429d0448d08cb4a4c49af5132a', 'a100d100989b4fbaa954bf60c832d6ea', 'test2', NULL, 1, 2, 3, 0); args=('8ec033429d0448d08cb4a4c49af5132a', 'a100d100989b4fbaa954bf60c832d6ea', 'test2', None, 1, 2, 3, 0)[2019-09-13 01:13:18,788] [utils:execute] (0.000) SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED; args=None[2019-09-13 01:13:18,792] [utils:execute] (0.002) DELETE FROM `message_channel_countonlineperson` WHERE `message_channel_countonlineperson`.`user_id` = 1; args=(1,)

执行打印的sql进一步获取细节信息：

 看看insert语句的执行效果

查询记录是否插入成功：

转载地址：http://rsfld.baihongyu.com/