Django community: Django Q&A RSS
This page, updated regularly, aggregates Django Q&A from the Django community.
-
How to add custom action button in Django admin form and post the information
enter image description here I am new to Django! I am using Django Admin. How can I make a new button(near save,...) and post the information and use it in a python script(I am using Django version 2). admin.py admin.site.register(Router) admin.site.register(Peer, PeerModelAdmin) admin.site.register(Prefixe, PrefixModelAdmin) -
No env variables in bash after exported with command in docker-compose
I have a serverless.yml file, that defines environment variables. In order to use the ones for my local stage in a docker container I use the serverless dotenv plugin in order to export them to an .env file. I do this in my docker-compose.yml where I also export the variables from this file. It works as my django settings have access to them. command: > bash -c "sls dotenv -s local && export $$(grep -v '^#' .serverless/.env | xargs -d '\n') && python manage.py makemigrations ingredients" However, if I bash into the container or run a command, the environment variables are not available anymore: docker-compose exec flask-dynamodb-serverless python manage.py createsuperuser What am I missing? -
Executing a script on background while the website browsing is ongoing on Django
I am using Django and would like to background execute a long script at a certain stage while browsing the website pages. For example, for a user calculating the shortest distance and save in the database by comparing with available i.e. 5000 locations. At present, when the script execution starts then the page got frozen and couldn't allow clicking on the links or buttons. I have tried using Django Background Tasks but that needs manually executing through command. Also, looked at Celery with Redis but I found Celery could be huge for this and due to that looking for an easy way. Could you please share your advise to achieve my goal? Thank you! -
How can I build that specific SQL sentence, if I have a simple one-to-many relation
I have two tables. CUSTOMER, ITEMS. CUSTOMER has many fields name, address ..bla. ITEMS contains the bill content. (and CUSTOMER_ID as foreign key naturely).. so wich item and how many pieces saled to customers. How can I buld that SQL query wich get, all customer who bought same products with same amounts of them? If someone can reperesent that, in Django ORM filter, Extra Respect! :) -
How to add social sharing buttons in django blog
am using the django_social_share module and i cant figure out how to pass the sharing url for a particular blog post on social media here is the post_detail.html <article> <div class="embed-responsive embed-responsive-16by9"> <img src="{{post.thumb.url}}" alt="" /> </div> <div class="post-content"> <h2>{{post.title}}</h2> <div> {{post.created}} Author {{post.user}} <hr/> <p>{{post.body}}</p> <hr> <div id="subheader" class="blog"> <div class="subheader-text"> <h1>Did you like this Post ?</h1> <h4>Consider sharing Most readers like to share our Posts </h4> <a href="#" rel="shared-popover" data-popover-content="#shared-btn-Popover" title="Share" data-placement="bottom" class="mtr-btn button-circle button-fab ripple"><i class="fa fa-share-alt"></i></a> <div id="shared-btn-Popover" class="hide"> <ul class="blog-share-buttons"> <li><a href="{% post_to_twitter object.title %}" title="Twitter"><i class="fa fa-twitter"></i></a></li> <li><a href="{% post_to_facebook object.title %}" title="Facebook"><i class="fa fa-facebook"></i></a></li> <li><a href="#" title="Linkedin"><i class="fa fa-linkedin"></i></a></li> </ul> </div> </article> </div> help out please all the setting are okay -
django login via existing login credential
I am working with a django project 'appointment reservation system for student and teacher'. Here teacher can create their free appointment shcedule and student can book that appointment. Pretty simple. However, I'm stuck. I have to made the login system such that they can use their existing login credential from their school management application. So the login system would have modularity. Its should work like login via facebook, instead, it would be login via their existing login access. Looking for gudance. Thanks in advanced. -
PermissionDenied after upgrade to restframework 3.7.0
I have a django 1.11 project running with restframework 3.6.4. After upgrading the restframework to 3.7.0, I'm getting a strange exception while running one of my unit tests: Traceback (most recent call last): File "/Users/alex/.Envs/autodesk/lib/python3.5/site-packages/rest_framework/views.py", line 482, in dispatch self.initial(request, *args, **kwargs) File "/Users/alex/.Envs/autodesk/lib/python3.5/site-packages/rest_framework/views.py", line 400, in initial self.check_permissions(request) File "/Users/alex/.Envs/autodesk/lib/python3.5/site-packages/rest_framework/views.py", line 335, in check_permissions request, message=getattr(permission, 'message', None) File "/Users/alex/.Envs/autodesk/lib/python3.5/site-packages/rest_framework/views.py", line 176, in permission_denied raise exceptions.PermissionDenied(detail=message) rest_framework.exceptions.PermissionDenied: You do not have permission to perform this action. Maybe someone has an idea what the problem is or at least how can I understand where the problem is? -
NOT NULL constraint failed: portal_visitrequests.visitor_id
I am very new to django and I've been battling with this particular project for a while now. I get a not null constraint error every time I try and submit my form(which ultimately creates Visitor and VisitRequests objects). The error comes from this line of code...visit_request = VisitRequests(staff=staff, visitor=visitor, comment=comment, token=token, status=None).save()... Please view the code below. views.py def formpage(request): if request.method=='POST': token=secrets.token_urlsafe(20) visitor_name=request.POST.get('visitorsname') comment=request.POST.get('comment') visit_type=request.POST.get('visit_type') visit_content='You have a waiting visitor'+'\n'+'Name:'+visitor_name+'\n'+'Purpose Of Visit:'+visit_type+'\n'+'Additional Comment:'+comment+'\n'+token staff_id=request.POST.get('staff') staff=Staff.objects.get(id=staff_id) staff_email=staff.staff_email req_comment = request.POST.get('req_comment') request_id = (request.POST.get('request_id')) visitor=Visitor(visitor_name=visitor_name).save() visit_request = VisitRequests(staff=staff, visitor=visitor, comment=comment, token=token, status=None).save() models.py class Staff(models.Model): staff_name = models.CharField(max_length=250) staff_email = models.CharField(max_length=250, default="") def __str__(self): return self.staff_name class Visitor(models.Model): visitor_name = models.CharField(max_length=250) timestamp = models.DateTimeField(default=timezone.now) def __str__(self): return '{}'.format(self.visitor_name) class VisitRequests(models.Model): staff=models.ForeignKey(Staff, on_delete=models.CASCADE) visitor = models.ForeignKey(Visitor, on_delete=models.CASCADE) comment= models.TextField(default='') status= models.NullBooleanField() token=models.CharField(max_length=20) -
Django RawSql Annotate
I'm new to Django so I will have ask some help. I have a table with records representing Transit. When transit arrives to depot, I need to find how many Resources are that time in depot. Resource has start time and end time. What I need to do, is annotate Resources count to Transit using Transit depot arrival time. There is now any relation between models. I think I might need RawSql for this but I'm still little short of knowledge to do this. -
Django template and loop over list of elements
I would like to loop over some objects placed into a list and get statistics on each one. I'm using Django 1.11.16 User can select one or multiple publication(s) and I display some statistics over each publication in the list. I have a view part which looks like this : def get_context_data(self, **kwargs): publication_list = self.request.GET.getlist('publication_list') publication_selected = Publication.objects.filter(id__in=publication_list) download_all_period = Download.objects.values('usage', 'doc__publication__pub_id') \ .filter( doc__publication__id__in=publication_list) \ .filter( Q(creation_date__gte=start_date) & Q(creation_date__lte=end_date))\ .aggregate( nusage=Sum('usage')) request_all_period = Download.objects.values('doc__publication__pub_id')\ .filter( doc__publication__id__in=publication_list)\ .filter( Q(creation_date__gte=start_date) & Q(creation_date__lte=end_date)) all_period_list = zip(publication_selected, download_all_period, request_all_period) context_data['publication_list'] = publication_list context_data['publication_selected'] = publication_selected context_data['download_all_period'] = download_all_period context_data['request_all_period'] = request_all_period context_data['all_period_list'] = all_period_list return context_data Then I have a template, with a table. So I would like to loop over each element in my list in order to create one row per element : {% for publication_selected, download_all_period, request_all_period in all_period_list %} {% if download_all_period.nusage %} <tr> <td>{{ start_date|date:"Y/m/d" }} to {{ end_date|date:"Y/m/d" }}</td> <td>{{ publication_selected }}</td> <td><span class="badge alert-danger">{{ download_all_period.nusage }}</span> / <span class="badge alert-info">{{ request_all_period.count }}</span></td> </tr> {% else %} <tr> <td>{{ start_date|date:"d/m/Y" }} to {{ end_date|date:"d/m/Y" }}</td> <td>{{ publication_selected }}</td> <td>{% trans 'No downloads/No requests' %}</td> </tr> {% endif %} {% endfor %} It displays only the last ... -
button that refresh data
I'm Brazilian then: I'm setting up a parking system for hours, and I was able to do the part of updating a record that is already saved and I configured the automatic checkin at the time of the registration and left the checkout to do with DateTimeNow. What I need is that at the time that all the registrations are listed in the table, that I click on the Checkout button and it redirects to the update of the register by passing the time by datetimenow, so when the page that it redirected is loaded, open with the schedule checkout, in order to make the payment Model.py class MovRotativo(models.Model): checkin = models.DateTimeField(auto_now=True, blank=False, null=False,) checkout = models.DateTimeField(auto_now=True, null=True, blank=True) email = models.EmailField(blank=False) placa = models.CharField(max_length=7, blank=False) modelo = models.CharField(max_length=15, blank=False) valor_hora = models.DecimalField( max_digits=5, decimal_places=2, null=False, blank=False) pago = models.CharField(max_length=15, choices=PAGO_CHOICES) forms.py class MovRotativoForm(forms.ModelForm): class Meta: model = MovRotativo fields = '__all__' widgets = { 'checkin': DateTimeInput(), 'checkout': DateTimeInput(), } views.py @login_required def movrotativos_update(request, id): data = {} mov_rotativo = MovRotativo.objects.get(id=id) form = MovRotativoForm(request.POST or None, instance=mov_rotativo) data['mov_rotativo'] = mov_rotativo data['form'] = form if request.method == 'POST': if form.is_valid(): form.save() return redirect('core_lista_movrotativos') else: return render(request, 'core/update_movrotativos.html', data) table <table class="table ... -
I can not update the profile photo in Django
I'm developing a social network. In this social network there is how to update the profile photo, such as Facebook, for example. But when the user updates their photo, it is not shown in the frontend. user_tags_extras.py: def user_photo(context, user): try: if user.image == None or user.image == "": return static("icon/user.png") else: return "data:image/png;base64, " + user.image except: return static("icon/user.png") Models.py: class User(PermissionsMixin, AbstractBaseUser): name = models.CharField(max_length=200, verbose_name='Name', null=True) email = models.EmailField(max_length=256, unique=True, verbose_name=_('e-mail'), blank=True, null=True) image = models.TextField(verbose_name=u'Profile Photo', default='') HTML: <img alt="author" src="{% user_photo request.user %}" class="avatar avatar_template_base"> -
Django adding record to manytomany field
I have a problem with creating new record and adding it to the manytomanyfield. With code that I have I can add new Service. And it is working fine. Question is how to pass argument Car_id and to add new Service to services. My models.py: class Service(models.Model): mileage_number = models.DecimalField(max_digits=8, decimal_places=0) cash_float = models.DecimalField(max_digits=6, decimal_places=2) note_text = models.CharField(max_length=256, null=True) title_text = models.CharField(max_length=32) created_date = models.DateField(default=timezone.now) def __str__(self): return f"{self.title_text}" class Car(models.Model): user = models.ForeignKey(User, on_delete=models.CASCADE) mark_text = models.CharField(max_length=32, null=False, default='mark') model_text = models.CharField(max_length=32, null=False, default='model') services = models.ManyToManyField(Service) refueling = models.ManyToManyField(Fueling) def __str__(self): return f"{self.mark_text} {self.model_text}" My urls.py: path("", views.index, name='index'), path('register', views.register, name='register'), path('logout/', views.LogoutView.as_view(), name='logout'), path('car/<int:Car_id>/', views.CarView, name="car"), path('car/<int:Car_id>/serv/<int:Service_id>/', views.ServiceView, name="service"), path('car/<int:Car_id>/fuel/<int:Fuel_id>/', views.FuelView, name="fuel"), path('add_car/', views.CarEntry.as_view(), name="add_car"), path('car/<int:Car_id>/add_service', views.ServiceEntry.as_view(C_id='Car_id'), name="add_service"), My html: <div class="mx-auto" style="width: 300px;"> <form method="post" class="form" > {% csrf_token %} {% bootstrap_form form %} {% buttons %} <button type="submit" class="btn btn-primary" style="width: 300px;"> Submit </button> {% endbuttons %} </form> My views.py class ServiceEntry(CreateView): model = Service success_url = "/" template_name = "Site/add_service.html" fields = [ 'mileage_number', 'cash_float', 'note_text', 'title_text', 'created_date', ] enter code here -
django rest framework serializer skip relation table
My models are Purchase, Item, ItemGroup, Store These are the relevant fields of the models: class Store(models.Model): name = models.CharField(max_length=100) class ItemGroup(models.Model): name = models.CharField(max_length=100) store = models.ForeignKey(Store) class Item(models.Model): name = models.CharField(max_length=100) group = models.ForeignKey(ItemGroup) class Purchase(models.Model): item = models.ForeignKey(Item) date = models.DateTimeField() I want to write a serializer for Purchase. For each purchase, I want the following output: {"item": "item_name", "store": "store_name"} (Also there are some additional Purcahse fields, but these are easy to fetch). I've tried to follow the relations using the django double underscore __ style, but this does not work: class PurchaseSerializer(serializers.ModelSerializer): class Meta: model = Purchase fields = ('item', 'item__group__store') -
django error: invalid literal for int() with base 10: b'01/12/1990'
I have created a Profile and Blog model in my django application. here is the models.py file below: from django.db import models # Create your models here. class Profile(models.Model): name = models.CharField(max_length=30) description = models.TextField() number = models.CharField(max_length=10) dob = models.DateField() #error might be occuring here def __str__(self): return '%s %s' % (self.name, self.number) class Blog(models.Model): title = models.CharField(max_length=30) content = models.TextField() blog_document = models.FileField(upload_to='documents/', null=True, blank=True) def __str__(self): return self.title And in my admin panel, for profile model: I want to view two or more columns in the table, something like this: However this line is giving me the error since I do not know how to present more than one column appear in the Profile table: def __str__(self): return '%s %s' % (self.name, self.number) Please help! what would be the correct solution for implementing two or more fields in the Profile table(admin panel). Thanks in advance! -
Python package for listing zip-code and its details (country-wise)
Is there a python package that gives the list of all zip-codes and its city in country-wise. I tried with zipcodes package but it return results only from US,i need all countries codes and its details. -
Django: matching URL patterns to display data results in a 404
I am trying to use the URL pattern match to display data dynamically in my template. The goal is to display data based on organization type of which I have 3: Manufacturers, Suppliers, and Distributors. So, if the URL matches /profiles/man_dash/manufacturers/ display data for all Manufacturers. Below is my code: View def man_org_list(request, member_type=None): member_type_map = { 'manufacturers': 'Manufacturer', 'suppliers': 'Supplier', 'distributors': 'Distributor' } member_type = member_type_map.get(member_type, None) if member_type is None: raise Http404 queryset = Organization.objects.filter(member__member_flag=1, member__member_type=member_type).order_by('id') return render(request, 'profiles/man_dash.html', {'object_list': queryset}) urls.py urlpatterns = [ url(r'^$', views.org_list, name='org_list'), url(r'^(?P<id>\d+)/$', views.org_details, name='org_details'), url(r'^man_dash/<str:member_type>/', views.man_org_list, name='man_org_list') ] Code block I want to display: {% for org in object_list %} <tr> <th scope="row">{{ org.id }}</th> <td>{{ org.org_name }}</td> <td>{{ org.org_type }}</td> {% for member in org.member.all %} <td>{{ member.member_flag }}</td> {% endfor %} {% for c_score in org.c_score.all %} <td>{{ c_score.completeness_score }}%</td> {% endfor %} <td><a href="{% url 'org_details' org.id %}" target="_blank">View</a></td> </tr> {% endfor %} For some reason, I keep getting 'The current path, profiles/man_dash/manufacturers/, didn't match any of these.' error. -
django-mysql connection inside docker-compose giving connection refused
Dockerfile FROM python:3.6 ENV PYTHONUNBUFFERED 1 WORKDIR /usr/src/govtcareer_api COPY ./ /usr/src/govtcareer_api RUN pip install -r requirements.txt CMD ["/bin/bash"] docker-compose.yml version: "3" services: govtcareer_api: container_name: govtcareer build: . command: "bash -c 'python manage.py migrate --no-input && python manage.py runserver 0.0.0.0:8000'" working_dir: /usr/src/govtcareer_api ports: - "8000:8000" volumes: - ./:/usr/src/govtcareer_api links: - db db: image: mysql environment: - MYSQL_ROOT_PASSWORD=Thinkonce - MYSQL_USER=soubhagya - MYSQL_PASSWORD=Thinkonce - MYSQL_DATABASE=freejobalert ports: - "3306:3306" django database connection: DATABASES = { 'default': { 'ENGINE': 'django.db.backends.mysql', 'NAME': 'freejobalert', 'USER': 'soubhagya', 'PASSWORD': 'Thinkonce', 'HOST': 'db', 'PORT': '3306', }, } errors: govtcareer | Traceback (most recent call last): govtcareer | File "/usr/local/lib/python3.6/site-packages/django/db/backends/base/base.py", line 216, in ensure_connection govtcareer | self.connect() govtcareer | File "/usr/local/lib/python3.6/site-packages/django/db/backends/base/base.py", line 194, in connect govtcareer | self.connection = self.get_new_connection(conn_params) govtcareer | File "/usr/local/lib/python3.6/site-packages/django/db/backends/mysql/base.py", line 227, in get_new_connection govtcareer | return Database.connect(**conn_params) govtcareer | File "/usr/local/lib/python3.6/site-packages/MySQLdb/__init__.py", line 85, in Connect govtcareer | return Connection(*args, **kwargs) govtcareer | File "/usr/local/lib/python3.6/site-packages/MySQLdb/connections.py", line 204, in __init__ govtcareer | super(Connection, self).__init__(*args, **kwargs2) govtcareer | _mysql_exceptions.OperationalError: (2003, 'Can\'t connect to MySQL server on \'db\' (111 "Connection refused")') govtcareer | govtcareer | The above exception was the direct cause of the following exception: govtcareer | govtcareer | Traceback (most recent call last): govtcareer | File "manage.py", line ... -
DoesNotExist in Django with docker-compose
I use docker-compose to manage a django app and it's database. My problem is when I add some type off object in the database I have a DoesNotExist error : error message. What I don't understand is that the data IS in the database and i can request it from the django app docker without any problem. I don't have the issue when I run the app in dev mode with python manage.py runserver with a local database. Here is my docker-compose.yml : version: '3' services: dojodb: image: mysql:5 environment: MYSQL_ROOT_PASSWORD: password MYSQL_USER: root MYSQL_DATABASE: dojodb volumes: - dojodbvolume:/var/lib/mysql dojo: build: . environment: - SQLHOST=dojodb - SQLPORT=3306 - SQLUSER=root - SQLPWD=password - DBNAME=dojodb ports: - "8000:8000" depends_on: - dojodb volumes: dojodbvolume: I really don't see where the problem comes from. -
E-Commerce Platform for Research Purpose
I would like to simulate a webshop for an economic experiment. It should be modular and atomic, so that other researchers are not limited to the basic functions, but are allowed to extend the features by modifying the code or by writing plugins. For example, I would like to support ecological price decisions, through co2 pricing, informations about ecological impacts etc. and this should be easy to "play" in treatments or to be changed in the backend, similar to otree / ztree. I think that python / a django-based shop is good for it. But what framework would you recommend for the beginning, Django-shop, saleor, Oscar... Any tips? -
Circles not getting aligned properly on the chart D3 Django
Here is the attempt I have made in order to fulfill my visualization. <!DOCTYPE html> <meta charset="utf-8"> <style> /* set the CSS */ .line { fill: none; stroke: steelblue; stroke-width: 2px; } </style> <body> <!-- load the d3.js library --> <script src="https://d3js.org/d3.v4.min.js"></script> <script> var real = {{values.real0|safe}}, pred = {{values.got0|safe}}; // set the dimensions and margins of the graph var margin = {top: 20, right: 20, bottom: 30, left: 50}, width = 960 - margin.left - margin.right, height = 500 - margin.top - margin.bottom; // parse the date / time var parseTime = d3.timeParse("%d-%b-%y"); // set the ranges var x = d3.scaleLinear() .range([0, width]) .domain([0, Object.keys(real).length]) ; var y = d3.scaleLinear() .range([height, 0]) .domain([0, 1]); // define the line var valueline = d3.line() .x(function(d) { return x(d.date); }) .y(function(d) { return y(d.close); }); // append the svg obgect to the body of the page // appends a 'group' element to 'svg' // moves the 'group' element to the top left margin var svg = d3.select("body").append("svg") .attr("width", width + margin.left + margin.right) .attr("height", height + margin.top + margin.bottom) .append("g") .attr("transform", "translate(" + margin.left + "," + margin.top + ")"); // Add the valueline path. // svg.append("path") // .data([real]) // .attr("class", "line") ... -
Trying to pass form from generic.FormView to generic.DetailView
I'm new in Django and it's just a test for further model. I'm trying to pass a form from generic.FormView to generic.DetailView, and exhibit the datas inserted in the previous HTML (associated with the FormView) to another HTML (associated with the DetailView). I've thought it probably a problem with the link between the view.py and urls.py. The codes are: views.py: class IndexView(generic.FormView): template_name = 'dutos/index.html' form_class = GetDate success_url = 'dutos/detail.html' #def form_valid(self, form): #return HttpResponse(self.success_url) #return super.form_valid(form) class DetailView(generic.DetailView): model = Dutos template_name = 'dutos/detail.html' urls.py: from django.urls import path from .views import views urlpatterns = [ path('', views.IndexView.as_view(), name="index"), path('detail/', views.DetailView.as_view(), name="detail"), ] index.html: <!DOCTYPE html> <html> <head> <title>Template</title> </head> <body> <h1>Teste HTML</h1> <div class="container-fluid" id="wrapper"> <div class="row"> <form action="/detail/" method="post"> {% csrf_token %} {{ form.non_field_errors }} <div> <div class="fieldWrapper"> {{ form.dateDataInicial.errors }} <label for="{{ form.dateDataInicial }} Data Inicial: </label> {{ form.dateDataInicial }} </div> <div class="fieldWrapper"> {{ form.dateDataFinal.errors }} <label for="{{ form.dateDataFinal }} Data Final: </label> {{ form.dateDataFinal }} </div> <input type="submit" value="Pesquisar"> </div> </form> </div> </div> </body> </html> detail.html: <!DOCTYPE html> <html> <head> <title>Template</title> </head> <body> <h1>Template HTML</h1> {{form.cleaned_data['dateDataInicial']}} {{form.cleaned_data['dateDataFinal']}} </body> </html> I've already change the "{{form.cleaned_data['dateDataInicial']}}" to "form.dateDataInicial", or just cleaned everything and put "Test" to ... -
send email with attachment in Django
I'm using EmailMultiAlternatives to send email with html content, I also need to send .docx file as an attachment in the mail. I used message.attach_file('/tmp/file.docx') but I getting error as "No such file or directory is found" even though path is correct. I also tried with EmailMessage using message.content_subtype to include html_content, but still the same error with .docx attachment. I also want to try message.attach('filename', content, 'mimetype')--> here I don't know what exactly to include in the contentspace. How do I solve this? Email Client is Outlook Django Version - 1.11 Python Version - 3.6 -
All of POST request repeat execute in Django
when i send a form by post request to Django, the Django frame aways double execute the request, include insert data to mysql Database，and not has any exception,i run the command 'python manage.py check',the result is "System check identified no issues", i checked my code,but not found any questions! i also can't find any answers in the website, who can help me！Thanks! here is the log info. enter image description here -
Django filter by aggregate preserving details
I have a fairly simple task to filter models using an aggregate value, for example: class A(models.Model): title = models.CharField() address = models.CharField() page_count = models.IntegerField() Now I need to select all A titles that have a sum of page_count equal to for example 2 for the same address. It would be easy if I would not need the title: A.objects.all().values('address').annotate(pages=Sum(page_count)).filter(pages=2) But what if I need for every "row" to select all As which are "included" in this row. Is this possible in one query? prefetch_related maybe?
