Django community: RSS
This page, updated regularly, aggregates Django Q&A from the Django community.
-
django data table filters with filter-checkbox
HOW CAN I CONVERT THIS DYNAMIC FILTER JAVASCRIPT INTO CHECKBOX FILTER JS AND THE DATA WHICH IS EXPOSED IN THE FOR LOOP IS COMING DIRECTLY FROM SQL CONNECTION. PLEASE HELP """ function myFunction() { var input, filter, table, tr, td, i, txtValue; input = document.getElementById("myInput"); filter = input.value.toUpperCase(); table = document.getElementById("myTable"); tr = table.getElementsByTagName("tr"); for (i = 0; i < tr.length; i++) { td = tr[i].getElementsByTagName("td")[1]; if (td) { txtValue = td.textContent || td.innerText; if (txtValue.toUpperCase().indexOf(filter) > -1) { tr[i].style.display = ""; } else { tr[i].style.display = "none"; } } } } </script> """ """ <div class="sub-filter filter-hide" aria-labelledby="static-filter-company" data-toggle="checkboxgroup"> <ul role="listbox"> <li role="option"> <div class="filter-item pad-responsive-lr"> <div class="checkbox"> <input id="static-check-company" type="checkbox" data-indeterminate checked/> <label for="static-check-company">Select All</label> </div> </div> <ul class="filter-checklist"> {% for i in res %} <li class="pad-responsive-lr filter-item" role="option"> <div class="checkbox"> <input class ="filter-checkbox" data-filter="cols" id="static-check-mendez" type="checkbox" value="{{i.0}}"/> <label for="static-check-mendez">ID</label> </div> </li> {% endfor %} </ul> </div> """ HOW CAN I CONVERT THIS DYNAMIC FILTER JAVASCRIPT INTO CHECKBOX FILTER JS AND THE DATA WHICH IS EXPOSED IN THE FOR LOOP IS COMING DIRECTLY FROM SQL CONNECTION. PLEASE HELP -
Django Develop Live Streaming Application
We are building Live Streaming Application and I found there is very few resources to achieve this kind of thing. I decided to integrate third-party tools with Django to implement live streaming! Does anyone know any third-party service or tutorial to develop live video streaming? so that my user can go love using my webpage anytime. -
django.core.exceptions.SuspiciousFileOperation: The joined path is located outside of the base path comp
raise SuspiciousFileOperation( [20/Jun/2022 15:21:10] "GET /static/assets/img/logos/facebook.svg HTTP/1.1" 404 1846 django.core.exceptions.SuspiciousFileOperation: The joined path (S:\cdn.startbootstrap.com\sb-forms-latest.js) is located outside of the base path component (C:\Users\Nishant\Envs\work\lib\site-packages\django\contrib\admin\static) [20/Jun/2022 15:21:10] "GET /static/assets/img/about/2.jpg HTTP/1.1" 404 1825 [20/Jun/2022 15:21:10] "GET /static/assets/img/logos/google.svg HTTP/1.1" 404 1840 [20/Jun/2022 15:21:10] "GET /static/assets/img/about/3.jpg HTTP/1.1" 404 1825 [20/Jun/2022 15:21:10] "GET /static/https%3A/cdn.startbootstrap.com/sb-forms-latest.js HTTP/1.1" 500 59 [20/Jun/2022 15:21:10] "GET /static/assets/img/team/1.jpg HTTP/1.1" 404 1822 [20/Jun/2022 15:21:10] "GET /static/assets/img/about/4.jpg HTTP/1.1" 404 1825* [ [ i am having this error that path is located outside of the base path and i also uploaded all my file in github link is given ][github link for files] ][screenshort of the error] * -
Django apps ,Ajax post is not working over HTTPS in Azure, returns 403
I'm new to Azure. when I host the same website in Heroku it works fine in both(Http and Https). But in Azure the ajax POST Method is only working over Http but return 403 in Https and showing error when login to Django admin pannel Django admin login error I tried many things but still I cannot figure it out Its not the problem in code because it works fine in Heroku. I think missed something in Azure Network configuration You can visit the websites Problem in https://glide.azurewebsites.net Works in http://glide.azurewebsites.net Works in https://estatemanagements.herokuapp.com When page Loades it sends a ID that saved in browser via post request if ID is not available a Sign in button will appear if ID is there it will return the Name and email You can notice that over http connection sign in button is visible in Login and Register(https://glide.azurewebsites.net/auth) also not responding -
best way to rename django app without getting errors
am in need of renaming my django app but i know that comes with alot of problems and headaches if done wrong. Anyone got any ideas on how to do it as smooth as possible? I looked around and is this metod the best one to do? or any other suggestions? https://pypi.org/project/django-rename-app/ https://odwyer.software/blog/how-to-rename-an-existing-django-application -
getting this error : how can i solve it using django?
hello im try to add google recaptcha t my website so when i add the recaptcha i had this error : ?: (captcha.recaptcha_test_key_error) RECAPTCHA_PRIVATE_KEY or RECAPTCHA_PUBLIC_KEY is making use of the Google test keys and will not behave as expected in a production environment HINT: Update settings.RECAPTCHA_PRIVATE_KEY and/or settings.RECAPTCHA_PUBLIC_KEY. Alternatively this check can be ignored by adding SILENCED_SYSTEM_CHECKS = ['captcha.recaptcha_test_key_error'] to your settings file. how can i solve it ? -
Django - update query doesn't work in pre_delete signal
I tried to update a Transaction model queryset in the below pre_delete signal that connected to the Wallet model, but it didn't work. The signal triggers, and all lines work correctly, except the last line :( @receiver(pre_delete, sender=Wallet) def delete_wallet(sender, instance, **kwargs): if instance.is_default: raise ValidationError({"is_default": "You can't delete the default wallet"}) q = {"company": instance.company} if instance.company else {"user": instance.user} try: default_wallet = Wallet.objects.get(**q, is_default=True) except Wallet.DoesNotExist: default_wallet = Wallet.objects.filter(**q).first() if not default_wallet: raise ValidationError({"is_default": "You can't delete the last wallet"}) instance.transactions.all().update(wallet=default_wallet) -
How could I keep the variable constant in looping when the variable is reused in python
I'm trying to loop through the JSON where I have sid which is initially zero when it is passed through the Stored Procedure it will return some value 8463 and I want to keep this value as sid and again I want to pass the same value which is 8463 through the SP again. I have tried keeping it constant but once it loop through the one dictionary it automatically increasing the value of `sid. Views.py @api_view(['POST']) def SaveUserResponse(request): if request.method == 'POST': for ran in request.data: print(type(ran),'QId--',ran.get('QId'), ran) print(type(request.data)) auditorid =ran.get('AuditorId') print('SaveUserResponse auditorid---', auditorid) ticketid = ran.get('TicketId') qid = ran.get('QId') answer = ran.get('Answer') sid = '0' cursor = connection.cursor() cursor.execute('EXEC [dbo].[sp_SaveAuditResponse] @auditorid=%s,@ticketid=%s,@qid=%s,@answer=%s,@sid=%s', (auditorid,ticketid,qid,answer, sid)) result_st = cursor.fetchall() print('sp_SaveAuditResponse', result_st) # # if qid != 1 or qid != 42: for row in result_st: print('sp_SaveAuditResponse', row) sid = row[0] return Response(row[0]) Payload: [{"AuditorId":130,"Agents":"","Supervisor":"","TicketId":"325423432","QId":42,"Answer":"2","SID":"0","Comments":""}, {"AuditorId":130,"Agents":"","Supervisor":"","TicketId":"325423432","QId":43,"Answer":"2","SID":"0","Comments":""}, {"AuditorId":130,"Agents":"","Supervisor":"","TicketId":"325423432","QId":44,"Answer":"2","SID":"0","Comments":""}, {"AuditorId":130,"Agents":"","Supervisor":"","TicketId":"325423432","QId":45,"Answer":"2","SID":"0","Comments":""}, {"AuditorId":130,"Agents":"","Supervisor":"","TicketId":"325423432","QId":46,"Answer":"3","SID":"0","Comments":""}, {"AuditorId":130,"Agents":"","Supervisor":"","TicketId":"325423432","QId":47,"Answer":"5","SID":"0","Comments":""}, {"AuditorId":130,"Agents":"","Supervisor":"","TicketId":"325423432","QId":48,"Answer":"5","SID":"0","Comments":""}, {"AuditorId":130,"Agents":"","Supervisor":"","TicketId":"325423432","QId":49,"Answer":"2","SID":"0","Comments":""}, {"AuditorId":130,"Agents":"","Supervisor":"","TicketId":"325423432","QId":50,"Answer":"5","SID":"0","Comments":""}] -
Directory indexes are not allowed here. I`m trying to solve this error but nothing any solution
Here Is My Code for trying to view pdf file by pressing button.How to solve this problem please add some reply for solving this problem thank you advance.. here is my views.py code : def show(request): a=student.objects.all() return render(request,'show.html',{'a':a}) def ppts(request, id): b=student.objects.get(id=id) return render(request,'ppts.html',{'b':b}) And Here is my html file <!DOCTYPE html> {% load static %} <html lang="en"> <head> <meta charset="UTF-8"> <meta http-equiv="X-UA-Compatible" content="IE=edge"> <meta name="viewport" content="width=device-width, initial-scale=1.0"> <title>Document</title> </head> <body> <td><embed src="{% static ' ' %}{{a.resume}} " height="700px" width="1500px"></td> <!-- <td> <a href="" download></a> </td> --> </body> </html> And Here is my show.html code : <!DOCTYPE html> {% load static %} <html lang="en"> <head> <meta charset="UTF-8"> <meta http-equiv="X-UA-Compatible" content="IE=edge"> <meta name="viewport" content="width=>, initial-scale=1.0"> <title>student table</title> </head> <body> <table> <thead> <tr> <th>NAME</th> <th>ADDRESS</th> <th>AGE</th> <th>EDUCATION</th> <th>EMAIL</th> <th>RESUME</th> </tr> </thead> <tbody> {% for val in a %} <tr> <td>{{val.NAME}}</td> <td>{{val.ADDRESS}}</td> <td>{{val.AGE}}</td> <td>{{val.EDUCATION}}</td> <td>{{val.EMAIL}}</td> <td><button><a href="/ppts/{{val.id}}/">{{val.resume}}</a></button></td> </tr> {% endfor %} </tbody> </table> </body> </html> here is output showing while run this program.. -
Django: How to create superuser with custom fields?
I have a custom User model in my models.py and custom UserManager as well. My custom User model has username field with changed name to login and same is updated in UserManageras well. Everything goes fine, but when I try to create superuser using commandpython manage.py createsuperuser, it asks for loginbut it does not ask foremail` which at the end gives me this error: TypeError: UserManager.create_superuser() missing 1 required positional argument: 'email' My custom User model is: class User(AbstractBaseUser, PermissionsMixin): login = models.CharField(max_length=254, unique=True) email = models.EmailField(max_length=254, unique=True) first_name = models.CharField(max_length=254, null=True, blank=True) last_name = models.CharField(max_length=254, null=True, blank=True) is_staff = models.BooleanField(default=False) is_admin = models.BooleanField(default=False) is_active = models.BooleanField(default=True) last_login = models.DateTimeField(null=True, blank=True) date_joined = models.DateTimeField(auto_now_add=True) USERNAME_FIELD = 'login' EMAIL_FIELD = 'email' REQUIRED_FIELDS = [] objects = UserManager() def get_absolute_url(self): return "/users/%i/" % (self.pk) My custom UserManager is: class UserManager(BaseUserManager): def _create_user(self, login, email, password, is_staff, is_admin, **extra_fields): if not email: raise ValueError('Users must have an email address') now = timezone.now() email = self.normalize_email(email) user = self.model( login=login, email=email, is_staff=is_staff, is_active=True, is_admin=is_admin, last_login=now, date_joined=now, **extra_fields ) user.set_password(password) user.save(using=self._db) return user def create_user(self, login, email, password, **extra_fields): user = self._create_user(login, email, password, False, False, **extra_fields) user.save(using=self._db) return user def create_superuser(self, login, email, password, … -
How to implement Buy Now functionality using Django in eCommerce
I am creating an e-commerce website. almost done!! But I want to add extra feature which is Buy Now I found the same question Here -
django quill editor how to make validation on quill text area
i have django form in which a text area is made up using quill editor know if i submit form with data it work correctly but when i submit it text area empty it gives me key error . how to make validation on quill field that it required form.py def clean(self): data = super(NewQuestion, self).clean() if len(data['title']) < 15: self.add_error('title', "Title must be at least 15 characters.") if len(data['body']) < 30: self.add_error( 'body', f"Body must be at least 30 characters; you entered {len(data['body'])}.") if len(data['tags']) < 1: self.add_error( 'tags', f"Please enter at least one tag; .") models.py class Questions(models.Model): title = models.CharField(max_length=150, blank=False,) body = QuillField(blank=False) views.py if request.method == 'POST': newQuestionForm = NewQuestion(request.POST or None) if newQuestionForm.is_valid(): -
psycopg2.errors.CannotCoerce: cannot cast type integer to interval
Error when running migrations.AlterField in a conversion from IntegerField to DurationField using PosgreSQL with Django 2.2. Any workaround? -
How to store list of foreign keys in a model
Hii Everyone here is the case in which i am facing this same issue please have a look over this: ClassificationGroup.py class DeviceClassificationGroup: vendor_id = models.ForeignKey(Vendor, on_delete=models.CASCADE, default=None, null=True) id = models.IntegerField(primary_key=True) name = models.CharField(max_length=100) description = models.CharField(max_length=1000) classification = ?? Classification.py class DeviceClassification(models.Model): vendor_id = models.ForeignKey(Vendor, on_delete=models.CASCADE, default=None, null=True) id = models.IntegerField(primary_key=True) name = models.CharField(max_length=100) description = models.CharField(max_length=1000) device_type = models.IntegerField() device_name_regex = models.CharField(max_length=100) vid_pid = models.CharField(max_length=50) device_instance_id = models.CharField(max_length=100) serial_number = models.CharField(max_length=100) brand = models.CharField(max_length=25) def __str__(self): return self.name So i would have set of classifications that i can put in the one classification group. How can i store an unknown amount of foreign keys in a django model?? Kindly help me out in this. -
Detect if Django API query is from own-site or external site
I have Django running on a server which has a public facing API. I want to do different django-rest-framework throttling based on where the request is coming from. For example, if the request is coming from an Angular client on the same domain (e.g. my-angular-client.mydomain.com) I'd like it to be rate limited differently to, say, a curl request from someone's command line. What is the best practice for this? I know there is data in HttpRequest.META such as REMOTE_ADDR, but that field is empty when I use my test server rather than running locally. There's also HTTP_REFERER, but that seems to populate only if the page is a django template page, rather than say, a client built using a different tech stack, such as Angular. What should I be using for this use case? -
Display my Django project on my server domain
I have a Django project on a CentOS server. I run the following command - python3 manage.py runserver 0.0.0.0:8080 Django version 3.2.13, using settings 'djangonautic.settings' Starting development server at http://0:8080/ But when I visit http://myDomainName:8080 I get the error ERR_CONNECTION_REFUSED. I also tried running - python3 manage.py runserver myIP:8080 but when I visit http://myIP:8080 I receive Bad Request (400). This time I can see the GET request on my server - "GET / HTTP/1.1" 400 143 [20/Jun/2022 09:16:39] "GET /favicon.ico HTTP/1.1" 400 143 [20/Jun/2022 09:16:41] "GET / HTTP/1.1" 400 143 [20/Jun/2022 09:16:41] "GET /favicon.ico HTTP/1.1" 400 143 The allowed_hosts in setting.py containing my domain name. Thanks! -
Django default image upload preview
Good day, is there any tool for Django out-of-the-box to preview images before upload? I'd like to add this feature without JS scripts or Django modules. -
Django Rest Framework creatable fields and updatable fields
Below is my sample model: class DemoModel(models.Model): field_one = models.IntegerField() field_two = models.IntegerField(blank=True, null=True) The Serializer: class DemoSerializer(serializers.ModelSerializer): """ Here only field_one should be creatable and only field_two should be updatable """ class Meta: model = models.DemoModel fields = '__all__' My question is how can I write the view for this serializer and model, so that when using the post method the client can not add data for the field_two field. Client can only add data to field_one. But while updating, the client can update the value of field_two, but can not update the value of field_one field. Thank you -
How to process the data in realtime that received with a Django made API?
I'm new to Django. Currently, I've built an API with Django. The frontend would use this API to POST the data to mysql DB. Now I want to do some realtime process. Once the frontend POST data, I can instantaneously aquire and process(e.g. some algorithm with python) the data. Is it possible? How can I know when I received the data? Is it possible to get this data without access the DB? Where should I put the code to process the received data(in a new file or in models.py,views.py,serializers.py)? # models.py class Room(models.Model): code = models.CharField(max_length=100, default="", unique=False) host = models.CharField(max_length=100, unique=True) #serializers.py class RoomSerializer(serializers.ModelSerializer): class Meta: model = Room fields = ('id', 'code', 'host') #views.py class RoomView(generics.ListCreateAPIView): queryset = Room.objects.all() serializer_class = RoomSerializer def home(request): q = request.GET.get('q') if request.GET.get('q') != None else '' rooms = Room.objects.filter( Q(Room__host__icontains=q) ) return render(request) #Once frontend POST data. def process(): tcp_client_socket.send(latestdata['host']) ... -
Passing Id and Context in Django Redirect
I want to pass a model to a html page as context when I login into an account. My Home page url comes with user id as a url parameter. But i cant pass any context in redirect views.py from django.contrib.auth import authenticate,login,logout from django.contrib import messages from django.shortcuts import redirect, render from django.http import HttpResponse from .models import users from home.models import Posts def f1(request): Post = Posts.objects.all() context = {'Post':Post} if request.method == "POST": username = request.POST['username'] password = request.POST['password'] uz = authenticate(request,username=username, password=password) if uz is not None: login(request,uz) id = users.objects.filter(name=username).values('id')[0]['id'] return redirect('home',id) # This Works Fine return redirect('home',id,context) # This is not Working else: messages.error(request,"Wrong Credentials") return render(request,'login.html') urls.py from django.contrib.auth import logout from django.urls import path from . import views urlpatterns=[ path('<str:users_id>/',views.func,name="home"), ] How can I pass the context? If I can't tell me an alternative way to do it. #Thanks -
Ruserver is fine; Getting error while migrate - Django
while running server its working fine; website working fine; everything is fine. but when I am trying migrate something I am getting error as below. even if I am adding new model and trying to do makemigrations and migrate everything happening and working fine, but migrate shows error as below. couldn't find out the problem. Operations to perform: Apply all migrations: admin, auth, contenttypes, pmp, sessions Running migrations: Applying pmp.0035_alter_tests_reports_visit...Traceback (most recent call last): File "C:\Users\Lenovo\AppData\Local\Programs\Python\Python310\lib\site-packages\django\db\backends\utils.py", line 89, in _execute return self.cursor.execute(sql, params) File "C:\Users\Lenovo\AppData\Local\Programs\Python\Python310\lib\site-packages\django\db\backends\sqlite3\base.py", line 477, in execute return Database.Cursor.execute(self, query, params) sqlite3.IntegrityError: UNIQUE constraint failed: new__pmp_tests_reports.visit_id The above exception was the direct cause of the following exception: Traceback (most recent call last): File "E:\py\patient_management_project\manage.py", line 22, in <module> main() File "E:\py\patient_management_project\manage.py", line 18, in main execute_from_command_line(sys.argv) File "C:\Users\Lenovo\AppData\Local\Programs\Python\Python310\lib\site-packages\django\core\management\__init__.py", line 446, in execute_from_command_line utility.execute() File "C:\Users\Lenovo\AppData\Local\Programs\Python\Python310\lib\site-packages\django\core\management\__init__.py", line 440, in execute self.fetch_command(subcommand).run_from_argv(self.argv) File "C:\Users\Lenovo\AppData\Local\Programs\Python\Python310\lib\site-packages\django\core\management\base.py", line 414, in run_from_argv self.execute(*args, **cmd_options) File "C:\Users\Lenovo\AppData\Local\Programs\Python\Python310\lib\site-packages\django\core\management\base.py", line 460, in execute output = self.handle(*args, **options) File "C:\Users\Lenovo\AppData\Local\Programs\Python\Python310\lib\site-packages\django\core\management\base.py", line 98, in wrapped res = handle_func(*args, **kwargs) File "C:\Users\Lenovo\AppData\Local\Programs\Python\Python310\lib\site-packages\django\core\management\commands\migrate.py", line 290, in handle post_migrate_state = executor.migrate( File "C:\Users\Lenovo\AppData\Local\Programs\Python\Python310\lib\site-packages\django\db\migrations\executor.py", line 131, in migrate state = self._migrate_all_forwards( File "C:\Users\Lenovo\AppData\Local\Programs\Python\Python310\lib\site-packages\django\db\migrations\executor.py", line 163, in _migrate_all_forwards state = self.apply_migration( File "C:\Users\Lenovo\AppData\Local\Programs\Python\Python310\lib\site-packages\django\db\migrations\executor.py", line … -
'NoneType' object is not iterable in Django
I am getting this error when I create a new course. Please help to solve this. My admin panel shows 'Courses' then I click 'add' button but when I save it shows this error TypeError at /admin/course/course/add/ 'NoneType' object is not iterable Request Method: POST Request URL: http://127.0.0.1:8000/admin/course/course/add/ Django Version: 3.1.5 Exception Type: TypeError Exception Value: 'NoneType' object is not iterable Exception Location: C:\Users\bilol\AppData\Local\Programs\Python\Python37-32\lib\site-packages\parler\models.py, line 759, in save_translations Python Executable: C:\Users\bilol\AppData\Local\Programs\Python\Python37-32\python.exe Python Version: 3.7.3 Python Path: ['C:\\Django\\mysite', 'C:\\Users\\bilol\\AppData\\Local\\Programs\\Python\\Python37-32\\python37.zip', 'C:\\Users\\bilol\\AppData\\Local\\Programs\\Python\\Python37-32\\DLLs', Here is my model. I made migrations. class Course(TranslatableModel): STATUS = ( ('True', 'True'), ('False', 'False'), ) parent = models.ForeignKey('self', blank=True, null=True, related_name='children', on_delete=models.CASCADE) title = models.CharField(max_length=30) keywords = models.CharField(max_length=255) description = models.CharField(max_length=255) image = models.ImageField(blank=True, upload_to='images/') status = models.CharField(max_length=10, choices=STATUS) slug = models.SlugField() create_at = models.DateTimeField(auto_now_add=True) update_at = models.DateTimeField(auto_now=True) def __str__(self): return self.title -
InvalidTemplateLibrary: Invalid template library specified. ImportError raised when trying to load 'bootstrap3.templatetags.bootstrap3':
I am getting the error "InvalidTemplateLibrary: Invalid template library specified. ImportError raised when trying to load 'bootstrap3.templatetags.bootstrap3': No module named parse" while loading the django application from obuntu. Can anyone help on this? regards Mallika -
Django template inheritance {% include %} with model set
This is for a simple blog that you can comment on each post. I'm getting an error when I try to include a template to a parent template. The variables are not getting passed. I understand that templates cannot pass their context to each other. My main.html is a list view of posts. Each post has another list of comments. {% for comment in post.comment_list|slice:"0:7" %} {% include 'blog/comments.html' with comment=comment %} {% endfor %} My comments.html is the template for each comment. <div><h1> {comment.username} {comment.id} {comment.body} </div></h1> What can I do here to make this work? -
Django Form Wizard dynamic form not aligning
I have a very specific issue with my Form Wizard, and after a lot of tinkering I just can't figure it out. I tried googling it but I think it's too specific. At step 3, the user has the option to add "contacts". When they press the button I have a little JS script that generates a form. Consecutive forms can be added and will be aligned in rows of 2. Once you go to the next step you have the option to return to the previous step if you forgot something. But, when you do, the 2 contacts that were filled in will appear in their separate row instead of the same row. (See pictures) I have no idea why this is happening. I'm really hoping on a sort of guru who had this happen to them or can spot something in the code. Thanks in advance! init.js function hideInitialFormset(prefix, row) { let fields = []; if (prefix === "contacts") { fields = [$('#id_contacts-0-name').val(), $('#id_contacts-0-funct').val(), $('#id_contacts-0-email').val()]; } let total = $('#id_' + prefix + '-TOTAL_FORMS'); if (total.val() === '1') { if (fields.includes('')) { row.hide(); total.val('0'); } } } main.js function total_field(prefix) { // get hidden field with jQuery once …
