[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_239":240,"_241":242},"routes/_app.x.$handle.$name",{"_100":99,"_32":45,"_108":86,"_27":37,"_13":14,"_109":-5,"_11":110,"_111":112,"_113":114,"_115":116,"_117":118,"_20":-5,"_119":120,"_121":122,"_123":26,"_124":125,"_126":24,"_127":-5,"_128":-5,"_129":130},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_43":44,"_32":45,"_38":46,"_47":-5,"_48":26,"_49":50,"_51":50,"_52":-5,"_53":-5,"_18":54,"_55":56,"_57":24,"_58":-5,"_59":60,"_61":62,"_63":64,"_65":-5,"_66":-5,"_67":-5,"_68":-5,"_69":70,"_71":70,"_72":73,"_74":73,"_75":73,"_76":70,"_77":70,"_78":79,"_80":81,"_82":83,"_84":26},"version",54,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":-7,"_23":24,"_25":26,"_27":28,"_29":28},"file",{"_30":31,"_32":33,"_34":35,"_36":37,"_38":39,"_40":14,"_41":42,"_23":26},"previous","deleted",true,"deletedHere",false,"path","backend/documentation.json","latestPath","fileId","74f94bfc-0778-11f0-8051-569c3dd06744","name","documentation.json","fileType","script","content","","createdAt",["D",1742687438834],"branchVersion","branchId","c140760c-06c9-11f0-99ae-569c3dd06744","id","c13c86fa-06c9-11f0-99ae-569c3dd06744","AlwaysHereBackend",["D",1742612404852],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","imageUrl","bb1eb5fa-10b6-4de3-a259-5b804744f1ec","pinnedFileId","4263e75e-b85c-49ca-b0ee-3957dd991531","pinPreview","pinMigrated","screenshotVersion",140,"likeCount",0,"orgId","bedf198b-fc8f-45e9-bc77-3a7a761b4633","tursoName","tursoHostname","tursoMeasuredAt","pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_100":99,"_107":103},"org",{"_100":99,"_101":-5,"_102":103,"_18":54,"_104":105,"_106":26},"branch",{"_13":85,"_32":86,"_43":42,"_87":44,"_88":89,"_90":91,"_92":50,"_93":94,"_95":96,"_97":45,"_98":99},"isOwned",179,"main","projectId","forkedBranchId","41ef5540-f2f5-11ef-891c-569c3dd06744","forkedBranchVersion",226,"forkedProjectPrivacy","forkedProjectId","41ef0130-f2f5-11ef-891c-569c3dd06744","forkedProjectOrgId","e81e7335-6d4c-4764-a902-d0962bbfa9f7","projectName","userHandle","ninadxc","handle","displayName","avatar","https://img.clerk.com/eyJ0eXBlIjoiZGVmYXVsdCIsImlpZCI6Imluc18yTm10cGhQUklwU0tqZHNiOHNnNGd2ZjJURFUiLCJyaWQiOiJ1c2VyXzJycnhUMzZvbVdVMmplR25OaUY1YjNCdWQ2OSIsImluaXRpYWxzIjoiTkMifQ","tier","free","canRestrictVals","profileImageUrl","branchName","adoptOrgId",{"_43":44,"_32":45,"_38":235,"_47":-5,"_48":26,"_49":50,"_51":50,"_52":-5,"_53":-5,"_18":54,"_55":56,"_57":24,"_58":-5,"_59":60,"_61":62,"_63":64,"_65":-5,"_66":-5,"_67":-5,"_68":-5,"_69":70,"_71":70,"_72":73,"_74":73,"_75":73,"_76":70,"_77":70,"_78":236,"_80":237,"_82":238,"_84":26},"tree",[170,178],"files",[170,171,172,173,174,175,176,177,178],"counts",{"_160":62,"_161":148,"_162":62,"_163":164,"_165":166},"contents",[142,143],"upstreamProject",{"_43":94,"_32":138,"_52":139,"_53":-5,"_49":50,"_78":140},"upstreamBranch",{"_43":89,"_38":131,"_132":133,"_32":86,"_87":94,"_13":134,"_88":-5,"_90":-5,"_135":136,"_47":-5,"_84":26,"_49":50,"_98":137,"_63":96,"_97":138},"emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},["D",1740432065884],"updatedAt",["D",1755285423526],244,"lockfileKey","1755661346047-esm.town_v_stevekrouse_reactHonoExample@244-main","stevekrouse","reactHonoExample","Example with client-side React & Hono server",{"_100":137,"_107":141},"https://images.clerk.dev/uploaded/img_2PqHa2Gsy93xQrjh2w78Xu0cChW.jpeg",{"_43":154,"_32":155,"_30":156,"_147":-5,"_41":42,"_40":148,"_149":24,"_38":157,"_13":62,"_34":158,"_36":-5,"_23":26,"_152":-5,"_27":159},{"_43":144,"_32":145,"_30":146,"_147":-5,"_41":42,"_40":148,"_149":24,"_38":150,"_13":62,"_34":20,"_36":151,"_23":26,"_152":-5,"_27":153},"c143246a-06c9-11f0-99ae-569c3dd06744","README.md","df8c8d6a-fbaa-4787-b331-1717f751724a","parentId",1,"latest",["D",1742612404852],"# React Hono Val Town Project Starter Template\n\nThis is a starter template for a full-stack app in a Val Town Project. The app itself is a simple persistent message board.\n\nThis app is broken up into three folders, corresponding to where the code in those folders run:\n\n- `backend/` - runs on Val Town serverless infrastructure in Deno\n- `frontend/` - runs in the user's browser\n- `shared/` - runs in both the frontend and backend\n\nThe entrypoint of this app is `backend/index.ts`, which is the Hono HTTP server, which serves the HTML, CSS, and JS, which run client-side.\n\nYou can click into each of those folders to view their respective READMEs.","label",[145],"c14311dc-06c9-11f0-99ae-569c3dd06744","backend","1c2d6f1f-27d1-43d0-86bd-525544c118c7",["D",1742612404852],"directory",[155],"pulls","branches","forks","envVars",{"_167":148,"_169":62},"connections",{"_167":62,"_168":62},"count","unfilledCount","emptyCount",{"_43":154,"_32":155,"_30":156,"_147":-5,"_41":42,"_40":148,"_149":24,"_38":232,"_13":62,"_34":158,"_36":-5,"_23":26,"_152":-5,"_180":233,"_27":234},{"_43":228,"_32":212,"_30":205,"_147":156,"_41":42,"_40":148,"_149":24,"_38":229,"_13":62,"_34":158,"_36":-5,"_23":26,"_152":-5,"_180":230,"_27":231},{"_43":222,"_32":145,"_30":223,"_147":205,"_41":42,"_40":148,"_149":24,"_38":224,"_13":62,"_34":20,"_36":225,"_23":26,"_152":-5,"_180":226,"_27":227},{"_43":213,"_32":214,"_30":215,"_147":205,"_41":42,"_40":216,"_149":26,"_38":217,"_13":218,"_34":35,"_36":219,"_23":26,"_152":-5,"_180":220,"_27":221},{"_43":202,"_32":203,"_30":204,"_147":205,"_41":42,"_40":206,"_149":26,"_38":207,"_13":208,"_34":35,"_36":209,"_23":26,"_152":-5,"_180":210,"_27":211},{"_43":196,"_32":145,"_30":197,"_147":156,"_41":42,"_40":148,"_149":24,"_38":198,"_13":62,"_34":20,"_36":199,"_23":26,"_152":-5,"_180":200,"_27":201},{"_43":192,"_32":33,"_30":31,"_147":156,"_41":42,"_40":14,"_149":26,"_38":193,"_13":62,"_34":35,"_36":37,"_23":26,"_152":-5,"_180":194,"_27":195},{"_43":183,"_32":184,"_30":56,"_147":156,"_41":42,"_40":185,"_149":26,"_38":186,"_13":187,"_34":188,"_36":189,"_23":26,"_152":-5,"_180":190,"_27":191},{"_43":144,"_32":145,"_30":146,"_147":-5,"_41":42,"_40":148,"_149":24,"_38":179,"_13":62,"_34":20,"_36":151,"_23":26,"_152":-5,"_180":181,"_27":182},["D",1742612404852],"children",[],[145],"dd404bb8-0776-11f0-b7bc-569c3dd06744","index.ts",53,["D",1742686754788],25,"http","import { parseProject } from \"https://esm.town/v/std/parseImportMeta@149-main/project\";\nimport { readFile, servePublicFile } from \"https://esm.town/v/stevekrouse/utils@187-main/serve-public/index.ts\";\nimport { swaggerUI } from \"npm:@hono/swagger-ui\";\nimport { Hono } from \"npm:hono\";\nimport {\n createFriendRequest,\n deleteConversation,\n deleteRecording,\n deleteUser,\n getChatHistory,\n getConversationBetweenUsers,\n getFriendsList,\n getRecordingById,\n getRelationshipInfo,\n getSessionTranscript,\n getUserByEmail,\n getUserById,\n getUserRecordings,\n insertUser,\n listPendingRequests,\n saveRecording,\n searchUsers,\n sendMessage,\n updateConversation,\n updateFriendRequest,\n updateFriendRequestStatus,\n updateUser,\n} from \"./database/queries.ts\";\n\nconst app = new Hono();\napp.get(\"/ui\", swaggerUI({ url: \"/doc\" }));\napp.get(\"/\", async c => c.text(\"Server is up and running\"));\napp.get(\"/public/**/*\", c => servePublicFile(c.req.path.replace(\"/public\", \"/frontend\"), import.meta.url));\napp.get(\"/shared/**/*\", c => servePublicFile(c.req.path, import.meta.url));\n\n// AUTH\napp.post(\"/auth/signup\", async (c) => {\n const { firstName, lastName, email, password, systemPrompt, authType } = await c.req.json();\n const result = await insertUser(firstName, lastName, email, password, systemPrompt, authType);\n return c.json(result, \"error\" in result ? 400 : 200);\n});\n\napp.post(\"/auth/login\", async (c) => {\n const { email, password } = await c.req.json();\n const user = await getUserByEmail(email);\n if (\"error\" in user || user.password !== password) {\n return c.json({ error: \"Invalid credentials\" }, 401);\n }\n return c.json(user);\n});\n\napp.post(\"/auth/forgot-password\", async (c) => {\n const { email } = await c.req.json();\n // Simulated response\n return c.json({ message: `Password reset link sent to ${email}` });\n});\n\n// USERS\napp.get(\"/users/:uid\", async (c) => {\n const uid = c.req.param(\"uid\");\n const result = await getUserById(uid);\n return c.json(result, \"error\" in result ? 404 : 200);\n});\n\napp.get(\"/searchUsers\", async (c) => {\n const search = c.req.query(\"search\") || \"\";\n const result = await searchUsers(search);\n return c.json(result);\n});\n\napp.put(\"/users/:uid\", async (c) => {\n const uid = c.req.param(\"uid\");\n const { firstName, lastName, systemPrompt, authType } = await c.req.json();\n const result = await updateUser(uid, firstName, lastName, systemPrompt, authType);\n return c.json(result, \"error\" in result ? 400 : 200);\n});\n\n// CHATS\napp.post(\"/sendMessage\", async (c) => {\n const { from_id, to_id, message } = await c.req.json();\n const result = await sendMessage(from_id, to_id, message);\n return c.json(result, \"error\" in result ? 400 : 200);\n});\n\napp.get(\"/history\", async (c) => {\n const uid = c.req.query(\"uid\");\n const result = await getChatHistory(uid);\n return c.json(result, \"error\" in result ? 400 : 200);\n});\n\n// FRIENDS\napp.post(\"/updateFriendRequest\", async (c) => {\n const { from_id, to_id, status } = await c.req.json();\n const result = await updateFriendRequest(from_id, to_id, status);\n return c.json(result, \"error\" in result ? 400 : 200);\n});\n\napp.get(\"/friendsList\", async (c) => {\n const uid = c.req.query(\"uid\");\n const result = await getFriendsList(uid);\n return c.json(result, \"error\" in result ? 400 : 200);\n});\n\napp.post(\"/sendFriendRequest\", async (c) => {\n const { to_id, from_id, relationship_info } = await c.req.json();\n const result = await createFriendRequest(to_id, from_id, relationship_info);\n return c.json(result);\n});\n\napp.get(\"/friends/pending\", async (c) => {\n const userId = c.req.query(\"userId\");\n const result = await listPendingRequests(userId);\n return c.json(result, \"error\" in result ? 400 : 200);\n});\n\napp.patch(\"/friends/:request_id\", async (c) => {\n const request_id = c.req.param(\"request_id\");\n const { request_status } = await c.req.json();\n const result = await updateFriendRequestStatus(request_id, request_status);\n return c.json(result, \"error\" in result ? 400 : 200);\n});\n\n// RECORDINGS\napp.post(\"/recordings\", async (c) => {\n const { uid, recordingLocation } = await c.req.json();\n const result = await saveRecording(uid, recordingLocation);\n return c.json(result, \"error\" in result ? 400 : 201);\n});\n\napp.get(\"/recordings/:recording_id\", async (c) => {\n const recording_id = c.req.param(\"recording_id\");\n const result = await getRecordingById(recording_id);\n return c.json(result, \"error\" in result ? 404 : 200);\n});\napp.get(\"/userRecordings\", async (c) => {\n const uid = c.req.query(\"uid\");\n const result = await getUserRecordings(uid);\n return c.json(result, \"error\" in result ? 400 : 200);\n});\n\n// CONVERSATIONS\napp.get(\"/conversations\", async (c) => {\n const userId = c.req.query(\"userId\");\n const friendId = c.req.query(\"friendId\");\n const result = await getConversationBetweenUsers(userId, friendId);\n return c.json(result);\n});\n\napp.post(\"/conversations\", async (c) => {\n const { to_id, from_id, transcript } = await c.req.json();\n const result = await sendMessage(from_id, to_id, transcript);\n return c.json(result);\n});\n\napp.get(\"/conversations/:session_id\", async (c) => {\n const session_id = c.req.param(\"session_id\");\n const result = await getSessionTranscript(session_id);\n return c.json(result);\n});\n\napp.patch(\"/conversations/:session_id\", async (c) => {\n const session_id = c.req.param(\"session_id\");\n const { transcript } = await c.req.json();\n const result = await updateConversation(session_id, transcript);\n return c.json(result);\n});\n\napp.get(\"/sessionTranscript\", async (c) => {\n const session_id = c.req.query(\"session_id\");\n const result = await getSessionTranscript(session_id);\n return c.json(result, \"error\" in result ? 400 : 200);\n});\n\napp.get(\"/getUserById\", async (c) => {\n const uid = c.req.query(\"uid\");\n const result = await getUserById(uid);\n return c.json(result, \"error\" in result ? (result.error === \"User not found\" ? 404 : 400) : 200);\n});\n\napp.onError((err, c) => {\n throw err;\n});\n\nexport default app.fetch;",[],[155,184],"74f94b48-0778-11f0-8051-569c3dd06744",["D",1742687438834],[],[155,33],"c1430912-06c9-11f0-99ae-569c3dd06744","82750b47-9dd6-41a7-a7d5-75d456567d21",["D",1742612404852],"# Backend\n\nThis folder contains all backend-only code in this project. It's broken up into:\n\n* `index.ts` - this is the **entrypoint** for this whole project\n* `database/` - this contains the code for interfacing with the app's SQLite database table\n\n## Hono\n\nThis app uses [Hono](https://hono.dev/) as the API framework. You can think of Hono as a replacement for [ExpressJS](https://expressjs.com/) that works in serverless environments like Val Town or Cloudflare Workers. If you come from Python or Ruby, Hono is also a lot like [Flask](https://github.com/pallets/flask) or [Sinatra](https://github.com/sinatra/sinatra), respectively.\n\n## Serving assets to the frontend\n\nThis backend HTTP server is responsible for serving all static assets to the browser to render the app, including HTML, JavaScript (including all client-side React), CSS, and even the favicon SVG.\n\nIn a normal server environment, you would likely use a middleware [like this one](https://hono.dev/docs/getting-started/nodejs#serve-static-files) to serve static files. Some frameworks or deployment platforms automatically make any content inside a `public/` folder public. \n\nHowever in Val Town you need to handle this yourself, and it can be suprisingly difficult to read and serve files in a Val Town Project. This template uses helper functions from [stevekrouse/utils/serve-public](https://www.val.town/x/stevekrouse/utils/branch/main/code/serve-public/README.md), which handle reading project files in a way that will work across branches and forks, automatically transpiles typescript to javascript, and assigns content-types based on the file's extension.\n\n### `index.html`\n\nThe most complicated part of this backend API is serving index.html. In this app (like most apps) we serve it at the root, ie `GET /`. \n\nWe *bootstrap* `index.html` with some initial data from the server, so that it gets dynamically injected JSON data without having to make another round-trip request to the server to get that data on the frontend. This is a common pattern for client-side rendered apps.\n\n## CRUD API Routes\n\nThis app has two CRUD API routes: for reading and inserting into the messages table. They both speak JSON, which is standard. They import their functions from `/backend/database/queries.ts`. These routes are called from the React app to refresh and update data.\n\n## Errors\n\nHono and other API frameworks have a habit of swallowing up Errors. We turn off this default behavior by re-throwing errors, because we think most of the time you'll want to see the full stack trace instead of merely \"Internal Server Error\". You can customize how you want errors to appear.",[],[155,145],"d7a6a496-0775-11f0-a771-569c3dd06744","queries.ts","5951db31-6fbc-484c-b195-acc208c71ed5","803fd727-4664-4f25-b4f6-0f9b021c743a",48,["D",1742686315894],10,"import { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\nimport { CONVERSATIONS, createTables, FRIENDS, RECORDINGS, USERS } from \"./migrations.ts\";\n\n// =======================DO NOT TOUCH=====================================\nawait createTables();\n// ========================================================================\n\n// CHAT FUNCTIONS\n// Insert a message into the chat\nexport async function sendMessage(\n from_id: string,\n to_id: string,\n message: string,\n): Promise<{ reply: string } | { error: string }> {\n if (!from_id || !to_id || !message) {\n return { error: \"Missing chat parameters\" };\n }\n\n try {\n await sqlite.execute(\n `INSERT INTO ${CONVERSATIONS} (to_id, from_id, transcript) VALUES (?, ?, ?)`,\n [to_id, from_id, message],\n );\n return { reply: message };\n } catch (error) {\n console.error(\"Send Message Error:\", error);\n return { error: \"Internal Server Error\" };\n }\n}\n\nexport async function searchUsers(search: string): Promise {\n try {\n const { rows } = await sqlite.execute(\n `SELECT * FROM ${USERS} WHERE first_name LIKE ? OR last_name LIKE ? OR email LIKE ?`,\n [`%${search}%`, `%${search}%`, `%${search}%`],\n );\n return rows;\n } catch (err) {\n console.error(\"Search Users Error:\", err);\n return { error: \"Internal Server Error\" };\n }\n}\n\n// Fetch chat history for a user\nexport async function getChatHistory(uid: string): Promise {\n if (!uid) {\n return { error: \"Missing user ID\" };\n }\n\n try {\n const { rows } = await sqlite.execute(\n `SELECT * FROM ${CONVERSATIONS} WHERE to_id = ? OR from_id = ? ORDER BY session_id DESC`,\n [uid, uid],\n );\n return rows;\n } catch (error) {\n console.error(\"Get Chat History Error:\", error);\n return { error: \"Internal Server Error\" };\n }\n}\n\n// ===================================================================================\n// FRIENDS FUNCTIONS\n// Send or accept a friend request\nexport async function updateFriendRequest(\n from_id: string,\n to_id: string,\n status: string = \"Pending\",\n): Promise<{ success?: string; error?: string }> {\n if (!from_id || !to_id) {\n return { error: \"Missing user IDs\" };\n }\n\n try {\n if (status === \"Accepted\") {\n await sqlite.execute(\n `UPDATE ${FRIENDS} SET request_status = 'Accepted' WHERE to_id = ? AND from_id = ?`,\n [to_id, from_id],\n );\n } else {\n await sqlite.execute(\n `INSERT INTO ${FRIENDS} (to_id, from_id, request_status) VALUES (?, ?, 'Pending')`,\n [to_id, from_id],\n );\n }\n\n return { success: \"Friend request updated\" };\n } catch (err) {\n console.error(\"Friend Request Error:\", err);\n return { error: \"Internal Server Error\" };\n }\n}\n\n// Get a user's friends list\nexport async function getFriendsList(\n uid: string,\n): Promise {\n if (!uid) return { error: \"Missing user ID\" };\n\n try {\n const { rows } = await sqlite.execute(\n `SELECT f.request_id, f.to_id, f.from_id, f.request_status, u.first_name, u.last_name \n FROM ${FRIENDS} f\n JOIN app_users u ON (f.to_id = u.uid OR f.from_id = u.uid)\n WHERE (f.to_id = ? OR f.from_id = ?) AND f.request_status = 'Accepted'`,\n [uid, uid],\n );\n\n return rows;\n } catch (err) {\n console.error(\"Get Friends Error:\", err);\n return { error: \"Internal Server Error\" };\n }\n}\n\n// ==================================================================\n// RECORDINGS FUNCTIONS\n// Save a new recording\nexport async function saveRecording(\n uid: string,\n location: string,\n): Promise<{ success?: boolean; message?: string; error?: string }> {\n if (!uid || !location) {\n return { error: \"Missing parameters\" };\n }\n\n try {\n await sqlite.execute(\n `INSERT INTO ${RECORDINGS} (uid, recording_location) VALUES (?, ?)`,\n [uid, location],\n );\n return { success: true, message: \"Recording saved\" };\n } catch (err) {\n console.error(\"Save Recording Error:\", err);\n return { error: \"Internal Server Error\" };\n }\n}\n\n// Fetch recordings for a user\nexport async function getUserRecordings(\n uid: string,\n): Promise {\n if (!uid) {\n return { error: \"Missing user ID\" };\n }\n\n try {\n const { rows } = await sqlite.execute(\n `SELECT * FROM ${RECORDINGS} WHERE uid = ?`,\n [uid],\n );\n return rows;\n } catch (err) {\n console.error(\"Get Recordings Error:\", err);\n return { error: \"Internal Server Error\" };\n }\n}\n\nexport async function getRecordingById(\n recording_id: string,\n): Promise {\n try {\n const { rows } = await sqlite.execute(\n `SELECT * FROM ${RECORDINGS} WHERE recording_id = ?`,\n [recording_id],\n );\n return rows.length ? rows[0] : { error: \"Recording not found\" };\n } catch (err) {\n console.error(\"Get Recording By ID Error:\", err);\n return { error: \"Internal Server Error\" };\n }\n}\n\n// Fetch all messages for a given session ID\nexport async function getSessionTranscript(\n session_id: string,\n): Promise {\n if (!session_id) {\n return { error: \"Missing session ID\" };\n }\n\n try {\n const { rows } = await sqlite.execute(\n `SELECT * FROM ${CONVERSATIONS} WHERE session_id = ? ORDER BY session_id DESC`,\n [session_id],\n );\n return rows;\n } catch (err) {\n console.error(\"Get Session Transcript Error:\", err);\n return { error: \"Internal Server Error\" };\n }\n}\n\n// Fetch a user by their ID\nexport async function getUserById(\n uid: string,\n): Promise {\n if (!uid) {\n return { error: \"Missing user ID\" };\n }\n\n try {\n const { rows } = await sqlite.execute(\n `SELECT * FROM ${USERS} WHERE uid = ?`,\n [uid],\n );\n\n if (rows.length === 0) {\n return { error: \"User not found\" };\n }\n\n return rows[0];\n } catch (err) {\n console.error(\"Get User Error:\", err);\n return { error: \"Internal Server Error\" };\n }\n}\n\n// USER MANAGEMENT FUNCTIONS\nexport async function insertUser(\n first_name: string,\n last_name: string,\n email: string,\n password: string,\n system_prompt: string,\n auth_type: string,\n): Promise<{ success?: boolean; error?: string }> {\n try {\n await sqlite.execute(\n `INSERT INTO ${USERS} (first_name, last_name, email, password, system_prompt, auth_type)\n VALUES (?, ?, ?, ?, ?, ?)`,\n [first_name, last_name, email, password, system_prompt, auth_type],\n );\n return { success: true };\n } catch (err) {\n console.error(\"Insert User Error:\", err);\n return { error: \"Internal Server Error\" };\n }\n}\n\nexport async function getUserByEmail(email: string): Promise {\n try {\n const { rows } = await sqlite.execute(`SELECT * FROM ${USERS} WHERE email = ?`, [email]);\n return rows.length ? rows[0] : { error: \"User not found\" };\n } catch (err) {\n console.error(\"Get User By Email Error:\", err);\n return { error: \"Internal Server Error\" };\n }\n}\n\nexport async function updateUser(\n uid: string,\n first_name: string,\n last_name: string,\n system_prompt: string,\n auth_type: string,\n): Promise<{ success?: boolean; error?: string }> {\n try {\n await sqlite.execute(\n `UPDATE ${USERS} SET first_name = ?, last_name = ?, system_prompt = ?, auth_type = ? WHERE uid = ?`,\n [first_name, last_name, system_prompt, auth_type, uid],\n );\n return { success: true };\n } catch (err) {\n console.error(\"Update User Error:\", err);\n return { error: \"Internal Server Error\" };\n }\n}\n\nexport async function deleteUser(uid: string): Promise<{ success?: boolean; error?: string }> {\n try {\n await sqlite.execute(`DELETE FROM ${USERS} WHERE uid = ?`, [uid]);\n return { success: true };\n } catch (err) {\n console.error(\"Delete User Error:\", err);\n return { error: \"Internal Server Error\" };\n }\n}\n\n// RECORDINGS MANAGEMENT\nexport async function deleteRecording(recording_id: string): Promise<{ success?: boolean; error?: string }> {\n try {\n await sqlite.execute(`DELETE FROM ${RECORDINGS} WHERE recording_id = ?`, [recording_id]);\n return { success: true };\n } catch (err) {\n console.error(\"Delete Recording Error:\", err);\n return { error: \"Internal Server Error\" };\n }\n}\n\n// FRIENDS MANAGEMENT\nexport async function listPendingRequests(to_id: string): Promise {\n try {\n const { rows } = await sqlite.execute(\n `SELECT * FROM ${FRIENDS} WHERE to_id = ? AND request_status = 'Pending'`,\n [to_id],\n );\n return rows;\n } catch (err) {\n console.error(\"List Pending Requests Error:\", err);\n return { error: \"Internal Server Error\" };\n }\n}\n\nexport async function createFriendRequest(\n to_id: string,\n from_id: string,\n relationship_info: string,\n): Promise<{ success: boolean } | { error: string }> {\n try {\n await sqlite.execute(\n `INSERT INTO ${FRIENDS} (to_id, from_id, relationship_info, request_status) VALUES (?, ?, ?, 'Pending')`,\n [to_id, from_id, relationship_info],\n );\n return { success: true };\n } catch (err) {\n console.error(\"Create Friend Request Error:\", err);\n return { error: \"Internal Server Error\" };\n }\n}\n\nexport async function updateFriendRequestStatus(\n request_id: string,\n status: string,\n): Promise<{ success?: boolean; error?: string }> {\n try {\n await sqlite.execute(\n `UPDATE ${FRIENDS} SET request_status = ? WHERE request_id = ?`,\n [status, request_id],\n );\n return { success: true };\n } catch (err) {\n console.error(\"Update Friend Request Status Error:\", err);\n return { error: \"Internal Server Error\" };\n }\n}\n\nexport async function getRelationshipInfo(\n id1: string,\n id2: string,\n): Promise<{ relationship_info?: string; error?: string }> {\n try {\n const { rows } = await sqlite.execute(\n `SELECT relationship_info FROM ${FRIENDS} WHERE (to_id = ? AND from_id = ?) OR (to_id = ? AND from_id = ?)`,\n [id1, id2, id2, id1],\n );\n return rows.length ? { relationship_info: rows[0].relationship_info } : { error: \"No relationship found\" };\n } catch (err) {\n console.error(\"Get Relationship Info Error:\", err);\n return { error: \"Internal Server Error\" };\n }\n}\n\n// CONVERSATIONS MANAGEMENT\nexport async function updateConversation(\n session_id: string,\n transcript: string,\n): Promise<{ success?: boolean; error?: string }> {\n try {\n await sqlite.execute(\n `UPDATE ${CONVERSATIONS} SET transcript = ? WHERE session_id = ?`,\n [transcript, session_id],\n );\n return { success: true };\n } catch (err) {\n console.error(\"Update Conversation Error:\", err);\n return { error: \"Internal Server Error\" };\n }\n}\n\nexport async function getConversationBetweenUsers(id1: string, id2: string): Promise {\n try {\n const { rows } = await sqlite.execute(\n `SELECT * FROM ${CONVERSATIONS} WHERE (to_id = ? AND from_id = ?) OR (to_id = ? AND from_id = ?) ORDER BY conversation_dt DESC`,\n [id1, id2, id2, id1],\n );\n return rows;\n } catch (err) {\n console.error(\"Get Conversations Between Users Error:\", err);\n return { error: \"Internal Server Error\" };\n }\n}\n\nexport async function deleteConversation(session_id: string): Promise<{ success?: boolean; error?: string }> {\n try {\n await sqlite.execute(`DELETE FROM ${CONVERSATIONS} WHERE session_id = ?`, [session_id]);\n return { success: true };\n } catch (err) {\n console.error(\"Delete Conversation Error:\", err);\n return { error: \"Internal Server Error\" };\n }\n}",[],[155,212,203],"database","265fe988-0773-11f0-b98b-569c3dd06744","migrations.ts","d5cb44d0-1e2c-4286-ae1d-21e14e69d169",39,["D",1742685159482],15,"import { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\n\nexport const USERS = \"app_users\";\nexport const RECORDINGS = \"app_recordings\";\nexport const FRIENDS = \"app_friends\";\nexport const CONVERSATIONS = \"app_conversations\";\n\nexport async function createTables() {\n await sqlite.batch([\n `DROP TABLE IF EXISTS ${CONVERSATIONS}`,\n `DROP TABLE IF EXISTS ${FRIENDS}`,\n `DROP TABLE IF EXISTS ${RECORDINGS}`,\n `DROP TABLE IF EXISTS ${USERS}`,\n `PRAGMA foreign_keys = ON`,\n\n `CREATE TABLE IF NOT EXISTS ${USERS} (\n uid INTEGER PRIMARY KEY AUTOINCREMENT,\n first_name TEXT NOT NULL,\n last_name TEXT NOT NULL,\n email TEXT UNIQUE NOT NULL,\n password TEXT NOT NULL,\n system_prompt TEXT,\n auth_type TEXT\n )`,\n\n `CREATE TABLE IF NOT EXISTS ${RECORDINGS} (\n recording_id INTEGER PRIMARY KEY AUTOINCREMENT,\n uid INTEGER NOT NULL,\n recording_location TEXT NOT NULL,\n FOREIGN KEY (uid) REFERENCES ${USERS}(uid) ON DELETE CASCADE\n )`,\n\n `CREATE TABLE IF NOT EXISTS ${FRIENDS} (\n request_id INTEGER PRIMARY KEY AUTOINCREMENT,\n to_id INTEGER NOT NULL,\n from_id INTEGER NOT NULL,\n relationship_info TEXT,\n request_status TEXT CHECK(request_status IN ('Pending', 'Accepted', 'Denied')) NOT NULL,\n FOREIGN KEY (to_id) REFERENCES ${USERS}(uid) ON DELETE CASCADE,\n FOREIGN KEY (from_id) REFERENCES ${USERS}(uid) ON DELETE CASCADE\n )`,\n\n `CREATE TABLE IF NOT EXISTS ${CONVERSATIONS} (\n session_id INTEGER PRIMARY KEY AUTOINCREMENT,\n to_id INTEGER NOT NULL,\n from_id INTEGER NOT NULL,\n transcript TEXT NOT NULL,\n conversation_dt DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,\n FOREIGN KEY (to_id) REFERENCES ${USERS}(uid) ON DELETE CASCADE,\n FOREIGN KEY (from_id) REFERENCES ${USERS}(uid) ON DELETE CASCADE\n )`,\n\n // Dummy Users with different auth types\n `INSERT INTO ${USERS} (first_name, last_name, email, password, system_prompt, auth_type) VALUES\n ('Alice', 'Smith', 'alice@example.com', 'hashed_pw1', 'Be concise.', 'local'),\n ('Bob', 'Jones', 'bob@example.com', 'hashed_pw2', 'Explain in detail.', 'google'),\n ('Carol', 'White', 'carol@example.com', 'hashed_pw3', 'Use simple words.', 'github'),\n ('Dave', 'Lee', 'dave@example.com', 'hashed_pw4', 'Be friendly.', 'local'),\n ('Eve', 'Brown', 'eve@example.com', 'hashed_pw5', 'Ask questions.', 'linkedin')`,\n\n // Dummy Recordings\n `INSERT INTO ${RECORDINGS} (uid, recording_location) VALUES\n (1, '/rec/alice-1.mp3'),\n (1, '/rec/alice-2.mp3'),\n (2, '/rec/bob-1.mp3'),\n (4, '/rec/dave-1.mp3'),\n (5, '/rec/eve-1.mp3')`,\n\n // Dummy Friends with different statuses\n `INSERT INTO ${FRIENDS} (to_id, from_id, relationship_info, request_status) VALUES\n (1, 2, 'Colleague', 'Pending'),\n (2, 3, 'Old friend', 'Accepted'),\n (3, 1, 'Gaming buddy', 'Accepted'),\n (4, 1, 'Neighbor', 'Denied'),\n (5, 3, 'Project mate', 'Pending')`,\n\n // Dummy Conversations with implicit timestamps\n `INSERT INTO ${CONVERSATIONS} (to_id, from_id, transcript) VALUES\n (2, 1, 'Hey Bob, how are you?'),\n (3, 1, 'Hi Carol, long time no see.'),\n (1, 3, 'Hey Alice, Im back!'),\n (1, 4, 'Hey Alice, got time to chat?'),\n (5, 3, 'Carol, we need to finish our project.')`,\n ]);\n}",[],[155,212,214],"c142fe04-06c9-11f0-99ae-569c3dd06744","6472ad89-f1b4-4df6-89b7-01c5eab403a3",["D",1742612404852],"# Database\n\nThis app uses [Val Town SQLite](https://docs.val.town/std/sqlite/) to manage data. Every Val Town account comes with a free SQLite database, hosted on [Turso](https://turso.tech/). This folder is broken up into two files:\n\n* `migrations.ts` - code to set up the database tables the app needs\n* `queries.ts` - functions to run queries against those tables, which are imported and used in the main Hono server in `/backend/index.ts`\n\n## Migrations\n\nIn `backend/database/migrations.ts`, this app creates a new SQLite table `reactHonoStarter_messages` to store messages. \n\nThis \"migration\" runs once on every app startup because it's imported in `index.ts`. You can comment this line out for a slight (30ms) performance improvement on cold starts. It's left in so that users who fork this project will have the migration run correctly.\n\nSQLite has much more limited support for altering existing tables as compared to other databases. Often it's easier to create new tables with the schema you want, and then copy the data over. Happily LLMs are quite good at those sort of database operations, but please reach out in the [Val Town Discord](https://discord.com/invite/dHv45uN5RY) if you need help.\n\n## Queries\n\nThe queries file is where running the migrations happen in this app. It'd also be reasonable for that to happen in index.ts, or as is said above, for that line to be commented out, and only run when actual changes are made to your database schema.\n\nThe queries file exports functions to get and write data. It relies on shared types and data imported from the `/shared` directory.",[],[155,212,145],"c1430778-06c9-11f0-99ae-569c3dd06744",["D",1742612404852],[172,173,174],[155,212],["D",1742612404852],[171,175,176,177],[155],["D",1742612404852],{"_100":99,"_107":103},{"_100":99,"_101":-5,"_102":103,"_18":54,"_104":105,"_106":26},{"_13":85,"_32":86,"_43":42,"_87":44,"_88":89,"_90":91,"_92":50,"_93":94,"_95":96,"_97":45,"_98":99},"ctx",{"_78":-5,"_128":272,"_273":274,"_275":276,"_277":26,"_278":26,"_279":26,"_280":24,"_281":-5,"_282":-7,"_283":-7,"_284":62,"_285":26,"_286":26,"_287":-5,"_288":26,"_289":26,"_290":26,"_291":-5},"ENV",{"_243":244,"_245":246,"_247":86,"_248":249,"_250":251,"_252":253,"_254":255,"_256":257,"_258":259,"_260":261,"_262":263,"_264":265,"_266":267,"_268":269,"_270":271},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","fdb67791413f4386b4dbf18f354029a617f6160f","RENDER_GIT_BRANCH","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","VANITY_WEB_API_TEMPLATE","https://{label}.val.run/","DENOLS_URL","https://lsp.val.town","NODE_ENV","production","CLOUDFLARE_TURNSTILE_SITE_KEY","0x4AAAAAACtaIZJH7s9rBMZ6","GOOGLE_CLIENT_ID","875989696899-jtsqkhlbdv5jrlsk8631p7ipjg3c6o62.apps.googleusercontent.com","STRIPE_PUBLISHABLE_KEY","pk_live_51N2zvWEpZTTLipIkVEwXrUG9AT0yeOOEYxszarZT1jpsZV58Ly6wlg3SltZpHN26CUalOBmUSY7adQRQiSkCZz2500qSXNkf8Y","API_URL","https://api.val.town",[],"preferencesKeybindings","default","preferencesTheme","light","preferencesFixers","preferencesCopilot","preferencesSelectionAi","preferencesCloseBrackets","preferencesChatPanelState","preferencesDprint","preferencesDenofmt","notificationCount","flagDenols","isBusinessOrgMember","businessOrgHandle","isBusinessOrgAdmin","isHigherTownieTier","navCollapsed","currentOrgId"]

Diff · v54