Django community: RSS
This page, updated regularly, aggregates Django Q&A from the Django community.
-
login failed with correct password in django
I got an error in Django (3.1.7) when trying to login here is screenshots form.py views.py error -
How do I authorize a Google user in Python backend with ID token coming from iOS application?
Following the documentation here, I am trying to authenticate a user in my iOS app and pass their ID token to my backend. The backend handles the Google API interactions for the iOS app. I am missing how to actually authenticate that user in the backend. I read over the docs here regarding ID tokens but I am confused on where the service account comes into play. Current endpoint: @api_view(['POST']) @authentication_classes([TokenAuthentication]) @permission_classes([IsAuthenticated]) def google_token_info(request): try: token_obj = json.loads(request.body) token = token_obj['id_token'] id_info = id_token.verify_oauth2_token(token, requests.Request(), settings.IOS_CLIENT_ID) # create session here - how? While testing I had authentication set up via my backend. I had code like this: def google_auth(request): web_flow = flow.Flow.from_client_secrets_file(creds, scopes=scopes) web_flow.redirect_uri = request.build_absolute_uri(reverse('api.auth:oauth_callback')) auth_url, state = web_flow.authorization_url(access_type='offline', include_granted_scopes='true', prompt='consent') request.session['state'] = state return redirect(auth_url) def oauth_callback(request): success_flow = flow.Flow.from_client_secrets_file(creds, scopes=scopes, state=request.session.get('state')) success_flow.redirect_uri = request.build_absolute_uri(reverse('api.auth:oauth_callback')) auth_response = request.build_absolute_uri() success_flow.fetch_token(authorization_response=auth_response) credentials = success_flow.credentials if not request.session.get('google_credentials'): request.session['google_credentials'] = _credentials_to_dict(credentials) return redirect(reverse('api.auth:success')) Which setup session credentials for the user. I'm assuming I need something similar, but I am unsure how to create a session without actual credentials. -
Django Editing JsonResponse
How I can add "points = " to this JsonResponse in Django? My code look like this: return JsonResponse(data=points, safe=False, json_dumps_params={'indent': 1}) Result : [ { "x": 0, "y": 1 }, { "x": 0.315397047887207, "y": 0.694608645422627 } ] what I want to do : points=[ { "x": 0, "y": 1 }, { "x": 0.315397047887207, "y": 0.694608645422627 } ] -
How to filter only request.user in online_users
I am Building a BlogApp and I am stuck on a Problem What i am trying to do I am trying to access only request.user online status in template. BUT it is showing all the active users. What i am doing I am using online_users_activity to know which user is online. The Problem It is showing all the users that are online. views.py def online(request,user_id): user_status = online_users.models.OnlineUserActivity.get_user_activities(timedelta(hours=87600)) users = (user for user in user_status) context = {'users':users} return render(request, 'online.html', context) I don't know what to do. Any help would be Appreciated. -
Using Salesforce Custom Fields from Heroku Connect in a Django app
I have a Heroku app which uses Heroku Connect to connect to my Salesforce org. I created a custom object in Salesforce and that data is syncing successfully to Heroku. I also have a Django app I am building to serve as the front end of my heroku app, which uses a Postgres database. The problem is that in Salesforce, custom objects and custom fields are appended with __c and there's no way to get around that, but in Django, __ cannot be used as in a Object/Table name or a field name. Below is my models.py class in Django: from django.db import models from django.utils import timezone from django.contrib.auth.models import User from django.urls import reverse class MyCustomObject__c(models.Model): # New class that matches the name of the object I created in Salesforce name = models.TextField() # Unrestricted text def __str__(self): return self.name # return name when MyCustomObject__c.objects.all() is called However, when I run python manage.py makemigrations to create that table in Django, I get the error: blog.MyCustomObject__c: (models.E024) The model name 'MyCustomObject__c' cannot contain double underscores as it collides with the query lookup syntax. Does anyone know how I could access the data for a Custom Object that's stored in … -
Handling Form to submit API call and display API result in the same page
I'm starting with Django journey and I'm quite confused about what I have to do here. I appreciate any help. So, basically, I'm using Form to get data and from that data, I will use a specific solution API to create a site using the information from this form. I would like to get the data from this form, create the site using the APIs, but I would like to get the API result data and display the content on the same form page but below the submit bottom. I was able to create the basic form, get the necessary data and create the site using API call, but I have no idea what I have to do to get the API result and display it in case of success. `` from django import forms from django.core.exceptions import ValidationError class SiteForm(forms.Form): site_name = forms.CharField(max_length=100, label="Site Name", widget=forms.TextInput(attrs={'placeholder': 'Demo API'})) country = forms.CharField(label="Country", widget=forms.TextInput(attrs={'placeholder': 'Country',})) time_zone = forms.CharField(max_length=100, label="Timezone", widget=forms.TextInput(attrs={'placeholder': 'City'})) location = forms.CharField(max_length=200, label="Location", widget=forms.TextInput( attrs={'placeholder': 'Street'})) I don't know if this is the best code, but the POST is working at least, I can create my site using the API call. My views.py from django.shortcuts import render import requests, … -
Django Errors, Login and Signup forms works with standard methods but not with Class Based Views
I wanted to ask you for your help. I wanted to rewrite my authentication with Class Based Views. I found several tutorials, they are all telling the same. urls.py: # Authorization: path('signup/', views.SignUpView.as_view(), name='signup'), path('login/', auth_views.LoginView.as_view(), name='login'), path('logout/', auth_views.LogoutView, name='logout'), views.py: class SignUpView(generic.CreateView): form_class = UserCreationForm success_url = reverse_lazy('home') template_name = 'registration/signup.html' And this is part of my signup.html: <div class="jumbotron jumbotron-fluid vertical-center"> <div class="container"> <div class="d-flex justify-content-center"> {% if error %} <div style="text-align: center;"> <div class="alert alert-danger" role="alert">{{ error }}</div> </div> {% endif %} <div class="row w-75"> <div class="col-md-12"> <h1>Sign Up:</h1><br> <form method="post"> {% csrf_token %} <div class="form-group"> <label for="exampleInputEmail1">Username:</label> <input type="text" class="form-control" name="username" aria-describedby="emailHelp" placeholder="Enter username. It will be visible for others." required> </div> <br> <div class="form-group"> <label for="exampleInputPassword1">Password:</label> <input type="password" class="form-control" name="password1" id="exampleInputPassword1" placeholder="Password. Please make it strong and unique." required> </div> <br> <div class="form-group"> <label for="exampleInputPassword1">Confirm Password:</label> <input type="password" class="form-control" name="password2" id="exampleInputPassword1" placeholder="Repeat password from above." required> </div> <br> <button type="submit" class="btn btn-lg btn-success">Sign Up</button> </form> </div> </div> </div> </div> </div> And it is not working. I can see in console that POST 200 was sent but there is no redirect to home page. When I try to login nothing is happening. Also no errors are … -
'QuerySet' object has no attribute 'email'
I found an error of QuerySet object has no attribute 'email'.. i tried my best to solve the problem but don't able to find a solution.. from django.http import HttpResponse from loginsystem.models import newUser from django.contrib import messages from django.core.exceptions import MultipleObjectsReturned def login(request): if request.method=='POST': try: userdetails=newUser.objects.filter(email=request.POST['email'] , password=request.POST['password']) print("username=", userdetails) request.session['email']=userdetails.email return render(request, 'home.html') Thanks -
Django field with setter won't update even when I change the setter
To begin I will provide a background on my project / the problem I am having. The question is at the end as it makes more sense with the information first. Thank you for reading. I have a Django model which is based around tracking stock data. The first thing I do in this model is assign a score to instances of my Equity model, based on data from an Article model. def fundamental_list(self): l_fund = [] filtered_articles = Article.objects.filter(equity__industry = self.industry) for filtered_article in filtered_articles: if(filtered_article.equity.equity_name == self.equity_name): l_fund.append([filtered_article.get_fun_score(), filtered_article.get_date(), filtered_article.id, filtered_article.title, filtered_article.get_source(), filtered_article.is_this_month()]) else: if (filtered_article.read_through == -1): l_fund.append([float(-1)*filtered_article.get_fun_score(), filtered_article.get_date(), filtered_article.id, filtered_article.title, filtered_article.get_source(), filtered_article.is_this_month()]) if (filtered_article.read_through == 1): l_fund.append([filtered_article.get_fun_score(), filtered_article.get_date(), filtered_article.id, filtered_article.title, filtered_article.get_source(), filtered_article.is_this_month()]) return l_fund I then initially assigned a weighted_score to my Equity as follows (in order to rank them). weighted_strength_minus = models.FloatField(db_column='weighted_strength_minus', default=0) def set_weighted_strength_minus(self): sys.stdout.flush() weight = 0.40 fundamental_data = self.fundamental_list() sentiment_data = self.sentiment_list() num_entries = len(fundamental_data) if (num_entries != 0): total = 0 for i in range(num_entries): total += (weight**i)*(fundamental_data[i][0]-sentiment_data[i][0]) total = total*(1-weight)/(1-weight**num_entries) self.weighted_strength_minus = total return total else: self.weighted_strength_minus = 0 return 0 However, this weighted_strength incorporated too much data and I only wanted to use data from the past two weeks … -
Django: cannot annotate using prefetch calculated attribute
Target is to sum and annotate workingtimes for each employee on a given time range. models: class Employee(models.Model): first_name = models.CharField(max_length=64) class WorkTime(models.Model): employee = models.ForeignKey(Employee, on_delete=models.CASCADE, related_name="work_times") work_start = models.DateTimeField() work_end = models.DateTimeField() work_delta = models.IntegerField(default=0) def save(self, *args, **kwargs): self.work_delta = (self.work_end - self.work_start).seconds super().save(*args, **kwargs) getting work times for each employee at a given date range: queryset = Employee.objects.prefetch_related( Prefetch( 'work_times', queryset=WorkTime.objects.filter(work_start__date__range=("2021-03-01", "2021-03-15"])) .order_by("work_start"), to_attr="filtered_work_times" )).all() trying to annotate sum of work_delta to each employee: queryset.annotate(work_sum=Sum("filtered_work_times__work_delta")) This causes a FieldError: Cannot resolve keyword 'filtered_work_times' into field. Choices are: first_name, id, work_times How would one proceed from here? Using Django 3.1 btw. -
unable to add rows and columns in spreadsheet in dash-plotly in django
I am trying to add rows and columns in spreadsheet in Django using Plotly-dash library but ,I am unable to add these in spreadsheet. I follow this link https://dash.plotly.com/datatable/editable (Uploading Data, uploading and removing rows and columns ). Can someone help me with code? Thanks in advance! -
Django related objects in hierarchy
I've got some models which relations like this: attribute: str name attribute_value: foreign attribute float value product: ManyToMany attribute_value page: ManyToManyField product Is there a way to search for a page that has products with attribute_value.attribute.pk == x and attribute_value.value == y? I've read about related objects but can I use them in this kind of relation, should I use some inner join or is there any other way I could use Django to filter it easily? -
How to select HTML Table rows by checkbox and adding to database?
Here is my Template : {% for pr in productlist %} <ul> <li><input type="checkbox" name="mylistch" value="{{ pr.productid }}"></li> <li><input type="hidden" name="mylist" value="{{ pr.productname }}"></li> <li><input type="number" name="mylist" id="prqty"/></li> </ul> {% endfor %} result is : 1 product1 23 2 product2 44 3 product3 23 4 product44 56 5 product5 12 6 product6 9 7 product7 76 Here i can get list of items via : pd = request.POST.getlist("mylist") and get selected items by checkbox via: pn = request.POST.getlist("mylistch") and View is : pch = request.POST.getlist('mylistch') pnch = iter(pch) pr = request.POST.getlist('mylist') pri = iter(pr) for pid, pname, ptotal in zip(pnch , pri , pri): models.Sellinvoiceitems.objects.create( productid=pid productname=pname, totalnumber=ptotal, sellinvoice = invoice, stockid = stock ) My problem is when i checked ids 4 , 5 , 6 via checkbox it returned ids 1 ,2 ,3. for each list it just returned first elements. how can i get id 4 ,5 ,6 which selected by checkboxes? -
uWSGI error when deploying Django app on Heroku
I'm trying to deploy a DRF app on Heroku but it keeps erroring out when building wheel for uWSGI. I'm on Heroku stack: Heroku-20 the latest The log on the command line appears like this: remote: Building wheel for uWSGI (setup.py): started remote: Building wheel for uWSGI (setup.py): finished with status 'error' remote: ERROR: Command errored out with exit status 1: remote: command: /app/.heroku/python/bin/python -u -c 'import sys, setuptools, tokenize; sys.argv[0] = '"'"'/tmp/pip-install-_2lmfods/uWSGI/setup.py'"'"'; __file__='"'"'/tmp/pip-install-_2lmfods/uWSGI/setup.py'"'"';f=getattr(tokenize, '"'"'open'"'"', open)(__file__);code=f.read().replace('"'"'\r\n'"'"', '"'"'\n'"'"');f.close();exec(compile(code, __file__, '"'"'exec'"'"'))' bdist_wheel -d /tmp/pip-wheel-8jh6k5it remote: cwd: /tmp/pip-install-_2lmfods/uWSGI/ remote: Complete output (221 lines): remote: /app/.heroku/python/lib/python3.8/distutils/dist.py:274: UserWarning: Unknown distribution option: 'descriptions' remote: warnings.warn(msg) remote: running bdist_wheel The full log on command line is too long to post here. But further down the log there is this warning: remote: plugins/python/python_plugin.c: In function ‘uwsgi_python_worker’: remote: plugins/python/python_plugin.c:1961:3: warning: ‘PyOS_AfterFork’ is deprecated [-Wdeprecated-declarations] remote: 1961 | PyOS_AfterFork(); remote: | ^~~~~~~~~~~~~~ remote: In file included from /app/.heroku/python/include/python3.8/Python.h:144, remote: from plugins/python/uwsgi_python.h:2, remote: from plugins/python/python_plugin.c:1: remote: /app/.heroku/python/include/python3.8/intrcheck.h:18:37: note: declared here remote: 18 | Py_DEPRECATED(3.7) PyAPI_FUNC(void) PyOS_AfterFork(void); A little further down I get the failed message: remote: plugins/router_basicauth/router_basicauth.c:73:5: error: ‘struct crypt_data’ has no member named ‘current_salt’ remote: 73 | cd.current_salt[0] = ~cpwd[0]; remote: | ^ remote: ---------------------------------------- remote: ERROR: Failed building wheel … -
Using custom manager for many-to-many relations?
I have two classes (Book and Question) that are linked by a ManyToMany relationship. In particular, I typically call book.questions.all() to get all the questions in a book. Now, for my Question class, I have a custom manager active_objects, which basically only return questions that are active. What I'm trying to do is when I call book.questions.all(), I only want to return the active questions of the book using my custom manager. I was looking at previous SO questions which recommended using base_manager_name but this doesn't seem to work for me. Upon checking the documentation, they said base_manager_name does not work for ManyToMany relationships (https://docs.djangoproject.com/en/3.1/topics/db/managers/). Does anyone have a good way to do this? Class Question(models.Model): objects = models.Manager() # The default manager. active_objects = CustomManager() # custom manager. books = models.ManyToManyField(Book, related_name='questions') class Meta: base_manager_name = 'active_objects' class Book(models.Model): pass -
Why modelformset always returns error "this field is required"?
I try to render modelformset in a template manually and when I hit submit button it gives an error saying that "This field is required.". I create modelformset like this: from django.forms import modelformset_factory ImageFormset = modelformset_factory(PostImages, fields=('image',), extra=0, can_delete=True) formset = ImageFormset(queryset=post.postimages_set.all()) And when I render modelformset like this, everything works: {{ formset.management_form }} {{ formset.as_p }} But when I render it like this I get an error: {{ formset.management_form }} {% for f in formset %} <img src="/media/{{ f.image.value}}" style="max-width: 400px;" alt=""> {{ f.image }} {{ f.DELETE }} {% endfor %} -
Django redirects or react history?
For some time I've been developing a django rest/react app. I'm still a newbie in this topic and most of the time I apply just-working solutions to my project. Gradually I'm lerning new things. There is this topic that bothers me. In my app I have this like 'main view' with a nav bar and a drawer (simply from material-ui). In drawer I've declared some buttons for navigation. Now the only view/layout changing is this empty space excluding nav bar and drawer (on the left). So it's facebook-like layout (with only middle part changing when navigating trough main stream or groups/pages). Those buttons in drawer use history.push() from react, as it was easiest to apply, but I wonder is it the right way ? Django has it's redirections, shouldn't I use those ? There is not much of a comparison between history and redirect. Something interesting I've found is: React-Router - Link vs Redirect vs History . Also, I've implemented a simple login and django auth, but with axios.posting I'm able to trace this this request in browsers network. Is there a better, or more important a safer way of requesting ? -
View.py changes not updating on Django site
New Django user. Hello world. Got it to work. "Hello, world!" in the browser. I went back into views.py and updated the line to read "Hello, world! You're at the index." and saved it. Refreshing the browser (F5) does not show the change. Even Ctrl-F5 doesn't refresh it. I'm running ./manage.py runserver, and it recognizes that the file was changed and reloads the site: /home/pi/pidjango/doorbell/views.py changed, reloading. Watching for file changes with StatReloader Performing system checks... System check identified no issues (0 silenced). March 14, 2021 - 14:00:19 Django version 3.1.7, using settings 'pidjango.settings' Starting development server at http://127.0.0.1:8000/ Quit the server with CONTROL-C. But refreshing the browser still shows the old line. I have to reboot the computer in order to see the change. But it does change, so I know the file is the correct one in the correct spot. I'm not even sure what this is called. It's some kind of cache that's not flushing, so I researched Django caching and couldn't find anything that helped. I'm running '''DEBUG = True''', so you'd think this would be a pretty common thing to do. This is on a headless Raspberry Pi, connected by SSH, so there's no local … -
communication feature in django / vuejs
I have been asked for a project to developp a communication feature for a website that is implemented in vue.js for the front-end and Django in back-end. The goal would be to have a video,voice and chat options and to have an option of constant surveillance like a baby monitor would do on one end. I have researched many options and found that WebRTC might solve this issue. However I am still looking for diverse already made options that would avoid me too much implementation work. Does somebody has a good advice or know some tools that could help me ? Thank you very much and have a great day! -
Pass parameters from Django template to view
I am pulling data from an API and passing it through to my template. I would like to give users a few options and to do so I need to pass those options from my template to the params for the API in my view. What is the best way to go about doing that? For instance, I am rendering a game schedule and I need to change the value for "league" or "date" in the params via a button click. view params = {"league": "nba", "date": "2021-03-14"} results = requests.request("GET", URL, headers=headers, params=params).json() -
Django: Add class to a div depending on a variable
I'd like to declare in the template a variable that allows me to position an image inside a section on the left or the right. I just don't understand how can I do it on the variable side. Here's my current code, main.html : {% with img_left=False %} {% include 'section-service.html' %} {% endwith %} section-service.html: <div class="sect_service-inside {% if img_left=True %} serv_img-left {% else %} serv_img-right {% endif %}"> <div id="here_img">...</div> <div id="here_text">...</div> </div> but I get the error Could not parse the remainder: '=True' from 'img_left=True' Note that I'll use this section multiple times in the main.html page, that's why I'd like to have the variable left-right. -
How to aggregateSUM all keyvalues(=cost) from a field(payment) (one to one relationship) of a model(Session)
I would like to traverse a (one to one relationship) field of session. Specifically the payment and for each Session-payment aggregate Sum all the payment.cost Something like for each session-payment (if payment exists) aggrSum all the cost VALUES. in my views.py (sthing gotta change) "TotalCost": ( sessions.values_list("payment").aggregate(Sum("cost")) ), models.py. (these are my stable files) class Payment(models.Model): id = models.UUIDField(primary_key=True, editable=False, default=uuid.uuid4) payment_req = models.BooleanField(default=False) cost = models.FloatField(blank=True, validators=[validate_positive]) invoice = models.CharField(max_length=100) user_id = models.ForeignKey(User, on_delete=models.CASCADE) # session_id = models.OneToOneField(Session, on_delete=models.CASCADE) def __str__(self): return str(self.id) class Session(models.Model): id = models.UUIDField(primary_key=True, editable=False, default=uuid.uuid4) payment = models.OneToOneField(Payment, on_delete=models.CASCADE) user_comments_ratings = models.TextField() def __str__(self): return f"Id = {self.id}" -
How to set custom model manager as a default model manager in Django?
I have multiple apps and models in Django project. Now i want to use custom model manager in all apps models. i don't want to write custom model manager query inside of every single model. I just want to know is that possible to set custom model manager as default models manager for all apps? manager.py class CustomQuerySet(models.Manager): def get_queryset(self): return super(CustomQuerySet, self).get_queryset().filter(status=True) -
Change the color of the icon in jquery (django project)
I added to the wish list for products.(django project) Users click on a heart-shaped icon if they add a product to this list. If a user has already added this product to the list, the heart icon is red, and if this product is not in the user's favorites list, the heart icon is white. I want to change the color of the icon each time I remove or add it to the list. In the code I wrote, this operation is done only once, and if it clicks again at the same time, there will be no change in color. {% if request.user in product.favourite.all %} <a href="{% url 'home:favourite' product.id %}" class="favourite-product fa-btn{{ product.id }}" data-id='{{ product.id }}' data-text="remove"> <i class="fa fa-heart test{{ product.id }}" style="color:red"></i></a> {% else %} <a href="{% url 'home:favourite' product.id %}" class="favourite-product fa-btn{{ product.id }}" data-id='{{ product.id }}' data-text="add"> <i class="fa fa-heart test{{ product.id }}" style="color:#eee;"></i></a> {% endif %} # ajax $(document).on('click', '.favourite-product', function (e) { e.preventDefault(); const likeText = $(`.fa-btn${product_id}`).attr("data-text"); const trim = $.trim(likeText) $.ajax({ url: $(this).attr('href'), type: 'GET', data: { 'product': product_id }, success: function (response) { if (trim === 'add') { $(`.test${product_id}`).css({"color": "red"}); } else { $(`.test${product_id}`).css({"color": "#eee"}); } }, error: … -
When I run my django project, I face this issue. Kindly help me to resolve this
Traceback (most recent call last): File "C:\Users\SARAVANAN\Envs\test8\lib\site-packages\django\core\handlers\exception.py", line 47, in inner response = get_response(request)
