Django community: RSS
This page, updated regularly, aggregates Django Q&A from the Django community.
-
psycopg2.errors.UndefinedTable: relation "libman_classbooks" does not exist
I had mistakenly deleted my migration folders for all my apps in my project. I therefore had to redo makemigrations and migrate for each of those apps. When thence I try to access the specific areas with relational paths I get an error. relation "libman_classbooks" does not exist When I try to make some changes on the models, save and try to run makemigrations and migrate. this does not go on well but returns. django.db.utils.ProgrammingError: relation "libman_classbooks" does not exist. I have been forced to guess that I need to manually create the tables in the database. Using CREATETABLE. I don't know if this is the best option though. So I think my option may be possible in development thro' the pgAdmin, but what about in production? If CREATETABLE is the best option to take, how will I do it for the production database??. I already have data in my database which do not need interference. -
405 Error when trying to update picture in Django
I cannot update user profile_picture, I can update all other information related to a user but not their profile picture. When I try to update a profile_picture I get a null value for the picture and this error: Method Not Allowed: /update_profile/2/ [29/Apr/2022 14:11:16] "GET /update_profile/2/ HTTP/1.1" 405 13924 This is my API endpoint: path('update_profile/<int:pk>/', views.UpdateProfileView.as_view(), name='update_profile'), This is my UpdateProfileView: class UpdateProfileView(generics.UpdateAPIView): queryset = User.objects.all() serializer_class = UpdateUserSerializer def profile(request): if request.method == 'PUT': try: user = User.objects.get(id=request.user.id) serializer_user = UpdateUserSerializer(user, many=True) if serializer_user.is_valid(): serializer_user.save() return Response(serializer_user) except User.DoesNotExist: return Response(data='no such user!', status=status.HTTP_400_BAD_REQUEST) My UpdateUserSerializer: class UpdateUserSerializer(serializers.ModelSerializer): email = serializers.EmailField(required=False) city = serializers.CharField(source='profile.city', allow_blank=True, required=False) country = serializers.CharField(source='profile.country', allow_blank=True, required=False) profile_pic = Base64ImageField(max_length=None, use_url=True, required=False) # serializers.ImageField(source='profile.profile_pic', use_url=True, required=False) class Meta: model = User #, 'city', 'country', 'bio' fields = ['username', 'email', 'password', 'first_name', 'last_name', 'city', 'country', 'profile_pic'] # fields = UserDetailsSerializer.Meta.fields + ('city', 'country') extra_kwargs = {'username': {'required': False}, 'email': {'required': False}, 'password': {'required': False}, 'first_name': {'required': False}, 'last_name': {'required': False}, 'city': {'required': False}, 'country': {'required': False}, 'profile_pic': {'required': False} } def update(self, instance, validated_data): profile_data = validated_data.pop('profile', {}) city = profile_data.get('city') country = profile_data.get('country') profile_pic = profile_data.get('profile_pic') instance = super(UpdateUserSerializer, self).update(instance, validated_data) profile = instance.profile if … -
Is there a way to filter out items from RelatedManager in a ModelViewSet?
I'm using DRF for a simple API, and I was wondering if there's a way to achieve this behavior: I've got two models similar to the following: class Table(models.Model): name = models.CharField(max_length=100) ... class Column(models.Model): original_name = models.CharField(max_length=100) name = models.CharField(max_length=100, blank=True, null=True) ... table = models.ForeignKey(Table, on_delete=models.CASCADE, related_name="columns") And their serializers as follows: class ColumnSerializer(serializers.HyperlinkedModelSerializer): table = serializers.HyperlinkedRelatedField( read_only=True, view_name="table-detail" ) class Meta: model = Column fields = ["url", "name", "table"] class TableSerializer(serializers.HyperlinkedModelSerializer): dataset = serializers.HyperlinkedRelatedField( read_only=True, view_name="dataset-detail" ) tags = serializers.SlugRelatedField( many=True, slug_field="name", queryset=Tag.objects.all() ) columns = ColumnSerializer(many=True, read_only=True) class Meta: model = Table fields = [ "url", "name", ... "columns", ] This returns me an output similar to { ... "results": [ { "url": "http://0.0.0.0:8001/api/tables/1/", "name": "some-name", "columns": [ { "url": "http://0.0.0.0:8001/api/columns/1/", "name": "id", "table": "http://0.0.0.0:8001/api/tables/1/" }, ... } which is totally fine. But what I'd really want to do is, if a Column has name=None, it's filtered out from every API ViewSet. I've managed to do it on the ColumnViewSet by doing queryset = queryset.filter(name__isnull=False), but I can't do it for the TableViewSet or others that might show a Column list. I've tried tinkering with the ColumnSerializer, but the best I could get from it was … -
Is it possible to rename the application's group name in Django?
For example, you have "Groups" and "Users" under "AUTHORIZATION AND AUTHENTICATION" (or something named like that). If you make a new app and register its model, it's gonna write out the name of the application. I want to rename that in the admin. -
GNUPLOT integration with web application
I would like to point out that I am just learning programming, so I am not so experienced. I would like to create a web application in django REST framework as backend and ractjs as front end, which would create graphs using gnuplot,I would like the application to work more or less like an overleaf where the user enters the commands from gnuplot and when the button is pressed the finished graph appears. My question is what's the best way to integrate or invoke gnuplot to work like that and what's tools i should use? I saw a similar topic on the forum but no answer to his question Text. Would javascipt be a good choice or would python be sufficient for such a task? Any tips are welcome. -
NoReverseMatch at /allbook Reverse for 'random_book' with arguments '('',)' not found. 1 pattern(s) tried: ['info/(?P<pk>[0-9]+)\\Z']
NoReverseMatch at /allbook Reverse for 'random_book' with arguments '('',)' not found. 1 pattern(s) tried: ['info/(?P[0-9]+)\Z'] views.py class MoreInfoView(View): def get(self, request, id): book_info = BookModel.objects.filter(id=id).first() stuff = get_object_or_404(BookModel, id=self.kwargs['id']) total_likes = stuff.total_likes() return render(request, 'bookapp/more_info.html', context={ 'id': id, 'book_info': book_info, 'book': BookModel, 'total_likes': total_likes, }) def random_book(self): book_pks = list(BookModel.objects.values_list('id', flat=True)) pk = random.choice(book_pks) book = BookModel.objects.get(pk=pk) return HttpResponse(book) html <li class="navigation"><a class="nav-link" href="{% url 'random_book' pk %}">random</a></li> url.py urlpatterns = [ path('', index, name='index'), path('allbook', AllBookView.as_view(), name='allbook'), path('addbook', AddBookView.as_view(), name='addbook'), path('register', RegisterView.as_view(), name='reg'), path('login', LoginView.as_view(), name='login'), path('logout', LogoutView.as_view(), name='logout'), path('info/<int:id>', MoreInfoView.as_view(), name='more_info'), path('profile', profileview, name='profile'), path('password-change', ChangePasswordView.as_view(), name='change_pass'), path('like/<int:pk>', LikeView, name='like_book'), path('info/<int:pk>', views.random_book, name='random_book'), -
i got decimal.InvalidOperation: [<class 'decimal.ConversionSyntax'>]
views.py @api_view(["POST", "GET"]) @permission_classes([IsAuthenticated]) def add_order(request, pk): print(request.user) customer = md.Customer.objects.get(pk=pk) if request.method == "POST": description = request.data['description'] price = request.data['price'] order = md.Order.objects.create(customer=customer, date_created=zt.now(), description=description, price=float(price), customer_total_when_created=customer.total_owe[0] ) try: is_paid = request.data['is_paid'] if is_paid == "on": who_paid = request.data['who_paid'] payment_method = request.data['payment_method'] who_took_money = request.user if who_paid == customer.name: order.who_paid = customer elif who_paid == customer.parent: order.who_paid = customer.parent order.payment_method = payment_method order.who_took_money = who_took_money order.date_paid = zt.now() customer.total = customer.total_owe customer.save() order.save() except: print("no payment succeed") order_api = OrderSerializer(order) return Response(order_api.data) customer_api = CustomerSerializer(customer) parent_api = CustomerSerializer(customer.parent) context = { "customer": customer_api.data, "parent":parent_api.data, "sample": [ {"description": "secreal", "price": "12.21", "is_paid": "on", "who_paid": "azra", "payment_method": "CARD"} ] } return Response(context) models.py class Order(models.Model): payment_method_list = [("CASH","CASH"),("CARD","CARD")] customer = models.ForeignKey(Customer,on_delete=models.CASCADE,null=True,blank=True,) who_paid = models.ForeignKey(Customer,on_delete=models.CASCADE,null=True,blank=True, related_name='%(class)s_requests_created') who_took_money = models.ForeignKey(User,on_delete=models.CASCADE,null=True,blank=True, related_name='who_took_money') payment_method = models.CharField(choices=payment_method_list,max_length=4,default="CASH",blank=True,null=True) date_paid = models.DateTimeField(blank=True,null=True) date_created = models.DateTimeField(blank=True, null=True) date_modified = models.DateTimeField(blank=True, null=True, auto_now=True) is_paid = models.BooleanField(default=False, blank=True,null=True) customer_total_when_paid = models.DecimalField(max_digits=5,decimal_places=2,null=True,blank=True) customer_total_when_created = models.DecimalField(max_digits=5,decimal_places=2,null=True,blank=True) description = models.TextField(blank=True,null=True) price = models.DecimalField(max_digits=5,decimal_places=2,null=True,blank=True) def __str__(self): return self.description[0:12] from django.db.models.signals import post_save def update_total_owe_created_order(sender,instance,created,**kwargs): if created: order = instance customer = order.customer customer.total = customer.total_owe[0] customer.save() post_save.connect(update_total_owe_created_order,sender=Order) def update_total_owe_updated_order(sender,instance,created,**kwargs): if created==False: order = instance customer = order.customer customer.total = customer.total_owe[0] customer.save() post_save.connect(update_total_owe_updated_order,sender=Order) I have an … -
Django Gunicorn - Failed to find attribute 'application'
I had a Django/Gunicorn app running just fine, but after a code update it stopped working due to this gunicorn error. I don't think anything has changed regarding that setup, so I am at a loss as to why it won't work now. /etc/systemd/system/triform.service [Unit] Description=triform daemon Requires=triform.socket After=network.target [Service] User=django Group=www-data WorkingDirectory=/home/triform/django ExecStart=/home/triform/django/venv/bin/gunicorn \ --access-logfile - \ --workers 3 \ --bind unix:/run/gunicorn.sock \ triform.wsgi:application [Install] WantedBy=multi-user.target /etc/systemd/system/triform.socket [Unit] Description=triform socket [Socket] ListenStream=/run/triform.sock [Install] WantedBy=sockets.target /home/triform/django/triform/wsgi.py import os from django.core.wsgi import get_wsgi_application os.environ.setdefault('DJANGO_SETTINGS_MODULE', 'triform.settings') application = get_wsgi_application() in /home/triform/django/triform/settings.py: WSGI_APPLICATION = 'triform.wsgi.application' -
How to cache query data per request
I have a decorator that fetches some data from DB and modifies response context data. This decorator is applied to several views, the problem is that every time the decorator function is being executed it makes the DB query again. I would like to cache the result of a DB only per request, on page refresh/new request I would like to fetch data again. views.py def set_data(): def wrapper(request): # fetching data from db data = get_some_data_from_db() response = view(request) response.context_data["data"] = data return response.render() return wrap @set_data def view1(request): return TemplateResponse(request, "template1.httml", context) @set_data def view2(request): return TemplateResponse(request, "template2.httml", context) I've tried to use django-request-cache library, but this doesn't solve this problem. ANy idea how can i achieve it? -
How to Change django 404 error into own html design
File not found error come in django , i want to change into own html 404 code design page or replace it. What i do for change it? -
django using request in auth form(passwordchangeview)
class PasswordsChangeView( PasswordChangeView ): form_class = PasswordChangeForm success_url = reverse_lazy('password_success') ##admin filteration group = list(request.user.groups.values_list('name',flat = True)) the request in above is not defined , it works for my function which i have request, but in auth form i don't know how to pass the request, any idea role='admin' type = search( group ,role) extra_context={'t': type} -
Access decorators from multiple views in Django
As I am learning Django, I am running into this issue I have not found a solution for. Imagine I have 5 apps in my project: * project * accounts * profiles * products * services In my accounts project, I have all of the logic for authentication and have created a decorators.py file under accounts that I would like to check from any of the apps. Under accounts, in my views.py, I simply import the decorators.py as such: from .decorators import * At this point, however, I am not seeing how to import the same decorators.py from the views.py file in other apps. -
Save Django Model when list_editable fields are changed in Django Admin change_list view
I have a Django Model which I'm trying to update from the Admin change_list view when a field that is listed in list_editable has a change event fired. Right now the only way to save the updates is by clicking a "Save" button and then the page reloads. I don't want the page to reload at all. I just want it to update the model asynchronously. For example I have the following model. class Example(models.Model): name = models.CharField() hide = models.BooleanField(default=False) In the Admin Form I have class ExampleAdmin(admin.ModelAdmin): list_display = [ "name", "hide" ] list_editable = [ "name", "hide" ] When viewing the change list for Examples now I will see the values listed out with an editable text input for name and a checkbox for hide. I would like to listen for events on those inputs and when they are fired send an async request to update the specific model. -
Is this the correct way of making primary keys in django?
class profiles(models.model): customer_ID = models.IntegerField().primary_key Is this the correct way of making a primary key in django?? -
how to copy data from model to another model in Django after filtering?
here is the models: class Rooms(models.Model): name=models.CharField(max_length=100) image=models.URLField() max_person=models.CharField(max_length=100) office=models.CharField(max_length=200) status=models.CharField(max_length=200) cost=models.CharField(null=True,max_length=250) roomId=models.CharField(max_length=100,null=True) Address= models.CharField(max_length=100,null=True) def __str__(self): return str(self.name) class Available_Rooms(models.Model): users=models.ForeignKey(Rooms,on_delete=models.CASCADE) name=models.CharField(max_length=100) image=models.URLField() max_person=models.CharField(max_length=100) office=models.CharField(max_length=200) status=models.CharField(max_length=200) cost=models.CharField(null=True,max_length=250) roomId=models.CharField(max_length=100,null=True) Address= models.CharField(max_length=100,null=True) def __str__(self): return str(self.name) at model "rooms" there is 100 objects (rooms) and what I want filter it and list rooms that have maxperson = 4 availablity= Rooms.objects.filter(maxperson="4").all() and want to to copy the rooms details to the other model "Available_Rooms" any idea how that can be done? many thanks in advance -
How to iteratively render the first X fields in a Django form
I'm rendering a form in a Django html template by using a for loop and iterating over the fields. I want to add some sections & headers inside my form, so is there a way to 'slice' the form fields or otherwise iteratively display only a subsection of fields? Something like {% for field in form.slice(0, 5) %} <!-- render first 5 fields --> <h2>Section 2</h2> <p>Some text about next section</p> {% for field in form.slice(5, 10) %} <!-- render the next 5, etc. --> I know the worst case answer is to render each field manually, but it's a VERY long form. Here's my existing form code. {% for field in form %} <div class="field"> <label class="label" for="{{field.id_for_label}}"> {{field.label}} </label> <div class="control">{{field}}</div> {% if field.help_text %} <p class="help">{{field.help_text}}</p> {% endif %} <ul class="errorlist"> {% for error in field.errors %} <li class="is-danger help">{{error}}</li> {% endfor %} </ul> </div> {% endfor %} -
Django version downgraded when I install third party Django package
When we upgrade Django version this two packages prompted incompatible Installing collected packages: django Attempting uninstall: django Found existing installation: Django 3.1.6 Uninstalling Django-3.1.6: Successfully uninstalled Django-3.1.6 ERROR: pip's dependency resolver does not currently take into account all the packages that are installed. This behaviour is the source of the foll owing dependency conflicts. django-helpdesk 0.3.4 requires Django<4,>=2.2, but you have django 4.0.4 which is incompatible. django-celery-beat 2.2.1 requires Django<4.0,>=2.2, but you have django 4.0.4 which is incompatible. Successfully installed django-4.0.4 When we try to upgrade packages(django-helpdesk) django core version was downgraded. Is this not a bug? pip install django-helpdesk --upgrade -------- -------- -------- Installing collected packages: Django Attempting uninstall: Django Found existing installation: Django 4.0.4 Uninstalling Django-4.0.4: Successfully uninstalled Django-4.0.4 Successfully installed Django-3.2.13 Please help me -
Python Django login logout logic
In this question I won't add any code. Just wanted to know whether I should redirect the user to home page if user is already authenticated in the system but tries to visit login page. What is the best solution? -
Trouble with Django and Google Charts
I'm trying to make my page update in real time but for some reason the code get's stuck on "var = new_data ..." function refresh() { $.ajax({ type:"GET", url: "{% url 'get_data' %}", data:{ poll_id: {{ poll.id }} }, success: function(data) { // the code stops running here var new_data = google.visualization.arrayToDataTable(data); var options = { title: "Results", legend: 'none' }; var chart = new google.visualization.PieChart(document.getElementById('chart_div')); chart.draw(new_data, options); }, }); setTimeout(function () { refresh() }, 1000); }; } -
sql query not work in django but dose in sql shell
i have a project in django 3 and try to create a filter for finding conflicted item via datetime in postgresql 13. when i use below script via postgesql shell, it worked!. SELECT a.*, b.* FROM users_task AS a JOIN users_task AS b ON daterange(a."startDatetime"::date, a."endDatetime"::date) && daterange(b."startDatetime"::date, b."endDatetime"::date) WHERE (a."startDatetime"::date, a."endDatetime"::date) <= (b."startDatetime"::date, b."endDatetime"::date) but when i use it in my code, not work and return empty. return tsk.objects.raw(''' SELECT a.*, b.* FROM users_task AS a JOIN users_task AS b ON daterange(a."startDatetime"::date, a."endDatetime"::date) && daterange(b."startDatetime"::date, b."endDatetime"::date) WHERE (a."startDatetime"::date, a."endDatetime"::date) <= (b."startDatetime"::date, b."endDatetime"::date) ''') i found &&(contains) not work when inserted in my code. please help me. -
django get module path in shell
I am on a really big project that jump among many modules, here's a difficulty, sometimes I add a print in certain line of particular file, for testing purposes. after building, I run the file from shell, and there is a line output comes from nowhere pops up in my command line (well, not exactly nowhere, I forgot where I added the print), I need a stronger print like: print('test') # test flags/urls.py 348 therefore, I am building a put function, from inspect import currentframe def put(value): frameinfo = currentframe() location = 'path to this module' print(f'{value} {location} {frameinfo.f_back.f_lineno}') put({'name': 'jason'}) # {'name': 'jason'} path to this module 9 when I tried to work out the path, something unexpected happened. flags/test.py print(__file__) # /Applications/MAMP/htdocs/canvas/src/zzd/env/lib/python3.7/site-packages/django/core/management/commands/shell.py shell (env) 🌹 python manage.py shell < '/Applications/MAMP/htdocs/canvas/src/zzd/zzd/flags/tests.py' /Applications/MAMP/htdocs/canvas/src/zzd/env/lib/python3.7/site-packages/django/core/management/commands/shell.py it turns out to always return the path of shell.py, instead of my module file path. I wonder why this happens, would be very gratefully for your help. -
Run different python files on Django startup
After running my Django project, I want my different python files to run concurrently until I terminate the project. When I run "python manage.py runserver" I want different python files to run at the same time. Is there a way to do this in django? I searched but couldn't find the exact result I wanted. -
Django FIlter: Filtering object hidden in multi layered model structure
I have a following django model relationship: model Project(): model Vehicle(): ForeignKey(Project) model Concept(): ManyToManyField(Vehicle) model Analysis(): ForeignKey(Concept) I want to sort out all Analyses objects which are connected to a Project with a known id. Concept can be for more than one vehicle but all the vehicles within a concept will be limited to only one Project. Or should i justadd to all following models a foreignkey with a project field? Thanks -
How can I add Datepicker in DjangoCreateView
#view.py class JobCreateView(CreateView): model = Job template_name = 'Job_create.html' fields = ['Company' ,'Job_title','Department','Start_date','end_date','Consent'] def form_valid(self, form): form.instance.Alumni_id = self.request.user.alumni return super().form_valid(form) def get_form(self): '''add date picker in forms''' form = super(JobCreateView, self).get_form() form.fields['end_date'].widget = forms.SelectDateWidget() return form from get_form function I got this kind of date Input but I want a date picker that's look like a calender -
django add method to standard Model class
from articles.models import Article label = f'{Article._meta.app_label}.{Article._meta.object_name}' I need to use label for almost all inherited classes from from django.db import models.Model, I want to add this method to the standard Model class without changing library file. if there is built-in way to mix-in a bunch functions to model class without adding inheritance classes and changing initial file, please let me know, I more than grateful. class Model(metaclass=ModelBase): def label(cls): return f'{cls._meta.app_label}.{cls._meta.object_name}'
