25 lines
672 B
JavaScript
25 lines
672 B
JavaScript
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();
|