Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- class Ingredient(models.Model):
- name = models.CharField(max_length=20,
- blank=False,
- null=False)
- class IngredientHistory(models.Model):
- ingredient = models.ForeignKey(Ingredient,
- blank=False,
- null=False)
- product = models.ForeignKey('Product',
- blank=False,
- null=False)
- date = models.DateField(auto_now_add=True)
- quantity = models.PositiveIntegerField(blank=False, default=1)
- class Product(models.Model):
- ingredients = models.ManyToManyField(Ingredient,
- through=IngredientHistory,
- through_fields=('product', 'ingredient'),
- related_name='products')
- p = Product.objects.get(pk=1)
- q = p.ingredients.all().values('id').annotate(max_date='ingredienthistory__date')
- for i in q:
- ingredient = p.ingredients.all().filter(id=i.id, ingredienthistory__date=i.second)
- # do something with ingredient
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement