Django community: Django Q&A RSS
This page, updated regularly, aggregates Django Q&A from the Django community.
-
Id seems to be not existent in django model: that's why no reverse match is found
I have a django model for which I am writing my delete view. I get an django.urls.exceptions.NoReverseMatch error. That is also logical since when I am trying to debug and I want to output my id with {{ model.id }} my view shows me no id at all. When I use the pk it passes in my urls. My model: class UrlTrack(models.Model): url = models.CharField(max_length=255, primary_key=True) counter = models.BigIntegerField(default=0) My view: class AnalyticsDeleteUrls(SingleObjectMixin, View): model = UrlTrack def get(self, request, *args, **kwargs): obj = self.get_object() if obj is not None: obj.delete() return redirect('list_history') My urls: path('history/delete/urls/<int:id>/', AnalyticsDeleteUrls.as_view(), name="history_url"), My template: {% for item in url_tracks %} <tr> <td>{{ item.url }}</td> <td>{{ item.counter }}</td> <td> <a class="btn btn-danger" href="{% url 'history_url' item.id %}"> Delete </a> </tr> {% endfor %} Why would the id be non existent? I though django passes that in automatically....? Any help is highly appreciated. Thanks in advance -
Mezzanine blog custom tag to show highest rated blogs
I'm very new to Mezzanine. I'd like to be able to create a custom blog tag similar to mezzanine.blog.templatetags.blog_tags.blog_recent_posts except it would be mezzanine.blog.templatetags.blog_tags.blog_top_rated_posts which would return the top n rated blog posts. -
Django objects.filter(date...) - template implementation
I've got a function which sends an email with expenses. Everything works fine, but I have no idea how to implement a small part of the code into a template and give for the user an option to choose a period of time. For example: user should choose a year and month from the template. def mail_from_web(request): email = EmailMessage('Your expenses', 'Hello there. Some text', 'email@from', ['email@to']) attachment_csv_file = StringIO() writer = csv.writer(attachment_csv_file, delimiter=',') writer.writerow(['Date', 'Customer', 'Car park']) for call in Call.objects.filter(date__year='2019', date__month='04').order_by('date'): writer.writerow([call.date_start.strftime("%Y-%m-%d"), call.customer, call.expenses]) email.attach('expenses.csv', attachment_csv_file.getvalue(), 'text/csv') email.send(fail_silently=False) return render(request, 'calls/mail_sent.html') Instead of this: objects.filter(date__year='2019', date__month='04') -
How to provide default value in Wagtail Page.title field?
All I need is just randomly generated page title, something among the lines: class MyBasePage(Page): title = models.CharField( default=uuid4, verbose_name=_('title'), max_length=255, help_text=_("The page title as you'd like it to be seen by the public") ) class OtherPage(MyBasePage): pass Currently I'm blocked by the following error: django.core.exceptions.FieldError: Local field 'title' in class 'MyBasePage' clashes with field of the same name from base class 'Page'. Any ideas how to achieve this? -
I am trying to show the output of machine learning on a webpage and i am using django for it, how to get the output on a webpage?
I am accessing the csv file using pandas pd.read_csv but the webpage shows server error 500.I am using django framework but i am unable to understand how to upload a csv file and then apply my machine learning algorithm written in a .py file on that csv to show the output. i expect the output to be the final answer after applying the machine learning algorithm to the csv fle(the prediction value), but getting the output as server error 500 -
how to save many to many field using django custom forms
how can i save many courses to the student table .I want to keep my design like this.This code is not saving the many to many field(courses) through AddStudentForm.It returns an error with courses variable. how can i save many courses to the student table .I want to keep my design like this.This code is not saving the many to many field(courses) through AddStudentForm.It returns an error with courses variable. models.py class Course(models.Model): title = models.CharField(max_length=250) price = models.IntegerField(default=0) duration = models.CharField(max_length=50) def __str__(self): return self.title class Student(models.Model): name = models.CharField(max_length=100) courses = models.ManyToManyField(Course) email = models.EmailField() image = models.ImageField(upload_to='Students',blank=True) def __str__(self): return self.name forms.py class AddStudentForm(forms.ModelForm): # courses = forms.ModelMultipleChoiceField(widget=forms.CheckboxSelectMultiple, queryset=Course.objects.all()) class Meta: model = Student fields = ['name','courses','email','phone','image'] def __init__(self, *args, **kwargs): super(AddStudentForm, self).__init__(*args, **kwargs) self.fields["courses"].widget = CheckboxSelectMultiple() self.fields["courses"].queryset = Course.objects.all() views.py def addstudent(request): courses = Course.objects.all() if request.method == 'POST': form = AddStudentForm(request.POST,request.FILES) if form.is_valid(): student = form.save(commit=False) course = form.cleaned_data['courses'] student.courses = course student.save() # student.save_m2m() # student.courses.set(course) # this method also didn't helped me messages.success(request, 'student with name {} added.'.format(student.name)) return redirect('students:add_student') else: # messages.error(request,'Error in form.Try again') return HttpResponse(form.errors) # this block is called and returns courses else: form = AddStudentForm() return render(request,'students/add_student.html',{'form':form,'courses':courses}) add_student.html ... -
Django pytest test unauthorized access to a view
I'm trying to test a protected view. Unauthenticated user are redirect to login page. When I run the test, it raises django.cose.exceptions.PermissionDenied which is normal but how could I write it without getting a failure and how can I test if the redirection is correct? Here is what I've done. class TestProtectedRegistrationListView: """ Verify registration views are protected from unauthenticated access. """ def test_access_url( self, user: settings.AUTH_USER_MODEL, request_factory: RequestFactory ): view = RegistrationListView.as_view() request = request_factory.get("/admin_staff/registrations") request.user = user resp = view(request) assert resp == PermissionDenied -
Django how to use model DecimalField with additional character values?
I have an input box that must accept the following parameters: Empty Value ('') ZERO (0) Fail value ('x') I know that I can create a custom "fail" BooleanField that gets set to True if "x" is typed. However, I would like to know if it is possible add these values inside the DecimalField. Maybe, use CharField with Decimal Validation. However, trying to use it with CharField and Decimal Validation failed. So, I am not sure how else I can achieve this. Thanks! -
How to incorporate python logic in Django?
Where should the python logics such as sorting a list, printing a Tree be placed in Django. Also, How can we take input and store it in a list in Django? -
How to create an input form for two related models
I have models Movie and MovieDescription therefore I want to create an input form for these two models. I want the input to take place from one joint form, where there will be fields: title, directed_by, genre, year, rate, synopsis. class Movie(models.Model): title = models.CharField(max_length=50, verbose_name='Title') directed_by = models.CharField(max_length=50, null=True, blank=True, verbose_name='Directed by') genre = models.CharField(max_length=90, null=True, blank=True, verbose_name='Genre') year = models.IntegerField(verbose_name='Year') class MovieDescription(models.Model): movie = models.OneToOneField('Movie', on_delete=models.CASCADE, null=True) synopsis = models.TextField(null=True, blank=True, verbose_name='Synopsis') rate = models.FloatField(null=True, blank=True, verbose_name='Rate') I have a problem with finding the most suitable django2.2 tool for this. -
Django console automatically reloading, when doesn't update anything
After run py manage.py runserver then server start to run and it shows on console, and it's doesn't stop just keep running over and over again, when doesn't code or anything changes please somebody solve this problem -
Why I get 405 Error during HttpResponseRedirect to https page?
Why I get 405 Error during HttpResponseRedirect to https url? def top_up_pay(request): template = 'payments/top_up_pay.html' conf_currency = AppConfig.get_config('subscription_price_currency') if request.method == "POST": amount = Decimal(request.POST.get('amount')) if conf_currency: req_user = request.user invoice = Invoice.objects.create( invoice_type=INVOICE_TYPE.TOP_UP, user=req_user, amount=amount, currency=conf_currency ) params = { "currency": invoice.currency, "amount": int(round(float(invoice.amount) * 100)), 'order_id': invoice.payment_no, } integration = FondyIntegration(params) redirect_to = integration.checkout_url() if request.is_ajax(): response = HttpResponse(json.dumps({'success': True, 'location': redirect_to}), content_type="application/json") print(redirect_to) #https url return HttpResponseRedirect(redirect_to) #405 Error -
Django for loop in template won't loop through the elements it's like one big string
I'm trying to do a simple loop but in Django I can't get it to output properly. It's printing everything like one big string. In python it loops through fine and it is a valid list, created an inputted into the postgres database. This is my function in my views.py def pages(request, id): obj = rtves_programas.objects.get(id=id) context = {'title': obj.title, 'show_date': obj.show_date, 'script' : obj.script, 'script_eng': obj.script_eng, 'description': obj.description, 'description_eng': obj.description_eng, 'show_id':obj.show_id, 'url': obj.url, } return render(request, 'rtves/pages.html', context) this element is a list → 'script_eng': obj.script_eng, and I want to printout the elements of the list. this is my code on the template. {% if script %} {% for sentence in script %} {{ sentence }} {% endfor %} {% else %} <p>Nothing here</p> {% endif %} But it's printing out everything in the list not the elements of the list, it looks like this if I just add this to the template it {{ script }} Similar to the loop but without the space -
How to avoid using `extra` when retrieve data from postgres?
I'm retrieving data from postgres DB with following code: values = ('foo', 'bar', 'group') FooBar.objects.order_by('-id').extra(select={'group': "'stackoverflow'"}).values(*values) The code works fine but I've heard that using extra is not preferable and even django documentations says to “Use this method as a last resort.” So the question is how it's possible to avoid using extra to retrieve data? -
Detect occurence of 504 while processing django view
I have a view which sometimes, takes a long time to process resulting in a timeout. I could handle this heavy processing in the background using background tasks in as celery. This for me however is not optimal because, I need to give feedback to the user, like imediately. Whenever I get timeouts, bad things happen and I end up with a model objects in an inconsistent state, missing some vital variables. I could easily remedy this by using atomic transactions but I dont know how to see a 504 event from the view. If it helps, I running django behind nginx Any help is appreciated. -
Which view functions can handle requests to this URL pattern?
Let's say I have the following URL pattern in my urlconf. urlpatters = patterns('blog.views', ... (r'^users/(?P<user_id>\d+)/(?P<country>\w+)', 'user_profile'), ... ) Which of the following view functions are correctly defined to handle requests to this URL pattern? 1. def user_profile (request, user_id, country=None): user_id = user_id country = country 2. def user_profile (request, user_id, **kwargs): user_id = user_id country = kwargs.get('country') 3. def user_profile (request, *args, **kwargs): user_id = kwargs.get('user_id') country = kwargs.get('country') 4. def user_profile (request): user_id = request.GET.get('user_id') country = request.GET.get('country') My best guess here was 1, 2 & 3, because 4 doesn't have enough argument parameters to be able to pass in the user id and country arguments. Why am I wrong? Which of the 4 can really handle requests to the url pattern above? -
Is there a way to make year constant in date_from and date_to in Django DateField and count the number of days from those two fields
In Django model i have two fields called date_from , date_to and number of days. The date_from and date_to are supposed to only have date and month so i need to set year with a default value which is don't know how to do.The number_of_days must be the number of days calculation from date_from and date_to. I need help on this issue. I'm new to django so i don't know how to do this date_from = models.DateField() date_to = models.DateField() no_of_days = models.CharField(max_length=50) so lets say the date_from needs to take in 22-2 and date_to as 22-3 without year from calender and the no_of_days must show as 30 counting the number of days from date_from and date_to. -
Django + uWSGI + Nginx instantly results in upstream prematurely closed connection
Firstly I have read probably every stackoverflow post related to this topic this Easter weekend. E.g. upstream prematurely closed connection (uwsgi + nginx + django) does not solve my problem because it was poor code which didnt even run via manage.py runserver. Most of the posts are about timeouts. This error is thrown immediately on a file that is less than 30KB. All my timeouts on Nginx and uWSGI are set at the default of 60s. It is not a timeout issue, but maybe a cache issue. I write some info from the database into a .xlsx file using openpyxl. When I return the file, it is about 27KB and it has about a 50% chance of not throwing the error. If it is quite a bit larger it fails every time, if it is quite a bit smaller it's okay every time. All other webpages work fine for the site. This is the error message: 2019/04/21 20:14:52 [error] 19712#19712: *46 upstream prematurely closed connection while reading response header from upstream, client: ipaddress, server: request: "GET / HTTP/1.1", upstream: "uwsgi://unix:////var/run/uwsgi.sock:", host: "www.mysite.com" The file can be downloaded successfully via manage.py runserver. It also runs successfully when I start uWSGI directly. ... -
Django DRF: How to join tables and call a function?
I have a basic CRUD app made using Django Rest Framework where the app takes in a Delivery number from the user and lets them enter any issue with the Delivery for which the DeliveryIssue model is used in a simple modal form. I want to add a way where once the Delivery number has been entered on the form, it can lookup the Customer Name and Delivery Date present in the DeliveryInfo model and show it on the form itself before submission. And then that information is saved alongwith the DeliveryIssue model. class DeliveryIssue(models.Model): class Meta: db_table = 'APP_Delivery_Issue' delivery = models.PositiveIntegerField(db_column = 'Delivery') issue_category = models.CharField(max_length=200, db_column = 'Issue Category') issue = models.CharField(max_length=200, db_column = 'Issue') detail = models.TextField(db_column = 'Detail') created_at = models.DateTimeField(auto_now_add=True, db_column = 'Create Datetime') updated_at = models.DateTimeField(auto_now=True, db_column = 'Update Datetime') class DeliveryInfo(models.Model): detail = models.CharField(db_column='Delivery', max_length=50, blank=True, null=False, primary_key=True) customer = models.CharField(db_column='Customer', max_length=250, blank=True, null=True) delivery_date = models.DateField(db_column='Delivery Date', blank=True, null=True) class Meta: managed = False db_table = 'INFO_DELIVERY' I have read about pre_save, but unsure how to use this in here. Here is the serializers.py file from rest_framework import serializers from .models import DeliveryIssue class DeliveryIssueSerializer(serializers.HyperlinkedModelSerializer): class Meta: model = DeliveryIssue fields ... -
Have detail view for transaction, transaction has a one to many relationship with sale. I want to display all sales with transaction in detail view
Im trying to display many side of a relationship in a detail view in django. A transaction can have many sales. my view below: class TransactionDetailView(DetailView): model = Transaction URL Below: path('transaction//', TransactionDetailView.as_view(), name='transaction-detail'), HTML below: <h1> Transaction</h1> <br/> <div class = "row"> <div class = "col-md-12"> <h4>Purchased Coins</h4> <table class="table"> <thead> <tr> <th scope="col">Coin</th> <th scope="col">Amount</th> <th scope="col">per Coin</th> <th scope="col">Total</th> <th scope="col">Value Per Coin</th> <th scope="col">Total Value</th> <th scope="col">Date Added</th> <th scope="col">Profit/Loss</th> <th scope="col">%Profit/Loss</th> </tr> </thead> <tbody> <tr> <td>{{object.currency}}</td> <td>{{object.amount}}</td> <td>{{object.amount_per_coin}}</td> <td>{{object.total_price}}</td> <td><p>Get From API</p></td> <td><p>{{object.amount}} * Get From API</p></td> <td>{{object.date_purchased|date:"F d, Y"}}</td> <td><p>TBC</p></td> <td><p>TBC</p></td> </tr> </tbody> </table> trying to create list of sales associated with transaction {% for sale in object.sales %} <p>kkk</p> {% endfor %} -
How to fix `sudo systemctl status gunicorn.socket` returns `Failed to dump process ..` while setting up gunicorn
I'm trying to set up the Ubuntu 18.04 server on DigitalOcean to serve the django web application by following official tutorial Using gunicorn like this: gunicorn --bind 0.0.0.0:8000 myproject.wsgi server is running just fine. But i got next problem while creating systemd socket and service files for Gunicorn. Home directory /home/sammy contains working directory named pjshop /home/sammy/pjshop: hand_made_ishop(django project directory) pjshop_env(virtual env directory) /home/sammy/pjshop/hand_made_ishop: wsgi.py ... /etc/systemd/system/gunicorn.socket file contains: [Unit] Description=gunicorn socket [Socket] ListenStream=/run/gunicorn.sock [Install] WantedBy=sockets.target /etc/systemd/system/gunicorn.service file: [Unit] Description=gunicorn daemon Requires=gunicorn.socket After=network.target [Service] User=sammy Group=www-data WorkingDirectory=/home/sammy/pjshop ExecStart=/home/sammy/pjshop_env/bin/gunicorn \ --access-logfile - \ --workers 3 \ --bind unix:/run/gunicorn.sock \ hand_made_ishop.wsgi:application [Install] WantedBy=multi-user.target EnvironmentFile=/home/utility so when i run sudo systemctl start gunicorn.socket and then sudo systemctl enable gunicorn.socket, if i'm not mistaken, it should create some symbol link and return output to the terminal, but i got nothing.. then checking the status of the process returns next content: Failed to dump process list, ignoring: No such file or directory ● gunicorn.socket - gunicorn socket Loaded: loaded (/etc/systemd/system/gunicorn.socket; enabled; vendor preset: enabled) Active: active (listening) since Sat 2019-04-20 18:27:51 UTC; 1 day 19h ago Listen: /run/gunicorn.sock (Stream) CGroup: /system.slice/gunicorn.socket Apr 22 12:48:56 pjshop systemd[1]: gunicorn.socket: Socket unit configuration has changed while unit has ... -
How can I display the number of items per category in Django?
i have many categories listed in my homepage and want to add just next to the category title the number of items Here is my view code ! def index(request): offres = OffresEmplois.objects.filter(available=True).order_by('-created_at')[:4] catoffres = OffresCategorie.objects.all().order_by('catname')[:10] num = OffresCategorie.objects.count(offres) return render(request, 'index.html', { 'annonces':annonces, 'firstzone':firstzone, 'secondzone':secondzone, 'offres':offres, 'catoffres':catoffres, 'num':num }) -
How To Separate Objects In Django Admin?
I have an app called 'Product' with the following models.py: class Product(models.Model): product_id = models.CharField(max_length=50) pub_date = models.DateTimeField(default=datetime.now) title = models.CharField(max_length=255) price = models.DecimalField(max_digits=8, decimal_places=2) user = models.ForeignKey(User, on_delete=models.CASCADE) featured = models.BooleanField(default=False) I want to have two separate sections in Django Admin: Products and Featured Products, depending if featured = True or False. So by default all products are listed under the Products section. But if featured = True they will be moved to Featured Products section. Can you please help me how to do that? Thanks in advance. -
Need Help Troubleshooting python requests - POST works, PUT fails - "Authentication credentials were not provided."
Trying to troubleshoot python requests to see if something is wrong when sending an authorization header via a put request, but not sure how to proceed. Any help regarding what I can do next to troubleshoot this would be appreciated. I have a Django-Rest-Framework API operating, and a second Django app that is attempting to talk to the API is having trouble. The API seems to be working fine, but I'm getting a strange "Authentication credentials were not provided" error when I send a PUT request from the second app using python requests. Below is a snippet of my script that generates a POST request when creating a new record, and a PUT request when updating an existing record. The POST request works, the PUT request doesn't - returns the auth error. The side function that generates the authorization header is the same and I've manually confirmed the Authorization header and key is correct. The endpoint url is correct. The data is identical. The endpoint url hits generic model views on DRF (ListCreate for the POST and RetrieveUpdate for the PUT). They both require the same auth level. if update and headers and payload: print "put request to %s with ... -
No module named base while running python manage.py --settings=[mysettings]
While running command from terminal inside virtualenv I get the error ImportError: No module named base I'm running python 2.7 and Django 1.9.0 Hierarchy todobackend settings base.py test.py manage.py test.py from base import * import os # Database # https://docs.djangoproject.com/en/1.8/ref/settings/#databases DATABASES = { 'default': { 'ENGINE': 'django.db.backends.mysql', 'NAME': os.environ.get('MYSQL_DATABASE', 'todobackend'), 'USER': os.environ.get('MYSQL_USER', 'todo'), 'PASSWORD': os.environ.get('MYSQL_PASSWORD', 'password'), 'HOST': os.environ.get('MYSQL_HOST', 'localhost'), 'PORT': os.environ.get('MYSQL_PORT', '3306') } } base.py """ Django settings for todobackend project. Generated by 'django-admin startproject' using Django 1.11.20. For more information on this file, see https://docs.djangoproject.com/en/1.11/topics/settings/ For the full list of settings and their values, see https://docs.djangoproject.com/en/1.11/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/1.11/howto/deployment/checklist/ # SECURITY WARNING: keep the secret key used in production secret! SECRET_KEY = '(0v^617bonn76kaj!sj-q9o08l2wka7x-17kk)-_uc^x410aok' # SECURITY WARNING: don't run with debug turned on in production! DEBUG = True ALLOWED_HOSTS = [] # Application definition INSTALLED_APPS = [ 'django.contrib.admin', 'django.contrib.auth', 'django.contrib.contenttypes', 'django.contrib.sessions', 'django.contrib.messages', 'django.contrib.staticfiles', 'rest_framework', 'corsheaders', 'todos' ] MIDDLEWARE = [ 'django.middleware.security.SecurityMiddleware', 'corsheaders.middleware.CorsMiddleware', 'django.contrib.sessions.middleware.SessionMiddleware', 'django.middleware.common.CommonMiddleware', 'django.middleware.csrf.CsrfViewMiddleware', 'django.contrib.auth.middleware.AuthenticationMiddleware', 'django.contrib.messages.middleware.MessageMiddleware', 'django.middleware.clickjacking.XFrameOptionsMiddleware', ] ROOT_URLCONF = 'todobackend.urls' TEMPLATES = [ { 'BACKEND': 'django.template.backends.django.DjangoTemplates', 'DIRS': [], 'APP_DIRS': True, 'OPTIONS': { 'context_processors': [ ...
