Django community: RSS
This page, updated regularly, aggregates Django Q&A from the Django community.
-
Django Rest Framework Response
I'm studying Django Rest Framework. I understand what is Django content negotiation, and the use of the Response function. In an example I've seen a code like: def func(request): if request.method == "GET": queryset_objects = // serializer = FooSerializer(queryset_objects, many = True) return Response(serializer.data) This function will render a JSON. But the only parameter passed to Response is a dictionary like type (serializer.data). How Render decide that the response must be a JSONN instead another type (without header)? -
images not showing in detail view
posted images are not showing in the detail view of my blog website. on the other hand, they show only when i add them through the admin page. i have older posts whose detail views can show but ever seens this problem started, the detail view do no longer open.it shows this error "The 'blog_Main_Img' attribute has no file associated with it" MY MODELS from django.db import models from django.utils import timezone from django.contrib.auth.models import User from django.urls import reverse # a class for text to be posted class Post(models.Model): title = models.CharField(max_length=50) content = models.TextField(blank=True) date_posted = models.DateTimeField(default=timezone.now) author = models.ForeignKey(User, related_name='blog_author',on_delete=models.CASCADE) blog_Main_Img = models.ImageField(upload_to='images/', verbose_name='Image',blank=True,default='') # this allow the method to be called as a string def __str__(self): return self.title def get_absolute_url(self): return reverse('blog-home') @property def image_url(self): if self.image and hasattr(self.image, 'url'): return self.image.url def __str__(self): return self.name def get_absolute_url(self): return reverse('blog-home') MY VIEWS from django.shortcuts import render,get_object_or_404 from django.contrib.auth.mixins import LoginRequiredMixin, UserPassesTestMixin from django.contrib.auth.models import User from django.views.generic import ( ListView, DetailView, CreateView, UpdateView, DeleteView ) from .models import Post def home(request): context ={ 'posts': Post.objects.all() } return render(request, 'blog/home.html', context) class PostListView(ListView): model = Post template_name = 'blog/home.html' context_object_name = 'posts' ordering = '-date_posted' paginate_by = … -
Django file upload as different user
I have a Django application running on an mod_wsgi (embedded mode) Apache instance inside a Docker container. This container shares a volume (media/) with the host. When a user uploads a file, it is stored in the media/<file> directory. The issue is that the file owner and group are both root, and I need write access to these for a particular user (tech) and/or group (tech-group). I'm assuming it is happening because python is running as root in the container(?). Is there a way to instead have it run as tech? Or somehow tell Django to write files as a particular user/group? -
get specific data with click event Django
I have a simple template where a user can compose a team from displayed names. I can't find out how could I get the names selected by the user to use it in view.py when the user click on "Add to the team" and remove the name when user click on "remove from the team" My html code is basic, on the left side of the page I have: <div class="card-body" id="team-list"> <p class="card-text">Select today's teammates:</p> <ul class="list-group list-group-flush"> {% for tech in techs %} <li class="list-group-item"> <span class="name" name="{{tech.id}}">{{tech.name}}</span> <span class="move" style="float: right;" id={{tech.id}}>Add to the team</span> </li> {% endfor %} </ul> </div><!--CLOSE CARD BODY--> and on the right side I have : <div class="card-body" id="selected-list"> <h3 class="title">You have selected the following teammates for today: </h3> <ul class="list-group list-group-flush" style="list-style-type: none;"> </ul> </div In my JS file, I handled the event like that: var selected = document.querySelector('#selected-list ul'); var team = document.querySelector('#team-list ul'); function clickHandlerTeam(e){ if(e.target.classList.contains('move')){ if (e.target.textContent == 'Add to the team'){ console.log('changing add'); e.target.textContent ='Remove from the team'; selected.appendChild(e.target.parentNode); } else { console.log('changing remove'); e.target.textContent = 'Add to the team'; team.appendChild(e.target.parentNode); } } return; } Finally, in views.py I pass the context like that: @login_required def mywork(request): … -
Cumulative sum SQL query for calculate sales contribution with Postgres
Based on this table I need to calculate how much each products contributes to the total sales and be able to filter the for these products that constitute the 80% of contribution | prod_id | sales date | units_sold | total_price | |---------+------------+------------+-------------| | 1 | 2020-04-20 | 10 | 100.00 | | 1 | 2020-04-19 | 2 | 20.00 | | 2 | 2020-04-20 | 5 | 15.00 | | 2 | 2020-04-19 | 5 | 15.00 | | 3 | 2020-04-20 | 25 | 25.00 | | 3 | 2020-04-19 | 25 | 25.00 | considering the total Sales is equal to $200 the resulting table should looks similar to the one below | prod_id | units_sold | total_price | Contribution % | Accumulate Contribution % | |---------+------------+-------------+----------------+---------------------------| | 1 | 12 | 120 | 0.6 | 1.0 | | 3 | 50 | 50 | 0.25 | 0.4 | | 2 | 10 | 30 | 0.15 | 0.15 | -
How can I create multiple objects with one view?
I am creating a dating app and am attempting to create a message form that displays once a user has matched with another user. I already have the matching down and the users displaying correctly, but I need this messaging component. Now, my InstantMessage model has a foreign key to Conversation which should contain 2 members, whom are having a conversation and contains at least one message exchanged between each other . I'm sure there's a clearer way to do this, but I'd rather keep my models as they are. Now, I what I want to do, when a user hits a link to start messaging, to have my code check if there is already a conversation object between the two users, and if so, then use that conversation object pk for my conversation field in Instant Message and then create a form for that. And if there isn't, then I want a conversation object to be created first, and then a message object to be created. I want this all in one view and with one link, so I assume I need to use if/else statements. Now, this is just a simple project I'm creating to show employers, so … -
Django views, models and urls
I'm setting up a few different views in django. I'd like to return info for each object such as 127.0.0.1:8000/courses/1/1 for instance however 127.0.0.1:8000/courses and 127.0.0.1:8000/courses/1 and 127.0.0.1:8000/courses/1/1 all currently return the same value which right now for example would be a book title and author. from .models import Course from django.conf.urls import url from . import views urlpatterns = [ url('', views.course_list, name='course_list'), url('<int:course_pk>/<int:step_pk>/', views.step_detail, name='step_detail_with_pk'), url('<int:pk>/', views.course_detail, name='course_detail_with_pk'), ] -
How to add Datepicker input using Django Model?
I'm using bootstrap to create a TV show template and here's my HTML code: <div class="container"> <h1>Add a New Show</h1> <form action="/"> <div class="form-group" method="POST"> <label for="title">Title</label> <input type="text" name="title" class="form-control" id="input-title"> </div> <div class="form-group"> <label for="network">Network</label> <input type="text" name="network" class="form-control" id="input-network"> <label for="releasedate">Release Date</label> <div class="input-group date" id="datetimepicker4" data-target-input="nearest"> <input type="text" class="form-control datetimepicker-input" data-target="#datetimepicker4" /> <div class="input-group-append" data-target="#datetimepicker4" data-toggle="datetimepicker"> <div class="input-group-text"><i class="fa fa-calendar"></i></div> </div> </div> </div> <div class="form-group"> <label for="description">Description</label> <textarea name="description" class="form-control" id="input-description" rows="8"></textarea> </div> <div class="form-group text-center"> <button type="submit" class="btn btn-primary shadow" id="createbtn">Create</button> </div> </form> </div> </div> and here's my models.py for django: from django.db import models Create your models here. class Show(models.Model): title = models.CharField(max_length=255) network = models.CharField(max_length=255) release_date = models.DateField() created_at = models.DateTimeField(auto_now_add=True) updated_at = models.DateTimeField(auto_now=True) So how can I create a datepicker in template using django but no jquery or javascript? -
Retrieve related field in Djando Rest Framework
I have the following models that represent Article, Author and Company (where author works): class Article(models.Model): article_title = models.CharField(max_length=250) article_url = models.URLField(max_length=250) article_pub_date = models.DateField() class Company(models.Model): company_name = models.CharField(max_length=250) class Author(models.Model): author_sf_id = models.CharField(max_length=20, unique=True) author_name = models.CharField(max_length=250) article = models.ForeignKey(Article, on_delete=models.CASCADE, related_name='author_crtcicle') company = models.ForeignKey(Company, on_delete=models.CASCADE, related_name='author_company') My Serializers: class ArticleSerializer(serializers.ModelSerializer): class Meta: model = Article fields = ('__all__') depth = 2 class CompanySerializer(serializers.ModelSerializer): class Meta: model= Company fields = ('__all__') class AuthorSerializer(serializers.ModelSerializer): article = ArticleSerializer() class Meta: model = Author fields = ('__all__')` My Views: class ArticleList(ListAPIView): queryset = Article.objects.all().order_by('-article_pub_date') serializer_class = ArticleSerializer class AuthorList(ListAPIView): queryset = Author.objects.all().order_by('author_name') serializer_class = AuthorSerializer class CompanyList(ListAPIView): queryset = Company.objects.all().order_by('company_name') serializer_class = CompanySerializer In DRF, I want to retrieve all articles of an Author and his Company members' with an url that would take an article_url e.g: /api/v1/{article_url}. I have tried various combination but what I have only succeeded doing so far is just retrieving all articles from an author. An idea I thought of is overriding the get_object method of the ListAPIView in a way that would help retrieve these fields. Does anyone have an idea? -
dependencies reference nonexistent parent node error after deleting app
I got this error after deleting a users app in my project whenever I try to migrate or run my app. I have tried the solutions from Django: dependencies reference nonexistent parent node but none worked. My migration files were all empty, i have tried deleting the pyc files, pycache, and deleting the migration files themselves but it still won't work. here is the error I get: Traceback (most recent call last): File "manage.py", line 21, in <module> main() File "manage.py", line 17, in main execute_from_command_line(sys.argv) File "C:\Users\clayh\.virtualenvs\VoterInfoApp-z_tPDrnw\lib\site-packages\django\core\management\__init__.py", line 401, in execute_from_command_line utility.execute() File "C:\Users\clayh\.virtualenvs\VoterInfoApp-z_tPDrnw\lib\site-packages\django\core\management\__init__.py", line 395, in execute self.fetch_command(subcommand).run_from_argv(self.argv) File "C:\Users\clayh\.virtualenvs\VoterInfoApp-z_tPDrnw\lib\site-packages\django\core\management\base.py", line 328, in run_from_argv self.execute(*args, **cmd_options) File "C:\Users\clayh\.virtualenvs\VoterInfoApp-z_tPDrnw\lib\site-packages\django\core\management\base.py", line 369, in execute output = self.handle(*args, **options) File "C:\Users\clayh\.virtualenvs\VoterInfoApp-z_tPDrnw\lib\site-packages\django\core\management\base.py", line 83, in wrapped res = handle_func(*args, **kwargs) File "C:\Users\clayh\.virtualenvs\VoterInfoApp-z_tPDrnw\lib\site-packages\django\core\management\commands\makemigrations.py", line 87, in handle loader = MigrationLoader(None, ignore_no_migrations=True) File "C:\Users\clayh\.virtualenvs\VoterInfoApp-z_tPDrnw\lib\site-packages\django\db\migrations\loader.py", line 49, in __init__ self.build_graph() File "C:\Users\clayh\.virtualenvs\VoterInfoApp-z_tPDrnw\lib\site-packages\django\db\migrations\loader.py", line 274, in build_graph raise exc File "C:\Users\clayh\.virtualenvs\VoterInfoApp-z_tPDrnw\lib\site-packages\django\db\migrations\loader.py", line 248, in build_graph self.graph.validate_consistency() File "C:\Users\clayh\.virtualenvs\VoterInfoApp-z_tPDrnw\lib\site-packages\django\db\migrations\graph.py", line 195, in validate_consistency [n.raise_error() for n in self.node_map.values() if isinstance(n, DummyNode)] File "C:\Users\clayh\.virtualenvs\VoterInfoApp-z_tPDrnw\lib\site-packages\django\db\migrations\graph.py", line 195, in <listcomp> [n.raise_error() for n in self.node_map.values() if isinstance(n, DummyNode)] File "C:\Users\clayh\.virtualenvs\VoterInfoApp-z_tPDrnw\lib\site-packages\django\db\migrations\graph.py", line 58, in raise_error raise NodeNotFoundError(self.error_message, self.key, origin=self.origin) django.db.migrations.exceptions.NodeNotFoundError: Migration … -
Why global variable inside for loop doesn't change value? Javascript
I have a problem when executing a function that runs a for loop with 3 global variables that will be passed to a callback function. All the arrays have the same length, the problem comes with the 3 window variables, called in getPickup() inside the callback function don't change value in any of the loop goes. I find it strange because those variables should get a new value updated from location when the callback function is finished, and the loop is run again. function calculateDistanceDriverCustomer() { {% autoescape off %} var locations = {{ locations }} {% endautoescape %} {% autoescape off %} var firstname = {{ firstname }} {% endautoescape %} {% autoescape off %} var lastname = {{ lastname }} {% endautoescape %} {% autoescape off %} var rating = {{ rating }} {% endautoescape %} var location; for (location = 0; location < locations.length; location++) { var origin = locations[location]; window.firstname = firstname[location]; window.lastname = lastname[location]; window.rating = rating[location]; var destination = $('#origin-input').val(); var service = new google.maps.DistanceMatrixService(); service.getDistanceMatrix( { origins: [origin], destinations: [destination], travelMode: google.maps.TravelMode.DRIVING, unitSystem: google.maps.UnitSystem.METRIC, // kilometers and meters. avoidHighways: false, avoidTolls: false }, callback); } }; function callback(response, status) { if (status != … -
Python/Django button to redirect user depending on the actual site
I've searched for the best idea to clearly implement a button that redirects a user to the post creation page depending on the current URL but I still don't have a good solution. I have 1 same template for 3 pages. Each page has 10 categories (subpages). Maybe example: urls.py: app_name = 'forum' 1 category path('category1/, View.as_view(), name = category1 2 category path('category2/, View.as_view(), name = category2 1 category post creation path('category1/create-post/', PostCreateView.as_view(my_id=11), name = category1-new-post 2 category post creation path('category2/create-post/', PostCreateView.as_view(my_id=12), name = category2-new-post If the user is on the first subpage/category and clicks the button then redirect him to {% url 'forum:category1-new-post' %} If the user is on the second subpage/category and clicks the button then redirect him to {% url 'forum:category2-new-post' %} and etc 28x times (3 pages x 10 categories) I've tried to write something like this: {% if request.resolver_match.url_name == 'category1' %} button with href '{% url 'forum:category1-new-post' %}' {% elif request.resolver_match.url_name == 'category2' %} button with href '{% url 'forum:category2-new-post' %}' and etc 28x times. The code above doesn't seem good. Writing 30 ifs is not the best idea and i don't know how to handle it. For each subpage/category post creation i have … -
NoReverseMatch at /main/insert_num/ Django
I'm trying to make to make a django web app which has a form that asks a user to input a phone number and stores that number in a postgres database. The following code is giving me the error: NoReverseMatch at /main/insert_num/ Reverse for '' not found. '' is not a valid view function or pattern name. And I can't figure out what the issue is, can someone help? index.html <html lang="en"> <head> <meta charset="UTF-8"> <meta name="viewport" content="width=device-width, initial-scale=1.0"> <meta http-equiv="X-UA-Compatible" content="ie=edge"> <title>Test Form 1</title> </head> <body> <form action="{% url 'insert_my_num' %}" method="post" autocomplete="off"> {% csrf_token %} <!-- {{ form.as_p }} --> <input type="submit" value="Send message"> </form> </body> </html> forms.py from django import forms from phone_field import PhoneField from main.models import Post class HomeForm(forms.ModelForm): phone = PhoneField() class Meta: model = Post fields = ('phone',) models.py from django.db import models from phone_field import PhoneField class Post(models.Model): phone = PhoneField() main/urls.py from django.urls import path from . import views urlpatterns = [ path('insert_num/', views.insert_my_num,name='insert_my_num') ] project/urls.py from django.contrib import admin from django.urls import path,include urlpatterns = [ path('admin/', admin.site.urls), path('main/',include('main.urls')) ] views.py def insert_my_num(request: HttpRequest): phone = Post(request.POST.get('phone')) phone.save() return redirect('') -
why does Django returns BadHeaderError when adding a new line in my 'Contact' page's 'message' field
Everything works except when I add a new line via 'enter' in the "Message" field. It goes through if I don't add new lines in the message textfield. What am i missing here? Tried to solve this problem for 2 days, nothing similar on google. I feel like there could be the problem of my views.py config: def success(request): return render(request, 'home/success.html') def contact(request): if request.method == 'POST': form = ContactForm(request.POST) if form.is_valid(): # send email code goes here sender_name = form.cleaned_data['name'] sender_email = form.cleaned_data['email'] sender_phone = form.cleaned_data['phone'] sender_message = form.cleaned_data['message'] subject = "Enquiry: {0}".format(sender_message[:50]) message = "New message from {0}\n phone number: {1}\n email: {2}\n\n{3}".format(sender_name, sender_phone, sender_email, sender_message) recipients = ['john.smith@gmail.com'] sender = "{0}<{1}>".format(sender_name, sender_email) try: send_mail(subject, message, sender, recipients, fail_silently=False) except BadHeaderError: return HttpResponse('Invalid header found') return HttpResponseRedirect('success') else: form = ContactForm() return render(request, 'home/contact.html', {'form': form}) Any ideas? -
Data not passing to django template on DetailView
I have a model that should show data on the home page but isn't. I think the problem has to do with fetching data from an external API that also shows on the home page. `models.py` class Stats(models.Model): confirmed = models.CharField(max_length=20) recovered = models.CharField(max_length=20) death = models.CharField(max_length=20) def __str__(self): return str(self.confirmed) `views.py` import services # API comes from services.py class IndexData(DetailView): template_name = 'pages/home.html' stats = Stats.objects.all() def get(self, request): article_data = services.get_data() return render(request, 'pages/home.html', article_data) home.html {% for s in stats %} {{ s.recovered }} {{ s.deaths }} {{ s.confirmed }} {% endfor %} It should show: But is showing: -
"django_site" does not exist on migration
Earlier today I was having some problems with conflicting migrations for various reasons. I decided to just destroy the entire DB and start from scratch (we're pretty early in the project there is no harm in resetting everything). However, when I tried to get things back up and running with manage.py migrate I get this error: File "/Users/travis/Documents/venv/lib/python3.8/site-packages/django/db/backends/utils.py", line 84, in _execute return self.cursor.execute(sql, params) psycopg2.errors.UndefinedTable: relation "django_site" does not exist LINE 1: ..."django_site"."domain", "django_site"."name" FROM "django_si... ^ The above exception was the direct cause of the following exception: Traceback (most recent call last): ... return self.cursor.execute(sql, params) django.db.utils.ProgrammingError: relation "django_site" does not exist LINE 1: ..."django_site"."domain", "django_site"."name" FROM "django_si... ^ This seems to be a very common error and the main solutions I have seen (and tried) are: add SITE_ID = 1 to base.py; in my case, it's already in there. Include "django.contrib.sites" earlier in DJANGO_APPS I've tried putting it first and got the same error. run manage.py migrate sites before other migrations; running this migration gives me the same error. Additionally, I have completely removed the DB, and created a new PGSQL instance, I've removed the project locally and cloned it from our repo. I've tried creating new … -
Record IP Address with Form Submission Django
I am trying to use the django-ipware pacakge to record the IP address of someone submitting a form submission via Django. The form is a ModelForm. Here's the model: # models.py from django.db import models class Upload(models.Model): email = models.EmailField() title = models.CharField(max_length=100) language = models.ForeignKey('about.channel', on_delete=models.CASCADE, default='Other') date = models.DateField(auto_now_add=True) file = models.FileField() ip_address = models.GenericIPAddressField() Here is the form: # forms.py class UploadForm(forms.ModelForm): class Meta: model = Upload fields = ['email', 'title', 'language', 'file'] labels = { 'email': 'E-Mail', 'title': 'Video Title', 'file': 'Attach File' } The business logic for getting the IP address is pretty simple, but I've tried placing it in different locations with no luck. Where should I place the logic so it will be submitted along with the other form data? # views.py from ipware.ip import get_real_ip ip = get_real_ip(request) -
django calendar make first day sunday
Currently my calendar is formatted with Monday being the first day of the week. What I would like is for the first day to be Sunday. I used this to start out: https://medium.com/@unionproject88/django-and-python-calendar-e647a8eccff6 I messed around and began looking at the Documentation but not matter what I added it wouldn't work. utils.py class Calendar(calendar.HTMLCalendar): def __init__(self, year=None, month=None): self.year = year self.month = month super().__init__() # formats a day as a td # filter events by day def formatday(self, day, events, year, month): events_per_day = events.filter(start_date__day=day).order_by("start_date") d = "" for event in events_per_day: d += f"<a class='calendar-event' href='{reverse('events:detail', args={event.uid})}'>{event.title}</a> <a class='calendar-event-mobile' href='{reverse('events:detail', args={event.uid})}'><i class='fas fa-dot-circle'></i></a>" if day != 0: scope = datetime.date(year, month, day) if scope == datetime.date.today(): return f"<td class='date-today'><span class='date'>{day}</span><div> {d} </div></td>" return f"<td><span class='date'>{day}</span><div> {d} </div></td>" return "<td></td>" # formats a week as a tr def formatweek(self, theweek, events, year, month): week = "" for d, weekday in theweek: week += self.formatday(d, events, year, month) return f"<tr> {week} </tr>" # formats a month as a table # filter events by year and month def formatmonth(self, withyear=True): events = Event.objects.filter(start_date__year=self.year, start_date__month=self.month) cal = ( f'<table border="0" cellpadding="0" cellspacing="0" class="table table-striped table-bordered calendar">\n' ) cal += f"{self.formatmonthname(self.year, self.month, withyear=withyear)}\n" … -
Most efficient database design (models) for tracking daily object rankings in huge database
I am designing a Django project that needs to be able to track 1 million+ products and produce daily rankings for which product had the most total number of sales. I need to store and reference this historical ranking data and be able to retrieve rankings for any day in the past. Therefore, my models.py looks like: class Product(models.Model): product_name = models.CharField(max_length=200, unique=True) updated_at = models.DateTimeField(auto_now=True) sub_description = models.CharField(max_length=500, default='') class Rank(models.Model): class Meta(object): unique_together = ['pub_date', 'product'] pub_date = models.DateField(db_index=True) product = models.ForeignKey(Product, on_delete=models.DO_NOTHING) total_sold = models.IntegerField() My plan is to run a django management command script each day. The script will create a new Rank object for each Product in the database every day. Here is a simplified version of the script logic: now = datetime.datetime.utcnow().replace(tzinfo=utc) for prod in Product.objects.all(): try: rank = Rank.objects.get(product=prod, pub_date=now) print("Already updated for ", str(now)) except Rank.DoesNotExist: rank_value = prod_api.get(prod) rank = Rank(product=prod, pub_date=now) rank.total_sold = rank_value rank.save() Because it is possible for a user to request daily rankings while the management command is only halfway through adding new Rank objects for today, the following annotates were a bit tricky for me. I am returning the most recently updated Rank object for each … -
Django how to change the admin panel template
I am trying to change what is displayed when I click on a model in the django admin. For example if I have the model Book and then I go into the admin panel and click book, it will give me all the fields that I created the model with. But I want to edit that page that shows all that data. For example, if I click on the "Book" model in the admin panel and see my fields to edit, I want to put another bit of fields on the bottom from another model. Or maybe I want to put like a "Similar Books" list. Is it possible to edit this page? -
Static url goes after the regular page url
My static files only load on index page, but when navigating to another page like: examle_url/page, it returns a 404 error since it loads it like that: http://127.0.0.1:8000/categories/default/static/js/main.js, see the static loads after page settings.py STATIC_URL = 'static/' STATIC_ROOT = os.path.join(BASE_DIR, 'static_root/') STATICFILES_DIRS = ( os.path.join(BASE_DIR, '/static/base'), ) urls.py "all my urls are in main directory and then i import views from apps" urlpatterns = [ path('admin/', admin.site.urls), path('profile/', profile, name="profile"), path('', index, name="index"), path('category/', category, name="category"), ] if settings.DEBUG: urlpatterns += static(settings.STATIC_URL, document_root=settings.STATIC_ROOT) urlpatterns += static(settings.MEDIA_URL, document_root=settings.MEDIA_ROOT) If it matters my load static files are all in theme.html file and is then extended in all other html files. Any help will be greatly appreciated, thanks in advance! -
Having Issues trying to display my Order on my Order page can't seem to find the issue
How I tried to display it on my html template <div class="container"> <div class="col-md-12 h-100"> {% if messages %} {% for msg in messages %} <div class="alert alert-success"> {{msg.message}} </div> {% endfor %} {% endif %} {% for order in order_details %} <p>Order Number: {{order.id}}</p> <p>Order Date: {{order.created}}</p> <table class="table table-bordered table-hover table-condensed"> <thead> <tr> <th>Id</th> <th>Name</th> <th>Quantity</th> <th>Price</th> <th>Total</th> </tr> </thead> <tbody> {% for order_item in order.get_items %} <tr> <td>{{order_item.id}}</td> <td>{{order_item.product}}</td> <td>{{order_item.quantity}}</td> <td>&euro; {{order_item.price}}</td> <td>&euro; {{order_item.get_cost}}</td> </tr> {% endfor %} </tbody> </table> <div class="row"> <div class="col-md-12"> <p class="text-right"><strong>Order Total: &euro; {{order.get_total_cost}}</strong></p> </div> </div> <p> <a href=""><button class="btn btn-primary">Cancel Order</button></a> </p> {% endfor %} <div class="mx-auto"> {% if orders.paginator.num_pages > 1 %} <hr> <div class="text-center"> {% for pg in orders.paginator.page_range %} <a href="?page={{pg}}" class="btn btn-light btn-sm {% if orders.number == pg %} active {% endif %}">{{pg}}</a> {% endfor %} </div> {% endif %} </div> </div> </div> I have two models one for the user to fill out their address and a another to save the use details and products they bought. Not all the code is being displayed just more to do with user details class Order(models.Model): first_name = models.CharField(max_length=50) last_name = models.CharField(max_length=50) email = models.EmailField() address = models.CharField(max_length=120) address2 … -
using aggregate in generic view django rest
I am going to calculate sum of a field in django but I am failing to do this I am getting this error AttributeError: 'dict' object has no attribute 'model' with annotate it works but it shows one field multiple times that's why I need to use aggregate here my code class TestStatistics(generics.ListAPIView): serializer_class = TestSerializer permission_classes = (permissions.AllowAny,) filter_class = TestStatisticsFilter def get_queryset(self): test_id = self.request.GET.get('test_id') data = Test.objects.filter( test_id=test_id).aggregate(total=Sum('total')) print(data) return data can anybody help me, please? Thanks in advance! -
Django PostGIS spatial query
I'm trying to do a spatial query in Django to a PostGIS database, but I've not been able to do it. I've try it with raw querys a with this GIS QuerySet API Reference. I dont know what I'm doing wrong. this is my modeles.py file: class RayosTotal(models.Model): ka = models.FloatField(db_column='kA', blank=True, null=True) # Field name made lowercase. tiempo = models.DateTimeField(db_column='Tiempo',primary_key=True, blank=True, null=False) # Field name made lowercase. geom = models.PointField(blank=True, null=True) class Meta: managed = False db_table = 'Rayos_total' unique_together = (('lat', 'lng', 'tiempo'),) class Departamentos(models.Model): geom = models.MultiPolygonField(blank=True, null=True) cod_dane = models.IntegerField(db_column='COD_DANE',primary_key=True, blank=True, null=False) nom_dpto = models.CharField(db_column='NOM_DPTO', max_length=250, blank=True, null=True) # Field name made lowercase. class Meta: managed = False db_table = 'departamentos' and this is my views.py def join1(request): points = serialize('geojson',RayosTotal.objects.all()) x=serialize('geojson',Departamentos.objects.filter(geom__contains=points)) return HttpResponse(x,content_type='json') #with join1 I get this message: Couldn't create spatial object from lookup value def join2(request): x=RayosTotal.objects.raw("""SELECT "Rayos_total".geom AS geom FROM "public"."Rayos_total" INNER JOIN "public"."departamentos" ON ST_Within("Rayos_total".geom, "departamentos".geom) WHERE "departamentos"."NOM_DPTO" = 'CHOCO'""") return HttpResponse(x,content_type='json') #with join2 I get this message: Raw query must include the primary key any ideas ? thank you for the help -
Keep Bootstrap dropdown open a new page?
I use a bootstrap dropdown in my django framework. In the dropdown menu in my sidebar there are several links to other pages. If I click it, my dropdwon menu disappear becouse the menu fades away. Is there anyway way to prevent this? I tried e.startPropagation, but that didn't seem to work: Here the HTML section with the dropdown manu: <div class="container-fluid"> <div class="row"> <nav class="col-md-2 d-none d-md-block bg-dark sidebar"> <div class="sidebar-sticky"> <ul class="nav flex-column"> <li class="nav-item"> <a class="sidebar-heading d-flex justify-content-between align-items-center px-3 mt-4 mb-1" href="#homeSubmenu" data-toggle="collapse" aria-expanded="false" class="dropdown-toggle">Performance Monitoring<span data-feather="plus-circle"></span></a> <ul class="collapse list-unstyled" id="homeSubmenu"> <li> <a class="nav-link" href="#"> <span data-feather="monitor"></span> Dashboard</a> </li> <li> <a class="nav-link" href="#"> <span data-feather="trending-up"></span> Conto Economico</a> </li> <li> <a class="nav-link" href="#"> <span data-feather="home"></span> Stato patrimoniale </a> </li> <li> <a class="nav-link" href="#"> <span data-feather="dollar-sign"></span> Rendiconto Finanziario</a> </li> </ul> </li>
