Django community: RSS
This page, updated regularly, aggregates Django Q&A from the Django community.
-
Django models equal one filed to another
i try to equal owner_id to id , i mean when user's id is 1 and create organization i want to owner_id also be 1 . what is best way? class Organization(models.Model): id = models.AutoField(primary_key=True) name = models.CharField(default='0000000',max_length=100) type = models.CharField(default='0000000',max_length=20) owner_id = models.CharField(id,max_length=100) def __str__(self): return str(self.name) this not working owner_id = models.CharField(id,max_length=100) -
start docker with database, but i don't see database results in api
start docker with database, but i don't see database results in api I attach an image of the console running docker-compose up attached image of the api and attached image of the db docker image api image db image -
Dajngo CSV FIle not download ? When we have a large CSV file download its takes some time?Django 502 bad gateway nginx error Django
How can I download a large CSV file that shows me a 502 bad gateway error? I get this solution I added in below. Actually, in this, we use streaming references. In this concept for example we download a movie it's will download in the browser and show status when complete this will give the option to show in a folder same as that CSV file download completely this will show us. -
view the count of items cycled in that single day django template
as you can see I have a calendar with the days and every day in which there is an action is marked, I would like that if the actions are more than 3 it is put a + instead of 4. the texts are repeated because these actions are not of a single day but have a start and end date. I need to figure out how to see the number of items for that day and I would need to do it inside the template. html code <div class="giorni"> {% for giorno in giorni %} {% if giorno == 0 %} <div></div> {% else %} <div class="single-day{% if giorno == giorno_odierno %} oggi{% elif giorno < giorno_odierno %} vecchio{% endif %}"> {{ giorno|date:"d" }} {% if integratori %} {% for dayone in integratori %} {% if giorno >= dayone.inizio and giorno <= dayone.fine %} <div class="integrazione"> <div> <img src="{% static 'img/integratori.svg' %}" class="img-fluid"> <h6 class="m-0">{{ dayone.integratore }}</h6> </div> </div> {% endif %} {% endfor %} {% endif %} </div> {% endif %} {% endfor %} </div> -
Django PostgreSQL Migration from SQLite - UnicodeDecodeError
I'm trying to migrate my db from default sqlite to postgresql. I was following this video: https://www.youtube.com/watch?v=ZgRkGfoy2nE&ab_channel=VeryAcademy I've installed postgresql, created new database downloaded my project db by using python manage.py dumpdata > datadump.json and set my setting.py like that DATABASES = { #'default': { # 'ENGINE': 'django.db.backends.sqlite3', # 'NAME': BASE_DIR / 'db.sqlite3', #} 'default': { 'ENGINE': 'django.db.backends.postgresql_psycopg2', 'NAME': 'mydbname', 'USER': 'postgres', 'PASSWORD': 'mypassword', 'HOST': 'localhost', 'PORT': '5432', } } then run python manage.py migrate --run-syncdb when I'm trying to run python manage.py loaddata datadump.json I'm getting UnicodeDecodeError: 'utf-8' codec can't decode byte 0xbf in position 2206: invalid start byte I tried to set my json file encoding to utf-8 by using notepad++ but it did't help. I'm out of ideas. What should i do ? -
How to schedule Django shell command every week?
I'm trying to let a certain Python script run every week in the Django shell. How can I accomplish this? I've read about cron & django-rq, but I don't think this is possible within the given parameters. Thanks in advance! PS.: the code in question, it just deletes the old database and adds the updated one: from formcheck.models import FormCheck import csv FormCheck.objects.all().delete() formcheck_csv = open('PolisCheck.csv', 'r', encoding = "utf-8") reader = csv.reader(formcheck_csv) headers = next(reader, None)[1:] for row in reader: polis_dict = {} for h, val in zip(headers, row[1:]): polis_dict[h] = val formcheck = FormCheck.objects.create(**polis_dict) formcheck_csv.close() exit() -
Dynamic Ordering of Multiple QuerySets
I'm fairly new to Django and I'm currently creating a webpage that receives some context information from the url to create a tabbed bootstrap navbar (e.g., tab-example). The part I'm struggling with is how to properly populate each tab-pane with dynamic content. Dynamic content being 3 different QuerySets (displayed as lists) dependent on the information in the tab header. So far I let the view function gather all QuerySets for every tab and handed them back via the context in render() as a list of 'query_dicts' like so: query_dict = { "header": header, "data": [query_direct_hit, query_vague, query_very_vague] } Now I would like to be able to independently sort the Querysets of each header (e.g. order query_direct_hit by title, query_vague by date and preserve meta ordering in query_very_vague). I can't think of a way to do this, other then providing the view with even more context information, which would blow up the url even further. This can't be the best way to do this, right? Right now the url and view header already look as follows: path('search-entry/<search_term>/<entry_id>/<score>', views.search_entry, name='search-entry') def search_entry(request, search_term, entry_id, score): # do stuff I already saw other posts use jquery.load() or ajax, in order to only update … -
how to query from parent model to child model
I want to get all the posts created today but instead of querying from post model I want to query from the Author model. I tried this but it didn't work Author.objects.filter(post__created__date=date.today()) class Author(models.Model): #parent model name = models.CharField(max_length=200) class Post(models.Model): #child model title= models.CharField(max_length=200) description = models.TextField() author= models.ForeignKey(Author,on_delete=models.CASCADE) created = DateTimeField(auto_created=True) -
React - Django connection: Data in Heroku app lost
I am using a Django app as a backend on Heroku and a React app as a frontend at my local machine. The apps are used for creating blog posts. They have worked quite well so far. I created several posts, and these posts were seen on the server and could be retrieved for frontend. However, when I came back from the night (sleeping), these posts were disappeared. I do not know how to solve that problem. Your suggestion and explanation would be highly appreciated. Thank you. -
HOW TO RUN A LOOP 2 DIFFERENT TABLES IN DJANGO TO HTML
I am working on a project where I have a table in my HTML that gets info from 2 different tables from my database and I need to run a loop for each one. What's the best solution? VIEWS MODELS HTML -
Why html buttons dynamically created by django cannot access my javascript function?
My Django application makes divs dynamically. Each div is a post of a blog post and also I have a like button on each div. Each button will automatically turn into unlike when a user clicks on it without reloading using javascript. I wrote a javascript function for this. Unfortunately, my javascript function works only the last post on a page (As I have pagination property). document.addEventListener("DOMContentLoaded",function(){ // const colon = document.createElement('div'); // colon.setAttribute('id','colon') // e.preventDefault() // const likebtn = document.createElement('button'); // likebtn.setAttribute('class','likebtn btn btn-primary'); // likebtn.setAttribute('class','likebtn'); // document.querySelector('.card-footer').appendChild(likebtn); // document.querySelector('.likebtn').innerHTML = "Like"; document.querySelector(`#likeform${posts_id}`).addEventListener('submit',(event) => { event.preventDefault(); like_function(); // return false; }) // document.querySelector('.likepost').addEventListener('click', ()=> like_function('likepost')); }) // let is_like = "{{is_like}}"; // let num_like = "{{num_like}}"; function like_function(){ // document.createElement('button').innerHTML = "Love"; // console.log("Updated!") fetch(`/like/${posts_id}`,{ method:"POST", body : JSON.stringify({ "is_like" : is_like, "num_like" : num_like, }) }) .then(response => response.json()) .then(result => { if(result.is_like){ console.log("function is liked"); console.log(`${result.is_like} for post ${posts_id}`); let num_like = result.num_like; console.log(`Number of posts : ${num_like}`); document.querySelector(`#likebtn${posts_id}`).innerHTML = "Unlike"; num_like = num_like + 1; console.log(`Number of posts : ${num_like}`); document.querySelector(`#num_of_likes_${posts_id}`).innerHTML = `${num_like} ` // location.replace("http://127.0.0.1:8000") } else{ console.log("function is unliked, back off!"); console.log(`${result.is_like} for post ${posts_id}`); let num_like = result.num_like; console.log(`Number of posts : ${num_like}`); … -
django pytest how to test a view with argument(id)
i have a question regarding using pytest. These are my very 1st tests. I have 2 views which i want to test (simplest possible way). Views: class MenuView(View): def get(self, request): return render(request, 'diet_app/menu.html') class CuisineDetailsView(View): def get(self, request, id): cuisine = Cuisine.objects.get(id=id) recipes = cuisine.recipe_set.all() return render(request, 'diet_app/cuisine_details.html', {'cuisine': cuisine, 'recipes': recipes}) Here are my tests: def test_menu(client): url = reverse('menu') response = client.get(url) assert response.status_code == 200 @pytest.mark.django_db def test_cuisine_details_view(client): url = reverse('cuisine-details') response = client.get(url) assert response.status_code == 200 Urls: path('menu/', MenuView.as_view(), name='menu'), path('cuisine_details/<int:id>/', CuisineDetailsView.as_view(), name='cuisine-details'), 1st test (menu view) is working properly 2nd test (cuisine details view) shows error .NoReverseMatch: Reverse for 'cuisine-details' with no arguments not found. 1 pattern(s) tried: ['cuisine_details\\/(?P<id> I know i should probably put somethere ID argument but tried few options and havent succeed. Will be grateful for any help/advise -
why is group a wrong alias in postgres + Django for auth_group table
Why is that the following simple query does not work (Using Django in the backend) # select group.name from auth_group as group; ERROR: syntax error at or near "." LINE 1: select group.name from auth_group as group; while the following works # select groupd.name from auth_group as groupd; name --------------- FO Admin Role admin alice bob (4 rows) What is wrong with using group as an alias ? -
Is there a default route in case of any invalid url in django?
I am not an expert on Django. I came across for the invalid url a lot in django. is there any defualt route to be configured instead of showing nothing or showing error page while debuging. like, we might configure one route that redirects in any case of invalid url or not data found or ... Hope i explained and made my point clear. -
How to install pyodbc on Dockerfile
I'm trying to install pyodbc on Django to access Sql Server but the Docker image had no be built. I get the error: => ERROR [16/16] RUN pip install --no-cache-dir -r requirements.txt 155.7s ------ > [16/16] RUN pip install --no-cache-dir -r requirements.txt: ... #20 93.38 Building wheels for collected packages: pyodbc, dj-static, static3, django-ckeditor, odfpy, anyjson, django-celery, pyftpdlib #20 93.38 Building wheel for pyodbc (setup.py): started #20 96.49 Building wheel for pyodbc (setup.py): finished with status 'error' #20 96.49 ERROR: Command errored out with exit status 1: #20 96.49 command: /usr/local/bin/python -u -c 'import io, os, sys, setuptools, tokenize; sys.argv[0] = '"'"'/tmp/pip-install-6hbca4vm/pyodbc_01637cbf594442cbbc4aac8a8305e138/setup.py'"'"'; __file__='"'"'/tmp/pip-install-6hbca4vm/pyodbc_01637cbf594442cbbc4aac8a8305e138/setup.py'"'"';f = getattr(tokenize, '"'"'open'"'"', open)(__file__) if os.path.exists(__file__) else io.StringIO('"'"'from setuptools import setup; setup()'"'"');code = f.read().replace('"'"'\r\n'"'"', '"'"'\n'"'"');f.close();exec(compile(code, __file__, '"'"'exec'"'"'))' bdist_wheel -d /tmp/pip-wheel-_ty0puya #20 96.49 cwd: /tmp/pip-install-6hbca4vm/pyodbc_01637cbf594442cbbc4aac8a8305e138/ #20 96.49 Complete output (13 lines): #20 96.49 running bdist_wheel #20 96.49 running build #20 96.49 running build_ext #20 96.49 building 'pyodbc' extension #20 96.49 creating build #20 96.49 creating build/temp.linux-x86_64-3.8 #20 96.49 creating build/temp.linux-x86_64-3.8/tmp #20 96.49 creating build/temp.linux-x86_64-3.8/tmp/pip-install-6hbca4vm #20 96.49 creating build/temp.linux-x86_64-3.8/tmp/pip-install-6hbca4vm/pyodbc_01637cbf594442cbbc4aac8a8305e138 #20 96.49 creating build/temp.linux-x86_64-3.8/tmp/pip-install-6hbca4vm/pyodbc_01637cbf594442cbbc4aac8a8305e138/src #20 96.49 gcc -pthread -Wno-unused-result -Wsign-compare -DNDEBUG -g -fwrapv -O3 -Wall -fPIC -DPYODBC_VERSION=3.0.10 -DPYODBC_UNICODE_WIDTH=4 -DSQL_WCHART_CONVERT=1 -I/Applications/Xcode.app/Contents/Developer/Platforms/MacOSX.platform/Developer/SDKs/MacOSX10.8.sdk/usr/include -I/usr/local/include/python3.8 -c /tmp/pip-install-6hbca4vm/pyodbc_01637cbf594442cbbc4aac8a8305e138/src/sqlwchar.cpp -o build/temp.linux-x86_64-3.8/tmp/pip-install-6hbca4vm/pyodbc_01637cbf594442cbbc4aac8a8305e138/src/ sqlwchar.o -Wno-write-strings #20 96.49 gcc: … -
Cannot upload file to azure blob starage in Azure django app service
My django server was 1st time deployed to azure last autumn and after half year it suddenly stopped working. (It is still possible the there has been pipeline executions using different branches meanwhile). However when running the django server from on-prem host (i.e. using the same environment variables AZURE_ACCOUNT_NAME and AZURE_ACCOUNT_KEY) I can download and upload files from and to container's media directory 'poytakirjat'. But when running the code in azure I can just download files, but not upload into media directory 'poytakirjat'. When I try to upload something I get just Http error 502 and nothing else even tough I had DEBUG set to True. I don't even know how to get some log files. models.py: from django.db import models from custom_azure import AzureMediaStorage import datetime from html.parser import HTMLParser from tinymce import models as tinymce_models from django.core.mail import send_mail from ckeditor.fields import RichTextField from django.contrib.auth.models import User # Create your models here. class Tiedostot3(models.Model): otsikko = models.CharField(max_length=250) kuvaus = RichTextField(blank=True) paivitetty = models.DateTimeField(auto_now_add=True, verbose_name="Päivitetty") tiedosto = models.FileField(upload_to='poytakirjat', storage=AzureMediaStorage(), verbose_name="Tiedosto", blank = True) owner = models.ForeignKey(User, null=True, blank=True, on_delete=models.CASCADE) class Meta: ordering = ['-paivitetty'] verbose_name = "tiedosto" verbose_name_plural="tiedostot" def __unicode__(self): return unicode(self.otsikko) class Liite3(models.Model): otsikko = models.CharField(max_length=250) tiedosto = … -
csrf missing error but csrf token is present there i have checked it by inspecting it it is happen in cpanel deployment
Forbidden (403) CSRF verification failed. Request aborted. You are seeing this message because this site requires a CSRF cookie when submitting forms. This cookie is required for security reasons, to ensure that your browser is not being hijacked by third parties. If you have configured your browser to disable cookies, please re-enable them, at least for this site, or for “same-origin” requests. More information is available with DEBUG=True. In my django project when i deploy it to c panel its form submission giving me error i have already inclued the csrf token and also it is working perfectly fine during the development i did some research they were talking about the render function i have used redirect and i had to use -
How to use pytest third-party fixtures in my tests?
I am using postmarker in a Django project to send emails. I am using Pytest for testing, and I would like to mock all outgoing emails that I am sending using Postmarker. I found in Postmarker documentation indication for some predefined Pytest fixtures to do so, but I am not sure how I can use them in my Unit tests. Here is the source code of said Pytest fixtures: https://github.com/Stranger6667/postmarker/blob/master/src/postmarker/pytest.py I've ended up just copying those Pytest fixtures code with the mock statements, but was wondering if there is a cleaner way of using them. -
Is there any python library to plot a static map with a specific country in Django?
I have previously used some python libraries like folium, matplotlib etc. These libraries render nice, dynamic maps in Django template, but take a lot of time to load. Also, I want the static map for a specific country where places can be marked with their respective latitudes and longitudes. The map should be something like this: So, is there any python library that renders static maps in Django template with relatively less loading time than those by folium, matplotlib? -
Python Return a Variable in the file
I have tuple variables which are France, Germany. I'm trying to give a value to my bring_cities function and if it's France or Germany, I like to see the France and Germany tuple objects. Is there any shortcut to not use if loops like I did in the below ? France = ( ('Paris', 'Paris'), ('Lyon', 'Lyon'), ) Germany = ( ('Frankfurt', 'Frankfurt'), ('Berlin', 'Berlin'), ) cities = (('', ''),) + France + Germany def bring_cities(country): if country == 'France': return France if country == 'Germany': return Germany ... -
Django: get all permissions on template separated by groups
I have an admin site, I want to edit and add roles to it. It looks like this I can get all the permissions using the POST method by calling every name but I have many permissions and groups. But by using that I can only save one group at a time. Is there a way to get the permissions separated by groups when the save button was clicked? For example: {'Super Admin':['permision1','permision2'], 'Admin':['permision1'], 'CSM':['permision2]} -
Defaultlist in Django
I used defaultlist in my Django App but my output is not good .html {% for key, value in results.items %} <tr> <td>{{ item.key }} </td> <td>{{ item.value }} </td> </tr> {% endfor %} my output: defaultdict(<class 'list'>, {'List of auto blue': ['wolss', 'jaguar', 'bmw', 'tys', 'toyota', 'List of auto red': [jwdwoi, dede, dsd, dsa]}) views.py from django.shortcuts import render from django.core.files.storage import FileSystemStorage import pandas as pd import datetime from datetime import datetime as td import os from collections import defaultdict def home(request): if request.method == 'POST': uploaded_file = request.FILES['document'] uploaded_file2 = request.FILES['document2'] if uploaded_file.name.endswith('.xls'): savefile = FileSystemStorage() name = savefile.save(uploaded_file.name, uploaded_file) name2 = savefile.save(uploaded_file2.name, uploaded_file2) d = os.getcwd() file_directory = d+'\\media\\'+name file_directory2 = d+'\\media\\'+name2 results,output_df =results1(file_directory,file_directory2) return render(request,"results.html",{"results":results,"output_df":output_df,}) return render(request, "index.html") def readfile(uploaded_file): data = pd.read_excel(uploaded_file, index_col=None) return data def results1(file1,file2): results_list = defaultdict(list) if d> t: results_list["List of bleu auto :"].append(s_id) if len(p_index) > 1: results_list["List of red auto:"].append(s_id) results_list what is wrong please ? How i can give an output like this : List of auto blue: -wolss -jaguar -bmw -tys -toyota List of auto red: -jwdwoi -dede -dsd -dsa -
Black formatter in does not work correctly
i work in Django project and in it we use Black formatter but i have problem with this .we have a 'pyproject.toml' file like this picture but with configuration black does not work and i have this error Usage: black [OPTIONS] SRC ... Try 'black -h' for help. Error: Invalid value for '--exclude': Not a valid regular expression: bad escape \e at position 68 (line 7, column 5) but when i delete line 4-18 it work correctly (when i delete exclude part ).what is wrong in exclude part ?can anyone help me? thanks a lot -
Upload images/files in user specific folder in Django
I want to upload images in a folder ( Where folder name is currently logged in username). I am using django login forms. for example: currently user is logged in as 'user99'. now i gave functionality where he can upload his images. and when he upload a image, this should save in my local system in his username folder i.e user99. uploaded image- demo.jpg target dict - Media/user99/01-02-2022.jpg In model.py instead of using instance.title , I want to use instance.user. but when i do that i am getting this error. mysite.models.Image.user.RelatedObjectDoesNotExist: Image has no user. Django version 2.2.5, Python 3.7.11, Please guide me. Thank you my model.py is: def upload_path(instance,title): today = str(date.today()) name = instance.user return f'{name}/{today}.jpg' class Image(models.Model): title = models.CharField(max_length=20, choices=CROP_CHOICES) image = models.ImageField(upload_to=upload_path, blank=True) user = models.ForeignKey(settings.AUTH_USER_MODEL,on_delete=models.CASCADE) def __str__(self): return self.title and views.py is: def upload(request): if request.method == 'POST': form = ImageForm(request.POST, request.FILES) if form.is_valid(): form.save() img_obj = form.instance return render(request, 'mysite/upload.html', {'form': form, 'img_obj': img_obj}) else: form = ImageForm() return render(request, 'mysite/upload.html', {'form': form}) forms.py : class ImageForm(forms.ModelForm): class Meta: model = Image fields = ('title', 'image') -
KeyError: at 'role_type' while using request.session in Django 3.0
I am trying to fetch role_type when user is login to the server , when user login immediately i am getting this issue Here i am using Django 3.0 and python 3.7 Here is my views.py def get_context_data(self): dashboard_data = {} is_worker = self.request.session['role_type'] in [ 'Job Worker', 'Job Worker with documents'] dashboard_data['is_worker'] = is_worker ... ... return dashboard_data here is my error traceback Traceback (most recent call last): File "/home/abc/xyz/lib/python3.7/site-packages/django/core/handlers/exception.py", line 34, in inner response = get_response(request) File "/home/abc/xyz/lib/python3.7/site-packages/django/core/handlers/base.py", line 115, in _get_response response = self.process_exception_by_middleware(e, request) File "/home/abc/xyz/lib/python3.7/site-packages/django/core/handlers/base.py", line 113, in _get_response response = wrapped_callback(request, *callback_args, **callback_kwargs) File "/home/abc/xyz/lib/python3.7/site-packages/django/contrib/auth/decorators.py", line 21, in _wrapped_view return view_func(request, *args, **kwargs) File "/home/abc/xyz/lib/python3.7/site-packages/django/views/generic/base.py", line 71, in view return self.dispatch(request, *args, **kwargs) File "/home/abc/xyz/lib/python3.7/site-packages/django/views/generic/base.py", line 97, in dispatch return handler(request, *args, **kwargs) File "/home/abc/xyz/lib/python3.7/site-packages/django/views/generic/base.py", line 158, in get context = self.get_context_data(**kwargs) File "/home/abc/test/dev-1.8/mcam/server/mcam/dashboard/views.py", line 116, in get_context_data is_worker = self.request.session['role_type'] in [ File "/home/abc/xyz/lib/python3.7/site-packages/django/contrib/sessions/backends/base.py", line 64, in __getitem__ return self._session[key] KeyError: 'role_type' How could i solve this error
