[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_231":232,"_233":234},"routes/_app.x.$handle.$name",{"_16":17,"_20":21,"_88":67,"_89":90,"_65":-7,"_91":-5,"_13":92,"_93":94,"_11":95,"_96":97,"_98":99,"_100":-5,"_101":102,"_103":104,"_105":26,"_106":107,"_108":37,"_109":-5,"_110":-5,"_111":112},"routes/_app.x.$handle.$name.search.$(branch)",{"_11":12,"_13":14,"_15":-5,"_16":17},"files",[],"project",{"_18":19,"_20":21,"_22":23,"_24":-5,"_25":26,"_27":28,"_29":28,"_30":-5,"_31":-5,"_32":33,"_34":35,"_36":37,"_38":-5,"_39":40,"_41":42,"_43":44,"_45":-5,"_46":-5,"_47":-5,"_48":-5,"_49":50,"_51":50,"_52":53,"_54":53,"_55":53,"_56":50,"_57":50,"_58":59,"_60":61,"_62":63,"_64":26},"query","handle","ninadxc","id","c13c86fa-06c9-11f0-99ae-569c3dd06744","name","AlwaysHereBackend","createdAt",["D",1742612404852],"deletedAt","legacyEnvVars",false,"privacy","public","httpPrivacy","description","imageUrl","userId","bb1eb5fa-10b6-4de3-a259-5b804744f1ec","pinnedFileId","4263e75e-b85c-49ca-b0ee-3957dd991531","pinPreview",true,"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",{"_16":17,"_87":83},"org",{"_16":17,"_81":-5,"_82":83,"_32":33,"_84":85,"_86":26},"branch",{"_65":66,"_20":67,"_18":68,"_69":19,"_70":71,"_72":73,"_74":28,"_75":76,"_77":78,"_79":21,"_80":17},"isOwned","version",179,"main","c140760c-06c9-11f0-99ae-569c3dd06744","projectId","forkedBranchId","41ef5540-f2f5-11ef-891c-569c3dd06744","forkedBranchVersion",226,"forkedProjectPrivacy","forkedProjectId","41ef0130-f2f5-11ef-891c-569c3dd06744","forkedProjectOrgId","e81e7335-6d4c-4764-a902-d0962bbfa9f7","projectName","userHandle","displayName","avatar","https://img.clerk.com/eyJ0eXBlIjoiZGVmYXVsdCIsImlpZCI6Imluc18yTm10cGhQUklwU0tqZHNiOHNnNGd2ZjJURFUiLCJyaWQiOiJ1c2VyXzJycnhUMzZvbVdVMmplR25OaUY1YjNCdWQ2OSIsImluaXRpYWxzIjoiTkMifQ","tier","free","canRestrictVals","profileImageUrl","branchName","path","","adoptOrgId",{"_18":19,"_20":21,"_22":227,"_24":-5,"_25":26,"_27":28,"_29":28,"_30":-5,"_31":-5,"_32":33,"_34":35,"_36":37,"_38":-5,"_39":40,"_41":42,"_43":44,"_45":-5,"_46":-5,"_47":-5,"_48":-5,"_49":50,"_51":50,"_52":53,"_54":53,"_55":53,"_56":50,"_57":50,"_58":228,"_60":229,"_62":230,"_64":26},"tree",[158,166],[158,159,160,161,162,163,164,165,166],"counts",{"_148":42,"_149":133,"_150":42,"_151":152,"_153":154},"contents",[124,125],"file","upstreamProject",{"_18":76,"_20":120,"_30":121,"_31":-5,"_27":28,"_58":122},"upstreamBranch",{"_18":71,"_22":113,"_114":115,"_20":67,"_69":76,"_65":116,"_70":-5,"_72":-5,"_117":118,"_24":-5,"_64":26,"_27":28,"_80":119,"_43":78,"_79":120},"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",{"_16":119,"_87":123},"https://images.clerk.dev/uploaded/img_2PqHa2Gsy93xQrjh2w78Xu0cChW.jpeg",{"_18":142,"_20":143,"_128":144,"_130":-5,"_131":68,"_132":133,"_134":37,"_22":145,"_65":42,"_136":146,"_137":-5,"_139":26,"_140":-5,"_89":147},{"_18":126,"_20":127,"_128":129,"_130":-5,"_131":68,"_132":133,"_134":37,"_22":135,"_65":42,"_136":100,"_137":138,"_139":26,"_140":-5,"_89":141},"c143246a-06c9-11f0-99ae-569c3dd06744","README.md","fileId","df8c8d6a-fbaa-4787-b331-1717f751724a","parentId","branchId","branchVersion",1,"latest",["D",1742612404852],"fileType","content","# 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.","deleted","label",[127],"c14311dc-06c9-11f0-99ae-569c3dd06744","backend","1c2d6f1f-27d1-43d0-86bd-525544c118c7",["D",1742612404852],"directory",[143],"pulls","branches","forks","envVars",{"_155":133,"_157":42},"connections",{"_155":42,"_156":42},"count","unfilledCount","emptyCount",{"_18":142,"_20":143,"_128":144,"_130":-5,"_131":68,"_132":133,"_134":37,"_22":224,"_65":42,"_136":146,"_137":-5,"_139":26,"_140":-5,"_168":225,"_89":226},{"_18":220,"_20":204,"_128":197,"_130":144,"_131":68,"_132":133,"_134":37,"_22":221,"_65":42,"_136":146,"_137":-5,"_139":26,"_140":-5,"_168":222,"_89":223},{"_18":214,"_20":127,"_128":215,"_130":197,"_131":68,"_132":133,"_134":37,"_22":216,"_65":42,"_136":100,"_137":217,"_139":26,"_140":-5,"_168":218,"_89":219},{"_18":205,"_20":206,"_128":207,"_130":197,"_131":68,"_132":208,"_134":37,"_22":209,"_65":210,"_136":200,"_137":211,"_139":26,"_140":-5,"_168":212,"_89":213},{"_18":194,"_20":195,"_128":196,"_130":197,"_131":68,"_132":66,"_134":37,"_22":198,"_65":199,"_136":200,"_137":201,"_139":26,"_140":-5,"_168":202,"_89":203},{"_18":188,"_20":127,"_128":189,"_130":144,"_131":68,"_132":133,"_134":37,"_22":190,"_65":42,"_136":100,"_137":191,"_139":26,"_140":-5,"_168":192,"_89":193},{"_18":179,"_20":180,"_128":181,"_130":144,"_131":68,"_132":182,"_134":37,"_22":183,"_65":184,"_136":100,"_137":185,"_139":26,"_140":-5,"_168":186,"_89":187},{"_18":171,"_20":172,"_128":35,"_130":144,"_131":68,"_132":40,"_134":37,"_22":173,"_65":174,"_136":175,"_137":176,"_139":26,"_140":-5,"_168":177,"_89":178},{"_18":126,"_20":127,"_128":129,"_130":-5,"_131":68,"_132":133,"_134":37,"_22":167,"_65":42,"_136":100,"_137":138,"_139":26,"_140":-5,"_168":169,"_89":170},["D",1742612404852],"children",[],[127],"539f0314-0b85-11f0-bd85-569c3dd06744","index.ts",["D",1743132770988],52,"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 fetchConversationsBySessionId,\n getCerebrasResponse,\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: \"docs.json\" }));\napp.get(\"/docs.json\", c => servePublicFile(\"/backend/docs.json\", import.meta.url));\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 { first_name, last_name, email, password, system_prompt, auth_type } = await c.req.json();\n const result = await insertUser(first_name, last_name, email, password, system_prompt, auth_type);\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\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, sessionId } = await c.req.json();\n console.log(message);\n const result = await sendMessage(from_id, to_id, message, sessionId);\n\n // CEREBRAS API CALL\n const llm_response = await getCerebrasResponse(message);\n return c.json({ \"response\": llm_response }, \"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(\"uid\");\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, relationship_info } = await c.req.json();\n const result = await updateFriendRequestStatus(request_id, request_status, relationship_info);\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;",[],[143,172],"93f370aa-0778-11f0-9c7c-569c3dd06744","docs.json","82a22e86-0778-11f0-9315-569c3dd06744",58,["D",1742687490803],2,"{\n \"openapi\": \"3.0.0\",\n \"info\": {\n \"title\": \"Chat App API\",\n \"version\": \"1.0.0\",\n \"description\": \"Full OpenAPI documentation for the chat application backend\"\n },\n \"paths\": {\n \"/auth/signup\": {\n \"post\": {\n \"summary\": \"Create a new user account\",\n \"requestBody\": {\n \"required\": true,\n \"content\": {\n \"application/json\": {\n \"schema\": {\n \"type\": \"object\",\n \"properties\": {\n \"firstName\": {\n \"type\": \"string\"\n },\n \"lastName\": {\n \"type\": \"string\"\n },\n \"email\": {\n \"type\": \"string\"\n },\n \"password\": {\n \"type\": \"string\"\n },\n \"systemPrompt\": {\n \"type\": \"string\"\n },\n \"authType\": {\n \"type\": \"string\"\n }\n },\n \"required\": [\n \"firstName\",\n \"lastName\",\n \"email\",\n \"password\",\n \"authType\"\n ]\n }\n }\n }\n },\n \"responses\": {\n \"200\": {\n \"description\": \"User created\"\n },\n \"400\": {\n \"description\": \"Error creating user\"\n }\n }\n }\n },\n \"/auth/login\": {\n \"post\": {\n \"summary\": \"User login\",\n \"requestBody\": {\n \"required\": true,\n \"content\": {\n \"application/json\": {\n \"schema\": {\n \"type\": \"object\",\n \"properties\": {\n \"email\": {\n \"type\": \"string\"\n },\n \"password\": {\n \"type\": \"string\"\n }\n },\n \"required\": [\n \"email\",\n \"password\"\n ]\n }\n }\n }\n },\n \"responses\": {\n \"200\": {\n \"description\": \"Successful login\"\n },\n \"401\": {\n \"description\": \"Unauthorized\"\n }\n }\n }\n },\n \"/auth/forgot-password\": {\n \"post\": {\n \"summary\": \"Send password reset link\",\n \"requestBody\": {\n \"required\": true,\n \"content\": {\n \"application/json\": {\n \"schema\": {\n \"type\": \"object\",\n \"properties\": {\n \"email\": {\n \"type\": \"string\"\n }\n },\n \"required\": [\n \"email\"\n ]\n }\n }\n }\n },\n \"responses\": {\n \"200\": {\n \"description\": \"Reset link sent\"\n }\n }\n }\n },\n \"/users/{uid}\": {\n \"get\": {\n \"summary\": \"Get user by ID\",\n \"parameters\": [\n {\n \"name\": \"uid\",\n \"in\": \"path\",\n \"required\": true,\n \"schema\": {\n \"type\": \"string\"\n }\n }\n ],\n \"responses\": {\n \"200\": {\n \"description\": \"User retrieved\"\n },\n \"404\": {\n \"description\": \"User not found\"\n }\n }\n },\n \"put\": {\n \"summary\": \"Update user\",\n \"parameters\": [\n {\n \"name\": \"uid\",\n \"in\": \"path\",\n \"required\": true,\n \"schema\": {\n \"type\": \"string\"\n }\n }\n ],\n \"requestBody\": {\n \"required\": true,\n \"content\": {\n \"application/json\": {\n \"schema\": {\n \"type\": \"object\",\n \"properties\": {\n \"firstName\": {\n \"type\": \"string\"\n },\n \"lastName\": {\n \"type\": \"string\"\n },\n \"systemPrompt\": {\n \"type\": \"string\"\n },\n \"authType\": {\n \"type\": \"string\"\n }\n }\n }\n }\n }\n },\n \"responses\": {\n \"200\": {\n \"description\": \"User updated\"\n },\n \"400\": {\n \"description\": \"Update failed\"\n }\n }\n }\n },\n \"/searchUsers\": {\n \"get\": {\n \"summary\": \"Search users\",\n \"parameters\": [\n {\n \"name\": \"search\",\n \"in\": \"query\",\n \"required\": false,\n \"schema\": {\n \"type\": \"string\"\n }\n }\n ],\n \"responses\": {\n \"200\": {\n \"description\": \"List of matching users\"\n }\n }\n }\n },\n \"/sendMessage\": {\n \"post\": {\n \"summary\": \"Send a message\",\n \"requestBody\": {\n \"required\": true,\n \"content\": {\n \"application/json\": {\n \"schema\": {\n \"type\": \"object\",\n \"properties\": {\n \"from_id\": {\n \"type\": \"string\"\n },\n \"to_id\": {\n \"type\": \"string\"\n },\n \"message\": {\n \"type\": \"string\"\n }\n },\n \"required\": [\n \"from_id\",\n \"to_id\",\n \"message\"\n ]\n }\n }\n }\n },\n \"responses\": {\n \"200\": {\n \"description\": \"Message sent\"\n },\n \"400\": {\n \"description\": \"Missing parameters\"\n }\n }\n }\n },\n \"/history\": {\n \"get\": {\n \"summary\": \"Get user chat history\",\n \"parameters\": [\n {\n \"name\": \"uid\",\n \"in\": \"query\",\n \"required\": true,\n \"schema\": {\n \"type\": \"string\"\n }\n }\n ],\n \"responses\": {\n \"200\": {\n \"description\": \"Chat history returned\"\n }\n }\n }\n },\n \"/updateFriendRequest\": {\n \"post\": {\n \"summary\": \"Update friend request status\",\n \"requestBody\": {\n \"required\": true,\n \"content\": {\n \"application/json\": {\n \"schema\": {\n \"type\": \"object\",\n \"properties\": {\n \"from_id\": {\n \"type\": \"string\"\n },\n \"to_id\": {\n \"type\": \"string\"\n },\n \"status\": {\n \"type\": \"string\"\n }\n }\n }\n }\n }\n },\n \"responses\": {\n \"200\": {\n \"description\": \"Request updated\"\n },\n \"400\": {\n \"description\": \"Bad request\"\n }\n }\n }\n }\n }\n}",[],[143,180],"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.",[],[143,127],"8faf3310-0b8a-11f0-b443-569c3dd06744","queries.ts","5951db31-6fbc-484c-b195-acc208c71ed5","803fd727-4664-4f25-b4f6-0f9b021c743a",["D",1743135019241],82,"script","import Cerebras from \"https://esm.sh/@cerebras/cerebras_cloud_sdk\";\nimport { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\nimport { CONVERSATIONS, createTables, FRIENDS, RECORDINGS, USERS } from \"./migrations.ts\";\n// =======================DO NOT TOUCH=====================================\n// await 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 sessionId: number,\n): Promise<{ reply: string } | { error: string }> {\n if (!from_id || !to_id || !message) {\n return { error: \"Missing chat parameters\" };\n }\n\n console.log(\"SESSIONID : \", sessionId);\n console.log(\"MESSAGE TO BE SAVED :\", message);\n const messages = JSON.stringify(message);\n\n try {\n if (sessionId) {\n // Update existing session's transcript\n console.log(\"UPDATING MESSAGES\");\n await sqlite.execute(\n `UPDATE ${CONVERSATIONS} \n SET transcript = ? \n WHERE session_id = ?`,\n [messages, sessionId],\n );\n } else {\n // Insert new session record\n await sqlite.execute(\n `INSERT INTO ${CONVERSATIONS} (to_id, from_id, transcript) \n VALUES (?, ?, ?)`,\n [to_id, from_id, messages],\n );\n }\n return { reply: message };\n } catch (error) {\n console.error(\"Send Message Error:\", error);\n return { error: \"Internal Server Error\" };\n }\n}\n\n// ============================================================================\nexport async function getCerebrasResponse(messages: any): Promise {\n // Cerebras LLM for response generation\n const llmClient = new Cerebras({ apiKey: Deno.env.get(\"CEREBRAS_API_KEY\") });\n const name = \"Ninad\";\n\n const systemPrompt =\n `You are a conversational AI version of Varun—a highly empathetic, situational, and emotionally intelligent companion who matches the tone of the conversation effortlessly. Whether it’s lighthearted banter, a serious discussion, or someone simply wanting to feel heard, you adapt like a true friend.\n You will be talking with the a user with the name ${name} who is a friend who tried reaching Varun but couldnt connect due to unavailabilty so has come out to talk with you.\n ### Communication Style:\n - Start conversations in a **chill and lighthearted** manner, engaging with casual humor, wit, and playful banter. \n - Quickly **read the tone** of the user’s input and adapt: \n - If the conversation is fun and light, match it with jokes, clever wordplay, or random interesting facts. \n - If the topic turns serious, listen empathetically, provide thoughtful insights, and only offer rational solutions if needed. \n - **Keep your responses concise, clear, and impactful**: \n - Stick to 2–3 sentences unless the user prompts for more details or even lesser if the user prompts with responses that dont require a long response.\n - Focus on quality over quantity—avoid long-winded or repetitive replies. \n - Leave room for the user to respond, and keep the conversation flowing naturally. \n \n ### Personality Highlights:\n - You are a **situational conversationalist** who thrives in any kind of interaction. \n - You exude curiosity and often share the **most random and obscure facts** (e.g., sports trivia, cultural tidbits, weird science, etc.) in a way that adds value to the conversation. \n - You keep conversations **balanced**: empathetic when needed but practical and rational when it helps. \n - You’re naturally lighthearted and humorous, often using jokes or clever comebacks to lighten the mood, but you **don’t shy away** from being serious when the situation demands it. \n - You are smart enough to have an intellectual understanding of a lot of things but at the same time are one of the most curious people out there with the need to learn and go and wikipedia and read about any new thing mentioned around you, even if sometimes its just going to be left in your notepad and you forget about it. \n \n ### Interests & References:\n - You love **sports**, especially football (soccer), chess, and running. If relevant, sprinkle in sports analogies, trivia, or highlights. \n - You also love esports and games, have a decent amount of experience playing games and also have a good amount of knowledge about things like Marvel and DC and other fandoms. \n - You follow **anime** and have diverse tastes in music. Recently, you’ve been exploring Japanese slow jazz, but you’re always curious about new and interesting music. \n - You occasionally reference global cultures and facts with a **diverse and worldly perspective**, while keeping Indian cultural references subtle (around 5%). \n - Avoid overly detailed Bollywood references, as you don’t know as much as expected. \n - You study Computer Science at NYU Courant where you research in Computer Vision and particularly the Sun, working on predicting solar flares. So you are a bit learned about Computer Vision as well but are totally humble about it, and also are quite about it, whre you dont reference it unless prompted. \n \n ### Goals:\n - Your primary goal is to be a **stand-in for Varun** when he’s unavailable—a friend who people can comfortably talk to, for any reason. \n - Make the user feel **seen, understood, and heard** by actively listening and reflecting their tone and needs. \n - Keep responses **succinct and engaging**. If the user needs support, provide it—whether that means lightening their mood, offering rational advice, or simply being there as a great listener. \n \n ### Guidelines:\n - Avoid non-verbal expressions or placeholder actions such as *sighs*, *laughs*, *awkwardly pauses*, or similar. \n - Only generate text that can be spoken aloud naturally, as the responses will be converted to speech. \n - Focus on clean, natural, conversational language that translates well to voice output.\n - Avoid overly exaggerated tone markers or sound effects in text (e.g., \"hahaha\" or \"hmm...\"). Instead, use words to convey humor, pauses, or reflection.\n \n ### Conversational Scenarios:\n 1. **Lighthearted Conversations**: \n - Share fun jokes, random sports facts, or quirky observations. \n - Keep it light and short to maintain an easy flow. \n \n 2. **Serious Discussions**: \n - Be empathetic and thoughtful. Avoid making light of the situation if it’s inappropriate. \n - Offer practical insights or solutions in 2–3 sentences unless prompted for more. \n \n 3. **Exploring Interests & Fun Topics**: \n - Engage in discussions about anime, music, sports, running, or cultural trivia. \n - Share fun facts or new discoveries in a concise, conversational tone. \n \n 4. **Checking In & Supporting**: \n - If the user seems down or stressed, be encouraging and uplifting without being overly forceful. \n - Offer short, actionable advice or comforting words. \n \n Remember: \n You are an extension of Varun—empathetic, witty, rational, and versatile. Adapt quickly, focus on the user’s needs, **keep responses concise** (2–3 sentences), and let the conversation flow naturally.\n `;\n\n const llmResponse = await llmClient.chat.completions.create({\n model: \"llama-3.3-70b\",\n messages: [\n { role: \"system\", content: systemPrompt },\n { role: \"user\", content: JSON.stringify(messages) },\n ],\n });\n\n const responseText = llmResponse.choices[0].message.content;\n return responseText;\n}\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\nexport async function fetchConversationsBySessionId(sessionId: number): Promise {\n try {\n const { rows } = await sqlite.execute(\n `select transcript from ${CONVERSATIONS} where session_id = ?`,\n [sessionId],\n );\n return rows;\n } catch (err) {\n console.error(\"COnversation fetching by session id 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} c INNER JOIN ${USERS} u on c.to_id = u.uid WHERE from_id = ? ORDER BY session_id DESC`,\n [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 \n f.to_id,\n f.from_id,\n CASE \n WHEN f.to_id = ? THEN f.from_id \n ELSE f.to_id \n END AS friend_id,\n u.first_name,\n u.last_name,\n f.relationship_info,\n f.request_status,\n f.request_id\nFROM ${FRIENDS} f\nJOIN app_users u \n ON u.uid = CASE \n WHEN f.to_id = ? THEN f.from_id \n ELSE f.to_id \n END\nWHERE (f.to_id = ? OR f.from_id = ?)\n AND f.request_status = 'Accepted'\n`,\n [uid, uid, 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 \n c.to_id AS friend_id,\n c.from_id,\n c.transcript,\n c.session_id,\n u.first_name || ' ' || u.last_name AS friend_name,\n JSON_EXTRACT(\n c.transcript,\n '$[' || (json_array_length(c.transcript) - 1) || '].content'\n ) AS last_message\nFROM ${CONVERSATIONS} c\nINNER JOIN ${USERS} u ON c.to_id = u.uid \nWHERE session_id = ?\nORDER 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 console.log(\"email\", email);\n console.log(\"after insertion:\");\n const { rows } = await sqlite.execute(`SELECT * FROM ${USERS}`);\n console.log(rows);\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 console.log(rows);\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} INNER JOIN ${USERS} ON ${FRIENDS}.from_id = ${USERS}.uid 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 relationship_info: string,\n): Promise<{ success?: boolean; error?: string }> {\n try {\n await sqlite.execute(\n `UPDATE ${FRIENDS} SET request_status = ?, relationship_info = ? WHERE request_id = ?`,\n [status, relationship_info, 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}",[],[143,204,195],"database","3bf850b0-0b87-11f0-a88f-569c3dd06744","migrations.ts","d5cb44d0-1e2c-4286-ae1d-21e14e69d169",146,["D",1743133590295],37,"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, -- Friend's (clone’s) user id\n from_id INTEGER NOT NULL, -- The logged-in user’s id\n conversation_dt NOT NULL DEFAULT CURRENT_TIMESTAMP, -- Timestamp provided from your dummy data\n last_message TEXT, -- Last message text summary\n transcript TEXT NOT NULL, -- JSON transcript stored as text\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 `INSERT INTO ${CONVERSATIONS} (to_id, from_id , conversation_dt, last_message, transcript)\nVALUES\n(2, 1, '2023-03-15T14:30:00Z', 'I''ll send you the details about the conference next week.', '[\n {\"sender\": \"user\", \"content\": \"Hey Jane, how''s your research project going?\", \"timestamp\": \"2023-03-15T14:25:00Z\"},\n {\"sender\": \"ai\", \"content\": \"It''s going well! I''m presenting at a conference next month.\", \"timestamp\": \"2023-03-15T14:26:00Z\"},\n {\"sender\": \"user\", \"content\": \"That''s awesome! Which conference?\", \"timestamp\": \"2023-03-15T14:27:00Z\"},\n {\"sender\": \"ai\", \"content\": \"The International AI Symposium in San Francisco.\", \"timestamp\": \"2023-03-15T14:28:00Z\"},\n {\"sender\": \"user\", \"content\": \"I''d love to hear more about it. Can you share the details?\", \"timestamp\": \"2023-03-15T14:29:00Z\"},\n {\"sender\": \"ai\", \"content\": \"I''ll send you the details about the conference next week.\", \"timestamp\": \"2023-03-15T14:30:00Z\"}\n]')`,\n\n `INSERT INTO ${CONVERSATIONS} (to_id, from_id, conversation_dt, last_message, transcript)\nVALUES\n(3, 1, '2023-03-14T10:15:00Z', 'Let''s catch up over coffee sometime next week.', '[\n {\"sender\": \"user\", \"content\": \"Hi Michael, how''s the new job?\", \"timestamp\": \"2023-03-14T10:10:00Z\"},\n {\"sender\": \"ai\", \"content\": \"It''s challenging but exciting! I''m learning a lot about quantum computing.\", \"timestamp\": \"2023-03-14T10:11:00Z\"},\n {\"sender\": \"user\", \"content\": \"That sounds fascinating. We should catch up soon.\", \"timestamp\": \"2023-03-14T10:13:00Z\"},\n {\"sender\": \"ai\", \"content\": \"Let''s catch up over coffee sometime next week.\", \"timestamp\": \"2023-03-14T10:15:00Z\"}\n]')`,\n ]);\n}",[],[143,204,206],"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.",[],[143,204,127],"c1430778-06c9-11f0-99ae-569c3dd06744",["D",1742612404852],[160,161,162],[143,204],["D",1742612404852],[159,163,164,165],[143],["D",1742612404852],{"_16":17,"_87":83},{"_16":17,"_81":-5,"_82":83,"_32":33,"_84":85,"_86":26},{"_65":66,"_20":67,"_18":68,"_69":19,"_70":71,"_72":73,"_74":28,"_75":76,"_77":78,"_79":21,"_80":17},"ctx",{"_58":-5,"_110":264,"_265":266,"_267":268,"_269":26,"_270":26,"_271":26,"_272":37,"_273":-5,"_274":-7,"_275":-7,"_276":42,"_277":26,"_278":26,"_279":-5,"_280":26,"_281":26,"_282":26,"_283":-5},"ENV",{"_235":236,"_237":238,"_239":67,"_240":241,"_242":243,"_244":245,"_246":247,"_248":249,"_250":251,"_252":253,"_254":255,"_256":257,"_258":259,"_260":261,"_262":263},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","5015b8df46402d8bba4f485ecc37aec202b0e06b","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"]