Django community: RSS
This page, updated regularly, aggregates Django Q&A from the Django community.
-
Best place to retry a task in Django: requests or celery task
I am hitting an API using requests library in Django inside a celery task. To be very specific, it fetches some record from database, prepares a json and does a POST request. In the certain case scenario, the call fails with 500 error code. I want to retry the POST request again. What's the best way to go about it and why? Retry the Celery task itself (See implementation) Retry the request using urllib.util.retry (See full implementation) -
How to download the multiple bokeh images as a single report
My application is hosted on Django and one of the html pages shows multiple bar graphs which are drawn using Bokeh. I know we can download each graph separately by using SaveTool icon which comes with Bokeh. Now my requirement is I want to have a export button in the page, when I click on export button, all the images should be downloaded in a single pdf file or any other format what ever is the easier option to implement. Please guide me how can I achieve this? Thanks In Advance. -
Django prefetch_related seem to not work as expected
Descirption There is a Foo model that has a ForeignKey field bar: class Foo(models.Model): ... bar = models.ManyToManyField('bar.Bar', related_name='some_bar') ... Also Foo has get_config() method which returns its fields including bar like: def get_config(self): return { ... 'bar': map(lambda x: x.get_config(), self.bar.all()) ... Now there are 10,000 rows of Foo in the database. There are some Bar rows as well. Trying to retrieve the data about 10,000 Foo including the nested Bar data: query = Foo.objects.all().prefetch_related('bar') return [obj.get_config() for obj in query] Problem The query executes around 6 seconds. If there is no bar field - only 400 milliseconds. The prefetch seems to not work completely bar.get_config() seem to hit the database for each iteration step. It is supposed to simply load all Bar objects once and get config from that bar-query to populate each foo config. -
Django custom management commands still ouputs errors
I'm just trying to use Django mixer library to generate users. Sometimes, when then username already exists, there's an error, and even though I did a try-except and the loop continues, which implies I catch the right exception, the error is displayed (django.db.utils.IntegrityError: Mixer (): ERROR: the value of a duplicated key breaks the unique constraint « auth_user_username_key »). How to hide those errors? class Command(BaseCommand): help = "Populate database for testing purposes only" def handle(self, *args, **options): # Generate a random user for i in range(4000): try: user = mixer.blend(User) person = Person.objects.get(user=user) except IntegrityError: continue -
How to display the image from ImageField() in Django admin interface?
I want to display a small thumbnail-like image in my Django admin interface. How should I do this? Also, It doesnt seem to display any SVG files. Please do help models.py: from django.db import models import os from PIL import Image from datetime import date import datetime from .validators import validate_file_extension import base64 def get_directory_path(instance, filename): today = date.today() t = datetime.datetime.now() day, month, year = today.day, today.month, today.year hour, minutes, seconds = t.hour, t.minute, t.second filename = str(day) + str(month) + str(year) + str(hour) + str(minutes) + str(seconds) + '.png' dir = 'media' path = '{0}/{1}'.format(dir, filename) return path class Image(models.Model): image = models.FileField(upload_to = get_directory_path, null = True , validators=[validate_file_extension]) created_date = models.DateTimeField(auto_now = True) def __str__(self): return str(self.id) -
What signals.py should be for Django Rest Password Reset?
What signals.py should be for Django Rest Password Reset? Or is there another way to set up password reset functionality? -
.only().prefetch_related() gives 'ManyToOneRel' object has no attribute 'attname'
i am fetching required fields of a table after a select_related() and prefetch_related() on the same query using .only() I can't seem to get the result from prefetch_related probably because .only() is restricting access to its result ? I have tried adding prefetch_related field in .only() as well but to no avail. Feedback.objects.all().select_related( 'feedback_option' ).only( 'feedback_option', # tried with and without either one or both of the following 'feedback__remarks', 'feedback__remarks__text' ).prefetch_related( Prefetch( 'feedback__remarks', queryset=FeedbackRemark.objects.all().only('text'), ), ) I am getting the following exception because of this. AttributeError: 'ManyToOneRel' object has no attribute 'attname' I am using django 1.10.5 -
How to create a relative max-length constraint on Many-to-Many field in django?
I'm working on an educational django project as an intern and have got trouble with a database constraint on length of many-to-many field. I have a Trip model that contains a capacity field which is an IntegerField and a passeger field which is many-to-many. So I want to create a constraint that number of passengers of a trip never get more than trip's capacity. Can anybody help me with this problem? I have tied the CheckConstraints but faild to handle it with join attribute. class Trip(models.Model): WAITING_STATUS = 'wa' CLOSED_STATUS = 'cl' IN_ROUTE_STATUS = 'in' DONE_STATUS = 'dn' STATUS_CHOICES = [ (WAITING_STATUS, 'waiting'), (CLOSED_STATUS, 'closed'), (IN_ROUTE_STATUS, 'in route'), (DONE_STATUS, 'done') ] source = gis_models.PointField() destination = gis_models.PointField() is_private = models.BooleanField(default=False) passengers = models.ManyToManyField(Member, through="Companionship", related_name='partaking_trips') groups = models.ManyToManyField(Group, through="TripGroups") car_provider = models.ForeignKey(Member, on_delete=models.SET_NULL, related_name='driving_trips', null=True) status = models.CharField(max_length=2, choices=STATUS_CHOICES) capacity = models.PositiveSmallIntegerField(validators=[MaxValueValidator(20)]) start_estimation = models.DateTimeField() end_estimation = models.DateTimeField() trip_description = models.CharField(max_length=200, null=True) class Companionship(models.Model): member = models.ForeignKey(Member, on_delete=models.CASCADE) trip = models.ForeignKey(Trip, on_delete=models.CASCADE) source = gis_models.PointField() destination = gis_models.PointField() I got error "joined field references are not permitted in this query" when tried to migrate. -
Uncaught TypeError: Cannot read property 'showExportPDFDialog' of undefined at exportToPDF
I try to achieve a method that when I click the button, the webpage can show different views(based on which button I click). But after I run the server, I get this: VM2134:21 Uncaught TypeError: Cannot read property 'showExportPDFDialog' of undefined. I created button divs and used ajax. So if I click Page_1/Page_2/Page_3, the webpage can show up different content. I initial variables Page_1/2/3 and sent them back to Django. In the Django, I will compare data. If they are matched, it will jump to the desired html file web.html <button id="Page_1">customer</div> <button id="Page_2">mobile</div> <button id="Page_3">meeting</div> <script type="text/javascript"> $(document).ready(function(){ var id="Page_1" $("#Page_1").click(function(){ $.ajax({ url:"{% url "sheet" %}", data:{Page_1:id}, success:function(result){$("#vizContainersk").html(result);} }); }); }); ..... the rest of ajax are same as above one view.py @api_view(['GET']) def get_tableau_url(request): return render(request, 'web.html') def sheet(request): url ='http://xx.xx.xxx.xx:8000/trusted?username=some_name&target_site=demo' result = requests.post(url, timeout=15) context={} context['token'] = result.text q1 = request.GET.get('Page_1') s1 = "Page_1" q2 = request.GET.get('Page_2') s2 = "Page_2" q3 = request.GET.get('Page_3') s3 = "Page_3" if (q1 == s1): return render(request, 'sheet0.html', context) if (q2 == s2): return render(request, 'sheet1.html', context) if (q3 == s3): return render(request, 'sheet2.html', context) sheet0.html var viz; function initViz() { var containerDiv = document.getElementById("vizContainer"); var options = { width: '1300px', height: … -
how to search multiple classes in the model
i have a django project that include 1 model file consist of 2 classes class Folder class suspect Note these 2 classes are not related. i have a search form that allow user to filter in both classes. based on the answer of this question Django search fields in multiple models i used the itertools and import chain but i did not success in returning the correct result. views.py from django.db.models import Q from itertools import chain def searchFolder(request): print("search function") query = request.GET.get('q') folders = Folder.objects.filter(Q(FolderNum__icontains= query)) suspects = suspect.objects.filter( Q(suspect_name__icontains=query)| Q(suspect_father_name__icontains=query)| Q(suspect_mother_name__icontains=query)| Q(content__icontains=query)| Q(create_date__icontains=query) ).distinct() result = chain(folders,suspects) print(result) return render(request,'blog/update2.html',{"result":result}) the result displayed on the templates is <itertools.chain object at 0x000001ACF217DC88> -
Get current user in tasks.py Celery-Django
I'm using Celery in a Django project and I'm trying to get the current user in file tasks.py. I don't want to use "User.objects.get(id)" because I can't pass an argument (id) to the function. Is there something similar to "request.user" that I can use? Thanks a lot. -
django edit inline-formset data
i have a department form with inline formset for deparment's IP list. i'm trying to show the existing department and it's IPs and edit them if needed, but when i submit the form, change_data for form works fine but formset.has_changed always return true. I can add department using this form and formset in another template and everything works fine. but here i want to edit the form(add/remove or edit ips). models.py class Department(models.Model): name = models.CharField(unique=True, max_length=100) username = models.CharField(max_length=100) password = models.CharField(max_length=200) class Meta: managed = False db_table = 'department' class DepartmentIps(models.Model): department = models.ForeignKey(Department, models.DO_NOTHING) department_ip_from = models.CharField(unique=True, max_length=15) department_ip_to = models.CharField(unique=True, max_length=15) class Meta: managed = False db_table = 'department_ips' forms.py class DepartmentForm(ModelForm): class Meta: model = Department DepartmentIPFormset = inlineformset_factory(Department, DepartmentIps, exclude=('department',), widgets={'department_ip_from': forms.TextInput( attrs={'size': '6', 'class': 'form-control'), 'department_ip_to': forms.TextInput( attrs={'size': '6', 'class': 'form-control'), }, extra=0, can_delete=True, validate_min=True, min_num=1) views.py def setting_department(request, department=1): currnet_d = Department.objects.get(id=department) if request.method == "POST": if 'add-department' in request.POST: department_form = DepartmentForm(request.POST) department_formset = DepartmentIPFormset(request.POST or None, instance=department_form.instance) if department_form.is_valid() and department_formset.is_valid(): new_department = department_form.save() department_formset.save() if 'edit-department' in request.POST: department_form = DepartmentForm(request.POST, prefix='edit', instance=currnet_d) department_formset = DepartmentIPFormset(request.POST or None, prefix='editips') print(department_formset.has_changed()) for formss in department_formset: print(formss.changed_data) print(department_form.has_changed()) department_form = DepartmentForm() … -
Pass JWT token as authorization header to url tag in django template
I want to send authorization header with djnago url template tag. But i am unable to find a solution I tried sending authorization header as query parameter but when i receive the token, i am unable to modify the request header in django views. It only allows to modify the custom header -
Django: IntegrityError when migrating after adding foreign key field
I have three models as follows in a Django app named markets: class Market(models.Model): title = models.CharField(max_length=50, default="") current_price = models.DecimalField(max_digits=5, decimal_places=2, default=0.50) description = models.TextField(default="") shares_yes = models.IntegerField(default=0) shares_no = models.IntegerField(default=0) b = models.IntegerField(default=100) cost_function = models.IntegerField(default=0) open = models.BooleanField(default=True) def __str__(self): return self.title[:50] def get_absolute_url(self): return reverse('market_detail', args=[str(self.id)]) class Price(models.Model): market = models.ForeignKey( Market, on_delete=models.CASCADE, related_name='prices', default=None) price = models.DecimalField( max_digits=5, decimal_places=2, default=0.50) price_date = models.DateTimeField( default=now, blank=True) def __str__(self): return str(self.price) def get_absolute_url(self): return reverse('market_list') class Share(models.Model): user = models.ForeignKey('users.CustomUser', on_delete=models.CASCADE, related_name='user_shares', default=None) market = models.ForeignKey( Market, on_delete=models.CASCADE, related_name='market_shares', default=None) share = models.IntegerField(default=0) transaction_date = models.DateTimeField( default=now, blank=True) def __str__(self): return str(self.share) def get_absolute_url(self): return reverse('market_list') I would like to add the following foreign key field to the Price model: user = models.ForeignKey('users.CustomUser', on_delete=models.CASCADE, related_name='user_prices', default=None) When I run makemigrations on markets, there's no issue. But when I try to actually migrate the database, I get the following error: django.db.utils.IntegrityError: column "user_id" contains null values Why is that? I had no issues adding a user field to the Share model, so am not clear on why I run into problems when also looking to add it to Price. -
Call callable function in django-ratelimit
I have code as follow: callables function def get_limited_num(group, request): if request.user.is_authenticated: qs = NumberOfLimitedLogin.objects.all() if qs is None: return '1/d' data = qs.first() return '{0}/{1}'.format(data.numer, data.unit) return '1/d' ratelimit function @ratelimit(key='post:email', rate=????, method=['POST']) def demo(request): return 'hello' I want to replace ? by the first function, but I don't know how to call. Help me, please. -
Django rest framework | Knox authentication password not hashed in database
I have created serializer for registering users in Django with djangorestframework. I am also using django-rest-knox for token authentication. Problem is that passwords are not hashed in database when creating users. Below is the code of serializer: class RegisterSerializer(serializers.ModelSerializer): class Meta: model = User fields = ('id', 'username', 'email', 'password') extra_kwargs = {'password': {'write_only': True}} def create(self, validated_data): # user = User.objects.create_user( # validated_data['username'], validated_data['email'], validated_data['password']) user = User( username=validated_data['username'], email=validated_data['email']) user.set_password(validated_data['password']) user.save() return user Please note that I have tried both commented and uncommented methods of creating user in the above code. In both cases, passwords are saved as raw in database. Below is the part of settings.py related to implementing knox token authentication: REST_FRAMEWORK = { 'DEFAULT_AUTHENTICATION_CLASSES': ('knox.auth.TokenAuthentication',) } Any suggestions why password are not hashed? -
Test UpdateView for useraccounts application
Test doesn't give status_code 302 in user profile UpdateView and so there's no updates occurs on the object the model code class User(AbstractBaseUser, PermissionsMixin): ''' This a replaced user profile instead of the default django one ''' language_choices=[('en',_('English')),('se',_('Swedish'))] email=models.CharField(verbose_name=_('Email'), max_length=128, blank=False, unique=True) first_name=models.CharField(verbose_name=_('First Name'), max_length=128) last_name=models.CharField(verbose_name=_('Last Name'), max_length=128) joined_at=models.DateField( verbose_name=_('Joined at'), auto_now_add=True, blank=False ) language=models.CharField( verbose_name=_('Language'), max_length=2, choices=language_choices, default=language_choices[0][0] ) active=models.BooleanField(verbose_name=_('Active'), default=False) is_superuser=models.BooleanField(verbose_name=_('Is Superuser'), default=False) is_active=models.BooleanField(verbose_name=_('Is Active'), default=True) is_staff=models.BooleanField(verbose_name=_('Is Staff'), default=False) The form code class EditUserForm(UserChangeForm): ''' Profile form to update existing user information ''' # error message for email matches error_messages = { 'email_mismatch': _("The two email fields didn't match."), } # create field for email email1 = forms.EmailField( label=_("Email"), widget=forms.EmailInput, help_text=_("If you change your email your account will be inactive untill your reactivate by email link."), ) # get the email from confirmed email field email2 = forms.EmailField( label=_("Confirm Email"), widget=forms.EmailInput, help_text=_("Enter the same email as before, for verification."), ) # hide password field password = ReadOnlyPasswordHashField(label="Password") class Meta: ''' Initial fields and model for the form ''' model = models.User fields = ('first_name','last_name','email1','email2', 'language') def clean_email2(self): ''' Method for if email and confirmed email are the same This method works when confirmed email cleared ''' # get … -
Django MySQL REPEATABLE READ "data loss"
I'm looking for information about what is behind the entry in Django 2.0 release notes. Stating: MySQL’s default isolation level, repeatable read, may cause data loss in typical Django usage. To prevent that and for consistency with other databases, the default isolation level is now read committed. You can use the DATABASES setting to use a different isolation level, if needed. As I understand repeatable read is "stricter" than read commited, so what is Django doing to produce "data loss" is a question bugging me for sometime now. Is it stuff like prefetch_related? Or maybe in general making an UPDATE based on potentially stale (SELECTED earlier in a thread) is or can be considered data loos? Or even better - maybe there's something that only MySQL does or has a bug that makes it dangerous on repeatable read? Thank you. -
Django redirect with a custom error message
I'm new in using django templating/frontend and I would like to redirect to a page with a custom message in django. Here's what I've tried but I can't make It work. View return redirect("/login",custom_error="Try Again Later") Login.html {% if custom_error %} <p class="errornote"> {{ custom_error }} </p> {% endif %} Any suggestions on how to make this work? -
How to make all the contents visible in dropdown menu in django?
I have made a dropdown menu so that a user could select one option but whenever I click on dropdown menu, all the contents hide itself except the one I hover a mouse on it. How to make all the contents visible? I think the problem is in profile.html but not understanding how to deal with it? forms.py class ProfileUpdateForm(forms.ModelForm): class Meta: model = Profile fields = ['image','payment_method','detail'] models.py class Profile(models.Model): user = models.OneToOneField(User, on_delete=models.CASCADE) payment_method = models.CharField(max_length=10, choices=Paymet_choices) profile.html {{p_form|crispy}} -
How to convert an uploaded image to base64 and decode it back, and save the file as PNG?
I'm creating an image upload page which allows users to upload pages. When a user uploads an image, I want to convert that image using base64 and decode it back to a new image and save it in a PNG format extension. How do I do this? You can view my current models.py code: from django.db import models import os from PIL import Image from datetime import date import datetime from .validators import validate_file_extension import base64 def get_directory_path(instance, filename): today = date.today() t = datetime.datetime.now() day, month, year = today.day, today.month, today.year hour, minutes, seconds = t.hour, t.minute, t.second filename = str(day) + str(month) + str(year) + str(hour) + str(minutes) + str(seconds) + '.png' dir = 'media' path = '{0}/{1}'.format(dir, filename) return path class Image(models.Model): image = models.FileField(upload_to = get_directory_path, default = 'media/sample.png', validators=[validate_file_extension]) created_date = models.DateTimeField(auto_now = True) def __str__(self): return str(self.id) -
how to filter a database table row and update a specific column in django?
i have a database table and i want to filter it by id and update a specific object (column) with an if condition that i have write. but it get an error: attributeError: 'int' object has no attribute 'save' if current_complete['current_complete'] == 65 and optimestic: optimestic_percentagex = current_complete['current_complete'] * weight['weight'] if probable or pessimistic: probable_percentage = current_complete['current_complete'] * weight['weight'] pessimistic_percentage = current_complete['current_complete'] * weight['weight'] obj = Forcast.objects.filter(id=id).update(optimestic_percentage=optimestic_percentagex).save() obj.save() i except that i can update optimestic_percentage with the if condition that i have created. -
Why doesn't the 'follow' button on django work?
I'm using Django 2.2 and PostgreSql. I'm trying to create a simple app that I want to follow neighboring users. 'Follow' button will increase the number of followed, 'Unfollow' button will decrease the number of followed. However, the 'Follow' button does not work. How can I solve this problem? following/models.py class Following(models.Model): follower = models.ForeignKey(User, on_delete=models.CASCADE, related_name='fallower', null=True) followed = models.ForeignKey(User, on_delete=models.CASCADE, null=True, related_name='fallowing') following/views.py def user_follow_unfollow(request): response = sub_user_follow_unfollow(request) data = response.get('data') followed = response.get('followed') numbers_followed_and_follower= Following.user_followed_and_follower(followed) context = {'user': followed, 'followers': numbers_followed_and_follower['followers'], 'followeds': numbers_followed_and_follower['followeds']} html = render_to_string('following/following_partion.html', context=context, request=request) data.update({'html': html}) return JsonResponse(data=data) templates.following_partion.html {% if request.neighbor_detail != user %} <div> <button followed='{{ neighbor_detail.username }}' followed='{{ request.neighbor_detail.username }}' url="{% url 'following:user_follow_and_unfollow' %}" id="follow_unfollow_button" class="btn btn-lg btn-success"> {% if does_follow_the_user%} <b>Unfollow</b> {% else %} <b>Follow</b> {% endif %} </button> </div> {% endif %} <div class="followers col-lg-offset-3 col-md-3 col-md-offset-3 col-lg-3 text-center"> <span><b>followers</b></span> <button url="{% url 'following:fallowed-or-fallowers-list' 'fallowers' %}" follow_type="followers" username="{{ neighbor_detail.username }}" class="follow_button btn-block btn btn-primary"> {{ followers}} </button> <div class="followeds col-lg-3 col-md-3 text-center"> <span><b>Followeds</b></span> <button url="{% url 'following:followed-or-followers-list' 'followed' %}" follow_type="followed" username="{{ neighbor_detail.username }}" class="follow_button btn-block btn btn-success"> {{ followeds}} </button> my script <script> $("#follow_unfollow_button").click(function () { var $this = $(this); var $url = $this.attr('url'); var $takip_eden = $this.attr('follower'); … -
Path to my media file won't work in django project
I've tried to put my site that I've designed into django, and I've encountered some problemes with paths to my media file in css and javascript but now my css paths work but my javascripts file don't. Thanks in advance for any help provided! I've tried to change my STATIC_URL and all but it didn't work. it seems like django is changing my path for no reason. My project tree: https://ibb.co/DbNB2Tr WORKING: How I wrote my Path into css (works.css in my project) @font-face { font-family: gameboy; src: url('media/font/gameboy.ttf'); } background-image: url('media/gif/drive3.gif'); NOT WORKING: How I wrote my Path into javascript (works.js in my project) var pic1 = 'media/picture/travis.jpg'; var pic2 = 'media/picture/snoop.jpg'; var pic3 = 'media/gif/vash.gif'; var pic4 = 'media/picture/snoop.jpg'; The http response: [07/Aug/2019 10:23:51] "GET /works/media/picture/snoop.jpg HTTP/1.1" 404 3066 My Settings file: Django settings for Music project. Generated by 'django-admin startproject' using Django 2.1.2. For more information on this file, see https://docs.djangoproject.com/en/2.1/topics/settings/ For the full list of settings and their values, see https://docs.djangoproject.com/en/2.1/ref/settings/ """ import os # Build paths inside the project like this: os.path.join(BASE_DIR, ...) BASE_DIR = os.path.dirname(os.path.dirname(os.path.abspath(__file__))) # Quick-start development settings - unsuitable for production # See https://docs.djangoproject.com/en/2.1/howto/deployment/checklist/ # SECURITY WARNING: keep the secret key used … -
Pytest do endless collecting of tests and doesb`t start
When I am running pytest command it starts to collect all tests, but this process is endless without any errors or mistakes. I don't understand what is the reason. If you have any ideas, please could you share them? Also if it helps I run it on MacOS, on my Ubuntu computer it works perfect. This is what happened: Test session starts (platform: linux, Python 3.7.3, pytest 5.0.1, pytest-sugar 0.9.2) Django settings: settings (from ini file) rootdir: /home/roziukp/space11/backend, inifile: setup.cfg plugins: xdist-1.29.0, forked-1.0.2, pythonpath-0.7.3, env-0.6.2, django-3.5.1, sugar-0.9.2, celery-4.3.0, cov-2.7.1, mock-1.10.4 collecting ...
