Django community: Django Q&A RSS
This page, updated regularly, aggregates Django Q&A from the Django community.
-
How does Django add these attributes: ( tag, choice_label and id_for_label ) in RadioSelect's radio
In the documentation, I saw codes like this: {% for radio in myform.beatles %} <label for="{{ radio.id_for_label }}"> {{ radio.choice_label }} <span class="radio">{{ radio.tag }}</span> </label> {% endfor %} picture But I can't find related definition for these attributes in the source code. Thanks for your help : ) -
django-pyodbc-azure 2.1.0.0 not supporting Django 2.1.0
We are trying to connect Django-2.1 with MS SQL Server 2012. We were looking for modules to use for this and stumbled across django-pyodbc-azure. We pip installed it and while restarting the app, we got this following error message: Unhandled exception in thread started by <function check_errors.<locals>.wrapper at 0x0000006140CB2BF8> Traceback (most recent call last): File "C:\Program Files\Python36\lib\site-packages\django\utils\autoreload.py", line 225, in wrapper fn(*args, **kwargs) File "C:\Program Files\Python36\lib\site-packages\django\core\management\comma nds\runserver.py", line 109, in inner_run autoreload.raise_last_exception() File "C:\Program Files\Python36\lib\site-packages\django\utils\autoreload.py", line 248, in raise_last_exception raise _exception[1] File "C:\Program Files\Python36\lib\site-packages\django\core\management\__ini t__.py", line 337, in execute autoreload.check_errors(django.setup)() File "C:\Program Files\Python36\lib\site-packages\django\utils\autoreload.py", line 225, in wrapper fn(*args, **kwargs) File "C:\Program Files\Python36\lib\site-packages\django\__init__.py", line 24 , in setup apps.populate(settings.INSTALLED_APPS) File "C:\Program Files\Python36\lib\site-packages\django\apps\registry.py", li ne 112, in populate app_config.import_models() File "C:\Program Files\Python36\lib\site-packages\django\apps\config.py", line 198, in import_models self.models_module = import_module(models_module_name) File "C:\Program Files\Python36\lib\importlib\__init__.py", line 126, in impor t_module return _bootstrap._gcd_import(name[level:], package, level) File "<frozen importlib._bootstrap>", line 994, in _gcd_import File "<frozen importlib._bootstrap>", line 971, in _find_and_load File "<frozen importlib._bootstrap>", line 955, in _find_and_load_unlocked File "<frozen importlib._bootstrap>", line 665, in _load_unlocked File "<frozen importlib._bootstrap_external>", line 678, in exec_module File "<frozen importlib._bootstrap>", line 219, in _call_with_frames_removed File "C:\Program Files\Python36\lib\site-packages\django\contrib\auth\models.p y", line 2, in <module> from django.contrib.auth.base_user import AbstractBaseUser, BaseUserManager File "C:\Program Files\Python36\lib\site-packages\django\contrib\auth\base_use r.py", line 47, ... -
Django: "argument of type 'int' is not iterable" in oracle/base.py in _rowfactory
I'm trying to connect my Django app to Oracle DB but making a query results in exception: TypeError: argument of type 'int' is not iterable Exception Location: /opt/isep/venv/lib/python3.4/site-packages/django/db/backends/oracle/base.py in _rowfactory, line 560 def _rowfactory(row, cursor): # Cast numeric values as the appropriate Python type based upon the # cursor description, and convert strings to unicode. casted = [] for value, desc in zip(row, cursor.description): if value is not None and desc[1] is Database.NUMBER: precision = desc[4] or 0 scale = desc[5] or 0 if scale == -127: if precision == 0: # NUMBER column: decimal-precision floating point # This will normally be an integer from a sequence, # but it could be a decimal value. if '.' in value: value = decimal.Decimal(value) else: value = int(value) else: # FLOAT column: binary-precision floating point. # This comes from FloatField columns. value = float(value) elif precision > 0: # NUMBER(p,s) column: decimal-precision fixed point. # This comes from IntField and DecimalField columns. if scale == 0: value = int(value) else: value = decimal.Decimal(value) elif '.' in value: # No type information. This normally comes from a # mathematical expression in the SELECT list. Guess int # or Decimal based on whether it ... -
How to truncate yyyy-mm-dd to mm-dd in xAxis of Django Chartit chart?
I want to remove the YYYY from the x-axis date YYYY-MM-DD, because the chart is showed in a small area. For example, 2018-09-04 should be 09-04. I'm not sure whether any existing method can be used for this, Could somebody help? I'm using Django version 2.0, django-chartit 0.2.9, and Python 3.7.0. def get_block_chart(self): blockpivotdata = DataPool( series=[{ 'options': { 'source': Block.objects .annotate(date=TruncDay('timestamp')) # Truncate to day and add to select list .values('date') # Group By day .annotate(num=Count('hash')) # Select the count of the grouping .values('date', 'num') # select day and num .order_by('date') }, 'terms': [ 'date', 'num' ] }] ) return Chart( datasource=blockpivotdata, series_options=[{ 'options': { 'type': 'line', 'stacking': False }, 'terms': { 'date': [ 'num', ] } }], chart_options={ 'title': { 'text': 'Block Count Chart'}, 'xAxis': { 'title': { 'text': 'Date'}}, 'yAxis': { 'title': { 'text': 'Block'}}, 'legend': { 'enabled': False}, 'credits': { 'enabled': False}}, ) -
Django Rest framework, how to include '__all__' fields and a related field using foreignkey_id field
So here is my files - Models.py class Model1(models.Model): user = models.ForeignKey(User) other_fields = models.CharField(max_length=40) Serializers.py class MySerializer(ModelSerializer): class Meta: model = Model1 fields = '__all__' Here json request {"user_id":1, "other_fields":"details"} and in views.py serializer = MySerializer(data=request.data) serializer.data **Throws keyerror "user"** When i try to change request parameter "user_id" to "user" it works for me . But I cant change request json. Is there any way to handle this issue in serializer? I can set all the fields inplace of '_all_' but it is not a good solution due to large number of fields . I also tried with - class MySerializer(ModelSerializer): user = serializers.CharField(source='user_id') class Meta: model = Model1 fields = '__all__' but it was not worked for me. -
"CSRF Failed: CSRF cookie not set after" Django upgrade
I've made a Django upgrade from 1.7.5 to 1.11.15. I'm also using Django Rest Framework verion 3.3.2. After this all PUT/POST (probably DELETE too) requests are denied with 403 Status code and message : {"detail":"CSRF Failed: CSRF cookie not set."} The middleware classes I employ in settings.py are : MIDDLEWARE_CLASSES = ( 'django.middleware.common.CommonMiddleware', 'django.contrib.sessions.middleware.SessionMiddleware', #'django.middleware.csrf.CsrfViewMiddleware', 'django.contrib.auth.middleware.AuthenticationMiddleware', 'django.contrib.messages.middleware.MessageMiddleware' ) I noticed that if I enable the 'django.middleware.csrf.CsrfViewMiddleware' middleware class then everything works fine. However since I do not know clearly why this is class is currently disabled I would like to leave it as it is and look for another workaround. What would be the options in this scenario? -
How to automatically reload a Django app using django-livesync when a SCSS file changes?
I'm using https://github.com/fabiogibson/django-livesync to automatically refresh the Django page when some file changes. It works fine for any HTML or CSS file changed, however I'm now using https://github.com/jrief/django-sass-processor to compile SASS. Unfortunately, django-livesync doesn't work when a SCSS file is modified. Is there any way to make them work together? -
insert new field and value in nested json list with using recursion in Python Django rest framework
please any one tell me how to update/insert field and value in nested json list based on condition. like first my nested json list is like objlist= [{ "label": "1", "children": [{ "label": "2", "children": [{ "label": "3" }]}]}{"label": "4","children": [{ "label": "5"},{ "label": "6"}]}{"label":"7"},{"label":"8"}] after implement recursion and logic my output will like below\ objlist= [{ "label": "1", "children": [{ "label": "2", "children": [{ "label": "3" }]}], "checked":"true"}{"label": "4","children": [{ "label": "5", "checked":"true"},{ "label": "6"}]}{"label":"7"},{"label":"8", "checked":"true"}] and achieve this the code would be written below def get(self, request, format=None): queryset = models.Master_Industry.objects.filter(parent__isnull=True) serializer1 = masterserializer.IndustrySerializer(queryset, many=True) json_string = json.dumps(serializer1.data) stringobj = 2,5 my_dict = json.loads(json_string) for item in my_dict: if item["value"] in stringobj: item["checked"] = True continue for itemchild in item["children"]: if itemchild["value"] in stringobj: itemchild["checked"] = True continue for itemchildinner in itemchild["children"]: if itemchildinner["value"] in stringobj: itemchildinner["checked"] = True continue print(my_dict) return Response(serializer1.data) so please tell me how to resolve this? thanks -
Django TypeError: render() takes 2 positional arguments but 3 were given ?
i am sending an email to my drivers from my employee site but i am not able to send a driver id with the url link . and now it comes with the error render | join_message = template.render(ctx, request) TypeError: render() takes 2 positional arguments but 3 were given def rentacar_carapp_approve(request): if request.POST: try: args['driver'] = driver = Driver.objects.get(id=request.POST.get('driver_id')) subject = "Please Register Your Car" from_email = settings.EMAIL_HOST_USER to_email = 'bakrshk@gmail.com' if to_email is not None: template = Template("""Please hit the link and book a car {{ request.get_host }}{% url 'detail' driver_id=driver_id %}""") ctx = Context({'driver_id': driver.id}) join_message = template.render(ctx, request) send_mail(subject=subject, from_email=from_email, recipient_list=[to_email], message=join_message, fail_silently=False) print("email sent") except Driver.DoesNotExist: print("Driver doesn't exists") return HttpResponseRedirect('/mega-admin/rentacar/carapp-manager/') please tell me the solution i am newbie to django . -
django REST framework, validate json data
The server comes with json format: { "type": "string", "object": { "lead_id": int, "form_name": "string", "answers": [ { "key": "string", } ... ] }, "group_id": int, "secret": "string" } How to use django rest framework to validate this json? ru version -
Channels2 working on AWS Elastic Beanstalk
It works on my localhost. But when I deploy on AWS ElasticBeanstalk, I get this error: Traceback (most recent call last): File "/opt/python/run/venv/local/lib/python3.6/site-packages/django/core/handlers/exception.py", line 35, in inner response = get_response(request) File "/opt/python/run/venv/local/lib/python3.6/site-packages/django/core/handlers/base.py", line 113, in _get_response resolver_match = resolver.resolve(request.path_info) File "/opt/python/run/venv/local/lib/python3.6/site-packages/django/urls/resolvers.py", line 523, in resolve raise Resolver404({'tried': tried, 'path': new_path}) django.urls.exceptions.Resolver404: {'tried': [[<URLPattern '^$' [name='home']>], [<URLPattern '^comunidade/'>]], 'path': 'socket/comunidade/'} During handling of the above exception, another exception occurred: Traceback (most recent call last): File "/opt/python/run/venv/local/lib/python3.6/site-packages/django/core/handlers/exception.py", line 99, in get_exception_response response = callback(request, **dict(param_dict, exception=exception)) TypeError: handler404() got an unexpected keyword argument 'exception' My routing.py: application = ProtocolTypeRouter({ "websocket": OriginValidator( AuthMiddlewareStack( URLRouter([ # URLRouter just takes standard Django path() or url() entries. path("socket/", MyConsumer), url("socket/(?P<slug>[\w-]+)", MyConsumer), ]), ), [".mydomain.com.br", "localhost"] ), }) My JS connection: var ws_scheme = window.location.protocol == "https:" ? "wss" : "ws"; var connection = new WebSocket( ws_scheme + "://" + window.location.host + "/socket" + window.location.pathname ); In AWS config, WSGIPath is pointing to wsgi.py. It seems to be routing channels 2 to urls.py -
How to use CreateView with numeric fields and primary key
I am trying to create and object using CreateView, so I give django template name, model and fields. In my fields I have description, number of hours and primary key (hidden, as it is not obligatory to have it). I want to edit all the fields (including number of hours) but first of all, I cannot include field to enter hours in form, and secondly, I have the error ]Cannot insert the value NULL into column 'id'. But it should insert it automaticaly or at least let me edit it. -
Get Specific Length of String in jinja template
I have a CharField in model that can contains String of any length upto 1000... details = models.CharField(max_length=1000) How can I get the String of specific length(say 10) in my template? {{ details|10 }} -
dockerization of a project in python
I'm migrating a project to python on docker for a better "facility" for development. it's a project that runs with python 2.7, Django 1.6.8 and several RPC dependencies I find myself with a crash of the application with this stacktrace that I can't find the missing module (No module named coros). I'm thinking it should either be an addiction problem related to a version that is not good or an addiction installed on the default bone but not on the docker bone. Do you have any ideas or suggestions to correct this problem? app_1 | Traceback (most recent call last): app_1 | File "/usr/local/lib/python2.7/wsgiref/handlers.py", line 85, in run app_1 | self.result = application(self.environ, self.start_response) app_1 | File "/usr/local/lib/python2.7/site-packages/django/contrib/staticfiles/handlers.py", line 67, in __call__ app_1 | return self.application(environ, start_response) app_1 | File "/usr/local/lib/python2.7/site-packages/django/core/handlers/wsgi.py", line 187, in __call__ app_1 | self.load_middleware() app_1 | File "/usr/local/lib/python2.7/site-packages/django/core/handlers/base.py", line 45, in load_middleware app_1 | mw_class = import_by_path(middleware_path) app_1 | File "/usr/local/lib/python2.7/site-packages/django/utils/module_loading.py", line 26, in import_by_path app_1 | sys.exc_info()[2]) app_1 | File "/usr/local/lib/python2.7/site-packages/django/utils/module_loading.py", line 21, in import_by_path app_1 | module = import_module(module_path) app_1 | File "/usr/local/lib/python2.7/site-packages/django/utils/importlib.py", line 40, in import_module app_1 | __import__(name) app_1 | File "/var/www/ofsdashboards/common/middleware/login_required.py", line 7, in <module> app_1 | compile(reverse('ofsdashboards.account.views.login').lstrip('/')), app_1 | File ... -
How to hide the xAxis and yAxis title of Django Chartit chart?
I want to hide the x/y axis title in a small chart. I tried removing xAxis and yAxis fields from chart_options, but result is same. Could somebody help? return Chart( datasource=blockpivotdata, series_options=[{ 'options': { 'type': 'line', 'stacking': False }, 'terms': { 'date': [ 'num', ] } }], chart_options={ 'title': { 'text': 'Block Count Chart'}, 'xAxis': { 'title': { 'text': 'Date'}}, <<<< this one 'yAxis': { 'title': { 'text': 'Blocks'}}, <<<< and this one 'legend': { 'enabled': False}, 'credits': { 'enabled': False}}, ) BTW, I'm using Django version 2.0, django-chartit 0.2.9, and Python 3.7.0. -
How to upload list of files contained in a folder?
I am a python developer (python 3.6 in my pc), and as part of a project django (v==2.1) I want to upload list of files already in my folder and then empty it. I did several research on stackoverflow and on the Net most of the talk about the functions of the files in folders like walk, etc. What I want is to upload the files contained in a given folder in order to keep a reference of these in database. Thank you in advance. -
How add a html template as loading screen in AngularJS untill http response is recieved?
My project architecture is in this way .. I have a django-rest-api (api) in a django project and normal django app with TemplateView's , In django app templates I use both django template tags and angularJs tags and I differentiate them using {% verbaitm %} tag. I want to know the best way to show loading page . -
how to pass the dynamic variable in raw sql query using django mysql
How to archive the following... i need to pass two variable date which comes as long format and apply this variable in a subquery using raw sql django def duplicatephoneno(request): cursor = connection.cursor() payload = json.loads(request.body.decode('utf-8')) print(payload) if payload: startdate=payload['from'] enddate=payload['to'] with connection.cursor() as cursor: cursor.execute(MYSQLdb.escape_string("SELECT * FROM `allergy` WHERE `allergy`.`patient_n_key` IN (SELECT `patient_masters`.`patient_n_key` FROM `patient_masters` WHERE `patient_masters`.`created_on`between %s AND %s)",[startdate], [enddate])) row = dictfetchall(cursor) patientuser=serializers.serialize('json', row) return HttpResponse(patientuser, content_type='application/json;charset=utf8') -
TypeError: the first argument must be callable when I import a scheduler in my views.py file of django?
I am using Django 1.11. I want to use the scheduler in my application to run my script once in a day. This is my view.py file from __future__ import print_function from django.shortcuts import render from django.utils import timezone from django.http import HttpResponse from datetime import datetime, timedelta import requests import schedule import time def republic(request): return HttpResponse("<h1>Success Hindustan</h1>") def indiatv(request): return HttpResponse("<h1>Success Hindustan</h1>") def ndtv(request): return HttpResponse("<h1>Success NDTV</h1>") schedule.every().day.at("17:19").do(republic(requests)) schedule.every().day.at("17:19").do(indiatv(requests)) schedule.every().day.at("17:19").do(ndtv(requests)) while 1: schedule.run_pending() time.sleep(1) When I run the server I am getting following error File "/home/imsaiful/PiroProject/pironews/feed/urls.py", line 2, in <module> from . import views File "/home/imsaiful/PiroProject/pironews/feed/views.py", line 230, in <module> schedule.every().day.at("17:19").do(republic(requests)) File "/home/imsaiful/anaconda3/lib/python3.6/site-packages/schedule/__init__.py", line 385, in do self.job_func = functools.partial(job_func, *args, **kwargs) TypeError: the first argument must be callable But when I remove the scheduler lines then the application running properly. So, kindly help me to overcome this error? -
django-filter: How to concatenate columns
How to concatenate User.first_name and last_name in the same field when using django-filter? I'd like to have a single form field for querying something like John Smith. -
Using django prefetch_related()
Given the following: return Client.objects.filter(case=self.kwargs['case_pk'] ).prefetch_related('parent_set', 'children_set') This works correctly, although I think my filter is creating far too many queries. However, my problem is that there may be more than one Client. This results in: clienta parent1 clienta child1 clientb parent1 parent2 clientb child1 child2 I need to group the parents and children to the client, so I can produce something like this in a template: clienta parent: parent1 children: child1 clientb parents: parent1 parent2 children: child1 child2 Hope that makes sense. -
Django Rest Framework Get Additional related fields in one to many relation
Here's the problem Products have multiple sizes which is many to many relation Products |-------|---------| | ID | Title | |-------|---------| Sizes |-------|---------| | ID | Title | |-------|---------| Size Through |------|--------------|-----------|---------| | ID | Product ID | Size ID | Stock | |------|--------------|-----------|---------| I manage to get sizes in my product api using Django Rest Framework but i don't know how to get stock information as well. here is the code I've class SizeSerializer(serializers.ModelSerializer): class Meta: fields = ( 'id', 'title', ) model = Size class ProductsSerializer(serializers.ModelSerializer): sizes = SizeSerializer(many=True) class Meta: fields = ( 'url', 'id', 'title', "sizes", ) model = Products I would appreciate any help in this problem -
how i can fill my data on just one bootstrap table django 2.1
my picture i have problem with using table. i want to show one table my data but , it doesnt work, my program showing all my data different table but i dont want this. how i repair this situation ? my html codes thank u for your interest... <div class="container"> <div class="row"> <div class="col-3"> <a class="btn btn-warning" href="{% url 'ANASAYFA'%}"> ANASAYFA </a> <br> {% now "jS F Y H:i" %} </div> <div class="col-6"> {% for i in veriler %} <table class="table table-bordered table-dark"> <thead> <tr> <th scope="col">TARİH</th> <th scope="col">İSİM-SOYİSİM</th> <th scope="col">VARDİYA BÖLGE</th> <th scope="col">VARDİYA DÖNEM</th> </tr> </thead> <tbody> <tr> <th scope="i.row">{{ i.gun }}</th> <th>{{ i.personel }}</th> <th>{{ i.bolge }}</th> <td>{{ i.vardiya_donemi }}</td> </tr> </tbody> </table> {% endfor %} -
I cannot save image to mysql database on django with ImageField. (django version: 2.1)
When I am saving data with ImageField on django on sqlite db it's saving without any problem but when I am trying to save image on mySql database I am getting error like "expected str, bytes or os.PathLike object, not tuple". It's my code: Settings.py DATABASES = { 'default': { 'ENGINE': 'django.db.backends.mysql', 'NAME': 'dbname', 'USER': 'user', 'PASSWORD': 'password', 'HOST': 'localhost', } } ... MEDIA_URL = '/static/media/' MEDIA_ROOT = os.path.join(BASE_DIR, "static/media") models.py from django.db import models from subjects.models import Subjects class Course(models.Model): subject = models.OneToOneField(Subjects, on_delete=models.CASCADE) name = models.CharField(max_length=255) img = models.ImageField(upload_to="images", blank=True) def __str__(self): return self.name_en And I have also registered my model on admin.py to have permission. and I have also installed pillow to use ImageField. It's an error: Request Method: POST Request URL: http://127.0.0.1:8000/admin/course/course/add/ Django Version: 2.1 Python Version: 3.6.5 Installed Applications: ['django.contrib.admin', 'django.contrib.auth', 'django.contrib.contenttypes', 'django.contrib.sessions', 'django.contrib.messages', 'django.contrib.staticfiles', 'subjects', 'visit', 'course'] Installed Middleware: ['django.middleware.security.SecurityMiddleware', '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'] Traceback: File "/home/user/.virtualenvs/learneng/lib/python3.6/site-packages/django/core/handlers/exception.py" in inner 34. response = get_response(request) File "/home/user/.virtualenvs/learneng/lib/python3.6/site-packages/django/core/handlers/base.py" in _get_response 126. response = self.process_exception_by_middleware(e, request) File "/home/user/.virtualenvs/learneng/lib/python3.6/site-packages/django/core/handlers/base.py" in _get_response 124. response = wrapped_callback(request, *callback_args, **callback_kwargs) File "/home/user/.virtualenvs/learneng/lib/python3.6/site-packages/django/contrib/admin/options.py" in wrapper 607. return self.admin_site.admin_view(view)(*args, **kwargs) File "/home/user/.virtualenvs/learneng/lib/python3.6/site-packages/django/utils/decorators.py" in _wrapped_view 142. response = view_func(request, *args, **kwargs) File "/home/user/.virtualenvs/learneng/lib/python3.6/site-packages/django/views/decorators/cache.py" ... -
Is it possible to run locally even after deploying into AWS eb?
I'm a beginner and I've been working on Django project. Is it possible to run locally even after deploying into AWS? If so, what is the preferable way to do that? Also, is it possible to have multiple db so I can use both for development and production?
