Django community: RSS
This page, updated regularly, aggregates Django Q&A from the Django community.
-
Django unable to connect to remote mysql
I am trying to connect remote mysql from from django (python 3). I was facing django.db.utils.OperationalError: (2003, "Can't connect to MySQL server on 'ns3100739.supercar.pl' (110)") I have also changed /etc/mysql/my.conf and added following lines bind-address = ns3100739.supercar.pl and tried to restart MySQL with sudo privilege but MySQL not restarting. -
Pdf error after download as Content-Disposition' = attachment
In my rest framework, I have a retrieve method on ModelViewSet as def retrieve(self, request, *args, **kwargs): instance = self.get_object() serializer = self.get_serializer(instance) print(serializer.data) pdf = serializer.data['pdf'] response = Response(pdf, content_type='application/pdf') response['Content-Disposition'] = 'attachment; filename="invoice.pdf"' return response pdf is the model field of the FileField type. I am able to automatically download the pdf file on URL but when I try to open the pdf it gives an error, on chrome is says "Failed to load PDF document" and on pdf viewer is says "not a supported file type or the file has been damaged, (send as an email attachment and not correctly decoded)" What more I need to do to make it work correctly. While the pdf is of the correct format and can be opened directly, Thanks -
Updating Model Field from Views.py
I have a feeling I am missing something obvious and syntax related here so I apologize in advance. I would like the status of a user to be automatically updated when they successfully process a form. # Models.py class Account(AbstractBaseUser): status_list = ( ('R',"RED"), ('B',"BLUE"), ('G',"GREEN"),) status = models.CharField(max_length=1, choices=status_list, default='R') value = models.CharField(max_length=30, unique=False, blank=True) #Forms.py class Form(forms.ModelForm): class Meta: model = Account fields = ('value', ) # Views.py def View(request): if request.POST: form = Form(request.POST, instance=request.user) if form.is_valid(): form.initial = {"value": request.POST['value'],} form.save() #Here is the issue V Account.objects.filter(status=Account.status).update(status='B') return redirect('status') I have tried the solutions presented in both of these two posts: 1. Editing model field from Views.py 2. Object has no attribute 'update' as well as a host of other random and excessively creative combinations. Does anyone happen to know the proper syntax for this call? -
How to filter ModelAdmin autocomplete_fields results from clientside input
This is a followup on this thread: How to filter ModelAdmin autocomplete_fields results with the context of limit_choices_to Uberdude proposed a solution which works great to customize the autoselect queryset based on the field which triggered the request, but I would also need to filter based on input from the client side, most specifically a checkbox which is not a model field, and only for some of the fields in the form as in this form excerpt. I managed to apply the checkbox to the widget by overriding your AutocompleteSelect widget as: class AutocompleteSelectCb(AutocompleteSelect): def render(self, name, value, attrs=None): s = super().render(name, value, attrs) return mark_safe('<div style="margin-bottom:10px;"><input type="checkbox" id="parent1"\ name="parentx" value="1">Search among all kennels</div>' + s) and use that widget only when the fields are present in a autocomplete_cb_fields attribute in the admin: autocomplete_fields = ['breed'] autocomplete_cb_fields = ['father', 'mother'] However, I am not sure how to get my AutocompleteSelectCb widget to send the status of the checkbox so that it can be processed in the get_search_results method. I assume with some js, but how? Any idea? -
How to cache queries in django?
I am fairly new to the concept of caching, trying to use a custom middleware to cache DB queries in django. I tried using Johnny cache but its cache invalidation logic isn't that optimised in my use case. I have a huge table, from which multiple read/write queries are being made. Johnny cache reads into the cache and invalidates it if any write query is made on the particular table. I want to have a more specific cache invalidation in my case. What are some other standard ways to do this? -
Aggregating fields in graphene/django queries
I am writing a graphene/django ORM query, where I need to aggregate the values of a particular field on all my query result objects and return it with the query. Not quite sure how to do that, as this involves some post-processing. Would appreciate it if someone can offer some guidance. Here's some sample code. Django model class 'Market' has an integer field 'num_vendors'. The Graphene wrapper is 'MarketNode' that wraps around the 'Market' model class: Model class: class Market(models.Model): num_vendors = models.IntegerField(....) Graphene class: class MarketNode(DjangoObjectType): Meta: model: Market I'd like the query to return 'market_count' (there are multiple markets) and 'vendor_count' (sum of all 'vendors' across all markets). So the query would look like: allMarkets { market_count vendor_count edges { node { ... ... num_vendors ... } } } For the market_count, I am following this example (this works fine): https://github.com/graphql-python/graphene-django/wiki/Adding-counts-to-DjangoFilterConnectionField For vendor_count (across all markets), I assume I need to iterate over the results and add all the num_vendors fields, after the query is complete and resolved. How can I achieve this? This must be a fairly common-use case, so I am sure graphene provides some hooks to do this. -
How to get login of user who added new position and save it with new record
I'm just starting the adventure with Django. I have almost finished my first very small application but I have last one small problem to solve. I would like to know who added the new record to the database and save his login. No problem to show login on website... Problem is because I don't know how to get login of user who added new position and save it with new record. Because my application is not in english I prepared smallest version of it: my models.py file: from django.db import models from datetime import datetime import socket import getpass from django.contrib.auth.models import User class City(models.Model): city = models.CharField(max_length=40) description = models.CharField(max_length=200, null=True, blank=True) def __str__(self): return self.city class Workers(models.Model): hostname = socket.gethostname() login_username = getpass.getuser() user = User.username name = models.CharField(max_length=200) age = models.DecimalField(max_digits=3, decimal_places=0) hobby = models.CharField(max_length=300) city = models.ForeignKey(City, on_delete=models.CASCADE) description = models.CharField(max_length=200, null=True, blank=True) added_date = models.DateTimeField('added date', default=datetime.now()) computer = models.CharField(max_length=30, default=hostname) computer_user = models.CharField(max_length=10, default=login_username) logged_user = models.CharField(max_length=100, default='user') #<<== place for login user def __str__(self): return self.name my views.py file: from django.shortcuts import render, redirect from .models import Workers from .forms import WorkersForm def all_records(request): records = Workers.objects.all().order_by('id').reverse() context = { 'records': records } … -
Hello im getting this error: TemplateDoesNotExist at / blog/home.html, blog/post_list.html
I have the blog/home.html but idk why the post_list pop up. this only happens when I try to deploy my app to Heroku, when it do the python manage.py runserver everything works. Help is appreciated. -
django email verification before signup allowed
I am trying to build an email verification portion of my application. So the user enters their email, hits submit, and they will get an email with a one-time "token" or link that allows them to access the actual sign up page. How do I go about this with the newer version of django since the from django.contrib.auth.tokens import PasswordResetTokenGenerator from django.utils import six code doesn't seem to be working? The actual error says cannot import name six from django.utils. I see in other answers Getting error cannot import name 'six' from 'django.utils' when using Django 3.0.0 latest version that it has to do with six being dropped from django 3.0. Is there a better way to do verification emails upon registration? -
Setting up SendGrid using Django - User input "from_email"
All the Google searching in the world hasn't answered my question, so hoping someone can help me out. I have a Django based "Contact Me" webpage, which uses a form and the Django send_mail function. My app is hosted through Heroku. When I try to submit an email on my form, the form tries send_mail(subject, message, from_email, ["mypersonal@email.com"]) But I get the following error: (550, b'The from address does not match a verified Sender Identity. Mail cannot be sent until this error is resolved. Visit https://sendgrid.com/docs/for-developers/sending-email/sender-identity/ to see the Sender Identity requirements') This seems to imply to me that the "from_email" needs to be MY verified email on SendGrid, and not the email of the person trying to contact me? What am I missing? My goal is to have user submissions be sent to my @gmail.com address -
pycharm IDE warning on django doc: Expected type 'timedelta', got 'DateTimeField' instead python 3.7
in Django's doc is the following code snippet from django.db import models from django.utils import timezone import datetime class Question(models.Model): question_text = models.CharField(max_length=200) pub_date = models.DateTimeField('date published') def __str__(self): return self.question_text def was_published_recently(self): return self.pub_date >= timezone.now() - datetime.timedelta(days=1) Pycharm highlights self.pub_date and shouts Expected type 'timedelta', got 'DateTimeField' instead How do I get rid of this and do things right? -
Form not saving new object to database
I have a form named ProtocolUserCredentialsForm. The main objective of processCredsForm is is to save the user input for the data_source_username, user, data_source, and data_source_password and assign it these creds in a new object in a database. Get displays the actual form and the html. For Post, it sends the user to a new page with form.html, by clicking submit on the first page (that has upgrade_user_creds.html and the form). When the user clicks the submit button, I need the credentials to save and for a new object to be created. I am just confused on why this is not creating a new ProtocolUserCredentials object in the database when I check admin? There isn't any errors coming up as well. class UpdateCredsView(TemplateView): template_name = 'update_user_creds.html' def processCredsForm(self, request): creds_form = ProtocolUserCredentialsForm(data=request.POST) context = {} obj = ProtocolUserCredentials() obj.user = creds_form['user'] obj.data_source = creds_form['data_source'] obj.data_source_username = creds_form['data_source_username'] obj.data_source_password = creds_form['data_source_password'] if creds_form.is_valid(): credentials = creds_form.save(commit=FALSE) credentials.save if not creds_form.is_valid(): if not (creds_form.non_field_errors()): context['form_errors'] = creds_form.errors context['form1'] = creds_form def get(self, request): context = {} allcreds = ProtocolUserCredentials.objects.all() context = {'form1': ProtocolUserCredentialsForm(), 'allcreds': allcreds} return render(request, 'update_user_creds.html', context) def post(self, request): post_data = request.POST context = {} context = {''} if 'submit_nautilus_creds' … -
Can't install Django to windows. It gives a error called "ModuleNotFoundError: No module named 'pip._vendor.packaging'"
I installed virtual Environment and entered this code py -m pip install virtualenvwrapper-win Then I created a virtual environment called "myproject_01" using this command. mkvirtualenv myproject_01 Then I tried to install Django using this command but it gives an error ""ModuleNotFoundError: No module named 'pip._vendor.packaging'". py -m pip install Django Please help me to fix this error.This is the error I get when I try to install Django -
Specify nested fields Django
I was looking into Django Rest Framework Documentation and I read about Nested Serialization, and how Depth could be used, there it specify the depth of relationships: class AccountSerializer(serializers.ModelSerializer): class Meta: model = Account fields = ['id', 'account_name', 'users', 'created'] depth = 1 But doing in this way, all filds get the depth of 1, how can I specify wich field I want to be nested, like, for account_name, use a depth = 1, and for user a depth = 2 -
Forms fields respecting DRY django
Given some forms in Django (take the following for simplicity) class LoginRegisterForm(forms.Form): email = forms.EmailField(label="Email", max_length=100) password = forms.CharField(label="Password", widget=forms.PasswordInput(), max_length=100) We're trying to restrict the submission of these forms if there are additional fields submitted so we have the following added method to our form class def correct_fields(self): return set(self.data.keys()) == {"Email", "Password"} And the following code in the views.py method corresponding to the submission of this form: if form.is_valid() and form.correct_fields: How can we avoid having to write Email and Password in both the definition of the form and the correct_fields method? Does django offer a build-in function to prevent forms being submitted if the correct fields are not submitted? (The form is still submitted if the correct fields and some additional fields are given). If this functionality is not given, how do I avoid writing the fields twice? -
Django send_mail method : Include session userid in mail message
I was able to use send_mail method and it works without any problem. What I am trying to achieve is to include session's username in mail message. My views.py allow a certain authenticated user to create numbers. On successful addition of numbers, an email is triggered to the administrators, which at the moment does not include user's userid. So the administrators have no way of knowing which user created the numbers. My attempt to get userid displayed in mail body below. I also tried another variant - #send mail subject= 'Numbers created by {request.user}' message = 'This user {request.user} has created numbers. ' from_email= settings.EMAIL_HOST_USER to_list = [settings.EMAIL_ADMIN] -
HTTP ERROR 405 when i submit my form.how to fix this?
first i went to url /idontknow/ the html of the template belonging to this url: <body> <form action="{% url 'polls:idk' %}" method="post"> {% csrf_token %} {{ form }} <input type="submit" value="Submit"> </body> it loaded my form input the data and then submitted the form. after i submitted it gave me the 405 error , how to solve this such that when i submit i want the same page to reload but with my submiited data inside form. MY View: class IDK(FormView): form_class=NameForm template_name = "polls/idk.html" success_url = "polls/idontknow/" def form_valid(self, form): print("DATA="+form) return super(IDK, self).form_valid(form) my urls: path('idontknow/', views.IDK.as_view(), name='idk'), -
How can I fix this sign up function?
from django.contrib.auth.forms import UserCreationForm from django.shortcuts import render, redirect from django.urls import reverse_lazy def SignUp(request): if request.user.is_authenticated: return redirect('home') else: form = UserCreationForm success_url = reverse_lazy('login') return render(request, 'signup.html', {'form': form}) When I try to sign up it just refreshes the page, but nothing works, the user isn't registered. So how can I fix this? Thanks -
Using Either Slug or PK in URL (Python - Django)
I want the user to access posts using either the PK or Slug. I can get http://localhost:8000/post/8/ to work but not http://localhost:8000/post/working-in-malaysia/. I have looked at a few posts on Stack Overflow but I don't want http://localhost:8000/post/8/working-in-malaysia. And I don't want it to be a case of either the PK works. Or the slug works. I want the user to be able to enter either. Below is the code I have tried. I tried to merge together code I saw in a number of other posts. Sadly to no avail. urls.py urlpatterns = [ path('', PostListView.as_view(), name='blog-home'), path('post/<int:pk>/', views.post_detail, name='post-detail'), #path('post/<slug:the_slug>/', views.post_detail, name='post-detail-slug'), path('post/<slug:url>/', views.post_detail, name='post-detail-slug'), path('post/new/', PostCreateView.as_view(), name='post-create'), path('post/<int:pk>/update/', PostUpdateView.as_view(), name='post-update'), path('post/<int:pk>/delete/', PostDeleteView.as_view(), name='post-delete'), path('about/', views.about, name='blog-about'), path('facebook/',TemplateView.as_view(template_name='blog/index.html'), name="facebook") ] views.py class PostDetailView(DetailView): model = Post # Should match the value after ':' from url <slug:the_slug> #slug_url_kwarg = 'the_slug' slug_url_kwarg = 'url' pk_url_kwarg = "id" # Should match the name of the slug field on the model slug_field = 'url' # DetailView's default value: optional query_pk_and_slug = True def dispatch(): post = get_object_or_404(Post) comments = post.comments.filter(active=True, slug=slug) new_comment = None if request.method == 'POST': comment_form = CommentForm(data=request.POST) if comment_form.is_valid(): new_comment = comment_form.save(commit=False) new_comment.post = post new_comment.save() else: comment_form = … -
Django select random post elemets efficiently
I have some post models where the ID is a UUID. Now I want to display some random post proposals the user may also like to see at my post_detail template... This is how I process the post proposals the user may also like to see at views.py: def post_proposals(proposal_count): post_elements = sorted( chain( Model1.objects.all(), Model2.objects.all(), Model3.objects.all() ) ) post_elements_list = list(post_elements) # Conversion to list is requierd by random post_proposals = random.sample(post_elements_list, proposal_count) return post_proposals def post_detail(request, pk): ... args = { 'post': post, 'post_proposals': post_proposals(proposal_count=10), ... template.html: {% for post_proposal in post_proposals %} <h1>{{ post_proposal.title }}</h1> {% endfor %} The problem now is that this would kill my database performance from my understanding... As soon as I have a lot of posts stored at my database the query will become massive. I first have to get all elements of 3 models and then get 10 random entries from the list each time a post gets displayed to the user. I also found the following which seems to be quite useful: https://elpenia.wordpress.com/2010/05/11/getting-random-objects-from-a-queryset-in-django/ Sadly I can't use that solution as I work with UUIDs which are non-sequential strings instead of int values I would have with IDs. -
python *args as an tuple? directory?
How can I turn a phrasebook into a *argument I mean, specifically, the example in django we have: .order_by('field1', 'field2'...) and I'd like to do if sort =="byName": a=[] #???? a.append('name') a.append('surname') .order_by(a) #??? -
Am trying to deploy my django app on heroku using gcs google cloud storage
Am trying to deploy my django app on heroku using gcs google cloud storage as my storage it can't find the json file enter image description here -
DJANGO: How to use custom user types for social login?
I have custom models for users with multiple user types. Like user1@gmail.com is type A, and he/she can do a,b and c thing, user2@outlook.com is type B, and he/she can do a,b,d or e thing. And that system is working perfectly. But I have an option to login via google and Facebook via social_django, and office365 login via django-microsoft-auth. So how can I add that users (from login via Google, Facebook etc.) to user types for normal users? Also can I add the to existing user types or I need new ones? -
Django - How can I get birthday and gender using GoogleOAuth2
I managed to set google login working well but I am trying to get additional information from the users, specifically gender and birthday. Unfortunately I am having trouble trying to achieve this. Here are my configurations in settings.py: SOCIAL_AUTH_GOOGLE_OAUTH2_KEY = 'xxxx' SOCIAL_AUTH_GOOGLE_OAUTH2_SECRET = 'xxxx' SOCIAL_AUTH_GOOGLE_OAUTH_SCOPE = [ 'https://www.googleapis.com/auth/user.birthday.read', ] 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', # <--- enable this one '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', ) After adding the link to the scope I was expecting to get the birthday but when I check the response from: https://www.googleapis.com/oauth2/v1/userinfo?access_token='xxxx' I get the following response: { "id": "xx", "email": "xx@gmail.com", "verified_email": true, "name": "xx", "given_name": "xx", "family_name": "xx", "picture": "https://xx.com/a-/xx", "locale": "xx" } As you can see birthday is missing. Anyone that got through this one out there? Thanks -
Django: request.POST.get from form data not working correctly
I have been trying to come up with a solution and have been searching the web for hours now. I hope you guys can help me find the problem in my code! I am trying to implement a form in Django, a simple textfield. As soon as the user submits the text data in the field, I want it to POST the data and I want a next view to retrieve that data and print it on screen. In detail: I want the user to enter some text in the form on page home.html then submit it, and the user input will then be printed on the next page predict.html (of course, I am planning to transform the inpur in between, but first I want the text to at least get printed on the second page). This is my code: views.py from django.shortcuts import render from django.http import HttpResponse from .forms import NameForm from django.template import RequestContext def index(request): return render(request, 'personal/home.html') def predicted(request): predicted = request.POST.get('data') return render(request, 'personal/predicted.html', {"predicted": predicted}) def get_name(request): if request.method == 'POST': if form.is_valid(): return render_to_response('personal/predcited.html', RequestContext(request)) else: form = NameForm() return render(request, 'home.html', {'form': form}) forms.py from django import forms class NameForm(forms.Form): data …
