Django community: RSS
This page, updated regularly, aggregates Django Q&A from the Django community.
-
Error in posting data through Axios to Django Rest Framework server,Error code 500
I use token authentication to communicate between React and DRF. I can make GET request using below token but can not POST data to server with payload. axios.post('URL', { headers: {'Authorization': 'Token 83d1892877db7950c1c5a818cbb6ca738e53f90b'} }) .then(function (response) { console.log(response) }) .catch(function (error) { console.log(error); }) I get error 500 from Django server when posting above.But with same URL and Token I could successfully execute POST request in Postman. I want to add a data with the axios POST request, the data is {name:'myname'}. Thanks in advance -
how to make translatable relationship in django admin with django parler
I use django-parler to make my django app translatable, and everything works fine but I have a model for my products with relationship one to many: class Product(TranslatableModel): title = models.CharField(max_length=191) price = models.FloatField() translations = TranslatedFields( description=models.TextField(_('description')), any_language=True ) category = models.ForeignKey(Category, on_delete=models.CASCADE, related_name='products',) image = models.ImageField( upload_to=image_files, max_length=254, null=False ) def __unicode__(self): return self.description class Meta: ordering = ['id'] verbose_name = _('product') verbose_name_plural = _('products') where category is also translatable model. In my admin when I want to create a product I get this form: how can I change in that select object to translatable title? here is my admin.py: class ProductAdminForm(TranslatableModelForm): class Meta: model = Product exclude = () def __init__(self, *args, **kwargs): super(ProductAdminForm, self).__init__(*args, **kwargs) print(Category.objects.prefetch_related('translations').all()) self.fields['category'].queryset = Category.objects.prefetch_related('translations').all() class ProductAdmin(TranslatableAdmin): prefetch_language_column = True form = ProductAdminForm list_display = ('title', 'description', 'category', 'price', 'image') fieldsets = ( (None, { 'fields': ('title', 'description', 'price', 'category', 'image'), }), ) -
Django ordering by two fields not working as expected
i am working on a shop for clothes, shoes etc. And i am trying to sort the products by price. The problems comes when the product's discount_price field is populated which means that this product is discounted. So when i want to order the products in my view i am expecting to see products with lower discount_price before products with higher price, but it is not working like this. models.py class Item(models.Model): price = models.IntegerField(null=True, blank=True) discount_price = models.IntegerField(null=True, blank=True) The query i am performing items = Item.objects.all().order_by('price', 'discount_price') -
Several urls of website visible in Google
I build website in Django framework. I don't way why in Google serach, when I type name of the website domain, are visible several urls (like several webpages) which I created, not only main page? Is it any error in creating urls or any other error? -
FroalaField is not supported by modeltranslation
I am using frola editor on my django project. Today I tried to write modeltranslations for my website. it throws error : django.core.exceptions.ImproperlyConfigured: FroalaField is not supported by modeltranslation. on command python manage.py makemigrations Is there solution for this problem? -
How much data can a websocket consumer handle?
I've built a simple application using Django Channels where a Consumer receives data from an external service, the consumer than sends this data to some subscribers on another consumer. I'm new to websockets and i had a little concern: the consumer is receiving a lot of data, in the order of 100 (or more) JSON records per second. At what point should i be worried about this service crashing or running into performance issues? Is there some sort of limit for what i'm doing? -
Django rest framework, access the requested object in an extra action
I have a custom extra action that relies on the object requested by the user. Meaning that, if this the view's URL: 127.0.0.1:8000/myapp/ I want in my extra action to get the object in the get request. meaning, if this is the request: 127.0.0.1:8000/myapp/myobj then, the queryset in my extra action would be something like this: @action(detail=True) def get_location_details(): name = self.request.GET.get("name") data = Mission.objects.get(MissionName=f'{name}') But a code like this raises: object matching query does not exist. and if I print the name variable it's None -
Inherent and filter data from Django model
How to inherent and filter data from the base model in Django for example: my base model goes like this: class Customers(models.Model): Time_Registered = models.DateField(blank=False) Number = models.CharField(max_length=500) Name = models.CharField(max_length=250) Locations = models.ForeignKey(Locations, on_delete=models.CASCADE) what I want to do is create another models contains customer information related to one location such as : Class Canada(Customers): class Meta: proxy = True # filter by Canada' -
Failing to send variable with pure javascript to POST request
I am trying to pass two variable (dragged_id and replaced_id) in POST request via javascript to a view but when I print the request from the view (in django), I get an empty dictionary. What am I doing wrong? the JS: function swapHabits(dragged_id, replaced_id) { var request = new XMLHttpRequest(); var url = "/swap/" request.open("POST", url, true); var cookies = parse_cookies(); request.setRequestHeader('X-CSRFToken', cookies['csrftoken']); request.send(JSON.stringify({'dragged_id': dragged_id, 'replaced_id': replaced_id})); } I am using the library SortableJS to drag and drop rows of a table. The function swapHabits is triggered on drop of the row (onEnd): var originalList; var sortable = Sortable.create(selection, { handle: '.bars-move', animation: 150, onStart: function (evt) { originalList = [...document.querySelectorAll("#selection > tr")].map(el => el.id); }, onEnd: function(evt) { var dragged_id = evt.item.id; var replaced_id = originalList[evt.newIndex]; swapHabits(dragged_id, replaced_id); }, }); -
Django never closes connection to Aurora Serverless
Django never closes connections to Aurora Serverless database, it always shows 4 connections (4 asgi workers) Even if docs say Persistent connections avoid the overhead of re-establishing a connection to the database in each request. They’re controlled by the CONN_MAX_AGE parameter which defines the maximum lifetime of a connection. It can be set independently for each database. The default value is 0, preserving the historical behavior of closing the database connection at the end of each request Any ideas what could be the case there? -
Django ForeignKey value does not have corresponding value
I'm working on the Django section of CS50 around the 30min mark on the video with the modes 'ForeignKey' section. When i run the make migration i get the error. You are trying to add a non-nullable field 'agent' to product without a default; we can't do that (the database needs something to populate existing rows). Please select a fix: 1) Provide a one-off default now (will be set on all existing rows with a null value for this column) 2) Quit, and let me add a default in models.py Select an option: 2 if I set the default as a string value i get the error saying it was expecting an id. If i set it as 1 then i get the following. The row in table 'clutter_product' with primary key '1' has an invalid foreign key: clutter_product.agent_id contains a value '1' that does not have a corresponding value in clutter_supplier.id. class Supplier(models.Model): company = models.CharField(max_length=64) contact = models.CharField(max_length=64) email = models.CharField(max_length=128, blank = True) def __str__(self): return f"{self.id} {self.company} {self.contact} {self.email}" class Product(models.Model): name = models.CharField(max_length=64) sku = models.CharField(max_length=64, blank = True) unit_cost = models.IntegerField() rrp = models.IntegerField() average_fee = models.IntegerField() shipping_fee = models.IntegerField() agent = models.ForeignKey(Supplier, default=1, … -
Pythonanywhere - Django - No module named 'api.urls'
I uploaded my django project to pythonanywhere. But, I got some errors. No module named 'api.urls' in project/urls.py project/urls.py from django.contrib import admin from django.conf.urls import include, url from rest_framework.urlpatterns import format_suffix_patterns urlpatterns = [ url(r'^admin/', admin.site.urls), url(r'^api/', include('user.urls')), url(r'^api/', include('api.urls')), ] urlpatterns = format_suffix_patterns(urlpatterns) Only error at api.urls. But user.urls not. I can not understand why? My project structure: . |---project |---api |----urls.py |---user |----urls.py |---project |----settings.py |----urls.py pythonanywhere_com_wsgi.py # +++++++++++ DJANGO +++++++++++ # To use your own django app use code like this: import os import sys path = '/home/setname/example/project' if path not in sys.path: sys.path.append(path) os.environ['DJANGO_SETTINGS_MODULE'] = 'project.settings' # then: from django.core.wsgi import get_wsgi_application application = get_wsgi_application() Thanks. -
I want to navigate to the details of a product but it displays <QuerySet [<Product: Tshirt>]> and does not show any information Django ORM Python
When i click on the provided link it must show the products related to the particular shop but i get an error Unsupported lookup 'product_name' for CharField or join on the field not permitted. Please suggest on this product_name is the foreign key for ProductDetails and shop is the foreign key for Products this is the template <strong><a href="{{partone}}">{{tut.product_description}}</a></strong> Views.py # first check to see if the url is in categories. categories = [c.shop_slug for c in Shop.objects.all()] if single_slug in categories: matching_series = Product.objects.filter(shop_name__shop_slug=single_slug) series_urls = {} for m in matching_series.all(): part_one = Product.objects.filter(product_name=m.product_name) series_urls[m] = part_one return render(request=request, template_name='products/shop_products.html', context={"product_name": matching_series, "part_ones": series_urls}) product_details = [t.test_something for t in ProductDetails.objects.all()] if single_slug in product_details: this_product = ProductDetails.objects.get(test_something = single_slug) return render(request, 'products/product_details.html',{"product":this_product}) return HttpResponse(f"{single_slug} does not correspond") from django.db import models # Create your models here. # For shop in the beginning # class ShopType(models.Model): # shop_type = models.CharField(max_length=50) # shop_type_description = models.TextField() # def __str__(self): # return self.shop_type class Shop(models.Model): shop_name = models.CharField(max_length=50) shop_location = models.CharField(max_length=100) shop_opening_time = models.CharField(max_length=10) shop_slug = models.CharField(max_length = 20) # shop_type = models.ForeignKey( # ShopType, default=1, on_delete=models.SET_DEFAULT) shop_image = models.ImageField(upload_to='products', null=True, blank=True) shop_owner = models.CharField(max_length=100) shop_description = models.TextField() shop_added_date = models.DateTimeField(auto_now=True) def … -
Django: Get a confirmation when a model is saved to db
I have a model called Project. On updating this model object, I want to show the corresponding "success" or "failed" message. Somthing like the following: (this doesnt work since save returns an object not boolen). Do you know how to know if an object is actually saved ? views.py if (project.save()): messages.success(request, 'Project was deleted') else: messages.warning(request, 'Your request could not be processed. Please try again.') -
OpenEdx - AuthMissingParameter at /complete/edx-oidc/
I have installed docker devstack version of openedx ironwood.master release. When I click 'View My Records' button in profile page I got an error: AuthMissingParameter at /complete/edx-oidc/ Missing needed parameter state Request Method: GET Request URL: http://localhost:18150/complete/edx-oidc/ Django Version: 1.11.29 Exception Type: AuthMissingParameter Exception Value: Missing needed parameter state Exception Location: /edx/app/credentials/venvs/credentials/lib/python3.5/site-packages/social_core/backends/oauth.py in validate_state, line 88 Python Executable: /edx/app/credentials/venvs/credentials/bin/python Python Version: 3.5.2 Python Path: ['/edx/app/credentials/credentials', '/edx/app/credentials/venvs/credentials/lib/python35.zip', '/edx/app/credentials/venvs/credentials/lib/python3.5', '/edx/app/credentials/venvs/credentials/lib/python3.5/plat-x86_64-linux-gnu', '/edx/app/credentials/venvs/credentials/lib/python3.5/lib-dynload', '/usr/lib/python3.5', '/usr/lib/python3.5/plat-x86_64-linux-gnu', '/edx/app/credentials/venvs/credentials/lib/python3.5/site-packages', '/edx/app/credentials/credentials'] Server time: Sun, 12 Apr 2020 06:44:47 +0000 Please help me. Thanks. -
Why are class variables used in model classes?
I am learning django and reading other's code, as below: class Review(models.Model): RATING_CHOICES = ((1, '1'),(2, '2'),(3, '3'),(4, '4'), (5, '5'),) wine = models.ForeignKey(Wine, on_delete=models.CASCADE) pub_date = models.DateTimeField('date published') user_name = models.CharField(max_length=100) comment = models.CharField(default="no comment", max_length=200) rating = models.IntegerField(choices=RATING_CHOICES) Why are all these variables not defined in init as instance variables? They don't make sense as class variables. Right? -
Load Three JS model with gltf loader in Django
I am trying to load a Three JS model in a Django(3.0.3) app on a local environment. Template: <script> var address_to_model ="{% static 'models/matilda/scene.gltf' %}"; // Pass this variable to .js file </script> <script src="{% static 'js/matilda.js' %}"></script> matilda.js: var loader = new THREE.GLTFLoader( ); loader.load( address_to_model, function ( gltf ) { scene.add( gltf.scene ); }, undefined, function ( error ) { console.error( error ); } ); renderer.outputEncoding = THREE.sRGBEncoding; The page loads without any Django error and it shows the ThreeJS window which is working but the model is not loaded and in the Chrome error console, I get this error: GET http://127.0.0.1:8000/matilda/models/matilda/scene.gltf 404 (Not Found) I think it should not check this URL because I do not resolve it in urls.py and there is nothing in this address. It should load the model which is collected in the 'static/models/matilada' with collectstatic command. I check these links but they do not help: * Django {% static 'path' %} in javascript file * Correctly accessing django static files from external javascript * Django: External JS using framework doesn't load * https://pypi.org/project/django-js-urls/ -
Unsupported lookup 'product_name' for CharField or join on the field not permitted. Django Python ORM
When i click on the provided link it must show the products related to the particular shop but i get an error Unsupported lookup 'product_name' for CharField or join on the field not permitted. Please suggest on this product_name is the foreign key for ProductDetails and shop is the foreign key for Products this is the template <a href="{{shop.shop_slug}}"><strong>{{shop.shop_location}}</strong></a> This is views.py # first check to see if the url is in categories. categories = [c.shop_slug for c in Shop.objects.all()] if single_slug in categories: matching_series = Product.objects.filter(shop_name__shop_slug=single_slug) series_urls = {} for m in matching_series.all(): part_one = Product.objects.filter(product_name__product_name=m.product_name) series_urls[m] = part_one return render(request=request, template_name='products/shop_products.html', context={"product_name": matching_series, "part_ones": series_urls}) products = [t.product_slug for t in Product.objects.all()] if single_slug in products: return HttpResponse(f"{single_slug} is a product") return HttpResponse(f"{single_slug} does not correspond") This is Models.py from django.db import models # Create your models here. # For shop in the beginning # class ShopType(models.Model): # shop_type = models.CharField(max_length=50) # shop_type_description = models.TextField() # def __str__(self): # return self.shop_type class Shop(models.Model): shop_name = models.CharField(max_length=50) shop_location = models.CharField(max_length=100) shop_opening_time = models.CharField(max_length=10) shop_slug = models.CharField(max_length = 20) # shop_type = models.ForeignKey( # ShopType, default=1, on_delete=models.SET_DEFAULT) shop_image = models.ImageField(upload_to='products', null=True, blank=True) shop_owner = models.CharField(max_length=100) shop_description = models.TextField() shop_added_date = … -
How to Fill Form with Data in DJango without Update
New to Django here. I have a link to a form in DJango. I use the CreateView to have the user enter the initial information. It all works great and the data is accurately saved to the database. My issue is this: I would like that same link to open the form (it's a one-to-one relationship) with the filled data so the user can see what they have previously entered and correct, edit or update as needed. The form currfently opens as a blank form so if the user has entered that information previously they are unable to see it. I cave researched get_or_create and update_or_create as well as a number of other topics, but can't seem to figure this out. This needs to be a user-friendly experience so multiple entires or clicking multiple buttons to access the data is not an option. How best can I implement this? -
Serializer Relations Doesn't Work in Django Rest Framework
I have two models in my application. Here is my code in models.py: from django.db import models class TblDivision(models.Model): strdivisionname = models.CharField(db_column='strDivisionName', max_length=35, blank=True, null=True) # Field name made lowercase. class Meta: db_table = 'Tbl_Division' class TblPosition(models.Model): strpositionname = models.CharField(db_column='strPositionName', max_length=30, blank=True, null=True) # Field name made lowercase. class Meta: db_table = 'Tbl_Position' class TblEmployee(models.Model): strname = models.CharField(db_column='strName', max_length=70, blank=True, null=True) # Field name made lowercase. stremployeeid = models.CharField(db_column='strEmployeeID', max_length=10, blank=True, null=True) # Field name made lowercase. bitactive = models.BooleanField(db_column='bitActive', blank=True, null=True) # Field name made lowercase. intdivision = models.ForeignKey(TblDivision, db_column='intDivision',related_name='division', on_delete=models.CASCADE) intposition = models.ForeignKey(TblPosition, db_column='intPosition',related_name='position', on_delete=models.CASCADE) class Meta: db_table = 'Tbl_Employee' This is my code in serializer.py: from rest_framework import serializers from .models import TblEmployee,TblDivision class DivisionSerializer(serializers.ModelSerializer): class Meta: model = TblDivision fields=['id','strDivisionName'] class EmployeeSerializer(serializers.ModelSerializer): division = DivisionSerializer(many=True, read_only=True) class Meta: model = TblEmployee fields=['id','strname','stremployeeid','intdivision','division'] And this my views.py: from .models import TblEmployee from .serializer import EmployeeSerializer,DivisionSerializer from rest_framework import status from rest_framework.response import Response from rest_framework.decorators import api_view @api_view(["GET", ]) def api_list_employee_view(request): try: employee_list = TblEmployee.objects.all() except TblEmployee.DoesNotExist: return Response(status=status.HTTP_404_NOT_FOUND) if request.method == "GET": serializer = EmployeeSerializer(employee_list, many="true") dataEmployee = serializer.data return Response(dataEmployee) I want to create a simple API that shows data from Employee model and its … -
Access cookies path in django
I am working on a django project where I can track the user from the cookies and the path of the website they are visiting. My question is that when I set the cookie, I have given a path attribute so that the cookie is valid for that path only. SO how can I access the path set in the cookie. Additionally if someone have any other ideas to implement this system then I'm open for suggestions. Thank you in advance. -
Django: unresolved import 'markdown'
Vscode raised a problem from this line: import markdown with unresolved import 'markdown'Python(unresolved-import) This is my env: Django 3.0.5 Markdown 3.2.1 Here I tried to integrate markdown into my blog app by creating a custom template filter. After most works done, the markdown wasn't taken into effect. I have checked the rest of my codes and they are pretty safe. The problem should lie in how to import markdown I think? Any ideas? -
Django REST Framework Error 500 when receive '&' (And Symbol)
I have been confusing with this bug, I give & symbol in json raw body and return Server Error 500. And then I removed it so it works very well. Is this code bug or Django bug ? The REST Server is not my own so I cannot show you the code. -
How to run a function in the background after my django website starts?
I have written an algorithm. And when I use python manage.py runserver, my website will run on the local server. Now I want to run my algorithm after python manage.py runserver. In other words, when I start the django website, I hope the algorithm will run in the background until it is completed. And I want to know if the algorithm is still running or the algorithm is complete. What should I do? Thanks. -
I'm writing a stock exchange for an online game. How do I ensure orders are executed in isolation, using Django and Postgres?
I'm writing an online game using Django, and I'm planning to use Postgres as the database engine. One of the features of the game is going to be a simulated stock exchange and commodity market. If User A says "I want to buy an apple for $50" and User B says "I want to sell an apple for $50", then those two orders should be matched with each other, causing User B to sell an apple to User A. However, I'm not sure how to ensure that order executions are isolated from each other and don't introduce inconsistencies. I haven't written any real code for this feature yet, but let's assume that the model classes look like this: class Account(models.Model): number_of_dollars = models.BigIntegerField(validators=[MinValueValidator(0)], default=0) number_of_apples = models.BigIntegerField(validators=[MinValueValidator(0)], default=0) class AppleOrder(models.Model): account = models.ForeignKey(Account, on_delete=models.CASCADE) price = models.IntegerField(validators=[MinValueValidator(0)], default=0) direction = models.IntegerField(choices=[(1, 'buy'), (2, 'sell')]) status = models.IntegerField(choices=[(1, 'open'), (2, 'canceled'), (3, 'filled')]) Certain web requests may result in the game searching for orders that match each other, and executing them. But how can I make sure that orders are executed correctly? Naively, I would want to do it like this: def execute_orders(buy_order, sell_order, price) # We assume that "buy_order" and …