Django community: RSS
This page, updated regularly, aggregates Django Q&A from the Django community.
-
django many to many through forms
I have a many to many relationship, with an intermediate table with extra fields. I want to create a form that allows me to enter a product, and to be able to choose a price for 1 or more markets. I can't figure out the views to create this form and print it in a template. Can you help me? How the form should look like: Relation: Models: class Market(models.Model): name = models.CharField(max_length=100) class Product(models.Model): name = models.CharField(max_length=250) market = models.ManyToManyField(Market, through='Link') class Link(models.Model): product = models.ForeignKey(Product, on_delete=models.CASCADE) market = models.ForeignKey(Market, on_delete=models.CASCADE) link = models.CharField(max_length=250) class Meta: unique_together = [['producto', 'supermercado']] Forms: class MarketForm(ModelForm): class Meta: fields = ['name'] model = Market class ProductForm(ModelForm): class Meta: fields = ['name'] model = Product class LinkForm(ModelForm): class Meta: fields = ['market','product','link'] model = Link -
Static files not appearing when going live django project
I have the correct settings to get static files live, but no static files work even though I do collectstatic My Settings.py: `STATIC_URL = '/static/' MEDIA_URL = '/media/' STATIC_ROOT = os.path.join(BASE_DIR,'staticfiles/') MEDIA_ROOT = os.path.join(BASE_DIR,'media/')` Debug is False -
django.db.utils.OperationalError: (1074, "Column length too big for column 'audio_file' (max = 16383); use BLOB or TEXT instead")
when I do python manage.py makemigrations it take the change but when I do python manage.py migrate it throw error django.db.utils.OperationalError: (1074, "Column length too big for column 'audio_file' (max = 16383); use BLOB or TEXT instead") I have models.py where my audio_file field is class RadioFile(models.Model): audio_file = models.FileField( upload_to='radio/', validators=[validate_file_extension], max_length=200, help_text="Only wav,mp1,mp2,mp3,m4p,.m5p,wma,pdf and voc files are allowed.", ) I tried to remove max_length completely from audio_file field,it is still giving me this error. I check in other models.py , I don't have max_length set to max = 16383 anywhere neither field name audio_file. from where this error is coming? -
How to make a form field required only if another field is filled and vice versa in Django?
I made the following form in Django. class SearchTimeSlotsForm(forms.Form): available_from = forms.TimeField(widget=TimeInput()) available_till = forms.TimeField(widget=TimeInput()) In the above form the user can either fill both the fields or may not fill any field but he cannot fill only one field. How can I implement this? -
Django server Google Id_token verification using google.oauth2.id_token.verify_oauth2_token() not working
I'm trying to build a flutter app with django backend and need to implement google authentication as well. After receiving the Id_token from google, I send it to my django server. Whilst trying to verify google Id_token from my django server using google.oauth2.id_token.verify_oauth2_token(), it's always showing bad request. I'm passing id_token, requsts.Request() and Client_id of my flutter fronted app as the arguments. Is there any problem with the arguments passed? Is there anything I should do related to google, like creating an Oauth id for my backend server, or something like that.? I tried the solution given here but still not working. -
Run external application using Django
I am creating a django backend. In it I want to run an external Python application I wrote, when someone clicks a button. My project is distributed as follows: external_application_folder main_django_project_folder django_app_folder The way I am currently doing it is, I have created a html file which has a form in it <!DOCTYPE html> <html> <head> <title> ABM TRY </title> </head> <body> <form method="POST">{% csrf_token %} <button type="submit" name="run_external_code"> Run</button> </form> </body> </html> Inside the django_app's views.py I have from external_application_folder.run import external_function def ex_view(request): if request.method=='POST' and 'run_external_code' in request.POST: external_function() return render(request,"html_file.html",{}) whenever I run python manage.py runserver I get the following Watching for file changes with StatReloader Performing system checks... and then everything works. I am new to django, is this the best way to run external application using backend? -
Create a relation without a foreign key
How can I create a "belongs to" relationship in Django without creating a foreign key on the DB layer? -
EC2 .bashrc and .bash_profile re-setting
Reason I'm asking: pycurl requires both libcurl-devel and openssl-devel. To install these, I have these two lines the my .bash_profile: sudo yum install libcurl-devel sudo yum install -y openssl-devel Previously, I just ran those commands in the terminal while ssh'd into the EC2 instance. However, it seems that at random times those lines are cleared from the .bashrc and .bashprofile, and the packages no longer exist in the instance. Why is this happening? Is the EC2 instance refreshing to a clean version at some point? If so, why? And how can I ensure those two packages are default installed on every instance? When I eb deploy I still see the .bashrc and .bash_profile contain the yum install commands. The timing the files are refreshed seems random, and I can't figure out why. -
django many to many through forms
tengo una relación muchos a muchos, con una tabla intermedia con campos extra. Quiero crear un formulario que me permita ingresar un producto, y poder elegir un precio para 1 o más mercados. No logro resolver las views, para crear este formulario e imprimirlo en un template. Podrán ayudarme? Como debería quedar el formulario: Relación: Modelos: class Market(models.Model): name = models.CharField(max_length=100) class Product(models.Model): name = models.CharField(max_length=250) market = models.ManyToManyField(Market, through='Link') class Link(models.Model): product = models.ForeignKey(Product, on_delete=models.CASCADE) market = models.ForeignKey(Market, on_delete=models.CASCADE) link = models.CharField(max_length=250) class Meta: unique_together = [['producto', 'supermercado']] Formularios: class MarketForm(ModelForm): class Meta: fields = ['name'] model = Market class ProductForm(ModelForm): class Meta: fields = ['name'] model = Product class LinkForm(ModelForm): class Meta: fields = ['market','product','link'] model = Link -
Django App on Elastic Beanstalk not Inserting to Specific Model in Deployed Version (works locally)
I have a Django web application that is hosted on AWS Elastic Beanstalk, with a PostgreSQL database on AWS RDS. I have a strange issue where data updates in the UI are inserted to the model locally, but not in the deployed version. Additionally, it's only for one specific model. The other models take UI inputs fine in the deployment. Again, this works perfectly locally, but not when deployed to Elastic Beanstalk. The weird part is that the other models in the application work fine in both local and deployed versions. Since it works locally, and only one model is impacted I don't necessarily know what code would be beneficial to post, and don't want to flood the post with unecessary code but I will be happy to provide relevant code. Any help would be greatly appreciated! I have reviewed the RDS logs, the Elastic Beanstalk logs, and access the EB instance using eb ssh to review additional logs there but find no indication of an error occurring. -
How to restart or reload Django when using it with gunicorn and nginx
I am new to Stackoverflow so i am sorry if i am a little bit of course I recently started to learn Django i am a noob at it still , i just installed django with gunicorn and nginx on a Ubuntu 20 server, and now i am configuring my server but i cant find how to reload or restart Django , any help? I added my domain to allowed_host and saved the file and its not reloading the config i needed to restart the server to reload and then i needed to go back into the venv stop nginx start gunicorn and start nginx again to work , i cant be doing this at evry change i make , and at this topic any ideea how can i make gunicorn start with nginx corectly? -
Django Simple History: Don't want to track User
I'm working on a Django project, and I'd like to use Django Simple History to track changes to records. However, I'm facing an issue: I don't want to track the user who made the change (I'm not using Django's auth app). When I try to perform the migrations, I receive this error message: SystemCheckError: System check identified some issues: ERRORS: my_app.HistoricalModel.history_user: (fields.E300) Field defines a relation with model 'auth.User', which is either not installed, or is abstract. data_lake.HistoricalInstance.history_user: (fields.E307) The field my_app.HistoricalInstance.history_user was declared with a lazy reference to 'auth.user', but app 'auth' isn't installed. Is there a way to use the HistoricalRecords model disabling references to user model? -
FactoryBoy factory that does NOT generate an 'id' for an unmanaged Django model?
I've got a factory that I need to just generate the data I want it to - without having it create an 'id' attribute. I have a couple factories that look like this: class RatedPersonalityFactory(PersonalityFactory): person__end_year = get_end_year() rating_information__create_rating = False rating_information__section = None class Params: pass @post_generation def person(obj, create, extracted, **kwargs): PersonFactory( personality=obj, personality_id=obj.id, state_id=1234, first_name=obj.identity.first_name, last_name=obj.identity.last_name, middle_name=obj.identity.middle_name, birth_date=obj.identity.birth_date, number=obj.student_number, end_year=kwargs["end_year"], ) class PersonFactory(DjangoModelFactory): class Meta: model = Person database = "alternatives" django_get_or_create = ("personality_id",) class Params: # This will create the Personality that we can then use attributes from personality = SubFactory(PersonalityFactory) current_end_year = get_end_year() personality_id = SelfAttribute("personality.id") state_id = 1234 first_name = Faker("first_name") last_name = Faker("last_name") middle_name = Faker("first_name") number = SelfAttribute("person.student_number") active_year = 1 birth_date = Faker( "date_between", start_date=(datetime.now() - relativedelta(years=14)).date(), end_date=datetime.now().date(), ) start_date = Faker( "date_time_between", start_date="-1y", end_date="now", tzinfo=py_timezone(settings.TIME_ZONE), ) end_date = None end_year = LazyFunction(get_end_year) gender = Iterator(["M", "F"]) native_lang = "EN" The model looks like this: class Person(models.Model): personality_id = models.IntegerField(db_column="personalityID") state_id = models.IntegerField(db_column="stateID") first_name = models.CharField(db_column="firstName", max_length=35) last_name = models.CharField(db_column="lastName", max_length=40) middle_name = models.CharField(db_column="middleName", max_length=30) number = models.IntegerField(db_column="studentNumber") active_year = models.IntegerField(db_column="activeYear") birth_date = models.DateField(db_column="BirthDate") start_date = models.DateField(db_column="startDate") end_date = models.DateField(db_column="endDate", null=True) end_year = models.IntegerField(db_column="endYear") gender = models.CharField(db_column="gender", max_length=1) native_lang = models.CharField(db_column="languageAlt", … -
How to get a queryset of foreign keys from a current queryset in django
I have two models, Employee and Manager. The Employee model has a foreign key to Manager. Given an arbitrary queryset qs of Employee objects, I would like to get a queryset of their managers. This seems very simple but I can't find a way to do it. In naive python, I could get a list of these managers by doing something like: qs = Employee.objects.filter(whatever) managerlist = [] for emp in qs: managerlist.append(emp.manager) and this would give me a list of managers corresponding to employees in my queryset. But instead of a list I would like a queryset. Is there a quick simple way to do this? -
I have performance issue with apex charts
I have 3 async charts on one page and total number of data on the page is about 15k, but the chart is lagging a lot. Data is from the backend I use Django templates to iterate over specific data and add that data to the chart. First chart: var options = { series: [{ name: 'Fed Fund Rate', data: [ {% for int in interest %} { x: "{{int.interest_date}}", y: ["{{int.strategy_interest}}"], }, {% endfor %} ] }, ], chart: { id: 'chart_1', group: 'social', height: 300, type: 'line',`your text` animations: { enabled: false }, zoom: { type: 'xy' }, }, dataLabels: { enabled: false }, yaxis: { type: 'numeric', }, xaxis: { type: 'datetime', }, }; var chart = new ApexCharts(document.querySelector("#chart-int"), options); chart.render(); Second: var options = { series: [{ name: 'OHLC', data: [ {% for stock in stocks %} { x: "{{stock.date}}", y: ["{{stock.open|floatformat}}", "{{stock.high|floatformat}}", "{{stock.low|floatformat}}", "{{stock.price|floatformat}}"], }, {% endfor %} ] }, ], chart: { height: '100%', id: 'chart_2', group: 'social', type: 'candlestick', animations: { enabled: false }, }, dataLabels: { enabled: false }, title: { text: '{{ticker}}', align: 'center', style: { fontSize: '24px', fontFamily: 'calibri' } }, yaxis: { type: 'numeric', }, xaxis: { type: 'datetime', … -
Setup an email notification when consumer: Connection to broker lost in celery
I want to implement an email system which will send an email whenever my celery worker lost connection with my Redis server. Whenever it lost connection it gives warning: [2023-03-02 21:33:48,272: WARNING/MainProcess] consumer: Connection to broker lost. Trying to re-establish the connection... And starts reconnecting with the server [2023-03-02 21:33:48,286: ERROR/MainProcess] consumer: Cannot connect to redis://127.0.0.1:6379//: Error 61 connecting to 127.0.0.1:6379. Connection refused.. Trying again in 2.00 seconds... (1/100) I am using django 3.2.8 and celery 5.2.7. I went through the whole celery docs and source code I get to know there is a method on_connection_error_after_connected in the celery.worker.consumer.connection which get's triggered when it lost connection. -
Data not rendering in Cytoscape.js in the Django template
I am trying to display the data in the Django template in the form of graph. I am getting the data from Neo4J and for querying I am using neomodel. First I am serializing the data in the form of JSON accepted my Cytoscape.js. This is my template <!DOCTYPE html> <html lang="en"> <head> <meta charset="UTF-8"> <title>Graph View</title> <!-- <script src="https://cdnjs.cloudflare.com/ajax/libs/cytoscape/3.23.0/cytoscape.min.js" integrity="sha512-gEWKnYYa1/1c3jOuT9PR7NxiVI1bwn02DeJGsl+lMVQ1fWMNvtjkjxIApTdbJ/wcDjQmbf+McWahXwipdC9bGA==" crossorigin="anonymous" referrerpolicy="no-referrer"></script>--> <script src="https://cdnjs.cloudflare.com/ajax/libs/cytoscape/3.8.4/cytoscape.min.js" integrity="sha512-gn5PcEn1Y2LfoL8jnUhJtarbIPjFmPzDMljQbnYRxE8IP0y5opHE1nH/83YOuiWexnwftmGlx6i2aeJUdHO49A==" crossorigin="anonymous" referrerpolicy="no-referrer"></script> <style> #cy { width: 300px; height: 250px; display: block; background-color: #fff; } </style> </head> <body> {{data}} <div id="cy"></div> <div id="test"></div> <h2>Hello</h2> <script> var my_graph_data = JSON.parse('{{ data|escapejs }}'); var cy = cytoscape({ container: document.getElementById('cy'), elements: '{{data}}', style: [ { selector: 'node', style: { 'label': 'data(label)', 'width': '60px', 'height': '60px', 'color': 'blue', 'background-fit': 'contain', 'background-clip': 'none' } }, { selector: 'edge', style: { 'text-background-color': 'yellow', 'text-background-opacity': 0.4, 'width': '6px', 'target-arrow-shape': 'triangle', 'control-point-step-size': '140px' } } ], layout: { name: 'circle' } }); </script> </body> </html> This is the format of my data when I print my json [{'data': {'movieName': 'Matrix', 'director': 'John', 'rating': 9.0}}, {'data': {'movieName': 'John Wick', 'director': 'Bill', 'rating': 8.0}}] When I try the different data with same format I get the graph [ { 'data': { id: 'a', name: 'Sheraton … -
Running django migration gives "Wait for backup lock" in mysql
I am trying to run a django migration that creates 3 models and deletes 1 model with 350k rows. However, after running the migration, my mysql database is waiting for backup lock. <id> <admin> <ip>:<port> database_test Query Waiting for backup lock CREATE TABLE `table` (`id` bigint AUTO_INCREMENT NOT NULL PRIMARY KEY, `column1` double precision NOT NULL, `column2` bigint NULL, `column3` bigint NULL) How can I resolve waiting for backup lock and what does it mean? -
{% if {club.c_type} == 'Tech' %} is giving error Code is working perfectly without it. Want to filter data on basis or Tech and Non Tech in same Page
{% for club in clubs %} {% if {club.c_type} == 'Tech' %} SOME CODE {% endif %} {% endfor %} def clubs(request): clubs_data = Clubs.objects.all() return render(request, 'clubs.html', {'clubs': clubs_data}) CLUBS_TYPE = {('T', 'Tech'), ('NT', 'Non-Tech')} class Clubs(models.Model): club_id = models.CharField(primary_key= True, max_length=5) c_name = models.CharField(max_length=50) c_logo = models.ImageField(upload_to='clubimg') c_type = models.CharField(choices=CLUBS_TYPE, max_length=2) -
I want to run "python manage.py makemigrations ". Got error "password authentication failed""No changes detected"
I want to run: (venv) ubuntu@ip-172-31-44-136:~/easy_django_repo$ python manage.py makemigrations And got this error: /home/ubuntu/venv/lib/python3.10/site-packages/django/core/management/commands/makemigrations.py:143: RuntimeWarning: Got an error checking a consistent migration history performed for database connection 'default': connection to server at "localhost" (127.0.0.1), port 5432 failed: FATAL: password authentication failed for user "diEvaR6s52EqJv" connection to server at "localhost" (127.0.0.1), port 5432 failed: FATAL: password authentication failed for user "diEvaR6s52EqJv" warnings.warn( No changes detected I changed password for user and os: (venv) ubuntu@ip-172-31-44-136:~/easy_django_repo$ sudo -u postgres psql Password for user postgres: psql (14.6 (Ubuntu 14.6-0ubuntu0.22.04.1)) Type "help" for help. postgres=#ALTER USER diEvaR6s52EqJv WITH PASSWORD '#####'; (venv) ubuntu@ip-172-31-44-136:~$ sudo passwd postgres New password: And I ran: (venv) ubuntu@ip-172-31-44-136:/etc/postgresql/14/main$ sudo -u postgres psql Password for user postgres: (venv) ubuntu@ip-172-31-44-136:/etc/postgresql/14/main$ psql -U postgres Password for user postgres: Got error: psql: error: connection to server on socket "/var/run/postgresql/.s.PGSQL.5432" failed: FATAL: password authentication failed for user "postgres" I can't understand what do I have to do. Can anyone give me some advice? Almost struggling for a week. -
Django logging - logger from a module?
According to documentation I have to specify the LOGGING variable in settings.py Is it possible to pass logger from my custom module in django instead? For example, I have a following module: import logging import os class CustomFormatter(logging.Formatter): grey = "\x1b[38;20m" blue = "\x1b[1;34m" yellow = "\x1b[33;20m" red = "\x1b[31;20m" bold_red = "\x1b[31;1m" reset = "\x1b[0m" logging_message_format = "\n%(asctime)s - (%(filename)s:%(lineno)d) - %(name)s - %(levelname)s - %(message)s" FORMATS = { logging.DEBUG: blue + logging_message_format + reset, logging.INFO: grey + logging_message_format + reset, logging.WARNING: yellow + logging_message_format + reset, logging.ERROR: red + logging_message_format + reset, logging.CRITICAL: bold_red + logging_message_format + reset } def format(self, record): log_fmt = self.FORMATS.get(record.levelno) formatter = logging.Formatter(log_fmt) return formatter.format(record) LOGGING_LEVEL = os.environ.get('LOGGING_LEVEL', 'INFO').upper() logger = logging.getLogger("api") logger.setLevel(LOGGING_LEVEL) ch = logging.StreamHandler() ch.setLevel(LOGGING_LEVEL) ch.setFormatter(CustomFormatter()) # Set to False if too much output in container logger.propagate = True logger.addHandler(ch) I'm using it for logging in tests, as well as database and intending to use the same module for celery logging (probably modifying it a little bit). Is it possible to re-use the module for Django's runserver logging as well? -
Django built-in template tag to convert UTC to datetime?
Is there any way to convert a UTC, defined with models.CharField, to datetime using a built-in filter template tag? Or must i use a custom function (see below)? I have found nothing on this specific topic online. Here is an example Inside models.py: ... boarding_time_utc = models.CharField(max_length=15, default="14:00") ... def show_boarding_time(self): date_time = datetime.fromtimestamp(int(self.boarding_time_utc)) reable_date_time = date_time.strftime('%H:%M') return str(reable_date_time) Inside example.html: <td>{{ entry.show_boarding_time}}</td> Thats pretty much it. Thanks in advance! -
What are some ways to display images on server for a Django project? I keep getting 404 errors
A current miniproject that I am working on is a personal cocktail "cookbook" website, where I display different drinks, their recipes, my personal notes, images, etc. I configured the code in that when someone clicks on one of the many drinks that are displayed under a base alcohol category, they will be navigated to that one specific drink and be shown its attributes. The only thing that I haven't been able to do is having the server correctly display the image associated with the drink. Whenever I run the server and click on a specific drink, that entries' contents are shown in the correct format, but the image only appears as an icon and the server console keeps giving a 404 not found error. On Django admin, I am able to save images whenever I create a new entry, and VScode shows the correct location as to where the images are stored. I made sure that libraries like Pillow and Whitenoise have been downloaded. I also checked the MEDIA and STATIC section of my settings.py file to check the path configuration of where the images can be stored and served. But, so far, the server keeps giving a 404 error … -
phonenumber field authentication error in django
i am making a login function in django where user will input their phone number and password, they can access the account. but when i run the server, i get error that invalid phone number and password, but i registered proper phone number and password. I did some troubleshooting and come to know that phone number data is not showing. here's my code models.py from django.db import models from django.contrib.auth.models import AbstractBaseUser, PermissionsMixin from phonenumber_field.modelfields import PhoneNumberField from .manager import MyUserManager # Create your models here. class MyUser(AbstractBaseUser, PermissionsMixin): username= models.CharField(max_length=50, null=True) phone_number = PhoneNumberField(unique=True) first_name = models.CharField(max_length=30, blank=True) last_name = models.CharField(max_length=30, blank=True) email = models.EmailField(unique=True) is_active = models.BooleanField(default=True) is_staff = models.BooleanField(default=False) is_superuser = models.BooleanField(default=False) USERNAME_FIELD = 'phone_number' REQUIRED_FIELDS = [] objects = MyUserManager() def __str__(self): return self.phone_number.as_e164 def has_perm(self, perm, obj=None): return True def has_module_perms(self, app_label): return True forms.py from django import forms from django.contrib.auth.forms import AuthenticationForm from phonenumber_field.formfields import PhoneNumberField from .models import * class MyLoginForm(AuthenticationForm): phone = PhoneNumberField() password = forms.CharField(label='Password', widget=forms.PasswordInput) views.py from django.contrib.auth import authenticate, login, logout from django.shortcuts import render, redirect from .forms import MyLoginForm # Create your views here. def my_login(request): if request.method == 'POST': form = MyLoginForm(request, request.POST) if form.is_valid(): phone_number = … -
Choosing a right size for e-commerce platform images (grid-item, item, full-size item?)
I'm now a bit lost and can't find the right way or the best practice of choosing the right size of the image. I know that the image sizes should be optimal and not too big or small. So I've read and found that optimal size should be 800x800? So let's start with the things that I will be using in the front-end. So first of all I will have a grid in which I will display from 1 to 4 items in a row. The grid item has a max-width:574px; max-height:409px;. Let's continue to the main item page. I wish to display a slider in which the image should be centered and not full-width. Two things here, I don't really know what the wrapper should look like. This image has 700x109 but it does stretch to fill all the width, I would love to prevent it from happening. Another question is how should I process user uploaded images? Should I prevent users from uploading images that are smaller than 800x800 or something? How should I resize them, what resolutions should I save in our server? This is the grid-item with the visible size: f
