Django community: RSS
This page, updated regularly, aggregates Django Q&A from the Django community.
-
503 DNS Service Unavailable Error in Django when calling Google Data QnA API
I am trying to create a Django web application where a user can search for data in a simple search bar. The user input is then used to call Google's Data QnA API, where the data is received from BigQuery and translated to natural language so that the user has a readable response. However, when I attempt to call the API, I get a 503 Service Unavailable Error. When I call the API locally in my terminal, it works fine. Here is my code: views.py from django.shortcuts import render import os from google.api_core.client_options import ClientOptions from google.cloud.dataqna import AutoSuggestionServiceClient, Question, QuestionServiceClient from google.cloud import bigquery client_options = ClientOptions(api_endpoint = f"us-dataqna-googleapis.com:443") suggest_client = AutoSuggestionServiceClient(client_options = client_options) questions_client = QuestionServiceClient(client_options = client_options) bq_client = bigquery.Client() def index(request): return render(request, 'index.html') def response(request): os.environ["GOOGLE_APPLICATION_CREDENTIALS"] = "[path to .json]" project = "[project name]" location = "us" scope = f"[scope of project]" parent = questions_client.common_location_path(project, location) if request.method == "POST": title = request.POST.get("q") question = Question(scopes = [scope], query = title) question_response = questions_client.create_question(parent = parent, question = question) chosen_interpretation_index = 0 question_response = questions_client.execute_question(name = question_response.name, interpretation_index = chosen_interpretation_index) chosen_interpretation = question_response.interpretations[chosen_interpretation_index] bigquery_job = chosen_interpretation.execution_info.bigquery_job job = bq_client.get_job(bigquery_job.job_id, bigquery_job.project_id, bigquery_job.location) job_results = job.result() headers … -
Django view not redirecting after AJAX POST request
I've switched from sending data from a <form> to building a JSON string myself and sending that to the server. I was expecting that after sending a POST request to my view that the browser would render the JSON response -- basically, show me a page of the posted JSON data. That was the case when I submitting via a form POST request. What actually happens is that the browser doesn't do anything. But I can nevertheless see that the server is sending the right response to the browser. But why doesn't the page redirect to show the JSON data? javascript.js async function submit() { let response = await fetch('/cartography/', { method: 'POST', body: JSON.stringify({test: "test"}), headers: { "Content-Type": "application/json;charset=utf-8", "X-CSRFToken" : csrfToken.value, }, }) } views.py def cartography_view(request): if request.method == 'POST': request_data = json.loads(request.body) json_data = json_dumps(request_data) return JsonResponse(json_data) # <-- doesn't redirect. but why? urls.py path('cartography/', cartography_view, name = 'cartography'), home.html <button class="pushable" onclick="submit"/>submit to cartography</button> -
Convert a Queryset object to a model instance
I have two models as following: class Genre(models.Model): name = models.CharField(max_length=20) def __str__(self): return self.name class Book(models.Model): genre= models.ForeignKey(Genre, related_name="book", on_delete=models.CASCADE) name = models.CharField(max_length=20) def __str__(self): return self.name def save_book(book_list): #book_list is a list of dict: [{'name': 'xxx', 'genre': 'xxx'}, {...}] for book in book_list: book_genre = book['genre'] genre= Genre.objects.get(name=book_genre ) book = {'name': book['name'], 'genre': genre} new_book = Book(**book) new_book.save() In the code above, instead of hitting the database with each Genre.objects.get(name=book_genre ), I want to use Genre.objects.all() to get all of them at once. However, this code: def save_book(book_list): #book_list is a list of dict: [{'name': 'xxx', 'genre': 'xxx'}, {...}] genres= Genre.objects.all() for book in book_list: book_genre = book['genre'] genre= genres.filter(name=book_genre) book = {'name': book['name'], 'genre': genre} new_book = Book(**book) new_book.save() gives the error ValueError: Cannot assign "<QuerySet [Genre:]>": "Book.genre" must be a "Genre" instance. How do I convert a member of the queryset to a model instance to be assign along foreign key as above? -
Customize PointField serialization
I want to rename keys in PointField from drf_extra_fields.geo_fields import PointField E.g i want to rename key 'latitude' with 'lat' I found in github source code of PointField https://github.com/Hipo/drf-extra-fields/blob/252e681765645322113f69131e786664f815b919/drf_extra_fields/geo_fields.py and created my own class class MyPointField(PointField): """ Intended to rename fields 'longitude' -> 'lng' 'latitude' -> 'lat' """ def to_representation(self, value): """ Transform POINT object to json. """ if value is None: return value if isinstance(value, GEOSGeometry): value = { "lat": value.y, "lng": value.x } if self.str_points: value['lng'] = smart_str(value.pop('lng')) value['lat'] = smart_str(value.pop('lat')) return value I am using this field in serializers.py class ConstructionSerializer(serializers.ModelSerializer): coordinates = MyPointField() But I have an error "coordinates": [ "Enter a valid location." ] How can I fix the error? -
having problem in mapping my geojson data on html page using Django
how can I show my shape files- polygons on my website? I want to show my polygons on map but I cannot find the way. what should I do? Could you Please help me? Thanks These are my codes : my polygons/view.py( I want to show the "master_plan_dataset" on map): from django.http import HttpResponse from django.shortcuts import render from django.views.generic import TemplateView from django.core import serializers from .models import master_plan from djgeojson.views import GeoJSONLayerView class HomepageView(TemplateView): template_name = "index1.html" def master_plan_dataset(request): master_plans = serializers.serialize('geojson', master_plan.objects.all()) return render(request, 'layers.html', {'master_plans': master_plans}) my polygons/urls.py: from django.conf.urls import include, url from djgeojson import views from . import views urlpatterns = [ url(r'^$', views.HomepageView.as_view(), name='home'), url(r'^master_plan_dataset/$', views.master_plan_dataset, name='master_plan') ] my polygons/models.py: class master_plan(models.Model): id = models.IntegerField(primary_key=True) Landuse = models.CharField(max_length=100) Shape_Area = models.FloatField(null=False) Name_per = models.CharField(max_length=100, default=None) geom = models.MultiPolygonField(srid=4326) def __str__(self): return self.Name_per def __unicode__(self): return self.Name_per class Meta: verbose_name_plural = 'master_plan' and also my Html template => layers.html: <!DOCTYPE html> <html lang="en"> {%load static%} {%load leaflet_tags%} <head> {%leaflet_js%} {%leaflet_css%} <meta charset="UTF-8"> <title>homepage</title> <style type="text/css"> #gis {width:80%;height:500px;} </style> <script type="text/javascript" src="{% static 'dist/leaflet.ajax.js' %}"> </script> </head> <body> <h3> THE WEB SPATIAL DATABASE </h3> <br> <div> <script type = "text/javascript"> function display_layers(map, options) { var … -
Traefik and Django on a Subpath
Following setup I want to achieve inside Docker with Traefik and Django: http://domain/app1 http://domain/app2 My docker-compose.yml contains the following labels for the containers: traefik.http.routers.app1.rule=Host(my.host.de) && PathPrefix(/app1) traefik.http.routers.app1.middlewares=app1 traefik.http.middlewares.app1.headers.customresponseheaders.SCRIPT_NAME=/app1 I did the same for app2. In the settings.py of both apps I set: FORCE_SCRIPT_NAME = env('FORCE_SCRIPT_NAME', default=None) which then should get resolved via the ENV File where I have FORCE_SCRIPT_NAME=/app1. On Django side I always get a 404 with the message that this path does not exist and I should choose from an existing one. Django recognizes the URL as http://my.host.de/app1 and tells me The current path, app1, didn't match any of these. -
Sending a text + HTML email with a calendar ICS attachment in Django or Python
I've been searching for a library or at least functional snippet of code that lets me send an e-mail from Django (or at least in Python) with text content, HTML content, and an ICS calendar attachment that is recognized by every major e-mail client. For my particular use case it's enough if the user is offered an 'add to calendar' button. I feel like this should be a solved problem by now, but I'm only finding answers that refer to libraries that aren't being maintained or that are outdated or incomplete in some other way. I've tested a couple of snippets that will attach an ICS file, but G-mail doesn't give me the option of adding it to the calendar like it usually does. Is there a ready made solution that I'm missing? -
face detection using Django, Python, OpenCV
i want to run the camera on the browser and to use the device's camera to be able to access the attendance for many students from my pc .. but openCV using the main device camera so when i try to run share it with other pc it opens my camera not the one who using it -
How do I add a search TextField in Django?
I am using Django as my WebFramework. I have a Database that we want to search through. To enable a search with auto-completion we use ElasticSearch as library. There we have a method that takes a string as input and returns a list of relevant similar strings. Now we want to add a TextField on our website that displays these suggestions. As soon as the user enters a character into the textfield the function mentioned above should be called and the strings that come as return parameter should be displayed. The input should be updated after each additional character entered. In the following I have a small graphic to better illustrate my desired behavior. Is there a nice way to implement such a thing in django? If it doesn't work with django I would be happy if you steer me in the right direction which tools etc. I have to use. -
Deploy web application that has a .data-00000-of-00001
I have a django project that is basically a API for a chatbot, the chatbot uses tensorflow and it uses a extremely large file that ends in .data-00000-of-00001. I can not upload it to github because it is really big. Anyone knows how can I deploy my web application with this kind of file? -
django orm multiple filter on same many to many field
class Book(models.Model): title = models.CharField(max_length=50) authors = models.ManyToManyField(Author) class Author(models.Model): first_name = models.CharField(max_length=30) last_name = models.CharField(max_length=40) Suppose I want to get books having atleast two author's whose first names are Test and Tester.So I will proceed with Book.objects.filter(first_name='Test').filter(first_name='Tester') What if I have multiple first name(long list) to check,apart from running a for loop and rawsqlquery are there other options? queryset = Book,objects.all() for i in ['test','tester']: queryset = queryset.filter(first_name=i) -
Callback URL mismatch. Django.Auth0
enter image description here enter image description here enter image description here Please,solve it -
Is there python library or way to read text and image at once from database such as excel and sql? [closed]
For example, my database table looks like: Name Image tiger -
Data changing when multiple users are logged in
I'm making a Django app with Discord OAuth2 so users can log in. When 2 users log in, the data appears on both screens. So if you log in, it'll show your data but if you reload the page, it'll show another user's data. Does anyone know why this happens? Urls.py from django.urls import path from home import views urlpatterns = [ path('', views.main, name='home'), path('/logout', views.discord_logout, name="logout"), path('/settings', views.guild_dashboard, name='guild_dashboard'), path('/settings/edit', views.edit, name='edit'), path('/session_expired', views.session_expired, name='session_expired'), path('/authorize/user', views.main, name='get_authenticated_user'), path('/oauth2/login', views.discord_login, name='oauth2_login'), path('/oauth2/login/redirect', views.discord_login_redirect, name='discord_login_redirect'), ] Views.py from django.shortcuts import render from django.http import HttpResponse, HttpRequest, JsonResponse, HttpResponseRedirect from django.shortcuts import redirect from django.contrib.auth import authenticate, login, logout import requests from django.contrib.auth.models import User from home.auth import DiscordAuthenticationBackend from django.contrib.auth.decorators import login_required from .forms import Prefix import psycopg2 import aiohttp import matplotlib.pyplot as plt import numpy as np import time client_id = "client_id" @login_required(login_url="app/oauth2/login") def main(request: HttpRequest): username = user['username'] guild = [guild for guild in guilds if int(guild["permissions"]) & 0x00000020 == 32] try: connection = connection except: print("ERROR: unable to connect to the database") db = connection.cursor() query = db.execute("select server_count from info") servers = db.fetchone() servers = servers[0] query = db.execute("select user_count from info") users = db.fetchone() … -
Django cannot login with email
I'm trying to login with the email instead of the username. I don't know what I did wrong here. I filtered the DB from the Player instance in models.py which uses AbstractUser. import requests from django.shortcuts import render, redirect from django.contrib.auth.forms import UserCreationForm from django.contrib.auth import authenticate, login, logout from django.contrib import messages from django.views.decorators.csrf import csrf_exempt from django.views.decorators.csrf import csrf_exempt from .forms import PlayerCreationForm from .models import Player # REGISTER VIEW def register_view(request): if request.method != 'POST': form = PlayerCreationForm() else: form = PlayerCreationForm(request.POST) if form.is_valid(): form.save() requests.post('http://127.0.0.1:5000/credentials', json={'email': form.cleaned_data['email'], 'username': form.cleaned_data['username'], 'password': form.cleaned_data['password2']}) return redirect('/login') context = {'form': form} return render(request, "register.html", context) # LOGIN VIEW def login_view(request): if request.user.is_authenticated: return redirect('/') if request.method == 'POST': email = request.POST.get('email') password = request.POST.get('password') user = Player.objects.filter(email=email, password=password) if user is not None: login(request, user) return redirect('/') else: messages.info(request, 'Incorrect email or password') return render(request, 'login.html') # LOGOUT VIEW def logout_view(request): logout(request) return redirect('/') # HOMEVIEW def home_view(request): return render(request, "base.html") I was given the error of Internal Server Error: /login/ Traceback (most recent call last): File "/home/stevek/.local/lib/python3.9/site-packages/django/core/handlers/exception.py", line 47, in inner response = get_response(request) File "/home/stevek/.local/lib/python3.9/site-packages/django/core/handlers/base.py", line 181, in _get_response response = wrapped_callback(request, *callback_args, **callback_kwargs) File "/home/stevek/Projects/Python/CRAFTMINE/web/accounts/views.py", line 39, … -
Can I easily "rewrite" an extension using Django staticfiles?
I have a file within my Django project: my_app/static/my_app/bonus_feature.mjs which I have been using via: <script type="module" src="{% static "my_app/bonus_feature.mjs" %}"></script> This is not a public-facing part of the site and does not need to support older browsers, so it doesn't get transpiled or compressed or any fancy build process — I just need it served as a simple static file. Except, with one difference… It turns out the server does not know about the .mjs extension and serves this file as Content-Type: text/plain, causing browsers to refuse to run that code. Ideally/eventually the IT staff running the server can hopefully add the right MIME type but until then I'm looking for an easy workaround. The most obvious workaround would be to rename the file with a .js extension instead, but that introduces a headache on the development side as the linter is set up differently for .js files vs. .mjs files and will get upset with the code if it has a .js extension. Is there a way to tell the django.contrib.staticfiles app to rename the "as-served" extension to .js while keeping the "in-repo" extension as .mjs? The idea being that I could keep editing the file as a … -
How do I get cryptocurrency prices and make some calculations and post it in a list with Django?
I'm newby with Django and I have to deliver some homework. So I want to create a super simple web page that a user can come and write what cryptocurrency coin and how much of it he/she has bought and submits it. On the next page, there will be some posts that show that info again, cryptocurrencies price, and the website does some calculations that I determine and posts it(eg. 10% lower than buying price)...at last there will be a list of purchases that the user has submitted. I have stocked in this problem for weeks now, can you please guide me through it or write its code so I can study it? -
Django - How to trigger views function with html button action
I have another NoReverseMatch that I don't understand.+ In my eyes, what should be happening is: 1. User presses button to submit form <button type="submit" action="{% url 'APP_NAME:image_gen' %}">Run</button> 2. The request passes through my URL pattern, which triggers the views function. path('image_gen/', views.image_gen, name='image_gen'), 3. The action sends a request to the views function, which generates an image. def image_gen(request): save_image(path) return render(request, 'APP_NAME/page.html', {'title': 'page'}) There's a lot less going on here than in my actual site, but it works in the same way. Why isn't it working? -
Django Window functions
Question How do I calculate the delta of a column between two consecutive rows in my database using the Django ORM? Background I have the following model: class Foobar(models.Model): foo = models.IntegerField() I want to calculate the delta between foo for each row in the database. I found Django's support for Window functions and the Lag() function. With those in hand, I tried something like this: Foobar.objects.annotate(delta=Window(expression=F('foo') - Lag('foo'))) which gives the following error: Traceback (most recent call last): File "/usr/lib/python3.8/code.py", line 90, in runcode exec(code, self.locals) File "<input>", line 1, in <module> File "/home/llund/.cache/pypoetry/virtualenvs/scraper-2Ye6bxs0-py3.8/lib/python3.8/site-packages/django/db/models/expressions.py", line 1275, in __init__ raise ValueError( ValueError: Expression 'CombinedExpression' isn't compatible with OVER clauses. So to simplify, I just tried to annotate each row with the value from the previous row: fs = Foobar.objects.annotate(prev=Window(expression=Lag('foo')) for f in fs: print(model_to_dict(f)) The resulting dicts in my print() statement don't have 'prev', though. What am I missing? What is the correct way to use Lag() to calculate the delta between each row? -
logging updates to fields of djagno model in a jsonfield
I have been using logging the updates to any field of a django model with a jsonfield. class User(models.Model): phone_number = models.CharField(max_length=15) email_field = models.TextField() updates_log = models.JSONField(default=list) def save_phone_update_log(self, old_phone, new_phone): self.updates_log.update({"old_phone":old_phone,"new_phone":new_phone, "updated_at":datetime.datetime.now()}) self.save(updated_fields=["updates_log"]) Now I want to do it for all the fields , what could be an optimized implementation? -
Queries related to Google cloud storage and Aws bucket for file storage
there.I am moving forward to use google cloud services to store Django media files. But one thing that stops me is about the Google and Amazon free tier. I had read the google cloud docs but I am confuse about many things. For free tiers, New customers also get $300 in free credits to run, test, and deploy workloads. What I want to know is if they are gonna automatically charge me for using the cloud-storage after 3 months of trial is over because I am gonna put my bank account. This case is same on Aws bucket which allows to store mediafiles for 1 year after then what's gonna happen. Are they auto gonna charge me? -
Download file from internet into server (django)
How to download a file from internet into server. I wanted to download a file from internet to my server and from server I would like to upload it to youtube or something else. Every thing should be done on server. -
Django return home page in get absolute url
My urls urlpatterns = [ path('', views.home, name='blog-home'), path('about/', views.about, name='blog-about'), path("post/new/", PostCreateView.as_view(), name="post-create"), ] Once I do a post my site crashes since I need to specify a get_absolute_url. I just want to return to the home page but trying redirect("") fails with error NoReverseMatch at /post/new/ Reverse for '' not found. '' is not a valid view function or pattern name. How can I return to the homepage ? -
Django one custom model field to two db columns
I would like to create a custom field that receives a datetime string and store data in two db columns. I am reading django doc but not getting how to do it with more than one db column. It is a legacy db, so I can not change db tables layout. I have this model right now. class MyModel(models.Model): mixing_datetime = models.DateTimeField() mixing_datetime_utc_offset_seconds = models.IntegerField() I would like to create a field that lets the front end (it is an API with DRF) just send a datetime string (instead of datetime and offset separately), and let the backend do the work behind the scenes. So the idea would be: class MyModel(models.Model): mixing_datetime = models.DateTimeField() mixing_datetime_utc_offset_seconds = models.IntegerField() datetime = MyCustomDatetimeField() # This also should not be sent to db How can I achieve it? -
Django return method parameter
I was watching a tutorial on django and the guy added the following line of code, however he didnt exactly explain what it does. return '%s - %s' django the full code line is: def __str__(self): return '%s - %s' % (self.post, self.author) and i do understand it, just not that return part. Anyone mind clearing it out for me.
