Advertisement
Guest User

Untitled

a guest
Dec 4th, 2016
81
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.11 KB | None | 0 0
  1. class Ingredient(models.Model):
  2. name = models.CharField(max_length=20,
  3. blank=False,
  4. null=False)
  5.  
  6. class IngredientHistory(models.Model):
  7. ingredient = models.ForeignKey(Ingredient,
  8. blank=False,
  9. null=False)
  10. product = models.ForeignKey('Product',
  11. blank=False,
  12. null=False)
  13. date = models.DateField(auto_now_add=True)
  14. quantity = models.PositiveIntegerField(blank=False, default=1)
  15.  
  16. class Product(models.Model):
  17. ingredients = models.ManyToManyField(Ingredient,
  18. through=IngredientHistory,
  19. through_fields=('product', 'ingredient'),
  20. related_name='products')
  21.  
  22. p = Product.objects.get(pk=1)
  23. q = p.ingredients.all().values('id').annotate(max_date='ingredienthistory__date')
  24. for i in q:
  25. ingredient = p.ingredients.all().filter(id=i.id, ingredienthistory__date=i.second)
  26. # do something with ingredient
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement