Django community: RSS
This page, updated regularly, aggregates Django Q&A from the Django community.
-
Use django-redis on AWS beanstalk without Elasticache
I wish to create a cache for an app that will be deployed on AWS Elastic Beanstalk (EB for the rest of the question) but cannot find any tutorial that achieves this without using Elasticache. My question is : is it possible to do it? i.e. launch the app with some EB config that will activate django-redis on the server EB will create and use its memory without linking to any external cache? Thanks -
Dynamic annotion in django queryset
I have a Django queryset being created for a graph like the following: obj = Allotment.objects.all().values('dispatch_date').annotate(transaction_no=Count('transaction_no')).\ values('dispatch_date', 'transaction_no') Now I am trying to pass all these values dynamically so I tried this : data = request.data.copy() x_model = data['x_model'] y_model = data['y_model'] obj = Allotment.objects.all().values('{}'.format(x_model)).annotate(transaction_no=Count('{}'.format(y_model))).\ values('{}'.format(x_model), '{}'.format(y_model)) where I just replaced the string values and it gives me the following error: The annotation 'transaction_no' conflicts with a field on the model. How do I dynamically change the field in annotate function ? and apply aggregators such as Sum, Count, etc given that the aggregators are passed through the API as well -
How change a function based view into a class based?
I want to write a category detail view in order to do so i want to change this function based view def CategoryView(request, cats): category_posts = Post.objects.filter(category=cats.replace('-', ' ')) return render(request, 'categories.html', {'cats':cats.replace('-', ' ').title(), 'category_posts':category_posts}) into the class based view. My first question: 1. How to do so?; 2.How also change the url for the view?; path('category/<str:cats>/', CategoryView, name='category'), Here is my models: from django.conf import settings from django.db import models from django.urls import reverse class Category(models.Model): name = models.CharField(max_length=255) def __str__(self): return (self.name) def get_absolute_url(self): return reverse("home") class Post(models.Model): title = models.CharField(max_length=255) body = models.TextField() author = models.ForeignKey(settings.AUTH_USER_MODEL, on_delete=models.CASCADE,) created_at = models.DateTimeField(auto_now_add=True) updated_at = models.DateTimeField(auto_now=True) category = models.ManyToManyField(Category, related_name='categories') def __str__(self): return self.title def get_absolute_url(self): return reverse("post_detail", kwargs={"pk": self.pk}) @property def categories(self): return ', '.join([x.name for x in self.category.all()]) class Comment(models.Model): article = models.ForeignKey(Post, null=True, blank=True, on_delete=models.CASCADE) comment = models.CharField(max_length=140) author = models.ForeignKey(settings.AUTH_USER_MODEL,on_delete=models.CASCADE,) def __str__(self): return self.comment def get_absolute_url(self): return reverse("post_list") When you write an answer, if you don't mind, can you also write an explanation a step by step. And can you also write how did you figure out the answer. A lost a useful materials would be also helpful. Thank you in advance -
Does anyone else have images reload or dissapear everytime they push to Heroku?
Whenever I push my git push to heroku the images that were previously uploaded on the site disappear. It still shows the file path on my backend database but the images actually just go to placeholder image. Has anyone else had this problem? I just have no idea what is causing the problem. I have whitenoise installed. I had an issue earlier with the "simple upload" that heroku offers that was not working, but I deleted it. I don't know if there are remnants of the code somewhere that is messing up my server? -
Django query after a given character
I am trying to filter data from the postgres database connected to my django app. The data in the database column to be filtered is in this format e.g Name|ABC & facilities:Unit|XY Unit I want to write a django query that matches the search text after the last pipe ("|") symbol. How can this be done to return the data in shortest time possible. I tried writing a query Mymodel.objects.filter(name__iendswith=searchTxt) but it's not returning any result. -
How to link multiple Django models to display a form?
I'm building an application to track the assignment of applications to employees. Each department has a list of applications that are utilized by employees and each application has a list of optional options (access levels as needed). I'm struggling with how to put the form together by stitching all these models together. My goal is to display applications grouped by their department with their associated options and status. Am I overthinking this? Is there a simpler way to achieve what I'm trying to do? Example: Department: department.name +---------------------+-----------------------------+------------------------+ | application.name | <applicationsubtype.name> | <statuslevel.status> | +---------------------+-----------------------------+------------------------+ which translates to: Department: IT Application Options (drop down) Status (drop down) +---------------------+-----------------------------+-------------------------------+ | Active Directory | Standard/Admin | Unassigned/Assigned/Revoked | +---------------------+-----------------------------+-------------------------------+ +---------------------+-----------------------------+-------------------------------+ | Microsoft Office | | Unassigned/Assigned/Revoked | +---------------------+-----------------------------+-------------------------------+ Below are the models I've created. I can input data via Django Admin but I would like to display it on a form as described above. models.py from django.db import models class Employee(models.Model): first_name = models.CharField(max_length=50) last_name = models.CharField(max_length=50) employee_id = models.PositiveIntegerField() department = models.ForeignKey("Department", on_delete=models.SET_NULL, null=True, blank=True) job_title = models.ForeignKey("JobTitle", on_delete=models.SET_NULL, null=True, blank=True) applications = models.ManyToManyField("Application", through="ApplicationManager") def __str__(self): return f"{self.first_name} {self.last_name}" class Department(models.Model): name = models.CharField(max_length=100) manager = models.ForeignKey("Employee", on_delete=models.SET_NULL, null=True, … -
Request URL: http://localhost:8000/user Request Method: GET Status Code: 401 Unauthorized Remote Address: 127.0.0.1:8000 in django rest & react axios
i am tring to do untimate authantication in django and reactjs typescript and is giveng me error like 401 i have doing in 3wek to solve this can you help me please """"""""""django"""""""" models.py from django.db import models from django.contrib.auth.models import AbstractUser # Create your models here. class Users(AbstractUser): first_name = models.CharField(max_length=256) last_name = models.CharField(max_length=256) email = models.CharField(max_length=256,unique=True) password = models.CharField(max_length=256) username = None USERNAME_FIELD = 'email' REQUIRED_FIELDS = [] class UserToken(models.Model): user_id = models.IntegerField() token = models.CharField(max_length=256) created_at = models.DateTimeField(auto_now_add=True) expired_at = models.DateTimeField(auto_now=True) class Reset(models.Model): email = models.CharField(max_length=255) token = models.CharField(max_length=256) views.py from rest_framework.views import APIView from rest_framework.response import Response from rest_framework import exceptions from .Serializers import UserSerializers from .models import Users, UserToken, Reset from .authentication import create_access_token, create_refresh_token, JWTAuthentication, decode_refresh_token import datetime, random, string from django.core.mail import send_mail class RegisterAPIView(APIView): def post(self, request): data = request.data if data['password'] != data['password_confirm']: raise exceptions.APIException('password do not match!') serializer = UserSerializers(data=data) serializer.is_valid(raise_exception=True) serializer.save() return Response(serializer.data) class LoginAPIView(APIView): def post(self, request): email = request.data['email'] password = request.data['password'] user = Users.objects.filter(email=email).first() if user is None: raise exceptions.AuthenticationFailed('Invalid credentials ') if not user.check_password(password): raise exceptions.AuthenticationFailed('Invalid credentials') access_token = create_access_token(user.id) refresh_token = create_refresh_token(user.id) UserToken.objects.create( user_id = user.id, token = refresh_token, expired_at = datetime.datetime.utcnow() + datetime.timedelta(days=7) … -
In Django I created two URLs to insert data and retrieve data [closed]
In Django I created two URLs to insert data and retrieve data but As I can check in database data is inserted properly in table but it is displaying in list after running command python manage.py run server In Django I created two URLs to insert data and retrieve data but As I can check in database data is inserted properly in table but it is displaying in list after running command python manage.py run server -
How to change unique_together error message in django model?
Model: class MyModel(models.Model): field1 = models.CharField(max_length=50) field2 = models.CharField(max_length=50) class Meta: unique_together = ('field1', 'field2') Error: UNIQUE constraint failed: field1, field2 I want to change error mesaage to {'field2': 'This value is already exist'} OR How to override unique_error_message() in django model? I try this: def unique_error_message(self, model_class, unique_check): return ValidationError(message='My custom error message') But didn't work. -
Retrieve submitted data Django
I have created this dependent dropdown using plain HTML. When I click on submit, it redirects me to the next page where I have to run a python code based on the selection made in the previous page. I am unable to figure out how to retrieve the submitted data, any help? -
Get objects where (val1, val2) both in (other_val1, other_val2, ...)
Given the models below: class Language(models.Model): name = models.CharField(max_length=255, unique=True) class Profile(models.Model): languages = models.ManyToManyField(Language) class Job(models.Model): language1 = models.ForeignKey( Language, models.CASCADE, related_name='language1' ) language2 = models.ForeignKey( Language, models.CASCADE, related_name='language2' ) How to represent the following sql query to orm expression? with user_languages as (select language_id from core_profile_languages where profile_id = <profile-id>) select * from core_job where language1_id in (select * from user_languages) and language2_id in (select * from user_languages) -
Save generated image to ImageField model Django
Detected path traversal attempt in '/home/mrlonely/Desktop/lumen/lumen/media/thumbnail/6.jpeg' When i run this in the views.py: def generate_thumbnail(instance): post = Post.objects.get(pk=instance.pk) output = 'media/thumbnail/' + post.title + '.jpeg' filename_thumbnail = Path.joinpath(filename, output) try: ( ffmpeg .input(str(filename)+post.video.url, ss='00:00:20') .output(output, vframes=1) .overwrite_output() .run(capture_stdout=True, capture_stderr=True) ) with open(filename_thumbnail, 'rb') as file_handler: django_file = File(file_handler) post.thumbnail.save(filename_thumbnail, 'thumbnail/') except ffmpeg.Error as e: print(e.stderr.decode(), file=sys.stderr) sys.exit(1) I am trying to connect the ffmpeg generated thumbnail to the model ImageField on the Post model (instance is post) -
how can i post form object, correctly?
i am practicing CBV , so i thought to check if i can override methodes, well one of biggest problems is that idk how to use data(like data just submitted ), i wrote this code for a DetailView so i could see post and comments under it: class ArtDetailView(FormView, DetailView): model = Art form_class = CommentForm def get_context_data(self, **kwargs): context = super(ArtDetailView, self).get_context_data(**kwargs) context['time'] = timezone.now() context['form'] = self.get_form() return context def form_valid(self, form): form.instance.writer = self.request.user form.instance.text = self.post #form.instance.art = Art.objects.get(id=self.pk) form.save() return super().form_valid(form) def get_success_url(self) -> str: return reverse('pages:art_detail', args=(self.kwargs['pk'],)) forms.py: from django import forms from .models import Art, Comment class CommentForm(forms.ModelForm): class Meta(): model = Comment fields = ['text','art'] but when i post something it is in this shape:screen_shot(2nd comment) ,i think problem is withform.instance.text = self.post but i don't know how to fix it can you please also explain a little because all i want is to learn. and i tried to also add art as autofill(i added as comment) but wasn't successful, can you pls check it it too. -
Use Javascript to add row and html element with Django to get view dict but appear Error
Use Javascript to add row and html element with django get view dict show , but getting an error, the error shows django.template.exceptions.TemplateSyntaxError: Could not parse some characters: JourDt|"+i+"||date:'Y-m-d' i try use quotation mark Adjustment,still can't do it, what should i do? <script> $(document).ready(function () { var html = ""; for (i = 1 ; i < 5 ; i++) html += "<tr style="+"text-align: center;>" +"<td>"+i+"</td>" +"<td><input type="+"'date'"+"value="+"{{JourDt"+i+"|date:'Y-m-d'}}></td>"; $("#myTable").html(html); }); </script> -
Looking for a way to detect database changes using Django Channels
I am looking for a way to detect if there is data insertion happened in my database, i will use this to create a notification badge in real time so that the user wont need to refresh the page to see if there is new notifications. I am planning to use django channels but i cannot see any tutorials that will fit my need. I've tried to use timer but i don't think it is the best practice for this. -
How to create and save a model with multiselect values in Django
I am trying to create a model where I can assign multiple days of the week to a Customer through a form. However, when I try to save it I get the following error. django.db.utils.DataError: value too long for type character varying(2) I am using the django-multiselectfield package to create multiple select checkboxes. https://pypi.org/project/django-multiselectfield/ model.py from multiselectfield import MultiSelectField DAYS_OF_THE_WEEK_CHOICES = [ ('Mo', 'Monday'), ('Tu', 'Tuesday'), ('We', 'Wednesday'), ('Th', 'Thursday'), ('Fr', 'Friday'), ('Sa', 'Saturday'), ('Su', 'Sunday'), ] class Customer(models.Model): days_of_the_week = MultiSelectField(choices=DAYS_OF_THE_WEEK_CHOICES) forms.py RECURRINGDAYS = [ ('Mo','Monday'), ('Tu','Tuesday'), ('We','Wednesday'), ('Th','Thursday'), ('Fr','Friday'), ('Sa','Saturday'), ('Su','Sunday') ] class CustomerCreateForm(forms.Form): days_of_the_week = forms.MultipleChoiceField(required=False, choices=RECURRINGDAYS, widget=forms.CheckboxSelectMultiple(), label="Recurring Day(s)?") views.py from .models import Customer from .forms import CustomerCreateForm def create_customer(request): form = CustomerCreateForm(request.POST or None) if request.POST: if form.is_valid(): recurringDays = form.cleaned_data['days_of_the_week'] newCustomer = Customer( days_of_the_week = recurringDays ) newCustomer.save() return render(request, "customer.html", context) If someone fills out the form and selects Monday and Tuesday, how do I save that to the database Customer model? -
DRF foreign key field is empty when update the object
In Django Rest Framework this is the model: class Vehicle(models.Model): id = models.UUIDField(default=uuid.uuid4, editable=False, primary_key=True) system = models.ForeignKey(System, on_delete=models.SET_NULL, null=True) vehicle_type = models.ForeignKey(VehicleType, on_delete=models.PROTECT, null=True) I created an object with both vehicle_type and system but when I try to update the object, vehicle_type is empty by default. how can I fill vehicle_type with instance data? -
VSC : font color does not chagnges
enter image description here As soon as i installed django, the situation above suddenly happend. The fontcolor that represents imported modules or variables does not change into appropriate ones and remains white. Still Django works but i cannot directly see it does how can i solve this problem? attempted to change settings but didn't find any solution i want to make VSC recognize class and variables precisely -
Django e-commerce checkout page does not want to display products in the HTML page
basket/models.py from decimal import Decimal from django.db import models, migrations from django.conf import settings from datetime import datetime from marketplace.models import prodProduct from member.models import Person class Basket(models.Model): class Meta: db_table = 'basket' productqty = models.IntegerField(default=0) productid = models.ForeignKey(prodProduct, on_delete=models.CASCADE) Person_fk = models.ForeignKey(Person, on_delete=models.CASCADE) def save(self): super().save() def get_subtotal_price(self, fk1): product = prodProduct.objects.get(pk=fk1) basket = Basket.objects.all() return sum(Decimal(product['productPrice']) * basket['productqty']) def get_total_price(self, fk1): product = prodProduct.objects.get(pk=fk1) basket = Basket.objects.all() subtotal = sum(Decimal(product['productPrice']) * basket['productqty']) if subtotal == 0: shipping = Decimal(0.00) else: shipping = Decimal(3.00) total = subtotal + Decimal(shipping) return total marketplace/models.py class prodProduct(models.Model): class Meta: db_table = 'prodProduct' productid = models.AutoField(primary_key=True) productName = models.CharField(max_length=255, blank=True) productDesc = models.CharField(max_length=1500,blank=True) productCategory = models.CharField(max_length=255, blank=True) productPrice = models.DecimalField(max_digits=4, decimal_places=2) productStock = models.IntegerField(default=0) productPhoto = models.ImageField(upload_to ='images/', null=True) productRating = models.IntegerField(default=0) timePosted = models.DateTimeField(default=datetime.now, blank=True) Person_fk = models.ForeignKey(Person, on_delete=models.CASCADE) def save(self): super().save() return self.productid def deleteProduct(self): super().delete() basket/summary.html {% block content %} <div class="container"> <div class="col-12"> <h1 class="h2">Your Basket</h1> </div> <div class="col-12"> <p>Manage your <b>items</b> in your basket</p> </div> <hr /> </div> <div class="container"> <div class="row g-3"> {% if allBasket.count == 0 %} <div class="col-12">Your basket is empty <a href="{% url 'MainMarketplace' %}">Shop</a></div> {% else %} <div class="col-12 bg-light p-3 d-flex justify-content-between"> … -
What is the correct way to configure ASGI application for channels in Django?
I've just started to learn about channels and asgi in django in few tutorials that i've seen they do this to configure the asgi apllication asgi.py import os from django.core.asgi import get_asgi_application from channels.routing import ProtocolTypeRouter, URLRouter os.environ.setdefault('DJANGO_SETTINGS_MODULE', 'config.settings') application = ProtocolTypeRouter({ 'http':get_asgi_application(), }) settings.py INSTALLED_APPS = [ 'channels', 'django.contrib.admin', 'django.contrib.auth', 'django.contrib.contenttypes', 'django.contrib.sessions', 'django.contrib.messages', 'django.contrib.staticfiles', 'chat' ] ASGI_APPLICATION = 'config.asgi.application' to check when i run my server it was supposed to be running on asgi/channel server like this Starting ASGI/Channels version development server at http://127.0.0.1:8000/ but mine is still running on the default one Starting development server at http://127.0.0.1:8000/ when i use daphne and put inside installed apps instead of channels 'daphne', 'django.contrib.admin', 'django.contrib.auth', 'django.contrib.contenttypes', 'django.contrib.sessions', 'django.contrib.messages', 'django.contrib.staticfiles', 'chat' ] it works fine Starting ASGI/Daphne version 4.0.0 development server at http://127.0.0.1:8000/ can someone tell me what is going on here?and how exactly django works with asgi? -
Not entering Else Statement from user.is_authenticated
In the castmascotvote view, everything is working when I'm authenticated, but not working otherwise. I have a print('entering not authenticated') right when it enters the else statement if the user isn't authenticated, but it never enters it, i'm boggled. I don't understand at all why it's not working. does anyone have any idea where I should start looking? error message The view didn't return an HttpResponse object. It returned None instead. But I clearly have a HttpResponse object! .html <form class="mascotvoteform" action="{% url 'castmascotvote' mascot.id %}" id="{{mascot.id}}"> <div class="p-0"><h4>{{ mascot.name }} </h4> <p> by {{ mascot.author }} </p></div> <div class="p-0"><img class="img-thumbnail" src="{{ mascot.image.url }}" style="width:250px;"></div> <div class="row p-3"> {% if mascot.total_votes is 0 %} <div class="col"><h5 id="mascotvotes{{mascot.id}}">0</h5></div> <button class="col btn btn-primary" type="submit" id="castmascotvote{{mascot.id}}">Vote</button> {% else %} <div class="p-0 col"><h5 id="mascotvotes{{mascot.id}}">{{ mascot.total_votes }}</h5></div> <button class="col btn btn-primary" type="submit" id="castmascotvote{{mascot.id}}">Vote</button> {% endif %} </div> </form> .script $( document ).ready(function() { $(".mascotvoteform").submit(function(e) { {% if user.is_authenticated %} e.preventDefault() {% endif %} let mascot_id = $(this).attr("id"); let url = $(this).attr('action'); $.ajax({ type: 'POST', url: url, data: { 'csrfmiddlewaretoken': $('input[name=csrfmiddlewaretoken]').val(), 'mascot_id': mascot_id, }, success: function(response) { console.log('success', response) $(`#mascotvotes${mascot_id}`).text(`${response['total_votes']}`) }; }, error: function(response) { console.log('error', response) } }); }) .views def castmascotvote(request, mascot_id): mascot = … -
How to handle variable replacement in dev vs rollup build?
I am making a site that was based off Open Web Components Generator. I hit the same issue of process not being defined for redux as this SO question: lit-element with rollup and redux: process is not defined I am confused because the top answer says to use Rollup's replace plugin. This works great for the built version from the generator's package.json which runs the following: "build": "rimraf dist && tsc && rollup -c rollup.config.js && npm run analyze -- --exclude dist", However when I'm just doing dev watcher the command is this: "start": "tsc && concurrently -k -r \"tsc --watch --preserveWatchOutput\" \"wds\"" Rollup isn't going to run while just doing a dev watcher like this so I'm not sure how to solve the problem when doing dev as opposed to building. Meanwhile the Redux maintainer on the original post, says to use an artifact when not bundling with something via Rollup. My code is like the following so I'm not sure how to satisfy both conditions. import { configureStore, EnhancedStore, } from '@reduxjs/toolkit'; I wonder if this is an issue on me, or Open WC not using Rollup watch under the hood? -
problem with SQLite when deploying Django Website on AWS, cant properly instal pysqlite
`I have made Django blog. I encountered this error after deploy when trying to visit my website on AWS: Django - deterministic=True requires SQLite 3.8.3 or higher upon running python manage.py runserver So I found this solution: Django - deterministic=True requires SQLite 3.8.3 or higher upon running python manage.py runserver So i understand it like this: In ubuntu terminal i type : sudo apt install python3.10-venv to install envirement Then in my Django project in Visual Studio i type python3 -m venv django_my_site to create virtual env Now i click "+" to open this env and type pip3 install pysqlite3 and pip3 install pysqlite3-binary After that i type python3 -m pip freeze > requirements.txt and i get requirements.txt file which looks like that: asgiref==3.6.0 Django==4.1.4 Pillow==9.3.0 pysqlite3==0.5.0 pysqlite3-binary==0.5.0 sqlparse==0.4.3 Now AWS have problem with installing pysqlite3. How to properly install pysqlite3 on AWS? Encountered error while trying to install package. pysqlite3` note: This is an issue with the package mentioned above, not pip. hint: See above for output from the failure. src/blob.h:4:10: fatal error: sqlite3.h: No such file or directory #include "sqlite3.h" ^~~~~~~~~~~ compilation terminated. LINK TO MY REPOSITORY: https://github.com/Stanotech/my_site.git I tried to deploy site with sqlite with no success, … -
How to create a crypto payment invoice generator app?
I want to create an application that generates invoices in order to receive crypyo payment but I don't know where to start. I code in django and react and I request any idea, tool, framework, github similar project or anything that can help me develop my project. -
Bootstrap 4 close button not working django
enter image description hereI have a close button on my alert but when I click on it it doesn't close. I have seen similar people with the same problem but none of the solutions have worked for me This is what I currently have {% for message in messages %} <div class="container-fluid p-0"> <div class="alert {{ message.tags }} alert-dismissible fade show" role="alert"> <button type="button" class="close" data-dismiss="alert" aria-label="Close"> <span aria-hidden="true">&times;</span> </button> {{ message }} </div> </div> {% endfor %}
