const response = await database.query.eventTable.findFirst({
where: eq(eventTable.id, eventId),
with: {
tags: true,
allocations: {
with: {
employee: {
with: {
availabilities: {
where: and(
gte(availabilityTable.endTime, getOuterEventField(eventTable.endTime)),
lte(availabilityTable.startTime, getOuterEventField(eventTable.startTime)),
eq(availabilityTable.day, sql`WEEKDAY(${getOuterEventField(eventTable.date)})`)
)
}
}
}
}
}
}
}).execute()
const response = await database.query.eventTable.findFirst({
where: eq(eventTable.id, eventId),
with: {
tags: true,
allocations: {
with: {
employee: {
with: {
availabilities: {
where: and(
gte(availabilityTable.endTime, getOuterEventField(eventTable.endTime)),
lte(availabilityTable.startTime, getOuterEventField(eventTable.startTime)),
eq(availabilityTable.day, sql`WEEKDAY(${getOuterEventField(eventTable.date)})`)
)
}
}
}
}
}
}
}).execute()