const reservations = (await db
.select({
id: reservationsTable.id,
_id: reservationsTable._id,
reserveTotal: reservationsTable.reserveTotal,
checkInDate: reservationsTable.checkInDate,
checkOutDate: reservationsTable.checkOutDate,
partnerName: reservationsTable.partnerName,
})
.from(reservationsTable)
.where(
and(
eq(reservationsTable.listingId, listing.id),
eq(reservationsTable.type, "booked"),
isNotNull(reservationsTable.reserveTotal),
),
)) as Array<
Pick<
Reservation,
"id" | "_id" | "checkInDate" | "checkOutDate" | "partnerName"
> & {
reserveTotal: number; // Override to make it non-null since we filter with isNotNull
}
>;
const reservations = (await db
.select({
id: reservationsTable.id,
_id: reservationsTable._id,
reserveTotal: reservationsTable.reserveTotal,
checkInDate: reservationsTable.checkInDate,
checkOutDate: reservationsTable.checkOutDate,
partnerName: reservationsTable.partnerName,
})
.from(reservationsTable)
.where(
and(
eq(reservationsTable.listingId, listing.id),
eq(reservationsTable.type, "booked"),
isNotNull(reservationsTable.reserveTotal),
),
)) as Array<
Pick<
Reservation,
"id" | "_id" | "checkInDate" | "checkOutDate" | "partnerName"
> & {
reserveTotal: number; // Override to make it non-null since we filter with isNotNull
}
>;