import { Op } from 'sequelize';
import moment from 'moment-timezone';
import TempFormData from '../models/TempFormData.js';

const deleteOldTempFormData = async () => {
  try {
    const thresholdDate = moment().subtract(20, 'days').toDate();

    const deletedRows = await TempFormData.destroy({
      where: {
        createdAt: { [Op.lt]: thresholdDate },
      },
    });

    console.log(
      `Deleted ${deletedRows} old records from TempFormData older than 20 days`
    );
  } catch (error) {
    console.error('Error deleting old TempFormData records:', error);
  }
};

export default deleteOldTempFormData;