My purpose is to gain averages of values stored in child-tables depending on each parent-table. In my case, I want to gain averages of satisfaction stored in the Evaluation model (child) depending on each Professor model (parent). models.py class Professor(models.Model):…
I am trying to update a record in Database using Django but it adds the same record again. How i can fix it? code is given below. def update(request, id): book = tblbook.objects.get(id=id) form = tblbook(BookID = book.BookID, BookName=book.BookName, Genre=book.Genre,Price=book.Price)…
Imagine we have a table like this: id name type created_at 1 James male 2022-03-02 2 Jane female 2022-04-02 3 Kirk male 2022-03-04 4 Sarah female 2022-04-04 5 Jason male 2022-03-05 And i want to group by type and just…
Context of the problem - I want to migrate from the SQLite database to Postgres. When I makemigrations with Postgres settings which are passed to the settings file with environment variables, I get KeyError; however, another variable from the same…
I store all my secrets and database params in the dev.env file. I have 3 different settings files - base, dev and prod. There is an SQLite database in base, and I want to connect to Postgres in dev. So…
I have a Django project. I use nginx + gunicorn. The views.py file has a combined_data() function that creates and returns an HTML page. As you can see, I am passing the objects in 'rows' and the current date in…
I have a project with Django, Django REST Framework and PostgreSQL. And my goal to make a search with certain conditions: logical operators (AND, OR, NOT) case insensitive operator like * To search by prefixes. som* -> search for some,…
I'm quite new to Django. I'm building a Django app and want to deploy it to Heroku with Postgres database. I already installed a Postgres app on Heroku, and have my credentials. Should I have two databases - one Postgres…
In Django, I'm trying to use dt in cursor.execute() to get the tables in PostgreSQL as shown below: # "views.py" from django.http import HttpResponse from django.db import connection def test(request): cursor = connection.cursor() cursor.execute('''dt''') # Here row = cursor.fetchone() print(row)…
I am working on Django and I need to filter records eg: table: Person name age David Abraham Benj 18 so, if I run this, Person.objects.filter(name__icontains="David Abraham") it is working but if I run this, Person.objects.filter(name__icontains="David Benj") it is not…