🎙️ 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 = new URL(import.meta.url).pathname.split(\"/\").at(-1);\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`;","createdAt",["D",1739118958114],"version","currentUserHasLiked","likeCount",1,"forkCount","referenceCount","dependencyCount","commentCount","prCount","mergedPr",{"_128":129,"_130":131},"handle","Dharana","profileImageUrl","https://img.clerk.com/eyJ0eXBlIjoiZGVmYXVsdCIsImlpZCI6Imluc18yTm10cGhQUklwU0tqZHNiOHNnNGd2ZjJURFUiLCJyaWQiOiJ1c2VyXzJzb092d2szcHNFY05PdkhuZjZUa2JrRVBZRyJ9","forkedVal","interval","slug","Dharana/rentalPodcastApp","description","@jsxImportSource https://esm.sh/react@18.2.0","versions",[140],{"_117":31,"_141":-5,"_115":142,"_112":110},"prId",["D",1739118958114],"recentThread","breadcrumbs","comments",[],"isOwner","routes/_app.v.$handle.$name.dependencies",{"_150":151,"_218":120,"_219":135,"_220":31,"_94":221},"dependenciesList",[152],{"_100":153,"_154":155},"08f95904-3584-11ef-8995-0e10024e3b32","initialData",{"_98":156,"_95":157,"_100":153,"_102":158,"_103":-5,"_104":105,"_106":159,"_107":160,"_109":161,"_111":26,"_112":161,"_113":162,"_115":163,"_117":164,"_118":26,"_119":165,"_122":166,"_123":120,"_124":120,"_121":167,"_125":31,"_126":-5,"_20":168,"_132":171,"_133":-7,"_136":176,"_177":-5,"_134":178,"_138":179},"sqlite","a0bf3b31-15a5-4d5c-880e-4b1e22c9bc18","76a8911e-393e-11ef-8e71-de64eea55b61","# LLM-Safe Fork of @std/sqlite\n\nWe found that LLMs have trouble with the inputs and outputs of our @std/sqlite method.\n\n1. It expects the input to be `(sql: string, args: any[])` but it's `{ sql: string, args: any[] }`\n2. It expects the output to be objects, but they are arrays\n\nInstead of struggling to teach it, we built this val to be a wrapper around @std/sqlite that adheres to what the LLMs expect. \n\nThis val is also backwards-compatible with @std/sqlite, so we're considering merging it in.","script","5631f2d0-dcb9-11ef-80ec-e6cdfca9ef9f","import { API_URL } from \"https://esm.town/v/std/API_URL\";\nimport { LibsqlError, type ResultSet, type Row, type TransactionMode } from \"npm:@libsql/client\";\nimport { z } from \"npm:zod\";\n\n/**\n * Every Val Town account comes with its own private\n * [SQLite database](https://www.sqlite.org/) that\n * is accessible from any of your vals.\n * ([Docs ↗](https://docs.val.town/std/sqlite))\n */\nexport const sqlite = {\n /**\n * Executes a SQLite statement.\n *\n * @param {InStatement} statement - The SQLite statement to execute.\n * @example String query:\n * `sqlite.execute(\"SELECT 1;\")`\n * @example Query with arguments:\n * `sqlite.execute({sql: \"SELECT * from books WHERE year > ?;\", args: [2020]})`\n */\n execute,\n\n /**\n * Executes a batch of SQLite statements.\n *\n * @param {InStatement[]} statements - An array of SQLite statements to execute.\n * @param {TransactionMode} [mode] - The transaction mode for the batch execution.\n */\n batch,\n};\n\n// ------------\n// Functions\n// ------------\n\nasync function execute(statement: InStatement, args?: InArgs): Promise {\n const res = await fetch(`${API_URL}/v1/sqlite/execute`, {\n method: \"POST\",\n headers: {\n Authorization: `Bearer ${Deno.env.get(\"valtown\")}`,\n },\n body: JSON.stringify({ statement: normalizeStatement(statement, args) }),\n });\n if (!res.ok) {\n throw createResError(await res.text());\n }\n const resultSet = await res.json();\n return upgradeResultSet(resultSet);\n}\n\nasync function batch(statements: InStatement[], mode?: TransactionMode): Promise {\n if (mode && ![\"write\", \"read\", \"deferred\"].includes(mode)) {\n throw new Error(\"Invalid transaction mode provided to sqlite.batch. Must be 'write', 'read', or 'deferred.\");\n }\n const res = await fetch(`${API_URL}/v1/sqlite/batch`, {\n method: \"POST\",\n headers: {\n Authorization: `Bearer ${Deno.env.get(\"valtown\")}`,\n },\n body: JSON.stringify({ statements: statements.map(s => normalizeStatement(s)), mode }),\n });\n if (!res.ok) {\n throw createResError(await res.text());\n }\n const resultSets = await res.json();\n return resultSets.map(upgradeResultSet);\n}\n\nfunction createResError(body: string) {\n try {\n const e = zLibsqlError.parse(JSON.parse(body));\n // e.message already contains the code, and LibsqlError adds the\n // code to the beginning, so we remove it here\n const msg = e.message.replace(e.code, \"\").replace(/^:\\s+/, \"\");\n return new LibsqlError(msg, e.code, e.rawCode);\n } catch (_) {\n // Failed to parse libsql error\n }\n return new Error(body);\n}\n\n/* Val Town's Turso Proxy returns rows as an array of values\n * Yet the LibSQL API has a Row type which behave as an array or object,\n * ie you can access it via numerical index or string\n */\ninterface ImpoverishedResultSet extends ResultSet {\n rows: any[];\n}\n\nfunction normalizeStatement(statement: InStatement, args?: InArgs) {\n if (Array.isArray(statement)) {\n // for the case of an array of arrays\n return normalizeStatement(statement[0], statement[1]);\n }\n if (typeof statement === \"string\") {\n if (args) {\n return { sql: statement, args };\n } else return statement;\n }\n else if (typeof statement === \"object\") {\n if (statement.args) {\n return statement;\n }\n if (args) {\n return { sql: statement.sql, args };\n }\n return statement.sql;\n }\n else throw new Error(\"Error normalizing sql input\");\n}\n\nfunction upgradeResultSet(results: ImpoverishedResultSet): ResultSet {\n return {\n ...results,\n rows: results.rows.map(row => rowFromSql(row, results.columns)),\n };\n}\n\n// adapted from\n// https://github.com/tursodatabase/libsql-client-ts/blob/17dd996b840c950dd22b871adfe4ba0eb4a5ead3/packages/libsql-client/src/sqlite3.ts#L314C1-L337C2\nfunction rowFromSql(\n sqlRow: Array,\n columns: Array,\n): Row {\n const row = {};\n // make sure that the \"length\" property is not enumerable\n Object.defineProperty(row, \"length\", { value: sqlRow.length });\n for (let i = 0; i < sqlRow.length; ++i) {\n const value = sqlRow[i];\n Object.defineProperty(row, i, { value });\n\n const column = columns[i];\n if (!Object.hasOwn(row, column)) {\n Object.defineProperty(row, column, {\n value,\n enumerable: true,\n configurable: true,\n writable: true,\n });\n }\n }\n return row as Row;\n}\n\n// ------------\n// Helpers\n// ------------\n\nconst zLibsqlError = z.object({\n message: z.string(),\n code: z.string(),\n rawCode: z.number().optional(),\n});\n\n// We patch these types to only support JSON values\nexport type InValue = null | string | number | boolean;\nexport type InArgs = Array | Record;\nexport type InStatement = {\n /**\n * The SQL statement to execute.\n */\n sql: string;\n\n /**\n * The arguments to bind to the SQL statement.\n */\n args: InArgs;\n} | string;",["D",1737987404484],13,10,15061,21,{"_128":169,"_130":170},"stevekrouse","https://images.clerk.dev/uploaded/img_2PqHa2Gsy93xQrjh2w78Xu0cChW.jpeg",{"_112":172,"_128":173,"_98":156,"_117":174,"_175":-5},"56c849ee-f1f8-11ee-9b87-cab58f78796a","std",6,"prDisabledHint","LLM-Safe Fork of @std/sqlite We found that LLMs have trouble with the inputs and outputs of our @std/sqlite method. It expects the input to be (sql: string, args: any[]) but it's { sql: string, args: any[] } It expects the output to be objects, but they are arrays Instead of struggling to teach it, we built this val to be a wrapper around @std/sqlite that adheres to what the LLMs expect. This val is also backwards-compatible with @std/sqlite, so we're considering merging it in.","latestEvaluation","stevekrouse/sqlite",[180,184,188,192,195,199,203,207,210,214],{"_115":181,"_117":164,"_182":183},["D",1737987404484],"n","1",{"_115":185,"_117":186,"_182":187},["D",1724087412304],12,"2",{"_115":189,"_117":190,"_182":191},["D",1724087404512],11,"3",{"_115":193,"_117":165,"_182":194},["D",1723494410142],"4",{"_115":196,"_117":197,"_182":198},["D",1723494389876],9,"5",{"_115":200,"_117":201,"_182":202},["D",1723494345363],8,"6",{"_115":204,"_117":205,"_182":206},["D",1723494323065],7,"7",{"_115":208,"_117":174,"_182":209},["D",1719604370206],"8",{"_115":211,"_117":212,"_182":213},["D",1719604260994],5,"9",{"_115":215,"_117":216,"_182":217},["D",1719604144103],4,"10","dependenciesCount","valname","page",{"_112":110,"_98":99,"_128":129,"_11":96,"_117":31,"_100":101,"_113":114,"_104":105,"_111":26,"_134":135},"routes/_app","actionData","errors"]

🎙️ Podcast Space Rental

{space.name}

Book {selectedSpace.name}