Django community: Django Q&A RSS
This page, updated regularly, aggregates Django Q&A from the Django community.
-
Django - Unable to retrieve data in database in dropdownlist
Hi, I really need help in this, tried for many days and still cannot do it. I am very new to django. I am unable to retrieve the data in mySQL database to display it in a dropdownlist. Can someone help me please? appreciate it! models.py class paper(models.Model): id = models.CharField(max_length=70, primary_key=True, null=False) year = models.TextField(null=True) month = models.TextField(null=True) number = models.IntegerField(null=True) def __str__(self): return str(self.id) Views.py def dropdown_list(request): paperS = paper.objects.all() pname = request.GET.get(['paper_id']) if request.method == 'GET': z = ["Nov 2017 - GCE O'Level Elementary Mathematics Paper 1", "Nov 2017 - GCE O'Level Elementary Mathematics Paper 2", "Nov 2016 - GCE O'Level Elementary Mathematics Paper 1", "Nov 2016 - GCE O'Level Elementary Mathematics Paper 2", "Nov 2015 - GCE O'Level Elementary Mathematics Paper 1", "Nov 2015 - GCE O'Level Elementary Mathematics Paper 2", "Nov 2014 - GCE O'Level Elementary Mathematics Paper 1", "Nov 2014 - GCE O'Level Elementary Mathematics Paper 2", "Nov 2013 - GCE O'Level Elementary Mathematics Paper 1", "Nov 2013 - GCE O'Level Elementary Mathematics Paper 2", "Nov 2012 - GCE O'Level Elementary Mathematics Paper 1", "Nov 2012 - GCE O'Level Elementary Mathematics Paper 2", "Nov 2011 - GCE O'Level Elementary Mathematics Paper 1", "Nov 2011 ... -
Django - PageNotFound after login
Django 2.1 does not obey my configuration in settings. After logging in, I get the error: Page not found (404) Request Method: GET Request URL: http://localhost:8000/accounts/login/index.html settings.py: LOGIN_REDIRECT_URL = 'dashboard/index' Login URL: http://localhost:8000/accounts/login/ myproject/urls.py path('admin/', admin.site.urls), path('', TemplateView.as_view(template_name='index/index.html'), name='index'), path('accounts/', include('django.contrib.auth.urls')), path('dashboard/', include('dashboard.urls')), dashboard/urls.py urlpatterns = [ path('index/', views.dashboard_index, name='dashboard_index'), ] dashboard/views.py @login_required def dashboard_index(request): return render(request, 'dashboard/index.html', {}) Any idea? -
django - Update model form when files are uploaded
I am building a website with lots of Work objects. Works are grouped into Collections, and each of those class has its own database model (so, each Work has a foreign key referring to its Collection). I typically add a Collection of several Work objects all at once. The models look something like this: class Collection(models.Model): name = models.CharField(max_length=100, default=None) description = models.TextField(null=True, blank=True, default=None) class Work(models.Model): collection = models.ForeignKey(Collection, on_delete=models.CASCADE) name = models.CharField(max_length=100, default=None) description = models.TextField(null=True, blank=True, default=None) imagepath = models.ImageField(upload_to=get_work_filename, default=None) To simplify adding these to the website, I want to add both of them in one form. So, I'm trying to use a custom ModelAdmin and Model Form: class WorkInline(admin.StackedInline): model = Work class CollectionForm(forms.ModelForm): name = forms.CharField() description = forms.Textarea() pictures = forms.FileField(widget=forms.ClearableFileInput(attrs={'multiple': True})) class Meta: model = Collection fields = '__all__' class CollectionAdmin(admin.ModelAdmin): form = CollectionForm fieldsets = ( (None, { 'fields': ('name', 'abbrev', 'description', 'pictures',), }), ) inlines = [WorkInline] The idea is that I fill in the name and description of the Collection, and then upload a bunch of images as Works in that collection. Most of the fields in Work can be autofilled based on just the filename of the uploaded ... -
Combine and manipulate querysets based on if object in one is not in another
For some reason I cannot figure out the best way to do this. I can merge them, get the difference, etc - but can't figure out how to merge both query sets based on values, and then assign a different value after they're merged. I have two QuerySets: query_set_a = Reports.objects.filter( agent=report.profile.agent_code, product='product_a', date__range=(report_range_start, report_range_end), prem_submitted__gt=0).order_by('date') query_set_b = Reports.objects.filter( agent=report.profile.agent_code, product='product_b', date__range=(report_range_start, report_range_end), prem_submitted__gt=0).order_by('date') If you consider the following: {% for each in query_set_a %} [{{ each.date|date:"m-d" }} - {{ each.activated }}], {% endfor %} {% for each in query_set_b %} [{{ each.date|date:"m-d" }} - {{ each.activated }}], {% endfor %} Which outputs correctly: query_set_1 output [08-01 - 2], [08-02 - 2], [08-03 - 1], [08-06 - 1], [08-07 - 1], [08-10 - 13], [08-13 - 2] query_set_2 output [08-01 - 21], [08-02 - 23], [08-03 - 18], [08-06 - 17], [08-07 - 5], [08-09 - 2], [08-10 - 30], [08-13 - 13], [08-15 - 4], How would I take values that are in query_set_2 output and add them to query_set_1, but set query_set_1.activated to null? Such that query_set_1 would look like: [08-01 - 2], [08-02 - 2], [08-03 - 1], [08-06 - 1], [08-07 - 1], [08-09 - null], ... -
Django - Multiple databases and single Auth
I have a customer that is a supermarket. They have a lot of stores across the country and what I'm trying to achieve with Django is to use: 1) django-hosts to have different domains for each store; 2) Django routers to have different databases for each store; I have read this tutorial: https://strongarm.io/blog/multiple-databases-in-django/ And also I'm reading Django docs: https://docs.djangoproject.com/en/2.1/topics/db/multi-db/ The link above shows how to use multi dbs and creates an Auth Database, which is exactly what I need, but following the example, they create "replica" databases, which is not my case. That's because each store has their own data and I don't want "replicas". Assuming that all of my users can access (read and write) all of stores data and not only one, my questions is, am I doing it right? Or should I do something else to achieve this architecture? PS: It sounds like an "open question" but its not, I want to know the best way to achieve my scenario combining everything together :) -
Django 2 Create Model Programmatically
I'm looking to auto-register app and create a Django model within the app programmatically, upon using manage.py startapp newapp --template=quicktemplate. My thought process is as below, but I only got up to auto-register app. But then, the whole process feels too hacky, and I very much welcome any Django-approved way. I looked up for migrations.CreateModel API, but it's too complex for my novice understanding. In my project-wide settings.py, I scan for folders which are not non-app folders i.e. project-level folder called quick. Here, I auto-register any new folders as app into INSTALLED_APPS INSTALLED_APPS = [ ... # django contribs ] NON_APP_FOLDERS = ['quick', 'quicktemplate', 'media'] APP_LIST = [ app for app in next(os.walk('.'))[1] if app not in NON_APP_FOLDERS ] INSTALLED_APPS = INSTALLED_APPS + APP_LIST In my quicktemplate, I have created initial model, and also update apps.py for the model initialization. # quicktemplate/models.py # declare model that will be initialized once upon app creation from django.db import models class AppProfile (models.Model): name = models.CharField(max_length=100) ... # quicktemplate/__init__.py # to allow AppConfig ready() to be called default_app_config = '{{ app_name }}'.apps.'{{ camel_case_app_name }}' ... #quicktemplate/apps.py from django.apps import AppConfig class {{ camel_case_app_name }}Config(AppConfig): name = {{ app_name }} def ready(self): # NOT ... -
Saving paragraphs using Factory Boy / Faker
factory.Faker("paragraphs", nb=3, ext_word_list=None) returns factory.faker.Faker object and when used on a text field, it's saving the actual list instead of joined as paragraphs! I am getting this in DB: ['Course step statement human special relationship step. Shake boy expert. Support argue officer school.', 'Work stay visit range any still. Both job blue over since.', 'Truth food tree risk. Forward attention grow stand listen also few. Sea process else commercial minute.'] Any idea how to save it as a string? -
One ListView blocks the otherone
I'm working on a app, and the app has two different ListViews, one of them for posts the other is for news. Here are the Views: class NewsListView(ListView): context_object_name = 'news' model = models.News template_name = 'posts/news_list.html' def get_queryset(self): return News.objects.all() class PostsListView(ListView): context_object_name = 'posts' model = models.Posts template_name = 'posts/posts_list.html' def get_queryset(self): return Posts.objects.all() Here is the apps urls.py: urlpatterns=[ url(r'^$',views.NewsListView.as_view(),name='news'), url(r'^$',views.PostsListView.as_view(),name='posts'),] And here is the projects urls.py: urlpatterns = [ url(r'^$',views.IndexView.as_view(),name='index'), path('admin/', admin.site.urls), url(r'^posts/',include('posts.urls',namespace='posts')),] My problem i that for some reason only one List works, always the one which is is the first one in the apps urls.py. How can i solve this problem? Thanks for your help!!! -
Django ForeignKey in same table about same attribute in different table
I have one model in my project. class users(models.Model): match_user = models.ForeignKey(User,on_delete=models.CASCADE) matched_user = models.CharField(max_length=25) Imagine that: match_user is 'Mete' and matched_user is 'Gizem'. Also match_user is 'Gizem' and matched_user is 'Mete' I have 2 table line: id match_user matched_user __ __________ ____________ 1 mete gizem 2 gizem mete Now if ı want delete mete, only first row deleted. But I want to delete 2 rows.Actually I want to two foreign key about same location in different table. How I can? is it possible. İf it is not a possible, is there any solution for my want. Also I tried some different ways like that: match_user = models.ForeignKey(User,related_name="username"on_delete=models.CASCADE)` matched_user = models.ForeignKey(User,related_name="username"on_delete=models.CASCADE)` But there is error all time Thanks for answers :) -
Django: setting initial in get_context_data doesn't work as expected
I am trying to set initial within a class based view, to pre-populate a text input with name=description The following code seems to accept an integer input in the url as specified, and puts this where I want it in the template. #urls.py urlpatterns += ( path('repair/', views.RepairListView.as_view(), name='app_name_repair_list'), path('repair/create/<int:pk>', views.RepairCreateView.as_view(), name='app_name_repair_create'), ) # views.py class RepairCreateView(CreateView): model = Repair form_class = RepairForm def get_context_data(self, **kwargs): context = super(RepairCreateView , self).get_context_data(**kwargs) self.initial['description'] = self.kwargs['pk'] return context However when accessing in the browser... access: /repair/create/1 text input contains: 1 access: /repair/create/2 text input contains: 1 (again) access: /repair/create/3 text input contains: 2 (and so forth) Have I done something blatantly wrong here or is this some kind of weird bug? I'm basically plan to have a URL somewhere else on the site, that the user would click to load this form, thus populating the form with already known information which would be in said URL. -
ckeditor_uploader Dynamic Image Upload Path
I have a Django application that requires users to upload multiple images per document. The application has django-ckeditor installed, but the uploaded images end up in the same folder set by the CKEDITOR_UPLOAD_PATH setting. I would like the path to be dynamic, based on the URL scheme. For example, images uploaded to the CKEditor instance on https://myapp/report/1/finding/5 should reside in /ckeditor_base_path/report/1/finding/5/my_img.png. Unfortunately, the URL for the view function that handles setting the path is set by the widget (CKEditorUploadingWidget) before the view creates a context parameter. I was hoping to send the parameters URL parameters to ImageUploadView for processing. Any help or advice on this is greatly appreciated. -
Receive http request
CLIENT: I sent this http request, code: import requests payload = {'data': [{'name': 'pippo', 'age':'7'}, {'name':'luca', 'age':'12'}]} r = requests.post("http://127.0.0.1:8000", data=payload) print(r.url) Server Django. code views.py: from django.shortcuts import render from django.views.decorators.csrf import csrf_exempt @csrf_exempt def home(request): context = {'request_method': request.method} if request.method == 'POST': context['request_payload'] = request.POST.dict() post_data = request.POST print(post_data) for key, value in post_data.items(): for subvalue in value: print{key, subvalue} if request.method == 'GET': context['request_payload'] = request.GET.dict() return render(request, 'main/index.html', context) when i do execute. Django i not receive data of send client. My result in print(post_data)on django are : <QueryDict: {'data': ['name', 'age', 'name', 'age']}> I would like to extract this: {'name': 'pippo', 'age':'7'} {'name':'luca', 'age':'12'} How can I do? -
Redirecting if already logged in
After my users log in, they can still access the login.html page and "log in again". They can also manually access the pages meant to be seen only when registering ("enter your name and telephone number" sort of pages). I'd rather they not be able to access these after they're logged in. There is no @login_forbidden decorator. So how can I redirect if a user is already logged in? -
Wagtail 2.2.2, django 2.1.1 compatibility issues
Wagtail github site says that wagtail is compatible with django 2.1.x. I am trying to setup a project with pipenv. When I install wagtail via pipenv it installs django version 2.0.8 If I try to update django to 2.1.1 console gives: Your dependencies could not be resolved. You likely have a mismatch in your sub-dependencies. Could not find a version that matches django<2.1,==2.1.1,>=1.11 Besides the error it installs django 2.1.1. But then when I runserver... I get error: AttributeError: module 'django.contrib.auth.views' has no attribute 'login' So is wagtail 2.2.2 compatible with django 2.1.x ? -
How can I dynamically change the storage of Django FileField()?
Basically I got the following model where some uploaded documents will be public and some others private. To decide when the doc is private or not, when creating the instance, I set the field is_public=True/False, then I will be able to choose the right direction within the AWS S3 bucket. So I want to be able to change the storage to PrivateMediaStorage() when is_public=False from my_project.storage_backends import PrivateMediaStorage class Document(models.Model): file = models.FileField(upload_to="uploaded_documents/%d-%m-%Y") # file = models.FileField(upload_to="uploaded_documents/%d-%m-%Y", # storage=PrivateMediaStorage()) uploaded_by = models.ForeignKey(UserProfile,blank=True,null=True) nb_download = models.IntegerField(default=0) is_public = models.BooleanField(default=False) Here is the storage class in case it's important. from storages.backends.s3boto3 import S3Boto3Storage from django.conf import settings class PrivateMediaStorage(S3Boto3Storage): location = settings.AWS_PRIVATE_MEDIA_LOCATION default_acl = 'private' file_overwrite = False custom_domain = False -
trouble loading a simple hello world on django 2.1
I'm entirely new to Django. Here I'm trying to create my first project following every detailed step mentioned in here. But yet I face this error by entering http://localhost:8000/polls/ : using the urlconf defined in mysite.urls, django tried these url patterns, in this order: 1. admin/ I was wondering if any of you guys ever encountered the same or have something to say about it. Thanks. -
Highlighted post in Django templates
I've created this model: class PostModel(models.Model): post_title = models.CharField(max_length=70) post_short_description = models.TextField(max_length=200) post_contents = models.TextField() post_publishing_date = models.DateTimeField(auto_now=False, auto_now_add=True) post_author = models.ForeignKey(AuthorModel, on_delete=models.CASCADE) post_keyconcept = models.ManyToManyField(KeyConceptModel) slug = models.SlugField(verbose_name="Slug", unique="True") post_highlighted = models.BooleanField(default=False) def __str__(self): return self.post_title def get_absolute_url(self): return reverse("singlepostManuscriptusView", kwargs={"slug": self.slug}) class Meta: verbose_name = "Articolo" verbose_name_plural = "Articoli" I want use post_highlighted for put in a div only the article or the articles that have response true. How I can set up the "for cicle"? Here there is the cicle for show the list of posts: {% for posts in object_list %} <div id="bloghome" class="container"> <h1><a href="{{ posts.get_absolute_url }}">{{ posts.post_title }}</a></h1> <p>{{ posts.post_short_description|safe|linebreaks }}</p> <p>Pubblicato il <strong>{{ posts.post_publishing_date|date }}</strong></p> <h5>Keywords:</h5> {% for keyword in object_list.all %} <button type="button" class="btn btn-outline-warning btn-sm">{{ keyword }}</button> {% endfor %} </div> <hr> {% empty %} <h1>Go to the admin panel and create your first post!</h1> {% endfor %} -
Django - how to create membership models with foreign keys and manytomanyfield
I am trying to create a django membership models with 2 model classes: Target and Group. I want to have targets attributable to certain groups, but also to be able to query which targets are in which group. This is what I have so far and I am able to see that "targets" is a field of Group but it shows up as empty in the query set when I access Group.objects.get(pk=1) through a variable. I also want both groups and targets to be attributable to certain users. Here are my models, what am I doing wrong? I've tried doing this a few different ways so far: class Target(models.Model): first_name = models.CharField(max_length=50, default='Target First name') last_name = models.CharField(max_length=50, default='Target last name') email = models.EmailField(max_length=100, default='email@example.com') user = models.ForeignKey(settings.AUTH_USER_MODEL, on_delete=models.DO_NOTHING) date_time = models.DateTimeField(auto_now=True) group = models.ForeignKey(Group, on_delete=models.DO_NOTHING, null=True, blank=True) def __str__(self): return self.email def __unicode__(self): return self.email class Group(models.Model): group_id = models.IntegerField(primary_key=True) name = models.CharField(max_length=50, default='Group name') created_date = models.DateTimeField(auto_now=True) modified_date = models.DateTimeField(null=True, blank=True) targets = models.ManyToManyField(Target, related_name='targets', blank=True, null=True) user = models.ForeignKey(settings.AUTH_USER_MODEL, on_delete=models.DO_NOTHING) def __str__(self): return self.name def __unicode__(self): return self.name -
Using django-filter with django-tables2, how do I annotate a queryset?
I am using django-filter and django-tables2 to pull data from a SQLite3 database. The database has 15+ fields of sales order information were they may be multiple lines (Line field) per sales order. I would like to render a table that does the equivalent of 'Group By' sales order and sum the ExtAmount field. I know I should use the annotate function but I am unsure where to implement this with django-filter/django-tables2. In SQL I used the below to get what I need: SELECT SalesOrder, Customer, Count(Line) AS Lines, Round(Sum(ExtAmount), 2) AS Amount FROM backlog_backlogData GROUP BY SalesOrder Order By Sum(ExtAmount) DESC limit 100 As of now, the view renders the three fields from tables.py but without grouping SalesOrder. Which is great, but I can't seem to find traction of where I need to annotate. I've read through the docs and searched through other questions and I just can't seem to understand how to use django-filter/django-table2. The only place I have found 'annotate' referenced in the django-filter docs is with the ModelMultipleChoiceFilter filter reference. Any help would be great! #models.py from django.db import models class backlogData(models.Model): Shipto = models.IntegerField() Customer = models.CharField(max_length=200) City = models.CharField(max_length=200, null=True) ST = models.CharField(max_length=200, null=True) ... -
Static files in Django 1.8
My static files are inside the main django folder (BASE_DIR). It works fine, until I turn off the DEBUG. The error occurs because the 'static' function returns empty if the DEBUG is off. What should I do to work around this problem when settings.DEBUG=False? Thanks any help. urls.py urlpatterns = [ url(r'^$', redirect), url(r'^webContextRoot/', include(base)), ] + static(settings.STATIC_URL, document_root=settings.STATIC_ROOT) settings.py # SECURITY WARNING: don't run with debug turned on in production! DEBUG = True STATIC_URL = '/riserweb/static/{version:}/'.format(version=VERSION) STATICFILES_DIRS = ( os.path.join(BASE_DIR, 'resources/static'), ) -
Django choking on special character in model name
I'm using a legacy MSSQL database with my Django application, and one of the column names contains a "%". As a result, Django is looking for a format variable whenever the model is called. I've isolated the issue to know it breaks on this field within my model: fg_field = models.DecimalField(db_column="FG%", max_digits=15... And the error message I get is: sql = sql % tuple('?' * len(params)) TypeError: not enough arguments for format string When I note out this field in the model, the application works fine... so I know it has to do with this naming convention. Can I do anything on the Django side to stop this from happening? -
Where to insert data into a django form before validation?
I have a modelForm created from a Model: class Client(models.Model): name = models.CharField(max_length=30) domain_url = models.CharField(max_length=128, unique=True) schema_name = models.CharField(max_length=63, unique=True, validators=[_check_schema_name]) I am not showing the schema_name for editing, as I want this to be automatically generated somewhere between form submission and validation. class SetupForm(forms.ModelForm): '''Setup form for the new instance domain_url and schema_name are charfield ''' class Meta: model = Client fields = ['name', 'domain_url', ] I want to modify the domain_url and create a schema_name from it. I still want the regular form validations to run though. So where can I add the schema_name to the data for cleaning? -
Prepopulating fields of user edit form (also: passing {{user}} into a javascript function?)
Basically, I'm trying to make an edit profile modal with fields that are already prepopulated by the user's original data. I passed django models into my javascript files by using these brackets {{}} but it doesn't seem to work for {{user}} (as in request.user). This is what I did for simple fields: <div class="field"> <label>Email</label> <input value={{user.email}} type="email" name="email" placeholder="Email"> </div> {{user.email}} successfully is set as the default value for the input. Is there a different way to prepopulate fields? If there is, let me know and I might not have to deal with this next situation. My naive solution works for text fields but if I have a multiselect like: <div class="field"> <label>Native Language</label> <select name="nativelanguage" id="nativedrop" class="ui fluid search selection dropdown"> <option value="">Language</option> <option value="English">English</option> <option value="Spanish">Spanish</option> <option value="French">French</option> </select> </div> my solution no longer works. I want to pass {{ user }} into a javascript function like myFunction({{ user }}) but it seems that this is not possible. Could anyone give me advice on how to prepopulate fields or fix the second issue below? Thanks! -
Kerberos Double Hop Delegation with Django on IIS
I need to pass the credentials (Integrated Windows Authentication) from a django website on IIS onto a backend SQL server so that it runs under the proper user context. This is how my setup looks so far: Running SQL Server on sql_sever.domain.com under a service account domain\svc_sqlserver Running Django website on app_server.domain.com using IIS under a service account domain\svc_appserver with Windows authentication and ASP.Net Impersonation (Providers is set to Negotiate:Kerberos -> Negotiate -> NTLM ) with useAppPoolCredentials=True Connecting to SQL server from django using Windows authentication by setting Trusted_Connection=yes in the connection Configured SPNs for Kerberos authentication both for SQL Server and IIS as follows setspn -a HTTP/app_server domain\svc_appserver setspn -a HTTP/app_server.domain.com domain\svc_appserver setspn -a MSSQLSvc/sql_server.domain.com:PORT domain\svc_sqlserver setspn -a MSSQLSvc/sql_server.domain.com:INSTANCE domain\svc_sqlserver setspn -a MSSQLSvc/sql_server.domain.com domain\svc_sqlserver Trusted both svc_sqlserver and svc_appserver for delegation to MSSQLSvc services and additionally for domain\svc_appserver I added HTTP services too (from the above list) Result: Kerberos authentication works on SQL Server. Confirmed by looking at auth scheme of connected users Kerberos authentication works on Django website. Confirmed by inspecting WWW-Authenticate response header and Authorization request header (Negotiate is being correctly used) Sql server runs only under the context of domain\svc_appserver when it should be running under ... -
SSL manage.py runserve 0:8000
I am running code manage.py runserve 0:8000 but I would like to display it as https. I'm using nginx . I have installed the certificate in the appropriate folders in nginx. I can see the secured nginx default page when I browsed to mywebsite.com (without port 8000) but I get a blank page when I add port 8000 to it. I have tried multiple options below but still unable to get mywebsite:8000 to work on secured ssl page. Any thought? Below are what I have tried so far manage.py runserver_plus 2.manage.py sslserver 3.All sort of Django extensions
