Django community: RSS
This page, updated regularly, aggregates Django Q&A from the Django community.
-
Error base64 encoding when testing upload image in django restful framework
I'm writing unit tests trying to upload images and base64 encode it. But the encoding is different from expected. This is my tests.py with open('tests/image.jpg', 'rb') as image: r = self.client.post('/images', {'image': image}, format='multipart') This is my views.py def post(self, request): image = request.FILES['image'] base64_str = base64.b64encode(image.read()).decode('utf-8') The base64_str turns out to be like 7f7NCd0Aw29mVx...... Doing in a python script with open('tests/image.jpg', 'rb') as f: print(base64.b64encode(f.read()).decode('utf-8')) The output is /9j/4AAQSk...... I suppose there is something wrong with the encoding. So what's the problem? -
DirectAdmin CloudLinux Python Selector Django App - Application URL goes to root /home/<user>/<app>
I have setup a new DirectAdmin server with CloudLinux. I want to use the Python Selector option to build Django websites. I have created a test website, but the URL redirects to the root folder. django.[domain].nl/myapp/admin -> django.[domain].nl/home/[user]/myapp/admin /home/[user]/ is added extra. The full DirectAdmin path. I doubt whether this is a DirectAdmin setup error or a Django setting. -
getting problem with working json data for web development
hi i am working on python django project i need to convert my json data to datatable in frontend, i have using backend in python and frontend htmt,css,javascript for ex this is my json data- {"json_res": [{"car_number": mh00012, "trip":27,"empid":001,"onlinehrs":16}], "json_res1":[{"car_number":mh00014,"trip":100,"last_Week_trips":10}]} i want to make table like this in frontend- car_number trips empid onlinehrs last_week_trips mh00012 27 001 16 0 mh00014 100 0 0 10 -
Why my function in Views.py is not correct?
I have a Notification List view and this function def mark_as_read(request, notification_id): notification = get_object_or_404(Notification.objects.filter(pk=notification_id).exclude(viewed_at__isnull=False)) notification.viewed_at = datetime.datetime.now() notification.save() return redirect('users:notification') It works good but I think it is written not correct? Any body can tell it correct here working get_object_or_404? -
Saved task_id in database does not match Info from celery worker
I'm currently working on an application, that allows queueing of several tasks which should be allowed to be cancelled. For that to be possible, my task-model has a field for saving the task_id of the worker, and in Django, the user is presented with a list of the tasks and an option to stop individual tasks. The issue I am having is that the task_ids stored away in the database and the task_ids mentioned in the info line from the worker do not match until the worker has finished his task. i.e. the worker returns [2021-07-22 16:35:25,652: INFO/MainProcess] Received task: dop.tasks.execute_report[7490537f-90dd-4966-bff7-63d5461a92ff] but in the database, there's a different task_id saved until the worker returns a successful completion of the task. This prevents me from revoking any of the displayed tasks in the queue, because they have the wrong task_id associated with them. my code is below: def create_report(request, slug): ... # create report report = Report.objects.create( reportDefinition=reportDefinition, user=request.user ) ... transaction.on_commit( lambda: execute_report.delay( user_id=request.user.id, report_id=report.id, command_string=reportDefinition.get_command(), db_name=request.user.basex_prefix, resource_names=report.get_active_user_resource_names(), ) ) ... execute_report looks like this: @celery_app.task(bind=True) def execute_report( self, user_id, report_id, command_string, db_name, resource_names: list ): start_time = datetime.now() # get objects user = get_user_model().objects.get(id=user_id) report = Report.objects.get(id=report_id) report.task_id = … -
Django in_bulk() raising error with distinct()
I have the following QuerySet: MyModel.objects .order_by("foreign_key_id") .distinct("foreign_key_id") .in_bulk(field_name="foreign_key_id") foreign_key_id is not unique on MyModel but given the use of distinct should be unique within the QuerySet. However when this runs the following error is raised: "ValueError: in_bulk()'s field_name must be a unique field but 'foreign_key_id' isn't." According to the Django docs on in_bulk here it should be possible to use in_bulk with distinct in this way. The ability was added to Django in response to this issue ticket here. What do I need to change here to make this work? I'm using Django3.1 with Postgres11. -
DATETIME_FORMAT setting for my customized datetime field
I wrote a customized datetime field Now i want to add DATETIME_FORMAT setting for this customized field? -
How to set is_staff to True in Django when a user is created with a specific group selected
How would I automatically set is_staff to True when creating a new user in the Django admin when they have a specific group selected? -
Uploading image to Django database raises TypeError
I am having trouble uploading image paths into my Django database. When I try to add data without the eventImage field, it works fine. But when I upload anything to the eventImage field, it says: TypeError at /admin/events/event/add/ expected str, bytes or os.PathLike object, not tuple Request Method: POST Request URL: http://127.0.0.1:8000/admin/events/event/add/ Django Version: 3.2.5 Exception Type: TypeError Exception Value: expected str, bytes or os.PathLike object, not tuple Exception Location: /Library/Frameworks/Python.framework/Versions/3.9/lib/python3.9/posixpath.py, line 374, in abspath I've put relevant code snippets below. Please let me know what I'm doing wrong! In my settings.py file: from pathlib import Path import os BASE_DIR = Path(__file__).resolve().parent.parent INSTALLED_APPS = [ 'django.contrib.admin', 'django.contrib.auth', 'django.contrib.contenttypes', 'django.contrib.sessions', 'django.contrib.messages', 'django.contrib.staticfiles', 'rest_framework', 'events', ] STATIC_URL = '/static/' MEDIA_URL = '/media/' MEDIA_ROOT = os.path.join(BASE_DIR, 'media'), STATICFILES_DIRS = [os.path.join(BASE_DIR, 'static')] In my events.py file: from django.db import models class Event(models.Model): venueName = models.TextField() artistName = models.TextField() eventName = models.TextField() time = models.TextField() date = models.TextField() length = models.TextField() description = models.TextField() eventImage = models.ImageField( upload_to='media/', blank=True, null=True) def __str__(self): return self.eventName Any help would be hugely appreciated! -
how to solve Django url patterns not working
I added path('int:pk/',...) in urls.py and access 'http://127.0.0.1:8000/blog/1' the result was 'page not found(404)' Using the URLconf defined in doit.urls, Django tried these URL patterns, in this order: blog <int:pk>/ blog admin/ The current path, blog/1, didn’t match any of these. also, I made 3 pk contents please help me I suffered for a long time. urls.py from django.urls import path from . import views urlpatterns = [ path('<int:pk>/', views.PostDetail.as_view()), path('', views.PostList.as_view()), ] models.py from django.db import models class Post(models.Model): title = models.CharField(max_length=30) content = models.TextField() created_at = models.DateTimeField() def __str__(self): return f'[{self.pk}]{self.title}' views.py from django.views.generic import ListView, DetailView from .models import Post class PostList(ListView): model = Post ordering = '-pk' class PostDetail(DetailView): model = Post post_list.html <!DOCTYPE html> <html lang = "ko"> <head> <meta charset="UTF-8"> <title>Blog</title> </head> <body> <h1>Blog</h1> {% for p in post_list %} <hr/> <h2> {{ p.title }} </h2> <p> {{ p.content }}</p> <h4> {{ p.created_at }} </h4> {% endfor %} </body> </html> post_detail.html <!DOCTYPE html> <html lang="ko"> <head> <meta charset = "UTF-8"> <title> {{ post.title }} - Blog </title> </head> <body> <nav> <a href="/blog/">Blog</a> </nav> <h1> {{ post.title }} </h1> <h4> {{ post.created_at }} </h4> <p> {{ post.content }} </p> <hr/> <h3> ... </h3> </body> </html> -
Python: Object is missing attributes
Im working with the following object (from PyGuacamole: https://pypi.org/project/pyguacamole/0.7/): class GuacamoleClient(object): """Guacamole Client class.""" def __init__(self, host, port, timeout=20, debug=False, logger=None): """ Guacamole Client class. This class can handle communication with guacd server. :param host: guacd server host. :param port: guacd server port. :param timeout: socket connection timeout. :param debug: if True, default logger will switch to Debug level. """ self.host = host self.port = port self.timeout = timeout self._client = None # handshake established? self.connected = False # Receiving buffer self._buffer = bytearray() # Client ID self._id = None self.logger = guac_logger if logger: self.logger = logger if debug: self.logger.setLevel(logging.DEBUG) @property def client(self): """ Socket connection. """ if not self._client: self._client = socket.create_connection( (self.host, self.port), self.timeout) self.logger.info('Client connected with guacd server (%s, %s, %s)' % (self.host, self.port, self.timeout)) return self._client @property def id(self): """Return client id""" return self._id def close(self): """ Terminate connection with Guacamole guacd server. """ self.client.close() self._client = None self.connected = False self.logger.info('Connection closed.') def receive(self): """ Receive instructions from Guacamole guacd server. """ start = 0 while True: idx = self._buffer.find(INST_TERM.encode(), start) if idx != -1: # instruction was fully received! line = self._buffer[:idx + 1].decode() self._buffer = self._buffer[idx + 1:] self.logger.debug('Received instruction: %s' % … -
Django is loading static files but not image that are stored from backend in production
As the title says, after I changed DEBUG to False, the image that is uploaded from the admin panel are not loading. However, other static files like css files and images that are loaded only from HTML side are rendered properly. -
Django - Sum annotation adding group by id to clause
The following queryset subquery = aggregate_table.objects.filter( item__parent__name=OuterRef(dimension) ).annotate( aggregate_value=Sum(aggregation_field) ).order_by( 'item__parent__name' ).values('aggregate_value') queryset = queryset.annotate(aggregate_value=Subquery(subquery)) produces SQL that groups by both the name (supplied by the order_by) and by the id. SELECT SUM(U0."data") AS "aggregate_value" FROM "aggregate_table" U0 INNER JOIN "item" U1 ON (U0."item_id" = U1."id") INNER JOIN "parent" U2 ON (U1."parent_id" = U2."id") WHERE U2."name" = (T12."name") GROUP BY U0."id", U2."name" ORDER BY U2."name" ASC the ID produces incorrect results and instead of summing and returning 1 row with say 100 as the sum'd value, it returns 100 rows with 1 as the sum'd value. any ideas on how to remove the u0.id from the group by clause? -
display a spinner during data processing
I have written a django application for some data processing. In some cases, there could several minutes to wait until the processing is done. So I'd like to display a spinner on the page as soon as the user clicked on "excute" and all along the processing until the page is refreshed to display the results... I followed a tutorial (here) where I could set things up on the application and show the spinner when the page is loading. But this is not exactly what I'm looking for. The follwing JS code is coming from the video and shows the spinner until the page is loaded: const spinnerbox = document.getElementById('spinner-box') //console.log(spinnerbox) $.ajax({ type: 'GET', url: '/', success : function(response){ spinnerbox.classList.add('not-visible') console.log('response', response) }, error : function(error){ console.log(error) } }) I guess I need to modify this code, type should be 'POST' but I don't know what to add next to the script. Thanks for any help! Sébastien -
Django testing image
How to create image for test? I tried simpleUploadFile in different ways and it didn't work. I need test my endpoint. but have problem in image field My test: def setUp(self): self.card = Card.objects.create( title='card titulo', image='', amount=0, description='descricao', id= 1 ) self.user = User.objects.create_user( username='test', email='', password='have_senha' ) self.referral = Referral.objects.create(refferal_user=self.user, reffered_user=self.user) self.redeem = Redeem.objects.create(card=self.card,user=self.user) self.factory = RequestFactory() self.image = SimpleUploadedFile('donwload.jpeg', b'') def test_new_card(self): data ={ "title": "teste", "image": self.image, "amount": 0, "description": "TESET", "id": 24 } client = APIClient() client.force_authenticate(user=self.user) response = client.post('/card', data, format='json') print(response.json()) -
AWS EC2 and OpenCV with UDP consumer
I have two EC2 A That grabs the video feed from Amazon Kinesis Video to send it into via UDP to B B the consumer which it will grab the UDP feed from the A While debugging my opencv not grabbing the UDP feed, I suspect something is wrong with ffpmeg, so I am going to make sure that ffplay can read packets sent from A. Now when I try to read udp packets with ffplay {adress-ip-with-port}I have the following error : Could not initialize SDL - No available video device (Did you set the DISPLAY variable?) How do I fix this one since there is no display on EC2. Also if it can help, this is my code for the consumer part Create your views here. from django.http import HttpResponse from django.template import loader from django.shortcuts import render # from .models import Vehicule import cv2 import threading from django.views.decorators import gzip from django.http import StreamingHttpResponse @gzip.gzip_page def webcam(request): try: cam = VideoCamera() return StreamingHttpResponse(gen(cam), content_type="multipart/x-mixed-replace;boundary=frame") except: pass return render(request, 'vebcam.html') #capture video class VideoCamera(object): def __init__(self): self.video = cv2.VideoCapture('udp://172.31.57.243:55055', cv2.CAP_FFMPEG) (self.grabbed, self.frame) = self.video.read() threading.Thread(target=self.update, args=()).start() def __del__(self): self.video.release() def get_frame(self): image = self.frame _, jpeg = cv2.imencode('.jpg', image) … -
Django Views: Display and access data from csv file of users to create them
Currently I'm doing this via a management command that takes a csv, iterates through to create users. I'd like to do this via a view form where rows are populated by the data so eventually I can look and modify if typos in rows before importing. Here is an example of the csv. code: password = 'tempass12345' with open(file_path, mode='r', encoding='utf8') as csv_file: data = csv.reader(csv_file) for row in list(data)[1:]: first_name, last_name, email = row user = User.objects.create( username=email, first_name=first_name, last_name=last_name, email=email, password=password ) # csv file First Name,Last Name,Email Roy ,Cot, rcot@xyz.com What's the best django approach to doing this? The file will not be stored. -
How can assign foreign key of Abstrat User Model in django
When i submit the button it show the error "Vendor_Profile.auth_user" must be a "Auth_User" instance. Auth_User is an Abstract User Model.py class Auth_User(AbstractUser): is_vendor = models.BooleanField(default=False) class Vendor_Profile(models.Model): auth_user = models.ForeignKey(Auth_User, on_delete=models.CASCADE) name = models.CharField(max_length=50) View.py try: vendor = Vendor_Profile( auth_user=request.session['USER_ID'], name=self.request.POST.get('name') ) vendor.save() return render(request, 'home.html') except Exception as e: return HttpResponse('failed{}'.format(e)) -
TypeError: addProductPaymentResponse() missing 1 required positional argument: 'paymentForOrderID'
I want to restrict post request if similar str(number) in paymentForOrderID is already exists in ProductPayment model, #model.py class ProductPayment(models.Model): user = models.ForeignKey(User, on_delete=models.SET_NULL, null=True, editable=False,verbose_name="Payment Made By",) paymentForOrderID = models.CharField(max_length=200, null=True, blank=True, verbose_name="Payment For Order ID") paymentMethodUsed = models.CharField(max_length=200, null=True, blank=True,editable=False, verbose_name="Method Used") aproxTimeAndDateOfPayment = models.CharField(max_length=200, null=True, blank=True,editable=False, verbose_name="Approx Date/Time Of Payment") totalAmountPaid = models.CharField(max_length=200, null=True, blank=True,editable=False, verbose_name="Amount Paid") paymentDetails = models.TextField(null=True, blank=True,editable=False,verbose_name="Details") createdAt = models.DateTimeField(auto_now_add=True) _id = models.AutoField(primary_key=True, editable=False, verbose_name="Entry ID") def __str__(self): return str(self.createdAt) I'm trying this way.... #views.py @api_view(['POST']) @permission_classes([IsAuthenticated]) def addProductPaymentResponse(request, paymentForOrderID): user = request.user data = request.data response_list = ProductPayment.objects.all() alreadyExists = response_list.objects.filter(paymentForOrderID=paymentForOrderID).exists() if alreadyExists: content = {'detail': 'Sorry Response has already been recieved'} return Response(content, status=status.HTTP_400_BAD_REQUEST) else: product = ProductPayment.objects.create( user=user, paymentForOrderID=data['paymentForOrderID'], paymentMethodUsed=data['paymentMethodUsed'], aproxTimeAndDateOfPayment=data['aproxTimeAndDateOfPayment'], totalAmountPaid=data['totalAmountPaid'], paymentDetails=data['paymentDetails'], ) return Response('Payment Response added') On hitting post action from frontend I get this error TypeError: addProductPaymentResponse() missing 1 required positional argument: 'paymentForOrderID' [22/Jul/2021 18:13:01] "POST /api/payments/product-payment-add-response/ HTTP/1.1" 500 102170 So kindly highlight where is the mistake and how can I fix that -
How to use global variables in django
I use django_rest_framework. I need parse huge xml file then find some data. Parse xml on get call is bad idea because is too long time. I try once a 3 minute parse it and save parsed object to global variable. But I'm not sure about it work correctly. Example: class MyView(APIView): catalog = None parse_time = 0 @classmethod def get_respect_catalog(cls): if time.time() - cls.parse_time > 300: cls.catalog = parse_xml() cls.parse_time = time.time() return cls.catalog def get(self, request): vals = catalog.xpath('tag/text()') # here i find some tag ... return response I sent several requests but many time variable parse_time had value 0. As if class MyView recreate sometimes and class variables "catalog" and "parse_method" resets to init values. I think it because uwsgi have many workers and many interprets. May be exists way for using global variables in django. P.S. I know for my case I need use database. But I want use global vars. -
adding items from products to card (Django-views-codes)
I am fairly new and working on a project and just want to add products to the basket and I'm getting this Error: "AttributeError at /productapp/basket/add/Django Tutorial/ Manager isn't accessible via Basket instances" I think the problem is the view code but don't know how to fix it. Can anybody help me? Thank You. Models: class Products(models.Model): products_name = models.CharField(max_length=30) pub_date = models.DateTimeField(auto_now=True) price = models.CharField(max_length=10) note = models.CharField(max_length=200) inventory = models.IntegerField(default=1) product_pic = models.ImageField(upload_to ='images/', default='images/broken/broken.png') def __str__(self): if (self.inventory<=0): return self.products_name + ' (Out of Stock)' return self.products_name class Basket(models.Model): products = models.ForeignKey(Products, on_delete=models.CASCADE) pub_date = models.DateTimeField(auto_now=True) amount = models.IntegerField(default=1) def __str__(self): return str(self.products) urls: app_name = 'productapp' urlpatterns = [ path('products/', views.products, name='products'), path('basket/', views.basket, name ='basket'), path('', views.home, name='home'), path('basket/add/<str:name>/', views.addtobasket, name='addtobasket'), ] views: def products(request): products_list = Products.objects.order_by('-pub_date') context = {'products_list': products_list} return render(request, 'productapp/products.html', context) def basket(request): basket_list = Basket.objects.order_by('-pub_date') context = {'basket_list': basket_list} return render(request, 'productapp/basket.html', context) def addtobasket(request, name): basket = Basket.objects.all()[0] product = Products.objects.get(products_name=name) basket.objects.add(products=product) return HttpResponseRedirect(reverse("basket")) Html: <body> <section class="products_section"> <h1 class="products_section_h1" style="color: #ffffff;">Our Tutorials</h1> {% block content %} {% if products_list %} {% for product in products_list %} <div class="products"> <div class="product"> <img src="../{{product.product_pic}}" style="width:200px; border: 2px solid #051218;"> … -
Django object creation happens infinitely
I have a class connectTo defined in myclass.py which will connect to lets say a TCP socket and importing the same in views.py. I wrote an ajax to call the views function which creates object for my class as below views.py from myclasses import connectTo def connect(request): connectTo() return JsonResponse("Success") but the problem is as long as django server is running the connection to the TCP socket is happening. It should happen only once when connect in views.py is called instead it keeps on creating object and establishes TCP connection and stops if I close django server. -
Django admin inlines - how to remove empty records from create/update form
I'm using StackedInline to add related objects in my Django admin form (relation is one to many). The problem is that it renders three empty inline forms by default when creating new object like in this example: What I want is to render only "Add" button because the related objects are so rare that most of the records don't have these (or at least single empty record) and my related object is much larger than the one on the pictures. It should look something like this example: How can I do this? -
How to redirect from a view in one app to a view in another app?
I have two apps members and ctr member app handles the login, registration and logout and ctr will handle some admin stuff in page named foradmin.html. I want to redirect to from member/views.py to ctr/views.py after the login has been done. Please tell me how can I do it member/views.py def loginpage(request): if user is not None: login(request, user) if user.is_superuser: return redirect('foradmin') #this foradmin page is included in ctr urls @login_required(login_url='login') @allowed_user(allowed_roles=['admin']) def foradmin(request): return render(request, 'foradmin.html') #I want to redirect this ctr app this is also written in ctr/views.py member/urls.py urlpatterns=[ path('register',views.registerpage, name='register'), path('login', views.loginpage, name='login'), path('logout', views.logoutUser, name='logout'), path('ricktest', views.ricktest, name='ricktest'), path('forstaff', views.forstaff, name="forstaff"), path('foradmin', views.foradmin, name="foradmin"), ] ctr/views.py @login_required(login_url='login') @allowed_user(allowed_roles=['admin']) def foradmin(request): return render(request, 'foradmin.html') ctr/urls.py urlpatterns=[ path('foradmin', views.foradmin, name="foradmin"), ] Final Note: I want that after the conditions of login are met this should redirect to ctr app -
How to implement Biometric Authentication in a ReactJS Web Application
I currently have a web application set up using ReactJS for the front-end, Django and Apache Guacamole for the back-end and MariaDB for the database. I also have a Secugen Hamster Plus Fingerprint Scanner which when plugged in to the computer, will be used for user authentication on the login page of the web application (using ReactJS). Does anyone know how I can go about writing code to retrieve fingerprint images from the database to compare them with the user-inputted fingerprint when he attempts to login? I have been unsuccessful in finding any working examples or documentation for reference on the Internet.
