Guest User

Untitled

a guest
Nov 16th, 2018
120
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.47 KB | None | 0 0
  1. class Book(Model):
  2. released_at=DateTimeField()
  3.  
  4. class BookPrice(Model):
  5. price = DecimalField()
  6. created_at = DateTimeField()
  7.  
  8. books = Book.objects.annotate(
  9. old_price=Subquery(BookPrice.objects.filter(
  10. created_at__lt=OuterRef('released_at')
  11. )
  12. .order_by('created_at')
  13. .last()
  14. .price
  15. )
  16. )
Add Comment
Please, Sign In to add comment