const db = require('./src/db/models');

async function check() {
  try {
    const requests = await db.time_off_requests.findAll({
      limit: 10,
      order: [['createdAt', 'DESC']],
      include: ['requester']
    });

    console.log("Found " + requests.length + " requests.");
    requests.forEach(r => {
      console.log(`ID: ${r.id}, Status: ${r.status}, Requester: ${r.requester?.firstName} ${r.requester?.lastName}`);
      console.log(`   Starts: ${r.starts_at}, Ends: ${r.ends_at}, Days: ${r.days}`);
      console.log(`   Reason: ${r.reason}`);
    });
  } catch (err) {
    console.error(err);
  } finally {
    await db.sequelize.close();
  }
}

check();