Added index on post.opening. Use it when getting OP of a thread

boards/migrations/0035_auto_20151021_1346.py

@@ -0,0 +1,19 b''
+# -*- coding: utf-8 -*-
+from __future__ import unicode_literals
+
+from django.db import migrations, models
+
+
+class Migration(migrations.Migration):
+
+    dependencies = [
+        ('boards', '0034_auto_20151014_2253'),
+    ]
+
+    operations = [
+        migrations.AlterField(
+            model_name='post',
+            name='opening',
+            field=models.BooleanField(db_index=True),
+        ),
+    ]

boards/models/post/__init__.py

@@ -98,7 +98,7 b' class Post(models.Model, Viewable):'
     uid = models.TextField(db_index=True)
 
     tripcode = models.CharField(max_length=50, blank=True, default='')
-    opening = models.BooleanField()
+    opening = models.BooleanField(db_index=True)
     hidden = models.BooleanField(default=False)
 
     def __str__(self):

boards/models/thread.py

@@ -194,7 +194,7 b' class Thread(models.Model):'
         Gets the first post of the thread
         """
 
-        query = self.get_replies().order_by('pub_time')
+        query = self.get_replies().filter(opening=True)
         if only_id:
             query = query.only('id')
         opening_post = query.first()

neboard/settings.py

@@ -109,7 +109,7 b' TEMPLATE_CONTEXT_PROCESSORS = ('
     'boards.context_processors.user_and_ui_processor',
 )
 
-MIDDLEWARE_CLASSES = (
+MIDDLEWARE_CLASSES = [
     'django.middleware.http.ConditionalGetMiddleware',
     'django.contrib.sessions.middleware.SessionMiddleware',
     'django.middleware.locale.LocaleMiddleware',
@@ -118,7 +118,7 b' MIDDLEWARE_CLASSES = ('
     'django.contrib.messages.middleware.MessageMiddleware',
     'boards.middlewares.BanMiddleware',
     'boards.middlewares.TimezoneMiddleware',
-)
+]
 
 ROOT_URLCONF = 'neboard.urls'
 
@@ -208,6 +208,8 b' IMAGE_VIEWERS = ['
     ('popup', 'Popup'),
 ]
 
+ALLOWED_HOSTS = ['*']
+
 POSTING_DELAY = 20  # seconds
 
 # Websocket settins
@@ -219,21 +221,20 b" CENTRIFUGE_PROJECT_ID = '<project id her"
 CENTRIFUGE_PROJECT_SECRET = '<project secret here>'
 CENTRIFUGE_TIMEOUT = 5
 
-# Debug mode middlewares
-if DEBUG:
-    MIDDLEWARE_CLASSES += (
-        'debug_toolbar.middleware.DebugToolbarMiddleware',
-    )
+# Debug middlewares
+MIDDLEWARE_CLASSES += [
+    'debug_toolbar.middleware.DebugToolbarMiddleware',
+]
 
-    def custom_show_toolbar(request):
-        return True
+def custom_show_toolbar(request):
+    return request.user.has_perm('admin.debug')
 
-    DEBUG_TOOLBAR_CONFIG = {
-        'ENABLE_STACKTRACES': True,
-        'SHOW_TOOLBAR_CALLBACK': 'neboard.settings.custom_show_toolbar',
-    }
+DEBUG_TOOLBAR_CONFIG = {
+    'ENABLE_STACKTRACES': True,
+    'SHOW_TOOLBAR_CALLBACK': 'neboard.settings.custom_show_toolbar',
+}
 
-    # FIXME Uncommenting this fails somehow. Need to investigate this
-    #DEBUG_TOOLBAR_PANELS += (
-    #    'debug_toolbar.panels.profiling.ProfilingDebugPanel',
-    #)
+# FIXME Uncommenting this fails somehow. Need to investigate this
+#DEBUG_TOOLBAR_PANELS += (
+#    'debug_toolbar.panels.profiling.ProfilingDebugPanel',
+#)