Hello, I wonder if there is a directive to set `ex...
# orm-helps
sandorTuranszky
02/25/2019, 3:38 PMHello, I wonder if there is a directive to set
expireAfterSecondsh
Harshit
02/25/2019, 3:42 PMHi,
I think this is something you should implement in you custom server.
Can you also brief me about what you mean by expire(either deletion or something else)?
s
sandorTuranszky
02/25/2019, 6:05 PMHi, it's when the value gets deleted after time expires. Useful for storing tokens for restoring passwords etc. Usually, they are valid for limited time and it is convenient that DB removes them rather than you have to take care of it
h
Harshit
02/25/2019, 6:48 PMI think you should implement a shared queue for this. I don't this is something that we can implement on the datalayer.
You can use bull here: https://www.npmjs.com/package/bull
s
sandorTuranszky
02/26/2019, 8:56 AMMongoDb supports TTL so using it would be an ideal solution
sandorTuranszky
02/26/2019, 8:57 AMsandorTuranszky
02/26/2019, 8:57 AMWhile your suggestion would work, doing it natively is way more elegant
sandorTuranszky
02/26/2019, 8:58 AMWould it make sense to make a feature request?
sandorTuranszky
02/26/2019, 8:58 AM@Harshit
h
Harshit
02/26/2019, 8:58 AMOh ok, if it is just an index this will be possible in datamodel v1.1: https://github.com/prisma/prisma/issues/3405
Harshit
02/26/2019, 8:59 AMPlease make a comment about this there and tag
@mavileinHarshit
02/26/2019, 9:00 AMBTW datamodel v1.1 is currently in beta under a prototype flag
s
sandorTuranszky
02/26/2019, 9:00 AMand it supports TTL?
sandorTuranszky
02/26/2019, 9:01 AMin Mongoose what I need looks that simple
Copy code
// expire docs 3600 seconds after createdAt
new Schema({ createdAt: { type: Date, expires: 3600 }});h
Harshit
02/26/2019, 9:01 AMThis is simply an index so I think it would be possible to create one using @index directive
9 Views