mirror of
https://github.com/orangecoding/fredy.git
synced 2026-06-16 12:31:07 +00:00
8d95f052c6
* Migrating Fredy from LowDb to SqLite 🎉
* adding new sql migration system for future sql migrations
* adding setting to change sqlite path for db files
* create migration plan for graceful migration lowdb -> sqlite
* Improving Documentation
* adding test for sqliteconnection
* upgrading dependencies
* making nodejs 22 as min version
* improve scraper
* adding overwrite ability for db migra
39 lines
1.0 KiB
JavaScript
39 lines
1.0 KiB
JavaScript
import { setInterval } from 'node:timers';
|
|
import { removeJobsByUserId } from './storage/jobStorage.js';
|
|
import { config } from '../utils.js';
|
|
import { getUsers } from './storage/userStorage.js';
|
|
import logger from './logger.js';
|
|
|
|
/**
|
|
* if we are running in demo environment, we have to cleanup the db files (specifically the jobs table)
|
|
*/
|
|
export function cleanupDemoAtMidnight() {
|
|
const now = new Date();
|
|
const millisUntilMidnightUTC =
|
|
(24 - now.getUTCHours()) * 60 * 60 * 1000 -
|
|
now.getUTCMinutes() * 60 * 1000 -
|
|
now.getUTCSeconds() * 1000 -
|
|
now.getUTCMilliseconds();
|
|
|
|
cleanup();
|
|
setTimeout(() => {
|
|
setInterval(
|
|
() => {
|
|
cleanup();
|
|
},
|
|
24 * 60 * 60 * 1000,
|
|
);
|
|
}, millisUntilMidnightUTC);
|
|
}
|
|
|
|
function cleanup() {
|
|
if (config.demoMode) {
|
|
const demoUser = getUsers(false).find((user) => user.username === 'demo');
|
|
if (demoUser == null) {
|
|
logger.error('Demo user not found, cannot remove Jobs');
|
|
return;
|
|
}
|
|
removeJobsByUserId(demoUser.id);
|
|
}
|
|
}
|