Skip to content

Latest commit

 

History

History
89 lines (82 loc) · 1.18 KB

pipeline.md

File metadata and controls

89 lines (82 loc) · 1.18 KB
Raw

pipeline

[{$lookup: {
 from: 'events',
 localField: 'id',
 foreignField: 'user_id',
 as: 'event'
}}, {$unwind: '$event'}, {$match: {
 'event.event_id': 1
}}, {$project: {
 _id: 0,
 name: 1,
 username: 1,
 'event.event_id': 1,
 'event.user_id': 1,
 'event.point': 1
}}, {$group: {
 _id: '$name',
 star: {
  $sum: '$event.event_id'
 },
 point: {
  $sum: '$event.point'
 },
 total: {
  $sum: 1
 }
}}, {$sort: {
 point: 1
}}]
[{$lookup: {
 from: 'events',
 localField: 'id',
 foreignField: 'user_id',
 as: 'event'
}}, {$unwind: '$event'}, {$match: {
 'event.event_id': 1
}}, {$match: {
 'event.stars': false
}}, {$project: {
 _id: 0,
 name: 1,
 username: 1,
 'event.event_id': 1,
 'event.user_id': 1,
 'event.point': 1,
 'event.twitter': 1,
 'event.created_at': 1
}}, {$group: {
 _id: {
  name: '$name',
  username: '$username',
  twitter: '$event.twitter',
  day: {
   $dateToString: {
    format: '%Y/%m/%d',
    date: '$event.created_at',
    timezone: '+09:00'
   }
  }
 },
 star: {
  $sum: '$event.event_id'
 },
 point: {
  $sum: '$event.point'
 },
 total: {
  $sum: 1
 }
}}, {$project: {
 _id: 0,
 summary: '$_id',
 point: 1,
 total: 1
}}, {$sort: {
 total: -1
}}]