[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_363":364,"_365":366},"routes/_app.x.$handle.$name",{"_11":12,"_13":14,"_15":16,"_210":211,"_33":-7,"_212":-5,"_17":213,"_214":215,"_216":217,"_218":219,"_220":221,"_47":-5,"_222":223,"_224":225,"_226":24,"_227":228,"_229":166,"_230":-5,"_231":-5,"_232":233},"routes/_app.x.$handle.$name.branch.$branch.history",{"_11":12,"_13":14,"_15":16,"_17":18,"_19":20,"_21":22,"_23":24,"_25":-5},"handle","dk3","name","HONC","branchName","main","project",{"_27":154,"_13":14,"_31":155,"_156":-5,"_157":24,"_158":159,"_160":159,"_161":162,"_163":-5,"_25":80,"_164":151,"_165":166,"_167":-5,"_168":-5,"_169":20,"_35":36,"_170":171,"_172":173,"_174":175,"_176":-5,"_177":178,"_179":178,"_180":181,"_182":181,"_183":181,"_184":178,"_185":178,"_45":186,"_187":188,"_189":190,"_191":24},"page",0,"history",[26],"hasNext",false,"userId",{"_27":28,"_29":30,"_31":32,"_33":34,"_35":36,"_37":-5,"_38":-5,"_39":-5,"_40":-5,"_41":-5,"_42":-5,"_43":-5,"_44":-5,"_45":46,"_47":48,"_49":-5,"_50":-5,"_51":-5,"_52":53,"_54":55},"id","59bddbda-d286-11f0-8f85-42dde27851f2","branchId","59ba344e-d286-11f0-8f85-42dde27851f2","createdAt",["D",1765013492089],"version",1,"orgId","019aee04-b264-711e-852b-f28a1799c8d7","parentId","incomingCommitId","aiChatMessageId","aiChatThreadId","aiChatThreadUserId","aiChatThreadTitle","source","clientLabel","user",{"_27":80,"_35":36,"_11":12,"_81":82},"file",{"_74":151,"_13":152,"_77":153,"_79":24},"pull","merge","revert","multiple",{"_148":149,"_150":20},"commits",[56,57,58,59,60,61,62,63,64,65,66,67,68,69,70],{"_27":28,"_29":30,"_31":32,"_33":34,"_35":36,"_37":-5,"_38":-5,"_39":-5,"_40":-5,"_41":-5,"_42":-5,"_43":-5,"_44":-5,"_45":46,"_47":48,"_49":-5,"_50":-5,"_51":-5},{"_27":28,"_29":30,"_31":143,"_33":34,"_35":36,"_37":-5,"_38":-5,"_39":-5,"_40":-5,"_41":-5,"_42":-5,"_43":-5,"_44":-5,"_45":144,"_47":145,"_49":-5,"_50":-5,"_51":-5},{"_27":28,"_29":30,"_31":138,"_33":34,"_35":36,"_37":-5,"_38":-5,"_39":-5,"_40":-5,"_41":-5,"_42":-5,"_43":-5,"_44":-5,"_45":139,"_47":140,"_49":-5,"_50":-5,"_51":-5},{"_27":28,"_29":30,"_31":133,"_33":34,"_35":36,"_37":-5,"_38":-5,"_39":-5,"_40":-5,"_41":-5,"_42":-5,"_43":-5,"_44":-5,"_45":134,"_47":135,"_49":-5,"_50":-5,"_51":-5},{"_27":28,"_29":30,"_31":128,"_33":34,"_35":36,"_37":-5,"_38":-5,"_39":-5,"_40":-5,"_41":-5,"_42":-5,"_43":-5,"_44":-5,"_45":129,"_47":130,"_49":-5,"_50":-5,"_51":-5},{"_27":28,"_29":30,"_31":123,"_33":34,"_35":36,"_37":-5,"_38":-5,"_39":-5,"_40":-5,"_41":-5,"_42":-5,"_43":-5,"_44":-5,"_45":124,"_47":125,"_49":-5,"_50":-5,"_51":-5},{"_27":28,"_29":30,"_31":118,"_33":34,"_35":36,"_37":-5,"_38":-5,"_39":-5,"_40":-5,"_41":-5,"_42":-5,"_43":-5,"_44":-5,"_45":119,"_47":120,"_49":-5,"_50":-5,"_51":-5},{"_27":28,"_29":30,"_31":114,"_33":34,"_35":36,"_37":-5,"_38":-5,"_39":-5,"_40":-5,"_41":-5,"_42":-5,"_43":-5,"_44":-5,"_45":115,"_47":116,"_49":-5,"_50":-5,"_51":-5},{"_27":28,"_29":30,"_31":109,"_33":34,"_35":36,"_37":-5,"_38":-5,"_39":-5,"_40":-5,"_41":-5,"_42":-5,"_43":-5,"_44":-5,"_45":110,"_47":111,"_49":-5,"_50":-5,"_51":-5},{"_27":28,"_29":30,"_31":104,"_33":34,"_35":36,"_37":-5,"_38":-5,"_39":-5,"_40":-5,"_41":-5,"_42":-5,"_43":-5,"_44":-5,"_45":105,"_47":106,"_49":-5,"_50":-5,"_51":-5},{"_27":28,"_29":30,"_31":99,"_33":34,"_35":36,"_37":-5,"_38":-5,"_39":-5,"_40":-5,"_41":-5,"_42":-5,"_43":-5,"_44":-5,"_45":100,"_47":101,"_49":-5,"_50":-5,"_51":-5},{"_27":28,"_29":30,"_31":93,"_33":34,"_35":36,"_37":-5,"_38":-5,"_39":-5,"_40":-5,"_41":-5,"_42":-5,"_43":-5,"_44":-5,"_45":94,"_47":95,"_49":-5,"_50":-5,"_51":-5},{"_27":28,"_29":30,"_31":88,"_33":34,"_35":36,"_37":-5,"_38":-5,"_39":-5,"_40":-5,"_41":-5,"_42":-5,"_43":-5,"_44":-5,"_45":89,"_47":90,"_49":-5,"_50":-5,"_51":-5},{"_27":28,"_29":30,"_31":83,"_33":34,"_35":36,"_37":-5,"_38":-5,"_39":-5,"_40":-5,"_41":-5,"_42":-5,"_43":-5,"_44":-5,"_45":84,"_47":85,"_49":-5,"_50":-5,"_51":-5},{"_27":28,"_29":30,"_31":71,"_33":34,"_35":36,"_37":-5,"_38":-5,"_39":-5,"_40":-5,"_41":-5,"_42":-5,"_43":-5,"_44":-5,"_45":72,"_47":73,"_49":-5,"_50":-5,"_51":-5},["D",1765013492089],{"_27":80,"_35":36,"_11":12,"_81":82},{"_74":75,"_13":76,"_77":78,"_79":24},"fileId","019af300-91a8-76cd-81d4-56f39c611e73","home.tsx","fileType","script","deleted","019aee04-b263-75ee-92f4-372f56307701","avatar","https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvb2F1dGhfZ2l0aHViL2ltZ18zNlFETVNueWN1THEwdGZOOUxVYkpKZGFRVzAifQ",["D",1765013492089],{"_27":80,"_35":36,"_11":12,"_81":82},{"_74":86,"_13":87,"_77":78,"_79":24},"019af300-91a8-76cd-81d4-5843183739cc","types.ts",["D",1765013492089],{"_27":80,"_35":36,"_11":12,"_81":82},{"_74":91,"_13":92,"_77":78,"_79":24},"019af300-91a9-7674-8913-d85a4f3aa149","users.ts",["D",1765013492089],{"_27":80,"_35":36,"_11":12,"_81":82},{"_74":96,"_13":97,"_77":98,"_79":24},"019af300-91a9-7674-8913-dc888eb6f9f5","app","directory",["D",1765013492089],{"_27":80,"_35":36,"_11":12,"_81":82},{"_74":102,"_13":103,"_77":78,"_79":24},"019af300-91a9-7674-8913-e11d8efe563d","client.ts",["D",1765013492089],{"_27":80,"_35":36,"_11":12,"_81":82},{"_74":107,"_13":108,"_77":78,"_79":24},"019af300-91a9-7674-8913-e4cd7d14f850","migrate.ts",["D",1765013492089],{"_27":80,"_35":36,"_11":12,"_81":82},{"_74":112,"_13":113,"_77":78,"_79":24},"019af300-91a9-7674-8913-eb460f12b6e7","schema.ts",["D",1765013492089],{"_27":80,"_35":36,"_11":12,"_81":82},{"_74":117,"_13":87,"_77":78,"_79":24},"019af300-91a9-7674-8913-edfb44e2bbc6",["D",1765013492089],{"_27":80,"_35":36,"_11":12,"_81":82},{"_74":121,"_13":122,"_77":98,"_79":24},"019af300-91a9-7674-8913-f37f7d2f5324","db",["D",1765013492089],{"_27":80,"_35":36,"_11":12,"_81":82},{"_74":126,"_13":127,"_77":78,"_79":24},"019af300-91a9-7674-8913-f7929d91498b","drizzle.ts",["D",1765013492089],{"_27":80,"_35":36,"_11":12,"_81":82},{"_74":131,"_13":132,"_77":78,"_79":24},"019af300-91a9-7674-8913-f851de77d861","fiberplane.ts",["D",1765013492089],{"_27":80,"_35":36,"_11":12,"_81":82},{"_74":136,"_13":137,"_77":78,"_79":24},"019af300-91a9-7674-8913-ffdef763a866","hono.ts",["D",1765013492089],{"_27":80,"_35":36,"_11":12,"_81":82},{"_74":141,"_13":142,"_77":98,"_79":24},"019af300-91a9-7674-8914-02ef0fb89d97","deps",["D",1765013492089],{"_27":80,"_35":36,"_11":12,"_81":82},{"_74":146,"_13":147,"_77":47,"_79":24},"019af300-91a9-7674-8914-0728ddd93f4c","README.md","count",15,"deletedCount","019af300-91a9-7674-8914-08996f314cbb","index.ts","http","59b8390a-d286-11f0-8f85-42dde27851f2",["D",1765013492089],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","HONC app template on Val Town (honc.dev)","imageUrl","pinnedFileId","pinPreview",true,"pinMigrated","screenshotVersion","likeCount","tursoName","59b8390ad28611f08f8542dde27851f2","tursoHostname","59b8390ad28611f08f8542dde27851f2-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789528852539],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm",{"_11":12,"_209":82},"org",{"_11":12,"_204":205,"_81":82,"_25":80,"_206":207,"_208":24},"branch",{"_33":34,"_13":16,"_27":30,"_192":154,"_193":194,"_195":196,"_197":159,"_198":199,"_200":201,"_202":14,"_203":12},"isOwned","projectId","forkedBranchId","413bdebc-f6a0-11ef-969a-569c3dd06744","forkedBranchVersion",95,"forkedProjectPrivacy","forkedProjectId","413b5bb8-f6a0-11ef-969a-569c3dd06744","forkedProjectOrgId","2cdea40e-3470-4c15-b791-920f79c299a9","projectName","userHandle","displayName","dk","tier","free","canRestrictVals","profileImageUrl","path","","adoptOrgId",{"_27":154,"_13":14,"_31":358,"_156":-5,"_157":24,"_158":159,"_160":159,"_161":162,"_163":-5,"_25":80,"_164":151,"_165":166,"_167":-5,"_168":-5,"_169":20,"_35":36,"_170":171,"_172":173,"_174":359,"_176":-5,"_177":178,"_179":178,"_180":181,"_182":181,"_183":181,"_184":178,"_185":178,"_45":360,"_187":361,"_189":362,"_191":24},"tree",[277,281,286,290,291],"files",[277,278,279,280,281,282,283,284,285,286,287,288,289,290,291],"counts",{"_268":20,"_269":34,"_270":20,"_271":272,"_273":274},"contents",[242,243,244,245,246],"upstreamProject",{"_27":199,"_13":14,"_161":162,"_163":-5,"_158":159,"_45":240},"upstreamBranch",{"_27":194,"_31":234,"_235":236,"_13":16,"_192":199,"_33":196,"_193":-5,"_195":-5,"_237":238,"_156":-5,"_191":24,"_158":159,"_203":239,"_35":201,"_202":14},"emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},["D",1740835362112],"updatedAt",["D",1741798186927],"lockfileKey","1766788753419-esm.town_v_fiberplane_HONC@95-main","fiberplane",{"_11":239,"_209":241},"https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvdXBsb2FkZWQvaW1nXzJ0OXJLaXVodjZKMUU4QnFhODNCVkJ4aVRQSyJ9",{"_27":265,"_13":97,"_74":96,"_37":-5,"_29":30,"_248":34,"_249":166,"_31":266,"_33":20,"_77":98,"_251":-5,"_79":24,"_253":-5,"_210":267},{"_27":262,"_13":122,"_74":121,"_37":-5,"_29":30,"_248":34,"_249":166,"_31":263,"_33":20,"_77":98,"_251":-5,"_79":24,"_253":-5,"_210":264},{"_27":259,"_13":142,"_74":141,"_37":-5,"_29":30,"_248":34,"_249":166,"_31":260,"_33":20,"_77":98,"_251":-5,"_79":24,"_253":-5,"_210":261},{"_27":255,"_13":147,"_74":146,"_37":-5,"_29":30,"_248":34,"_249":166,"_31":256,"_33":20,"_77":47,"_251":257,"_79":24,"_253":-5,"_210":258},{"_27":247,"_13":152,"_74":151,"_37":-5,"_29":30,"_248":34,"_249":166,"_31":250,"_33":20,"_77":153,"_251":252,"_79":24,"_253":-5,"_210":254},"59bc67a0-d286-11f0-8f85-42dde27851f2","branchVersion","latest",["D",1765013492089],"content","import { createFiberplane, createOpenAPISpec } from \"./deps/fiberplane.ts\";\nimport { Hono, HTTPException } from \"./deps/hono.ts\";\n\nimport homePage from \"./app/home.tsx\";\nimport type { AppType } from \"./app/types.ts\";\nimport usersApi from \"./app/users.ts\";\nimport { db } from \"./db/client.ts\";\nimport { migrateDatabase } from \"./db/migrate.ts\";\n\n// Migrate database on startup to make sure the proper table exists to store users\n// NOTE - Please comment on the template project if you have ideas on how to do migrations more cleanly on Valtown\nawait migrateDatabase();\n\nconst app = new Hono();\n\n/**\n * Middleware for setting up the database and storing it on the Hono app's context\n */\napp.use(async (c, next) => {\n c.set(\"db\", db);\n await next();\n});\n\n/** Mount the user management API at `/api/users` */\napp.route(\"/api/users\", usersApi);\n\n/** Render a Home page (example of using Hono with JSX) */\napp.route(\"/\", homePage);\n\n/** Create a simplified openapi spec that just lists the routes in our app */\napp.get(\"/openapi.json\", async c => {\n return c.json(\n createOpenAPISpec(app, {\n openapi: \"3.0.0\",\n info: {\n title: \"Honc D1 App\",\n version: \"1.0.0\",\n },\n }),\n );\n});\n\n/**\n * Mount the Fiberplane api playground\n * Visit /fp to view the UI\n */\napp.use(\n \"/fp/*\",\n createFiberplane({\n openapi: { url: \"/openapi.json\" },\n }),\n);\n\n// Unwrap and rethrow Hono errors as the original error\n// If you delete this, all errors will be \"Internal Server Error\"\napp.onError((err: unknown) => {\n if (err instanceof HTTPException) {\n return err.getResponse();\n }\n throw err;\n});\n\n/**\n * Wrap the incoming request, inject the Deno env vars into the Hono app,\n * and then call the Hono api entrypoint (`app.fetch`)\n */\nexport default async function(req: Request): Promise {\n const env = Deno.env.toObject();\n // NOTE - Adding the entire env object will also expose the following values to your api handlers:\n //\n // * `valtown`\n // * `VAL_TOWN_API_KEY`\n // * `VALTOWN_API_URL`\n //\n // If you don't want those values, remove them from the env object\n return app.fetch(req, env);\n}","label",[152],"59bc5fd0-d286-11f0-8f85-42dde27851f2",["D",1765013492089],"# 🪿 HONC! 🪿\n\nThis is a template for a [HONC](https://honc.dev) project inside ValTown. You should just be able to fork it and get going. It uses:\n\n- Hono for the API\n- Drizzle for the ORM\n- ValTown sqlite for the DB\n- ValTown as the Cloud\n- Fiberplane as the API Explorer\n\nThere's a list of example HONC apps for inspiration on GitHub: [here](https://github.com/fiberplane/awesome-honc) and [here](https://github.com/fiberplane/create-honc-app/tree/main/examples)\n\n## A Few Honkin' Notes\n\n### database migrations need love and care 🫂\n\nNot totally sure how to generate and apply drizzle migrations yet!\n\nSo this template assumes you'll do a lot of manual SQL writing to sync your schema with your migrations.\nThere's ~~probably~~ _definitely_ a better solution, so please comment if you have ideas!\n\n### Why `deps/`?\n\nWe try to keep our dependencies inside a folder called `deps/`, and you might be wondering: Why?\n\nGreat question. So interrogative!\n\nIf we want to update all external dependencies at once, it's just a lot easier to do it in one file, instead of going to (for example) each file that imports Drizzle, and changing the import url there.",[147],"59bc5eb8-d286-11f0-8f85-42dde27851f2",["D",1765013492089],[142],"59bc59fe-d286-11f0-8f85-42dde27851f2",["D",1765013492089],[122],"59bc5256-d286-11f0-8f85-42dde27851f2",["D",1765013492089],[97],"pulls","branches","forks","envVars",{"_148":20,"_276":20},"connections",{"_148":20,"_275":20},"unfilledCount","emptyCount",{"_27":265,"_13":97,"_74":96,"_37":-5,"_29":30,"_248":34,"_249":166,"_31":355,"_33":20,"_77":98,"_251":-5,"_79":24,"_253":-5,"_293":356,"_210":357},{"_27":350,"_13":76,"_74":75,"_37":96,"_29":30,"_248":34,"_249":166,"_31":351,"_33":20,"_77":78,"_251":352,"_79":24,"_253":-5,"_293":353,"_210":354},{"_27":345,"_13":87,"_74":86,"_37":96,"_29":30,"_248":34,"_249":166,"_31":346,"_33":20,"_77":78,"_251":347,"_79":24,"_253":-5,"_293":348,"_210":349},{"_27":340,"_13":92,"_74":91,"_37":96,"_29":30,"_248":34,"_249":166,"_31":341,"_33":20,"_77":78,"_251":342,"_79":24,"_253":-5,"_293":343,"_210":344},{"_27":262,"_13":122,"_74":121,"_37":-5,"_29":30,"_248":34,"_249":166,"_31":337,"_33":20,"_77":98,"_251":-5,"_79":24,"_253":-5,"_293":338,"_210":339},{"_27":332,"_13":103,"_74":102,"_37":121,"_29":30,"_248":34,"_249":166,"_31":333,"_33":20,"_77":78,"_251":334,"_79":24,"_253":-5,"_293":335,"_210":336},{"_27":327,"_13":108,"_74":107,"_37":121,"_29":30,"_248":34,"_249":166,"_31":328,"_33":20,"_77":78,"_251":329,"_79":24,"_253":-5,"_293":330,"_210":331},{"_27":322,"_13":113,"_74":112,"_37":121,"_29":30,"_248":34,"_249":166,"_31":323,"_33":20,"_77":78,"_251":324,"_79":24,"_253":-5,"_293":325,"_210":326},{"_27":317,"_13":87,"_74":117,"_37":121,"_29":30,"_248":34,"_249":166,"_31":318,"_33":20,"_77":78,"_251":319,"_79":24,"_253":-5,"_293":320,"_210":321},{"_27":259,"_13":142,"_74":141,"_37":-5,"_29":30,"_248":34,"_249":166,"_31":314,"_33":20,"_77":98,"_251":-5,"_79":24,"_253":-5,"_293":315,"_210":316},{"_27":309,"_13":127,"_74":126,"_37":141,"_29":30,"_248":34,"_249":166,"_31":310,"_33":20,"_77":78,"_251":311,"_79":24,"_253":-5,"_293":312,"_210":313},{"_27":304,"_13":132,"_74":131,"_37":141,"_29":30,"_248":34,"_249":166,"_31":305,"_33":20,"_77":78,"_251":306,"_79":24,"_253":-5,"_293":307,"_210":308},{"_27":299,"_13":137,"_74":136,"_37":141,"_29":30,"_248":34,"_249":166,"_31":300,"_33":20,"_77":78,"_251":301,"_79":24,"_253":-5,"_293":302,"_210":303},{"_27":255,"_13":147,"_74":146,"_37":-5,"_29":30,"_248":34,"_249":166,"_31":296,"_33":20,"_77":47,"_251":257,"_79":24,"_253":-5,"_293":297,"_210":298},{"_27":247,"_13":152,"_74":151,"_37":-5,"_29":30,"_248":34,"_249":166,"_31":292,"_33":20,"_77":153,"_251":252,"_79":24,"_253":-5,"_293":294,"_210":295},["D",1765013492089],"children",[],[152],["D",1765013492089],[],[147],"59bc5d96-d286-11f0-8f85-42dde27851f2",["D",1765013492089],"/**\n * Module that centralizes all Hono deps, to avoid using multiple imports of the library\n *\n * \"Why?\", you might ask.\n *\n * Well, Hono's type system freaks out if you import it multiple times,\n * so this avoids the case where one file accidentally imports a different version \n * (from esm.sh or npm)\n */\n\nimport { Hono, type MiddlewareHandler } from \"https://esm.sh/hono@4.7.0\";\nimport { cors } from \"https://esm.sh/hono@4.7.0/cors\";\nimport { HTTPException } from \"https://esm.sh/hono@4.7.0/http-exception\";\nimport { css, cx, keyframes, Style } from 'https://esm.sh/hono@4.7.0/css'\n\nexport { Hono, cors, type MiddlewareHandler, HTTPException, css, cx, keyframes, Style };",[],[142,137],"59bc5c88-d286-11f0-8f85-42dde27851f2",["D",1765013492089],"import { createFiberplane, createOpenAPISpec } from \"https://esm.sh/@fiberplane/hono@0.4.4\";\n\nexport { createFiberplane, createOpenAPISpec };",[],[142,132],"59bc5b34-d286-11f0-8f85-42dde27851f2",["D",1765013492089],"// Import drizzle deps with npm: specifier because exports don't get picked up properly by typescript when using esm.sh\nimport { drizzle, type LibSQLDatabase } from \"npm:drizzle-orm@0.39.3/libsql\";\nimport { and, eq, desc, relations, sql } from \"npm:drizzle-orm@0.39.3\";\nimport { integer, sqliteTable, text } from \"npm:drizzle-orm@0.39.3/sqlite-core\";\n\nexport { drizzle };\nexport type { LibSQLDatabase };\nexport { and, eq, desc, relations, sql };\nexport { integer, sqliteTable, text };",[],[142,127],["D",1765013492089],[287,288,289],[142],"59bc58f0-d286-11f0-8f85-42dde27851f2",["D",1765013492089],"import type { LibSQLDatabase } from \"../deps/drizzle.ts\";\nimport type * as schema from \"./schema\";\n\nexport type DBType = LibSQLDatabase;",[],[122,87],"59bc57d8-d286-11f0-8f85-42dde27851f2",["D",1765013492089],"import { integer, sql, sqliteTable, text } from \"../deps/drizzle.ts\";\n\nexport type NewUser = typeof users.$inferInsert;\n\nexport const users = sqliteTable(\"users\", {\n id: integer(\"id\", { mode: \"number\" }).primaryKey(),\n name: text(\"name\").notNull(),\n email: text(\"email\").notNull(),\n createdAt: text(\"created_at\").notNull().default(sql`(CURRENT_TIMESTAMP)`),\n updatedAt: text(\"updated_at\").notNull().default(sql`(CURRENT_TIMESTAMP)`),\n});",[],[122,113],"59bc56ac-d286-11f0-8f85-42dde27851f2",["D",1765013492089],"import { sqlite } from \"https://esm.town/v/std/sqlite\";\n\n/**\n * @NOTE - It is not straightforward how to use drizzle-kit to generate and apply migrations on ValTown\n * For this reason, we need to manually create the users table.\n */\nexport const migrateDatabase = async () => {\n await sqlite.execute(`\nCREATE TABLE IF NOT EXISTS \\`users\\` (\n \\`id\\` integer PRIMARY KEY NOT NULL,\n\t\\`name\\` text NOT NULL,\n \\`email\\` text,\n\t\\`created_at\\` text DEFAULT (CURRENT_TIMESTAMP) NOT NULL,\n\t\\`updated_at\\` text DEFAULT (CURRENT_TIMESTAMP) NOT NULL\n);\n`);\n};",[],[122,108],"59bc5468-d286-11f0-8f85-42dde27851f2",["D",1765013492089],"import { sqlite } from \"https://esm.town/v/std/sqlite\";\nimport { drizzle } from \"../deps/drizzle.ts\";\nimport * as schema from \"./schema.ts\";\nimport type { DBType } from \"./types.ts\";\n\n/**\n * The typed database client, allowing us to construct sql queries and\n * use Drizzle's ORM features against the ValTown sqlite database\n */\nexport const db: DBType = drizzle(sqlite as any, {\n schema,\n});",[],[122,103],["D",1765013492089],[282,283,284,285],[122],"59bc5080-d286-11f0-8f85-42dde27851f2",["D",1765013492089],"import * as schema from \"../db/schema.ts\";\nimport { and, eq, sql } from \"../deps/drizzle.ts\";\nimport { Hono, HTTPException } from \"../deps/hono.ts\";\nimport type { AppType } from \"./types.ts\";\n\nconst app = new Hono();\n\n/**\n * Get user by id\n */\napp.get(\"/:id\", async c => {\n const db = c.get(\"db\");\n const id = c.req.param(\"id\");\n const idNumber = +id;\n\n if (Number.isNaN(idNumber)) {\n throw new HTTPException(400, {\n message: \"id must be a number\",\n });\n }\n\n const user = await db.select().from(schema.users).where(eq(schema.users.id, id));\n return c.json(user);\n});\n\n/**\n * List users\n */\napp.get(\"/\", async c => {\n const db = c.get(\"db\");\n const users = await db.select().from(schema.users);\n\n return c.json({ users });\n});\n\n/**\n * Create a user\n */\napp.post(\"/\", async (c) => {\n const { name, email } = await c.req.json();\n\n const db = c.get(\"db\");\n\n const [newUser] = await db.insert(schema.users).values({\n name,\n email,\n }).returning();\n\n return c.json(newUser);\n});\n\n/**\n * Delete a user\n */\napp.delete(\"/:id\", async (c) => {\n const id = c.req.param(\"id\");\n const idNumber = +id;\n \n if (Number.isNaN(idNumber)) {\n return c.json({ message: \"Id must be a number \"}, 422);\n }\n\n const db = c.get(\"db\");\n\n await db.delete(schema.users).where(eq(schema.users.id, idNumber));\n\n return c.body(null, 204)\n});\n\nexport default app;",[],[97,92],"59bc4e14-d286-11f0-8f85-42dde27851f2",["D",1765013492089],"import type { MiddlewareHandler } from \"../deps/hono.ts\";\nimport type { DBType } from \"../db/types.ts\";\n\n/**\n * Our Hono app type\n * \n * Optimisitically types the values we expect in our environment and context:\n *\n * - `Bindings` determines env vars, accessed via `c.env.NAME_OF_VAR` in api handlers\n * - `Variables` determines context vars, accessed via `c.get(\"NAME_OF_VAR\")` in api handlers\n */\nexport type AppType = {\n Bindings: {\n /**\n * If you have an environment variable called `MY_ENV_VAR`,\n * manually specify it here to make Hono's type system aware of it.\n */\n MY_ENV_VAR: string;\n };\n Variables: {\n db: DBType;\n };\n};\n\nexport type AppMiddleware = MiddlewareHandler;",[],[97,87],"59bc420c-d286-11f0-8f85-42dde27851f2",["D",1765013492089],"/** @jsxImportSource https://esm.sh/hono@4.7.0/jsx */\n\nimport { css, Hono, Style } from \"../deps/hono.ts\";\n\nconst app = new Hono();\n\n/**\n * Use Hono's jsx renderer and css utilities to write a simple Home page\n * - https://hono.dev/docs/helpers/css\n * - https://hono.dev/docs/guides/jsx\n */\napp.get(\"/\", async ctx => {\n const bodyStyles = css`\n background-color: #1a1a1a;\n color: #f5f5f0;\n font-family: system-ui, -apple-system, sans-serif;\n line-height: 1.5;\n max-width: 800px;\n margin: 40px auto;\n padding: 20px;\n `;\n\n const linkStyles = css`\n color: #d9853b;\n text-decoration: none;\n &:hover {\n text-decoration: underline;\n }\n `;\n\n return ctx.html(\n \n \n \n \n

History