Ella Resort Booking

1async function createBooking(roomId: string, checkIn: Date, checkOut: Date) {
2  return await prisma.$transaction(async (tx) => {
3    // Lock room rows for this date range
4    const conflicts = await tx.$queryRaw`
5      SELECT * FROM bookings 
6      WHERE room_id = ${roomId}
7      AND status != 'cancelled'
8      AND (
9        (check_in, check_out) OVERLAPS (${checkIn}, ${checkOut})
10      )
11      FOR UPDATE NOWAIT
12    `;
13    
14    if (conflicts.length > 0) {
15      throw new Error('Room not available');
16    }
17    
18    // Create booking - guaranteed no conflicts
19    return await tx.booking.create({
20      data: {
21        roomId,
22        checkIn,
23        checkOut,
24        status: 'confirmed'
25      }
26    });
27  }, {
28    isolationLevel: 'Serializable',
29    timeout: 5000
30  });
31}