Django community: Django Q&A RSS
This page, updated regularly, aggregates Django Q&A from the Django community.
-
Return fileresponse after return (or render) of view
I'm executing the code that creates a file and returns a FileResponse (with the path to the created document) using the multiprocessing.Process object inside a view class, to be more specific, inside the post function that gets the data I need to the creation of the file out of a form. The function runs in the background, so as the code continues the view redirects to another view with just some text (the "your download will start soon" page). Problem is, though the file is actually created, it doesn't get downloades (even though it has the as_attachment parameter set). How can return effectively the FileResponse? -
Unpack a list in Django Template
How do you unpack a list inside a list within a Django template? My views.py runs a query which then takes a bunch of lists and appends them together to get a larger list to pass to a template. I am using get_context_data to do this. When I view {{timedata}} in my template, it is a list within a list. How can I unpack it, so that it is a single list? views.py class recoaterDataListView(LoginRequiredMixin,ListView): model = Data template_name = 'charts.html' login_url = 'login' def get_context_data(self, **kwargs): context = super().get_context_data(**kwargs) query = Data.objects.filter(author_id = self.kwargs ["author"], ProcessIdentifier_data=self.kwargs['pi']) RecoaterList = [] TimeStamps = [] for data in query: RecoaterList.append(data.RecoaterData) TimeStamps.append(data.recoaterTimeStamp) context['recoaterdata'] = RecoaterList context['timedata'] = TimeStamps return context -
django test views that involve invocation of a signal
I have 2 apps, 1 for auth and the other for storing profile related info auth app models.py class User(AbstractUser): # contains the User related info signals.py @receiver(post_save, sender=User) def create_related_profile(sender, instance, created, *args, **kwargs): if instance and created: instance.profile = Profile.objects.create(user=instance) profiles app models.py class Profile(models.Model): user = models.OneToOneField(User) # other info while testing update user method. class TestUserRetrieveUpdateView(APITestCase): def setUp(self): self.test_username = 'testuser' self.test_email = 'test@example.com' self.test_password = 'testpassword' # We want to go ahead and originally create a user. self.test_user = get_user_model().objects.create_user(self.test_username, self.test_email, self.test_password) self.auth_headers = {'HTTP_AUTHORIZATION': f"Bearer {self.test_user.token}"} # URL for creating an account. self.detail_url = reverse('users:detail') # URL for creating an account. self.create_url = reverse('users:signup') # Request factory self.request_factory = RequestFactory() @patch('yapoll.users.signals.create_related_profile') def test_udpate_user_with_preexisting_username(self, mock): data_1 = { 'username': 'testuser2', 'email': 'test_1@example.com', 'password': 'testuser' } response_1 = self.client.post(self.create_url, data_1, format='json') data = {'username': 'testuser2'} # TODO: Complete this test case handling signals response = self.client.put(self.detail_url, data, format='json', **self.auth_headers) self.assertEqual(response.status_code, status.HTTP_400_BAD_REQUEST) self.assertEqual(get_user_model().objects.count(), 2) self.assertTrue('errors' in response.data) self.assertTrue('username' in response.data['errors']) self.assertEqual(len(response.data['errors']['username']), 1) While doing this I am the getting the following error. django.db.models.fields.related_descriptors.RelatedObjectDoesNotExist: User has no profile. However, I have tested the user creation and profile creation subsequently using signals. It's working fine. -
django(1046, 'No database selected')
i'm working on django project but i failed to connect mysql to django,this is what i've done 1.settings.py DATABASES = { 'default': { 'ENGINE': 'django.db.backends.mysql', 'Name':'testdb', 'USER':'root', 'PASSWORD':'qcds1234', 'HOST':'localhost', 'PORT':'3306' } } 2.use pymysql instead mysqldb import pymysql pymysql.install_as_MySQLdb() 3.i've checked mysql is connected and database exits enter image description here 4.but sadly django.db.utils.InternalError: (1046, 'No database selected') I can't figure out why? -
Django .update() on queryset containing a duplicated objects
I need to increment a tickets field in multiple User objects at once. The thing is, the queryset can contain the same user multiple times. When that's the case, I want tickets to be incremented as many times as the user can be found in the queryset. If I use an F() expression, the .update() method only increment the field ONCE, regardless of the number of occurences of the user in the queryset. Here is a code sample: >>> user_list = User.objects.filter(reservations__is_active=True) >>> user_list <QuerySet [<User: USER_1>, <User: USER_1>]> # duplicated object in qs >>> user_list.values_list('tickets') <QuerySet [(1,), (1,)]> >>> user_list.update(tickets=F('tickets')+1) 1 >>> user_list.values_list('tickets') <QuerySet [(2,), (2,)]> # I should read 3 tickets instead Can F() expressions be used in this context? If not, how could I achieve this simply? -
django, python, jquery autocomplete - Select a valid choice. That choice is not one of the available choices
I am trying to save a field "company" which is an autocomplete field. I'm using ajax jquery, but when trying to save the form I get the error: " Select a valid choice. That choice is not one of the available choices." . I can only save it if I input the company id (ie, 1, 2) instead of the name "Jack in the Box". Any idea why this is happening? Models.py class Question(models.Model): question_text = models.CharField(max_length=200, validators=[validate_badwords]) pub_date = models.DateTimeField('date published') company = models.ForeignKey(Company, on_delete=models.CASCADE, null=True, default=None) class Choice(models.Model): question = models.ForeignKey(Question, on_delete=models.CASCADE) choice_text = models.CharField(max_length=200, validators=[validate_badwords]) votes = models.IntegerField(default=0) class Company(models.Model): name = models.CharField(max_length=100) description = models.TextField(default=None, null=True) B2B = "B2B" B2A = "B2A" B2C = "B2C" BUSINESS_CHOICES = ((B2B, "B2B"), (B2A, "B2A"), (B2C, "B2C")) business = models.CharField(max_length=3, choices=BUSINESS_CHOICES, default=B2A) created_at = models.DateTimeField(auto_now_add=True) updated_at = models.DateTimeField(auto_now=True) View.py class QuestionCreate(CreateView): template_name = 'polls/question_form.html' model = Question form_class = QuestionForm success_url = reverse_lazy('polls:index') def get(self, request, *args, **kwargs): self.object = None form_class = self.get_form_class() form = self.get_form(form_class) choice_form = ChoiceInlineFormSet() return self.render_to_response( self.get_context_data(form=form, choice_form=choice_form)) def post(self, request, *args, **kwargs): self.object = None form_class = self.get_form_class() form = self.get_form(form_class) choice_form = ChoiceInlineFormSet(self.request.POST) if (form.is_valid() and choice_form.is_valid()): return self.form_valid(form, choice_form) else: return ... -
Adding and removing fields from a django form dynamically
I have a django form with an inline formset and I'd like to give the user the ability to add/remove the fields 'approach_type' and 'approach_number' This a snippet of the form: <div class="form-group"> <div class="input-group-sm"> <label class="text-muted">Approaches</label> <div class="form-control pl-4 pt-2"> <div class="row form-row"> <input type="hidden" name="approach_set-TOTAL_FORMS" value="1" id="id_approach_set-TOTAL_FORMS" /><input type="hidden" name="approach_set-INITIAL_FORMS" value="0" id="id_approach_set-INITIAL_FORMS" /><input type="hidden" name="approach_set-MIN_NUM_FORMS" value="0" id="id_approach_set-MIN_NUM_FORMS" /><input type="hidden" name="approach_set-MAX_NUM_FORMS" value="1000" id="id_approach_set-MAX_NUM_FORMS" /> <input type="hidden" name="approach_set-0-id" id="id_approach_set-0-id" /> <div class="col pr-5>"><select name="approach_set-0-approach_type" class="form-control" id="id_approach_set-0-approach_type"> <option value="" selected>---------</option> <option value="ILS">ILS</option> <option value="CATII">CAT II</option> <option value="CATIII">CAT III</option> </select></div> <div class="col pr-5>"><input type="number" name="approach_set-0-number" min="0" class="form-control" id="id_approach_set-0-number" /> </div> <div class="input-group-append"> <button class="btn btn-success add-form-row">+</button> </div> <!-- <div class="col pr-5>"><input type="checkbox" name="approach_set-0-DELETE" class="form-control" id="id_approach_set-0-DELETE" /></div> --> </div> and here is the JS from this tutorial: https://medium.com/@taranjeet/adding-forms-dynamically-to-a-django-formset-375f1090c2b0 <script type='text/javascript'> function updateElementIndex(el, prefix, ndx) { var id_regex = new RegExp('(' + prefix + '-\\d+)'); var replacement = prefix + '-' + ndx; if ($(el).attr("for")) $(el).attr("for", $(el).attr("for").replace(id_regex, replacement)); if (el.id) el.id = el.id.replace(id_regex, replacement); if (el.name) el.name = el.name.replace(id_regex, replacement); } function cloneMore(selector, prefix) { var newElement = $(selector).clone(true); var total = $('#id_' + prefix + '-TOTAL_FORMS').val(); newElement.find(':input').each(function() { var name = $(this).attr('name').replace('-' + (total-1) + '-', '-' + total + '-'); var id ... -
Associating Objects and Users in Django using Generic Views
I'm attempting to associate a collection of Objects with a logged in user. Urls.py urlpatterns = [ path('new/collection', views.CollectionCreate.as_view(), name="create"), path('edit/collection/<int:pk>', views.CollectionUpdate.as_view(), name='update'), path('delete/collection/<int:pk>', views.CollectionDelete.as_view(), name='delete'), ] Views.py This page generates a form where a logged in User enters the title of the Collection, and creates it. As it is right now, the Collection does not get associated with any user. I know that this is the point in which I need to attach the created Collection to the logged in User but I have reached a stop point. class CollectionCreate(CreateView): model = Collection template_name = 'upload/collection_form.html' fields = [ 'title' ] Models.py In this class, a Collection is being associated with a default Django User. class Collection(models.Model): user = models.OneToOneField(User, blank=True, null=True, on_delete=models.CASCADE) title = models.CharField(max_length=140) tags = models.CharField(max_length=140) upload_date = models.DateTimeField(auto_now_add=True) def get_absolute_url(self): return reverse('gallery:detail', kwargs={'pk': self.pk}) def __str__(self): return self.title + ' by ' + self.author class Meta: ordering = ['-upload_date'] Given a form.ModelForm, I know I can access the passed data by using form = ModelForm(request.POST) inside a def post(self, ...) function. I don't know how to do that in a CreateView. -
How do I have multiple exclude conditions?
What is the correct way to do the following query: sites = Site.objects.all().exclude(itempage__isnull=True or itempage__pk=1) -
Django: Multiple Databases Using DATABASE_ROUTERS
I am using 2 different databases in my Django project: 1) 'default' is a PostgreSQL 2) 'analysis' is an Azure SQL Database I am also using Django-Tenants to allow a multi-tenancy approach. Now, the second database is supposed to only have special analytical database tables, whereas the core application runs on the first database. settings.py: DATABASES = { 'default': { 'ENGINE': 'tenant_schemas.postgresql_backend', 'NAME': 'xxx', 'USER': 'xxx', 'PASSWORD': 'xxx', 'HOST': 'localhost', 'PORT': '', }, 'analysis': { 'ENGINE': 'sql_server.pyodbc', 'NAME': 'xxx', 'USER': 'xxx', 'PASSWORD': 'xxx', 'HOST': 'xxx', 'PORT': 'xxx', 'OPTIONS': { 'driver': 'ODBC Driver 17 for SQL Server', 'MARS_Connection': 'True', } } } DATABASE_ROUTERS = ( 'apps.power_bi.routers.AnalysisRouter', 'tenant_schemas.routers.TenantSyncRouter', ) Since the analytical functionality is available in a specific Django app, I configured the following router: class AnalysisRouter: def db_for_read(self, model, **hints): if model._meta.app_label == 'analysis': return 'analysis' return None def db_for_write(self, model, **hints): if model._meta.app_label == 'analysis': return 'analysis' return None def allow_migrate(self, db, app_label, model_name=None, **hints): if app_label == 'analysis': return db == 'analysis' return None I would expect that during the migrate schema command, the analysis application will sync with the second database analysis, instead, all applications will create the tables according to their model definitions. What am I missing ... -
Import using Django admin import-export throws error
I am trying to import data through xls or JSON file. Django throws error while trying to import the file using the Django admin import-export functionality. Following are the codes, Models.py from django.db import models from django.utils import timezone class Questions(models.Model): q_no_id = models.AutoField(primary_key=True) category = models.CharField(max_length=100) question = models.TextField() created_at = models.DateTimeField(auto_now_add=True) def print_all(self): res = self.objects.all() for r in res: print(r.Question) I have added 'import_export' in the Installed_Apps section in the settings.py admin.py from import_export.admin import ImportExportModelAdmin from django.contrib import admin from .models import Questions from import_export import resources class QuestionResource(resources.ModelResource): class Meta: model = Questions fields = ('category', 'question') @admin.register(Questions) class QuestionAdmin(ImportExportModelAdmin): pass The images for reference are as follows: Error Input xls file Why am I getting the error? I even tried removing the data from the q_no_id and created_at fields (as they are autofields) but still the error is persistent. -
Docker / Django: pipenv x requirements
I currently setup my Django project in Docker. I used pipenv so far, therefore I don't have a requirements.txt but a pipfile. Anyone knows how I have to adjust my Dockerfile in order to install all dependencies? I followed the official tutorial. But it doesn't say anything about pipenv, if I don't use requirements.txt - it's my case. FROM python:3 ENV PYTHONUNBUFFERED 1 RUN mkdir /code WORKDIR /code ADD requirements.txt /code/ RUN pip install -r requirements.txt ADD . /code/ -
Recombee batch does not send all the data
I am using recombees API for a recommendation and there is a batch method to send all the user data to the API. The code for the following: for i in range(0,len(list_of_ratings)): name = str(list_of_ratings[i].user) series = str(list_of_ratings[i].series) rate = list_of_ratings[i].rating print(name + ' ' + series + ' ' + str(rate)) request = AddRating(name, series, rate ,cascade_create=True) requests.append(request) try: client.send(Batch(requests)) except APIException as e: print(e) except ResponseException as e: print(e) except ApiTimeoutException as e: print(e) except Exception as e: print(e) But the problem is it does not send all the data. There are 946 data objects that I have in a Django model but the first time when i ran this only 20 were sent and during the 2nd time only 6. I dont know whats causing the issue. Any help is appreciated. -
Django - How to add a custom field to a FormView
I have been trying to make a Form for item removal but I don't know how to connect the field to the model, here's what I'm doing: class StudentForm(forms.ModelForm): queryset = Student.objects.filter().values('name') choices = [('', var) for var in queryset] names = forms.ChoiceField(choices=choices) class Meta: model = Student fields = '__all__' I used this class to connect to the Student model and use its fields, however I want to add a field of my own to it, which is names = forms.ChoiceField(choices=choices), but what I want to know is, how would I connect this field that lists all names, for example, to the form to make it so that I could pick an object's name and then I could change/delete it accordingly? class StudentRegister(generic.FormView): template_name = 'students/student_form.html' form_class = StudentForm success_url = '/' def form_valid(self, form): form.save(commit=True) return super().form_valid(form) This is my views.py and as you can see, it automatically sets the values of the form because those are already "tied in" to a model field, but not the choice field I added. How would I correct this? -
coding style, use return as break in python/django methods
From other programming languages I am very much used to do something like that: def doit(bikes): if type(bikes) is not list: return False # do something with bikes list But in most python code I have seen, its much more done like def doit(bikes): if type(bikes) is list: # do something with bikes list So is my way not really "pythonic" ? I don't know if this really sets an example, but what I want to express is, that I always try not to put the code I want to run within a statement but to break the method when something is running wrong. This also might look like def runbikes(bikes): if type(bikes) is not list: return False if len(bikes) < 1: return False if 'tandem' not in bikes: return False return [bike.run() for bike in bikes] does this meet python coding guidelines? -
Redirecting user if condition is not met
I have a page where the user can report a post. If they have already reported that particular post, then they are not allowed to access this page. I am using a DetailView with the post id as the slug so it looks like this: /report/p/3/ Here's what I have so far: class ReportPostView(LoginRequiredMixin, DetailView): login_url = '/login/' template_name = 'core/report-post.html' model = Post slug_field = 'id' def get(self, request, *args, **kwargs): if Report.objects.filter(actor=self.request.user, post={{ slug_id_should_be_here, but I don't know how to get it from the slug }}).exists(): return HttpResponseNotFound("You have already reported this Post") else: return How can I check for this condition and redirect the user? -
django model does not save the uploaded image
I am trying to upload/update images that users upload using django/ajax/jquery. my front-end code seems to be working. But the django model does not upload/save the passed image. here is my profile model: from django.db import models from django.contrib.auth.models import User class Profile(models.Model): user = models.OneToOneField(User, on_delete=models.CASCADE) image = models.ImageField(default='default.jpg', upload_to='profile_pics') def __str__(self): return f'{ self.user.username } Profile' and the forms for updating the user info: from django.db import models from django import forms from django.contrib.auth.models import User from .models import Profile class UserUpdateForm(forms.ModelForm): email = forms.EmailField() class Meta: model = User fields = ['username','email'] class ProfileUpdateForm(forms.ModelForm): class Meta: model = Profile fields = ['image'] and this is my view function for updating the image: @login_required def update_profile_image(request): #print(request.FILES) if request.method == 'POST': p_form = ProfileUpdateForm(request.POST, request.FILES, instance=request.user.profile) print(p_form) if p_form.is_valid(): p_form.save() context = {'None': 'none'} return JsonResponse(context) else: return HttpResponse('None') when I print the p_form, that is what it prints on the command window: <tr><th><label for="id_image">Image:</label></th><td>Currently: <a href="/media/profile_pics/profile_pic.jpg">profile_pics/profile_pic.jpg</a><br> Change: <input type="file" name="image" accept="image/*" id="id_image"></td></tr> I have added enctype="multipart/file-data" to my form so that is not the problem. and this my ajax call which as I said seems to be working fine: $(document).on('submit', '#profile_edit_form', function(event){ event.preventDefault(); //method = $(this).attr('method'); var ... -
Add foreign key related entities in the same Django admin page
I'm working on a Django app wich will manage some quizes. Those quizes are formed by a question and some possible answers, which I've defined as different models. There is an OneToMany relationship between them, which as far as I know, should be modeled with a foreign key, in this case, in the answer entity. However, while managing the data from the Django administration site, this is quite inconvenient, because I've to define first my question, and later, while adding the answers, look for the question in order to fill the foreign key field. Would be somehow possible, to define all the answers while adding the question, in a similar way as if it was a ManyToMany relationship (the box with the + symbol, etc)? -
Django view give ''int' object has no attribute'' when in shell gives object from model
I got this error when I'm trying to obtain data from models in my view.Thing is, I understand clearly what this error is,but I am very confused why it is happening.It is becouse when I run following code in django shell i'm getting what i want. In django shell: In [2]: from ep.models import * In [3]: a = PreventionProgramCenter.objects.all() In [4]: a.values_list('center',flat=True) Out[4]: <QuerySet [1, 2, 3]> In [5]: b=a[0] In [6]: b Out[6]: <PreventionProgramCenter: PreventionProgramCenter object (1)> In [7]: b.center.zip_code Out[7]: '53-334' In [8]: for i in a: ...: print(i) ...: PreventionProgramCenter object (1) PreventionProgramCenter object (2) PreventionProgramCenter object (3) It is all good.I can get list of object from my model,iterate over it and calls methods. But in my view.py zip_codes = [] zip_codes_obj = PreventionProgramCenter.objects.all() zip_codes_obj = zip_codes_obj.values_list('center',flat=True) for zip_code in zip_codes_obj: print(zip_code) zip_codes.append(zip_code.center.zip_code) zip_code is just int,not object of PreventionProgramCenter.How,what I'm missing? -
Celery is connecting to amqp://guest**@localhost instead of Redis. Heroku deploy
I have read simillar topics and done everything there was being suggested, but the problem remains. I am deploying my app to Heroku. Locally everything was working fine, but during deploy after specyfying every setting I could think off to specify the celery worker sends following error: :22:50.722826+00:00 app[worker.1]: [2018-10-21 18:22:50,722: ERROR/MainProcess] consumer: Cannot connect to amqp://guest:**@127.0.0.1:5672//: [Errno 111] Connection refused. I tried switching from CloudAMQP to Redis. And the problem remains. Here are my config files: Django's settings.py: try: CELERY_BROKER_URL = os.environ['REDIS_URL'] except KeyError: CELERY_BROKER_URL = 'amqp://admin:admin@localhost:5672/admin_host' try: CELERY_RESULT_BACKEND = os.environ['REDIS_URL'] except KeyError: CELERY_RESULT_BACKEND = 'amqp://admin:admin@localhost:5672/admin_host' CELERY_ACCEPT_CONTENT = ['json'] CELERY_TASK_SERIALIZER = 'json' CELERY_RESULT_SERIALIZER = 'json' django_heroku.settings(locals()) celery.py from __future__ import absolute_import, unicode_literals import os from celery import Celery from . import settings # set the default Django settings module for the 'celery' program. os.environ.setdefault('DJANGO_SETTINGS_MODULE', 'file_upload.settings') app = Celery('file_upload', broker_pool_limit=1) app.config_from_object('django.conf:settings') app.autodiscover_tasks(lambda: settings.INSTALLED_APPS) @app.task(bind=True) def debug_task(self): print('Request: {0!r}'.format(self.request)) init.py from the package containig celery.py and settings.py: from __future__ import absolute_import, unicode_literals # This will make sure the app is always imported when # Django starts so that shared_task will use this app. from .celery import app as celery_app __all__ = ['celery_app'] and the os.environ['REDIS_URL'] does return a url, I checked ... -
django boolean in form always returns true
learning django, and trying to make a todo list. A task is created first with only a task.name. Then I go to a taskdetail.html, with a form for task.detail, task.duedate, and task.done. The latter is a boolean that is true if the task is completed. I have the following in my template: <input type="hidden" name="done" value=0 /> <input type="checkbox" name="done" value=1 {% if task.done %} checked {% endif %}> In my views.py, I have: def taskdetail(request, task_id): task = Task.objects.get(pk=task_id) if request.method == 'POST': form = DetailTaskForm(request.POST) if form.is_valid(): task.name = form.cleaned_data["name"] task.description = form.cleaned_data["description"] task.done = form.cleaned_data["done"] task.duedate = form.cleaned_data["duedate"] task.save() ... Strange enough, task.done alsways ends up true. It's default is false, and I have verified that it is indeed false before task.done = form.cleaned_data["done"] I read that somewhere that value=0 is the same as false, but that doesn't seem to work for me. I also tried <input type="hidden" name="done" value="" /> but then my form.is_valid returns false. What could be the problem here? (I am working with Django 2.1 and python 3.7) -
Is it possible to turn cached pages off after a user logs out?
I know how to cache pages and all that. I currently do it from url patterns like cache_page(60*720)(views.post_list). But my current problem is turning cached pages off after a user logs out. Example of problem: Assume every template inherits from base.html, and that template has the following: {% if user.is_authenticated %} <h1>Hi, {{ request.user }}!</h1> {% endif %} Now assume that EVERY page is cached, except a logout/ page. Also assume that the user went straight to the login page without viewing any other page. So after logging in, a user goes to blog/, home/, contact/, and a special_login_page_viewable_only_by_login/, and so on, so they get the special Hi, user_name message visible on every page. Then the user goes to logout/ page, and they successfully logout. Now when the users goes to any page they just visited, even though logged out, they still see the Hi, user_name message on every page they visited, because of the cached pages. Caching makes the server far faster, but doesn't look right if the person logged out, and decided to browse the site some more. My current solution: Make pages that require a login to inherit from a different template that has the above if ... -
Adding slug id in query
I have a DetailView which contains a get function. This get function checks if a certain condition holds true, if it does then throw an error. However, I'm having difficulty getting the slug id inside query where post= How can I add the slug id here? class ReportPostView(LoginRequiredMixin, DetailView): login_url = '/login/' template_name = 'core/report-post.html' model = Post slug_field = 'id' def get(self, request, *args, **kwargs): if Report.objects.filter(actor=self.request.user, post={{ slug_id_should_be_here }}).exists(): return HttpResponseNotFound("You have already reported this Post") else: return -
Adding data from two models into one table in Django?
I'm trying to add data from two models into one table. They are linked via a Foreign Key. I have searched the forum but cannot find a method that works with my data. At the moment, I can display a single models data in the table but not the other. Im using MySQL as my database. My models.py file: class location(models.Model): loc_room = models.CharField(max_length=20, blank=True, null=True) loc_block = models.IntegerField(blank=True, null=True) loc_shelf = models.CharField(max_length=4, blank=True, null=True) class box(models.Model): box_contents = models.CharField(max_length=300, blank=True, null=True) project_assigned_to = models.ForeignKey('project', null=True) location_id = models.ForeignKey('location', null=True) My views.py file: def all_assets(request): box_data = box.objects.all() return render(request, 'main_app/all_assets.html', { "box_data":box_data }) My table: <thead> <tr> <th>Assets</th> <th>Project</th> <th>Room</th> <th>Block</th> <th>Shelf</th> </tr> </thead> <tbody> {% for item in box_data %} <tr> <td>{{ item.box_contents }}</td> <td>{{ item.project_assigned_to }}</td> <td>**Here I need to add data from ROOM**</td> <td>**Here I need to add data from BLOCK**</td> <td>**Here I need to add data from SHELF**</td> </tr> {% endfor %} I hope somebody can help me with this. I've been trying out all the solutions on the forum but non work with my data. The closest I got was Django query to join records of two tables But again, I couldn't get it ... -
Django - Can't get models.ForeignKey to self reference
I've been trying to show a list of people in a class that's pickable in a form, so I chose to have a foreignkey reference itself so the names would be the choices, that left me with this piece of code: class Student(models.Model): """Model representing the student. It has their name and classroom for now.""" name = models.TextField(max_length="200",help_text="Digite o nome do aluno.") class_number = models.ForeignKey(Classroom, on_delete=models.CASCADE, null=True) name_for_delete = models.ForeignKey('self', on_delete=models.CASCADE) def get_absolute_url(self): return reverse("student-detail", args=[str(self.id)]) def __str__(self): return self.name Where the relevant bit is name_for_delete = models.ForeignKey('self', on_delete=models.CASCADE), since I want to delete a person's name from the database. But whenever I try to execute the code I get this error: no such column: classroom_student.name_for_delete_id I tried to add an id but there's name conflicts. I don't even know if my solution to the problem is the correct one, is this the way I would delete a name using this view, and if it is, how do I fix this problem?
