-// TODO: adapt
-//exports.cleanUsersDb = function()
-//{
-// var tsNow = new Date().getTime();
-// // 86400000 = 24 hours in milliseconds
-// var day = 86400000;
-//
-// db.users.find({}, (err,userArray) => {
-// userArray.forEach( u => {
-// if ((u.sessionTokens.length==0 &&
-// u._id.getTimestamp().getTime() + day < tsNow) //unlogged
-// || u.updated + 365*day < tsNow) //inactive for one year
-// {
-// db.users.remove({"_id": u._id});
-// }
-// });
-// });
-//}
+ cleanUsersDb: function()
+ {
+ const tsNow = Date.now();
+ // 86400000 = 24 hours in milliseconds
+ const day = 86400000;
+ db.serialize(function() {
+ const query =
+ "SELECT id, sessionToken, created " +
+ "FROM Users";
+ db.all(query, (err, users) => {
+ users.forEach(u => {
+ // Remove unlogged users for >1 day
+ if (!u.sessionToken && tsNow - u.created > day)
+ db.run("DELETE FROM Users WHERE id = " + u.id);
+ });
+ });
+ });
+ },
+}