Advertisement
Guest User

Untitled

a guest
Nov 26th, 2016
231
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Python 2.92 KB | None | 0 0
  1. ## error
  2.  
  3. Exception Type: ProgrammingError
  4. Exception Value:   
  5. relation "demo_query" does not exist
  6. LINE 1: SELECT COUNT(*) AS "__count" FROM "demo_query"
  7.                                           ^
  8. Exception Location: C:\Users\zack\AppData\Local\Programs\Python\Python35-32\lib\site-packages\django\db\backends\utils.py in execute, line 64
  9.  
  10. ## tables.py
  11.  
  12. import django_tables2 as tables
  13. from .models import Query
  14.  
  15. data = [{"query":"apples", "parent":"camden", "active": True, "date_added":"2016-09-18 17:36:27.585893", "date_deactivated":"2016-09-18 17:36:27.585893"},
  16.  {"query":"beers", "parent":"camden", "active": True, "date_added":"2016-09-18 17:38:59.053775", "date_deactivated":"2016-09-18 17:38:59.053775"},
  17.  {"query":"emmys", "parent":"kappa", "active": True, "date_added":"2016-09-18 17:32:59.041354", "date_deactivated":"2016-09-18 17:32:59.041354"}]
  18.  
  19. class QueryTable(tables.Table):
  20.     class Meta:
  21.         model = Query
  22.  
  23. table = QueryTable(data)
  24.  
  25. ## models.py
  26.  
  27. from django.db import models
  28.  
  29. class Query(models.Model):
  30.     query = models.CharField(max_length=200, verbose_name="query text")
  31.     parent = models.CharField(max_length=200, verbose_name="query parent")
  32.     active = models.BooleanField(verbose_name="currently active")
  33.     date_added = models.DateTimeField(auto_now_add=True)
  34.     date_deactivated = models.DateTimeField(auto_now_add=True)
  35.  
  36. ## views.py
  37.  
  38. # -*- coding: utf-8 -*-
  39. from __future__ import unicode_literals
  40. from django.core.files.storage import default_storage
  41.  
  42. from django.core.paginator import Paginator, PageNotAnInteger, EmptyPage
  43. from django.db.models.fields.files import FieldFile
  44. from django.views.generic import FormView
  45. from django.views.generic.base import TemplateView
  46. from django.contrib import messages
  47. from django.shortcuts import render
  48. from django_tables2 import RequestConfig
  49.  
  50. from .forms import ContactForm, ContactFormSet, AddQueryForm
  51. from .models import Query
  52. from .tables import QueryTable
  53.  
  54. def queries(request):
  55.     table = QueryTable(Query.objects.all())
  56.     RequestConfig(request).configure(table)
  57.     return render(request, 'table_test.html', {'table': table})
  58.  
  59. class FakeField(object):
  60.     storage = default_storage
  61.  
  62. fieldfile = FieldFile(None, FakeField, 'dummy.txt')
  63.  
  64. class HomePageView(TemplateView):
  65.     template_name = 'demo/home.html'
  66.  
  67.     def get_context_data(self, **kwargs):
  68.         context = super(HomePageView, self).get_context_data(**kwargs)
  69.         messages.info(self.request, 'hello http://example.com')
  70.         return context
  71.  
  72. class DefaultFormView(FormView):
  73.     template_name = 'demo/form.html'
  74.     form_class = ContactForm
  75.  
  76. class AddQuery(FormView):
  77.     template_name = 'demo/add_query.html'
  78.     form_class = AddQueryForm
  79.  
  80. ##table_test.html
  81. {% extends 'demo/base.html' %}
  82.  
  83. {% load bootstrap3 %}
  84.  
  85. {% block title %}
  86.    Table Test
  87. {% endblock %}
  88.  
  89. {% load render_table from django_tables2 %}
  90. {% render_table table %}
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement