Setting expiry time for a collection in mongodb using mongoose

Question

Below is the command that can be used via the mongo terminal to set an expiry time for collections (a TTL):

db.log.events.ensureIndex( { "status": 1 }, { expireAfterSeconds: 3600 } ) 

How do I do this from my code in Node.js using mongoose?

Answer 1

In Mongoose, you create a TTL index on a Date field via the expires property in the schema definition of that field:

// expire docs 3600 seconds after createdAt new Schema({ createdAt: { type: Date, expires: 3600 }}); 

Note that:

• MongoDB's data expiration task runs once a minute, so an expired doc might persist up to a minute past its expiration.
• This feature requires MongoDB 2.2 or later.
• It's up to you to set createdAt to the current time when creating docs, or add a default to do it for you as suggested here.
  • { createdAt: { type: Date, expires: 3600, default: Date.now }}