Django community: Django Q&A RSS
This page, updated regularly, aggregates Django Q&A from the Django community.
-
Babel Not compiling. Unexpected Token
This has been asked before but I have clearly set up the steps for this. What am I doing wrong or setting up wrong? I get the following error Failed to compile. ./src/Login.js Syntax error: Unexpected token (52:10) 50 | }; 51 | > 52 | const element = <div> The following is my .babelrc: { "presets": ["es2015", "react", "stage-2", "env"], "plugins": ["transform-class-properties"] } and then finally my webpack.config.js module: { rules: [ { //a regexp that tells webpack use the following loaders on all //.js and .jsx files test: /\.jsx?$/, exclude: /node_modules/, loader: 'babel-loader', exclude: /node_modules/, query: { presets: ['es2015', 'react', 'stage-2','@babel/preset-env'] } }, I have installed the babel presets and all the packages required. I am just trying to use the JSX coding style. I am still new to this environment. -
How to make statistics in django
I'm using django fobi to allow users to create their own forms. I would like to make some reports and stats based on those forms. I have a working python code but I don't know how to "translate" that code in a django working template. The data is as follows: saved_data = ''' [ [{ "label": "Question 1?", "html_name": "question_1", "first_name": "John", "last_name": "Doe", "email": "john@doe.com", "answer": "Yes" }, { "label": "Question 2?", "html_name": "question_2", "first_name": "John", "last_name": "Doe", "email": "john@doe.com", "answer": ["Red", "White"] }], [{ "label": "Question 1?", "html_name": "question_1", "first_name": "Jane", "last_name": "Mary", "email": "mary@jane.com", "answer": "No" }, { "label": "Question 2?", "html_name": "question_2", "first_name": "Jane", "last_name": "Mary", "email": "mary@jane.com", "answer": ["Red", "Black"] }] ] ''' data = json.loads(saved_data) answer = {} for x in data: for y in x: if type(y['answer']) is list: for an in y['answer']: answer.setdefault(y['label'], {})\ .setdefault('answer', []).append(an) answer.setdefault(y['label'], {}).setdefault('full_name', []).append(y['first_name'] + ' ' + y['last_name']) answer.setdefault(y['label'], {}).setdefault('email', []).append(y['email']) elif type(y['answer']) is str: answer.setdefault(y['label'], {})\ .setdefault('answer', []).append(y['answer']) answer.setdefault(y['label'], {}).setdefault('full_name', []).append(y['first_name'] + ' ' + y['last_name']) answer.setdefault(y['label'], {}).setdefault('email', []).append(y['email']) for questions, answers in answer.items(): print('\n', questions) counting = Counter(answers['answer']) for key, value in counting.items(): print(key, value) for answer in zip(answers['full_name'], answers['answer']): if key == answer[1]: ... -
Django : Filter bills with client name in the same page without reloading
in my view I have the list of bills , and I need to add a field in order to filter the list by client as bellow : so that if I choose client rgg it will get only show bill of that client. To do so, I need some orientation if I should do it with Ajax call , because I dont want to reload the page each time I change my choice. I really need to know the best way to do such thing. Thank You so much for your help -
Can't set csrf_token as hidden input value
I'm really confused. When I use csrf_token as itself e.g <div>{{csrf_token}}</div> it works perfectly and gives output like <div>aObwmGR5FiCGnfffpeZhbtMtFCFEMyjTKc0QnYT8FZcF9j9oqz5MzYnqDgcVyBBq</div>, but when I use it in my input field as a value it doesn't work.. This: <input type="hidden" id="csrf_token" value="{{csrf_token}}" v-model="csrf_token"> gives me this: <input type="hidden" id="csrf_token" value=""> -
Django Allauth very specific redirection after Facebook Social Signup
I know there are a few questions on the topic already but I have tried to implement those solutions and could not really solve my problem. I am talking about social signup with allauth here, and facebook in particular. DESIRED BEHAVIOR: after facebook signup I want user to go to my url "accounts:welcome", but when they simply login I want them to go to my LOGIN_REDIRECT_URL (which is the site's home page). After looking here and there this is the code I came up with (writing my custom adapter) settings.py: LOGIN_REDIRECT_URL = ("gamestream:home") SOCIALACCOUNT_ADAPTER = "myproject.users.adapter.MySocialAccountAdapter" adapter.py: from django.conf import settings from allauth.socialaccount.adapter import DefaultSocialAccountAdapter from django.core.urlresolvers import reverse from django.shortcuts import redirect class MySocialAccountAdapter(DefaultSocialAccountAdapter): def save_user(self, request, sociallogin, form=None): print('OK11OK') super().save_user(request, sociallogin, form=form) return redirect(reverse('accounts:welcome')) def get_connect_redirect_url(self, request, socialaccount): print('OK22OK') assert is_authenticated(request.user) url = reverse('accounts:welcome') return url Please assume that all links/settings are good as for example the console prints out 'OK11OK' when I create myself as a user via the facebook app. The fact is that the method get_connect_redirect_url never gets triggered as I never read 'OK22OK' on the console. The user is created and I end up on the home page, which is not what I want. ... -
Django-import-export before_import_row to automatically create object if it does not exist
I'm facing the current issue when using Django-import-export: class QuestionResource(resources.ModelResource): category = fields.Field( column_name='category', attribute='category', widget=ForeignKeyWidget(Category, 'category') ) class Meta: model = Question fields = ['id', 'question', 'category', 'answer',] # exclude = ('created', 'modified', 'verified', 'count', 'user_created') # PREVIOUS THINGS I TRIED: # def _post_import(model, **kwargs): # query = self.fields['category'] # category = Question.objects.get_or_create(category=query) # return category # def before_import(self, dataset, dry_run, *args, **kwargs): # query = self.fields['category'] # for q in query: # Category.objects.get_or_create(category=q) # def before_import_row(row, *args, **kwargs): # category = self.fields['category'] # Category.objects.get_or_create(category=category) def before_import_row(row, *args, **kwargs): category = row.fields['category'] Category.objects.get_or_create(category=category) As you can see I added the previous things I tried as comments. The error I receive is: python3.6/site-packages/django/db/models/query.py", line 403, in get self.model._meta.object_name questions.models.DoesNotExist: Category matching query does not exist. What am I missing? I can't seem to find any documentation on this (or there is but I don't understand it) Thanks in advance! -
Dropdown list in Django using pandas data
I am trying to generate two dropdown lists in django using a pandas dataframe. I am declaring the dataframe in the views.py file of the django project (no idea if it is the best way to do it) as I want to exploit all the functions of pandas such as unique() and all the possible selection I can do with the dataframe before sending the information to the webpage. ...views.py def index(request): dataframe=pd.read_excel("myFile.xlsx") countries = dataframe['Country'].unique() cities = dataframe['City'].unique() context = {'countries' : countries, 'cities' : cities} return render(request, 'myApp/index.html', context} while the index.html is .../myApp/index.html <select> {% for country in countries %} <option value="{{ country }}">{{ country }}</option> {% endfor %} </select> <select> {% for city in cities%} <option value="{{ city }}">{{ city }}</option> {% endfor %} </select> Now, I would like to select a 'Country' from its dropdown list and have only the cities belonging to that country in the second dropdown. Is it possible (and how can I do it)? Having in mind that the final work should be a dashboard (having also React.js and D3.js/NVD3.js so that a selection on dropdowns, search bars or plots will affect the whole webpage) is it a good approach to ... -
when create a project in django, create a empty folder
I dont know why every time i create a project with this command, create an empty folder: django-admin start-project myProject These are the files that I have in my directory: What I noticed is that I do not have the django-admin.py file, is that normal? Because when I execute the command, it does not throw me any error? When I go to see the folder created previously, I find an empty folder: -
Django Model Foreign Key Casting Integer to Char
I have two fields that I am trying to give a foreign key relationship to. The field that I want to reference is a CharField and the field that will reference the other field is an IntegerField. When I try to set the foreign key, it tries to convert the CharField to an IntegerField and then overflows the IntegerField. Is it possible to cast the IntegerField to a CharField and then set the foreign key? -
Replace object id for related objects
Given models class Reference(models.Model): name = models.TextField() version = models.PositiveSmallIntegerField() ... class First(models.Model): special_reference = models.ForeignKey(Reference, related_name='first_references') ... class Second(models.Model): not_special_reference = models.ForeignKey(Reference, related_name='second_references') ... class Third(models.Model): very_special_reference = models.ForeignKey(Reference, related_name='third_references') ... ref_v1 = Reference(name="Main Reference", version=1).save() first = First(reference_id=ref_v1.id).save() second = Second(reference_id=ref_v1.id).save() third = Third(reference_id=ref_v1.id).save() I don't know how many models can relate to reference. ForeignKeys and related names can be different. Now I will create next version of reference. ref_v2 = Reference(name="Main Reference", version=2).save() I need that all created objects of First, Second and Third models related to ref_v1 change relation to ref_v2. I know, that I can get all related models of Reference through _meta like this Reference._meta.related_objects. But I can't figure out how can I dynamically get all related models and change value of ForeignKey to new one. -
PHP speed test 2 django view
Good morning, my question is this: How can I transform the following PHP codes to a django view? I'm transferring the following code [https://github.com/adolfintel/speedtest][1] to get a speed test but it's done in php. ========================================================================= Código 1 Detalle de código de php file garbage.php // Disable Compression @ini_set('zlib.output_compression', 'Off'); @ini_set('output_buffering', 'Off'); @ini_set('output_handler', ''); // Headers header('HTTP/1.1 200 OK'); // Download follows... header('Content-Description: File Transfer'); header('Content-Type: application/octet-stream'); header('Content-Disposition: attachment; filename=random.dat'); header('Content-Transfer-Encoding: binary'); // Never cache me header('Cache-Control: no-store, no-cache, must-revalidate, max-age=0'); header('Cache-Control: post-check=0, pre-check=0', false); header('Pragma: no-cache'); // Generate data $data=openssl_random_pseudo_bytes(1048576); // Deliver chunks of 1048576 bytes $chunks=isset($_GET['ckSize']) ? intval($_GET['ckSize']) : 4; if(empty($chunks)){$chunks = 4;} if($chunks>100){$chunks = 100;} for($i=0;$i<$chunks;$i++){ echo $data; flush(); } ========================================================================= Código 2 Detalle de código de php file empty.php header( "HTTP/1.1 200 OK" ); header("Cache-Control: no-store, no-cache, must-revalidate, max-age=0"); header("Cache-Control: post-check=0, pre-check=0", false); header("Pragma: no-cache"); header("Connection: keep-alive"); -
Django form & rendering data from model
I am currently struggling with Django forms. Based on the tickets model I generate this formset where users can choose the qty of tickets they want. After they will be redirected to the checkout page. My problem is, when I use {{ form.ticket }} I get a select field but that's not what I'm looking for. I just want to print out the tickets as seen in the screenshot below. Can anyone help me on that? How it should be: How it currently looks like: views.py from django.forms import formset_factory from django.shortcuts import redirect, render from .forms import EntryModelForm from .models import Ticket from orders.models import Order, Entry # Create your views here. def choose_ticket_and_quantity(request): tickets = [] for ticket in Ticket.objects.all(): tickets.append({'ticket': ticket}) EntryFormSet = formset_factory(EntryModelForm, extra=0) formset = EntryFormSet(initial=tickets) if request.POST: o = Order.objects.create() request.session['order_id'] = o.order_id formset = EntryFormSet(request.POST, initial=tickets) if formset.is_valid(): for form in formset: if form.cleaned_data['quantity'] > 0: entry = form.save(commit=False) entry.order = o entry.save() return redirect('http://127.0.0.1:8000/checkout') return render(request, "tickets/choose_ticket_and_quantity.html", {'formset': formset}) forms.py from django import forms from orders.models import Entry class EntryModelForm(forms.ModelForm): class Meta: model=Entry fields = ['ticket', 'quantity'] choose_ticket_and_quantity.html <form method="post" action=""> {% csrf_token %} {{ formset.management_form }} {% for form in formset ... -
Do not use textures decorator for Django tests
Is there a decorator in Django that would allow to run the test function without applying fixtures? Something like: from django.test import TestCase class TestSomething(TestCase): fixtures = ['test_fixture.json'] def test_with_fixture(self): # test something with fixtures @do_not_use_fixtures def test_without_fixtures(self): # test something without fixtures -
Django - Loop through input fields in HTML through views
I have this markup <form action="my_view" method="POST"> {% csrf token %} <input name="1"> <input name="2"> <input name="3"> <input name="4"> <input name="5"> <button type="submit"> </form> Is there a way to loop through all the input fields in the VIEWS? View: def do_something(request): # loop through each input field # something like: # for field in fields ?? Thanks! -
How to take upvotes for the answer in Django?
I am developing website for simple question and answer forum. I want to get upvotes for an answer. models.py class Answer(models.Model): ans = models.TextField() img = models.CharField(max_length=100) created_by = models.ForeignKey(User, related_name='answer') created_on = models.DateTimeField(auto_now_add=True) ques = models.ForeignKey(Question, related_name='answer') def __str__(self): return self.ans class Upvote(models.Model): upvote = models.BooleanField(default=False) upvote_by = models.ForeignKey(User, related_name='upvote') upvoted_on = models.DateTimeField(auto_now_add=True) #ques = models.ForeignKey(Question, related_name='upvote') ans = models.ForeignKey(Answer, related_name='upvote') def __str__(self): return self.upvote_by views.py I can get upvotes for an answer like below answer = get_object_or_404(Answer, pk=1) upvotes = Upvote.objects.filter(ans=answer) How to take upvotes from answer object ? Is it possible please correct me if i am wrong. Something like below, answer.upvote_set Thanks in advance !! -
django rest framework - global default model serializer
In short, I want to have a global default serializer per model. My use case here is to create dynamic serializer- i.e creating ModelSerializer classes on the fly. class Customer(models.Model): name = models.CharField(max_length=200) code = models.CharField(max_length=200) # many more fields.. class CustomerTicket(models.Model): customer = models.ForeignKey(Customer) date = models.DateTimeField(auto_now_add=True) # more fields.. Customer will be referenced by many other models, and hence it will be serialized as a nested object. I don't want the 'code' field to appear in the output - no matter what it should always be excluded. Now I'd like to create a function: def serialize_default(model, fields, queryset): class S(serializers.ModelSerializer): class Meta: model = model fields = fields depth = 1 return S(queryset, many=True) if I serialize CustomerTicket queryset using this function, I will get all the customer fields as a nested object. I know I can override it locally, but I want to define a CustomerSerializer that will be used by default (for the nested Customer here) unless other serializer is specified as a field. How to achieve this? -
Django Fallback to model lookup from external API
I'm using Django REST framework to serve up JSON content for a website front end. On the back end, I have two Django models, Player and Match, that each reference multiple of the other. A Match contains multiple Players, and a Player contains multiple Matches. This data is originally retrieved from a third-party API. Matches and Players must be fetched separately from the API, and can only be fetched one at a time. When an object is fetched, its data is converted from the external JSON format into my Django model. At this point, the Match/Player will live forever in Django. The hard part is that I want this external fetching to be seamless. If I query for a player or match and it's in the DB, then just serve what we have there. Otherwise, I want to fetch that object from the external DB. My question is, does Django provide any convenient way of handling this? Ideally, any query along the lines of Match.objects.get(id=...) will handle this API fallback transparently (I don't mind the fact that this queyr may take significantly longer in some cases). -
Django: Actions that provide intermediate pages ... with 100k rows
I know how to write Actions that provide intermediate pages, since the docs are great: https://docs.djangoproject.com/en/2.0/ref/contrib/admin/actions/#actions-that-provide-intermediate-pages But, if my selection contains 100k rows, the pattern of the docs does not work since the URL gets too long. How to write Django Admin Actions that provide intermediate pages and can handle +100k rows? -
Django annotate returned more than one
user = get_object_or_404( (User.objects .annotate(company_name=F('usercompany__company__company_name')) .annotate(project=F('team__vacancy__name'))), email=request.GET.get('user_email') ) I got errors proj.models.MultipleObjectsReturned: get() returned more than one User -- it returned 2! How I can change .annotate(project=F('team__vacancy__name'))), that get all -
Display Django model entries as part of a form
I want to display model entries as part of a form so I can update them. What is the best way to do this? I am using crispy forms. I first filter my object, and then I want to display this object as a form, where certain model attributes are display only, with some attributes being updated. Essentially a table containing all attributes for obj that cant be modified, with 2 attributes that will be updated in the form. forms.py: class ReportSampleForm(forms.Form): def __init__(self, *args, **kwargs): super(ReportSampleForm, self).__init__(*args, **kwargs) sample = self.data.get('sample_id', False) obj = VariantAnnotationSampleRun.objects.filter(sample_run_id=sample) self.helper = FormHelper() self.fields['id'] = forms.ChoiceField( required=True, label='blah:', widget=forms.CheckboxSelectMultiple, choices=((s.id, (s.variant_annotation_id.variant_id, s.attribute1, s.attribute2)) for s in obj) ) self.helper.form_method = 'POST' This displays check boxes with variant_id, attribute1 and attribute2, but I would like Model entries 'evidence' and 'annotation' to be filled in and if the checkbox is checked and form submitted, the database gets updated for that specific model entry. models.py: class VariantAnnotationSampleRun(models.Model): variant_annotation_id = models.ForeignKey(VariantAnnotation, attribute1 = models.DecimalField(max_digits=8, decimal_places=3) attribute2 = models.IntegerField() reported = models.BooleanField(default=False) evidence = models.TextField(null=True, blank=True) annotation = models.CharField(max_length=80, null=True, blank=True) Is this possible to do without building a totally bespoke form, from my view? -
Django listview to list only if it receives a true value
my name is Gustavo and I need help, I'm developing an application that generates requests (city hall) I'm using Django 1.11, in my shopping area I have a view using get_context_data to get the objects of my requests and list them. my problem is that there are several sectors and the request will only be listed in the next sector if the previous one approves. in my models.py I have the class Request (Solicitacao) and the class SecretaryApproval (SecretarioAprovacao) that is related to my request. What I need to do is when opening the page he checks all the requests and only lists for me the ones that receive the true value in the variable secretario_aprovacao view.py class Compraslist(LoginRequiredMixin, ListView): model = Solicitacao template_name = 'compraslist.html' def get_context_data(self, **kwargs): context = super(Compraslist, self).get_context_data(**kwargs) context['solicitacoes'] = Solicitacao.objects.all() return context models.py class SecretarioAprovacao(models.Model): secretario_relacionamento = models.ForeignKey(Solicitacao, on_delete=models.CASCADE) secretario_aprovacao_CHOICES = ( (True, 'Sim'), (False, 'Não') ) secretario_aprovacao = models.BooleanField("Aprovar Solicitação?", choices = secretario_aprovacao_CHOICES, default = True, ) class Meta: verbose_name = "Secretario Aprovação" verbose_name_plural = "Secretario Aprovações" thanks for listening. -
django model and csv file zip feature lack
I fixed a lot with your help and I guess we come to last problem; If the line from the csv file not in the my django model database than django mixes up all so that; csv line and django database are no longer going in correct order so all mixed. To prevent this problem I added if queryset count function within the loop to raise an error message or tried also pushing another default value but nothing worked. What you would suggest to prevent this sync problem ? for instance in RFP.objects.filter(FP_Item=query): if RFP.objects.filter(FP_Item=query).count() >= 1: instances.append(instance) else: messages.success(request, "ERROR") For reference the whole code: with open(path, encoding='utf-8') as f: data = csv.reader(f, delimiter='|') for row in data: line = row[0] lines.append(line) query = line for instance in FP.objects.filter(FP_Item=query): if FP.objects.filter(FP_Item=query).count() <= 1: instances.append(instance) else: messages.success(request, "ERROR") pair = zip(lines, instances) context = {'pair': pair, } return render(request, 'check_fp.html', context) -
Django Widget not Loading
I using Django with widgets to get some user input but I can't seem to get it to display even thou the code seems almost identical to examples online. forms.py from django import forms class PickerIDForm(forms.Form): pickeID = forms.NumberInput() views.py def get_id(request): template = loader.get_template('metrics/lance1.html') def get(self, request): form = PickerIDForm() return render(request, 'self.template', {'form': form}) context ={ } return HttpResponse(template.render(context,request)) urls.py from django.urls import path from . import views from . import mark_views app_name = 'metrics' urlpatterns = [ path('', views.index, name='index'), path('test/', views.get_id, name='get_id'), ] test.html {% extends 'base.html' %} {% block content %} <p>User Input</p> <form method = "post" > {% csrf_token %} {{form.as_p}} <button type="submit"> Submit </button> </form> {% endblock %} I'm never directly calling the get function as defined in views.py that to me seems to be a possible source of the input fields not showing up when I load up test.html At what point do you link the disparate parts together? Because it seems I'm missing something. -
django celery how to print or check logging for the task
I have now got django and celery working. but there is no logs print for me to check if the task is working correctly. I am using mac and plan to use celery on production in my ubuntu aws machine. Here is what i do in tasks.py: import string from celery import shared_task import logging @shared_task def send_push_notification_celery(total): logging.debug("send_push_notification_celery") logging.debug("total:%d", total) return "i love you" this is all that gets printed out on celery worker console: [2018-04-12 11:25:08,620: INFO/MainProcess] Received task: myapp.tasks.send_push_notification_celery[322eae85-3ef7-4adb-b3bd-eae90300587b] [2018-04-12 11:25:08,622: INFO/ForkPoolWorker-2] Task myapp.tasks.send_push_notification_celery[322eae85-3ef7-4adb-b3bd-eae90300587b] succeeded in 0.0001755820121616125s: 'i love you' -
Facing issue with "cannot import name models"
My code structure app/admin.py uno.core import models as core_models from app import models class TemplatePageAdmin(admin.ModelAdmin): list_display = ('url', 'template', 'state') list_filter = ('template', 'state') search_fields = ('url', 'template') while am running python manage.py shell am facing issue from uno.core import models as core_models ImportError: cannot import name models thanks in advance
