Django community: Django Q&A RSS
This page, updated regularly, aggregates Django Q&A from the Django community.
-
How can I get User at Validate in Serializer?
In my view(CreateView) I overriding my method def create, but in my validate I cant get logged user by self.context.get('request').user, so, how can I get the user logged in my validate? -
How to upload image and createview
I don't understand how to add this image object on view. please help me. models from django.db import models from django.utils import timezone from django.contrib.auth.models import User from django.urls import reverse class Post(models.Model): title = models.CharField(max_length=100) content = models.TextField() image = models.ImageField(default='post.jpg', upload_to='image') date_posted = models.DateTimeField(default=timezone.now) author = models.ForeignKey(User, on_delete=models.CASCADE) def __str__(self): return self.title def save(self, *args, **kwargs): super().save() def get_absolute_url(self): return reverse('post-detail', kwargs={'pk': self.pk}) what i do for the image field is valid. I want to be able to upload an image file using CreateView and a LoginRequiredMixin but I can't get it working - it seems the form doesn't bind any file data after choosing a file. Here's the current content of the view views class PostCreateView(LoginRequiredMixin, CreateView): model = Post fields = ['title', 'content','image'] def form_valid(self, form): form.instance.author = self.request.user return super().form_valid(form) any think i do jast show the default photo. home.html {% extends "blog/base.html" %} {% block content %} {% for post in posts %} <article class="media content-section"> <img class="rounded-circle article-img" src="{{ post.author.profile.image.url }}"> <div class="media-body"> <div class="article-metadata"> <a class="mr-2" href="#">{{ post.author }}</a> <small class="text-muted">{{ post.date_posted|date:"F d, Y" }} </small> </div> <h2><a class="article-title" href="{% url 'post-detail' post.id %}"> {{ post.title }}</a></h2> <p class="article-content">{{ post.content }}</p> <img ... -
django rest framework nested objects JSON format
I'm facing a little problem right now with Django Rest Framework. I'm trying to post an object with nested objects in it. models.py class Car(models.Model): licence_plate = models.CharField(max_length=12, unique=True) vin = models.CharField(max_length=17, unique=True) car_brand = models.CharField(max_length=100, unique=True) class Place(models.Model): place_name = models.CharField(max_length=50) latitude = models.CharField(max_length=50) longitude = models.CharField(max_length=50) class Ride(models.Model): places = models.ManyToManyField(Place, through='RideStop') car = models.ForeignKey(Car, on_delete=models.CASCADE) date = models.DateTimeField(auto_now_add=True, blank=True) class RideStop(models.Model): place = models.ForeignKey(Place, on_delete=models.CASCADE, null=True) ride = models.ForeignKey(Ride, on_delete=models.CASCADE, null=True) dir = JSONField(null=True) serializers.py class RideSerializer(serializers.ModelSerializer): places = RideStopSerializer(many=True) car_id = CarSerializer() class Meta: model = Ride fields = '__all__' def create(self, validated_data): ride_stops = validated_data.pop('places') ride = Ride.objects.create(**validated_data) ride_stops_objects = [] for ride_stop in ride_stops: ride_stop_object = RideStop() ride_stop_object.ride_id = ride ride_stop_object.place_id = ride_stop['place_id'] ride_stop_object.ride = ride_stop['dir'] ride_stop_object.save() # RideStop.objects.bulk_create(ride_stops) return ride views.py class ListCreateRide(generics.ListCreateAPIView): queryset = models.Ride.objects.all() serializer_class = serializers.RideSerializer and I would like to post a JSON format like this: { "date":"21-14-17", "car":3, "ride_stops":[ { "place":4, "dir":"{ \"ahoj\":\"nazdar\"}" } ] }' Can anyone help me out please? -
Programmatically creating and uploading images in django
I'm using this method to create an image programmatically, def create_thumbnail(filename, letters, color): img = Image.new('RGB', (200, 200), color=color) d = ImageDraw.Draw(img) font = ImageFont.truetype("sans-serif.ttf", 48) d.text((0, 0), letters, (255, 255, 255), font=font) img.save("{}.png".format(filename)) This is my object creation logic, room, created = Room.objects.get_or_create(name=name, logo="", sport=sport,status=RoomStatus.ACTIVE,defaults={'team': team,'city': city,}) I've an override in the model to save the image to the correct folder. def image_upload_path(instance, filename): pattern = re.compile(r'\s+') filename = re.sub(pattern, '', filename) return 'images/rooms/logo/_{0}/{1}'.format(instance.id, filename) This works fine when handling a post request with the image data. My question is how do I create the image and upload it the correct folder using my image creation function. Any help appreciated. -
How to create an object for a model from the console similar to how Django made the createsuperuser command
I'm trying to create an object from the console but not sure how to set that up. This is my modelManager: class MajorManager(models.Manager): def __str__(self): return self.name def createMajor(self, name): try: name = name.lower() major = self.create(name=name) except IntegrityError: print("This major has already been created") And here is the model: class Majors(models.Model): name = models.CharField(max_length=30, unique=True) objects = MajorManager() Any help would be much appreciated. -
How to find out that external database is updated in Djangov (while manage=False)
I have a project that is connected to an external database and just have view access to it. So I created my models with managed=False flag. I was wondering how can I find out in django that any change in that database is happened. Is there any solution in django or I should find a method to communicate between that database and my django app. like socket, database triggers and ...? More details: Image my models is like this: class Alert(models.Model): key = models.CharField(max_length=20) class Meta: managed = False Now i want to be notified in django each time the database is updated. I want a signal to capture database updates and do something in django? -
Django: upload 4 files with same name-body and different extensions
I have 4 files (file1.ref, file1.bmp, file1.dat, file1.kfg). How to select only one file (".ref") and upload all four using Modelforms? views.py def results_import(request): if request.method == 'POST': form = ResultsForm(request.POST, request.FILES) if form.is_valid(): form.save() specimen = form.cleaned_data['specimen'] messages.success(request, f'Data for {specimen} is saved .') return render(request, 'ultra/results_import.html', {'form': form}) else: form = ResultsForm() return render(request, 'ultra/results_import.html', {'form': form}) forms.py class ResultsForm(ModelForm): class Meta: model = Results fields = ['specimen', 'pruefparameter', 'ref_file'] model.py class Results(models.Model): specimen = models.ForeignKey(Specimen, on_delete=models.CASCADE) pruefparameter = models.ForeignKey(Pruefparameter, on_delete=models.CASCADE) ref_file = models.FileField(upload_to='Echograph/', null=True, blank=True, default=None) bmp_file = models.FileField(upload_to='Echograph/', null=True, blank=True, default=None) dat_file = models.FileField(upload_to='Echograph/', null=True, blank=True, default=None) kfg_file = models.FileField(upload_to='Echograph/', null=True, blank=True, default=None) def __str__(self): return str(self.specimen) results_import.html {% extends "blog/base.html" %} {% load crispy_forms_tags %} {% load static %} {% block content %} <h2>Import Results</h2> <form method="POST" enctype="multipart/form-data" > {% csrf_token %} {{ form|crispy}} <button type="submit">Submit</button> </form> <p><a href="{url 'home' %}">Return to home</a></p> {% endblock content %} -
Adding emotion detection to my django website
I want to add emotion detection to my django website . I googled and found that i need to make an API and Json will help to send response to my site but I am still confused with it. How can I link my emotion detection code with my website? I am new to this so please help me out like how I go further. -
Django model DateField format in modelformset_factory
I'm trying to make a modelform_factory for my model named Book but the DateField is behaving strangely. class Book(models.Model): name = models.CharField(max_length = 50) date = models.DateField(max_length = 50) I have a function in my views that returns this: modelform = modelformset_factory(Book, fields = ( 'name', 'date', ), can_delete=True, widgets = { 'date': forms.DateInput(format='%d/%m/%Y'), }) In my template this modelform will render with a datepicker: $('.datepicker').datepicker({ format: 'dd/mm/yyyy' }); So far so good, and everything is working as expected to this point. But when I post my form to my view again, and save the modelformset, the dd/mm/yyyy date is wrongly converted to yyyy-mm-dd. if request.method == 'POST': formset = modelform(request.POST, request.FILES, queryset=Book.objects.filter(name=book)) if formset.is_valid(): formset.save() # This first deletes all instances that are checked for deletion f = formset.save(commit=False) # This filters the formset to only include filled in forms for form in f: form.save() return HttpResponse("success") Does someone has any clue how I can format this dd/mm/yyyy date to correctly enter my database? -
Why does Django CKeditor create an AWS s3 url that expires after 1hr?
I'm using Django Zinnia with CKeditor as the blog wysiwyg editor. I can upload images and connect to AWS S3 bucket perfectly. When I attach the picture to the blog post, it appears but expires and disappears from the post after 1hr. Why is that? I'm using: zinnia-wysiwyg-ckeditor==1.3 Django==2.1.2 django-s3-storage==0.12.4 boto3==1.9.54 botocore==1.12.54 Settings for Django s3 Storage AWS_QUERYSTRING_AUTH = False # Amazon S3 DEFAULT_FILE_STORAGE = 'django_s3_storage.storage.S3Storage' # The AWS region to connect to. AWS_REGION = "eu-west-3" # The AWS access key to use. AWS_ACCESS_KEY_ID = os.environ['AWS_ACCESS_KEY_ID'] # The AWS secret access key to use. AWS_SECRET_ACCESS_KEY = os.environ['AWS_SECRET_ACCESS_KEY'] # The optional AWS session token to use. # AWS_SESSION_TOKEN = "" # The name of the bucket to store files in. AWS_S3_BUCKET_NAME = os.environ['AWS_S3_BUCKET_NAME'] # How to construct S3 URLs ("auto", "path", "virtual"). AWS_S3_ADDRESSING_STYLE = "auto" # The full URL to the S3 endpoint. Leave blank to use the default region URL. AWS_S3_ENDPOINT_URL = "" # A prefix to be applied to every stored file. This will be joined to every filename using the "/" separator. AWS_S3_KEY_PREFIX = "" # Whether to enable authentication for stored files. If True, then generated URLs will include an authentication # token valid for `AWS_S3_MAX_AGE_SECONDS`. If ... -
Django form wizard - how to prevent field values from resetting?
I am using Django form wizard to fill a multistep form, its taking in the inputs and saving to the database and all but the problem is when ever i am navigating through the steps using "previous" i am see the clear fields with no data in it. i just want the data to be displayed there for reference when i go back. here are my forms.py `class AppEditForm(forms.Form): #App Name applicationfullname = forms.CharField(label='Application Full Name: ', max_length=80, required = False) #Full Name applicationabbreviatedname = forms.CharField(label='Application Abbreviated Name: ', max_length=40, required = False) class AppEditForm1(forms.Form): #Business Sponser businesssponsoredwpersonid = forms.CharField(widget= autocomplete.Select2(url='WorkerDim_ac', attrs={'data-placeholder': 'Search values', 'data-width': '25em'}), required = False, label="Business Sponsor Name: ") #Application Owner applicationowneredwpersonid = forms.CharField(widget= autocomplete.Select2(url='WorkerDim_ac', attrs={'data-placeholder': 'Search values', 'data-width': '25em'}), required = False, label='Application Owner Name: ') #Business Owner businessowneredwpersonid = forms.CharField(widget= autocomplete.Select2(url='WorkerDim_ac', attrs={'data-placeholder': 'Search values', 'data-width': '25em'}), required = False, label='Business Owner Name: ') ` here is my html <!DOCTYPE html> {% extends "newapp/base.html" %} {% load i18n static %} {% load staticfiles %} {% load crispy_forms_tags %} {% block title %}Addapplication{% endblock title %} {% block head %} {{ wizard.form.media }} <link rel="stylesheet" href="{% static 'css/addapplication.css' %}"> <script type='text/javascript'>function formProcess(){ var capture = document.forms['input']['id_1applicationfullname'].value ... -
How to tie mysql database in one container to another container running my django blog app (with docker-compose)
I have created a blog app with django and attached it to a mysql database stored on my local machine(localhost), which I manage through phpmyadmin. However, I switched to an ubuntu 18.04 LTS (previously on a windows machine) and wanted to deploy my app with docker containers. I want to run mysql database in one container, and my blog app in another container, and have them communicate with each other (I am using docker-compose to achieve this). Below is the DATABASES dictionary on my app: And here is docker-compose.yml file. After firing the docker-compose up command, I get this error: It says '(2006, "Authentication plugin 'caching_sha2_password' cannot be loaded: dlopen(/usr/local/mysql/lib/plugin/caching_sha2_password.so: cannot open shared object file: No such file or diectory")'. -
how to get id from Url in python django last v?
I want to get the id from url in Django for a python programming language but I face the problem page no found. I want the code for this in the last version in Django because I have it please help me -
DJango - Generic ModelAdmin definition
This is a newbie question. I have multiple models that I would like to show in admin view. I would like to show all model's fields when viewing a list of records for a model. I'd like to define a generic ModelAdmin subclass which will be able to list out all fields for a model. But not sure how to pass the class objects to it. admin.py looks like this class ModelFieldsAdmin(admin.ModelAdmin): def __init__(self, classObj): self.classObj = classObj self.list_display = [field.name for field in classObj._meta.get_fields()] admin.site.register(Candy, ModelFieldsAdmin) admin.site.register(Bagel, ModelFieldsAdmin) How can I pass the classObj (which would be one of the models Candy or Bagel) , and also ensure that the get_list_display() picks up the value from self.list_display ? -
Django - how to disable Referer check
I have put a Django-based web project (Cloudera Hue: https://github.com/cloudera/hue) behind nginx used for load balancing and SSL offloading. Getting stuck on 403 error with CSRF error. Log file contains 5:32:32 PM WARNING access 10.170.3.21 -anon- - "POST /accounts/login/ HTTP/1.1" -- Referer checking failed - https://hue-dev.discover.abc.com/hue/accounts/login/?next=/ does not match https://hue-dev.discover.abc.com:443/. Is there is a way to disable Referer check in a Django project? Referer check doesn't add any security as Referer in http header can be easily spoofed. https://security.stackexchange.com/questions/66165/does-referrer-header-checking-offer-any-real-world-security-improvement I already have following in nginx.conf proxy_set_header Host $host; proxy_set_header X-Real-IP $remote_addr; proxy_set_header X-Forwarded-For $proxy_add_x_forwarded_for; proxy_set_header X-Forwarded-Proto $scheme; proxy_set_header X-Forwarded-Host $host:$server_port; proxy_set_header X-Forwarded-Server $host; and also tried following changes regarding Referer http attribute: proxy_pass_header Referer proxy_hide_header Referer proxy_set_header $http_referer all of these options produce the same CSRF/Referer check error in Django/Hue backend. Again, for me it would be just easier to disable Referer check in Django. If it's not possible, then the issue is probably in Django code here: https://github.com/django/django/blob/22e8ab02863819093832de9f771bf40a62a6bd4a/django/middleware/csrf.py#L280 referer variable there is a urlparse object (see https://docs.python.org/3/library/urllib.parse.html ) which contains "netloc" property with a port. Notice the error again - netlocs don't match because one has a port (443) and another doesn't have it (443 port is default for ... -
Query orm Django para obter a quantidade de um filtro
O que eu tenho, essa query no orm django retorna a quantidade de id numa sala views.py sala = Post.objects.all()\ .values('sala')\ .annotate(value_pk=Count('pk')) Eu tenho saida: "sala 25=30" models.py class Post(models.Model): nome = models.CharField(max_length=150) sala = models.CharField(max_length=20) confirm = models.BooleanField( default=False ) O que eu preciso que me retorne o valor de "confirm" de acordo com a sala O que preciso saida: "sala 25=30 confirm=17" -
Ajax post getting 403 forbidden error with Django Rest Framework
There are loads of similar questions but each seems to deal with the problem under different scenarios, or the perscribed solution doesn't seem to resolve my issue. Basically, Why am I getting this 403 Forbidden Error? POST http://127.0.0.1:8000/api/hello-viewset/ 403 (Forbidden) The url is a Django Rest Framework (DRF) endpoint that I can access from the browser and make POSTs using the DRF gui just fine. The trouble is when I try to POST using Ajax from my javascript file. Note, that I am passing the CSRFToken (as advised here): $.ajax({ type: "POST", url: '/api/hello-viewset/', csrfmiddlewaretoken: window.CSRF_TOKEN, // yes, this variable is set successfully data: {first_name: username}, success: function(data){ console.log( 'success, server says '+data); } }); The /api/hello-viewset/ url is just a simplified test view that looks like this: class HelloViewSet(viewsets.ViewSet): serializer_class = serializers.HelloSerializer def post(self, request): serializer = serializers.HelloSerializer(data=request.data) if serializer.is_valid(): first_name = serializer.data.get('first_name') message = 'Hello {0}'.format(first_name) return Response({'message': message}) else: return Response(serializer.errors, status=status.HTTP_400_BAD_REQUEST) Thanks in advance for your help? -
Competent download in db
There are models of the following type: class Parameter (models.Model): id_parameter = models.IntegerField(primary_key=True) par_rollennr = models.IntegerField(default=0) par_definition_id = models.IntegerField(default=0) #not FK par_name = models.CharField(max_length=200) class Measurements (models.Model): id_measurement = models.AutoField(primary_key=True) par_value = models.IntegerField(default=0) line = models.ForeignKey(Line, on_delete=models.CASCADE, null=True) order = models.ForeignKey(Order, on_delete=models.CASCADE, null=True) recipe = models.ForeignKey(Recipe, on_delete=models.CASCADE, null=True) parameter = models.ForeignKey(Parameter, on_delete=models.CASCADE, null=True) I'm trying to write to the database so: def handle_parameters_upload(request, file): wb = openpyxl.load_workbook(file, read_only=True) first_sheet = wb.get_sheet_names()[0] ws = wb.get_sheet_by_name(first_sheet) recipe, created = Recipe.objects.get_or_create(par_recipe=ws["B2"].value) line, created = Line.objects.get_or_create(par_machine=ws["C2"].value) order, created = Order.objects.get_or_create(par_fa=ws["D2"].value) data = [] data_par = [] _id = 1 for row in ws.iter_rows(row_offset=1): parameter = Parameter() parameter.id_parameter = _id _id += 1 parameter.par_rollennr = row[5].value parameter.par_definition_id = row[6].value parameter.par_name = row[7].value data_par.append(parameter) measurements = Measurements() measurements.par_value = row[8].value measurements.line = line measurements.order = order measurements.parameter = parameter measurements.recipe = recipe data.append(measurements) # Bulk create data Measurements.objects.all().delete() Parameter.objects.all().delete() Parameter.objects.bulk_create(data_par) Measurements.objects.bulk_create(data) return True How can I avoid duplication of entries in the Parameter, and the correct assignment of ids for measurements? If the parameters is a record of the following form: 106 45300 Name 107 45300 Name1 106 45300 Name 108 45301 Name3 -
Django query min date
How i can write query in Django like: There is a table Tickets with such fields: creation_date, client_id, id. And every client can have several rows with tickets I need to find the number (count) of secondary clients, that is, those clients whose tickets_creation date is more than the minimum tickets_creation date for a specific client. To find minimum i write something like: ck = Ticket.objects.filter(active=False).exclude(status_id=4).values('client'). \ annotate(min_date=Min('createdon')).filter(min_date__date__range=('2018-12-01', '2018-12-06')) -
How to insert records to a Postgres database(table) using Python object oriented programming
I have this table (made in Django) class Prefixe(models.Model): remote_as = models.CharField(max_length=250) prefix_list = models.CharField(max_length=250, null=True) def __init__(self, remote_as, prefix_list): self.remot_as = remote_as self.prefix_list = prefix_list how can I add some some records to this table: def insert(): p = Prefixe('Apress', 'Berkeley') p.save() -
Unable to access Askbot homepage on port 8080 after installation on CentOS 7
I have installed Askbot on my CentOS 7 VM using steps available online. For instance, https://www.howtoforge.com/tutorial/how-to-install-and-configure-askbot-with-nginx-on-centos-7/ After askbot-setup, when running final manage.py commands, python manage.py syncdb python manage.py runserver 0.0.0.0:8080 I see following warnings: (test) [askbot@testserver qanda]$ python manage.py syncdb WARNING!!! You are using a 'locmem' (local memory) caching backend, which is OK for a low volume site running on a single-process server. For a multi-process configuration it is neccessary to have a production cache system, such as redis or memcached. With local memory caching and multi-process setup you might intermittently see outdated content on your site. System check identified some issues: WARNINGS: django_authopenid.UserPasswordQueue.user: (fields.W342) Setting unique=True on a ForeignKey has the same effect as using a OneToOneField. HINT: ForeignKey(unique=True) is usually better served by a OneToOneField. group_messaging.SenderList.recipient: (fields.W342) Setting unique=True on a ForeignKey has the same effect as using a OneToOneField. HINT: ForeignKey(unique=True) is usually better served by a OneToOneField. Operations " runserver output: (test) [askbot@testserver qanda]$ python manage.py runserver 0.0.0.0:8080 WARNING!!! You are using a 'locmem' (local memory) caching backend, which is OK for a low volume site running on a single-process server. For a multi-process configuration it is neccessary to have a production cache system, such as ... -
Using django ORM from non django python script
Here is the scenario. I have Django project and python script project under a directory. The python script needs to runs independently on a scheduled time and also needs to access Database used by Django. Is it possible to use/import existing Django code in python script to access db. If so how? The idea comes for C# app where Models and data access layer can be built as library and can be used in many projects. -
Proper way to change language on website?
I'm doing a website and would like to include language change. What is the proper way to handle this ? Just copy html's, rename and translate them and change links ? Or is there a better way ? I'm using django. -
Django 1.11 dict as input to .create?
Django 1.11 I have working code something = MyModel.objects.create( a=1,b=2 ) where a and b are the fields. I would like to change it to: mydict = {'a' : 1, 'b' : 2} something = MyModel.objects.create(mydict) I tried something = MyModel.objects.create(**mydict) and something = MyModel(**mydict) Both give this error: Exception Value: 'str' object has no attribute '__name__' I realise I can write some code to do it item by item, just curious if there is a direct way to do that, seems to be something useful.. Thanks! -
How to deploy Django/React/Webpack app on Digital Ocean through Passenger/Nginx
I'm trying to deploy a web app built with Django/Redux/React/Webpack on a Digital Ocean droplet. I'm using Phusion Passenger and Nginx on the deployment server. I used create-react-app to build a Django app which has a frontend that uses React/Redux, and a backend api that uses django-rest-framework. I built the frontend using npm run build. The Django app is configured to look in the frontend/build folder for its files and everything works as expected, including authentication. It's based on this tutorial: http://v1k45.com/blog/modern-django-part-1-setting-up-django-and-react/ On my development machine, I activate a Python 3.6 virtual environment and run ./manage.py runserver, and the app is displayed at localhost:3000. On the deployment server, I've cloned the files into a folder in var/www/ and built the frontend. I've set up Passenger according to the docs with a file passenger_wsgi.py: import myapp.wsgi application = myapp.wsgi.application And the wsgi.py file is in the djangoapp folder below: import os from django.core.wsgi import get_wsgi_application os.environ.setdefault('DJANGO_SETTINGS_MODULE', 'myapp.settings') application = get_wsgi_application() I think this is working correctly because Passenger and Nginx are running without error and the app's index.html page is being served up at the server's IP address. However, none of the app's content is being filled in. The web page ...
