Mercurial > public > sg101

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

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
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 c4696a0cbd3f
children 9a68fd3bd8a5
rev   line source
bgneal@499 1 # Base Django settings for the gpp project.
bgneal@499 2
bgneal@499 3 import os
bgneal@499 4 from decimal import Decimal
bgneal@499 5
bgneal@499 6 import django.utils.simplejson as json
bgneal@499 7 from django.contrib.messages import constants as message_constants
bgneal@512 8 import djcelery
bgneal@515 9 from celery.schedules import crontab
bgneal@512 10
bgneal@499 11
bgneal@499 12 PROJECT_PATH = os.path.abspath(os.path.join(os.path.split(__file__)[0], '..'))
bgneal@499 13
bgneal@499 14 DEBUG = True
bgneal@499 15 TEMPLATE_DEBUG = DEBUG
bgneal@499 16
bgneal@499 17 ADMINS = (
bgneal@499 18 ('Brian Neal', 'admin@surfguitar101.com'),
bgneal@499 19 )
bgneal@499 20
bgneal@499 21 MANAGERS = ADMINS
bgneal@499 22
bgneal@499 23 AUTH_PROFILE_MODULE = 'bio.userprofile'
bgneal@499 24
bgneal@499 25 INTERNAL_IPS = ['127.0.0.1']
bgneal@499 26
bgneal@499 27 # Local time zone for this installation. Choices can be found here:
bgneal@499 28 # http://en.wikipedia.org/wiki/List_of_tz_zones_by_name
bgneal@499 29 # although not all choices may be available on all operating systems.
bgneal@499 30 # If running in a Windows environment this must be set to the same as your
bgneal@499 31 # system time zone.
bgneal@499 32 TIME_ZONE = 'America/Chicago'
bgneal@499 33
bgneal@499 34 # Language code for this installation. All choices can be found here:
bgneal@499 35 # http://www.i18nguy.com/unicode/language-identifiers.html
bgneal@499 36 LANGUAGE_CODE = 'en-us'
bgneal@499 37
bgneal@499 38 SITE_ID = 1
bgneal@499 39
bgneal@499 40 # If you set this to False, Django will make some optimizations so as not
bgneal@499 41 # to load the internationalization machinery.
bgneal@499 42 USE_I18N = False
bgneal@499 43
bgneal@499 44 # Absolute path to the directory that holds media.
bgneal@499 45 # Example: "/home/media/media.lawrence.com/"
bgneal@499 46 MEDIA_ROOT = os.path.abspath(os.path.join(PROJECT_PATH, '..', 'media'))
bgneal@499 47
bgneal@499 48 # URL that handles the media served from MEDIA_ROOT. Make sure to use a
bgneal@499 49 # trailing slash if there is a path component (optional in other cases).
bgneal@499 50 # Examples: "http://media.lawrence.com", "http://example.com/media/"
bgneal@499 51 MEDIA_URL = '/media/'
bgneal@499 52
bgneal@499 53 # URL prefix for admin media -- CSS, JavaScript and images. Make sure to use a
bgneal@499 54 # trailing slash.
bgneal@499 55 # Examples: "http://foo.com/media/", "/media/".
bgneal@499 56 ADMIN_MEDIA_PREFIX = '/static/admin/'
bgneal@499 57
bgneal@499 58 # Staticfiles settings:
bgneal@499 59 STATICFILES_DIRS = [
bgneal@499 60 os.path.abspath(os.path.join(PROJECT_PATH, '..', 'static')),
bgneal@499 61 ]
bgneal@499 62 STATIC_ROOT = '/tmp/test_static_root'
bgneal@499 63 STATIC_URL = '/static/'
bgneal@499 64
bgneal@499 65 # Make this unique, and don't share it with anybody.
bgneal@499 66 SECRETS = json.load(open(os.path.join(PROJECT_PATH, 'settings', 'secrets.json')))
bgneal@499 67 SECRET_KEY = SECRETS['SECRET_KEY']
bgneal@499 68
bgneal@499 69 # List of Loader classes that know how to import templates from various sources.
bgneal@499 70
bgneal@499 71 TEMPLATE_LOADERS = (
bgneal@499 72 'django.template.loaders.filesystem.Loader',
bgneal@499 73 'django.template.loaders.app_directories.Loader',
bgneal@499 74 )
bgneal@499 75
bgneal@499 76 MIDDLEWARE_CLASSES = [
bgneal@499 77 'django.middleware.common.CommonMiddleware',
bgneal@499 78 'django.middleware.csrf.CsrfViewMiddleware',
bgneal@499 79 'django.contrib.sessions.middleware.SessionMiddleware',
bgneal@499 80 'django.contrib.messages.middleware.MessageMiddleware',
bgneal@499 81 'django.contrib.auth.middleware.AuthenticationMiddleware',
bgneal@499 82 'gpp.core.middleware.InactiveUserMiddleware',
bgneal@499 83 'gpp.core.middleware.WhosOnline',
bgneal@499 84 'django.contrib.flatpages.middleware.FlatpageFallbackMiddleware',
bgneal@499 85 ]
bgneal@499 86
bgneal@499 87 ROOT_URLCONF = 'gpp.urls'
bgneal@499 88
bgneal@499 89 TEMPLATE_DIRS = (
bgneal@499 90 # Put strings here, like "/home/html/django_templates" or "C:/www/django/templates".
bgneal@499 91 # Always use forward slashes, even on Windows.
bgneal@499 92 # Don't forget to use absolute paths, not relative paths.
bgneal@499 93 os.path.join(PROJECT_PATH, 'templates'),
bgneal@499 94 )
bgneal@499 95
bgneal@499 96 TEMPLATE_CONTEXT_PROCESSORS = (
bgneal@499 97 "django.contrib.auth.context_processors.auth",
bgneal@499 98 "django.core.context_processors.debug",
bgneal@499 99 "django.core.context_processors.request",
bgneal@499 100 "django.core.context_processors.media",
bgneal@499 101 "django.core.context_processors.static",
bgneal@499 102 "django.contrib.messages.context_processors.messages",
bgneal@499 103 )
bgneal@499 104
bgneal@499 105 INSTALLED_APPS = [
bgneal@499 106 'django.contrib.admin',
bgneal@499 107 'django.contrib.admindocs',
bgneal@499 108 'django.contrib.auth',
bgneal@499 109 'django.contrib.contenttypes',
bgneal@499 110 'django.contrib.flatpages',
bgneal@499 111 'django.contrib.humanize',
bgneal@499 112 'django.contrib.markup',
bgneal@499 113 'django.contrib.messages',
bgneal@499 114 'django.contrib.sessions',
bgneal@499 115 'django.contrib.sites',
bgneal@499 116 'django.contrib.staticfiles',
bgneal@512 117 'djcelery',
bgneal@499 118 'elsewhere',
bgneal@499 119 'haystack',
bgneal@499 120 'queued_search',
bgneal@512 121 'tagging',
bgneal@499 122 'accounts',
bgneal@499 123 'antispam',
bgneal@499 124 'bio',
bgneal@499 125 'bulletins',
bgneal@499 126 'comments',
bgneal@499 127 'contact',
bgneal@540 128 'contests',
bgneal@499 129 'core',
bgneal@525 130 'custom_search',
bgneal@499 131 'donations',
bgneal@499 132 'downloads',
bgneal@499 133 'forums',
bgneal@499 134 'gcalendar',
bgneal@499 135 'irc',
bgneal@499 136 'legacy',
bgneal@499 137 'membermap',
bgneal@499 138 'messages',
bgneal@499 139 'news',
bgneal@499 140 'oembed',
bgneal@544 141 'phantombrigade',
bgneal@499 142 'podcast',
bgneal@499 143 'polls',
bgneal@499 144 'potd',
bgneal@499 145 'shoutbox',
bgneal@499 146 'smiley',
bgneal@499 147 'weblinks',
bgneal@499 148 'ygroup',
bgneal@499 149 ]
bgneal@499 150
bgneal@499 151 LOGIN_URL = '/accounts/login/'
bgneal@499 152 LOGIN_REDIRECT_URL = '/profile/me/'
bgneal@499 153 LOGOUT_URL = '/accounts/logout/'
bgneal@499 154
bgneal@499 155 FILE_UPLOAD_PERMISSIONS = 0644
bgneal@499 156 DEFAULT_FROM_EMAIL = ADMINS[0][1]
bgneal@499 157
bgneal@499 158 #######################################################################
bgneal@499 159 # Messages
bgneal@499 160 #######################################################################
bgneal@499 161 MESSAGE_STORAGE = 'django.contrib.messages.storage.session.SessionStorage'
bgneal@499 162 MESSAGE_TAGS = {
bgneal@499 163 message_constants.DEBUG: 'notice',
bgneal@499 164 message_constants.INFO: 'info',
bgneal@499 165 message_constants.SUCCESS: 'success',
bgneal@499 166 message_constants.WARNING: 'alert',
bgneal@499 167 message_constants.ERROR: 'error',
bgneal@499 168 }
bgneal@499 169
bgneal@499 170 #######################################################################
bgneal@499 171 # Email
bgneal@499 172 #######################################################################
bgneal@499 173 EMAIL_HOST = 'localhost'
bgneal@499 174 EMAIL_PORT = 1025
bgneal@512 175 EMAIL_BACKEND = 'django.core.mail.backends.console.EmailBackend'
bgneal@499 176
bgneal@499 177 #######################################################################
bgneal@499 178 # Sessions
bgneal@499 179 #######################################################################
bgneal@499 180 SESSION_ENGINE = "django.contrib.sessions.backends.cached_db"
bgneal@499 181 SESSION_COOKIE_AGE = 2 * 7 * 24 * 60 * 60 # 2 weeks in seconds
bgneal@499 182 SESSION_COOKIE_DOMAIN = None
bgneal@499 183 SESSION_COOKIE_NAME = 'sg101_sessionid'
bgneal@499 184 SESSION_COOKIE_PATH = '/'
bgneal@499 185 SESSION_COOKIE_SECURE = False
bgneal@499 186 SESSION_EXPIRE_AT_BROWSER_CLOSE = False
bgneal@499 187 SESSION_SAVE_EVERY_REQUEST = False
bgneal@499 188
bgneal@499 189 #######################################################################
bgneal@499 190 # Tagging Specific Settings
bgneal@499 191 #######################################################################
bgneal@499 192 FORCE_LOWERCASE_TAGS = True
bgneal@499 193 MAX_TAG_LENGTH = 50
bgneal@499 194
bgneal@499 195 #######################################################################
bgneal@499 196 # Haystack Search Settings
bgneal@499 197 #######################################################################
bgneal@499 198 HAYSTACK_SITECONF = 'gpp.search_sites'
bgneal@499 199 HAYSTACK_SEARCH_ENGINE = 'xapian'
bgneal@499 200 HAYSTACK_XAPIAN_PATH = os.path.join(PROJECT_PATH, 'xapian_index')
bgneal@499 201
bgneal@499 202
bgneal@499 203 #######################################################################
bgneal@522 204 # Redis integration & settings
bgneal@522 205 #######################################################################
bgneal@522 206 REDIS_HOST = 'localhost'
bgneal@522 207 REDIS_PORT = 6379
bgneal@522 208 REDIS_DB = 0
bgneal@522 209
bgneal@522 210 #######################################################################
bgneal@512 211 # Celery integration & settings
bgneal@512 212 #######################################################################
bgneal@512 213 BROKER_URL = 'redis://localhost:6379/1'
bgneal@512 214 BROKER_POOL_LIMIT = 10
bgneal@512 215
bgneal@514 216 CELERY_IGNORE_RESULT = True
bgneal@512 217 CELERY_RESULT_BACKEND = 'redis'
bgneal@512 218 CELERY_REDIS_HOST = 'localhost'
bgneal@512 219 CELERY_REDIS_PORT = 6379
bgneal@512 220 CELERY_REDIS_DB = 1
bgneal@512 221
bgneal@512 222 CELERY_DISABLE_RATE_LIMITS = True
bgneal@512 223 CELERY_SEND_TASK_ERROR_EMAILS = True
bgneal@512 224
bgneal@512 225 djcelery.setup_loader()
bgneal@512 226
bgneal@515 227 CELERYBEAT_SCHEDULE = {
bgneal@515 228 "potd": {
bgneal@515 229 "task": "potd.tasks.pick_potd",
bgneal@515 230 "schedule": crontab(minute=0, hour=0),
bgneal@516 231 },
bgneal@516 232 "cleanup": {
bgneal@516 233 "task": "core.tasks.cleanup",
bgneal@516 234 "schedule": crontab(minute=0, hour=1),
bgneal@516 235 },
bgneal@519 236 "purge_messages": {
bgneal@518 237 "task": "messages.tasks.purge_messages",
bgneal@518 238 "schedule": crontab(minute=30, hour=1, day_of_week='sunday'),
bgneal@519 239 },
bgneal@519 240 "max_users": {
bgneal@519 241 "task": "core.tasks.max_users",
bgneal@519 242 "schedule": crontab(minute='*/15'),
bgneal@519 243 },
bgneal@525 244 "search_queue": {
bgneal@525 245 "task": "custom_search.tasks.process_search_queue_task",
bgneal@525 246 "schedule": crontab(minute='*/20'),
bgneal@525 247 },
bgneal@515 248 }
bgneal@515 249
bgneal@512 250 #######################################################################
bgneal@499 251 # GPP Specific Settings
bgneal@499 252 #######################################################################
bgneal@499 253 GPP_NO_REPLY_EMAIL = 'no_reply'
bgneal@499 254 AVATAR_DIR = 'avatars'
bgneal@499 255 MAX_AVATAR_SIZE_BYTES = 2 * 1024 * 1024
bgneal@499 256 MAX_AVATAR_SIZE_PIXELS = 100
bgneal@499 257 AVATAR_DEFAULT_URL = MEDIA_URL + AVATAR_DIR + '/default.png'
bgneal@499 258
bgneal@499 259 # Donations application settings:
bgneal@499 260 DONATIONS_DEBUG = False
bgneal@499 261 DONATIONS_ITEM_NAME = 'Donation for SurfGuitar101.com'
bgneal@499 262 DONATIONS_BUSINESS = 'brian@surfguitar101.com'
bgneal@499 263 DONATIONS_BUSINESS_DEBUG = 'bgneal_1246137628_biz@gmail.com'
bgneal@499 264 DONATIONS_GOAL = Decimal('100.00') # monthly goal
bgneal@499 265 DONATIONS_ANON_NAME = u'Anonymous'
bgneal@499 266 DONATIONS_ITEM_NUM = '500' # donation w/name listed
bgneal@499 267 DONATIONS_ITEM_ANON_NUM = '501' # donation listed as anonymous
bgneal@499 268
bgneal@499 269 # Oembed settings
bgneal@499 270 OEMBED_MAXWIDTH = 480
bgneal@499 271 OEMBED_MAXHEIGHT = 295
bgneal@499 272
bgneal@499 273 # GCalendar settings
bgneal@499 274 GCAL_CALENDAR_ID = 'i81lu3fkh57sgqqenogefd9v78@group.calendar.google.com'
bgneal@499 275
bgneal@499 276 # Google OAuth settings
bgneal@499 277 GOOGLE_OAUTH_CONSUMER_KEY = 'surfguitar101.com'
bgneal@514 278 GOOGLE_OAUTH_PRIVATE_KEY_PATH = SECRETS['GOOGLE_KEY_PATH']
bgneal@499 279
bgneal@544 280 # Phantom Brigade TeamSpeak3 settings
bgneal@544 281 PB_TS3_IP = '206.123.95.194'
bgneal@544 282 PB_TS3_PORT = 10011
bgneal@544 283 PB_TS3_VID = 6113
bgneal@544 284
bgneal@499 285 #######################################################################
bgneal@499 286 # Asynchronous settings (queues, queued_search, redis, celery, etc)
bgneal@499 287 #######################################################################
bgneal@499 288 QUEUE_BACKEND = 'redisd'
bgneal@499 289 QUEUE_REDIS_CONNECTION = 'localhost:6379'
bgneal@499 290 QUEUE_REDIS_DB = 0
bgneal@499 291
bgneal@499 292 #######################################################################
bgneal@499 293 # Open Graph Protocol related settings
bgneal@499 294 #######################################################################
bgneal@499 295 OGP_DEFAULT_IMAGE = 'http://surfguitar101.com/media/podcast/podcast_logo.jpg'
bgneal@499 296 OGP_FB_ID = '100001558124013'
bgneal@549 297 OGP_SITE_DESCRIPTION = ('The premier community website for friends and fans of'
bgneal@549 298 ' instrumental surf music. We have forums, podcasts, surf music news, an'
bgneal@549 299 ' event calendar, and much more! The surf is always up at'
bgneal@549 300 ' SurfGuitar101.com!')
bgneal@499 301
bgneal@499 302 #######################################################################
bgneal@499 303 # URL's of 3rd party Javascript and CSS files.
bgneal@499 304 # These dictionaries are used by core/templatetags/script_tags, and
bgneal@499 305 # should also be used by developers when creating form media classes.
bgneal@499 306 GPP_THIRD_PARTY_JS = {
bgneal@499 307 'jquery': [
bgneal@499 308 'http://ajax.googleapis.com/ajax/libs/jquery/1.5.2/jquery.min.js',
bgneal@499 309 ],
bgneal@499 310 'jquery-jeditable': [
bgneal@499 311 'js/jquery.jeditable.mini.js',
bgneal@499 312 ],
bgneal@499 313 'jquery-ui': [
bgneal@499 314 'http://ajax.googleapis.com/ajax/libs/jqueryui/1.8.12/jquery-ui.min.js',
bgneal@499 315 ],
bgneal@499 316 'markitup': [
bgneal@499 317 'js/markitup/jquery.markitup.pack.js',
bgneal@499 318 'js/markitup/sets/markdown/set.js',
bgneal@499 319 ],
bgneal@499 320 'tiny_mce': [
bgneal@499 321 'js/tiny_mce/tiny_mce.js',
bgneal@499 322 'js/tiny_mce_init_std.js',
bgneal@499 323 ],
bgneal@499 324 }
bgneal@499 325
bgneal@499 326 GPP_THIRD_PARTY_CSS = {
bgneal@499 327 'jquery-ui': [
bgneal@499 328 'http://ajax.googleapis.com/ajax/libs/jqueryui/1.8.12/themes/redmond/jquery-ui.css',
bgneal@499 329 ],
bgneal@499 330 'markitup': [
bgneal@499 331 'js/markitup/skins/markitup/style.css',
bgneal@499 332 'js/markitup/sets/markdown/style.css',
bgneal@499 333 ],
bgneal@499 334 }
bgneal@499 335