Django SELECT Query

Question

Hi Iam try to select from mysql using Django my models.py

from django.db import models
from django.db.models import Q

class Series(models.Model):
    id = models.IntegerField(primary_key=True)
    title = models.CharField(max_length=255)
    des  = models.CharField(max_length=255)
    img   = models.CharField(max_length=255)
    isseries  = models.IntegerField()
    istrend   = models.CharField(max_length=255)
    background_img = models.CharField(max_length=255)
    trial_url = models.CharField(max_length=255)
    imdb_id   = models.CharField(max_length=255)
    rate    = models.CharField(max_length=255)
    date = models.CharField(max_length=255)
    status    = models.IntegerField()
    isdel      = models.IntegerField()
    section_id  = models.IntegerField()
    poster_img   = models.CharField(max_length=255)
    genres       = models.CharField(max_length=255)
    class Meta:
        db_table = 'series'

my sample Script

series = series_db.objects.filter(istrend=1,status=1,isdel=0).order_by('id').values()

i Want to SELECT all Column without isdel so i remove isdel from models.py, but when i remove it i cant use isdel to make WHERE isdel = 0 in mysql so i got This Error

django.core.exceptions.FieldError: Cannot resolve keyword 'isdel' into field.

so how i can use isdel to make a condition without select it LIKE this Example

SELECT `series`.`id`, `series`.`title`, `series`.`des`, `series`.`img`, `series`.`isseries`, `series`.`istrend`, `series`.`background_img`, `series`.`trial_url`, `series`.`imdb_id`, `series`.`rate`, `series`.`date`, `series`.`status`, `series`.`section_id`, `series`.`poster_img`, `series`.`genres` FROM `series` WHERE (`series`.`isdel` = 0 AND `series`.`istrend` = '1' AND `series`.`status` = 1) ORDER BY `series`.`id` ASC

real Example

SELECT `series`.`id`, `series`.`title`, `series`.`des`, `series`.`img`, `series`.`isseries`, `series`.`istrend`, `series`.`background_img`, `series`.`trial_url`, `series`.`imdb_id`, `series`.`rate`, `series`.`date`, `series`.`status`, `series`.`isdel`, `series`.`section_id`, `series`.`poster_img`, `series`.`genres` FROM `series` WHERE (`series`.`isdel` = 0 AND `series`.`istrend` = '1' AND `series`.`status` = 1) ORDER BY `series`.`id` ASC

You can get the result by using a combination of Q objects and the .exclude() method — Hasan Raza, Aug 10 '23 at 09:14
It seems that you removed `isdel` from the `Series` model? Why do you use `series_db`? — Willem Van Onsem, Aug 10 '23 at 10:55

Ahtisham · Accepted Answer · 2023-08-10T09:52:04.500

You don't have to remove the field in model just mention the column you want to retrive in values like this:

series = Series.objects.filter(
     istrend=1,status=1,isdel=0
).order_by('id').values('id', 'title', 'des')

I have added just three columns in values you can add all the columns except the one you don't want.

If your model has lot of field and you find it hard to add them manually one by one then you can get all the fields of the model using _meta and exclude the given field like this:

fields = [field.name for field in Series._meta.fields if field.name != 'isdel']
series = Series.objects.filter(
   istrend=1,status=1,isdel=0
).order_by('id').values(*fields)

score 2 · Answer 2 · answered Aug 10 '23 at 09:29

2

You can use values So your query would be modified to:

series = series_db.objects.filter(istrend=1,status=1,isdel=0).order_by('id').values("id")

answered Aug 10 '23 at 09:29

Rushikesh Sutar

71
4

score 1 · Answer 3 · answered Aug 10 '23 at 09:07

It seems like you're encountering an issue because you've removed the isdel field from your Series model, but you still want to use it in your filtering conditions.

Here's how you can modify your sample script to achieve your desired query:

from django.db.models import Q

series = Series.objects.filter(
    Q(istrend=1) & Q(status=1)
).extra(where=["`series`.`isdel` = 0"]).order_by('id').values()

In this modified script, I'm using the extra method to add a custom where condition to your query, specifying the condition for isdel without having it as a field in the model. The rest of your filtering conditions remain the same.

Django SELECT Query

3 Answers3