Django community: RSS
This page, updated regularly, aggregates Django Q&A from the Django community.
-
How to preload a video in Django
This is an online experiment program in Django. In the playing page I got: Playing.html <video height="50%" autoplay id="video" {{video_muted|safe}}> <source src="{% static path %}" type="video/mp4"> </video> The videos are just 1-5MB, however, some users' Internet speed is so slow. Sometimes it takes them 2 minutes to load/download a video. Any method I can transfer the videos to users browser first and then in the playing.html, it gets the video from "cache in local browser" instead of the server directly. Thanks in advance. -
Checking in def clean to see if image field has been cleared
Within my def clean function, I've built a check to see if a user has an image, but no body, which is an invalid combination. forms.py def clean(self): cleaned_data = super(ServicesForm, self).clean() body = cleaned_data.get('body ') image = cleaned_data.get('image') if body != None and image == None : self.add_error('image', "You must provide an image if you want to save the post.") This works well upon the creation of the post. The error shows up if the user enters text in the body, but doesn't provide an image. However, if a user goes back to a post where both a body and image have been provided and clicks on 'clear' on the image widget, they are able to save the form with no error being thrown. Due to other reasons, I do not want to set image as a required field on this form. (There is other business logic that controls whether or not an image is required or not). How can I check in def clean() to see if the user has cleared the image? Thanks! -
How to disable loggin in pyppeteer
I'm using pyppeteer to take screenshots of images to a make a pdf but pyppeteer auto logs everything I take a screenshot at and because of server limitations and the logs is written to a file the logs are crashing my server. Is there any way to completely disable loggin? I tried this already: 'logLevel': logging.NOTSET, 'env': {'DEBUG': 'puppeteer:*,-not_this'}, I also tried to disable loggin like this: logging.getLogger('pyppeteer').setLevel(logging.NOTSET) And nothing seems to work. -
Puzzling Warning With FileField In Django Admin
I created the below model to associate a file with another object type called Organization. The _path() function sets the path of the file to {MEDIA_ROOT}/orgs/{NAME OF ASSOCIATED ORG}/{FILENAME}. It also replaces any spaces in the path with underscores. So if I upload the file "Draft1.doc" and associate it with the org named "My High School", the full path should be uploads/orgs/My_High_School/Draft1.doc This is in my settings.py file MEDIA_ROOT ='uploads/' class OrgFile(models.Model): def _path(instance, filename): return F"orgs/{instance.org.name.replace(' ', '_')}/{filename}" file = models.FileField(upload_to=_path) org = models.ForeignKey(Organization, on_delete=models.DO_NOTHING) def __str__(self): return self.file.name.split('/')[-1] When I use the Admin to upload and associate a file, the file is created in the correct place on disk and appears to have the correct path and associations in the admin. However when I navigate to the file object in the admin and click on the path labeled currently the "uploads/" portion is not included in the path (which may be OK) but I also get the warning: Org file with ID “9/change/orgs/My_High_School/Draft1.doc” doesn’t exist. Perhaps it was deleted? I have no idea why this happens since everything else looks OK. I assume that the link is supposed to take me to the file. -
Keyboard shortcut for {% %} in VSCode using Django HTML
I am building my first Django app and using the Django templating engine in my html files. I have the html and Django html plugin in VSCode. So far, it autocompletes html elements and colorizes the Django templates. Is there a way to autocomplete {% %} when using the Django HTML language mode in VSCode? -
I want to use my admin part rather then given by django default admin panel how i add my admin in django and also connect with db. its my admin panel
I have two part one of alumni section and another secton is admin section, this is my admin section image. -
Django - urls.py issue
I am developing this platform where a user can log in and take a quiz. The issue is that when I go on "localhost/quiz/quiz/" and then a click on my "choice", for example "data science" it gives me this error: sing the URLconf defined in piattaforma.urls, Django tried these URL patterns, in this order: admin/ [name='homepage'] users/ [name='user_list'] user/<username>/ [name='user_profile'] accounts/ accounts/ quiz/ quiz/ [name='quiz'] quiz/ questions/<choice>/ [name='questions'] quiz/ result/ [name='result'] The current path, quiz/datascience, didn't match any of these. I think the problem is on my urls.py on the questions path but I can't solve it quiz/questions.html {% extends "base.html" %} {% block title%} QUIZ {% endblock %} {% block content%} <form action="./result" method="post"> {% for que in ques %} <div class="row"> <div class="col-md-10"> <h3>{{ forloop.counter }}. {{ que.question }}</h3> </div> </div> <div class="row"> <div class="col-md-1"></div> <div class="col-md-3"> <h4> <input type="radio" name="{{ que.id }}" value="{{ que.optiona }}"> {{ que.optiona }} </h4> </div> <div class="col-md-3"> <h4> <input type="radio" name="{{ que.id }}" value="{{ que.optionb }}"> {{ que.optionb }} </h4> </div> </div> <div class="row"> <div class="col-md-1"></div> <div class="col-md-3"> <h4> <input type="radio" name="{{ que.id }}" value="{{ que.optionc }}"> {{ que.optionc }} </h4> </div> <div class="col-md-3"> <h4> <input class="form_control" type="radio" name="{{ que.id }}" value="{{ … -
django: drowning in login form/view
I am struggling a lot with my login system. At this point, I have watched so many different things about the topic that I got a bit lost. I have tried using the built-in authentication system but I failed to make it work with django-tenant. At this point, my login view "works" but does not do its job. I am unable to figure out what is going on. Ideally I would like to integrate what I have with Django built in User for a safe and secure authentication system. Model.py class Client(TenantMixin): id = models.AutoField(primary_key=True) name = models.CharField(max_length=100, default='') email = models.EmailField(default='') company = models.CharField(max_length=100, default='') password = models.CharField(max_length=100, default='') created_on = models.DateField(auto_now_add=True) class Domain(DomainMixin): pass forms.py class UserLoginForm(forms.Form): email = forms.CharField() password = forms.CharField(widget = forms.PasswordInput) company = forms.CharField() def cleaned_data(self): email = self.cleaned_data.get('email') password = self.cleaned_data.get('password') company = self.cleaned_data.get('company') try: tenant = Client.objects.get(email=email, password=password, company=company) except Client.DoesNotExist: raise forms.ValidationError("User does not exist") if email and password: user = authenticate(username= email, password= password) if not user: raise forms.ValidationError('THIS USER DOES NOT EXIST') if not user.check_password(password): raise forms.ValidationError('incorrect password') if not user.is_active: raise forms.ValidationError('this user is not active') return super(UserLoginForm, self).clean() views.py def login_view(request): form = UserLoginForm(request.POST or None) if … -
Heroku Deployment With MongoDB Error: Connection Refused
pymongo.errors.ServerSelectionTimeoutError: localhost:27017: [Errno 111] Connection refused Hello their, I am having a little bit of trouble trying to deploy my Django site in python. I am getting this error(shown above) when trying to connect with my MongoDB atlas database. I read that I have to whitelist my IP, but when I did it did not work. Here is my views.py file: class Initialize(): def __init__(self, name): self.name = name myclient = pymongo.MongoClient('mongodb+srv://<MY Username>:<My Password>@cluster0-gicez.mongodb.net/test?retryWrites=true&w=majority') global mydb mydb = myclient[f"{self.name}"] global userData userData = mydb["userData"] global authData authData = mydb["auth_user"] global storesCollection storesCollection = mydb["stores"] global mycolPostalCodes mycolPostalCodes = mydb["postalCodes"] When I was running my code before I tried deploying it, the code worked fine. Also, here is my settings.py file: DATABASES = { 'default': { 'ENGINE': 'djongo', 'NAME': 'cluster0', 'HOST' : 'mongodb+srv://<my username>:<my password>@cluster0-gicez.mongodb.net/test?retryWrites=true&w=majority', 'USER': '<my username>', 'PASSWORD': '<my password>', } } Any help would be much appreciated. Thanks. Please message me for more information if needed. -
What is the use of Celery in python?
I am confused in celery.Example i want to load a data file and it takes 10 seconds to load without celery.With celery how will the user be benefited? Will it take same time to load data? -
Refused to display iframe or embed tag in django 3.0 and chrome
I had a django app that used an iframe to display a pdf stored in my local machine, something like this: <embed src="path_to_file.pdf" type="application/pdf"> Everything worked just fine in all supported browsers... Until today. The app suddenly stopped working on Chrome and the console displays the message Refused to display 'path_to_file.pdf' in a frame because it set 'X-Frame-Options' to 'deny'. In other browsers it's still working as usual. I don't know if Chrome just made an update or what changed but it is not working anymore. ¡Any help would be appreciated! -
Django static files are not accesible
I have created a django project and tried to use an HTML template; however, I get an error while accessing files in static folder. Here is my configuration: #BASE_DIR = os.path.dirname(os.path.dirname(os.path.abspath(__file__))) STATIC_URL = '/static/' STATICFILES_DIR = [ os.path.join(BASE_DIR,'static'), ] STATIC_ROOT = os.path.join(BASE_DIR,'assets') I have added static variable at the top of the HTML file as: {% load static %} <!DOCTYPE html> <html lang="en"> <head> <title>Travello</title> <meta charset="utf-8"> <meta http-equiv="X-UA-Compatible" content="IE=edge"> <meta name="description" content="Travello template project"> <meta name="viewport" content="width=device-width, initial-scale=1"> <link rel="stylesheet" type="text/css" href="{% static 'styles/bootstrap4/bootstrap.min.css' %}"> <link href="{% static 'plugins/font-awesome-4.7.0/css/font-awesome.min.css' %}" rel="stylesheet" type="text/css"> <link rel="stylesheet" type="text/css" href="{% static 'plugins/OwlCarousel2-2.2.1/owl.carousel.css' %}"> <link rel="stylesheet" type="text/css" href="{% static 'plugins/OwlCarousel2-2.2.1/owl.theme.default.css' %}"> <link rel="stylesheet" type="text/css" href="{% static 'plugins/OwlCarousel2-2.2.1/animate.css' %}"> <link rel="stylesheet" type="text/css" href="{% static 'styles/main_styles.css' %}"> <link rel="stylesheet" type="text/css" href="{% static 'styles/responsive.css' %}"> .....(cont'd) The following is my folder configuration: -my_project --assets --my_project --static --templates --travello My problem is that: I cannot access images in static folder from browser, that is, when I type http://127.0.0.1:8000/static/images/about_1.jpg, I get an error like Page not found (404) When I type http://127.0.0.1:8000 in order to see the index.html main page, I get the page with lots of errors saying Failed to load resource: the server responded with a status … -
Django Messages framework for default login system (contrib.auth)
I am using Django's default authentication system and I was wondering if there is a way to use Django's messages framework with it to display error messages such as incorrect login details etc. All the posts I have searched through here suggest to override the login system, but is there any easier way to do it? I already have a form which is subclassing the AuthenticationForm to use form_valid method, is there anything I could do there? Any help would be really appreciated. -
Can't find django-html in "Select Language Mode" in VS Code
I'm trying to set django-html as the language for my *.html files so that I can use the snippets for python template literals but I can't find it anywhere. When I look for django html by clicking on "Select Language Mode" in the lower right corner I don't get any result: Here's is a screenshot of the search, Another screenshot However, I've seen in a video that this should be possible: screenshot with the search from the video I'm using VS Code 1.44.1 and Windows 10 -
Update django-dash dashboard with new dataframe data in a Django app
Our Aim We're creating a time series plot in a Django app using dash/plotly. The data being plotted is read from a pandas dataframe which is first pre-processed written to a file, and then sent to the next page via POST request for the interactive dashboard. On updating the dataframe the new plot should be plotted on the dashboard. Problem Even though the data is changed the dashboard doesn't updates. It still shows the plot for the previous dataframe saved in the file. Until or unless the django server is restarted it doesn't updates. dcc.interval() doesn't do the trick, it also requires the server to be restarted even though you can see the dash app reply in the console log plus it removes the zoom in capability for a graph since, it refreshes the plot. The Django version in use is 2.2.9 Here is the django-dash app code: import dash_core_components as dcc import dash_html_components as html from dash.dependencies import Input, Output,State import plotly.graph_objs as go from django_plotly_dash import DjangoDash import pandas as pd import dash_table from datetime import datetime app = DjangoDash('chalao') selected_df=pd.read_pickle(r'static/selected_df.pkl') actual_df=pd.read_pickle(r'static/actual_prediction.pkl') datatable_df=actual_df datatable_df.reset_index(inplace=True) datatable_df['START_DATETIME'] = datatable_df['START_DATETIME'].astype(str) datatable_df['Transaction'] = datatable_df['Transaction'].round(decimals=-3) datatable_df['Prediction'] = datatable_df['Prediction'] + 500 datatable_df['Prediction'] = datatable_df['Prediction'].round(decimals=-3) … -
Show data from API on Django tempalte
I'm trying to show the fetched data on an API to the Django template. Here's what I've tried on home.html <h1>Title: {{data.title}}</h1> Here's my views.py which gets the data from services.py class IndexData(TemplateView): def get(self, request): article_data = services.get_data() return render(request, 'pages/home.html', article_data) Here's the services.py def get_data(title, url, description, body, datePublished): url = 'https://contextualwebsearch-websearch-v1.p.rapidapi.com/api/Search/WebSearchAPI' params = {"autoCorrect": "true", "pageNumber": "1", "pageSize": "10", "q": "police", "safeSearch": "true" } headers = {...} r = requests.get(url, headers=headers, params=params) data = r.json() article_data = {'data': data['value']} return article_data The returned json is { "_type":"all", "didUMean":"", "totalCount":2923, "relatedSearch":[ "coronavirus", "new york", "post", "getty", "times", "china", "council", "shares", "americans", "pandemics", "prime", "19 crisis" ], "value":[ { "title":"COVID-19 And The Failure Of Populism", "url":"https://www.forbes.com/sites/riskmap/2020/04/02/covid-19-and-the-failure-of-populism/", "description":"Populist presidents, reliant on their need to constantly convey positive messaging that bolsters their support, have struggled to take the decisive, forward-looking action that the coronavirus crisis demands.", "body":").\nHow will the pandemic play out in these countries?\nSteering countries through the pandemic and an eventual recovery will then be the responsibility of leaders who will have lost credibility, as well as the veneer of their all is well message. The narrative that allowed people in certain countries to latch on to something they … -
Django Login: I'm entering the correct credentials but can't log in
I have a problem while trying to log in with Django. I'm putting the right username and password but I'm still getting the error in Postman: { "non_field_errors": [ "Incorrect username or password." ] } Here is my serializer: from django.contrib.auth import authenticate from rest_framework import serializers from ..models.model_user import * class LoginSerializer(serializers.Serializer): username = serializers.CharField() password = serializers.CharField() def validate(self, attrs): user = authenticate(username=attrs['username'], password=attrs['password']) if not user: raise serializers.ValidationError('Incorrect username or password.') if not user.is_active: raise serializers.ValidationError('User is disabled.') return {'user': user} My views: from django.conf import settings from django.contrib.auth import login, logout from rest_framework import views, generics, response, permissions, authentication from ..serializers.serializers_user import * from ..serializers.serializers_login import * class LoginView(views.APIView): permission_classes = (permissions.AllowAny,) def post(self, request): serializer = LoginSerializer(data=request.data) serializer.is_valid(raise_exception=True) user = serializer.validated_data['user'] login(request, user) return response.Response(UserDetailsSerializer(user).data) class LogoutView(views.APIView): def post(self, request): logout(request) return response.Response() My urls: from django.contrib import admin from django.urls import include, path from django.conf.urls import url from django.conf import settings from django.conf.urls.static import static from rest_framework import routers from ea.views import * from rest_framework_simplejwt.views import ( TokenObtainPairView, TokenRefreshView, TokenVerifyView, ) router = routers.DefaultRouter() router.register(r'users', UserViewSet) urlpatterns = [ path('', include('eao.urls')), path(r'', include(router.urls)), path('admin/', admin.site.urls), path(r'login/', LoginView.as_view(), name='user-login'), path('api/token/', TokenObtainPairView.as_view(), name='token_obtain_pair'), path('api/token/refresh/', TokenRefreshView.as_view(), name='token_refresh'), … -
DRF Form Rendered in SPA
I'm trying to wrap my head around the workings of DRF and I just cannot understand how to achieve this or even where to start with understanding the flow of things. I'm trying to render an HTML form out of DRF to an SPA or static HTML page with JQuery. I have a page /page/ I have a serializer: `class StudentSerializer(serializers.HyperlinkedModelSerializer): class Meta: model = Student fields = ('firstName', 'lastName')` Now I need to have a form rendered that has the initial data and allows to POST/PUT. I can do this very successfully with an APIView and HTMLrenderer, but I’m trying to see if I can have multiple rendered forms on a single page without a single APIView page. If the general approach is to hand-code the forms on a SPA front-end then that’s great, I just want to know if that’s the required approach. -
Cloud Build env variables not passed to Django app on GAE
I have a Django app running on Google AppEngine Standard environment. I've set up a cloud build trigger from my master branch in Github to run the following steps: steps: - name: 'python:3.7' entrypoint: python3 args: ['-m', 'pip', 'install', '--target', '.', '--requirement', 'requirements.txt'] - name: 'python:3.7' entrypoint: python3 args: ['./manage.py', 'collectstatic', '--noinput'] - name: 'gcr.io/cloud-builders/gcloud' args: ['app', 'deploy', 'app.yaml'] env: - 'SHORT_SHA=$SHORT_SHA' - 'TAG_NAME=$TAG_NAME' I can see under the Execution Details tab on Cloud Build that the variables were actually set. The problem is, SHORT_SHA and TAG_NAME aren't accessible from my Django app (followed instructions at https://cloud.google.com/cloud-build/docs/configuring-builds/substitute-variable-values#using_user-defined_substitutions)! But if I set them in my app.yaml file with hardcoded values under env_variables, then my Django app can access those hardcoded values (and the values set in my build don't overwrite those hardcoded in app.yaml). Why is this? Am I accessing them/setting them incorrectly? Should I be setting them in app.yaml somehow? I even printed the whole os.environ dictionary in one of my views to see if they were just there with different names or something, but they're not present in there. -
Error when serializing foreign key object with django-rest-framework-gis to geojson
I am trying to serialize into geojson a model with a foreign key that has a geometry field. I am using the django-rest-framework-gis. I am using django 2.2 I'm really stuck on this and none of the other related answers on stackoverflow work for me. e.g. I have tried versions of this: How can I flatten a foreignkey object with django-rest-framework-(gis) Set serializer geo_field as PointField from another model - Django I would be very grateful for help as been literally stuck on this for days. Thank you, kind people. The problem is I get this error: Expected a Response, HttpResponse or HttpStreamingResponse to be returned from the view, but received a <class 'statements.models.Response'> Models: from django.contrib.gis.db import models from django.contrib.gis.geos import Point class Hexgrid_10km2(models.Model): lng = models.FloatField() lat = models.FloatField() polygon = models.MultiPolygonField(srid=4326) centroid = models.PointField(default=Point(0,0), srid=4326) def __str__(self): return f'lng: { self.lng } lat: {self.lat }' class Response(models.Model): user = models.ForeignKey(User, on_delete=models.CASCADE) statement = models.ForeignKey(Statement, on_delete=models.CASCADE) hexgrid_10km2 = models.ForeignKey(Hexgrid_10km2, on_delete=models.CASCADE, null=True, blank=True) @property def polygon(self): return self.hexgrid_10km2.polygon Views class ResponseHeatmapAPIView(APIView): #ReadOnly def get(self, request, pk): final = Response.objects.all() serializer = ResponseHeatmapSerializer(final, many=True) return Response(serializer.data) Serializers class ResponseHeatmapSerializer(GeoFeatureModelSerializer): """ A class to serialize hex polygons as GeoJSON compatible data … -
Django: Limit choices in a models.Charfield by PrimaryKey
Another question from me tonight and I hope I can explain it adequately: I got three classes in my "models.py": class Customer(models.Model): full_name = models.CharField(max_length=100, null=True, unique=True) short_name = models.CharField(max_length=8, null=True, unique=True) class Project(models.Model): customer = models.ForeignKey(Customer, null=False, on_delete=models.CASCADE) name = models.CharField(max_length=255, null=True, unique=True) ... class Entry(models.Model): user = models.ForeignKey(User, null=True, blank=False, on_delete=models.CASCADE) customer = models.ForeignKey(Customer, null=True, blank=False, on_delete=models.CASCADE) project = models.ForeignKey(Project, null=True, blank=False, on_delete=models.CASCADE) date = models.DateField() shortText = models.CharField(max_length=100, null=False, blank=False) ... Note: One Customer can have multiple Projects. On one of my sites there's a table with buttons beside each "Customer". The plan is, that it should lead me to another page, were the user can write and save his "Entry". Right now, the PrimaryKey inside the Button/Link contains the ID of the "Customer". My question is: is it possible to limit the choices of the "Project" (inside a Drop-Down-Menu) to the "Customer" that has been clicked on? And is creating a ModelForm the right thing to do? Thanks to all of you and a good night! -
How to get return of InLineKeyboardButton with python-telegram-bot
I am working with python-telegram-bot building a menu system. I created a Django project, as shown below, using Webhook to connect to Telegram. I have the button menu built, according to the codes below, but I'm not sure how to interact with the contact when he clicks the button. Can you help me with this? view.py import json from django.http.response import HttpResponse from django.views.decorators.csrf import csrf_exempt from core.message import proccess @csrf_exempt def event(request): json_telegram = json.loads(request.body) proccess(request, json_telegram) return HttpResponse() messages.py import telegram from bot_webhook.settings import TOKEN from telegram import InlineKeyboardMarkup, InlineKeyboardButton bot = telegram.Bot(token=TOKEN) def proccess(request, json_telegram): msg_options(json_telegram) def msg_options(json_telegram): chat_id = json_telegram['message']['from']['id'] first_name = json_telegram['message']['from']['first_name'] last_name = json_telegram['message']['from']['last_name'] button_list = [] button_list.append(InlineKeyboardButton('Button One', callback_data='query_one')) button_list.append(InlineKeyboardButton('Button two', callback_data='query_two')) reply_markup = InlineKeyboardMarkup(build_menu(button_list, n_cols=2)) bot.send_message(text='Hello {0} {1}!\nI have this options:'.format(first_name, last_name), chat_id=chat_id, reply_markup=reply_markup) def build_menu(buttons, n_cols, header_buttons=None, footer_buttons=None): menu = [buttons[i:i + n_cols] for i in range(0, len(buttons), n_cols)] if header_buttons: menu.insert(0, [header_buttons]) if footer_buttons: menu.append([footer_buttons]) return menu -
django.db.utils.ProgrammingError: column "reviewee_id" of relation "Reviews_review" already exists
I keep getting this error when I try to deploy my django app to heroku. Locally, my app works but it uses a sqlite database whereas on heroku I am using postgres. I have tried dropping the database and restarting it as well as faking the migrations but no luck. Any advice? Here is the traceback: Operations to perform: Synchronize unmigrated apps: allauth, django_extensions, google, humanize, messages, staticfiles Apply all migrations: Reviews, Sessions, Users, account, admin, auth, contenttypes, sessions, sites, socialaccount Synchronizing apps without migrations: Creating tables... Running deferred SQL... Running migrations: Applying Reviews.0002_auto_20200415_1350...Traceback (most recent call last): File "/app/.heroku/python/lib/python3.6/site-packages/django/db/backends/utils.py", line 86, in _execute return self.cursor.execute(sql, params) psycopg2.errors.DuplicateColumn: column "reviewee_id" of relation "Reviews_review" already exists The above exception was the direct cause of the following exception: Traceback (most recent call last): File "manage.py", line 21, in <module> main() File "manage.py", line 17, in main execute_from_command_line(sys.argv) File "/app/.heroku/python/lib/python3.6/site-packages/django/core/management/__init__.py", line 401, in execute_from_command_line utility.execute() File "/app/.heroku/python/lib/python3.6/site-packages/django/core/management/__init__.py", line 395, in execute self.fetch_command(subcommand).run_from_argv(self.argv) File "/app/.heroku/python/lib/python3.6/site-packages/django/core/management/base.py", line 328, in run_from_argv self.execute(*args, **cmd_options) File "/app/.heroku/python/lib/python3.6/site-packages/django/core/management/base.py", line 369, in execute output = self.handle(*args, **options) File "/app/.heroku/python/lib/python3.6/site-packages/django/core/management/base.py", line 83, in wrapped res = handle_func(*args, **kwargs) File "/app/.heroku/python/lib/python3.6/site-packages/django/core/management/commands/migrate.py", line 233, in handle fake_initial=fake_initial, File "/app/.heroku/python/lib/python3.6/site-packages/django/db/migrations/executor.py", line 117, in migrate … -
Filter options in one to one field django admin
I have this 2 models from django.db import models def get_upload_path(instance, filename): return '{0}/{1}'.format(instance.imovel.id, filename) # Create your models here. class Imovel(models.Model): nome = models.CharField(max_length=50) descricao = models.CharField(max_length=800) area = models.IntegerField() quartos = models.SmallIntegerField(null=True, blank=True) banheiros = models.SmallIntegerField() disponivel_aluguel = models.BooleanField() disponivel_venda = models.BooleanField() valor_aluguel = models.DecimalField(max_digits=15, decimal_places=2) valor_venda = models.DecimalField(max_digits=15, decimal_places=2) valor_condominio = models.DecimalField(max_digits=15, decimal_places=2) valor_iptu = models.DecimalField(max_digits=15, decimal_places=2) capa = models.OneToOneField('ImagemImovel', related_name='capa', on_delete=models.DO_NOTHING, null=True, blank=True) def __str__(self): return self.nome class Meta: db_table = 'imovel' class ImagemImovel(models.Model): imovel = models.ForeignKey(Imovel, related_name='imagens', on_delete=models.CASCADE) nomeImagem = models.CharField(max_length=20) imagem = models.ImageField(upload_to=get_upload_path) def __str__(self): return self.nomeImagem class Meta: db_table = 'imagemImovel' I have houses and it's pictures and a field named 'capa' to say which one is the main picture. The problem is when I add a house through django admin, save and come back to choose the main one it let me choose images from other houses. How could I filter it to just show images that are related to this specific house? My django admin file from django.contrib import admin from .models import ImagemImovel, Imovel # Register your models here. class ImagemImovelAdmin(admin.TabularInline): model = ImagemImovel class ImovelAdmin(admin.ModelAdmin): inlines = (ImagemImovelAdmin, ) admin.site.register(Imovel, ImovelAdmin) -
How to make a "SELECT" of a model in django?
I am new to django and I am trying to make a django view that will bring me certain values from two models, this would be accomplished by doing a join if done directly in sql. What I intend to do with the obtained data is return it as JSON and use this json in an html page. I just don't know how to structure or if there is any way to get the data like sql. Model device class device(models.Model): device_name = models.CharField(max_length=50, unique=True, help_text='Station Name', validators=[validate_slug]) parent_area_id = models.ForeignKey('area', on_delete=models.CASCADE, null=True, help_text='Parent Area') f2cuid = models.CharField(max_length=100, unique=True, validators=[validate_slug]) ip_address = models.GenericIPAddressField(protocol='both', unpack_ipv4='True', default='127.0.0.1', blank=False, null=False) tower_ip_address = models.GenericIPAddressField(protocol='both', unpack_ipv4='True', default='127.0.0.1', blank=True, null=True) layered_tower = models.BooleanField(default=False, blank=True, help_text='Check if tower is multilayer') layer = models.CharField(max_length=1, unique=False, null=True, default=None, help_text='Layer', choices=layer_choices) target_oee = models.DecimalField(validators=[MinValueValidator(0), MaxValueValidator(100)], help_text='OEE Target', decimal_places=2, max_digits=6, default=0) target_availability = models.DecimalField(validators=[MinValueValidator(0), MaxValueValidator(100)], help_text='Availability Target', decimal_places=2, max_digits=6, default=0) target_performance = models.DecimalField(validators=[MinValueValidator(0), MaxValueValidator(100)], help_text='Performance Target', decimal_places=2, max_digits=6, default=0) target_quality = models.DecimalField(validators=[MinValueValidator(0), MaxValueValidator(100)], help_text='Quality Target', decimal_places=2, max_digits=6, default=0) Model notification_radio class notification_radio(models.Model): device_id = models.ForeignKey('device', on_delete=models.CASCADE, null=False) event_id = models.ForeignKey('event', on_delete=models.CASCADE, null=False) to_address = models.CharField(null=False, blank=False, max_length=100) message = models.CharField(null=False, blank=False, max_length=100, default='ANDON ALERT') notification_type = models.CharField(null=False, blank=False, choices=notification_type_choices, max_length=100) notification_id …
