Querying a django DB with model forms

Question

Okay, so I'm trying to teach myself django by trying to put together a simple DB query application.

So I have in my DB a relation mysql table storing triples (RDF, subj, obj, pred) and I have written a model form with the fields to query that. Though, I have initially setup my form to store the queries in a separate table. What I would like to do however, is the model form I created to instead query the triple table. Here is my code:

view:

from django.shortcuts import render, get_object_or_404, render_to_response
from django.template import RequestContext

# Create your views here.
from .forms import QueryForm
from .models import Query

def queries_create(request):
    form = QueryForm(request.POST or None)
    if form.is_valid():
        instance = form.save(commit=False)
        instance.save()

    context = {

        "title":"Create",
        "form": form,

    }
    #return HttpResponse("<h1>create</h1>")
    return render(request, "query_form.html", context)

model:

from __future__ import unicode_literals

from django.db import models
from django.core.urlresolvers import reverse

# Create your models here.

class Query(models.Model):
    studyName = models.CharField(max_length=250)
    population = models.IntegerField()
    intervention = models.CharField(max_length=250)
    comparison = models.CharField(max_length=250)
    outcome = models.CharField(max_length=250)
    outcomeTiming = models.CharField(max_length=250)

    updated = models.DateTimeField(auto_now=True, auto_now_add=False)
    timestamp = models.DateTimeField(auto_now=False, auto_now_add=True)

    def __unicode__(self):
        return self.studyName


    def get_absolute_url(self):
        return reverse("queries:detail", kwargs={"id": self.id})
        #return "/queries/%s/" %(self.id)

form:

from django import forms

from .models import Query

class QueryForm(forms.ModelForm):
    class Meta:
        model = Query
        fields = [

            "studyName",
            "population",
            "intervention",
            "comparison",
            "outcome",
            "outcomeTiming",

    ]

html:

<!--DOCTYPE html -->

<html>
<body>
<h1>Query the Model</h1>

<form method='POST' action=''>{% csrf_token %}
{{  form  }}
<input type='submit' value='Query!' />
</form>

</body>
</html>

Any help would be appreciated I've tried several modifications but nothing seems to be working.

You need to let us know what error do you have. nothing seems to be working is not enough for us to debug it for you. — Shang Wang
– Shang Wang, Commented Feb 17, 2016 at 16:33
This code block works but inserts the form data into its own DB. However, what I would like to do is instead of POST I would like to search the DB by keyword and return matching files. — jdv12
– jdv12, Commented Feb 17, 2016 at 17:09

Shang Wang · Accepted Answer · 2016-02-17 17:24:45Z

1

You need to handle the data differently for the form. Instead of saving it you need to extract the data and query for matching:

def query_queries(request):
    form = QueryForm(request.POST or None)
    if form.is_valid():
        # this is the same as doing
        # Query.objects.filter(studyName=form.cleaned_data['studyName']...)
        queries = Query.objects.filter(**form.cleaned_data)

    context = {
        'queries': queries
    }
    return render(request, "query_queries.html", context)

answered Feb 17, 2016 at 17:24

Shang Wang

25.7k21 gold badges77 silver badges95 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

jdv12 Over a year ago

Okay that makes sense although I'm not sure what you mean by: "**form.cleaned_data" ?

Shang Wang Over a year ago

It's python syntax for feeding a dictionary as parameters: stackoverflow.com/questions/334655/…

Nitish Kumar Pal Over a year ago

I don't understand how come this answer is right here the argument queries is references in None case before assignment.

Collectives™ on Stack Overflow

Querying a django DB with model forms

1 Answer 1

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related