Mongo aggregations and date to ObjectId

entity_users.js

// run like: nohup mongo --quiet neat_prod > entity_users.js

days_ago = 120
date_after = new Date(new Date().setDate(new Date().getDate() - days_ago))
secs_after = Math.floor(date_after.getTime() / 1000)
oid_after = ObjectId(secs_after.toString(16) + "0000000000000000")

rs.slaveOk()

c = db.entities.find(
  { _id: { $gte: oid_after } },
  { _id: 0 , account_id: 1 }
)

while (c.hasNext()) {
  printjson(c.next())
}


/*
printjson(
  db.entities.distinct(
    'account_id',
    { _id: { $gte: oid_after } }
  )
)
*/


/*
printjson(
  db.entities.aggregate(
    { $match: { _id: { $gte: oid_after } } },
    { $group: { _id: '$account_id', count: { $sum: 1 } } },
    { $sort:  { count: -1 } },
    { $project: { _id: 0, account_id: '$_id', entities_created_count: '$count' } }
  )
)
*/