Django Model data in views as variable

Question

Need help, Very new to Django.

I have created a model as below

class Redirect_url(models.Model):
    hosturl = models.CharField(max_length=100)
    path = models.CharField(max_length=100)
    redirectpage = models.CharField(max_length=200)

I need the hosturl, path and redirectpage as a variable in my views page for me to make some logic before I render to the html page. I don’t know

from django.shortcuts import render,redirect
from django.http import HttpResponseRedirect
from django.http import HttpResponse
from .import models

def home(request):
    return render(request,'home.html')

def redurl(request):
    b = request
    data = (models.Redirect_url.objects.all())
    print(data)
    return HttpResponse(data, content_type="text/plain")

I am getting print as Redirect_url object (1)Redirect_url object (2). How to get all the models data. Thanks.

At the moment you are simply passing the result of models.Redirect_url.objects.all() (which is a QuerySet object) as the response. Python is simply trying to create a readable representation of this object, which in this case is "Redirect_url object (1)Redirect_url object (2)" (a list of the two objects in the QuerySet). You should instead either create and render a template that displays what you want the user to see, or you should create a more readable string — Timmy O'Mahony
– Timmy O'Mahony, Commented Feb 26, 2020 at 10:02

stackoverflowusrone · Accepted Answer · 2020-02-26 09:13:31Z

1

models.Redirect_url.objects.all() returns a list of QuerySets. You can iterate through the list with for loop and access the properties.

You can also add __str__() method in your model for better representation, see here.

You should check basic Django tutorial to understand it better.

answered Feb 26, 2020 at 9:13

stackoverflowusrone

5363 silver badges10 bronze badges

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

Comments

Pruthvi Barot · Accepted Answer · 2020-02-26 09:29:45Z

0

import json

data = Redirect_url.objects.all()
list = []
for record in data:
    dict = {'Host URL':record.hosturl,'Path':record.path,'Redirect Page':record.redirectpage}
    list.append(dict)
    list_as_json = json.dumps(list)
return HttpResponse(list_as_json)

Redirect_url.objects.all() will return queryset which contains number of obhects that we have stored in database by iterating over queryset you can get all objects one by one. you can do number of operations on queryset as below: django queryset

edited Feb 26, 2020 at 9:29

answered Feb 26, 2020 at 9:06

Pruthvi Barot

2,0287 silver badges17 bronze badges

3 Comments

Charnel Over a year ago

Are you sure this will work - passing list of dictionaries to response with setting the content type as text?

Pruthvi Barot Over a year ago

just giving example. Changed to json

Charnel Over a year ago

I think you still need to exlicitly define the content type because browser may or may not guess what you respond with. Another thing is that OP mentioned this render to the html page so json will not help him much unless he suppose to use the endpoint with some JS code.

Collectives™ on Stack Overflow

Django Model data in views as variable

2 Answers 2

Comments

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related