Check if item exists in database by field value

user_14534550 0
Viewed 454

I have a class called Product and I want to check if there is already a product in the database with the same title.

class Product(models.Model):
  title = models.CharField(max_length=255)
  ...


for (something in something):
  check if db contains product with a title of 'Some Product'
django-views django-models django
1 Answers

You can work with .exists() [Django-doc]:

Product.objects.filter(title='Some Product').exists()

It might however be better to enforce uniqness at the database level, with unique=True [Django-doc]:

class Product(models.Model):
    title = models.CharField(max_length=255, unique=True)

then if the database enforces (most databases do), it will simply be impossible to create a new Product with the same title.

You can also obtain a Product, or create it if it does not yet exists, with .get_or_create(…) [Django-doc]:

my_prod, created = Product.objects.get_or_create(title='Some Product')
user_675790
Related