2022.07.30 - TIL [크롤러 지우는 코드]

const { Posting, Schedule } = require("./models");
const { sequelize } = require('./models');
const { dateFormatter } = require('./utils/util')
const { Op } = require('sequelize');

async function destroying() {
    let now = dateFormatter(new Date())

    const t = await sequelize.transaction();

    try {
        await Schedule.destroy({
            where: {
                date: { [Op.lte]: now },
                postingId: { [Op.ne]: null }
            }
        }, { transaction: t })

        await Posting.destroy({
            where: {
                deadline: { [Op.lte]: now }
            }
        }, { transaction: t })

        await t.commit();
        console.log('데이터 삭제 완료!');
        process.exit(0)
    } catch (error) {
        await t.rollback();
        console.log('데이터 삭제 실패!');
        process.exit(1)
    }
}

destroying()