🎙️ Podcast Space Rental

\n \n {!selectedSpace ? (\n

\n {spaces.map(space => (\n

{space.name}

{space.description}

Rate: ${space.hourlyRate}/hour

{space.available ? '✅ Available' : '❌ Booked'}

\n {space.available && (\n \n )}\n

\n ))}\n

\n ) : (\n

\n );\n}\n\nfunction client() {\n createRoot(document.getElementById(\"root\")).render();\n}\nif (typeof document !== \"undefined\") { client(); }\n\nexport default async function server(request: Request): Promise {\n const { sqlite } = await import(\"https://esm.town/v/stevekrouse/sqlite\");\n const KEY = \"rentalPodcastApp\";\n const SCHEMA_VERSION = 3;\n\n // Create spaces and bookings tables\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${KEY}_podcast_spaces_${SCHEMA_VERSION} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n name TEXT NOT NULL,\n description TEXT,\n hourly_rate REAL NOT NULL,\n available BOOLEAN DEFAULT TRUE\n )\n `);\n\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${KEY}_bookings_${SCHEMA_VERSION} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n space_id INTEGER NOT NULL,\n name TEXT NOT NULL,\n email TEXT NOT NULL,\n booking_date TEXT NOT NULL,\n start_time TEXT NOT NULL,\n end_time TEXT NOT NULL,\n FOREIGN KEY(space_id) REFERENCES ${KEY}_podcast_spaces_${SCHEMA_VERSION}(id)\n )\n `);\n\n // Seed initial spaces if not exists\n const spacesCount = (await sqlite.execute(`SELECT COUNT(*) as count FROM ${KEY}_podcast_spaces_${SCHEMA_VERSION}`)).rows[0].count;\n if (spacesCount === 0) {\n await sqlite.execute(`\n INSERT INTO ${KEY}_podcast_spaces_${SCHEMA_VERSION} \n (name, description, hourly_rate, available) VALUES \n ('Soundproof Studio A', 'Professional recording space with high-end equipment', 75.00, TRUE),\n ('Cozy Podcast Nook', 'Intimate space perfect for solo podcasters', 50.00, TRUE),\n ('Group Recording Room', 'Large space for multi-person podcast recordings', 100.00, TRUE)\n `);\n }\n\n // Handle routes\n if (request.method === 'GET' && new URL(request.url).pathname === '/spaces') {\n const spaces = await sqlite.execute(`SELECT * FROM ${KEY}_podcast_spaces_${SCHEMA_VERSION}`);\n return new Response(JSON.stringify(spaces.rows), {\n headers: { 'Content-Type': 'application/json' }\n });\n }\n\n if (request.method === 'POST' && new URL(request.url).pathname === '/book') {\n const booking = await request.json();\n \n // Basic validation\n if (!booking.name || !booking.email || !booking.date || !booking.startTime || !booking.endTime) {\n return new Response('Missing booking details', { status: 400 });\n }\n\n try {\n await sqlite.execute(`\n INSERT INTO ${KEY}_bookings_${SCHEMA_VERSION} \n (space_id, name, email, booking_date, start_time, end_time) \n VALUES (?, ?, ?, ?, ?, ?)\n `, [\n booking.spaceId, \n booking.name, \n booking.email, \n booking.date, \n booking.startTime, \n booking.endTime\n ]);\n\n // Optionally update space availability\n await sqlite.execute(`\n UPDATE ${KEY}_podcast_spaces_${SCHEMA_VERSION} \n SET available = FALSE \n WHERE id = ?\n `, [booking.spaceId]);\n\n return new Response('Booking successful', { status: 200 });\n } catch (error) {\n return new Response(`Booking failed: ${error}`, { status: 500 });\n }\n }\n\n return new Response(`\n \n \n Podcast Space Rental\n \n \n \n

\n \n \n \n \n `, {\n headers: { 'Content-Type': 'text/html' }\n });\n}\n\nconst css = `\nbody {\n font-family: 'Arial', sans-serif;\n max-width: 800px;\n margin: 0 auto;\n padding: 20px;\n background-color: #f4f4f4;\n}\n\n.podcast-booking-app {\n background: white;\n padding: 20px;\n border-radius: 8px;\n box-shadow: 0 2px 4px rgba(0,0,0,0.1);\n}\n\n.space-list {\n display: grid;\n grid-template-columns: repeat(auto-fit, minmax(250px, 1fr));\n gap: 15px;\n}\n\n.space-card {\n border: 1px solid #ddd;\n padding: 15px;\n border-radius: 5px;\n text-align: center;\n}\n\n.booking-form {\n display: flex;\n flex-direction: column;\n gap: 10px;\n}\n\ninput, button {\n padding: 10px;\n margin: 5px 0;\n}\n\nbutton {\n background-color: #007bff;\n color: white;\n border: none;\n cursor: pointer;\n transition: background-color 0.3s;\n}\n\nbutton:hover {\n background-color: #0056b3;\n}\n`;","deleted","label",[98],"permalink","https://www.val.town/x/Dharana/rentalPodcastApp/code/main.tsx","extension","actionData","errors"]

🎙️ Podcast Space Rental

{space.name}

Book {selectedSpace.name}