Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- ## error
- Exception Type: ProgrammingError
- Exception Value:
- relation "demo_query" does not exist
- LINE 1: SELECT COUNT(*) AS "__count" FROM "demo_query"
- ^
- Exception Location: C:\Users\zack\AppData\Local\Programs\Python\Python35-32\lib\site-packages\django\db\backends\utils.py in execute, line 64
- ## tables.py
- import django_tables2 as tables
- from .models import Query
- 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"},
- {"query":"beers", "parent":"camden", "active": True, "date_added":"2016-09-18 17:38:59.053775", "date_deactivated":"2016-09-18 17:38:59.053775"},
- {"query":"emmys", "parent":"kappa", "active": True, "date_added":"2016-09-18 17:32:59.041354", "date_deactivated":"2016-09-18 17:32:59.041354"}]
- class QueryTable(tables.Table):
- class Meta:
- model = Query
- table = QueryTable(data)
- ## models.py
- from django.db import models
- class Query(models.Model):
- query = models.CharField(max_length=200, verbose_name="query text")
- parent = models.CharField(max_length=200, verbose_name="query parent")
- active = models.BooleanField(verbose_name="currently active")
- date_added = models.DateTimeField(auto_now_add=True)
- date_deactivated = models.DateTimeField(auto_now_add=True)
- ## views.py
- # -*- coding: utf-8 -*-
- from __future__ import unicode_literals
- from django.core.files.storage import default_storage
- from django.core.paginator import Paginator, PageNotAnInteger, EmptyPage
- from django.db.models.fields.files import FieldFile
- from django.views.generic import FormView
- from django.views.generic.base import TemplateView
- from django.contrib import messages
- from django.shortcuts import render
- from django_tables2 import RequestConfig
- from .forms import ContactForm, ContactFormSet, AddQueryForm
- from .models import Query
- from .tables import QueryTable
- def queries(request):
- table = QueryTable(Query.objects.all())
- RequestConfig(request).configure(table)
- return render(request, 'table_test.html', {'table': table})
- class FakeField(object):
- storage = default_storage
- fieldfile = FieldFile(None, FakeField, 'dummy.txt')
- class HomePageView(TemplateView):
- template_name = 'demo/home.html'
- def get_context_data(self, **kwargs):
- context = super(HomePageView, self).get_context_data(**kwargs)
- messages.info(self.request, 'hello http://example.com')
- return context
- class DefaultFormView(FormView):
- template_name = 'demo/form.html'
- form_class = ContactForm
- class AddQuery(FormView):
- template_name = 'demo/add_query.html'
- form_class = AddQueryForm
- ##table_test.html
- {% extends 'demo/base.html' %}
- {% load bootstrap3 %}
- {% block title %}
- Table Test
- {% endblock %}
- {% load render_table from django_tables2 %}
- {% render_table table %}
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement