[{"_1":2,"_235":-5,"_236":-5},"loaderData",{"_3":4,"_91":92,"_160":161,"_234":-5},"root",{"_5":6,"_32":33,"_58":59,"_89":90},"ctx",{"_7":8,"_18":19,"_20":-5,"_21":22,"_23":24,"_25":26,"_27":26,"_28":29,"_30":31},"auth",{"_9":-5,"_10":-5,"_11":-5,"_12":-5,"_13":-5,"_14":-5,"_15":-5,"_16":-5,"_17":-5},"sessionClaims","sessionId","userId","actor","orgId","orgRole","orgSlug","orgPermissions","factorVerificationAge","environmentVariableKeys",[],"user","preferences_keybindings","default","preferences_theme","light","preferences_fixers",false,"preferences_copilot","preferences_model","claude-3-5-haiku-20241022","notification_count",0,"ENV",{"_34":35,"_36":37,"_38":39,"_40":41,"_42":43,"_44":45,"_46":47,"_48":49,"_50":51,"_52":53,"_54":55,"_56":57},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","VAL_RUNTIME_NAME","prod","RENDER_GIT_COMMIT","fa80b67e1f763bfb4b247c3f5ca4f0b0730f3f5c","RENDER_GIT_BRANCH","main","CLERK_PUBLISHABLE_KEY","pk_live_Y2xlcmsudmFsLnRvd24k","POSTHOG_API_TOKEN","phc_nmoyuAkStEZuUp69rYlg1DZgrIt19Gx0Y4Hwf8tGgJP","POSTHOG_API_HOST","https://wart.val.town","WEB_API_TEMPLATE","https://{val}.web.val.run","APP_URL","https://www.val.town","MODULE_URL","https://esm.town","API_URL","https://api.val.town","WORKER_FINGERPRINT","799d99f2805306c2714a7cfefbeae178","clerkState",{"_60":61},"__internal_clerk_state",{"_62":63,"_64":43,"_65":66,"_67":66,"_68":26,"_69":66,"_70":66,"_71":66,"_72":66,"_73":66,"_74":66,"_75":66,"_76":66,"_77":78,"_87":26,"_88":26},"__clerk_ssr_state",{"_9":-5,"_10":-5,"_11":-5,"_12":-5,"_13":-5,"_14":-5,"_15":-5,"_16":-5,"_17":-5},"__publishableKey","__proxyUrl","","__domain","__isSatellite","__signInUrl","__signUpUrl","__afterSignInUrl","__afterSignUpUrl","__signInForceRedirectUrl","__signUpForceRedirectUrl","__signInFallbackRedirectUrl","__signUpFallbackRedirectUrl","__clerk_debug",{"_79":26,"_80":66,"_81":82,"_83":66,"_84":43,"_85":26,"_86":66},"isSignedIn","proxyUrl","reason","session-token-and-uat-missing","message","publishableKey","isSatellite","domain","__telemetryDisabled","__telemetryDebug","remixVersion",2,"routes/_app.v.$handle.$name",{"_93":94,"_95":96,"_94":97,"_146":-5,"_147":-5,"_148":149,"_128":129,"_136":137,"_100":101,"_98":99,"_117":-7,"_50":51,"_159":26},"type","val","author","76693440-ecfa-11ef-8139-5783405cc753",{"_98":99,"_95":96,"_100":101,"_102":-5,"_103":-5,"_104":105,"_106":-5,"_107":108,"_109":110,"_111":26,"_112":110,"_113":114,"_115":116,"_117":118,"_119":26,"_120":31,"_121":31,"_122":31,"_123":118,"_124":118,"_125":31,"_126":-5,"_20":127,"_132":-5,"_133":-7,"_134":135,"_136":137,"_138":139},"name","JobChatApp","valNameId","2429542a-ecfb-11ef-9012-e6cdfca9ef9f","parentFolderId","isOwned","privacy","public","readme","valType","http","currentVersion","d239a178-ecfb-11ef-aeb0-e6cdfca9ef9f","legacyPrivate","id","code","/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useState, useEffect } from \"https://esm.sh/react@18.2.0\";\nimport { createRoot } from \"https://esm.sh/react-dom@18.2.0/client\";\n\nfunction App() {\n const [view, setView] = useState('jobs');\n const [user, setUser] = useState(null);\n\n return (\n

💼 JobChat

\n {user ? (\n

\n Welcome, {user.name}\n \n

\n ) : (\n \n )}\n

\n \n\n {view === 'login' && }\n {view === 'jobs' && }\n {view === 'post' && }\n {view === 'chat-rooms' && user && }\n {view === 'chat-room' && user && }\n

\n );\n}\n\n// ... [Previous components remain the same]\n\nfunction ChatRooms({ user }) {\n const [rooms, setRooms] = useState([]);\n const [newRoomName, setNewRoomName] = useState('');\n const [selectedRoom, setSelectedRoom] = useState(null);\n\n useEffect(() => {\n fetchRooms();\n }, []);\n\n const fetchRooms = async () => {\n try {\n const response = await fetch('/chat-rooms');\n const chatRooms = await response.json();\n setRooms(chatRooms);\n } catch (error) {\n console.error('Failed to fetch rooms', error);\n }\n };\n\n const createRoom = async (e) => {\n e.preventDefault();\n try {\n await fetch('/create-room', {\n method: 'POST',\n headers: { 'Content-Type': 'application/json' },\n body: JSON.stringify({ \n name: newRoomName, \n createdBy: user.id \n })\n });\n setNewRoomName('');\n fetchRooms();\n } catch (error) {\n alert('Failed to create room');\n }\n };\n\n const joinRoom = (room) => {\n setSelectedRoom(room);\n };\n\n if (selectedRoom) {\n return setSelectedRoom(null)} />;\n }\n\n return (\n

