Django community: Django Q&A RSS
This page, updated regularly, aggregates Django Q&A from the Django community.
-
Pulling data from Sheets API via Python and Django issue
I'm trying to run python manage.py runserver on the local host (using virtualenv) but it kept giving me the message below and I kept hearing that it might be because of the Oauth2 Error? Performing system checks... usage: manage.py [--auth_host_name AUTH_HOST_NAME] [--noauth_local_webserver] [--auth_host_port [AUTH_HOST_PORT [AUTH_HOST_PORT ...]]] [--logging_level {DEBUG,INFO,WARNING,ERROR,CRITICAL}] manage.py: error: unrecognized arguments: runserver I'm adding my the Python code that I'm using (it's some what an example code from Google Sheets API V4) from __future__ import print_function from apiclient.discovery import build from httplib2 import Http from oauth2client import file, client, tools # Setup the Sheets API SCOPES = 'https://www.googleapis.com/auth/spreadsheets.readonly' store = file.Storage('credentials.json') creds = store.get() if not creds or creds.invalid: flow = client.flow_from_clientsecrets('client_secret.json', SCOPES) creds = tools.run_flow(flow, store) service = build('sheets', 'v4', http=creds.authorize(Http())) def get_form_data(): SPREADSHEET_ID = '1BxiMVs0XRA5nFMdKvBdBZjgmUUqptlbs74OgvE2upms' RANGE_NAME = 'Class Data!A2:E' result = service.spreadsheets().values().get(spreadsheetId=SPREADSHEET_ID, range=RANGE_NAME).execute() values = result.get('values', []) data = [] if not values: return data else: for row in values: data.append([]) for each in row: data[len(data)-1].append(each.encode("utf-8")) return data Has anyone ever run into this problem before and solve the issue? Any help is appreciated -
Django get file basename from uploaded file
In my form there is a file upload. fileandext = forms.FileField( ..... the user will upload a file barcode.txt . I want to get the barcode without the extension or dot. It seems no matter what type of os path file function i use a get an error of the format AttributeError: 'InMemoryUploadedFile' object has no attribute 'something here' So what is an InMemoryUploadedFile and how can I manipulate the filename to extract the basename? What I've tried, separate function, using os.path.splitext(fileandext) EDIT the value of fileandtext has no path it looks like "barcode.txt" -
Django[ TypeError: __init__() got an unexpected keyword argument 'choice' ] Happening when adding a choice in my model
I have a model that is a radar, and it needs to have 4 possible modes. I followed the documentation on the django website (https://docs.djangoproject.com/en/1.11/ref/models/fields/#choices). However I am still getting an error. I will post my model file down below. If you think I might need to post any other code let me know. from django.db import models # Create your models here. class Radar(models.Model): id = models.AutoField(primary_key=True) SCAN = "SC" ON = "ON" OFF = "OF" STANDBY = "ST" MODE_CHOICES = ( (SCAN, "scan"), (ON, "on"), (OFF, "off"), (STANDBY, "standby"), ) mode_choice = models.CharField( max_length=2, choice=MODE_CHOICES, default=OFF, ) ip_address = models.CharField(max_length=200) start_azimuth_angle = models.FloatField(default=0) end_azimuth_angle = models.FloatField(default=0) azimuth_scan_speed = models.FloatField(default=0) azimuth_increment = models.FloatField(default=0) start_elevation_angle = models.FloatField(default=0) end_elevation_angle = models.FloatField(default=0) elevation_scan_speed = models.FloatField(default=0) elevation_increment = models.FloatField(default=0) def __str__(self): string = 'RadarID : %s ip: %s ' % (self.id, self.ip_address) return string -
Django - nested relation query with the ORM
Because I need to avoid a recursive import and work with a Group object as my starting point for my query (which is why I can't import Action objects directly.) The relationship is Group -> Component -> ComponentVersion -> Action For instance, Group.components.all() returns all the components in a query set. Additionally [component.versions.all() for component in Group.components.all()] returns a list of Querysets whose results are all of the versions. Subsequently, .actions.all() would return all the Queryset of actions for each ComponentVersion returned in the comprehension. What is the optimal way to do this to avoid making unnecessary calls to the DB and for readability? -
Django Rest Framework nested relationship sets field 'read_only=True'
My AirportSerializer has a field city, that is a ForeignField nested by setting depth=1. I need the serializer to return the information of the 'Airport' and the information of the related 'City', so I need to nest the objects. The problem is that the field 'city' is set read_only=True when I set the depth to 1, so post method raises a 'not null' error because the field is required. I tried by setting city = CitySerializer(), and I get the nested result that I need, but this approach implies that a post method expects data for creating a new 'Airport' and a new 'City' also. This is not what I want. I only want the field 'city' not to be set read_only=True. The documentation says that I have to create create() and/or update() methods in order to explicitly specify how the child relationships should be saved I tried this, with this serializer: class AirportSerializer(serializers.ModelSerializer): class Meta: model = models.Airport fields = ('id', 'city', 'name', 'iata') depth = 1 def create(self, validated_data): airport = models.Airport.objects.create(**validated_data) return airport But validated_data gets de 'city' field already set to null, so airport = models.Airport.objects.create(**validated_data) raises the same not null error. So, in the end, ... -
Django through Docker Error: That IP address can't be assigned to.
I am working on Ubuntu 16.04 VM and trying to run my Django app through Docker container. I successfully verified that my web is working. It runs if I just command on my machine. However, when I build image with my app and run the container, it does not work. my Dockerfile has this CMD at the end. CMD ["python", "manage.py", "runserver", "myVmip:8000]" It gives me an error Performing system checks... System check identified no issues (0 silenced). June 21, 2018 - 20:50:44 Django version 1.11.13, using settings 'datahttptools.settings' Starting development server at http://myVMip:8000/ Quit the server with CONTROL-C. Error: That IP address can't be assigned to. I was trying all the possible solutions by googling but I was not able to figure it out. -
autocomplete django form jquery
I m kinda new to django, anyway I want my form to have javascript autocomplete. Example that I m trying to do is https://www.w3schools.com/howto/howto_js_autocomplete.asp. So here my question is that should i go for all HTML and Javascript and then try to pass the user input manually by declaring this in my views.py def register(request): country = request.POST['mycountry'] or is there any Django way of handle this? -
Assigning a slug in template url with taggit's built in slugify does not seem to work. Tosses a slug field error
I'm using a 3rd party app called django taggit to handle my tagging needs. I am mainly using it to display a list of all my tags and maybe in the future I will create a tag cloud. I have a tags page on my site that displays a list of all the tags. I created a detail view for my tags. If someone clicks on a tag I want it to list all the articles with that corresponding tag. Now Taggit has it's own slugify built in which I can call using tag.slug. Models: class BlogPost(models.Model): ... test_cat = TaggableManager() ... def __str__(self): return self.title def get_absolute_url(self): return reverse('post-detail', args=[str(self.id)]) Urls: urlpatterns = [ ... path('blogs/tags', views.TagListView.as_view(), name='tags'), path('tags/<slug>', views.TagDetailView.as_view(), name='tagged'), ... ] Tag list template: I have specified the slug in my {% url %} <ul class="tags"> {% for tag in tags %} <li><a href="{% url 'tagged' slug=tag.slug %}">{{tag}} ({{tag.num_times}})</a> </li> {% endfor %} </ul> Views: class TagListView(generic.ListView): model = BlogPost template_name = 'blog/all_tags.html' def get_context_data(self, **kwargs): context = super(TagListView, self).get_context_data(**kwargs) tags = BlogPost.test_cat.most_common() context['tags'] = tags return context class TagDetailView(generic.DetailView): model = BlogPost template_name = "blog/tag_detail.html" ... The error code is FieldError at /blog/tags/world-news Cannot resolve keyword ... -
How to make internal requests to Nginx
My architecture is: Ubuntu + postgres + django + Nginx From a python application or system service, how can I make an internal request https to Nginx. And in case it can be done, how could you create a Nginx block that distinguishes between internal and external requests (internet). -
Processing Background Tasks on a Scheduled Basis While returning HTTP Requests
Here is what I am trying to accomplish: 1) GET Request is made 2) Background task is scheduled. Response that task has been scheduled is made. 3) After ten seconds (after the response has been made), the task is processed. I want to do this asynchronously so that the computer that made the call is not waiting on the response and can perform other tasks without wasting CPU. I am able to process the background tasks if I use the command python manage.py process_tasks but I want this to occur automatically on a routine basis in my Python code. How can I do this? -
Django form with grouped checkboxes
I need to create a form in Django which contains a list of grouped checkboxes like: group_one [] option_one [] option_two group_two [] option_one [] options_three Right now I've an intermediate table where I'm storing a option_id and a group_id. I found this snippet but only works on Django 1.8, after that version some classes were removed from the core of django forms... I could find the way to update the snippet, but I wonder if maybe somebody had the same situation and found a better solution for this challenge. Thank you in advance! -
Verbosity for Django management commands
Django lets you define --verbosity parameter for management commands with different verbosity levels: 0, 1, 2, 3. For what cases would anyone need more than 2 verbosity options for management commands? Wouldn't silent and verbose mode be enough? -
Sending forms clears the Get parameters
When I click on the link <a href="?page={{request.GET.page}}&order_by=counter__service__name_service&sort={{ sort_type }}&from_date={{request.GET.from_date}}&from_date={{request.GET.to_date}}&type_water={{request.GET.type_water}}"> all the parameters are saved as both forms and the rest, but when I try to also keep the parameters in the form action method <form class="row justify-content-around" id="searchform" action="{% url 'history_application' %}?page={{request.GET.page}}&order_by={{request.GET.order_by}}&sort={{request.GET.sort}}" method="get" accept-charset="utf-8"> it removes them (URL: history/?type_water=hot&from_date=&to_date=). Why parameters do not remain in the query? -
How do I update django to 2.x on digitalocean?
I have recently started using digitalocean, and I have this problem ever since! I have created a django project on django 2.0.3, and I want to launch this. But the standard django version on digitalocean is 1.8.7. Now there are posts on the internet which have helped me to upgrade django using pip3, but that does not update the django version of the standard project digitalocean allready has created. So my question is, how can I update the version of that project? -
How to replace line number in a python logging function
I have a method that I am calling at the end of all my django views for logging. logger = logging.getLogger(__name__) def context_logger(context, request): for key, val in context.items(): if key is not 'page_form' and key is not 'failure_form': logger.debug('%s - context for %s: %s', request.get_full_path(), key, val) logger.debug(sys._getframe().f_lineno) views def index(request): products, tools = menu() job_executions = jobs_in_progress() context = {"products": products, "tools": tools, "job_executions": job_executions} context_logger(context, request) # i am able to get the line number here logger.debug(sys._getframe().f_lineno) return render(request, "app/index.html", context) The problem is when context_logger gets called it always prints the line number of the context_logger method (rather than where it is being called from) in the log. I am able to grab the line # with (sys._getframe().f_lineno) but not sure how to replace this in the log. Is there a straight forward way to do this? -
git submodule update via ssh error
I cloned the application commcare-hq after installing python and django in my cpanel. here's the link: https://github.com/dimagi/commcare-hq but whenever i enter the following command git submodule update --init --recursive i get the following error fatal: clone of 'git://github.com/dimagi/xml2json.git' into submodule path '/home/hcdcnetl/myProject/commcare-hq/submodules/xml2json' failed Failed to clone 'submodules/xml2json'. Retry scheduled Cloning into '/home/hcdcnetl/myProject/commcare- hq/corehq/apps/hqmedia/static/hqmedia/MediaUploader'... fatal: unable to connect to github.com: github.com[0: 192.30.253.113]: errno=Connection refused github.com[1: 192.30.253.112]: errno=Connection refused -
Can I build Uber app App admin panel with django.?
I want to get User Location with django.. (Lat,Lng) and also I want get all users around it within 10 km I want to do stuff that I am already doing in android with this library compile 'com.firebase:geofire-android:2.3.1' Thank you. -
django multiple filter options on queryset
We have 2 approach ideas that we are trying to consider here for the Django REST api. At the moment, we have implemented 1 filter option: class APINewsViewSet(viewsets.ModelViewSet): serializer_class = APINewsSerialiser def get_queryset(self): queryset = NewsBackup.objects.all() source = self.request.query_params.get('source', None) if source is not None: queryset = queryset.filter(news_source = source) return queryset This achieves: 127.0.0.1/news?source=xxx Something additional that we would like to do is have other filter options that the user can type in such as 127.0.0.1/news?source=xxx&sourcename=xxx which would then return them the JSON object with only data that has a source_id of xx and source_name of xx. Is this possible with the Django REST framework? We have tried to add other options within the method: query_params.get() -
Want a Django Rest Framework nested serializer but don't want to 'post' to referenced objects
I want a Django Rest Framework ModelSerializer to return a foreign field with a nested object with some fields of the referenced object, so I defined a ModelSerializer that returns the desired fields from the related objects, and nested it. The 'get' method works as desired, but for the 'post' I need to provide the data for the nested object, instead of only the key to the referenced object. If I set read_only=True, then I am unable to provide the data for the required field and I get an error: This is the result I expect from the serializer: { "id": 1, "name": "Crescencio Rejon", "city": { "id": 4, "name": "Merida" }, "iata": "MID" } This is my model: class Airport(models.Model): city = models.ForeignKey('City', on_delete=models.PROTECT, related_name='city_airports', verbose_name=_('City')) name = models.CharField(max_length=40, unique=True, verbose_name=_('Name')) iata = models.CharField(max_length=3, unique=True, null=True, blank=True, verbose_name=_('IATA')) class Meta: verbose_name = _('Airport') verbose_name_plural = _('Airports') def __str__(self): return "[{}]{}".format(self.city, self.name) These are my serializers: class CityRelatedFieldSerializer(serializers.ModelSerializer): class Meta: model = models.City fields = ('id', 'name') class AirportSerializer(serializers.ModelSerializer): city = CityRelatedFieldSerializer() class Meta: model = models.Airport fields = ('id', 'city', 'name', 'iata') I haven't found another way to get the result I want but nesting the serializers, but, when ... -
Django admin panel can not set valid choice when choices are enum.Enum
I use enum.Enum as choices for field language. I can create a book by b = Book(title="Some Title", language=LanguageChoice.EN). And query by books = Book.objects.filter(languge=LanguageChoice.EN). However, when I want to create new books at admin panel, it says Select a valid choice. LanguageChoice.EN is not one of the available choices.. Django has ability to serialize enum.Enum since 1.10. So how should admin panel work? Thanks. from enum import Enum from django.db import models class LanguageChoice(Enum): DE = "German" EN = "English" CN = "Chinese" ES = "Spanish" class Book(models.Model): title = models.CharField(max_length=255) language = models.CharField( max_length=5, choices=[(tag, tag.value) for tag in LanguageChoice] ) -
Django URL parameters replace each other
Perhaps my question will seem somewhat simple and understandable, but even so. In my project, I use standard pagination and sorting. The problem is that they replace each other in the get request, for example I sort them and if I go to the second page then the set is not sorted. I understand the reason and it seems the answer lies on the top, but even so I could not find it. Sorting: <a href="?order_by=counter__service__name_service&sort={{ sort_type }}">Counter</a> Pagination example: <a class="page-link" href="?page={{ history_application.previous_page_number }}">&laquo;</a> The question is how to save the parameters that were transmitted earlier. -
Ajax call using Django REST API python?
I am trying to pass multiple search fields to my Django API from my Ajax request but for some reason, its not filtering the results. I am still getting everything as if my search queries are not being passed to the Django API. What could i be doing wrong ? api.py from . import models from . import serializers from rest_framework import viewsets, permissions, filters class Useradviewset(viewsets.ModelViewSet): """ViewSet for the patientVisit class""" queryset = models.Userad.objects.all() serializer_class = serializers.useradserializer permission_classes = [permissions.IsAuthenticated] filter_backends = (filters.SearchFilter,) search_fields = ('user_id','category','country') ajax request $.ajax({ url: "/plentyofcats/api/v1/useradapi/", type: "get", data: { 'category': 'msw', 'country':'congo', }, success: function (json) { console.log(json) } }); -
In Django, what is the best practice for an app which relies on certain model instances?
In a Django project, we have a model SessionType which has a category foreign key to a SessionCategory. There is a function, create_checkin_sessions, which expects a SessionCategory with a certain name, 'Guide Check In', to exist in the database. If it doesn't, an error is logged: import logging from lucy_web.models import Session, SessionType, SessionCategory logger = logging.getLogger(__name__) class SessionCategory(models.Model): name = models.CharField(max_length=255, unique=True) class SessionType(models.Model): category = models.ForeignKey('lucy_web.SessionCategory') GUIDE_CHECKIN_CATEGORY = "Guide Check In" def create_checkin_sessions(family): _check_guide_checkins_category() session_number = 1 session_types = SessionType.objects.filter(category__name=GUIDE_CHECKIN_CATEGORY)\ .order_by('enterprise_checkin_ordering').all() for session_type in session_types: Session.objects.create( session_type=session_type, session_number=session_number, family=family) session_number += 1 def _check_guide_checkins_category(): """Check whether the expected session category for guide check-ins exists""" if not SessionCategory.objects.filter(name=GUIDE_CHECKIN_CATEGORY).exists(): logger.error(f"A session category for guide check-ins, '{GUIDE_CHECKIN_CATEGORY}', " "is expected to exist, but was not found in the database.") The problem with this is that the name of each SessionCategory is editable in an internal dashboard. If the name is changed, this function would throw an error, whereas ideally, we would like everything to continue to work as before. For this reason, I'm considering adding a field like original_name, and populating it in a data migration with the name at that time, and using the original_name instead of the name from ... -
How to create dynamic form fields from schemas
I'm trying to make a JSON Creator form that is dynamically created based off of a schema chosen by the user. I made an example of how I would want one to more or less look like. Take this given schema: { "type":"object" "properties": "color": { "type": "string", "enum": ["red","green","blue"] }, "unique_id": { "type": "string" "maxLength": 15 }, "workload":{ "type": "object", "properties":{ "write_pre":{ "type": "number", "minimum": -1 }, "read_pre":{ "type": "number", "minimum": -1 }, "required": ["write_pre","read_pre"], "additionalProperties": false } }, "required": ["color", "unique_id"], "additionalProperties": false } I would want my form to look something like this: {% load static %} <!DOCTYPE html> <html> <head> <meta charset="utf-8"> <link rel="stylesheet" href="{% static "css/background.css" %}"> </head> <body> <div class="navbar"> </div> <h1>Welcome To The JSONCreator</h1> <form method="post" class="creator"> {% csrf_token %} <h4>color: *required</h4> <select name="color" required> <option value="red">red</option> <option value="green">green</option> <option value="blue">blue</option> </select> <h4>unique_id: *required</h4> <input type="text" name="unique_id" required> <h4>workload:</h4> <h5>work_pre: *required</h5> <input type="number" min="-1" name="workloadWork_pre" required> <h5>read_pre: *required</h5> <input type="number" min="-1" name="workloadRead_pre" required> <br><br><input type="submit" value="submit"> </form> </body> </html> My problem is I don't know how I would auto update the form fields to the given property fields given in the schema. I'm planning not to actually write the form with Django's form ... -
Serializing a Django Queryset returns wrong data
I'm writing a bit of Javascript for my app and I need to get a queryset to my .js file by serializing to JSON data first and then returning it to the HTML template. I followed the documentation and I thought I got it working the first time but I now realized that the data it returns aren't the same with what there is in the database. Here's my views.py: class DetailView(generic.DetailView): model = Poll template_name = 'voting/detail.html' context_object_name = 'question' def get_context_data(self, **kwargs): context = super().get_context_data(**kwargs) context['data'] = serializers.serialize("json", Profile.objects.filter(user_id=self.request.user)) return context def get_queryset(self): """ Excludes any questions that aren't published yet. """ return super(DetailView, self).get_queryset().filter( eligiblevoters__user=self.request.user, pub_date__lte=timezone.now() ) """ return super(DetailView, self).get_queryset().filter( eligiblevoters__user=self.request.user, pub_date__lte=timezone.now() ) Basically I'm putting into context a JSON serialized Queryset that contains data about the logged in user from the Profile model. The profile model in models.py: class Profile(models.Model): user = models.OneToOneField(User, on_delete=models.CASCADE) email_confirmed = models.BooleanField(default=False) encrypted_private_key = models.BinaryField(max_length=500, blank=True) public_key = models.BinaryField(max_length=30, blank=True) salt = models.BinaryField(max_length=16, blank=True) The output serialized data that is accessible in my HTML file is this which looks correct at first but I noticed that even though the user id is correct the fields encrypted_private_key, public_key and salt are ...
