记一次：django的页面操作的sql分析

开启查询记录

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 os

DEBUG = True
ALLOWED_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
http://127.0.0.1:8000/admin/router_in/communityline/add/?_changelist_filters=room__uuid__exact%3D8ec03342-9d04-48d0-8cb4-a4c49af5132a

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语句的执行效果

查询记录是否插入成功：