I'm saving logintokens with a lifetime of 365 days using the following sequelize beforeCreate Hook:
let hooks = {
setExpires: (instance, options, done) => {
if(instance.get('expires')) {
return done();
}
instance.set('expires', Sequelize.literal('NOW() + INTERVAL 1 YEAR'));
return done();
}
};
Logintoken.beforeCreate(hooks.setExpires);
Logintoken.beforeBulkCreate(hooks.setExpires);
It works great as long as I use MySQL. Other dialects such as SQLite don't understand NOW() + INTERVAL 1 YEAR
, which is bad. Is there a built-in cross-dialect way to achieve what I am trying to do here?
I've already studied the docs, googled like hell and even had a look at the source code but couldn't find anything that looks like date calculation.
Aucun commentaire:
Enregistrer un commentaire