Guest User

Untitled

a guest
Nov 23rd, 2017
66
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.71 KB | None | 0 0
  1. db.events.find({'end': {'$gte': datetime.utcnow() - timedelta(days=3)})
  2.  
  3. db.events.aggregate([
  4. { '$match':
  5. { 'end':
  6. { '$gte': datetime.utcnow() - timedelta(days=3) }
  7. }
  8. },
  9. { '$project':
  10. {
  11. 'timeDelta': {
  12. '$subtract': ['$end', datetime.utcnow()]
  13. }
  14. }
  15. },
  16. { '$project':
  17. {
  18. 'absTimeDelta' : {
  19. '$cond' : [
  20. { '$lte': ['$timeDelta', 0] },
  21. { '$multiply' : ['$timeDelta', -1 ] },
  22. '$timeDelta'
  23. ]
  24. }
  25. }
  26. },
  27. { '$sort':
  28. {
  29. 'absTimeDelta' : 1
  30. }
  31. }
  32. ])
Add Comment
Please, Sign In to add comment