Django community: RSS
This page, updated regularly, aggregates Django Q&A from the Django community.
-
Who to manage changing url while handling old url
I have a url Ex /this-is-url-12334 Now I want to change this url to Ex /this-is-url But I don't want that any old url to show 404 what I want that if anyone who use old url should redirect to new url What approach should I take -
How to implement Category, SubCategory and Product in django
class Category(models.Model): name= models.CharField(max_length=50) @staticmethod def get_all_categories(): return Category.objects.all() def __str__(self): return self.name class Products(models.Model): name = models.CharField(max_length=60) price= models.IntegerField(default=0) category= models.ForeignKey(Category,on_delete=models.CASCADE,default=1 ) How can I now add subcategory to this heirarchy -
How to set html lang attribute in Django template?
I wrote a Django application that serves translated content for German users, and English content for everyone else. Currently I use a base template containing: <!DOCTYPE html> <html lang="en"> Obviously this sets the wrong lang in case the content is served as German. Possibly I could try something like <html lang="{{ 'de' if request.LANGUAGE_CODE == 'de' else 'en' }}"> but this feels clumsy and hard to maintain in case more languages are added. What would be a simple way to set <html lang> to the actual language served? -
Unable to retrieve username and password using POST in Django and Unity as Frontend
Hi there i am building an app in unity and am using Django as backend, i am new to Django and i was trying to retrieve username and password but i get the following error in terminal: However if i use csrf_exempt decorator, it works fine but this opens up my validate view to csrf attacks, is there any secure way? thanks Error: Forbidden (CSRF cookie not set.): /backend/fetchdata/ [18/Mar/2022 12:50:13] "POST /backend/fetchdata/ HTTP/1.1" 403 2870 Here is my view.py: from django.shortcuts import render from django.http import HttpResponse from django.views.decorators.csrf import csrf_exempt,csrf_protect def testhello(request): return HttpResponse("Hello from Django") # @csrf_exempt def validate(request): username= request.POST["user"] password = request.POST["pass"] # print(password) filelol = open("C://Users//Jay//Desktop//data.txt","w+") filelol.write(username) ``` -
django / joined query
Checked all docs and questions/answers here but not succesfull. Need your help. I've experience in pure PHP and MySQL, but frameworks kills me. My models; class Projects(models.Model): id = models.AutoField(primary_key=True) subject= models.CharField(max_length=50) sender= models.ForeignKey(User, on_delete=models.CASCADE)#inserting django's default user id This is django's default but edited auth_user table CREATE TABLE "auth_user" ( "id" integer NOT NULL PRIMARY KEY AUTOINCREMENT, "password" varchar(128) NOT NULL, "last_login" datetime NULL, "is_superuser" bool NOT NULL, "username" varchar(150) NOT NULL UNIQUE, "first_name" varchar(150) NOT NULL, "last_name" varchar(150) NOT NULL, "email" varchar(254) NOT NULL, "is_staff" bool NOT NULL, "is_active" bool NOT NULL, "date_joined" datetime NOT NULL, "tck_no" varchar(11) NOT NULL ) When I want to fetch my project, I use normally; SELECT u.*, p.* FROM users u, projects p WHERE u.id=p.sender; Above code returns all fields on both table normally. In django viewmodel; @login_required(login_url="/login/") def others_projects(request): projectlist = Projects.objects.all().filter(sender_id=request.user.id) Above code returns Projects table fields, but can not figured how to get first_name field matched record from users foreign key used? -
Django - Add classes to inline only if qs len is more than 5
For TaskInline I'd like to display it collapsed if there are more than 5 elements: from django.contrib import admin from django.contrib.auth.models import User from django.db import models class Task(models.Model): title = models.CharField(max_length=50) description = models.TextField() performer = models.ForeignKey(User, on_delete=models.CASCADE) class TaskInline(admin.TabularInline): model = Task def get_queryset(self, request): qs = super().get_queryset(request) if len(qs) > 5: self.classes = 'collapse', return qs @admin.register(User) class UserAdmin(admin.ModelAdmin): inlines = TaskInline, But trick that is implemented in get_queryset method seems not working (it seems this method selects all the items of Task model). Where should I compare len to add classes? -
Use variable as key name for model
I have the method like this. @classmethod def get_my_msg(cls): return cls.objects.latest("updated_at").my_msg Now , I want to give the variable to function and get the data dynamically such as @classmethod def get_my_msg(cls,key): return cls.objects.latest("updated_at").{key} // use variable here Is it possible? -
Django: How do I make a foreign key dynamic? [duplicate]
How can I dynamically tie two or more models of a video together with a foreign key, as shown below? class ProductVideo(models.Model): ... class UserVideo(models.Model): ... class History(models.Model): video = models.ForeignKey('ProductVideo or UserVideo') ... class Favorite(models.Model): video = models.ForeignKey('ProductVideo or UserVideo') ... -
Django: Using a nested TextChoice class values in a Meta class
I used to declare TextChoices classes inside the model class like this: class Order(models.Model): class OrderStatusChoices(models.TextChoices): NEW = 'NEW' CLOSED = 'CLOSED' CANCELLED = 'CANCELLED' status = models.CharField(choices=OrderStatusChoices.choices, max_length=9) In this case, I was instantiating the class as: from models import Order order = Order(status=Order.OrderStatusChoices.NEW) Now I need to use the TextChoices values in the Meta class to check the database constraint: class Order(models.Model): class OrderStatusChoices(models.TextChoices): NEW = 'NEW' CLOSED = 'CLOSED' CANCELLED = 'CANCELLED' status = models.CharField(choices=OrderStatusChoices.choices, max_length=9) class Meta: constraints = [ models.CheckConstraint( name='%(app_label)s_%(class)s_status_valid', check=models.Q(status__in=OrderStatusChoices.values) ) ] However, if the status class is nested within the order class, the textchoice cannot be referenced (Unresolved reference 'OrderStatusChoices' ). This can be solved by taking the status class out of the order class: class OrderStatusChoices(models.TextChoices): NEW = 'NEW' CLOSED = 'CLOSED' CANCELLED = 'CANCELLED' class Order(models.Model): status = models.CharField(choices=OrderStatusChoices.choices, max_length=9) class Meta: constraints = [ models.CheckConstraint( name='%(app_label)s_%(class)s_status_valid', check=models.Q(status__in=OrderStatusChoices.values) ) ] But this does not make it very convenient to import (for me, maybe I'm wrong and this is normal) the order model without status textchoice and in order to create an instance of the order class, you need to import both the order model and the status textchoice: from models … -
footer is not fixed to bottom
<footer class="footer"> <!-- Copyright --> <div class="navbar fixed-bottom my_footer"> <p class="text-center"> © 2022 Copyright: Anoop Electronics </p> </div> <!-- Copyright --> </footer> this footer is not fixed to the bottom. It follows when its scrolling down/up. https://ecommerce9.pythonanywhere.com/shop/ -
Nginx www redirect to non-www, browser says your connection to this site is not secure, Django
I can't connect to my site with www.example.com, it says 'not secure' only https://example.com works. At first I didn't set the DNS A record for www to redirect to my server ip so www.example.com wasn't working, but once I added the www A record it now shows Not Secure with the red https line through it when I go to www.example.com. Here is my myapp.conf from nginx sites-available: upstream myapp_app_server { server unix:/apps/myapp/myapp_env/run/gunicorn.sock fail_timeout=0; } server { listen 80; listen [::]:80; server_name example.com www.example.com; return 301 https://$server_name$request_uri; } server { listen 443 ssl http2; listen [::]:443 ssl http2; server_name example.com; ssl_certificate /etc/letsencrypt/live/example.com-0001/fullchain.pem; ssl_certificate_key /etc/letsencrypt/live/example.com-0001/privkey.pem; include /etc/letsencrypt/options-ssl-nginx.conf; ssl_dhparam /etc/letsencrypt/ssl-dhparams.pem; client_max_body_size 4G; access_log /etc/nginx/logs/nginx-access-prod.log; error_log /etc/nginx/logs/nginx-error-prod.log; location = /favicon.ico { access_log off; log_not_found off; } location /static/ { alias /var/www/html/myapp/static/; } location /media/ { alias /var/www/html/myapp/media/; } location / { proxy_set_header X-Forwarded-For $proxy_add_x_forwarded_for; proxy_set_header X-Forwarded-Proto https; proxy_set_header Host $http_host; proxy_redirect off; if (!-f $request_filename) { proxy_pass http://myapp_app_server; break; } if ( $host !~* ^(example.com|www.example.com)$ ) { return 444; } } } Here is my nginx.conf from etc/nginx: user www-data; worker_processes auto; pid /run/nginx.pid; include /etc/nginx/modules-enabled/*.conf; events { worker_connections 768; } http { sendfile on; tcp_nopush on; types_hash_max_size 2048; include /etc/nginx/mime.types; default_type application/octet-stream; … -
" 'User' object has no attribute 'products' 'User' "
When I run my code I keep getting this error " 'User' object has no attribute 'products' 'User' " I don't know where I went wrong please help me. Below is are my user's app codes Because I am trying to build the website to display products onto the user's profile page so the user can see the products they have got and also display these products on the main home page but I got stuck with this error. "'User' object has no attribute 'products'" **View.py** def register(request): if request.method == 'POST': form = UserRegisterForm(request.POST) if form.is_valid(): form.save() username = form.cleaned_data.get('username') messages.success(request, f'{username}! your account created') return redirect('login') else: form = UserRegisterForm() return render(request, 'users/register.html', {'form': form}) @login_required def profile(request): users = request.user products = users.products.all() return render(request, 'users/profile.html', {'user': users, 'products': products}) @login_required def add_product(request): if request.method == 'POST': form = ProductForm(request.POST, request.FILES) if form.is_valid(): product = form.save(commit=False) product.users = request.user product.slug = slugify(product.title) product.save() return redirect('profile') else: form = ProductForm() return render(request, 'users/add_product.html', {'form': form}) Models.py from django.contrib.auth.models import User from django.db import models class Users(models.Model): name = models.CharField(max_length=255) created_at = models.DateTimeField(auto_now_add=True) created_by = models.OneToOneField(User, related_name='users', on_delete=models.CASCADE) class Meta: ordering = ['name'] def __str__(self): return self.name forms.py This … -
How to PHP cURL call to Django?
This is my cURL code to shoot Django. But it cannot get any result and keep sending request. Anyone know about this issue? Thank you.. $ch = curl_init($to_shoot_url); curl_setopt($ch, CURLOPT_TIMEOUT, 0); curl_setopt($ch, CURLOPT_RETURNTRANSFER,1); curl_setopt($ch, CURLOPT_HTTPAUTH, CURLAUTH_ANY); curl_setopt($ch, CURLOPT_HTTPHEADER, $headers); curl_setopt($ch, CURLOPT_POST, 1); curl_setopt($ch, CURLOPT_POSTFIELDS, json_encode($data)); $result = curl_exec($ch); echo $result;die; curl_close($ch); -
Reorder DELETE Field in Formset
I have a Django formset that is displayed as a table with one form per table. I would like to add a checkbox in the first column of the table so that the user to check it if they would like to delete the row (form). I have the javascript to manage the deletion of the formset row (form) and modify the management form on the front end, but I am having an issue when I add the DELETE field to the form. I used the solution reference in modify DELETE widget so that I could add the class "delete" to all of my delete fields for use in CSS and JS on the front end. When the DELETE field is added it is always the last field in the form. I would like it to be first. models.py class ModelOne(models.Model): attr_one = models.CharField(max_length=16) attr_two = models.CharField(max_length=16) forms.py class BaseFormOneFormset(BaseModelFormSet): def add_fields(self, form, index) -> None: super().add_fields(form, index) form.fields[DELETION_FIELD_NAME].widget = forms.CheckboxInput(attrs={'class':"delete"}) form.fields["id"].widget=forms.HiddenInput(attrs={'class':'pk'}) class FormOne(forms.ModelForm): class Meta: model = ModelOne attr_one = forms.CharField(max_length=16, required=True, label="attr_one", widget=forms.TextInput(attrs={'size':5,'class':'required '})) attr_two = forms.CharField(max_length=16, required=True, label="attr_two", widget=forms.TextInput(attrs={'size':5,'class':'required '})) views.py def view_one(request): formset_factory_one = modelformset_factory( ModelOne, FormOne, formset=BaseFormOneFormset, extra=0, can_delete=True) formset_one = formset_factory_one(query_set=FormOne.objects.all(), prefix="formone") return render(request, … -
Remove specific sign when filtering in Django
I have this query cardId = request.POST.get('id') with connection.cursor() as cursor: cursor.execute("SELECT category1_id FROM app_card_tbl WHERE id =%s", [cardId]) row = cursor.fetchone() cursor.execute("SELECT name FROM app_category1_tbl WHERE id =%s",[row]) tab1 = cursor.fetchone() print(tab1) And the output of this is ('thisisname',) All i want is the output should looks like this it should remove the `(',) sign it is possible? thisisname -
Hide one of the User.ModelAdmin.fieldsets if User role changes in django
Hi I want to hide some fieldsets in admin if user role changes. In get_queryset() I'm changing queryset if role == 'CMS' I also want to hide Permission fieldset for same role. Here is my admin: Note: I'm Using list for fieldsets here I pasted touples from django.contrib import admin from django.contrib.auth import get_user_model from django.contrib.auth.admin import UserAdmin as BaseUserAdmin from django.contrib.auth.models import Permission from .models import BankAccount from addresses.models import Address User = get_user_model() class AddressInline(admin.TabularInline): model = Address extra = 0 @admin.register(User) class UserAdmin(BaseUserAdmin): list_display = ( 'id', 'full_name', 'email', 'gender', 'role', ) list_filter = ( 'gender', 'is_staff', 'is_superuser', 'is_active', ) list_display_links = ( 'full_name', 'email', ) search_fields = ( 'email', 'first_name', 'last_name', 'phone_number', ) readonly_fields = ( 'created', 'updated', ) ordering = ('first_name', 'email', 'last_name',) fieldsets = ( ('Credentials', {'fields': ('email', 'phone_number', 'password')}), ('Info', {'fields': ('first_name', 'last_name', 'gender', 'role', 'otp', 'profile_pic', 'created', 'updated')}), ('Permissions', {'fields': ('is_vendor', 'is_staff', 'is_superuser', 'is_active', 'groups', 'user_permissions')}), ) add_fieldsets = ( ('Credentials', {'fields': ('email', 'phone_number', 'password1', 'password2')}), ('Info', {'fields': ('first_name', 'last_name', 'gender', 'role', 'profile_pic')}), ('Permissions', {'fields': ('is_vendor', 'is_staff', 'is_superuser', 'groups', 'user_permissions')}), ) inlines = (AddressInline,) def full_name(self, obj=None): return f'{obj.first_name} {obj.last_name}' def get_queryset(self, request): if request.user.role == 'CMS': return self.model.objects.filter( role='CUSTOMER', is_staff=False, is_superuser=False … -
ckeditor embed failure issue
I use ckeditor in Django. I want to insert an embed link, but the following message is displayed when using the auto-embedding plugin. This URL could not be automatically embedded. Also, the network operation message for embedding is as follows. status 403 error "No referrer header presented with the request." -
How to use to_internal_field and to_representation to modify just one field of a model?
I have a Position model that has a field named time_to_fill. I want the user to be able to input an integer representing the number of days from the creation date of the model instance and the serializer to convert this to a datetime. Likewise upon fetching the data I want the serializer to just calculate the time delta and return an integer. I have tried implementing it through to_internal_field() but it seems like I need to implement a conversion to and from native types for all fields. Is there anyway to use to_internal_field() for one field? Model: class Position(models.Model): name = models.CharField(max_length=50, blank=False) client = models.ForeignKey(Client, null=False, blank=False, on_delete=models.CASCADE) time_to_fill = models.DateTimeField(null=True, blank=True, default=timezone.now) applicant_source = models.JSONField(default=dict, null=True, blank=True) vacancies = models.IntegerField( null=True, blank=True, validators =[MinValueValidator(0)], default=0) filled = models.IntegerField( null=True, blank=True, validators =[MinValueValidator(0)], default=0) Serializer (fails with a NOT NULL constraint error): class PositionSerializer(serializers.ModelSerializer): client_name = serializers.ReadOnlyField(source='client.name') class Meta: model = Position fields = '__all__' def to_internal_value(self, data): if (data['time_to_fill']): date = datetime.now(tz=timezone.utc) data['time_to_fill'] = date + timedelta(int(data['time_to_fill'])) return super().to_internal_value(data) -
Is it possible to have multiple views use one model but have all input go to the same table?
I'm playing around with user inputs in a madlib game, I want the user to be able to fill out the blanks then play a second game that would remember the first inputs. I have one model that handles all of the inputs, the user is asked to fill out forms on different pages but instead of appending their inputs into the same table it creates a new one. I feel like it has something to do with my views but I'm not sure how to send everything to one table, I'll post my views below. from .models import Story from .forms import PartOneForm, PartTwoForm def index(request): return render(request, 'mad_libs/index.html') def story(request): """Show part one""" story = Story.objects.all() context = {'story': story} return render(request, 'mad_libs/part_one.html', context) def part_one_forms(request): if request.method != 'POST': form = PartOneForm() else: form = PartOneForm(data=request.POST) if form.is_valid(): form.save() return redirect('mad_libs:part_one') context = {'form': form} return render(request, 'mad_libs/part_one_forms.html', context) def story_2(request): """Show part one""" story = Story.objects.all() context = {'story': story} return render(request, 'mad_libs/part_two.html', context) def part_two_forms(request): if request.method != 'POST': form = PartTwoForm() else: form = PartTwoForm(data=request.POST) if form.is_valid(): form.save() return redirect('mad_libs:part_two') context = {'form': form} return render(request, 'mad_libs/part_two_forms.html', context) -
how can i solve problem of django project?
Traceback (most recent call last): File "C:\Users\DELL1\AppData\Local\Programs\Python\Python39\lib\site-packages\django\template\utils.py", line 69, in getitem return self._engines[alias] KeyError: 'django' During handling of the above exception, another exception occurred: Traceback (most recent call last): File "C:\Users\DELL1\AppData\Local\Programs\Python\Python39\lib\site-packages\markdown_deux\templatetags\markdown_deux_tags.py", line 4, in from django.utils.encoding import force_text ImportError: cannot import name 'force_text' from 'django.utils.encoding' (C:\Users\DELL1\AppData\Local\Programs\Python\Python39\lib\site-packages\django\utils\encoding.py) when I run a project of Django I face the following error please help how can I fix this? -
python if statements and validation error
Need some help with the if statements and Vaidation errors. Right now I have this function: def validate(self, validated_data): if self.partial: validated_data = self.fill_data(self.instance, validated_data) if not validated_data['brand'].sunny_account.first(): raise ValidationError('This brand does not have Sunny enabled') validated_data['calculate'] = Account.NEW return validated_data Need to add another if statement: if not validated_data['brand'].moon_account.first(): raise ValidationError('This brand does not have Moon enabled') If I add another if not statement in this function it's not going to the second one if not and raising the first Validation error. I would like that this function checking all if's and raising Validation error for the each case. -
Need help TypeError at /register/
TypeError at /register/ Got a TypeError when calling User.objects.create(). This may be because you have a writable field on the serializer class that is not a valid argument to User.objects.create(). You may need to make the field read-only, or override the RegisterSerializer.create() method to handle this correctly. Original exception was: Traceback (most recent call last): File "/Users/bishnukandel/Desktop/ISQA8380/lab4part3/venv/lib/python3.7/site-packages/rest_framework/serializers.py", line 917, in create instance = ModelClass.objects.create(**validated_data) File "/Users/bishnukandel/Desktop/ISQA8380/lab4part3/venv/lib/python3.7/site-packages/django/db/models/manager.py", line 82, in manager_method return getattr(self.get_queryset(), name)(*args, **kwargs) File "/Users/bishnukandel/Desktop/ISQA8380/lab4part3/venv/lib/python3.7/site-packages/django/db/models/query.py", line 411, in create obj = self.model(**kwargs) File "/Users/bishnukandel/Desktop/ISQA8380/lab4part3/venv/lib/python3.7/site-packages/django/db/models/base.py", line 484, in init raise TypeError("'%s' is an invalid keyword argument for this function" % kwarg) TypeError: 'password2' is an invalid keyword argument for this function view.py from rest_framework import status, generics from rest_framework.decorators import api_view from django.views.decorators.csrf import csrf_exempt from .serializers import * from rest_framework.response import Response from rest_framework.permissions import IsAuthenticated, IsAuthenticatedOrReadOnly, AllowAny @csrf_exempt @api_view(['GET', 'POST']) def customer_list(request): permission_classes = (IsAuthenticatedOrReadOnly) if request.method == 'GET': customers = Customer.objects.all() serializer = CustomerSerializer(customers, context={'request': request}, many=True) return Response({'data': serializer.data}) elif request.method == 'POST': serializer = CustomerSerializer(data=request.data) if serializer.is_valid(): serializer.save() return Response(serializer.data, status=status.HTTP_201_CREATED) return Response(serializer.errors, status=status.HTTP_400_BAD_REQUEST) @api_view(['GET', 'PUT', 'DELETE']) def getCustomer(request, pk): """ Retrieve, update or delete a customer instance. """ try: customer = Customer.objects.get(pk=pk) except Customer.DoesNotExist: … -
Send real time data from django rest framework to flutter
I'm trying to implement the idea of sending a real-time data from REST API (DRF) to flutter. The problem is when i update the the model, i need the last update sent directly to flutter app without needing to refresh the app every time i sent a new update from the server. Can i achieve this through the backend? or there is another method in the flutter itself? Thanks in advance. -
Django table does not exist
I have a app in Django called webshopCatalog with the models.py. It is all in a development server, and I have previously dropped the mysql database followed by creating a new one since I was experimenting. The problem is, when I try to create a product now I get an error saying that the table does not exists (see the full error log when I click on the product link from admin). I have tried with python manage.py makemigrations and python manage.py migrate it doesn't solve the problem. I also tried to comment out the model followed by making a python manage.py makemigrations and python manage.py migrate --fake and hereafter uncomment the model followed by repeating the steps without --fake, still it doesn't solve the problem. from django.db import models from django.db.models.fields.related import create_many_to_many_intermediary_model from django.urls import reverse class Product(models.Model): name = models.CharField(max_length = 50, unique=True) description = models.TextField() allergic_note = models.CharField(max_length = 255, blank = True, null=True) quantity = models.IntegerField(null = True, blank = True) #Used for campaign products to show how many items there is left price = models.DecimalField(max_digits=9, decimal_places=0, default=0.00) is_active = models.BooleanField(default = True) is_deliverable = models.BooleanField(default = True) image_path = models.ImageField(upload_to = 'productImages') meta_keywords = … -
Django/Postgres primary key sequence
I have a Django application deployed on Heroku (free dyno) and I use Heroku Postgres as my database (Hobby Tier). I been noticing that sometimes there are some gaps/jumps on the primary key numeration. For example, there was a jump from 162 to 195, from 237 to 270... But objects are not deleted in between this gaps. I can't really understand why this is happening. Has anyone experienced something similar? What do you think? Is this problem related to Django, Postgres or Heroku?
