Promise.mapSeries(seeds, (seed) => callLater().then(() => seed.up(db.sequelize.getQueryInterface())))
/** * @description Purge device states * @example * device.purgeStates(); */ async function purgeStates() { logger.debug('Purging device feature states...'); const deviceStateHistoryInDays = await this.variable.getValue(SYSTEM_VARIABLE_NAMES.DEVICE_STATE_HISTORY_IN_DAYS); const deviceStateHistoryInDaysInt = parseInt(deviceStateHistoryInDays, 10); if (Number.isNaN(deviceStateHistoryInDaysInt)) { logger.debug('Not purging device feature states.'); return; } const queryInterface = db.sequelize.getQueryInterface(); const now = new Date().getTime(); // all date before this timestamp will be removed const timstampLimit = now - deviceStateHistoryInDaysInt * 24 * 60 * 60 * 1000; await queryInterface.bulkDelete('t_device_feature_state', { created_at: { [Op.lte]: new Date(timstampLimit), }, }); }
Promise.mapSeries(reversedSeed, (seed) => callLater().then(() => seed.down(db.sequelize.getQueryInterface())))
var mysql_clean = function (string) { return sequelize.getQueryInterface().escape(string); }
Object.assign({}, config.sequelize, config.db, { logging: logger.getInstance().verbose }) ); const query = sequelize.getQueryInterface();
Object.assign({}, config.sequelize, config.db, { logging: logger.getInstance().verbose }) ); const query = sequelize.getQueryInterface();