Chat Rooms

\n \n\n

\n {rooms.map(room => (\n

\n {room.name}\n {room.member_count} members\n \n

\n ))}\n

\n );\n}\n\nfunction ChatRoom({ user, room, onBack }) {\n const [messages, setMessages] = useState([]);\n const [newMessage, setNewMessage] = useState('');\n\n useEffect(() => {\n const fetchMessages = async () => {\n const response = await fetch(`/chat-messages?roomId=${room.id}`);\n const chatMessages = await response.json();\n setMessages(chatMessages);\n };\n fetchMessages();\n const interval = setInterval(fetchMessages, 5000);\n return () => clearInterval(interval);\n }, [room.id]);\n\n const sendMessage = async (e) => {\n e.preventDefault();\n try {\n await fetch('/send-message', {\n method: 'POST',\n headers: { 'Content-Type': 'application/json' },\n body: JSON.stringify({ \n userId: user.id, \n username: user.name, \n message: newMessage,\n roomId: room.id\n })\n });\n setNewMessage('');\n } catch (error) {\n alert('Failed to send message');\n }\n };\n\n return (\n

\n \n

{room.name}

\n {messages.map((msg, index) => (\n

\n {msg.username}: {msg.message}\n

\n ))}\n

\n \n

\n );\n}\n\n// ... [Rest of the previous code remains the same]\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 = 4;\n\n // Initialize tables with new chat rooms table\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${KEY}_users_${SCHEMA_VERSION} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n username TEXT UNIQUE NOT NULL,\n password TEXT NOT NULL\n )\n `);\n\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${KEY}_jobs_${SCHEMA_VERSION} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n title TEXT NOT NULL,\n company TEXT NOT NULL,\n description TEXT NOT NULL,\n created_at DATETIME DEFAULT CURRENT_TIMESTAMP\n )\n `);\n\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${KEY}_chat_rooms_${SCHEMA_VERSION} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n name TEXT NOT NULL,\n created_by INTEGER NOT NULL,\n created_at DATETIME DEFAULT CURRENT_TIMESTAMP\n )\n `);\n\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${KEY}_chat_${SCHEMA_VERSION} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n room_id INTEGER NOT NULL,\n user_id INTEGER NOT NULL,\n username TEXT NOT NULL,\n message TEXT NOT NULL,\n created_at DATETIME DEFAULT CURRENT_TIMESTAMP\n )\n `);\n\n // Handle different routes\n const url = new URL(request.url);\n \n // ... [Previous route handlers remain the same]\n\n // New route for fetching chat rooms\n if (request.method === 'GET' && url.pathname === '/chat-rooms') {\n const result = await sqlite.execute(`\n SELECT \n r.id, \n r.name, \n r.created_at, \n COUNT(DISTINCT c.user_id) as member_count \n FROM ${KEY}_chat_rooms_${SCHEMA_VERSION} r\n LEFT JOIN ${KEY}_chat_${SCHEMA_VERSION} c ON c.room_id = r.id\n GROUP BY r.id, r.name, r.created_at\n ORDER BY r.created_at DESC\n `);\n return new Response(JSON.stringify(result.rows), { \n headers: { 'Content-Type': 'application/json' } \n });\n }\n\n // Route for creating a new chat room\n if (request.method === 'POST' && url.pathname === '/create-room') {\n const { name, createdBy } = await request.json();\n const result = await sqlite.execute(\n `INSERT INTO ${KEY}_chat_rooms_${SCHEMA_VERSION} (name, created_by) VALUES (?, ?)`,\n [name, createdBy]\n );\n return new Response('Room created', { status: 200 });\n }\n\n // Modified chat messages route to support room-specific messages\n if (request.method === 'GET' && url.pathname === '/chat-messages') {\n const roomId = new URL(request.url).searchParams.get('roomId');\n const result = await sqlite.execute(\n `SELECT * FROM ${KEY}_chat_${SCHEMA_VERSION} \n WHERE room_id = ? \n ORDER BY created_at DESC \n LIMIT 50`,\n [roomId]\n );\n return new Response(JSON.stringify(result.rows), { \n headers: { 'Content-Type': 'application/json' } \n });\n }\n\n // Modified send message route to include room_id\n if (request.method === 'POST' && url.pathname === '/send-message') {\n const { userId, username, message, roomId } = await request.json();\n await sqlite.execute(\n `INSERT INTO ${KEY}_chat_${SCHEMA_VERSION} (room_id, user_id, username, message) VALUES (?, ?, ?, ?)`,\n [roomId, userId, username, message]\n );\n return new Response('Message sent', { status: 200 });\n }\n\n // ... [Rest of the server function remains the same]\n}\n\n// Update CSS to accommodate new chat rooms view\nconst css = `\n/* Previous CSS remains the same, with additions: */\n.chat-rooms {\n padding: 20px;\n}\n\n.rooms-list {\n margin-top: 20px;\n}\n\n.room-item {\n display: flex;\n justify-content: space-between;\n align-items: center;\n padding: 10px;\n border-bottom: 1px solid #eee;\n}\n\n.chat-room-header {\n display: flex;\n align-items: center;\n background-color: #f0f0f0;\n padding: 10px;\n}\n\n.chat-room-header button {\n margin-right: 15px;\n}\n`;","createdAt",["D",1739775177950],"version",1,"currentUserHasLiked","likeCount","forkCount","referenceCount","dependencyCount","commentCount","prCount","mergedPr",{"_128":129,"_130":131},"handle","Kaycee1989","profileImageUrl","https://img.clerk.com/eyJ0eXBlIjoiZGVmYXVsdCIsImlpZCI6Imluc18yTm10cGhQUklwU0tqZHNiOHNnNGd2ZjJURFUiLCJyaWQiOiJ1c2VyXzJ0OXFLRHFXZHhiYnp2eHY2cEpoNWRwa0R3MiJ9","forkedVal","interval","slug","Kaycee1989/JobChatApp","description","@jsxImportSource https://esm.sh/react@18.2.0","versions",[140,143],{"_117":118,"_141":-5,"_115":142,"_112":110},"prId",["D",1739775177950],{"_117":31,"_141":-5,"_115":144,"_112":145},["D",1739774885937],"242b62e2-ecfb-11ef-9012-e6cdfca9ef9f","recentThread","breadcrumbs","comments",[150],{"_112":151,"_152":153,"_115":154,"_155":-5,"_156":26,"_157":26,"_20":158},"fd8b74be-ecfb-11ef-96d2-e6cdfca9ef9f","body","Hello ",["D",1739775250649],"updatedAt","canDelete","canEdit",{"_128":129,"_130":131},"isOwner","routes/_app.v.$handle.$name.dependencies",{"_162":163,"_230":118,"_231":135,"_232":31,"_94":233},"dependenciesList",[164],{"_100":165,"_166":167},"08f95904-3584-11ef-8995-0e10024e3b32","initialData",{"_98":168,"_95":169,"_100":165,"_102":170,"_103":-5,"_104":105,"_106":171,"_107":172,"_109":173,"_111":26,"_112":173,"_113":174,"_115":175,"_117":176,"_119":26,"_120":177,"_122":178,"_123":118,"_124":118,"_121":179,"_125":31,"_126":-5,"_20":180,"_132":183,"_133":-7,"_136":188,"_189":-5,"_134":190,"_138":191},"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,13512,21,{"_128":181,"_130":182},"stevekrouse","https://images.clerk.dev/uploaded/img_2PqHa2Gsy93xQrjh2w78Xu0cChW.jpeg",{"_112":184,"_128":185,"_98":168,"_117":186,"_187":-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",[192,196,200,204,207,211,215,219,222,226],{"_115":193,"_117":176,"_194":195},["D",1737987404484],"n","1",{"_115":197,"_117":198,"_194":199},["D",1724087412304],12,"2",{"_115":201,"_117":202,"_194":203},["D",1724087404512],11,"3",{"_115":205,"_117":177,"_194":206},["D",1723494410142],"4",{"_115":208,"_117":209,"_194":210},["D",1723494389876],9,"5",{"_115":212,"_117":213,"_194":214},["D",1723494345363],8,"6",{"_115":216,"_117":217,"_194":218},["D",1723494323065],7,"7",{"_115":220,"_117":186,"_194":221},["D",1719604370206],"8",{"_115":223,"_117":224,"_194":225},["D",1719604260994],5,"9",{"_115":227,"_117":228,"_194":229},["D",1719604144103],4,"10","dependenciesCount","valname","page",{"_112":110,"_98":99,"_128":129,"_11":96,"_117":118,"_100":101,"_113":114,"_104":105,"_111":26,"_134":135},"routes/_app","actionData","errors"]