Django community: RSS
This page, updated regularly, aggregates Django Q&A from the Django community.
-
django-mptt sort order not as expected - and can't apply filtering
I am using Django 3.2 and django-mptt 0.13.4 I have the following objects: class Comment(models.Model): parent = TreeForeignKey('self', on_delete=models.CASCADE, null=True, blank=True, related_name='children') created_at = models.DateTimeField(auto_now=True) # ... other fields and methods class MPTTMeta: order_insertion_by = ['created_at'] class Meta: permissions = [('perm_1', 'Permission 1'), ('perm2', 'Permission 2'),] class Commentable(models.Model): comments = GenericRelation(Comment) # ... other fields and methods class Meta: abstract = True class Foo(Commentable): class Meta: abstract = False In my view code, I access the comments as follows: class FooDetailView(DetailView): def get_context_data(self, **kwargs): context = super(FooDetailView, self).get_context_data(**kwargs) foo = self.get_object() context['comments'] = foo.comments.all() # I want to use a Models Manager instead # ... In my template (I am not using the mptt templatetags - for reasons too long to go into here), I do something like this: {% for comment in comments %} {% render_comment comment %} <!-- my own templatetag that renders as I wish --> {% endfor %} However, the comments are displayed with the earliest comment first - why?! I tried the following - and the sorting remained unchanged: Added ordering attribute of `['-created_at'] to Comment::Meta Chained method order_by('-created_at') to the all() method invocation in FooDetailView::get_context_data() My questions are: How can I get the comments … -
Application error and json.decoder.JSONDecodeError after django on heroku
I have created one django website which helps user to download instagram videos , profile pic etc. Here's the hosted LINK. On my local device this website works completely fine but after hosting it on heroku it displayed the home page but after clicking eg: get the user profile pic button it gives this error and sometime this : This is requirements.txt Django==3.2.5 requests==2.25.1 gunicorn==20.1.0 django-heroku==0.3.1 This is the python function to get that profile pic from insta from django.shortcuts import render import requests # get the profile pic function def Get_Profile_Pic(request): if request.method == "POST": header = { "User-Agent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/96.0.4664.45 Safari/537.36" } # get message USER_NAME = request.POST['msg'] USERNAME = USER_NAME.replace("@", "") PROFILE_USERNAME = link + USERNAME + TAIL # validation # if fields empty if not PROFILE_USERNAME or link not in PROFILE_USERNAME: Error = "Invalid Link!" return render(request, 'home.html', {"profile_Error": Error}) # output else: try: resp = f"https://www.instagram.com/{USERNAME}/?__a=1" response = requests.get(resp, headers=header) responsex = response.json() PROFILE_IMG = responsex["graphql"]["user"]["profile_pic_url_hd"] return render(request, 'home.html', {"profile_result": PROFILE_IMG}) except ValueError or KeyError and Exception as e: Error = f"Invalid Link! {e}" return render(request, 'home.html', {"profile_Error": Error}) else: return render(request, 'home.html') Procfile web: gunicorn … -
nested ModelSerializer inside Serializer: Expected a dictionary, but got int
Getting "Invalid data. Expected a dictionary, but got int." on model serializer. How to serializer model inside custom serializers.Serializer class UserAddressSerializer(serializers.ModelSerializer): class Meta: fields = "__all__" model = UserAddress class OrderDetailSerializer(serializers.Serializer): address_id = UserAddressSerializer() total_cost = serializers.FloatField() ... class ServiceOrderDetailSerializer(serializers.Serializer): service_name = serializers.CharField(max_length=100) ... class PlaceOrderSerializer(serializers.Serializer): order_detail = OrderDetailSerializer() service_order = ServiceOrderDetailSerializer(many=True) view.py: serializer = PlaceOrderSerializer(data=request.data) Request: { "order_detail": { "address_id": 5, "total_cost": 432, "user_id": 2 }, "service_order": [ { "service_name": "1212ser345", ... ... Above code gives Bad Request: { "data": { "order_detail": { "address_id": { "non_field_errors": [ "Invalid data. Expected a dictionary, but got int." ] } } } } -
LIKE button in a Django project
There is a view in the Django project (a paginated blog) that is responsible for how likes work. It has one drawback: when a user likes a post, it is redirected to the main page of the site. How can I fix this so that the user would remain on the page where they liked. views.py class AddLikeView(View): def post(self, request, *args, **kwargs): blog_post_id = int(request.POST.get('blog_post_id')) user_id = int(request.POST.get('user_id')) url_from = request.POST.get('url_from') user_inst = User.objects.get(id=user_id) blog_post_inst = News.objects.get(id=blog_post_id) try: blog_like_inst = BlogLikes.objects.get(blog_post=blog_post_inst, liked_by=user_inst) except Exception as e: blog_like = BlogLikes(blog_post=blog_post_inst, liked_by=user_inst, like=True) blog_like.save() return redirect(url_from) template.py -
Django remove all default migration
Is there a way to remove all default django migration? My app doesn't use any of the default migration so I think it's a good idea to remove all unused migration -
Django abstract models: how to use a parent method in a child class?
Abstract base classes are useful to put some common information into a number of other models. Now, I would like to build methods in my abstract base classes that I could call from every child class. Something like that, for instance: # models.py from django.db import models class Person(models.Model): first_name = models.CharField(max_length=50) last_name = models.CharField(max_length=50) @property def full_name(self): "Returns the person's full name." return '%s %s' % (self.first_name, self.last_name) class Meta: abstract = True class Student(Person): school = models.CharField(max_length=50) class Employee(Person): work = models.CharField(max_length=50) # any HTML template rendered by a view returning a *Student* instance to the template engine {{ student_instance.full_name }} # any HTML template rendered by a view returning a *Employee* instance to the template engine {{ employee_instance.full_name }} This, however, does not work. Why? Note that moving the method full_name into the Student and into the Employee would fix the problem. However, following the DRY principle, I would like to find a better solution. What could I do? -
Django elastic beanstalk CLI deployment failure after adding .env files to gitignore
I'm new to Django/EB/Git and been working on a django project and have successfully separated my setttings and separated .env files for both development and production which all works as expected and deployed- see the following project structure: Project Structure project root myapp settings __init__ base.py dev.py prod.py .env.dev .env.prod .gitignore manage.py requiremnts.txt However the moment I add my my .env files to the .gitignore file I now received the following error with deployment within eb logs (cfn-init-cmd.log): .gitignore # Elastic Beanstalk Files .elasticbeanstalk/* !.elasticbeanstalk/*.cfg.yml !.elasticbeanstalk/*.global.yml .env.dev .env.prod Error: eb logs (cfn-init-cmd.log) FileNotFoundError: [Errno 2] No such file or directory: '.env.prod' If i remove .env.prod from the .gitignore file then my project deploys successfully. Moreoever, I read online that might be due to me git adding and comitting the .env.prod file to the repo however believe I have also excluded git add/commit when I started fresh and re-created the git repo with the following command (commands run on local project): git add --all -- :!.env.dev :!.env.prod git commit -m "Initial commit" Followed by: eb deploy myproject-env See my .ebextensions config file as follows: .ebextensions/django.config option_settings: aws:elasticbeanstalk:container:python: WSGIPath: myproject.wsgi:application aws:elasticbeanstalk:application:environment: DJANGO_SETTINGS_MODULE: "myproject.settings.prod" aws:elasticbeanstalk:environment:proxy:staticfiles: "/static": "static/" packages: yum: python3-devel: [] mariadb-devel: [] … -
How to extract payload from a jwt Expired Token
I have made a view where I send a Refresh Token to email for activation account purpose. If token is valid everything works fine. The problem is when jwt token expire, I want to be able in backend to extract payload (user_id) from token when jwt.decode throw ExpiredSignatureError and in this way be able to auto resend an Email based on user_id extracted from token. Here is how i generate the token def activation_link(request, user, email): token = RefreshToken.for_user(user) curent_site = "localhost:3000" relative_link="/auth/confirm-email" link = 'http://' + curent_site + relative_link + "/" + str(token) html_message = render_to_string('users/email_templates/activate_account.html',{ 'activation_link': link, }) text_content = strip_tags(html_message) email_subject = 'Activate your account' from_email = 'notsure@yahoo.com' to_email = email @api_view(['POST']) def ConfirmEmailView(request): try: activation_token = request.data['activation_token'] payload = jwt.decode(activation_token,settings.SECRET_KEY, algorithms=['HS256']) user = User.objects.get(id = payload['user_id']) if user.is_confirmed: return Response('Already verified!', status=status.HTTP_200_OK) user.is_confirmed = True user.save() return Response(status=status.HTTP_202_ACCEPTED) except jwt.ExpiredSignatureError as identifier: // =>>> Here I want to decode activation_token and extract user_id return Response("Link- expired!", status=status.HTTP_403_FORBIDDEN) except Exception as e: print(e) return Response(status=status.HTTP_400_BAD_REQUEST) -
How can i add import export to a table and also order the columns in django
I want to add import export button and at the same time order the table columns class OrderEtudiant(admin.ModelAdmin): list_display = ('id_etudiant','nom_etudiant','prenom_etudiant','Telephone','Adresse','Filiere') search_fields = ('nom_etudiant',) class userdat(ImportExportModelAdmin): pass admin.site.register(Etudiant,userdat,OrderEtudiant) here is the problem i can't pass three parameters -
In-built template tags not recognized by django .tex template (with django-tex)
I'm using django-tex to compile pdf files from a django web app. When writing code in LaTeX there is frequent use of the sequences {{, {%, {# and some others which conflict with some of the template tags used in django to input context data or include logic into the template. There is a built-in tag called templatetag which can be used to input these characters with {% templatetag openvariable %}, {% templatetag openblock %} and {% templatetag opencomment %}, respectively. Also, code can be enclosed in {% verbatim %} {% endverbatim %} to ignore all template tags between the verbatim tag. However, when I try to use any of these tags in my template, I get the error ("Encountered unknown tag 'verbatim'.",). This error occurs for many of the in-built template tags like verbatim, templatetag, load, and most others. On the other hand, {{ context_variable }} and logical blocks like {% if %} {% endif %} do work perfectly. What could be the problem here? I have the following in settings for django-tex my settings.py file: LATEX_INTERPRETER = 'pdflatex' LATEX_GRAPHICSPATH = [str(os.path.join(BASE_DIR, '/songapp/templates/songapp/images')),] TEMPLATES = [ { 'BACKEND': 'django.template.backends.django.DjangoTemplates', 'DIRS': [], 'APP_DIRS': True, 'OPTIONS': { 'context_processors': [ 'django.template.context_processors.debug', 'django.template.context_processors.request', … -
when i use the create function using django rest framework it dosent create a new person
when i use the create function using django rest framework it dosent create a new person instead it shows an error 405 Method Not Allowed. I even tried creating new person using frontend it just dosent work. views.py @api_view(['POST']) def create_person(request): serializer = PersonSerializer(data=request.data) if serializer.is_valid(): serializer.save() return Response(serializer.data) create.js: const Create = () => { let history = useHistory(); let [person, setPerson] = useState({ name:"", about:"", email:"", image:"", }) let createPerson = () => { e.preventDefault() fetch(`/api/person-create/`, { method: "POST", headers: { "content-type": 'application/json' }, body: JSON.stringify(person) }) .then(setPerson({ name:"", about:"", email:"", image:"", })) } let handleChange = (e) => { setPerson({...person, [e.target.id]: e.target.value}); console.log(person) } useEffect(() => { console.log("correct", person); }, [person]); return ( <div class="container"> <div class="row justify-content-center"> <form onSubmit={(e) => createPerson(e)}> <div> <h2> <button onClick={() => history.push('/')} className="btn btn-primary mt-4"> &#10094; Back </button> </h2> <h2 className="mt-4 mb-4" style={{width: '600px'}}> New Person </h2> <div className="form-group" style={{width: '600px'}}> <label>Name</label> <input onChange={handleChange} className="form-control" id="name" placeholder="Enter Name" value={person.name} /> </div> <div className="form-group" style={{width: '600px'}}> <label for="exampleInputEmail1">About</label> <textarea style={{height: '250px'}} onChange={handleChange} className="form-control" id="about" placeholder="Tell us somthing about yourself" value={person.about} /> </div> <div className="form-group" style={{width: '600px'}}> <label>Email</label> <input onChange={handleChange} className="form-control" id="email" placeholder="Enter Email" value={person.email} /> </div> <div className="custom-file mt-3"> <input onChange={handleChange} type="file" … -
filtering random objects in django
How can i filter 12 random objects from a model in django . I tried to do this but It does not work and It just returned me 1 object. max = product.objects.aggregate(id = Max('id')) max_p = int(max['id']) l = [] for s in range(1 , 13): l.append(random.randint(1 , max_p)) for i in l: great_proposal = product.objects.filter(id=i) -
Can not transform function in class in Django
Sorry for my poor knowledge of classes in Django, I have written my first training project via functions and now can not get it how to transform some functions in Classes. I had this function which works: @login_required def topic(request, topic_slug): """Выводит одну тему и все её записи.""" topic = get_object_or_404(Topic, slug=topic_slug) Проверка того, что тема принадлежит текущему пользователю check_topic_owner(topic.owner, request) entries = topic.entry_set.order_by('-date_added') context = {'topic': topic, 'entries': entries} return render(request, 'learning_logs/topic.html', context) Now could not transform it in to Class for the same work. I have this: class ShowTopic(DetailView): model = Topic template_name = 'learning_logs/topic.html' context_object_name = 'topic' slug_url_kwarg = 'topic_slug' def get_queryset(self): return Topic.objects.filter(topic__slug=self.kwargs['topic_slug']) For logging required I know I should add the mixin later, but right now I have error: Cannot resolve keyword 'topic' into field. Choices are: date_added, entry, id, owner, owner_id, public, slug, text And could not understand how can I insert entries here? Could somebody give me advice please? Thanks in advance. -
django boolean field validation issue
it seems that django does not handle checkbox input well. In my application, use need to choose either proceed or reject, I use a form with a checkbox to do this, which user event is handled by javascript. forms.py class ActionForm(forms.Form): action = forms.BooleanField() class Meta: fields = ['action'] template <form id="action-form" style="display: none" method="POST"> {% csrf_token %} {{ form }} <button type="submit">submit</button> </form> <div id="action-bar"> <button id="reject" class="action-button" type="button">reject</button> <button id="proceed" class="action-button" type="button">proceed</button> </div> javascript const form = document.getElementById('action-form'); const checkbox = form.querySelector('input'); const reject = document.getElementById('reject'); const proceed = document.getElementById('proceed'); reject.addEventListener('click', ()=>{ checkbox.checked = false; form.submit(); }); proceed.addEventListener('click', ()=>{ checkbox.checked = true; form.submit(); }); views.py def ActionView(request, pk): if request.method == 'POST': form = forms.ActionForm(request.POST) if form.is_valid(): print(form.cleaned_data['action']) return HttpResponse('') else: print(form.errors) return HttpResponse('') else: form = forms.ActionForm() return render(request, 'template.html', { 'form': form, }) The result I got <ul class="errorlist"><li>action<ul class="errorlist"><li>This field is required.</li></ul></li></ul> What I have tried: add required=False to the BooleanField, the result sent was always False even if I click on proceed add initial=True to the BooleanField, the result sent was always what the initial is. add both, the result sent was always False I will be so grateful for your suggestion -
POSTGRESQL NULL to zero
guys I have a big database table am using Django to plot answers, anyway 1: I can change NULL to Zeros. 2: and if the fields contain any character other than numbers remove it 3: Any recommendations on heatmap plot documentation maybe? Thanks -
Easy date time picker in django
I am fairly new to django so bare with me. I'd like to have several datepickers in some of my pages. I have followed the guide in the following link for Fengyuan Chen’s Datepicker (last one): https://simpleisbetterthancomplex.com/tutorial/2019/01/03/how-to-use-date-picker-with-django.html If I create a standalone html page with the code provided, it's all great! I don't understand how to embed the date time picker in other pages though. All of my html pages extend a base. And I put in the base head all of the contents like so: base.html <head> /* some unrelated things*/ <!-- jQuery --> <script src="https://code.jquery.com/jquery-3.3.1.slim.min.js" integrity="sha384-q8i/X+965DzO0rT7abK41JStQIAqVgRVzpbzo5smXKp4YfRvH+8abtTE1Pi6jizo" crossorigin="anonymous"> </script> <!-- Fengyuan Chen's Datepicker --> <link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/datepicker/0.6.5/datepicker.min.css" integrity="sha256-b88RdwbRJEzRx95nCuuva+hO5ExvXXnpX+78h8DjyOE=" crossorigin="anonymous" /> <script src="https://cdnjs.cloudflare.com/ajax/libs/datepicker/0.6.5/datepicker.min.js" integrity="sha256-/7FLTdzP6CfC1VBAj/rsp3Rinuuu9leMRGd354hvk0k=" crossorigin="anonymous"></script> </head> Then, in the page that i need to have the picker in: {% extends 'main/base.html' %} <input id="datepicker"> {% block myBlock%} <script> $(function () { $("#datepicker").datepicker(); }); </script> {% endblock %} in my views def test1(response): return render(response, "main/test1.html", {}) I find frustrating the fact that many guides are for standalone pages and not so many describe embedding. Then again it might be that I am very new to this. Thank you for the help! -
Detail viewset for product in django rest framework
I need to get just one product object in my VeiwSet based on a given slug, I looked into the docs, but I can't find any solution to this problem. I need to get the slug from the url path aswell, but I don't know how to do it too. Obviously the code below doesn't work. product/serializers.py from rest_framework import serializers from .models import Product class ProductSerializer(serializers.ModelSerializer): image = serializers.ImageField(required=True) class Meta: model = Product fields = ("name", "description", "slug", "id", "price", "stock", "image", "category") product/views.py from django.http.response import JsonResponse from rest_framework import serializers, viewsets from rest_framework.response import Response from django.http import JsonResponse from .serializers import ProductSerializer from .models import Product class ProductViewSet(viewsets.ModelViewSet): queryset = Product.objects.all().order_by('name') serializer_class = ProductSerializer class ProductDetailViewSet(viewsets.ViewSet, slug): queryset = Product.objects.filter(slug=slug) serializer_class = ProductSerializer product/urls.py from rest_framework import routers, urlpatterns from django.urls import path, include from .views import ProductViewSet, ProductDetailiewSet router = routers.DefaultRouter() router.register(r'', ProductViewSet) urlpatterns = [ path('<str:slug>/',), path('', include(router.urls)) ] -
Django money - making a MoneyField in my model
So I've been trying to import A money field from django-money using this code from djmoney.models.fields import MoneyField but every time am getting the same error Import djmoney.models.fields" could not be resolved I added djmoney to installed apps in the settings file and I used pip install django-money as well but it's still giving me the same error django-money version: 2.1 django version: 3.2.7 -
Django create an object that has a reference to another object using serializers
I want to create an order that has multiple ads and each ad must have a reference to a display object. I did this kind of thing previously just by setting the object's id in the put method and it worked well. models.py class OrdersDj(models.Model): id = models.CharField(primary_key=True, max_length=32, default=generate_uuid) user_id = models.CharField(max_length=45, blank=True, null=True) class Meta: ordering = ["dateplaced"] class AdsDj(models.Model): id = models.CharField(primary_key=True, max_length=32, default=generate_uuid) order = models.ForeignKey(OrdersDj,on_delete=models.CASCADE, blank=False, null=True) display = models.ForeignKey(Displays, on_delete=models.CASCADE, blank=False, null=True) null=True) serializers.py class AdsSerializer(serializers.ModelSerializer): display = DisplaySerializer() class Meta: model = Ads fields = "__all__" class OrderSerializer(serializers.ModelSerializer): ads = AdsSerializer(source="adsdj_set", many=True) def create(self, validated_data): ads_data = validated_data.pop('adsdj_set') order = Orders.objects.create(**validated_data) for ad in ads_data: Ads.objects.create(order=order, **ad) return order class Meta: model = Orders fields = "__all__" the put method data { "user_id": "1", "ads": [ { "display_id": "10", // "display" : 10, // "display" : "10", } ] } Here in dependence of what I insert for display, it expects a dictionary and not any other types. { "ads": [ { "display": { "non_field_errors": [ "Invalid data. Expected a dictionary, but got str." ] } } ] } -
creation of a new script tag in shopify
I am sending the post request to https://mystore.myshopify.com/admin/api/2021-10/script_tags.json with the respective request body. request body params below:- { "script_tag": { "event": "onload", "src": "my_link_to_script", "display_scope": "order_status" } } however i am getting the successful creation response. But the tag is not get inserted into my store checkout page. I am inserting the image below where the tag should get inserted after the successful response. enter image description here -
want to get multiple values from dropdown after adding script tag in html page it stop working or using select and script tag togetherit stop working
This is my load clients function from where I pass value to clients.html page views.py def load_clients(request): CPA_id = request.GET.get('CPA_id') clients = CPA_Client.objects.filter(CPA_id=CPA_id) return render(request, 'crm/clients_dropdown_list_options.html', {"clients": clients}) # return JsonResponse(list(cities.values('id', 'name')), safe=False client.html <select id="ddselect" name="framework[]" multiple class="form-control"> <option value="----">------</option> {% for Client_of_CPA in clients %} <option value="{{ Client_of_CPA.pk }}">{{ Client_of_CPA.name }}</option> {% endfor %} </select> In this code i am getting my output but need to select multiple values from a dropdown thats why i want to add some functionality of bootstrap jquery due to which i need script tag. After adding script tag page stop working -
How to style crispy forms with bootstrap4 in django?
I'm trying to style upload form used from crispy forms. Can you give me simple solution, and not to get too crazy about css. This is how it looks now! This is upload_document.html {% extends "base.html" %} {% load static %} {% load crispy_forms_tags %} {% block content %} <h1>Upload</h1> <form method="post" enctype="multipart/form-data"> {% csrf_token %} {{ form }} <button type="submit" class="btn btn-primary">Upload</button> </form> {% endblock content %} models.py from django.db import models class UploadFile(models.Model): excel = models.FileField(upload_to="excel/", max_length=250) def __str__(self): return self.title forms.py from .models import UploadFile class GlForm(forms.ModelForm): class Meta: model = UploadFile fields = ('excel',) -
Reuse Django field definitions in other models
I'm having a few fields throughout different models. E.g. class A(models.Model): field_1 = models.CharField(max_length=5, blank=False) field_2 = models.CharField(max_length=100, blank=False) field_3 = models.CharField(max_length=200, blank=False) class B(models.Model): field_4 = models.CharField(max_length=5, blank=False) field_5 = models.CharField(max_length=100, blank=False) field_6 = models.CharField(max_length=200, blank=False) In addition of these classes, I want to create a lead class. This class contains data that will be potentially copied into the other models in the future. The data constraints are therefore the same but since this is optional data, some might be missing. I want to use DRY, but I also want to update the blank field. Any tips on how to use the exact field definitions from those original classes? class Lead(models.Model): field_1 = A.field_1 # but with updated blank field field_3 = B.field_3 # but with updated blank field I considered class dependency, but in reality I'm using fields from 5 classes which I fear will become an unreadable mess if the lead class depends on these. -
Django wagitail backend oracle migrate ORA-00907: missing right parenthesis
Django 3.2.9 Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production cx_Oracle 8.3.0 Python 3.7.6 I create a new project Wagtail and i change in setting.py Database section DATABASES = { # 'default': { # 'ENGINE': 'django.db.backends.sqlite3', # 'NAME': os.path.join(BASE_DIR, 'db.sqlite3'), # } 'default': { 'ENGINE': 'django.db.backends.oracle', 'NAME': '(DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = XXX)(PORT = 1526)) (CONNECT_DATA = (SERVER = DEDICATED) (SID = XXXX)))', 'USER': 'ZZZZZZ', 'PASSWORD': 'ZZZZZZZ', 'HOST': '', 'PORT': '', } } when execute python manage.py migrate show this error: WARNINGS: wagtailcore.WorkflowState: (models.W036) Oracle does not support unique constraints with conditions. HINT: A constraint won't be created. Silence this warning if you don't care about it. Operations to perform: Apply all migrations: admin, auth, contenttypes, home, sessions, taggit, wagtailadmin, wagtailcore, wagtaildocs, wagtailembeds, wagtailforms, wagtailimages, wagtailredirects, wagtailsearch, wagtailusers Running migrations: Applying wagtailcore.0059_apply_collection_ordering...Traceback (most recent call last): File "C:\Users\A262556\Documents\PROGETTI\prj-intranet-new\cms-prova\venv\lib\site-packages\django\db\backends\utils.py", line 84, in _execute return self.cursor.execute(sql, params) File "C:\Users\A262556\Documents\PROGETTI\prj-intranet-new\cms-prova\venv\lib\site-packages\django\db\backends\oracle\base.py", line 523, in execute return self.cursor.execute(query, self._param_generator(params)) cx_Oracle.DatabaseError: ORA-00907: missing right parenthesis The above exception was the direct cause of the following exception: Traceback (most recent call last): File "manage.py", line 10, in <module> execute_from_command_line(sys.argv) File "C:\Users\A262556\Documents\PROGETTI\prj-intranet-new\cms-prova\venv\lib\site-packages\django\core\management\__init__.py", line 419, in execute_from_command_line utility.execute() File "C:\Users\A262556\Documents\PROGETTI\prj-intranet-new\cms-prova\venv\lib\site-packages\django\core\management\__init__.py", line 413, in execute … -
Is there a way to allow blank data for Django restframework
I have a products model that I want to have optional fields that are not required by the user whenever i try to input empty data it throws an error 400 back to the user meaning the serialized data is not valid views.py def products(request): if request.method == 'GET': products = Product.objects.filter(user=request.user) serializer = ProductSerializer(products, many=True) return Response(serializer.data) elif request.method == 'POST': serializer = ProductSerializer(data=request.data) serializer.initial_data['user'] = request.user.pk 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) serializer.py class ProductSerializer(serializers.ModelSerializer): class Meta: model = Product fields = '__all__' models.py class Product(models.Model): name = models.CharField(max_length=50) description = models.TextField(blank=True) price = models.FloatField() quantity = models.IntegerField(blank=True) user = models.ForeignKey(settings.AUTH_USER_MODEL, on_delete=models.CASCADE) shop = models.ForeignKey(Shop, on_delete=models.DO_NOTHING) discount = models.FloatField(default=0)
