[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_316":317,"_318":319},"routes/_app.x.$handle.$name",{"_11":12,"_13":14,"_15":16,"_17":18,"_39":-7,"_146":-5,"_19":147,"_148":149,"_150":151,"_152":153,"_154":155,"_21":156,"_157":158,"_159":160,"_161":30,"_162":163,"_164":24,"_165":-5,"_166":-5,"_167":168},"routes/_app.x.$handle.$name.branch.$branch.history_.$",{"_11":12,"_13":14,"_15":16,"_17":18,"_19":20,"_21":22,"_23":24,"_25":26,"_27":28,"_29":30,"_31":-5},"handle","toowired","name","HONC","branchName","main","path","db","project",{"_33":95,"_13":14,"_37":96,"_97":-5,"_98":30,"_99":100,"_101":100,"_102":-5,"_103":-5,"_31":74,"_104":105,"_106":24,"_107":-5,"_108":-5,"_109":26,"_41":42,"_110":-5,"_111":-5,"_112":-5,"_113":-5,"_114":115,"_116":115,"_117":118,"_119":118,"_120":118,"_121":115,"_122":115,"_51":123,"_124":125,"_126":127,"_128":30},"file",{"_68":92,"_13":18,"_71":93,"_73":30,"_94":-5},"isDirectory",true,"page",0,"history",[32],"hasNext",false,"userId",{"_33":34,"_35":36,"_37":38,"_39":40,"_41":42,"_43":-5,"_44":-5,"_45":-5,"_46":-5,"_47":-5,"_48":-5,"_49":-5,"_50":-5,"_51":52,"_21":53,"_54":-5,"_55":-5,"_56":-5,"_57":58,"_59":60},"id","396a7902-056c-11f0-875e-569c3dd06744","branchId","39671050-056c-11f0-875e-569c3dd06744","createdAt",["D",1742462282589],"version",1,"orgId","332725b9-0bd3-42b9-83ec-05fac730cb70","parentId","incomingCommitId","aiChatMessageId","aiChatThreadId","aiChatThreadUserId","aiChatThreadTitle","source","clientLabel","user",{"_33":74,"_41":42,"_11":12,"_75":76},{"_68":90,"_13":91,"_71":72,"_73":30},"pull","merge","revert","multiple",{"_87":88,"_89":26},"commits",[61,62,63,64],{"_33":34,"_35":36,"_37":38,"_39":40,"_41":42,"_43":-5,"_44":-5,"_45":-5,"_46":-5,"_47":-5,"_48":-5,"_49":-5,"_50":-5,"_51":52,"_21":53,"_54":-5,"_55":-5,"_56":-5},{"_33":34,"_35":36,"_37":82,"_39":40,"_41":42,"_43":-5,"_44":-5,"_45":-5,"_46":-5,"_47":-5,"_48":-5,"_49":-5,"_50":-5,"_51":83,"_21":84,"_54":-5,"_55":-5,"_56":-5},{"_33":34,"_35":36,"_37":77,"_39":40,"_41":42,"_43":-5,"_44":-5,"_45":-5,"_46":-5,"_47":-5,"_48":-5,"_49":-5,"_50":-5,"_51":78,"_21":79,"_54":-5,"_55":-5,"_56":-5},{"_33":34,"_35":36,"_37":65,"_39":40,"_41":42,"_43":-5,"_44":-5,"_45":-5,"_46":-5,"_47":-5,"_48":-5,"_49":-5,"_50":-5,"_51":66,"_21":67,"_54":-5,"_55":-5,"_56":-5},["D",1742462282589],{"_33":74,"_41":42,"_11":12,"_75":76},{"_68":69,"_13":70,"_71":72,"_73":30},"fileId","f8e62e88-83c2-42f5-93b9-9d6ef3acb077","client.ts","fileType","script","deleted","02bea313-4abc-475e-987f-68da0b110d85","avatar","https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvdXBsb2FkZWQvaW1nXzJ5MkxRcEVHOWxNcEFMQ0d1VHB5S1R0Unh2byJ9",["D",1742462282589],{"_33":74,"_41":42,"_11":12,"_75":76},{"_68":80,"_13":81,"_71":72,"_73":30},"d985e18b-8507-49ab-a1b4-30bd300408d1","types.ts",["D",1742462282589],{"_33":74,"_41":42,"_11":12,"_75":76},{"_68":85,"_13":86,"_71":72,"_73":30},"6d60c4d2-6cde-4dd5-a83b-e1a956d4ea8f","migrate.ts","count",4,"deletedCount","298fd97e-bca8-4950-9443-271686ade3ac","schema.ts","d4d82522-bfa8-4059-9aad-6c694ca42602","directory","deletedAtVersion","396470b6-056c-11f0-875e-569c3dd06744",["D",1742462282589],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","imageUrl","pinnedFileId","3436ce9d-1e64-4732-b0e3-8b4e7082f51c","pinPreview","pinMigrated","screenshotVersion","likeCount","tursoName","tursoHostname","tursoMeasuredAt","pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm",{"_11":12,"_145":76},"org",{"_11":12,"_141":-5,"_75":76,"_31":74,"_142":143,"_144":30},"branch",{"_39":40,"_13":16,"_33":36,"_129":95,"_130":131,"_132":133,"_134":100,"_135":136,"_137":138,"_139":14,"_140":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","tier","free","canRestrictVals","profileImageUrl","adoptOrgId",{"_33":95,"_13":14,"_37":312,"_97":-5,"_98":30,"_99":100,"_101":100,"_102":-5,"_103":-5,"_31":74,"_104":105,"_106":24,"_107":-5,"_108":-5,"_109":26,"_41":42,"_110":-5,"_111":-5,"_112":-5,"_113":-5,"_114":115,"_116":115,"_117":118,"_119":118,"_120":118,"_121":115,"_122":115,"_51":313,"_124":314,"_126":315,"_128":30},"tree",[214,218,223,227,228],"files",[214,215,216,217,218,219,220,221,222,223,224,225,226,227,228],"counts",{"_205":26,"_206":40,"_207":26,"_208":209,"_210":211},"contents",[185,186,187,188],{"_33":178,"_13":18,"_68":92,"_43":-5,"_35":36,"_179":40,"_180":24,"_37":181,"_39":26,"_71":93,"_182":-5,"_73":30,"_183":-5,"_17":184},"upstreamProject",{"_33":136,"_13":14,"_102":175,"_103":-5,"_99":100,"_51":176},"upstreamBranch",{"_33":131,"_37":169,"_170":171,"_13":16,"_129":136,"_39":133,"_130":-5,"_132":-5,"_172":173,"_97":-5,"_128":30,"_99":100,"_140":174,"_41":138,"_139":14},"emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},["D",1740835362112],"updatedAt",["D",1741798186927],"lockfileKey","1766788753419-esm.town_v_fiberplane_HONC@95-main","fiberplane","HONC app template on Val Town (honc.dev)",{"_11":174,"_145":177},"https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvdXBsb2FkZWQvaW1nXzJ0OXJLaXVodjZKMUU4QnFhODNCVkJ4aVRQSyJ9","3968f79e-056c-11f0-875e-569c3dd06744","branchVersion","latest",["D",1742462282589],"content","label",[18],{"_33":201,"_13":70,"_68":69,"_43":92,"_35":36,"_179":40,"_180":24,"_37":202,"_39":26,"_71":72,"_182":203,"_73":30,"_183":-5,"_17":204},{"_33":197,"_13":86,"_68":85,"_43":92,"_35":36,"_179":40,"_180":24,"_37":198,"_39":26,"_71":72,"_182":199,"_73":30,"_183":-5,"_17":200},{"_33":193,"_13":91,"_68":90,"_43":92,"_35":36,"_179":40,"_180":24,"_37":194,"_39":26,"_71":72,"_182":195,"_73":30,"_183":-5,"_17":196},{"_33":189,"_13":81,"_68":80,"_43":92,"_35":36,"_179":40,"_180":24,"_37":190,"_39":26,"_71":72,"_182":191,"_73":30,"_183":-5,"_17":192},"3968f64a-056c-11f0-875e-569c3dd06744",["D",1742462282589],"import type { LibSQLDatabase } from \"../deps/drizzle.ts\";\nimport type * as schema from \"./schema\";\n\nexport type DBType = LibSQLDatabase;",[18,81],"3968f4ba-056c-11f0-875e-569c3dd06744",["D",1742462282589],"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});",[18,91],"3968f30c-056c-11f0-875e-569c3dd06744",["D",1742462282589],"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};",[18,86],"3968f104-056c-11f0-875e-569c3dd06744",["D",1742462282589],"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});",[18,70],"pulls","branches","forks","envVars",{"_87":26,"_213":26},"connections",{"_87":26,"_212":26},"unfilledCount","emptyCount",{"_33":308,"_13":294,"_68":289,"_43":-5,"_35":36,"_179":40,"_180":24,"_37":309,"_39":26,"_71":93,"_182":-5,"_73":30,"_183":-5,"_234":310,"_17":311},{"_33":301,"_13":302,"_68":303,"_43":289,"_35":36,"_179":40,"_180":24,"_37":304,"_39":26,"_71":72,"_182":305,"_73":30,"_183":-5,"_234":306,"_17":307},{"_33":295,"_13":81,"_68":296,"_43":289,"_35":36,"_179":40,"_180":24,"_37":297,"_39":26,"_71":72,"_182":298,"_73":30,"_183":-5,"_234":299,"_17":300},{"_33":286,"_13":287,"_68":288,"_43":289,"_35":36,"_179":40,"_180":24,"_37":290,"_39":26,"_71":72,"_182":291,"_73":30,"_183":-5,"_234":292,"_17":293},{"_33":178,"_13":18,"_68":92,"_43":-5,"_35":36,"_179":40,"_180":24,"_37":283,"_39":26,"_71":93,"_182":-5,"_73":30,"_183":-5,"_234":284,"_17":285},{"_33":201,"_13":70,"_68":69,"_43":92,"_35":36,"_179":40,"_180":24,"_37":280,"_39":26,"_71":72,"_182":203,"_73":30,"_183":-5,"_234":281,"_17":282},{"_33":197,"_13":86,"_68":85,"_43":92,"_35":36,"_179":40,"_180":24,"_37":277,"_39":26,"_71":72,"_182":199,"_73":30,"_183":-5,"_234":278,"_17":279},{"_33":193,"_13":91,"_68":90,"_43":92,"_35":36,"_179":40,"_180":24,"_37":274,"_39":26,"_71":72,"_182":195,"_73":30,"_183":-5,"_234":275,"_17":276},{"_33":189,"_13":81,"_68":80,"_43":92,"_35":36,"_179":40,"_180":24,"_37":271,"_39":26,"_71":72,"_182":191,"_73":30,"_183":-5,"_234":272,"_17":273},{"_33":267,"_13":252,"_68":247,"_43":-5,"_35":36,"_179":40,"_180":24,"_37":268,"_39":26,"_71":93,"_182":-5,"_73":30,"_183":-5,"_234":269,"_17":270},{"_33":260,"_13":261,"_68":262,"_43":247,"_35":36,"_179":40,"_180":24,"_37":263,"_39":26,"_71":72,"_182":264,"_73":30,"_183":-5,"_234":265,"_17":266},{"_33":253,"_13":254,"_68":255,"_43":247,"_35":36,"_179":40,"_180":24,"_37":256,"_39":26,"_71":72,"_182":257,"_73":30,"_183":-5,"_234":258,"_17":259},{"_33":244,"_13":245,"_68":246,"_43":247,"_35":36,"_179":40,"_180":24,"_37":248,"_39":26,"_71":72,"_182":249,"_73":30,"_183":-5,"_234":250,"_17":251},{"_33":237,"_13":238,"_68":239,"_43":-5,"_35":36,"_179":40,"_180":24,"_37":240,"_39":26,"_71":21,"_182":241,"_73":30,"_183":-5,"_234":242,"_17":243},{"_33":229,"_13":230,"_68":105,"_43":-5,"_35":36,"_179":40,"_180":24,"_37":231,"_39":26,"_71":232,"_182":233,"_73":30,"_183":-5,"_234":235,"_17":236},"396900cc-056c-11f0-875e-569c3dd06744","index.ts",["D",1742462282589],"http","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}","children",[],[230],"3968ff1e-056c-11f0-875e-569c3dd06744","README.md","8762a59c-93bc-438f-8d63-72e67be99bf6",["D",1742462282589],"# 🪿 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.",[],[238],"3968fc1c-056c-11f0-875e-569c3dd06744","hono.ts","5d7d5907-0d6d-43b7-8a61-60e4cded9aca","080a5a12-1742-44dc-b03f-dca9dc851d24",["D",1742462282589],"/**\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 };",[],[252,245],"deps","3968fa14-056c-11f0-875e-569c3dd06744","fiberplane.ts","56065404-f2e2-4dd7-a6a5-4c323463d432",["D",1742462282589],"import { createFiberplane, createOpenAPISpec } from \"https://esm.sh/@fiberplane/hono@0.4.4\";\n\nexport { createFiberplane, createOpenAPISpec };",[],[252,254],"3968f898-056c-11f0-875e-569c3dd06744","drizzle.ts","bdd2fb7c-a8f3-4287-87ba-6a10f13d8a1c",["D",1742462282589],"// 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 };",[],[252,261],"3968fdac-056c-11f0-875e-569c3dd06744",["D",1742462282589],[224,225,226],[252],["D",1742462282589],[],[18,81],["D",1742462282589],[],[18,91],["D",1742462282589],[],[18,86],["D",1742462282589],[],[18,70],["D",1742462282589],[219,220,221,222],[18],"3968d516-056c-11f0-875e-569c3dd06744","users.ts","c5814f02-78f0-4fd1-9290-a7c12554a444","6087f613-03eb-4a5f-8c6a-897b74106cc8",["D",1742462282589],"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;",[],[294,287],"app","3968ce86-056c-11f0-875e-569c3dd06744","a1cb7a4d-d112-48dc-8097-8d6ca530dfb6",["D",1742462282589],"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;",[],[294,81],"3968c792-056c-11f0-875e-569c3dd06744","home.tsx","3cd28248-72b1-4367-ba17-452017332611",["D",1742462282589],"/** @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 · db