Django community: RSS
This page, updated regularly, aggregates Django Q&A from the Django community.
-
How do i modify src attribute of ckeditor image upload in django-rest-framework
I am using django-rest, ckeditor, vue js. When I upload image from ckeditor, ckeditor putting only half of the src url. My image is located in different domain and my frontend page is located in another domain. Here in src attribute, before media how can I add my domain name? For example src="domain.com/media/media" -
Get all comments of a particular tag in for loop
I am building a BlogApp and I am trying to implement a feature :- In which, I am trying to retrieve all the comments commented by request.user of a particular tag in for loop. Like :- I build a for loop for getting tags one by one and I am trying to get comments of tag. and If a tag got 2 upvotes than I will do the rest. I am not going to show that in template but let me show you how i am expecting about for loop :- Tag Name (in for loop) All comments of loop tag Upvotes of all the comments of a tag tag1 "Good", "Bad", "Car", "Bike", "Umbrella" 15 tag2 "Rain", "Mac", "CPU" 5 models.py class BlogPost(models.Model): user = models.ForeinKey(User, on_delete=models.CASCADE) title = models.CharField(max_length=30) tags = TaggableManager() class Comment(models.Model): comment_by = models.ForeignKey(User, on_delete=models.CASCADE) on_post = models.ForeignKey(BlogPost, on_delete=models.CASCADE) upvotes = models.ManyToManyField(User, related_name='upvotes', blank=True) views.py def page(request): # Successfully getting the tags of post which were commented by user query = Tag.objects.filter(blogpost__comment__comment_by =request.user).annotate( num_name=Count('name')) # Not Working gettingComments = Comments.objects.filter(on_post __tags__name__in=query .values_list( 'name')) for q1 in query: for q2 in gettingComments: if q2.upvotes.count() >= 5: print("Working") context = {'query':query} return render(request, 'page.html', context} What am … -
How to use get_elided_page_range in Django paginator?
There is new option to create pagination range - get_elided_page_range https://docs.djangoproject.com/en/3.2/ref/paginator/#django.core.paginator.Paginator.get_elided_page_range How should I use it? How can I set args? I am using CBV ListView. I tried https://nemecek.be/blog/105/how-to-use-elided-pagination-in-django-and-solve-too-many-pages-problem but it didn't work for me. I have 81 pages and current page is 10. Problem is I am always have range 1 2 3 4 ... 80 81 What am I doing wrong? #views.py class TrailersListView(ListView): queryset = Trailer.objects.all() paginate_by = 10 #template.html {% for i in paginator.get_elided_page_range %} {% if page_obj.number == i %} <li class="active page-item"> <span class="page-link">{{ i }}</span> </li> {% else %} {% if i == paginator.ELLIPSIS %} <li class="page-item"> <span class="page-link">{{ paginator.ELLIPSIS }}</span> </li> {% else %} <li class="page-item"> <a class="page-link" href="?page=i">{{ i }}</a> </li> {% endif %} {% endif %} {% endfor %} -
how can we write queryset to compare two id of different models and fetch the id related data like name,address in html form
#This is the view where I tried to write the queryset to compare to different ids #and tried to get the data related to that id in html form. But failed and I am new to #django # need good insight. #This is my views.py class SalaryEnter(generic.CreateView,generic.ListView,LoginRequiredMixin,PermissionRequiredMixin): form_class = SalaryPaymentForm model = SalaryPayment template_name = 'payment/salary.html' success_url = reverse_lazy('payments:salist') def get(self,request,*args,**Kwargs): entered = self.request.GET.get('Staff_id','') if entered == StaffRegistration.Staff_id: self.result = StaffRegistration.objects.values() else: self.result = StaffRegistration.objects.none() return super().get(request,*args,**Kwargs) def get_context_data(self,**kwargs): return super().get_context_data(results = self.result,**kwargs) #This is my template <!DOCTYPE html> <html lang="en"> {% extends 'payment/payment_base.html' %} {% block group_content %} {% load bootstrap4 %} {% load static %} <head> <meta charset="UTF-8"> <meta http-equiv="X-UA-Compatible" content="IE=edge"> <meta name="viewport" content="width=device-width, initial-scale=1.0"> <title>Salary Payment Form</title> <link rel="stylesheet" href="{% static '/css/form_design.css' %}"> <script src="https://ajax.googleapis.com/ajax/libs/jquery/3.5.1/jquery.min.js"></script> </head> <body> <br><br><br><br><br><br><br><br><br> <h3>Salary Payment Form</h3> <div class="container"> <form enctype="multipart/form-data" action="{% url 'payment:salary' %}" method="POST"> {% csrf_token %} {% bootstrap_form form %} <input type="button" value="Submit" class="btn btn-primary"> </form> <script src="{% static '/js/navigation_bar/staff_salary.js' %}"></script> </div> </div> </body> </html> {% endblock %} -
Return function output to a function view django
I want to use the output from a function in a function-based view. Passing the get_context_data function output to ShowProfilePage function view def ShowProfilePageView(request, username): def get_context_data(self, *args, **kwargs): context = super(ShowProfilePageView, self).get_context_data(*args, **kwargs) page_user = get_object_or_404(UserProfile, id=self.kwargs['pk']) user_posts = Post.objects.filter(author= page_user.user).order_by('-post_date') username = page_user.user context['page_user'] = page_user context['user_posts'] = user_posts context['username'] = username return context context = {} return render(request, 'registration/user_profile.html', context) -
Django website running too slow on Google Cloud Platform(GCP)
I am planning to migrated from DigitalOcean(DO) to Google Cloud(GCP). I have taken trial on GCP and hosted Django website on it, but it is running too slow (it take 12-15 seconds to open page). Same website running on DO is very fast(it take hardly 1 second to open page). Website is hosted on Ubuntu 20 LTS (on DO & GCP) & Apache2 server On GCP there is no user right now, for testing I am only one user and it is running too slow. I have 2CPU and 8GB memory on VM. I am not able to find out the issue why it is running slow on GCP and running fast on DO? Can someone please help to find out solution? -
How do I create list the intended way I want
I have the following scripts: Does calculation for me and lists them function fromPortIdChange() { fromportid = $('#fromPortId').val(); console.log(fromportid); portIdRange(fromportid,toportid); listOfNumbers=[]; } function toPortIdChange() { toportid = $('#toPortId').val(); console.log(toportid); portIdRange(fromportid,toportid); listOfNumbers=[]; } function portIdRange(fromportid, toportid) { fromportid = $('#fromPortId').val(); toportid = $('#toPortId').val(); fromportidlastvalueSliced = fromportid.slice(-5); interfaceNameLength = fromportid.length-1; interfaceName = fromportid.substring(0, interfaceNameLength); console.log("length: " +interfaceNameLength); console.log("interface name: " +interfaceName); fromportidlastvalue = fromportidlastvalueSliced.split('/')[2] console.log(fromportidlastvalue+ " FROM port id"); console.log("range is " +fromportid+ " to " +toportid); toportidlastvalueSliced = toportid.slice(-5); toportidlastvalue = toportidlastvalueSliced.split('/')[2] console.log(toportidlastvalue+ " TO port id"); console.log(typeof(toportidlastvalue)); calculateRange(fromportidlastvalue, toportidlastvalue, interfaceName); } function calculateRange(fromportidlastvalue, toportidlastvalue, interfaceName) { fromportidlastvalue = parseInt(fromportidlastvalue); toportidlastvalue = parseInt(toportidlastvalue); console.log(fromportidlastvalue + " type is " + typeof(fromportidlastvalue)); console.log(toportidlastvalue + " type is " + typeof(toportidlastvalue)); currentValue = fromportidlastvalue; while(currentValue<=toportidlastvalue) { console.log(currentValue); listOfNumbers.push(interfaceName+currentValue); currentValue++; } $('#port_range').val(listOfNumbers); } Here is the html involved: The part it is on the page and the one I am going to clone <div id = first> <div class="port"> <div class="row"> <div class="col-md-4"> <div class="form-group"> <label for="subnet_bit">From Port ID</label> <select id="fromPortId" class="custom-select mb-3" onchange="fromPortIdChange();"> <option selected>Select</option> {% for items in righttable %} <option value={{items.0}}>{{items.0}}</option> {%endfor%} </select> </div> </div> <div class="col-md-4"> <div class="form-group"> <label for="subnet_bit">To Port ID</label> <select id="toPortId" class="custom-select mb-3" onchange="toPortIdChange();"> <option selected>Select</option> {%for … -
What is the best way to implement sitemap.xml (or django-sitemap) on cookiecutter-django?
When trying to install django-sitemaps over the default cookiecutter-django generated project, after following the steps in the documentation, the following error happens: django.core.exceptions.ImproperlyConfigured: app_dirs must not be set when loaders is defined. Looks like Step 2 in the documentation: Make sure your TEMPLATES setting contains a DjangoTemplates backend whose APP_DIRS options is set to True. It’s in there by default, so you’ll only need to change this if you’ve changed that setting. conflicts with the default Loaders-approach that comes with the default install, and as such this piece of code does not function: TEMPLATES = [ { .... "APP_DIRS": True, "OPTIONS": { ... "loaders": [ "django.template.loaders.filesystem.Loader", "django.template.loaders.app_directories.Loader", ], ... ] Commenting out the "loaders" part does the trick, but changes the way templating is thought in cookiecutter-django in the process. So the question is: what is the best way of harmonizing django-sitemaps and cookiecutter-django? Is there a loader that can be added to the list that does the trick, preserving the intent of the original way the templating was concieved? Or is it better to just go APP_DIRS: True and comment loaders out entirely? Pros and cons? -
The script sqlformat.exe is installed in directory , which is not on PATH
I am getting this warning while I was trying to install django in a virtual environment in pycharm. But while I open python in command prompt then I don't get any warning like 'python is not in path or something', then why am I getting this warning now in pycharm? pls help me fix this, thankyou in advance. -
define an element as default value in a list created by a for loop in a django template
here is my html <div class="modal-body"> <form action="#" id="periodeOptionForm"> <div class=" card-body"> <div class="form-group form-elements"> <div class="form-label">Options</div> <div class="custom-controls-stacked"> {% for periode in periodes %} <label class="custom-control custom-radio" id'{{periode.labelle}}'> <input type="radio" class="custom-control-input" name="example-radios" value="{{periode.valeur}}"> <span class="custom-control-label">{{periode.labelle}} </span> </label> {% endfor %} </div> </div> </div> </form> </div> My fbv def periodes(request): ... periodes = [{"labelle":"10 minutes","valeur":10},{"labelle":"30 minutes","valeur":30},{"labelle":"1 heure","valeur":60}] .... return render(request,"my_template.html",{"periodes":periodes} When I display the html page no elements are selected. I want the first element of my periodes list to be selected by default. How can I do it? -
Failed to decode response from marionette selenium without of docker
I have a django app that runs a selenium script that scrapes data from youtube channels, and I randomly get this error during collection Message: Failed to decode response from marionette I'm running this on my mac locally and I have only been able to find issues of this related to running it inside a docker, but I'm not running this inside anything except my virtual environment that has selenium installed. It seems like the solution is increasing the amount of memory allocated to the process, but I think I already have more than enough. I am working on a brand new 2021 macbook air. Any idea on what I should do to fix this? -
New modules installed not found using pip
I was trying to do my first deploy using heroku, and for that I installed modules python-decouple and dj-database-url with pip, but python is not recognizing this new modules, even packages like Pillow and colorama are not being recognized, the packages are installed in the env with the path: D:\User\Documents\My_Repository\training\env\Lib\site-packages The error when I type python manage.py runserver is quite extensive: vscode error -
Django queryset not updating on live server unless the server is restarted, but updates on local
I am using Django version 3.2 This queryset updates on local and on live: variable1 = serialize('json', Calls.objects.order_by('-time_pulled','-time')[:15].using('myDatabase')) These two querysets only update on live after a server restart and then never refresh: variable2 = Calls.objects.filter(local_date = current_local_date).using('myDatabase').count() variable3 = serialize('json', Calls.objects.all().filter(local_date=current_local_date).using('myDatabase')) I did read in the Django docs that .count() does not return a new queryset, but .filter() is supposed to. I tried to use Calls.refresh_from_db but this doesn't refresh the queryset either. I also tried calling Calls.objects.all()[:15].using('myDatabase') at the beginning of the view function to see if it would fetch a new queryset, but don't see the results in the latter calls. Any help would be appreciated. Thank you in advance. -
Django ORM shows empty JSONField but postgreSQL shows contents
I am using a Django (3.2.6) JSONField to store geoJSON data, with postgreSQL 10.14 on the back end. The fields are generally defined in a class in the following manner: from django.db import models from django.core.serializers.json import DjangoJSONEncoder class BaseComponent(models.Model): class Meta: abstract = True name = models.CharField(max_length=256, null=True, blank=True) x = models.FloatField(null=True, blank=True) y = models.FloatField(null=True, blank=True) geometry = models.JSONField(null=True, blank=True, default=dict, encoder=DjangoJSONEncoder) I store values to these objects and later want to retrieve the JSON field. I do the following in the Django shell and can show that the geometry field is a NoneType with apparently no data. In [14]: obj.geometry In [15]: type(obj.geometry) Out[15]: NoneType In [16]: obj.id Out[16]: UUID('aed2fd38-28de-477d-bf4b-0d78b68bd729') However, when I call the same data back from the associated database, I see the following: SELECT id, geometry FROM basecomponent_table WHERE id='aed2fd38-28de-477d-bf4b-0d78b68bd729'; id | geometry --------------------------------------+--------------------------------------------- aed2fd38-28de-477d-bf4b-0d78b68bd729 | {"type": "Feature", "geometry": {"type": "Polygon", "coordinates": [[[-121.018614, 42 .377513], [-121.01859, 42.377513], [-121.01859, 42.378199], [-121.018614, 42.378199], [-121.018614, 42.377513]]]}, "propertie s": {...}} (1 row) How could this be? The data stored even appears to be valid JSON. A few basic things I have tried thus far: Restarting my Docker environment Rolling back and migrations associated with the JSON field Varying … -
Semantic UI Dropdown ApiSettings not working
I simply want to make this dropdown a dynamic search but for some reason jquery isn't working correctly. The field becomes searchable but no dropdown results. Django isn't receiving any api requests on input. //HTML <div class="ui fluid search selection dropdown" id="origin-search"> <div class="text">Search Origin</div> <i class="dropdown icon"></i> <input type="hidden" name=""> </div> //JS $(".location-search").dropdown({ apiSettings: { url: url, } }); libraries used: <script src="{% static 'javascript/jslib/moment.2.20.1.js' %}"></script> <script src="{% static 'javascript/jslib/jquery-3.3.1.min.js' %}"></script> <script src="{% static 'javascript/jslib/jquery.datatables.min.js'%}"></script> <script src="{% static 'javascript/jslib/jquery.formset.js' %}"></script> <script src="{% static 'semantic/dist/semantic.min.js' %}"></script> Any idea why? This in django. -
I want to set an API on django rest framework just like it https://docs.microsoft.com/en-us/rest/api/power-bi/reports/get-reports-in-group#code-try-0
I want to set an API on django rest framework which take sheet_id of google drive. I want same functionality but google.drive. https://docs.microsoft.com/en-us/rest/api/power-bi/reports/get-reports-in-group#code-try-0 -
Django Middleware user is always anonymus (REST, SimpleJWT)
I am using Django REST Framework alongside with rest_framework_simplejwt and trying to write my own middleware, that will update user.last_request every time user performs one. from django.utils.timezone import now class LastRequestMiddleware: def __init__(self, get_response): self.get_response = get_response def __call__(self, request): if request.user.is_authenticated: request.user.last_request = now() request.user.save() response = self.get_response(request) return response``` But every time `user.is_authenticated` returns `False' -
subclasses of BaseDatabaseOperations may require a datetime_extract_sql() method
I am working on a Django project integrated with MongoDB as the database. I have set up my models for a simple blog post, views(function-based views), and URLs but I experience this error when I want to add a post(from the admin area for now): NotImplementedError at /admin/mongo/post/add/ subclasses of BaseDatabaseOperations may require a datetime_extract_sql() method models.py from django.db import models from django.utils import timezone from django.contrib.auth.models import User from django.urls import reverse # Create your models here. class PublishedManager(models.Manager): def get_queryset(self): return super(PublishedManager, self).get_queryset().filter(status='published') class Post(models.Model): STATUS_CHOICES = ( ('draft', 'Draft'), ('published', 'Published'), ) title = models.CharField(max_length=250) slug = models.SlugField(max_length=250, unique_for_date='publish') author = models.ForeignKey( User, on_delete=models.CASCADE, related_name='blog_posts') body = models.TextField() publish = models.DateTimeField(default=timezone.now) created = models.DateTimeField(auto_now_add=True) status = models.CharField( max_length=10, choices=STATUS_CHOICES, default='draft') objects = models.Manager() published = PublishedManager() class Meta: ordering = ('-publish',) verbose_name = 'Post' verbose_name_plural = 'Posts' def __str__(self): return self.title def get_absolute_url(self): return reverse("mongo:post_detail", args=[self.publish.year, self.publish.month, self.publish.day, self.slug]) views.py from django.shortcuts import render, get_object_or_404 from .models import Post # Create your views here. def post_list(request): posts = Post.published.all() return render(request, 'blog\post\list.html', {'posts': posts}) def post_detail(request, year, month, day, post): post = get_object_or_404(Post, slug=post, status='published', publish__year=year, publish__month=month, publish__day=day) return render(request, 'blog/post/detail.html', {'post': post}) -
What is best practice to remove values in M2M relation in DRF?
could you please point this out... What is the best practice in django rest framework should be if I wanna remove some m2m objects from base model object? Should I just be satisfied with views method PATCH and update method in serializers (orm m2m method "set" to reset and install all values from scratch) and to use obj.m2m.set(*[list_values]) OR should I implement a views action method DELETE to remove specific values (orm m2m method "remove" to remove specified in list objects) and to use obj.m2m.remove(*[list_of_values])? -
Django Modelform with one custom field doesn't save
We use a JSONField to store some dynamic data on our application. We would like to present this data in a user friendly manner and decided on a table with keys and values. For this we adjusted the ModelForm in our forms.py: class UserEditForm(ModelForm): class Meta: model = OUR_MODEL fields = ['description', 'reference'] widgets = { 'reference': CustomJSONWidget(), } The CustomJSONWidget is defined as follows: class CustomJSONWidget(Widget): template_name = 'jsonwidget.html' def get_context(self, name, value, attrs=None): return {'widget': { 'name': name, 'value': json.loads(value), 'type': 'table' }} def render(self, name, value, attrs=None, renderer=None): context = self.get_context(name, value, attrs) template = loader.get_template(self.template_name).render(context) return mark_safe(template) And finally the jsonwidget.html looks like this: <table name="{{ widget.name }}"> ... <tbody> {% for key, val in widget.value.items %} <tr> <td><input {% if key != None %} value="{{ key|stringformat:'s' }}"{% endif %} /></td> <td><input {% if val != None %} value="{{ val|stringformat:'s' }}"{% endif %} /><td> <tr> {% endfor %} </tbody> </table> It looks good on the page, exactly like we envisioned it, but the saving doesn't work: when trying to update the description it throws that reference is a required field and changing the table doesn't do anything. Where do we have to overwrite the save? Is … -
Fake installization in django
When I install django (pip install django) the cmd say Requirement already satisfied but when I do this (django-admin --version) to get the version the cmd say 'django-admin' is not recognized as an internal or external command, operable program or batch file. -
Django ORM Annotate Count Items and Order by Specific Order?
I have a graph showing different licence types by region and how many active licences there are in each region. Is there a way to order the items in a specific order in the queryset to be output to the graph? These are my models: class Licence(models.Model): status = models.CharField(choices=STATUS, max_length=1000) number = models.CharField(unique=True, max_length=1000) licence_type = models.ForeignKey( "LicenceType", on_delete=models.SET_NULL, null=True ) class LicenceType(models.Model): region = models.ForeignKey( "Region", on_delete=models.SET_NULL, null=True ) class Region(models.Model): slug = models.SlugField(primary_key=True) Here is my view: @login_required(login_url="/login/") def dashboard(request): # total number of active licences across regions active_licences = ( Licence.objects.values("licence_type", "licence_type__region") .annotate(total=Count("id")) .order_by("licence_type") ) return render(request, "dashboard.html", "active_licences": active_licences) Is there a way that I can specify the order in which the regions appear? For example, they are currently in the order (by pk) [1, 2, 3, 4, 5, 6, 7, 8, 9, 10] but I want them to appear as [1, 3, 2, 4, 5, 6, 7, 8, 9, 10]. -
Saving a list on a djago model
Hi guys I'm working with python, django and django rest framework I want to sabe the information that i have on a dictionary into a model but I don't know how to do it I would be really thankful if you explain me how can I do it This is the list [{'evolution': 'charizard', 'height': 11, 'id_pokemon': '5', 'name': 'charmeleon', 'stats': [[80, 'speed'], [65, 'special-defense'], [80, 'special-attack'], [58, 'defense'], [64, 'attack'], [58, 'hp']], 'weight': 190}, {'evolution': 'charmeleon', 'height': 6, 'id_pokemon': '4', 'name': 'charmander', 'stats': [[65, 'speed'], [50, 'special-defense'], [60, 'special-attack'], [43, 'defense'], [52, 'attack'], [39, 'hp']], 'weight': 85}, {'evolution': 'None', 'height': 17, 'id_pokemon': '6', 'name': 'charizard', 'stats': [[100, 'speed'], [85, 'special-defense'], [109, 'special-attack'], [78, 'defense'], [84, 'attack'], [78, 'hp']], 'weight': 905}] #_____________________________________ #And i want to save it on this model class Pokemon(models.Model): """Database model for pokemon information""" id_pokemon = models.IntegerField(primary_key=True) name = models.CharField(max_length=255) weight = models.IntegerField() height = models.IntegerField() special_defense = models.IntegerField() special_attack = models.IntegerField() defense = models.IntegerField() attack = models.IntegerField() hp = models.IntegerField() speed = models.IntegerField() evolution = models.IntegerField() -
Django Rest-Framework During Validation, Check the Request Method Type
I am working on API Validation Errors to be called. I have to make sure 2 dates don't overlap when making new "POST" calls, which is working fine. I am doing a model.objects.Filter() query and if anything gets returned, I return a validation error. However, I want to return this error only during POST requests. I have tried if request.method == "POST": do something but I get errors under the "request" word saying "request" is not defined. is there another way to check the Method Type during validation? I am doing this in my serializer. Thanks! -
AttributeError: 'int' object has no attribute 'pk' - Django
I'm trying to return a very simple serialised queryset and I get this error: AttributeError: 'int' object has no attribute 'pk' Models: class Portfolio(models.Model): user = models.ForeignKey(User, on_delete=models.CASCADE) name = models.CharField(max_length=200, blank=False, null=False) class Image(models.Model): user = models.ForeignKey(User, on_delete=models.CASCADE) portfolio = models.ForeignKey(Image, related_name="images", on_delete=models.CASCADE) thumb = models.URLField(blank=True, null=True) View: class PortfolioViewSet(viewsets.ModelViewSet): serializer_class = serializers.PortfolioSerializer queryset = models.Portfolio.objects.all() permission_classes = (permissions.IsAuthenticated, core_permissions.IsMineOnly) def get_queryset(self): portfolios = self.request.user.portfolio_set.all() ser = self.serializer_class(portfolios, many=True) data = ser.data return data serialisers: class PortfolioSerializer(serializers.ModelSerializer): images = ImageSerializer(many=True) class Meta: model = models.Portfolio exclude = ('user',) class ImageSerializer(serializers.ModelSerializer): class Meta: model = Image fields = '__all__' I read this answer that says we should use validated_data after calling is_valid() first but I don't serialise data but a queryset so I can't call this method.
