From 990fb9ed6cc8414e9a0b1baed8990261650af1db Mon Sep 17 00:00:00 2001 From: Alexandru DAMIAN Date: Wed, 5 Nov 2014 13:30:31 +0000 Subject: bitbake: toaster: SQL query logging We add a logger, enabled through the settings.py, that logs all SQL queries, with timestamp and duration, to console. This is helpful in profiling the SQL queries. The facility is disabled by default. (Bitbake rev: 54fd0a76fa3154adfab5688ecc96963f42cded11) Signed-off-by: Alexandru DAMIAN Signed-off-by: Richard Purdie --- bitbake/lib/toaster/toastermain/settings.py | 21 +++++++++++++++++++++ 1 file changed, 21 insertions(+) (limited to 'bitbake/lib/toaster/toastermain/settings.py') diff --git a/bitbake/lib/toaster/toastermain/settings.py b/bitbake/lib/toaster/toastermain/settings.py index 42581f2df4..8de3b52f34 100644 --- a/bitbake/lib/toaster/toastermain/settings.py +++ b/bitbake/lib/toaster/toastermain/settings.py @@ -24,6 +24,10 @@ DEBUG = True TEMPLATE_DEBUG = DEBUG +# Set to True to see the SQL queries in console +SQL_DEBUG = False + + ADMINS = ( # ('Your Name', 'your_email@example.com'), ) @@ -276,11 +280,21 @@ LOGGING = { '()': 'django.utils.log.RequireDebugFalse' } }, + 'formatters': { + 'datetime': { + 'format': 'DB %(asctime)s %(message)s' + } + }, 'handlers': { 'mail_admins': { 'level': 'ERROR', 'filters': ['require_debug_false'], 'class': 'django.utils.log.AdminEmailHandler' + }, + 'console': { + 'level': 'DEBUG', + 'class': 'logging.StreamHandler', + 'formatter': 'datetime', } }, 'loggers': { @@ -292,6 +306,13 @@ LOGGING = { } } +if DEBUG and SQL_DEBUG: + LOGGING['loggers']['django.db.backends'] = { + 'level': 'DEBUG', + 'handlers': ['console'], + } + + # If we're using sqlite, we need to tweak the performance a bit from django.db.backends.signals import connection_created def activate_synchronous_off(sender, connection, **kwargs): -- cgit 1.2.3-korg