Django community: RSS
This page, updated regularly, aggregates Django Q&A from the Django community.
-
cannot find images in react response
I am trying to return multiple images in django to react. But I am unable to retrieve the images in react. My httpresponse is dictionary in this format: {id1:[image1,image2], id2:[image1,image2} but I am getting only integers as a response in react. django code: images = {} for id in post_ids: img_obj = PostImage.objects.filter(post_id=id) imgs = [img_obj[0].image.file] try: x = img_obj[0].other_image1.file imgs.append(x) except ValueError: pass try: x = img_obj[0].other_image2.file imgs.append(x) except ValueError: pass try: x = img_obj[0].other_image2.file print('type', type(x)) imgs.append(x) except ValueError: pass images[id] = imgs return HttpResponse(images) react code: const submit = () =>{ const token = localStorage.getItem('access'); axios.post(url, { token: token, }).then(res => { if (res.status===200){ console.log(res.data); }else{ alert('error'); } }) } output in cosole 234567 -
Exception in thread django-main-thread unable to run server
[Exception in thread django-main-thread:][1] [Exception in thread django-main-thread:][2] [1]: https://i.stack.imgur.com/b4KFS.png [2]: https://i.stack.imgur.com/w6ko3.png -
Django - How to add "or" condition to queryset.filter in custom filter
i want to make a search filter which searches in multiple fields with multiple conditions, using only one search field. I have this filters.py file: import django_filters from .models import Product class ProductFilter(django_filters.FilterSet): q = django_filters.CharFilter(method='search_filter', label='Cerca') class Meta: model = Product fields = ['q'] def search_filter(self, queryset, name, value): return queryset.filter(name__icontains=value, sku__iexact=value) but return queryset.filter(name__icontains=value, sku__iexact=value) doesn't work, neither return queryset.filter(Product(name__icontains=value) | Product(sku__iexact=value)) How can i do this? -
Django query in list view to group similar category records
I have my website which displays the records on website these records are of different categories how can group the records belongs to similar category and display them together category 1 List item 1 List item 2 List item 3 class Mymixin: def get_queryset(self): return Record.objects.all() class Model: category = models.Charfield() -
Django Exception Type: ProgrammingError Exception Value: no existe la función sum(character varying)
I got an error when i use postgresql total = DetalleFacturas.objects.filter(IdFactura__Fecha__range=[fechainicio, fechafinal], IdFactura__IdBodega__Vendedor__Email=request.user.email).aggregate( Sum('Total')) And i have got this error: ProgrammingError at /reportehelisa/ no existe la función sum(character varying) LINE 1: SELECT SUM("DetalleFacturas"."Total") AS "sum" FROM "Detalle... It's work fine in sqlite but postresql not work -
How to override get_queryset() whilst using UpdateView Django
I have inherited UpdateView and I am trying to override the get_queryset() method, but it keeps throwing an error: raise ImproperlyConfigured( django.core.exceptions.ImproperlyConfigured: UserProfileManagement is missing a QuerySet. Define UserProfileManagement.model, UserProfileManagement.queryset, or override UserProfileManagement.get_queryset(). models.py class User(AbstractBaseUser, PermissionsMixin): email = models.EmailField(unique=True) first_name = models.CharField(max_length=50, blank=False, null=False) last_name = models.CharField(max_length=50, blank=False, null=False) start_date = models.DateTimeField(default=timezone.now) is_staff = models.BooleanField(default=False) is_active = models.BooleanField(default=False) USERNAME_FIELD = 'email' REQUIRED_FIELDS = ['first_name', 'last_name'] objects = CustomUserManager() def save(self, *args, **kwargs): self.first_name = self.first_name.capitalize() self.last_name = self.last_name.capitalize() return super(User, self).save(*args, **kwargs) def __str__(self): return self.email managers.py class CustomUserManager(BaseUserManager): def create_user(self, email, first_name, last_name, password, **extra_fields): if not email: raise ValueError(_('The Email must be set')) email = self.normalize_email(email) user = self.model(email=email, first_name=first_name, last_name=last_name, **extra_fields) user.set_password(password) user.save() return user views.py class UserProfileManagement(UpdateView): Model = User template_name = 'users/user_profile.html' fields = ['first_name', 'last_name'] def get_queryset(self): queryset = super(UserProfileManagement, self).get_queryset() return queryset.filter(pk=3) However, if I override the get_object() instead it works. def get_object(self, queryset=None): return User.objects.get(pk=3) -
how do I render shipping address_one object associated with a specific order
So the customer has an order page where I want to render their order details, specifically product name, date ordered, status, and their delivery location, right now I got everything to work except the delivery location("address_one"). I would really appreciate it if someone can help, thx! models.py class Order(models.Model): customer = models.ForeignKey(Customer, on_delete=models.SET_NULL, blank=True, null=True) class OrderItem(models.Model): product = models.ForeignKey(Product, on_delete=models.SET_NULL, blank=True, null=True) order = models.ForeignKey(Order, on_delete=models.SET_NULL, blank=True, null=True) class Product(models.Model): name = models.CharField(max_length=150) description = models.TextField() class ShippingAddress(models.Model): customer = models.ForeignKey(Customer, on_delete=models.SET_NULL, blank=True, null=True) order = models.ForeignKey(Order, on_delete=models.SET_NULL, blank=True, null=True) address_one = models.CharField(max_length=200) views.py @login_required def orders(request): orderitems = OrderItem.objects.filter(order__customer__user=request.user) #how do I get the shipping address associated with order shipping = ShippingAddress.objects.filter() context = {"orderitems": orderitems, "shipping": shipping} HTML {% for orderitem in orderitems %} <div class="order-data-view"> <div class="order">{{ orderitem.product.name }}</div> <div class="date">{{ orderitem.date_added }}</div> <div class="status">dummydata</div> <div class="delivering-to">{{ shipping.address_one }}</div> </div> {% endfor %} -
Is there a way to make a mock timezone for a Selenium test in Django?
In my selenium test below I'm trying to test my Analytics model. I'm using a mock of an Analytics model instance from class AnalyticsFactory. When I run this test everything works fine except I get an error for the timestamp field in the Analytics model. Note: I'm using timezone.now() for this. It seems like the time from when I run the test and when the time is assigned to the Analytics factory is slightly different. For example this is the error I'm getting: AssertionError: datetime.datetime(2022, 4, 8, 13, 3, 28, 153988, tzinfo=<UTC>) != datetime.datetime(2022, 4, 8, 13, 3, 28, 48016, tzinfo=<UTC>) in the error above 153988 and 48016 are different Is there a way I could set a 'fake' timezone object instead of using timezone.now()? Since it seems like 'now' is so precise that I can't get this to work. test_models.py: from django.utils import timezone from django.test import TestCase from myapp.tests.factories import UserFactory, AnalyticsFactory from myapp.models import Analytics class MyTestCase(TestCase): def setUp(self): self.admin = UserFactory( username='first.last@gmail.com', email='first.last@gmail.com', password=12345 ) self.a1 = AnalyticsFactory( user=self.admin, timestamp=timezone.now(), views=10 ) def test_analytics(self): a = Analytics.objects.get(id=6) self.assertEqual(a.views, 10) self.assertEqual(a.user, self.admin) self.assertEqual(a.timestamp, self.a1.timestamp) <--- not working self.assertEqual(response.status_code, 200) factories.py: import factory from myapp.models import Analytics from … -
Creating a root comments and comments with ancestors from the same view
I'm creating comments system like in twitter. Everything works fine with displaying the tweet, its ancestors and descendants. The main problem is I want to create root tweets and tweets with ancestors from the same url (e.g 'compose/tweet/). At the moment my code for this task is working. I have hidden input in my form with parent id value attr if user wants to create an answer on tweet. Attr is empty if root tweet will be created. <form action="{% url 'tweets:make_tweet' %}" method="post" novalidate> {% csrf_token %} {% render_field tweet_form.parent value=id %} <div class="tweet-form-textarea mb-2" id="tweet-form-textarea{{ id }}"> {% render_field tweet_form.text class="form-control fs-5" rows="3" placeholder=placeholder %} </div> <div class="tweet-form-footer d-flex flex-row align-items-center" id="tweet-form-foote{{ id }}"> <span class="chars-counter visually-hidden"></span> <input type="submit" class="make-tweet-btn fw-bold btn rounded-pill" value="Tweet"> <div> </form> Form renders with inclusion template tag: @register.inclusion_tag('tweets/tweet_form_snippet.html', takes_context=True) def render_tweet_form(context, id=''): return { 'tweet_form': context['form'], 'id': id } And finally value attr is populating in template(simplified version): {% if not tweet %} {% render_tweet_form %} {% else %} {% render_tweet_form id=tweet.id %} {% endif %} The form is processed from class: class MakeTweetView(BaseCreateView): form_class = TweetForm def form_valid(self, form): tweet = form.save(commit=False) # Searching for value in hidden input parent = self.request.POST['parent'] … -
Failed to login already existing users in databse by username or email ?how to login by username, email or password with null token in django graphql?
I tried to log in to existing users or manually inserted users in the database, but I am not able to log in with those existing users who already exist in the database. On the other hand, when we register a new user through API and try to log in only that registered user who registered through APIs, it is working absolutely fine. the main problem is here that we have old existing users and those old users are not able to log in, so please help me regarding login those users who are not registered through APIs who are already existing in the database. -
Filtering DateTimeField by past and future django dates
My problem is that I make a timer until the next event on the site. I store the events in the django model. Making the date output in the template, I do not know how to make events output in turn. I managed to filter the past dates in the template, but I can't do an automatic event change when the previous event has passed. That is, there is 00.00.00 left before it. I am also unable to output the first already filtered element. Only {%if forloop.counter0 == 1%} works, but this outputs an element of the entire list, not an element of the filtered list. I was just trying to output the first event where the date is greater than the current one. I tried to use some internal loops after filtering, but I can't do it. I am addressing you with this problem because I have reached a big dead end. I would be very grateful for your help. There was an idea to filter the events immediately in views.py using filter, but I'm confused again. I'm still new to this business, but I would really like to finish this project. Template {% for x in date %} … -
Audio file is not passing through Ajax
I am trying to send data in form with audio file when ever I send data request this error in console pop up [enter image description here][1] [1]: https://i.stack.imgur.com/q5Hi2.png This is my form code <body> <h1>Audio</h1> <form id="form" method="POST"> {% csrf_token %}{{form.as_p}} <input type="text" id="first_name" placeholder="student Name"><br> <input type="text" id="Reg_No" placeholder="Registration No"><br> <input type="text" id="Health_status" placeholder="Health Status"><br> <input type="text" id="deparment" placeholder="Department"><br> <input type="submit" name="submit" value="submit"> <h1>{{message}}</h1> </form> <div id="output"> </div> <button id="startRecordingButton">Start recording</button> <button id="stopRecordingButton">Stop recording</button> <button id="playButton">Play</button> <button id="downloadButton">Download</button> <button id="SubmitButton">Submit</button> audio file is storing in blob variable blob = new Blob([view], { type: 'audio/wav' }); }); I am trying to send it through ajax in dataform submit.addEventListener("click", function (e) { e.preventDefault(); let formData = new FormData(); var recording = blob; formData.append("recording", recording); formData.append("first_name", first_name); formData.append("deparment", deparment); formData.append("Reg_No", Reg_No); formData.append("Health_status", Health_status); $.ajaxSetup({ headers: { "X-CSRFToken": document.querySelector('[name=csrfmiddlewaretoken]').value, } }); $.ajax({ type: 'POST', url: "{% url 'HealthTest' %}", data: formData, dataType: "json", success: function (data) { // $('#output').html(data.msg) /* response message */ alert('created new user'); }, failure: function () { } }); }); here is my views.py function where i am actually storing data for audio file i just need to read audio and send it to pickle so i created … -
Can you iterate through model fields when you overwrite the save() method in django?
I'm calling a custom save method in my model. The save method is designed to produce some values in the model based on the content of a TextField. This content is stored in a dictionary, and is generated correctly. I'm trying to write a for loop to store the values of the dictionary. The keys correspond to the model field names: def save(self, *args, **kwargs): if self.text != "": results_dict = analyze(self.text) for field_name in field_names_list: self.field_name = results_dict[field_name] The value is not stored in the corresponding field. Do I need to use setattr here instead? -
Update a model field in save method based on other field values selected including m2m field
I am trying to update a model field by overriding save method: class DataTable(models.Model): id = models.AutoField(db_column='Id', primary_key=True) country= models.ForeignKey(Countries,on_delete=models.DO_NOTHING,db_column='CountryId') university=models.ManyToManyField(Universities,db_column='UniversityId',verbose_name='University',related_name='universities') intake = models.CharField(db_column='Intake',blank=True, null=True, max_length=20, verbose_name='Intake') year = models.CharField(max_length=5,blank=True,null=True) application_status = models.ForeignKey(Applicationstages,on_delete=models.DO_NOTHING, db_column='ApplicationStageId',verbose_name='Application Status') requested_count = models.PositiveIntegerField(db_column='RequestedCount',blank=True,null=True) class Meta: db_table = 'DataTable' def __str__(self): return str(self.application_status) def __unicode__(self): return str(self.application_status) def save(self,*args, **kwargs): super(DataTable,self).save(*args, **kwargs) country_id= self.country intake= self.intake year= self.year universities= self.university.all() courses = get_ack_courses(country_id,universities) all_data = get_all_courses(intake,year,courses) ack_data = get_acknowledgements_data(all_data) self.requested_count =len(ack_data) super(DataTable,self).save(*args, **kwargs) I am trying to update the requested_count field using the other field values, but in save method when I try to get the m2m field data ; it is returning empty. I tried with post_save signal also and there also m2m field data is empty. I want the count field based on otherfields from this model. How to save when we have m2m fields? -
django: Outputting CSV with JsonResponse
def export_csv(request,query): p = Path(os.path.dirname(__file__)) FILE_JUDGEMENT = str(p.parent)+"/static/pygiustizia" content = "" res = {} res["status"] = "ok" res["data"] = content response = JsonResponse(res, status=200) if os.path.exists(nameFile): response["Content-Description"] = "File Transfer" response["Content-Type"] = "application/octet-stream" response["Content-Disposition"] = 'attachment; filename="somefilename.csv"' response["Expires"] = 0 response["Cache-Control"] = "must-revalidate" response["Pragma"] = "public" writer = csv.writer(response,delimiter =';') writer.writerow(headerData.values()) totalRowData = 0 #fdata = toDict(fdata) #print("fdata",fdata) for keyRow,valueRow in fdata.items(): #print("valueRow",valueRow.values()) writer.writerow(valueRow.values()) totalRowData = totalRowData + 1 return response I have a controller-view in python django framework. My goal is output and download a csv created querying data from elastisearch. it create somefilename.csv but in header csv file I have {"status": "ok", "data": ""}sendername;controparte;nomegiudice;annosentenza;codiceufficio;fascicoloprecedente_annoruolo; Why? -
How to send a file with FTP in JavaScript?
I want when a user uploads a file, this file should be sent to the server with FTP without pressing a button or submitting a form. I try to do that but it is not working. Firstly, I created a function with time intervals, which checks whether the file input is empty or not. If it is not empty, it should send the file to the server. var file = "/uploads/" + {{ api_id }} this should be the address of the file on the server. How can I do that or where is my mistake? <input type="file" class="form-control-file" id="exampleFormControlFile1" name="bankStat1"> <script> setInterval(displayHello, 1000); function displayHello() { var is_File = false if (document.getElementById("exampleFormControlFile1").files.length >= 1){ is_File = true var file = "/uploads/" + {{ api_id }} var ftp = new FtpConnection("ftp://myftp/") ; ftp.login("myuser", "mypass"); ftp.cd("uploads") ftp.put(file,document.getElementById("exampleFormControlFile1").files[0]) ; ftp.close() ; file.close() ; } console.log(is_File) } </script> -
how Count field using django orm
Hi Everyone i trying to count active and inactive status sepratally, below mention code to count all, i need to count active and inactive status sepratally,pls help me out. Type.objects.all().aggregate(Count('status')) output=5 -
Azure App Services: multi-containers not starting
I had my Django web app running on Azure VM then decided to move to Azure App Services using a multi-container instances. However, celery seems to be breaking Following is my docker-compose configuration and error logs for Azure App Service services: application: image: expressway.azurecr.io/expressways_application:v1 ports: - 80:8000 depends_on: - queue working_dir: /data command: gunicorn config.wsgi:application 0.0.0.0:80 restart: unless-stopped queue: image: expressway.azurecr.io/redis:v1 restart: unless-stopped worker: image: expressway.azurecr.io/expressways_worker:v1 restart: unless-stopped depends_on: - queue - application command: bash -c /data/docker-worker-entrypoint.sh volumes: static-files: media-files: ${WEBAPP_STORAGE_HOME}/site/wwwroot:/var/www/html ${WEBAPP_STORAGE_HOME}/phpmyadmin:/var/www/phpmyadmin **However, the only thing that I see in my App Service logs is:** ` ``` 2022-04-08T11:47:32.913Z ERROR - multi-container unit was not started successfully 2022-04-08T11:47:32.929Z INFO - Container logs from testoms_application_0_cb8acd23 = 2022-04-08T11:47:24.232210483Z [2022-04-08 11:47:24 +0000] [1] [INFO] Starting gunicorn 19.9.0 2022-04-08T11:47:24.236012528Z [2022-04-08 11:47:24 +0000] [1] [INFO] Listening at: http://0.0.0.0:8000 (1) 2022-04-08T11:47:24.236677888Z [2022-04-08 11:47:24 +0000] [1] [INFO] Using worker: sync 2022-04-08T11:47:24.243640619Z [2022-04-08 11:47:24 +0000] [8] [INFO] Booting worker with pid: 8 2022-04-08T11:47:24.252172692Z [2022-04-08 11:47:24 +0000] [8] [ERROR] Exception in worker process 2022-04-08T11:47:24.252216296Z Traceback (most recent call last): 2022-04-08T11:47:24.252223297Z File "/usr/local/lib/python3.6/dist-packages/gunicorn/arbiter.py", line 583, in spawn_worker 2022-04-08T11:47:24.252228597Z worker.init_process() 2022-04-08T11:47:24.252232898Z File "/usr/local/lib/python3.6/dist-packages/gunicorn/workers/base.py", line 129, in init_process 2022-04-08T11:47:24.252237698Z self.load_wsgi() 2022-04-08T11:47:24.252241799Z File "/usr/local/lib/python3.6/dist-packages/gunicorn/workers/base.py", line 138, in load_wsgi 2022-04-08T11:47:24.252246299Z self.wsgi = self.app.wsgi() 2022-04-08T11:47:24.252250299Z File … -
how do I render 'address_one' object associated with a specific order
So the customer has an order page where I want to render their order details, specifically product name, date ordered, status, and their delivery location, right now I got everything to work except the delivery location("address_one"). I would really appreciate it if someone can help me out, thx! models.py class Order(models.Model): customer = models.ForeignKey(Customer, on_delete=models.SET_NULL, blank=True, null=True) class OrderItem(models.Model): product = models.ForeignKey(Product, on_delete=models.SET_NULL, blank=True, null=True) order = models.ForeignKey(Order, on_delete=models.SET_NULL, blank=True, null=True) class Product(models.Model): name = models.CharField(max_length=150) description = models.TextField() class ShippingAddress(models.Model): customer = models.ForeignKey(Customer, on_delete=models.SET_NULL, blank=True, null=True) order = models.ForeignKey(Order, on_delete=models.SET_NULL, blank=True, null=True) address_one = models.CharField(max_length=200) views.py @login_required def orders(request): orderitems = OrderItem.objects.filter(order__customer__user=request.user) #how do I get the shipping address associated with order shipping = ShippingAddress.objects.filter() context = {"orderitems": orderitems, "shipping": shipping} HTML {% for orderitem in orderitems %} <div class="order-data-view"> <div class="order">{{ orderitem.product.name }}</div> <div class="date">{{ orderitem.date_added }}</div> <div class="status">dummydata</div> <div class="delivering-to">{{ shipping.address_one }}</div> </div> {% endfor %} -
serving apk file in heroku server via django not working?
I want to serve apk file in website hosted on heroku, it is serving also but while installing it shows error "There was a problem while parsing the package". And also downloaded apk file working in local server -> Backend is Django {% load static %} <a href="{% static 'app/home.apk' %}" download=""></a> -
how to submit onchange form without refresh in django
here is the code where submit onchange <div class="form-group row"> <div class="col-sm-10 col-md-7"> <select {{ form|validation_class:"devamsizlik" }} id="devamsizlik" name="devamsizlik" onchange="this.form.submit();"> <option value="">Gelme durumu</option> <option value="True"> <span style="font-family: wingdings; font-size: 200%;">&#10004;</span> </option> <option value="False"> <span style="font-family: wingdings; font-size: 200%;">&#10060;</span> </option> </select> </div> </div> ı try some ajax code but none of them working on it , ı could not find anything about while submitting on change page not reload. -
How to change admin model in external app in Django?
I have installed the tell-me app that is gathering users' feedback. I want to edit list_display and list_filter in the admin panel but I am not sure how to access this model in the admin.py file. Any advice on how to do that will be appreciated. -
Django "Client class" integration into VS Code
I have had several issues integrating Django testing into VSCode. Finally I succeeded to run most kinds of tests (the trick, it seems, is to run django.setup() before anything else happens, including importing Django modules), but now I am having a problem with Django's client class. I do a simple client.get() and I get a 400 (Bad Request) error from within VSCode. But if I run "python manage.py test" from the CLI the test works! I am completely at a loss as to what is happening... Here is my code. It couldn't be simpler. import logging import django django.setup() from django.test import Client, TestCase # noqa: E402 from django.db import DatabaseError # noqa: E402 logger = logging.getLogger('XXXX.debugger') class WorkflowAPIClient(TestCase): def test_createWorkflow(self): client = Client() resp = client.get('/workflow/') logger.debug(f'After request: {resp.status_code} - {resp.content}') self.assertEqual(resp.status_code, 200) When I run this from the CLI as "python manage.py test" it runs OK (assertEqual succeeds). When I try to run this from the test module of VSCode, it gives a status_code of 400 and thus assertEqual fails. I am using unittest for the VSCode test configuration and it discovers the test files without any problem. -
UTF-8 encoding for xhtml2pdf in Django
I am using xhtml2pdf package to generate a pdf file from an html template in my django application. The pdf file generates correctly (no errors), however, I have encountered a problem with UTF-8 encoding. My generated pdf file, instead of special charactes (PL language), shows black squares. I have gone through almost all solutions available online, but none of them helped. When I am using ReportLab and generate pdf without a template, all seems to be okay. Am I missing something perhaps on the views side? My html template {% load static %} <!DOCTYPE html> <html lang="pl-PL"> <head> <meta charset="UTF-8"> <title>PDF {{obj.orderNumber}}</title> <style> @font-face { font-family: 'Lato'; src: url(https://github.com/google/fonts/blob/master/ofl/lato/Lato-Regular.ttf?raw=True); } * { font-family: 'Lato'; } table { -pdf-keep-with-next: true; } p { margin: 0; -pdf-keep-with-next: true; } p.separator { -pdf-keep-with-next: false; font-size: 6pt; } .bander{ color:brown; font-size:13pt; } </style> </head> <body> <img src="media/logo.jpg" style="height:60px;"> <h2> PLAN ROZKROJU ZLECENIA: </h2> <h1 style="color:#997207;">{{obj.orderNumber}} {{obj.orderName}}</h3> <h2> Naklad: {{obj.orderQuantity}} szt </h2> <h4> Data utworzenia wydruku: {{obj3}} </h4> <div> <table class="table table-bordered" style="text-align: center; padding: 5px;" border="0.2"> <thead class="table-active"> <tr> <th scope="col">Nazwa materialu</th> <th scope="col">Ilosc</th> <th scope="col">Nazwa czesci</th> <th scope="col">Wymiar (mm)</th> <th scope="col">Wymiar 2 (mm)</th> </tr> </thead> <tbody> {% for item in obj2 %} <tr> … -
Django - column of relation already exists - should I use --fake?
I have a Django app using PostgreSQL with tenant_schemas. My DB has been imported from a .sql file, and now I have to run the migrations (with some changes in it, differen than the original DB imported from the .sql). When I do that, I get: django.db.utils.ProgrammingError: column "active_vendor" of relation "analysis_supplier" already exists I've researched this problem, and it looks like some people (on stackoverflow) recommend using --fake for this situation. But according to django docs: --fake Marks the migrations up to the target one (following the rules above) as applied, but without actually running the SQL to change your database schema. This is intended for advanced users to manipulate the current migration state directly if they’re manually applying changes; be warned that using --fake runs the risk of putting the migration state table into a state where manual recovery will be needed to make migrations run correctly. As I understand, this means that the migration will only be added to the migration table of django, and the SQL code will not be ran. I don't think I want that. Am I misunderstanding it? If so, should I use --fake in my situation? If not, how should I fix …
