Django community: RSS
This page, updated regularly, aggregates Django Q&A from the Django community.
-
Django MSSQL query better way to fetch 100k records
I have a MSSQL database from where i need to fetch the records of about 100k. Then this record is shown in the dashboard and each operation in record is saved to the postgres DB which is the main DB of django. What is the best way to fetch the MSSQL server records, fetching everytime 100k records or is there is any way to store the query results to speed up the dashboard data view. -
Find Wagtail rootpage in users language
I have setup 2 rootpages according to https://wagtail.org/wagtail-localize/ English and Dutch For my menu system I have: {% get_site_root as site_root %} {% top_menu parent=site_root calling_page=self %} Which calls @register.simple_tag(takes_context=True) def get_site_root(context): return Site.find_for_request(context["request"]).root_page But it's always returning the Dutch root page. And when I'm on english it's not returning the english rootpage. Any ideas? -
control the empty data in django filter
I was coding the backend using Django. I am a beginner in Django. I used a filter to filter some post requests from the HTML form. here is the code. @api_view(["POST"]) def program_search(request): Data_List = [] MyFilter = CreateProgram.objects.filter(price__lte=request.POST['price'], days=request.POST['days']).values() ... but if I send a request from HTML form that one field of data be null the filter function cant handle it. -
Does a Django Model Serializer need performance tuning?
Is a Django serializer doing things like .only() on the same fields that are specified in the Serializer Meta: fields attribute or do I have to do it manually like saying in my view: def get_queryset(self) return SomeModel.objects.only('my_field_on_serializer') ? -
Django duplicate file to all the records with M2M which is self referencing
I have a Serializer & APIview where i upload a file it should be uploaded to other related records as well. class Record(models.Model): name = models.CharField(max_length = 122) related_records = models.ManyToManyField('self', null = True) class RecordDocument(models.Model): record = models.ForeignKey(Record, related_name = 'documents', null = True, blank= True ) file = models.FileField(max_length=255, blank=True, null=True) class RecordDocumentSerializer(serializers.ModelSerializer): save_documents_to_related_records = serializers.BooleanField() class Meta: model = RecordDocument fields = ( 'upload_to_related_cases', 'file' ) class RecordDocumentUploadView(APIView): def post(self, request, *args, **kwargs): 'how do i get serializers field **save_documents_to_related_records** and save the file on **related_records** which is not used in serializer till now if there are any inside it' -
DRF Invalid pk object does not exist for foreign key on POST create
I have two classes related to each other. One class I have made the primary key a char field so I can easily reference to it or create it to match the id of the actual object (all objects will have this unique name). from django.db import models class Ven(models.Model): id = models.CharField(max_length=80, primary_key=True) statusOn = models.BooleanField(default=True) class Device(models.Model): device_id = models.CharField(max_length=80) ven_id = models.ForeignKey(VEN, related_name='devices', on_delete=models.SET_NULL, null=True) class DeviceSerializer(serializers.ModelSerializer): class Meta: model = Device fields = ['id', 'device_id', 'ven_id'] class VENSerializer(serializers.ModelSerializer): class Meta: model = VEN fields = ['id', 'statusOn', 'devices'] class DeviceList(generics.ListCreateAPIView): logger.info("DeviceList: view") # permission_classes = [permissions.IsAuthenticated] queryset = Device.objects.all() serializer_class = DeviceSerializer however when I try to run my test: class DevicesTestCase(TestCase): def setUp(self): self.factory = Client() def test_create_device(self): device = { "ven_id": "TEST_VEN_1", "device_id": "TEST_DEVICE_1", "statusOn": True, } response = self.factory.post('/devices/', data=device) self.assertEqual(response.status_code, 201) my response returns 400 and states: b'{"ven_id":["Invalid pk \\"TEST_VEN_1\\" - object does not exist."]}' I'm trying to write a custom create in my serializer to create the ven if it does not exist but it's not being called. Data is being validated else where. My breakpoint in my view set's perform_create also does not fire. I don't want to write a … -
How to serialize data more efficiently in Django Rest Framework?
So guys, part of my problem is solved by the question: #72534250 I understood that the path I was following was wrong, and I should change the optimization of the models to serializers and/or viewsets. But how? I had this structure: *I already removed element_name and element_text from Models Foo class User(models.Model): name = models.CharField(max_lenth=50) age = models.IntergerField() class Customer(models.Model): user = models.ForeingKey(User, on_delete=models.CASCADE, verbose_name='User') class Element(models.Model): name = models.CharField(max_lenth=50) text = models.TextField() class Bar(models.Model): element = models.ForeingKey(Element, on_delete=models.CASCADE, verbose_name='Element') class Foo(models.Model): bar = models.OneToOneField(Bar, on_delete=models.CASCADE, verbose_name='Bar') customer = models.ForeingField(Customer, on_delete=models.CASCADE, verbose_name='Customer') is_active = models.BooleanField('Is Active', default=False) def user(self): return self.customer.user # Removed def element_name(self): return self.bar.element.name # Removed def element_text(self): return self.bar.element.text And these serializers: class UserSerializer(ModelSerializer): class Meta: model = User fields = '__all__' class CustomerSerializer(ModelSerializer): class Meta: model = Customer fields = '__all__' class ElementSerializer(ModelSerializer): class Meta: model = Element fields = '__all__' class BarSerializer(ModelSerializer): element = ElementSerializer() class Meta: model = Bar fields = '__all__' class FooSerializer(ModelSerializer): bar = BarSerializer() user = UserSerializer() class Meta: model = Foo fields = '__all__' And this viewset: class FooViewSet(ModelViewSet): serializer_class = FooSerializer permission_classes = [IsAuthenticated] authentication_classes = [JWTAuthentication] http_method_names = ['get', 'post', 'patch'] def get_queryset(self): active = self.request.query_params.get('is_active', False) … -
Django multitenant migration raises KeyError: "prune"
So I've been working in a project for a while, and haven't really changed the models at all, and therefore haven't done any migrations. Now I needed to add two new fields and delete another one, which should be normally fine. I'm using django-tenants, so my command to run the migrations is ./manage.py migrate_schemas. Now, whenever I run that, I get the error KeyError: "prune" (the full traceback is below) in what seems to be internal code of Django. Now, afterwards I tried reverting my changes, so no new migration and running the comnad again, and got the same error. I also thought that maybe the database had gotten "dirty" at some point, so I tried migrating a clean database from scratch, with the same result. The migrations don't even get to start. Has anyone ever encountered something similar? The full traceback (I have simplified the paths) [standard:public] === Starting migration Traceback (most recent call last): File ":directory/./manage.py", line 22, in <module> main() File ":directory/./manage.py", line 18, in main execute_from_command_line(sys.argv) File "$venv/lib/python3.9/site-packages/django/core/management/__init__.py", line 446, in execute_from_command_line utility.execute() File "$/lib/python3.9/site-packages/django/core/management/__init__.py", line 440, in execute self.fetch_command(subcommand).run_from_argv(self.argv) File "$venv/lib/python3.9/site-packages/django/core/management/base.py", line 402, in run_from_argv self.execute(*args, **cmd_options) File "$venv/lib/python3.9/site-packages/django/core/management/base.py", line 448, in execute output = … -
Why am I getting the error: "cannot read properties of null (reading "style") when I try to integrate Plaid link in JS?
My relevant code is as follows function useLink(token){ const handler = Plaid.create({ token: token, onSuccess: (public_token, metadata) => {}, onLoad: () => {}, onEvent: (eventName, metadata) => {}, recievedRedirectUri: window.location.href, }); } But everytime I try to use my link token to pull up link on the frontend, I get the following error from link-unitialize.js: Uncaught TypeError: Cannot read properties of null (reading 'style') I checked the Plaid website and couldn't find this listed as a common error, so I must be doing something very wrong. What is the most likely cause of this? -
Django - how to set user permissions after login via LDAP?
I'm starting a project in Django and I've already managed to get ldap authentication working, with django-auth-ldap. Now, I want that after the user logs in, django checks if this user exists in certain tables of my models, and if it does, give these users permission to access certain apps. For example, I have an app called 'alimentacao'. Only users registered in my model 'alimentacao.alunos' will be able to access "http://meu-projeto/alimentacao" As the user is created automatically if it doesn't already exist in the user model, I believe I would have to create a custom ldap authentication backend and check, after successful login, if the user exists in the table, and then set the permission to user. Neither the Django nor the django-auth-ldap documentation clearly explains how to create an authentication backend: in which folders the files need to be created, or how the application will call my custom method, or if I need to change any settings. I'm completely lost. -
using hyperlink inside a TextField
If one of my description model objects is being read as "This is a test". How do I attach a hyperlink to "test"? As in, when someone clicks on it, it takes them to test.com model description = models.TextField() admin class TestDescription(admin.ModelAdmin): formfield_overrides = { models.TextField: {'widget': TinyMCE()}, } -
Django, how to get Choices human friendly text for a choice value with no model instance
Firstly yes I know about get_FOO_display(). It's great if you have a model instance, I don't in my situation. Im sure every django user at some point wonders why Django uses tuples instead of a dict to define the choices, but anyways, I have this model: class Review(models.Model): PENDING = '' APPROVED = 'A' DECLINED = 'D' SKIPPED = 'S' RESULT_CHOICES = ( (PENDING, 'Pending'), (DECLINED, 'Declined'), (APPROVED, 'Approved'), (SKIPPED, 'Skipped'), ) result = models.CharField('result', max_length=1, choices=RESULT_CHOICES, blank=True, default='') Now I don't have a model instance, but I do have a value, e.g. A, or D. How do I get the matching text value, i.e. Approved, or Declined etc. I could build a dict, and then look up the value, but surely theres a more "Built in django" way? Not looking for this kind of hammer approach: human_friendly = [ PENDING: 'Pending', DECLINED: 'Declined', APPROVED: 'Approved', SKIPPED: 'Skipped', ]['A'] -
How do I apply Django middleware everywhere except for a single path?
I'm using Python 3.9 with Django 3. I have defined this middleware ... MIDDLEWARE = [ 'django.middleware.security.SecurityMiddleware', 'django.contrib.sessions.middleware.SessionMiddleware', 'corsheaders.middleware.CorsMiddleware', 'django.middleware.common.CommonMiddleware', 'django.middleware.csrf.CsrfViewMiddleware', 'django.contrib.auth.middleware.AuthenticationMiddleware', 'django.contrib.messages.middleware.MessageMiddleware', 'django.middleware.clickjacking.XFrameOptionsMiddleware', 'directory.middleware.extend_token_response.ExtendTokenResponse' ] However, I don't want the middleware to apply to a certain URL. I have hard-coded this in the middleware like so class ExtendTokenResponse: def __init__(self, get_response): self.get_response = get_response # One-time configuration and initialization. def __call__(self, request): response = self.get_response(request) if request.path != '/' + LOGOUT_PATH: # Code to be executed for each request before # the view (and later middleware) are called. is_expired = True try: token = request.auth print("req path: %s" % request.path) is_expired = is_token_expired(token) if token else True except Exception as err: print(err) if not is_expired: but this seems a little sloppy and I would think the middleware comes with somethign out of the box to configure that this wouldn't need to be applied to my "/logout" path. Is there a more elegant way to configure this? -
With Django pagination my tables pages isn't same as the first page
I'm using pagination for my table in Django. In every page 8 rows of my table is showing. But when I go to second page its height and width isn't the same. All table cells height and width is changing. How can I fix this? My html: (a simple table) <table class="table" border=1> <thead> <tr> <th>Full Name</th> <th>Company</th> <th>Email</th> <th>Phone Number</th> <th>Note</th> <th>ID</th> </tr> </thead> <tbody> {% for customer in customers %} <tr> <td>{{customer.full_name}}</td> <td>{{customer.company}}</td> <td>{{customer.email}}</td> <td>{{customer.phone_number}}</td> <td>{{customer.note}}</td> <td>{{customer.id}}</td> </tr> {% endfor %} My View class TableView(ExportMixin, SingleTableView): model = Customer table_class = CustomerTable template_name = 'pages/user_page.html' context_object_name = 'customers' paginate_by = 8 My Css .table{ margin-top:60px; position: fixed; top:250px; left:100px; bottom:250px; right:100px; width:900px; margin-left: 230px; } -
Django: The QuerySet value for an exact lookup must be limited to one result using slicing using django
i am writing a logic that would allow me display all the quizes that a teacher have created from the database, now i want to make this more precise by only showing a student a quiz based on the courses they enrolled in, i am trying to write this filter and it not working as expected models.py Class Course(models.Model): course_creator = models.ForeignKey(User, on_delete=models.CASCADE, related_name="quiz_user") course_title = models.CharField(max_length=255) slug = models.SlugField(unique=True) def __str__(self): return self.title class UserCourse(models.Model): user = models.ForeignKey(User , null = False , on_delete=models.CASCADE) course = models.ForeignKey(Course , null = False , on_delete=models.CASCADE, related_name="usercourse") payment_status = models.CharField(max_length=100, choices=PAYMENT_STATUS, default="pending") date = models.DateTimeField(auto_now_add=True) class Quiz(models.Model): user = models.ForeignKey(User, on_delete=models.CASCADE, related_name="quiz_user") title = models.CharField(max_length=255) course = models.ForeignKey(Course, on_delete=models.SET_NULL, null=True) date = models.DateTimeField(auto_now_add=True) slug = models.SlugField(unique=True) def __str__(self): return self.title views.py def StudentQuizList(request): user_course = UserCourse.objects.filter(user=request.user) quizzes = Quiz.objects.filter() context = { # 'user_course': user_course, 'quizzes': quizzes, } return render(request, 'student_dashboard/quiz.html', context) error The QuerySet value for an exact lookup must be limited to one result using slicing. -
how can i persist data on website in django?
i have just started using django and dabbling with front end technologies i wrote a small web app and i want to push this up on a host server. my question is how do i update the website without losing the data in the dblite and user tables? won't i overwrite the db? this concept confuses me a little bit. i understand how this would work if i had a backend app servicing the webaite but this is going to be a website just for me and a few friends and family members. ... -
Validation isn't working for SerializerMethodField
I am working on my Django DRF app. I have two models Organization and BankAccount class Organization(models.Model): ... class BankAccount(models.Model): is_main = models.BooleanField(default=False) # organization should have 1 main account organization = models.ForeignKey( Organization, related_name="accounts", on_delete=models.CASCADE, ) ... I want to validate Organization data Organization must have at least one account with is_main=True but my validation isn't working (it looks like there are no validate_accounts cals. class OrganizationSerializer(serializers.ModelSerializer): accounts = serializers.SerializerMethodField() class Meta: model = Organization fields = '__all__' read_only_fields = ("id",) def get_accounts(self, obj): if obj.accounts is not None: return BankAccountSerializer(obj.accounts, many=True).data return None def validate_accounts(self, value): """ Organization should have account with 'is_main' true """ raise ValueError(value) # Don't see exception in logs if not value: return value for account in value: # check all accounts if account["is_main"] == True: return value raise serializers.ValidationError("Organization should have main account (is_main=true)") Example: For this data I expect validation error: (only one acc with "is_main": false,) "accounts": [ { "id": 1, "is_main": false, "bank_name": "Sber", "bank_bik": "123", "bank_account": "123", "correspondent_account": "312", "organization": 3 }, ] -
How to use mapbox vector tiles in a performant way?
I am a bit confused about Mapbox MVT. As I understood, a tile is a little piece of map, as in a jigsaw puzzle. Not completely sure about the working of MVT. https://docs.mapbox.com/data/tilesets/guides/vector-tiles-introduction/#benefits-of-vector-tiles Here, it says Vector tiles are really small, enabling global high resolution maps, fast map loads, and efficient caching. So the thing is I am trying to get all the coordinates from db which can go up to more than 10K and currently getting the data from postgis using: query = f""" SELECT NULL AS id, ST_AsMVT(q, 'default', 4096, 'mvt_geom') FROM (SELECT "locations"."name", ST_AsMVTGeom(ST_Transform(locations.geom, 3857), ST_TileEnvelope(1, 0, 0), 4096, 0, false) AS mvt_geom FROM locations) AS q; """ with connection.cursor() as cursor: cursor.execute(query) rows = cursor.fetchall() mvt = bytes(rows[-1][-1]) return Response( mvt, content_type="application/vnd.mapbox-vector-tile", status=200 ) Now I am wondering about the performance issues, as everytime a user will visit it will put stress on db. And another problem I am having is when using vector tiles as a source, it calls the source url and (hitting the db) everytime I move the map. type: 'vector', tiles: [ 'http://url/{z}/{x}/{y}.mvt' ] Is it possible to call the source url at a specific zoom level and until then all the … -
django.db.utils.IntegrityError: (1048, "Column 'user_id' cannot be null") in DRF
I have an app and I use django.contrib.auth.models.User as authentication models then I use for serializer: class UserSerializer(serializers.ModelSerializer): class Meta: model = User fields = '__all__' # fields = ['first_name', 'last_name', 'email', 'password', 'username'] def validate(self, attrs): if 'name' in attrs.keys(): name = attrs['name'] name = name.split(' ') first_name, last_name = name[0], name[1] attrs['first_name'], attrs['last_name'] = first_name, last_name attrs['password'] = make_password(attrs['password']) return attrs then I use for view set: class UserViewSet(viewsets.ViewSet): permission_classes = (permissions.AllowAny,) # authentication_classes = (TokenAuthentication) ... def create(self, request): # return response.Response(data=request.data) # user = User.objects.filter(username=request.data['username']).exists() # return response.Response(data= user) if User.objects.filter(username=request.data['username']).exists(): serials = UserSerializer( data=request.data, context={'request': request} ) user = None if serials.is_valid(): user = serials.save() else: user = UserSerializer(request.data, many=True) token, created = Token.objects.get_or_create(user=user) return response.Response( data={ 'token': token.key, 'user': UserSerializer(user).data } ) ... And after that I got this error: django.db.utils.IntegrityError: (1048, "Column 'user_id' cannot be null") -
Allow data insertion only after time duration threshold in django
I have a model in Django with a DateTimeField attribute. I want to forbid insertion of new data in the database if the duration between the datetime field of the new data and the latest datetime field in the database is less than some duration threshold. class MyModel(models.Model): time_stamp = models.DateTimeField(default=timezone.now, null=True) When I want to insert a datapoint say today, and the latest time stamp in my database is yesterday, and the duration threshold is one month (this operation should not be possible). -
Django form's redirect me to the wrong URL if the input data is invalid
I am very new to Django and working on a marketplace site. I have a few forms on my main listing page, one for taking bids and another for leaving comments. The bidding form when given a bid that is too low is supposed to redirect the used to the listing page now with an error displayed. What actually happens is that the URL changes and it displays a different view of the same listing page. I'm sure this can be solved easily with JavaScript and ignore the redirect all together, but I'd rather figure out why this is happening then try to work around it. When entering invalid data I expect to be taken back to my current page "listing/product_name", but instead I am taken to "bid/product_name". The same thing happens with the comments form "/comment/product_name", that form doesn't want to validate either. URLS from django.urls import path from . import views urlpatterns = [ path("", views.index, name="index"), path("ended", views.ended, name="ended"), path("login", views.login_view, name="login"), path("logout", views.logout_view, name="logout"), path("bid/<str:listing>", views.bid, name="bid"), path("register", views.register, name="register"), path("watchlist", views.watchlist, name="watchlist"), path("close/<str:listing>", views.close, name="close"), path("newListing", views.newListing, name="newListing"), path("listing/<str:listing>", views.listing, name="listing"), path("comment/<str:listing>", views.comment, name="comment"), path("change_watchlist/<str:listing>", views.change_watchlist, name="change_watchlist"), ] views.py I know there is some messiness … -
How i can show image from database to page. Django
i have media directory in my project, and i can't take image from it. When i try getting image, then i got this Request URL:http://127.0.0.1:8000/auto/media/img/'MyImg'.jpg and obviously it can't work, so how can i do this? while doing this i am trying to get data in html like this {% for item in auto %} <div> <p>{{item.name}}</p> <p>{{item.info}}</p> <p>{{item.description}}</p> <img src="media/{{item.photo}}"> </div> <hr> {% endfor %} -
Django Forms: Validation forms error when apply two validations
I have a form with 'start=forms.DateInput', end=forms.DateInput and active=forms.CheckboxInput, but when I try to validate this fields, I have these errors. KeyError at /employee/edit/70000007/ 'end' ... if form.is_valid(): ... end = self.cleaned_data['end'] But this works fine when apply only one validator. def clean_end(self): start = self.cleaned_data['start'] end = self.cleaned_data['end'] if end < start: raise forms.ValidationError('end date cannot be less than start date.') return end def clean_active(self): active = self.cleaned_data['active'] end = self.cleaned_data['end'] if active and end: raise forms.ValidationError('active employee should cannot be end date') return active Thanks for your help. -
Django Error: maximum recursion depth exceeded while calling a Python object
enter image description hereI am trying to view the page in my browser but could not because of this error despite trying all sort of methods. I have tried different ways to solving it. Please anyone could try and help. Thank you -
Is there any GCash API for Django Web Apps
I want to integrate a Gcash API for the payments of the user in my ecommerce website
