Advertisement
Guest User

Untitled

a guest
Feb 19th, 2019
60
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.81 KB | None | 0 0
  1. from django.db import models
  2. from django.contrib.postgres.fields import JSONField
  3.  
  4. class Animal(models.Model):
  5. data = models.JSONField(verbose_name=_('data'), blank=True)
  6.  
  7. class Sell(models.Model):
  8. count = models.IntegerField(verbose_name=_('data'), blank=True)
  9. animal = models.ForeignKey('Animal',
  10. on_delete=models.CASCADE,
  11. related_name="sales_set",
  12. related_query_name="sold"
  13. )
  14.  
  15. animal = Animal(data={'type':'dog', 'bread':'Husky', 'count':20})
  16.  
  17. Animal.objects.annotate(animals_sold=Sum('sales_set__count'))
  18. .filter(data__contains=[{'count__gt': F('animals_sold')}])
  19.  
  20. Animal.objects.annotate(animals_sold=Sum('sales_set__count'))
  21. .filter(data__contains=[{'count__gt': F('animals_sold')}])
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement