annotate gpp/settings/local.py @ 552:9e42e6618168

For bitbucket issue #2, tweak the admin settings for the Post model to reduce slow queries. Define our own queryset() method so we can control the select_related(), and not have it cascade from post to topics to forums to categories. Removed 'topic' from list_display because MySQL still sucked with 2 inner joins. Now it seems to be tolerable with only one join to User.
author Brian Neal <bgneal@gmail.com>
date Wed, 25 Jan 2012 20:07:03 -0600
parents 1a09a7bea000
children abc4be5a82e5
rev   line source
bgneal@499 1 """
bgneal@499 2 Local Django settings.
bgneal@499 3
bgneal@499 4 """
bgneal@499 5 from settings.base import *
bgneal@499 6
bgneal@499 7 DEBUG = True
bgneal@499 8
bgneal@499 9 DATABASES = {
bgneal@499 10 'default': {
bgneal@499 11 'ENGINE': 'django.db.backends.mysql',
bgneal@499 12 'NAME': 'gremmies_portal',
bgneal@499 13 'USER': SECRETS['DB_USER'],
bgneal@499 14 'PASSWORD': SECRETS['DB_PASSWORD'],
bgneal@499 15 },
bgneal@499 16 }
bgneal@499 17
bgneal@499 18 # Django Debug Toolbar support
bgneal@499 19 if DEBUG:
bgneal@499 20 try:
bgneal@499 21 import debug_toolbar
bgneal@499 22 except ImportError:
bgneal@499 23 pass
bgneal@499 24 else:
bgneal@499 25 i = MIDDLEWARE_CLASSES.index('django.middleware.common.CommonMiddleware')
bgneal@499 26 MIDDLEWARE_CLASSES.insert(i + 1,
bgneal@499 27 'debug_toolbar.middleware.DebugToolbarMiddleware')
bgneal@499 28 INSTALLED_APPS.append('debug_toolbar')
bgneal@499 29 DEBUG_TOOLBAR_CONFIG = {
bgneal@499 30 'INTERCEPT_REDIRECTS': True,
bgneal@499 31 }
bgneal@499 32
bgneal@499 33 # Path to elsewhere application static images
bgneal@499 34 STATICFILES_DIRS.append(('elsewhere',
bgneal@499 35 '/home/brian/coding/python/django/3rdparty/elsewhere/img'))
bgneal@499 36
bgneal@499 37 # Logging configuration
bgneal@499 38
bgneal@499 39 LOGGING = {
bgneal@499 40 'version': 1,
bgneal@499 41 'disable_existing_loggers': True,
bgneal@499 42 'formatters': {
bgneal@499 43 'verbose': {
bgneal@499 44 'format': '%(asctime)s %(levelname)s %(module)s %(process)d %(thread)d %(message)s'
bgneal@499 45 },
bgneal@499 46 'simple': {
bgneal@499 47 'format': '%(asctime)s %(levelname)s %(message)s'
bgneal@499 48 },
bgneal@499 49 },
bgneal@499 50 'handlers': {
bgneal@499 51 'console': {
bgneal@499 52 'class': 'logging.StreamHandler',
bgneal@499 53 'level': 'DEBUG',
bgneal@499 54 'formatter': 'simple',
bgneal@499 55 },
bgneal@499 56 'file': {
bgneal@499 57 'class': 'logging.handlers.RotatingFileHandler',
bgneal@499 58 'level': 'DEBUG',
bgneal@499 59 'formatter': 'simple',
bgneal@499 60 'filename': os.path.join(PROJECT_PATH, 'logs', 'sg101.log'),
bgneal@499 61 'mode': 'a',
bgneal@499 62 'maxBytes': 100 * 1024,
bgneal@499 63 'backupCount': 10,
bgneal@499 64 },
bgneal@499 65 'mail_admins': {
bgneal@499 66 'class': 'django.utils.log.AdminEmailHandler',
bgneal@499 67 'level': 'ERROR',
bgneal@499 68 'formatter': 'simple',
bgneal@499 69 },
bgneal@499 70 },
bgneal@499 71 'loggers': {
bgneal@499 72 'django':{
bgneal@499 73 'level': 'WARNING',
bgneal@499 74 'propagate': False,
bgneal@499 75 'handlers': ['file'],
bgneal@499 76 },
bgneal@499 77 },
bgneal@499 78 'root': {
bgneal@499 79 'level': 'DEBUG',
bgneal@499 80 'handlers': ['file'],
bgneal@499 81 },
bgneal@499 82 }