Django community: RSS
This page, updated regularly, aggregates Django Q&A from the Django community.
-
Bad request (400) (unsupported syscall) when trying to reach container in Google Cloud Run
I have successfully deployed a Google Cloud Run instance, its showing a green checkmark and I get an address to access the container on. I can also see that the logs show that uwsgi is booted. When trying the container locally I can access it on the port I give it... I suspect that the incorrect booting of the system is due to this line: 019-12-04T21:44:45.834539783ZContainer Sandbox Limitation: Unsupported syscall setsockopt(0x3,0x6,0x9,0x29eebd3f8794,0x4,0x0). Please, refer to https://gvisor.dev/c/linux/amd64/setsockopt for more information. 2019-12-04T21:44:45.834891693ZContainer Sandbox Limitation: Unsupported syscall setsockopt(0x4,0x6,0x9,0x29eebd3f8794,0x4,0x0). Please, refer to https://gvisor.dev/c/linux/amd64/setsockopt for more information. 2019-12-04T21:44:45.835166ZuWSGI http bound on 0.0.0.0:8080 fd 4 2019-12-04T21:44:45.841985Zspawned uWSGI http 1 (pid: 3) 2019-12-04T21:44:45.844243Zuwsgi socket 0 bound to TCP address 127.0.0.1:48977 (port auto-assigned) fd 3 Does anyone have any tips on getting the container to run on Cloud Run? -
Nginx takes too long to send the network response using Django with Gunicorn
I'm developing a web application with Django, and so far everything seems ok, but I'm having a big problem with my server response, usually the first time I want to enter it takes around 20 to 40 seconds to get the response back from the server. I'm using a Linode linux virtual machine running Ubuntu 18.04, is a very cheap plan just for now with only one core CPU, 2GB of ram and 50Gb of SSD storage, however as I'm the only one accessing the website I feel it is not correct that it takes so long to response (It just happen every time I restart nginx or gunicorn, or after some time of inactivity, after it respond it start to work with a normal speed). I made a performance record with chrome dev tools and these were my results: Network result As you can see the network request took 22 seconds, and if I check the main thread I can see that chrome detects that time as idle, and the real time it takes the server to process the view is only a few milliseconds. Chrome results I also have my server with an SSL certificate, the config for … -
Is there a way to have a "nested" reverse relation ship in Django REST Framework
I have Three objects: Product, Attribute, Attribute_Category Right now they are structured like this, I start at the Product. class Product(models.Model): name_single = models.CharField(max_length=30, unique=True) Bla... bla... bla... Currently I have a ForeignKey relation from the attribute to the product and the attribute_category. class Attribute(models.Model): product = models.ForeignKey('Product', on_delete=models.CASCADE, related_name='products') attribute_category = models.ForeignKey('AttributeCategory', on_delete=models.CASCADE, related_name='attributes') And some more data... And at last the attribute_category. class AttributeCategory(models.Model): name_single = models.CharField(max_length=30, unique=True) Yet more things... I was thinking with this structure I can filter the objects for a specific attribute- or _category. Though now I am stuck, Is there any way I can go from the product, to the category of its attributes and then get the relevant attributes. This way I can structure my response like this: product1: [ {attribute_category1: [{attribute1}, {attribute2}] }, {attribute_category2: [{attribute3}] } ] I would like to know, how can I get the desired JSON. Am I missing something? Because it feels like I am grossly overcomplicating things. I realize that this question is incredibly messy and might be worded really bad. I will try to think up some way of making the problem worded better, if anyone has any tips on the problem, or rewording it … -
GeoDjango display map on template form from model
I am trying to build a sample website based on Django(GeoDjango) and OpenStreetMap. So far I have this simple scenario: Models.py class Parks(models.Model): park_name_en = models.CharField(max_length=256) description = models.TextField() picture = models.ImageField() geom = PolygonField() @property def picture_url(self): return self.picture.url def __unicode__(self): return self.title views.py def park_insert(request): form = ParkForm() return render(request, 'addpark.html', {'form': form}) forms.py class ParkForm(forms.ModelForm): class Meta: model = Parks fields = ('park_name_en', 'description', 'picture',) geom = forms.PolygonField() and last but not least the template addpark.html <html> <head> {{ form.media }} </head> <body> <div id="map"> <form enctype="multipart/form-data" method="post" action=""> {% csrf_token %} {{ form.as_p }} <input type="submit" value="Submit"/> </form> </div> </body></html> When I open the template page all fields come up right, except the PolygonField() which comes up as a text. How can I display a map on the user form also (I got it working in the admin panel, but I want to create a form for inserting new parks) -
Django factory boy post_generation in field with default value don't work
I have a model with a field that is a int type, that field have a default value I'm trying to set a value in that field with post_generation but nothing is happening, the field stay with the default value, when I try to use .set I get the following error: AttributeError: 'int' object has no attribute 'set' this is the field that I'm trying to populate @factory.post_generation def priority(obj, create, extracted, **kwargs): for series in range(obj.patrimony.count()): # this is a sequence of numbers series += 1 obj.priority.set(series) and this is the model, is just a simple model class Series(models.Model): priority = models.IntegerField(_("Priority"), default=0, null=True) Can someone open my eyes please? -
Complex Query from several models in django
I'm trying to query into three models. I need to get the amount products that are in the stores region location. These are my models: class Store(models.Model): name = models.CharField(max_length=255) logo = models.URLField(null=True, blank=True) user = models.OneToOneField(get_user_model(), models.CASCADE, related_name="user_store") region = models.CharField("Departamento", max_length=100) city = models.CharField("Ciudad", max_length=100) class Product(models.Model): name = models.CharField("Nombre del Producto", max_length=255) description = models.TextField() stock = models.PositiveIntegerField() seller = models.ForeignKey(User, on_delete=models.CASCADE) Product is related with user and it is related to store, what I want to do is something like this: { "Risaralda": 1523, "Cundinamarca": 8541 } where keys "Risaralda" and "Cundinamarca" are regions and values are the product amount in these places I tried something like this products = Product.objects.filter( seller__user_store__region__in=Store.objects.filter() .values("region").distinct()) And I got products in stores regions but i need to count how many products are in every store regions thank you a lot -
Django Session Form is not JSON Serialized
I'm trying to pass data from one view to another and im getting the following error . Exception Type: TypeError at /points/k8_points Exception Value: Object of type K8Points_ClassroomForm is not JSON serializable Here is my Views.py @login_required def K8_Points_Classroom(request): context_from_k8_points = request.session['k8_points_context'] if request.method == 'POST': form = K8Points_ClassroomForm() if form.is_valid(): form.save(commit=False) form.save() return render(request, 'points/k8_points_classroom.html', {'form': form}) else: return render(request, 'points/k8_pointsclassroom.html', {'form': form} ) else: form = K8Points_ClassroomForm() return render(request, 'points/k8_points_classroom.html', {'form': form} ) context_from_k8_points = request.session['k8_points_context'] @login_required def K8_Points(request): if request.method == 'POST': form = K8PointsForm(request.POST) if form.is_valid(): form.save(commit=False) classname = form.cleaned_data.get('class_name') date = form.cleaned_data.get('date') getstudents = Student.objects.filter(class_name = classname) students = getstudents.all() form = K8Points_ClassroomForm() context = {'form': form , 'students': students, 'classname': classname,'date': date,} request.session['k8_points_context'] = context return redirect('k8_points_classroom') else: return render(request, 'points/k8_points.html', {'form': form} ) else: form = K8PointsForm() return render(request, 'points/k8_points.html', {'form': form} ) Thank you for the help in advance ! -
QQplot using python and react
I want to display a qqplot in react webapp. My backend is Django and I can create a qqplot using import numpy as np import statsmodels.api as sm import pylab test = np.random.normal(20,5, 1000) sm.qqplot(test, line='r') pylab.show() sm.qqplot returns a matplotlib figure but I need the scatter plot and line data to send back to UI. Is there way extract that from the figure or is there a better way to do this ? -
Why can I access the Apache Tika server when using PyCharm but not from the command line?
I wrote a Python 3 program in PyCharm, and the program utilizes Apache Tika's parser. The relevant code looks like this. from tika import parser ... raw = parser.from_file(file_path) When I run the program using PyCharm, it works fine. I read that Java is required in order to access Tika, but as far as I know I don't have Java installed (interestingly, this post implies that Java is also needed for PyCharm). The only issue I experience is that I receive an error message as the program starts to run. So when I run the program in PyCharm, the initial output is... 2019-12-04 14:06:11,401 [MainThread ] [WARNI] Failed to see startup log message; retrying... and then the program runs successfully without me interacting with it. Parses beautifully. Well now I'm trying to use the same sort of Tika functionality in a Django project. I've got some code in views.py inside the Django project, and I can access it easily enough through urls.py. But when I add the Tika components and do my Django 'runserver' from the command line (the only way to do it as far as I know) this is what I receive. from tika import parser ... raw … -
Change bootstrap4 button "search" text
When I click to "Search" button on my site http://junjob.ru/ I go to http://junjob.ru/search/?q=&q2=ALL How can I change text "search" to "my_search" in this link? I need http://junjob.ru/my_search/?q=&q2=ALL I am using django web-framework. And fix should support queries from form My code vacancy_list.html <div class="container" style="margin-top: 40px; font-size: 2rem; padding-left: 0px;"> <form action="{% url 'search_results' %}" method="get"> <div class="row"> <div class="col-lg-8 col-md-6 col-xs-12"> <input name="q" type="text" placeholder="Search..." class="form-control"> </div> <div class="col-lg-3 col-md-4 col-xs-12"> <select name="q2" class="form-control" id="exampleFormControlSelect1"> <option>Other</option> </select> </div> <div class="col-lg-1 col-md-2 col-xs-12" style="padding-left: 0px;"> <button class="btn btn-primary">Search</button> <!-- BUTTON --> </div> </div> </form> </div> views.py class HomePageView(ListView): model = Vacancy template_name = 'vacancy_list/vacancy_list.html' paginate_by = 5 page_kwarg = 'vacancy' context_object_name = 'vacancies' queryset = Vacancy.objects.order_by('-published_date') def paginate_queryset(self, queryset, page_size): """Paginate the queryset, if needed.""" paginator = self.get_paginator( queryset, page_size, orphans=self.get_paginate_orphans(), allow_empty_first_page=self.get_allow_empty()) page_kwarg = self.page_kwarg page = self.kwargs.get(page_kwarg) or self.request.GET.get(page_kwarg) or 1 try: page_number = int(page) except ValueError: if page == 'last': page_number = paginator.num_pages else: raise Http404(_('Page is not “last”, nor can it be converted to an int.')) try: page = paginator.page(page_number) return (paginator, page, page.object_list, page.has_other_pages()) except InvalidPage as e: raise Http404(_('Invalid page (%(page_number)s): %(message)s') % { 'page_number': page_number, 'message': str(e) }) def vacancy_detail(request, pk): vacancy = … -
Django Social Auth - Google: AttributeError: 'NoneType' object has no attribute 'provider'
I am receiving this error when trying to login via google, I've tried just about everything I can think of and similar issues on SO don't seem to help. I have a custom user model setup as such: models.py from django.contrib.auth.models import AbstractUser from django.db import models class Departments(models.Model): name = models.CharField(max_length=255, unique=True) def __str__(self): return self.name class AlluredUser(AbstractUser): departments = models.ManyToManyField(Departments) def __str__(self): return self.username forms.py from django import forms from django.contrib.auth.forms import UserCreationForm, UserChangeForm from .models import AlluredUser class CustomUserCreationForm(UserCreationForm): class Meta: model = AlluredUser fields = ('username', 'email') class CustomUserChangeForm(UserChangeForm): class Meta: model = AlluredUser fields = ('username', 'email') Social Auth Pipeline SOCIAL_AUTH_PIPELINE = ( 'social_core.pipeline.social_auth.social_details', 'social_core.pipeline.social_auth.social_uid', 'social_core.pipeline.social_auth.auth_allowed', 'social_core.pipeline.social_auth.social_user', 'social_core.pipeline.user.get_username', 'social_core.pipeline.social_auth.associate_by_email', 'social_core.pipeline.user.create_user', 'social_core.pipeline.social_auth.associate_user', 'social_core.pipeline.social_auth.load_extra_data', 'social_core.pipeline.user.user_details' ) Error Traceback http://dpaste.com/12TG5RZ I'm guessing it has something to do with the custom user model I created since I didn't have this problem beforehand. Any help would be much appreciated. -
Django - Multiple Select Box - Save Changes to Database
I was able to get a multiple select box working for edit mode: <section class="container"> <div> <select id="leftValues" size="5" multiple></select> </div> <div> <input type="button" id="btnLeft" value="&lt;&lt;" /> <input type="button" id="btnRight" value="&gt;&gt;" /> </div> <div> <select id="rightValues" size="4" multiple> {% for device in devices %} <option>{{ device }}</option> {% endfor %} </select> </div> </section> <div> <input type="text" id="txtRight" /> </div> </section> But when I select the save button, after making changes to the table, again in the template, edit_maintenance.html, it does not feed into the database. I'm still fairly new to this so any tips, examples, would be great. -
How can I add CSS to my Django project website?
How can i add css to my django site? Map structure: pychache static css main.css templates Now I have this in my html: <!DOCTYPE html> <html lang="en" dir="ltr"> <head> <meta charset="utf-8"> <title>Portfolio</title> {% load static %} <link href="{% static './css/style.css' %}" rel="stylesheet"> </head> <body> <p>portfolio</p> </body> </html> -
How to "load" dependent drop down upon page load?
I have a form with a dependent drop-down. This secondary drop-down is hidden whenever the primary option selected does not have any secondary options, and when the page first loads. Whenever the form is submitted, only the first field gets cleared out, since most of the time the drop-downs remain the same, however, since the script works whenever there is a change in the primary drop-down, since the load upon does not constitute a change, it just keeps the selected/submitted option on the primary drop-down, and will just display an empty secondary drop-down, even when the primary option selected does have secondary options. I got most of the JS from the drop-down from a tutorial, as I am not very familiar with it. For a more visual understanding: This is the form when the page first loads When you select an option that has secondary options, the other dropdown appears After you select a Station and submit, the Employee # clears, but the other two are supposed to remain, however, when the page reloads upon submission, it looks like this, and the station has been cleared according to the debugger since there are none technically. I don't care so much … -
Upgrading to Django 3 from Django 2.2.x
I'm trying to upgrade Django 2.2.7 to Django 3. I have an Exception with the load of static library in my template when it's called by tag {% load static from staticfiles %}. Stacktrace: Internal Server Error: / Traceback (most recent call last): File "/usr/local/lib/python3.7/site-packages/django/template/defaulttags.py", line 1021, in find_library return parser.libraries[name] KeyError: 'staticfiles In the settings.py, staticfiles is config like this: STATICFILES_FINDERS = ( 'django.contrib.staticfiles.finders.FileSystemFinder', 'django.contrib.staticfiles.finders.AppDirectoriesFinder', ) STATICFILES_DIRS = [ os.path.join(BASE_DIR, 'static'), ] STATIC_URL = '/static/' And when requested by browser, Django answered: 'staticfiles' is not a registered tag library. Must be one of: admin_list admin_modify admin_urls cache i18n l10n log' Github code is here, PR is here Many thanks ! -
how do I connect my Django app with telegram to fetch channel messages?
I need some help in getting telegram messages in my Django app. I want to connect my django app with telegram user account and get the list of all channel. After user selects a specific channels, the messages of that channel should be displaying in my application The application should have the real-time messages. I'm using Mysql database to store the channel list and messages. Any help would be appreciated for this project. -
DataTable (JQuery): how to switch language with browser language?
I use DataTable in my Django project and currently doing internationalisation of my apps I would like DataTable change with browser language as for my templates. I have found the way to change language with DataTable option var table = $('#table_id').DataTable({ lengthMenu: [5,10], "language": { "url": "//cdn.datatables.net/plug-ins/9dcbecd42ad/i18n/French.json" } }); is their a simple way doing it? or should I test for browser language and have a switch to initialize var table? something like that (pseudocode): if browser.lang == 'english'{ var table = $('#table_id').DataTable({ lengthMenu: [5,10], }); } else { var table = $('#table_id').DataTable({ lengthMenu: [5,10], "language": { "url": "//cdn.datatables.net/plug-ins/9dcbecd42ad/i18n/French.json" } }); }``` -
Post a file to Django REST Framework without Headers/Footers
I am attempting to store a .csv file uploaded to Django REST Framework in its original format. I am following the instructions and the Django REST Framework page for uploading files. When I PUT a .csv file to a defined endpoint I end up waith a file with additional headers and footers. I am trying to save this file into a FileField in its original format so I can run some post-processing steps more easily. Steps I've taken: I created a model to store the file. from django.db import models class OriginFile(models.Model): uploaded_at = models.DateTimeField(auto_now_add=True) file = models.FileField(upload_to="origin_files/") And I created an APIView to handle the upload. from rest_framework import views from rest_framework.parsers import FileUploadParser from rest_framework.response import Response from reference.reference_model.models import OriginFile class OriginFileView(views.APIView): parser_classes = [FileUploadParser] def put(self, request, filename, format=None): f = request.data["file"] load_origin_file = OriginFile() load_origin_file.file.save(filename, f, save=True) return Response(status=204) What I am seeing: The first couple of lines of my original file look like: SPID,SA_ID,UOM,DIR,DATE,RS,NAICS,APCT,0:15,0:30,0:45,1:00,1:15,1:30,1:45,2:00,2:15,2:30,2:45,3:00,3:15,3:30,3:45,4:00,4:15,4:30,4:45,5:00,5:15,5:30,5:45,6:00,6:15,6:30,6:45,7:00,7:15,7:30,7:45,8:00,8:15,8:30,8:45,9:00,9:15,9:30,9:45,10:00,10:15,10:30,10:45,11:00,11:15,11:30,11:45,12:00,12:15,12:30,12:45,13:00,13:15,13:30,13:45,14:00,14:15,14:30,14:45,15:00,15:15,15:30,15:45,16:00,16:15,16:30,16:45,17:00,17:15,17:30,17:45,18:00,18:15,18:30,18:45,19:00,19:15,19:30,19:45,20:00,20:15,20:30,20:45,21:00,21:15,21:30,21:45,22:00,22:15,22:30,22:45,23:00,23:15,23:30,23:45,0:00 5001,5001,KWH,R,05/20/2018,A6,722000,100.0,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000200,0.022600,0.058100,0.100500,0.148500,0.251400,0.295800,0.359500,0.321400,0.365300,0.509800,0.571900,0.734700,1.121900,1.312700,1.358400,1.573900,1.270300,1.512500,1.359400,1.735500,1.759900,1.806400,1.501400,1.343900,1.396900,1.660400,1.924500,2.074300,2.037100,1.409000,1.371600,1.646600,1.591100,1.674500,1.751400,1.366200,1.404300,1.449400,1.405700,1.197900,0.679400,0.793800,0.772400,0.768200,0.969800,0.967400,0.833900,0.623500,0.474100,0.446600,0.368700,0.233500,0.133600,0.043800,0.011100,0.000300,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000 The first handful of lines of the stored file look like: ----------------------------434117419534676393692068 Content-Disposition: form-data; name="file"; filename="filename.csv" Content-Type: text/csv SPID,SA_ID,UOM,DIR,DATE,RS,NAICS,APCT,0:15,0:30,0:45,1:00,1:15,1:30,1:45,2:00,2:15,2:30,2:45,3:00,3:15,3:30,3:45,4:00,4:15,4:30,4:45,5:00,5:15,5:30,5:45,6:00,6:15,6:30,6:45,7:00,7:15,7:30,7:45,8:00,8:15,8:30,8:45,9:00,9:15,9:30,9:45,10:00,10:15,10:30,10:45,11:00,11:15,11:30,11:45,12:00,12:15,12:30,12:45,13:00,13:15,13:30,13:45,14:00,14:15,14:30,14:45,15:00,15:15,15:30,15:45,16:00,16:15,16:30,16:45,17:00,17:15,17:30,17:45,18:00,18:15,18:30,18:45,19:00,19:15,19:30,19:45,20:00,20:15,20:30,20:45,21:00,21:15,21:30,21:45,22:00,22:15,22:30,22:45,23:00,23:15,23:30,23:45,0:00 5001,5001,KWH,R,05/20/2018,A6,722000,100.0,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000200,0.022600,0.058100,0.100500,0.148500,0.251400,0.295800,0.359500,0.321400,0.365300,0.509800,0.571900,0.734700,1.121900,1.312700,1.358400,1.573900,1.270300,1.512500,1.359400,1.735500,1.759900,1.806400,1.501400,1.343900,1.396900,1.660400,1.924500,2.074300,2.037100,1.409000,1.371600,1.646600,1.591100,1.674500,1.751400,1.366200,1.404300,1.449400,1.405700,1.197900,0.679400,0.793800,0.772400,0.768200,0.969800,0.967400,0.833900,0.623500,0.474100,0.446600,0.368700,0.233500,0.133600,0.043800,0.011100,0.000300,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000 And the last couple of lines of the stored file look like this. 5090,5090,KWH,D,11/04/2018,A6,713910,104.2,0.333000,0.319000,0.332000,0.309000,0.326500,0.321000,0.322500,0.320000,0.296000,0.322000,0.323000,0.334000,0.321000,0.334000,8.098000,7.043000,1.422000,0.322000,0.323000,0.335000,0.322000,0.322000,0.322000,0.334000,0.336000,0.340000,0.392000,0.584000,0.200000,0.054000,0.176000,0.156000,0.090000,0.000000,0.002000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.002000,0.001000,0.009000,0.014000,0.020000,0.032000,0.054000,0.055000,0.086000,0.127000,0.151000,0.168000,0.220000,0.245000,0.299000,0.282000,0.317000,0.328000,0.314000,0.327000,0.315000,0.328000,0.316000,0.328000,0.318000,0.323000,0.328000,0.319000,0.327000,0.325000,0.320000,0.332000,0.319000,4.420000,3.531000,2.584000,0.458000,1.001000,0.263000,0.263000,0.261000,0.260000,0.258000 ----------------------------434117419534676393692068-- Is there a way … -
Upgrading Python 3.6 to 3.8
I downloaded python 3.8 expecting it to update python 3.6 with all my packages intact. instead it installed as a separate version so i now have two python versions installed on windows 10. -
How to create model objects of one model automatically when a model object of another has been added in django
Say for example I have a Model called Player. I want Model objects of Player created when new Users are added in django (from django.contrib.auth.models.User) such that each User object in User model has its own object in Player model. I know that I would technically have to use models.ForeignKey() to create a field in Player model and relate it to the User model and that I don't have to worry about deletion of users if I use the on_delete=models.CASCADE parameter in models.ForeignKey() but how do I automatically create these objects with like default values and such. Initially this was my code to do so: for name in User.objects.all().values_list('username', flat=True): if name not in Player.objects.all().values_list('player_name', flat=True): new_player = Player(player_name=name, current_level_no=None, no_of_moves=None) new_player.save() else: pass But this would give me a DatabaseIntegrityError that "Models aren't loaded yet". So I am confused about what to do or how to go forward. As always, I greatly appreciate all answers! -
Django POST error: tuple has no attribute get, despite similar code working previously
I'm working on a page that autofills an html dropdown with data from a Django model, then on submit, sends that data to another page that will do things with it. I have the html dropdown populated, but am having issues POSTing to another page. I keep getting "AttributeError at /battleSim/ 'tuple' object has no attribute 'get' as my error despite similar code working in my characterCreator template. I get this error as soon as I attempt to navigate to battleSim.html on the development server, despite the fact it shouldn't be trying that until a POST method runs. (I think?) Below is the relevant code: views.py: class CharacterCreatorView(TemplateView): template_name = "characterCreator.html" # this solution courtesy of Eliakin Costa on StackOverflow: https://stackoverflow.com/a/59112612/12352379 def post(self, request, *args, **kwargs): userID = 'testUser' addCharacter( userID, str(request.POST.get('characterName')), str(request.POST.get('race')), str(request.POST.get('class')), str(request.POST.get('strength')), str(request.POST.get('dexterity')), str(request.POST.get('constitution')), str(request.POST.get('intelligence')), str(request.POST.get('wisdom')), str(request.POST.get('charisma')) ) return render(request, self.template_name, {}) class battleSimView(TemplateView): template_name = "battleSim.html" def get(self, request, *args, **kwargs): character = characterTable.objects.all() # use filter() when you have sth to filter ;) monster = monsterTable.objects.all() return render(request, self.template_name, {'characters':character, 'monsters':monster},) def post(self, request, *args, **kwargs): if(request.method == "POST"): characterID = str(request.POST.get('character_id')) monsterID = str(request.POST.get('monster_id')) return(render(request, template_name ="battle.html"), {'characterID': characterID, 'monsterID': monsterID},) battleSim.html form: <div … -
Highcharts graph not displaying in Django template html
I am making a website using Django/python/sqlite3. I am also using the ebay-python-sdk to query ebay database and get back information based off of keywords. I am trying to convert the timestamp into milliseconds and pass those values into a Highcharts x-axis, and the final sell price of the item to the y-axis. The graph is not displaying in the Django template (called 'graphs.html'). My code is below: display_graphs/views.py from django.shortcuts import render from ebaysdk.finding import Connection as finding import xmltodict from json import loads, dumps import pandas as pd import datetime import matplotlib.pyplot as plt import io from matplotlib.backends.backend_agg import FigureCanvasAgg from django.http import HttpResponse content_df = pd.DataFrame() def display_the_graphs(request): keywords = request.POST.get('search') api = finding(appid='JohnHein-homepage-PRD-392e94856-07aba7fe', config_file=None, siteid='EBAY-US') api_request = {'keywords':keywords, 'itemFilter':[{'name':'SoldItemsOnly', 'value':True},]} response = api.execute('findCompletedItems', api_request) content = response.content xml_dict = xmltodict.parse(content) content_dict = to_dict(xml_dict) count = content_dict['findCompletedItemsResponse']['searchResult']['@count'] item_dict = content_dict['findCompletedItemsResponse']['searchResult']['item'] print('count:', count) content_df = extract_values(item_dict) x_values = content_df['endPrice'].tolist() y_values_b = content_df['endTime'].tolist() y_values = convert_datetime(y_values_b) context = { 'response': content_df.to_html(), 'content_df': content_df, 'x_v': x_values, 'y_v': y_values } return render(request, 'display_graphs/graphs.html', context) ''' def get_time_graph(request): fig, ax = plt.subplots() ax.set_title('Scatter plot of prices over time') ax.set_xlabel('dates') ax.set_ylabel('sell prices') ax.scatter(content_df.endDate.values, content_df.endPrice.values, s=10, label='sell prices over time') canvas = FigureCanvasAgg(fig) buf … -
How to add two fields of django model and save the sum in another field?
class example(models.Model): var1 = models.IntegerField(default=0) var2 = models.IntegerField(default=0) var3 = models.IntegerField(default=0) sum = var1 + var2 + var3 Can anyone help me to save the sum of the three field and save it in the sum field of the model? -
How do I fix Django changes made outside of my virtual environment?
I am new to Django and new to the virtualenv scene. I have been working on a Django project for a couple of days and completely forgot to activate my venv on my second day. I am using this tutorial to guide me and I have been working from within my activated environment up until this point.... Is it enough to just re-run manage.py after activating my venv? -
Simple operations with data requested from a Django model
I am trying to write a simple web application, where i can upload csv files and return the headers from each file. Everything is working fine. The id, the path to the file, gets saved in a database. This is the response i am getting: { "id": 1, "filefield": "http://127.0.0.1:8000/api/merged/1/uploads/header_body_test_zZr4Cea.csv" } What i do not understand is, where or how can i actually work with the data i request from the database? What i am imagining is a different url route, where i can specify an id and the response would be something like this: { "id": 1, "filefield": "http://127.0.0.1:8000/api/merged/1/uploads/header_body_test_zZr4Cea.csv" "headers_of_csv": "Date;Amount" } Its hard for me to explain (or google) what my problem actually is. I dont understand where or how the code to do this would actually be (is it part of the serializer, or the view, or in the model?). Or even in simpler terms, lets say i have a model, that had an id and a 3 digit number and returns this: { "id": 1, "number": 567 } How or where could i create a respone like this: { "id": 1, "number": 567 "first_digit_or_number": 5 } Any help is greatly appreciated, i just dont understand what …
