Django community: RSS
This page, updated regularly, aggregates Django Q&A from the Django community.
-
Django DRF how to overwrite Custom throttles
I want to implement this Custom throttles. I want to disallow every request if it exceeded a certain number of seconds. For example, If anyone sends more than 10 requests per seconds then I want to stop and wait 20seconds before sending new request. I tried this code but didn't work class CstomRateThrottle(throttling.BaseThrottle): def allow_request(self, request, view, wait=20): return True They saying Optionally I may also override the .wait() method but don't know how. -
How to change field value while exporting in Django Export Functionality
When I export category I'm getting only Active value in status column. If category status is 0 then also i'm getting Active. Here is my admin.py from import_export import resources from import_export.admin import ImportExportMixin,ExportActionModelAdmin from .models import Category class CategoryResource(resources.ModelResource): status = Field(column_name='Status') class Meta: model = Category # Fields to export fields = ['name','status','slug'] # Order of Field In export export_order = ['name', 'slug', 'status'] # custom field value if bool function name should be 'dehydrate_<field_name> def dehydrate_status(self, category): if category.status: return 'Active' else: return 'In-active' @admin.register(Category) class CategoryAdmin(ImportExportMixin,ExportActionModelAdmin,admin.ModelAdmin): # Add this to configure export settings resource_class = CategoryResource Anything i'm missing in the code? Using django-import-export -
How to sum with condition in a Django queryset
I am trying to sum Django query with a condition. Suppose I have got some data like this: | Name | Type | --------------- | a | x | | b | z | | c | x | | d | x | | e | y | | f | x | | g | x | | h | y | | i | x | | j | x | | k | x | | l | x | And these types are string and they have values, like x = 1, y = 25, z = -3 How can I sum up all the values without a loop? Currently using a loop. data = A.objects.all() sum = 0 mapp = {'x': 1, 'y': 25, 'z': -3} for datum in list(data): sum = sum + mapp[datum.type] print(sum) -
How to prevent sphinx adding exception and bases objects on documentation
Hi have this sphinx documentation inside my class. I would like to prevent sphnix adding exception and base objects as shown in the screen. Any help please ? class CampaignNamingTool(models.Model): """ The goal of Campaign Naming Tool is to help account mangers to plan their campaigns and to follow nomenclature guidelines and thus avoid bugs or missing campaigns. Because campaigns are case sensitives in the workflow process. So every bad named or misnamed campaign are ignored and it won't be displayed in the users insertions orders. Plase use this formular to create your campaign for the first time. .. admonition:: Important If the campaign does not respect the guidelines, you can't follow it here. It will be missing in the monitoring. Parameters ---------- user : owner or in charge of the campaign. year, month : year and month when launching campaign online. advertiser : advertiser of the campaign. name : name of the campaign. device : device the campaign must be served (Desktop, Mobile, tablette). type_of_format : format that campaign must be served (IAB, Video, etc) kpi : KPI of the campaign (CPM, CPC, CPV, CPA, etc) Returns ------- an Insertion Order object composed by the concatenation of all these … -
cannot access the passed file from swagger ui inside django debugger(pdb)
created an api and added swagger to the api with the help of the package drf-yasg the current updated version 1.20.0, then added code like this success_res_data = openapi.Schema(type=openapi.TYPE_OBJECT, properties={'status': openapi.Schema(type=openapi.TYPE_NUMBER, title='200'), 'success': openapi.Schema(type=openapi.TYPE_OBJECT, properties={'message_header': openapi.Schema(type=openapi.TYPE_STRING), 'message': openapi.Schema(type=openapi.TYPE_STRING)})}) error_res_data = openapi.Schema(type=openapi.TYPE_OBJECT, properties={'status': openapi.Schema(type=openapi.TYPE_NUMBER, title='400'), 'error': openapi.Schema(type=openapi.TYPE_OBJECT, properties={'message_header': openapi.Schema(type=openapi.TYPE_STRING), 'message': openapi.Schema(type=openapi.TYPE_STRING)})}) invitation_file = openapi.Parameter('invitation_file', openapi.IN_QUERY, type=openapi.TYPE_FILE, required=True) @swagger_auto_schema( manual_parameters=[invitation_file], operation_description="description", responses={200: success_res_data, 400: error_res_data} ) def post(self, request): invitation_file = request.data.get('invitation_file', None) this invitation_file variable is returning None even if we pass the file from front-end -
passing a for loop value to bootstarp modal in django
Here i am trying to pass the value outside for loop modal using ajax Here is the reference link which i followed reference link and please help me where i am wrong here is my template.html {% for compliance in compliance %} {% complience_category compliance request.user as compliances %} {% for qualification in compliances %} ..... ..... <td> <button data-toggle="modal" data-target="#modal-default" data-id="{{ qualification.id }}" type="button" class="btn btn-warning margin-bottom edit-qualification"> edit </button> </td> .... ..... {% endfor %} {% endfor %} {% csrf_token %} <div class="modal hid fade" id="modal-default"> <div class="modal-dialog"> <form class="form-horizontal" method="POST" enctype="multipart/form-data" action="{% url 'update_qualifications' qualification.id %}" "> {% csrf_token %} {% if qualification %} <div class="modal-header"> <button type="button" class="close" data-dismiss="modal" aria-hidden="true">&times;</button> <h3>Update Compliance</h3> </div> <div class="modal-body"> <div class="control-group"> <label class="control-label" for="inputdate_{{qualification.id}}">Expiry Date</label> <div class="controls"> <input type="date" id="inputdate_{{qualification.id}}" name="expiry_date" value="{{qualification.expiry_date|date:'Y-m-d'}}"> </div> </div> </div> <div class="modal-footer"> <button class="btn" data-dismiss="modal">Close</button> <button class="btn btn-primary" type="submit">Save</button> </div> {% endif %} </form> </div> </div> here is my AJAX <script> $(document).on('click','.edit-qualification',function(){ var id = $(this).data('id'); console.log(id) $.ajax({ url:'', type:'POST', data:{ 'id':id, 'csrfmiddlewaretoken': $('input[name=csrfmiddlewaretoken]').val(), }, success:function(data){ $('#modal-default .modal-dialog').html($('#modal-default .modal-dialog',data)); $('#modal-default').modal('show'); }, error:function(){ console.log('error') }, }); }); </script> here when clicking edit of particular item it need to update only for that item Please help me … -
django UploadFileForm with reduced ForeignKey Queryset
I need to find a way to reduce the category queryset with my filters. How can I do this? I have and UploadFileForm based on model: class Files100M(models.Model): id = models.AutoField(primary_key=True) file = models.FileField("File", upload_to=handle_uploaded_file,) project = models.ForeignKey(Project, on_delete=models.CASCADE) category = models.ForeignKey(Category, on_delete=models.CASCADE) date = models.DateTimeField(default=datetime.now, blank=True) The Form class is as follows: class UploadFileForm(forms.ModelForm): ALLOWED_TYPES = ['pdf', 'dwg'] class Meta: model = Files100M fields = ['project', 'category', 'file'] My template looks like this: {% load django_bootstrap5 %} <div class="col-sm-3 col-md-3 col-sm-3 col-lg-2"> {% if file_upload_form %} <form method='post' enctype="multipart/form-data"> {% csrf_token %} {% bootstrap_form file_upload_form %} {% bootstrap_button button_type="submit" content="Upload File" %} {% bootstrap_button button_type="reset" content="Cancel" %} </form> {%endif%} -
how to create multisite django with one database?
I want to create some websites on a server with one database. my structure is: main_domain.com/ main_domain.com/website1 main_domain.com/website2 . . main_domain.com/website_n Some contents are common between websites. I use Django 3 What is best practice for doing this. -
Django Strawberry writing a mutation that includes a foreign key that creates multiple objects
I am trying to have a graphql mutation create the inputs for two django models at once using strawberry. I check the docs here and there were no examples of how to do this. I have the following django model: class Address(models.Model): name = models.CharField() class Person(models.Model): name = models.CharField() address = models.ForeignKey('Address', on_delete=models.CASCADE, blank=False, null=False) With they type.py @strawberry.django.type(models.Address) class Address: id: auto name:auto @strawberry.django.input(models.Address) class AddressInput: id: auto name:auto @strawberry.django.type(models.Person) class Person: id: auto name: auto address:'Address' @strawberry.django.input(models.Person) class Person: id: auto name: auto address:'AddressInput' For the schema.py I have: @strawberry.type class Mutation: createAddress: Address = mutations.create(AddressInput) createPerson: Person =mutations.create(PersonInput) schema = strawberry.Schema(mutation=Mutation) I tried the Mutation but got an error: mutation newPerson ($name: String!, $addressname:String!){ createPerson(data: {name: $name, address: {name: $addressname}}) { id name address { id name } } } #Query Variables { "name": "Min", "addressname": "jkkihh", } Error message: "message": "Field 'id' expected a number but got PersonInput(id=<strawberry.unset._Unset object at 0x00000194FB945C90>, addressname='jkkihh', description=<strawberry.unset._Unset object at 0x00000194FB945C90>, notes=<strawberry.unset._Unset object at 0x00000194FB945C90>)." This is similar the this question I previously asked using graphene. Where it was resolved by making an new object type to store and wrote a mutate function inside a class for mutation. I also … -
HTML min max step validation doesn't work when using javascript to submit
I did use standard html validation for number input (min, max and step). User couldn't write the number exceeding this limit and couldn't use arrows to exceed it either. I had to prevent double clicking Submit button- users sometimes clicked this button very fast and it did add double the objects it supposed to add. So I used some js and jQuery: <script> $(document).ready(function() { $("#addButton").on("click", function() { var $this = $(this); $this.attr('disabled', true); $("#addForm").submit(); }); }); </script> With this way of submiting the form the validation is gone. I still can't use arrows to exceed the limit but user can just type any value. Is there any other way to approach this? I could validate in Javascript but there's a lot of different objects with different validation limits. Or should I ask- is there any other way to prevent double clicking submit button? I use Django and I tried to prevent this action in backend using django-ratelimit but it didn't work like it should @ratelimit(key='ip', rate='2/s') def my_view(request): -
Import "django.db.models" could not be resolved from source / py manage.py makemigrations No changes detected
I am working on a project using django and I am using Visual Studio Code software. In my 'store' directory i have a python package called 'tiendaonline' and the app called "gestionpedidos" where I am trying to create a a Table (DDBB) The problem i am getting is that I cannot create table because when I try to run "py manage.py makemigrations" I can see the msg "No changes detected". Also I can see in the window called problems this msg: " Import "django.db.models" could not be resolved from source " My setting.py is like this: INSTALLED_APPS = [ 'django.contrib.admin', 'django.contrib.auth', 'django.contrib.contenttypes', 'django.contrib.sessions', 'django.contrib.messages', 'django.contrib.staticfiles', 'gestionpedidos', ] and my model is this: from django.db import models # Create your models here. class Pedidos(models.Model): numero = models.IntegerField(max_length=100 ) fecha = models.DateField(max_length=300 ) entregado = models.BooleanField() class Clientes(models.Model): name = models.CharField(max_length=30 ) direc = models.CharField(max_length=50 ) Email = models.EmailField() Tel = models.EmailField() class Articulos(models.Model): name = models.CharField(max_length=100 ) seccion = models.CharField(max_length=300 ) price = models.IntegerField() I don't know what is happening. It could give me an adress of migration like "0001_init" but is not running. Thank you -
Set Session Variable in Django Rest Framework
How can i set session variable in DRF view(APIView) and get it in other views of my API. when I set session in any views like request.session['name'] = 'SRJ' I can access this in same view but I cant get it in other views files of API. i know request of django and DRF are different but is there a way to do it ? Thanks for any help -
How to store multiple values inside a foreign key field?
I need to add multiple categories to a brand field. Here is the code class Brand_Category(models.Model): """ this model is use to store the data of products category """ name = models.CharField(max_length=50, unique=True, verbose_name="Brand Category Name") slug = models.SlugField(max_length=140, unique=True, blank=True) created_at = models.DateTimeField(auto_now_add=True, null=True, blank=True) class Brand(models.Model): """ This model is use to store the data of products sub category """ user = models.ForeignKey(User, related_name='brand_user', on_delete=models.CASCADE,null=True,blank=True, default=None) name = models.CharField(max_length=50, unique=True, verbose_name="Brand Name") brand_img = models.FileField(verbose_name='Upload Image') category = models.ForeignKey(Brand_Category, related_name='brand_category', on_delete=models.PROTECT, null=True) slug = models.SlugField(max_length=140, unique=True, blank=True) created_at = models.DateTimeField(auto_now_add=True, null=True, blank=True) I have a brand form where I am adding multiple categories. This categories are stored in the brand_category model, and i would like to save the id of multiple categories into one brand field. how can i add that? i have found about onetomany field in django but it seems to have deprecated, and the other soultions are not similar to my problem. However, a cateogry is not strictly related to any brand -
How to validate the password at DB level in django
I'm trying to register a user with a phone and password, I want to find if the user exists and if the password is the same as we have already on our DB then I want the user to get a login instead of giving an error to that the user with same creds already exists. Now the problem I cant validate the password. I'm trying : registered_user = CustomUser.objects.get(phone_number=data['phone_number']) if make_password(data['password']) == registered_user.passwrod: serializer = UserSerializerWithToken(registered_user, many=False) return Response(serializer.data) But I get registered_user has no attribute password How we can fix this? -
ile "manage.py", line 9, in <module> from django.core.management import execute_from_command_line ModuleNotFoundError: No module named 'django'
#!/usr/bin/env python import os import sys if name == "main": os.environ.setdefault("DJANGO_SETTINGS_MODULE", "api.settings") from django.core.management import execute_from_command_line execute_from_command_line(sys.argv) ~ anyone can explane this code. while ı have trying to run this code with "python manage.py makemigrations" its gives an error: enter image description here but all modules in requrement.txt succsessfully loaded before. -
Administration of different databases of an application with django
I understand how to handle several databases through routers, however, how would it be handled when I have two databases with the same structure but it is required to save the information according to the database chosen by the user when starting a session . I have a session login with its corresponding username and password, in addition to that it is mandatory that the user choose a database through a selector to start the session to the application correctly, this information on the name of the selected database is moves through a session cookie for the entire session (forgive the redundancy), all the operations of the application must be done on the database that was initially selected in the access login, how to correctly route the databases for this case? DATABASES = { 'default' : { 'ENGINE': 'django.db.backends.mysql', 'NAME': env.str('NAME_DB_ZF'), 'USER': env.str('USER_DB'), 'PASSWORD': env.str('PASS_DB'), 'HOST': 'localhost', 'PORT': '3306', }, 'SBOJOZF': { 'ENGINE': 'django.db.backends.mysql', 'NAME': env.str('NAME_DB_ZF'), 'USER': env.str('USER_DB'), 'PASSWORD': env.str('PASS_DB'), 'HOST': 'localhost', 'PORT': '3306', }, 'SBOJOCOL': { 'ENGINE': 'django.db.backends.mysql', 'NAME': env.str('NAME_DB_COL'), 'USER': env.str('USER_DB'), 'PASSWORD': env.str('PASS_DB'), 'HOST': 'localhost', 'PORT': '3306', } } -
What is the fastest way to make plain html/css/javascript website work in Django?
I created a game with HTML/CSS/JavaScript (vanilla) and it really works. Now I want to have users of the same game, so when logged in, they can submit the results and see their place on the list. What are the fastest steps I need to do in order to accomplish that? As my first step, I just want this game to work in Django. -
Django throwing UNIQUE Constraint failed even after adding unique = False
I am developing a custom usermodel for my application in django, by using AbstractUser. But I am getting a UNIQUE constraint failed error while using add user + from django admin. I have also tried to add unique = False in the EmailField class User(AbstractUser): id = models.BigAutoField(primary_key=True) rollno = models.CharField(null=True,unique=True,max_length=15) email = models.EmailField(blank=True,null=True,unique=False) Error : .... return Database.Cursor.execute(self, query, params) django.db.utils.IntegrityError: UNIQUE constraint failed: Accounts_user.email [28/Jun/2022 05:54:58] "POST /admin/Accounts/user/add/ HTTP/1.1" 500 233697 The add form does not have a email field, submits a blank email. (PS : I can add user by signup form of my application, change user of django admin is also working.)\ -
Show fields for adding password to custom user model - Django
I have a custom user model. I want the admin to create new accounts from the admin panel. Registering a class doesn't help. admin.site.register(CustomUser) *This has the effect of avoiding the possibility of double-entering the password So I try this solution: from django.contrib.auth.admin import UserAdmin admin.site.register(CustomUser, UserAdmin) *In the above option, I have the option to enter the password twice (whean i create user), but the other fields from my custom user model are disappearing. class CustomUser(AbstractUser): name = models.CharField(max_length=50, blank=True, null=True) surname = models.CharField(max_length=50, blank=True, null=True) account_type = models.ForeignKey(Locationd, on_delete=models.CASCADE, blank=True, null=True How to add the ability to create accounts in the admin panel, giving a password that can be sent to the new user and editing all fields from the custome user class. ) -
I made a form and doesn't save to my database in django
Hey I just started learning django , and i had a problem in registration form , it doesn't save to my database , i've tried a lot of things and none if works for me i don't know where the problem is , and when i try to add it from python shell it worked but not from html i would love to if someone figure it out : models.py: class Register(models.Model): Username = models.CharField(max_length=255) email = models.EmailField(max_length=255) password = models.CharField(max_length=255) con_password = models.CharField(max_length=255) def __str__(self): return ( f"{self.Username}" f"{self.email}" ) views.py : def register(request): if request.method == "POST": form = Register(request.POST) if form.is_valid(): form.save(commit=False) form.save() return redirect('/') #redirect after saving form = Register() return render(request, "register.html", {'form': form}) register.html : {% block content %} <section id="hero" class="login"> <div class="container"> <div class="row justify-content-center"> <div class="col-xl-4 col-lg-5 col-md-6 col-sm-8"> <div id="login"> <div class="text-center"><img src="{% static 'touriste/img/logo_sticky.png' %}" alt="Image" data-retina="true"></div> <form method="post"> {% csrf_token %} {{ form.as_p }} <div class="form-group"> <label for="Username">Username</label> <input type="text" name="Username" class=" form-control" required placeholder="Username"> </div> <div class="form-group"> <label for="email">Email</label> <input type="email" name="email" class=" form-control" required placeholder="Email"> </div> <div class="form-group"> <label>Password</label> <input type="password" name="password" class=" form-control" required id="password" placeholder="Password"> </div> <div class="form-group"> <label>Confirm password</label> <input type="password" name="con_password" class=" … -
Django + Apache2 behind NGINX reverse proxy - redirections going wrong
I have a Django project running on Apache2 with mod_wsgi in a VM - https://systems3.slt.local/ Accessing the VM directly, via https://systems3.slt.local/ works perfectly. However, I need it to work behind an NGINX reverse proxy, and I'm having problems with login redirection. My proxy is configured like this: location /systems3 { proxy_set_header Host $host; proxy_set_header X-Real-IP $remote_addr; proxy_set_header X-Forwarded-For $proxy_add_x_forwarded_for; proxy_set_header X-Forwarded-Proto $scheme; proxy_redirect off; proxy_pass https://systems3.slt.local/; } When I try to access the project through the proxy, https://example.org/systems3 , Django checks that there is no user logged in, and then redirects to https://example.org/**accounts/login**. The correct would be to redirect to https://example.org/**systems3/accounts/login**. Even if I try to directly access this address, I am redirected to https://example.org/accounts/login. It seems that some configuration is missing so that the address https://example.org/systems3 is the root of the project, it shouldn't be redirecting me outside of systems3. It's also giving problem with my static folder, it also looks for the folder at https://example.org/static, ignoring that it was supposed to look inside systems3. -
Convert a basic sql query to django query
I want to display the course name along with the question count in a table. Need help to convert below query to a django query: SELECT DISTINCT exam_course.course_name, COUNT(exam_question.question) FROM exam_course INNER JOIN exam_question ON exam_question.course_id = exam_course.id GROUP BY exam_question.course_id -
How to Properly Display RenderedMarkdownField() on Template when "safe" Isn't "Working"?
On my django website, I'm using a RenderedMarkdownField() to make some fancy looking description text on my posts. My model looks like this: # Portfolio project overview model class Work(models.Model): title = models.CharField(max_length=100) # description = models.TextField() description = MarkdownField(rendered_field='description_rendered', validator=VALIDATOR_STANDARD) description_rendered = RenderedMarkdownField() image = models.ImageField(upload_to="work_app/media/images/", null=True, blank=True) video = models.FileField(upload_to="work_app/media/videos/", null=True, blank=True) pdf = models.FileField(upload_to="work_app/media/documents/", null=True, blank=True) # To show the title in the Admin page def __str__(self): return self.title Then my work_index.html page looks like this when rendering each project from my database (personally identifying/crucial info scratched out): As you can see, the Markdown characters in the description text (the *'s) are visible in this description. To fix this, we use Django's safe tag and render the work.description_rendered field instead, so my code when iterating through each post looks like this: <div class="row"> {% for work in works %} <div class="col-md-4"> <div class="card mb-2"> <a href="{% url 'work_detail' work.pk %}"> <img class="card-img-top" src="{{ work.image.url }}"> </a> <div class="card-body"> <a href="{% url 'work_detail' work.pk %}"> <h5 class="card-title project-title-link">{{ work.title }}</h5> </a> <p class="card-text">{{ work.description_rendered | safe | truncatechars:200 }}</p> <a href="{% url 'work_detail' work.pk %}" class="btn btn-primary"> Read More </a> </div> </div> </div> {% endfor %} </div> ...HOWEVER, … -
Django: Accessing reusable app in settings.py
I have a reusable django app installed in my project, and the desired outcome is to import it into the main project's settings.py. The project runs well with the reusable app installed and added into INSTALLED APPS in settings.py. However, when I try to import it in settings.py, django throws an error. django.core.exceptions.AppRegistryNotReady: Apps aren't loaded yet. I think it has something to do with Django not loading the reusable app in time before the imports, but I'm not sure how to solve this. Any suggestions are much appreciated! -
part a custom user model into two apps, but custom user model app override the 2nd app
I have searched a lot to any related to my problem but never found what i need I am trying to create a simple Django blog that has a custom user model inherit the core authentication AbstractUser class in app named user user.models.py class User(AbstractUser): email = models.EmailField('email_address', unique=True) USERNAME_FIELD = 'email' and another account app that has been parted the login and profiles of authenticated users account.models.py class Profile(models.Model): user = models.OneToOneField(settings.AUTH_USER_MODEL, related_name='profile_user', on_delete=models.CASCADE) the settings.AUTH_USER_MODEL above is the same User that already been imported from user app user.models import User and already been identified in settings.py When i started to makemigrations and migrate i found no problems, but when i went to my PostgreSQL pgAdmin to see database tables i fount all tables except the account_profile table although there are another class in account i found it's table but no Profile as it never been created Also when i tried to create superuser, i got the same notation that : psycopg2.errors.UndefinedTable: relation "account_profile" does not exist LINE 1: INSERT INTO "account_profile" ("user_id", "city_id", "phone... should i have to put the Profile class in account.models.py in user.models.py together or what exactly should i do, please help and sorry for …
