diff options
author | Alexandru DAMIAN <alexandru.damian@intel.com> | 2014-11-05 13:30:31 +0000 |
---|---|---|
committer | Richard Purdie <richard.purdie@linuxfoundation.org> | 2014-11-12 17:04:48 +0000 |
commit | 990fb9ed6cc8414e9a0b1baed8990261650af1db (patch) | |
tree | 1ed10c5bc93660fe6727ae014a85997c44f811db | |
parent | 3e9fc8d0916f1d51dd6b748fff966d8aafd7f438 (diff) | |
download | ast2050-yocto-poky-990fb9ed6cc8414e9a0b1baed8990261650af1db.zip ast2050-yocto-poky-990fb9ed6cc8414e9a0b1baed8990261650af1db.tar.gz |
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 <alexandru.damian@intel.com>
Signed-off-by: Richard Purdie <richard.purdie@linuxfoundation.org>
-rw-r--r-- | bitbake/lib/toaster/toastermain/settings.py | 21 |
1 files changed, 21 insertions, 0 deletions
diff --git a/bitbake/lib/toaster/toastermain/settings.py b/bitbake/lib/toaster/toastermain/settings.py index 42581f2..8de3b52 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): |