[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_287":288,"_289":290},"routes/_app.x.$handle.$name",{"_11":12,"_13":14,"_15":16,"_86":87,"_68":-7,"_88":-5,"_17":89,"_90":91,"_92":93,"_94":95,"_96":97,"_98":-5,"_99":-5,"_100":-5,"_101":24,"_102":103,"_104":42,"_105":-5,"_106":-5,"_107":108},"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","fiberplane","name","HONC","branchName","main","project",{"_26":27,"_13":14,"_28":29,"_30":-5,"_31":24,"_32":33,"_34":33,"_35":36,"_37":-5,"_25":38,"_39":40,"_41":42,"_43":-5,"_44":-5,"_45":20,"_46":47,"_48":-5,"_49":-5,"_50":-5,"_51":-5,"_52":53,"_54":53,"_55":56,"_57":56,"_58":56,"_59":53,"_60":53,"_61":62,"_63":64,"_65":66,"_67":24},"page",0,"history",[],"hasNext",false,"userId","id","413b5bb8-f6a0-11ef-969a-569c3dd06744","createdAt",["D",1740835362112],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","HONC app template on Val Town (honc.dev)","imageUrl","42ee3ab0-ecfb-11ef-af12-67b5d5b0b458","pinnedFileId","c6d15d5e-f6a0-11ef-9ab6-569c3dd06744","pinPreview",true,"pinMigrated","screenshotVersion","likeCount","orgId","2cdea40e-3470-4c15-b791-920f79c299a9","tursoName","tursoHostname","tursoMeasuredAt","pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_11":12,"_85":81},"org",{"_11":12,"_79":-5,"_80":81,"_25":38,"_82":83,"_84":24},"branch",{"_68":69,"_13":16,"_26":70,"_71":27,"_72":-5,"_73":-5,"_74":-5,"_75":-5,"_76":-5,"_77":14,"_78":12},"isOwned","version",95,"413bdebc-f6a0-11ef-969a-569c3dd06744","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","displayName","avatar","https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvdXBsb2FkZWQvaW1nXzJ0OXJLaXVodjZKMUU4QnFhODNCVkJ4aVRQSyJ9","tier","free","canRestrictVals","profileImageUrl","path","","adoptOrgId",{"_26":27,"_13":14,"_28":283,"_30":-5,"_31":24,"_32":33,"_34":33,"_35":36,"_37":-5,"_25":38,"_39":40,"_41":42,"_43":-5,"_44":-5,"_45":20,"_46":47,"_48":-5,"_49":-5,"_50":-5,"_51":-5,"_52":53,"_54":53,"_55":56,"_57":56,"_58":56,"_59":53,"_60":53,"_61":284,"_63":285,"_65":286,"_67":24},"tree",[170,174,179,183,184],"files",[170,171,172,173,174,175,176,177,178,179,180,181,182,183,184],"counts",{"_159":20,"_160":144,"_161":162,"_163":164,"_165":166},"contents",[109,110,111,112,113],"file","upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_26":153,"_13":154,"_116":155,"_117":-5,"_118":70,"_119":156,"_121":42,"_28":157,"_68":144,"_124":145,"_126":-5,"_128":24,"_129":-5,"_86":158},{"_26":147,"_13":148,"_116":149,"_117":-5,"_118":70,"_119":150,"_121":42,"_28":151,"_68":144,"_124":145,"_126":-5,"_128":24,"_129":-5,"_86":152},{"_26":139,"_13":140,"_116":141,"_117":-5,"_118":70,"_119":142,"_121":42,"_28":143,"_68":144,"_124":145,"_126":-5,"_128":24,"_129":-5,"_86":146},{"_26":131,"_13":132,"_116":133,"_117":-5,"_118":70,"_119":134,"_121":42,"_28":135,"_68":136,"_124":98,"_126":137,"_128":24,"_129":-5,"_86":138},{"_26":114,"_13":115,"_116":40,"_117":-5,"_118":70,"_119":120,"_121":42,"_28":122,"_68":123,"_124":125,"_126":127,"_128":24,"_129":-5,"_86":130},"4b65c65a-f817-11ef-86be-569c3dd06744","index.ts","fileId","parentId","branchId","branchVersion",83,"latest",["D",1740996440456],25,"fileType","http","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}","deleted","label",[115],"19cd3e1a-f818-11ef-9633-569c3dd06744","README.md","615db850-f6a0-11ef-9009-569c3dd06744",89,["D",1740996786746],9,"# 🪿 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.",[132],"5e3502aa-f6a0-11ef-9c01-569c3dd06744","deps","59a3c3b6-f6a0-11ef-a3eb-569c3dd06744",6,["D",1740835410741],1,"directory",[140],"4e4b2356-f6a0-11ef-9f9f-569c3dd06744","db","4a7428d6-f6a0-11ef-9020-569c3dd06744",2,["D",1740835384041],[148],"542d8d6e-f6a4-11ef-b1f7-569c3dd06744","app","519b536a-f6a4-11ef-b1f7-569c3dd06744",41,["D",1740837111903],[154],"pulls","branches","forks",4,"envVars",{"_167":20,"_169":20},"connections",{"_167":20,"_168":20},"count","unfilledCount","emptyCount",{"_26":153,"_13":154,"_116":155,"_117":-5,"_118":70,"_119":156,"_121":42,"_28":280,"_68":144,"_124":145,"_126":-5,"_128":24,"_129":-5,"_186":281,"_86":282},{"_26":271,"_13":272,"_116":273,"_117":155,"_118":70,"_119":274,"_121":42,"_28":275,"_68":276,"_124":197,"_126":277,"_128":24,"_129":-5,"_186":278,"_86":279},{"_26":264,"_13":222,"_116":265,"_117":155,"_118":70,"_119":266,"_121":42,"_28":267,"_68":214,"_124":197,"_126":268,"_128":24,"_129":-5,"_186":269,"_86":270},{"_26":256,"_13":257,"_116":258,"_117":155,"_118":70,"_119":69,"_121":42,"_28":259,"_68":260,"_124":197,"_126":261,"_128":24,"_129":-5,"_186":262,"_86":263},{"_26":147,"_13":148,"_116":149,"_117":-5,"_118":70,"_119":150,"_121":42,"_28":253,"_68":144,"_124":145,"_126":-5,"_128":24,"_129":-5,"_186":254,"_86":255},{"_26":245,"_13":246,"_116":247,"_117":149,"_118":70,"_119":248,"_121":42,"_28":249,"_68":144,"_124":197,"_126":250,"_128":24,"_129":-5,"_186":251,"_86":252},{"_26":237,"_13":238,"_116":239,"_117":149,"_118":70,"_119":240,"_121":42,"_28":241,"_68":144,"_124":197,"_126":242,"_128":24,"_129":-5,"_186":243,"_86":244},{"_26":229,"_13":230,"_116":231,"_117":149,"_118":70,"_119":232,"_121":42,"_28":233,"_68":162,"_124":197,"_126":234,"_128":24,"_129":-5,"_186":235,"_86":236},{"_26":221,"_13":222,"_116":223,"_117":149,"_118":70,"_119":224,"_121":42,"_28":225,"_68":144,"_124":197,"_126":226,"_128":24,"_129":-5,"_186":227,"_86":228},{"_26":139,"_13":140,"_116":141,"_117":-5,"_118":70,"_119":142,"_121":42,"_28":218,"_68":144,"_124":145,"_126":-5,"_128":24,"_129":-5,"_186":219,"_86":220},{"_26":209,"_13":210,"_116":211,"_117":141,"_118":70,"_119":212,"_121":42,"_28":213,"_68":214,"_124":197,"_126":215,"_128":24,"_129":-5,"_186":216,"_86":217},{"_26":201,"_13":202,"_116":203,"_117":141,"_118":70,"_119":204,"_121":42,"_28":205,"_68":144,"_124":197,"_126":206,"_128":24,"_129":-5,"_186":207,"_86":208},{"_26":192,"_13":193,"_116":194,"_117":141,"_118":70,"_119":195,"_121":42,"_28":196,"_68":150,"_124":197,"_126":198,"_128":24,"_129":-5,"_186":199,"_86":200},{"_26":131,"_13":132,"_116":133,"_117":-5,"_118":70,"_119":134,"_121":42,"_28":189,"_68":136,"_124":98,"_126":137,"_128":24,"_129":-5,"_186":190,"_86":191},{"_26":114,"_13":115,"_116":40,"_117":-5,"_118":70,"_119":120,"_121":42,"_28":185,"_68":123,"_124":125,"_126":127,"_128":24,"_129":-5,"_186":187,"_86":188},["D",1740996440456],"children",[],[115],["D",1740996786746],[],[132],"0ab19154-f815-11ef-9adf-569c3dd06744","hono.ts","28ae14d4-f6a3-11ef-b06a-569c3dd06744",66,["D",1740995472907],"script","/**\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 };",[],[140,193],"17b03356-f6a3-11ef-aed5-569c3dd06744","fiberplane.ts","efcd4f40-f6a2-11ef-b44b-569c3dd06744",31,["D",1740836580921],"import { createFiberplane, createOpenAPISpec } from \"https://esm.sh/@fiberplane/hono@0.4.4\";\n\nexport { createFiberplane, createOpenAPISpec };",[],[140,202],"707cf7fa-ff61-11ef-b46a-569c3dd06744","drizzle.ts","0ad5206c-f6a1-11ef-b987-569c3dd06744",93,["D",1741797943584],3,"// 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 };",[],[140,210],["D",1740835410741],[180,181,182],[140],"4dffe0a6-f6a2-11ef-850a-569c3dd06744","types.ts","4a14feae-f6a2-11ef-b998-569c3dd06744",22,["D",1740836242542],"import type { LibSQLDatabase } from \"../deps/drizzle.ts\";\nimport type * as schema from \"./schema\";\n\nexport type DBType = LibSQLDatabase;",[],[148,222],"87de3bc0-f6a1-11ef-9529-569c3dd06744","schema.ts","4fe31034-f6a0-11ef-9dbd-569c3dd06744",18,["D",1740835910133],"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});",[],[148,230],"062ee006-f6a2-11ef-bde6-569c3dd06744","migrate.ts","959523dc-f6a1-11ef-af35-569c3dd06744",20,["D",1740836122054],"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};",[],[148,238],"5eefd02e-f6a2-11ef-be72-569c3dd06744","client.ts","59dd1786-f6a2-11ef-b3e4-569c3dd06744",24,["D",1740836270958],"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});",[],[148,246],["D",1740835384041],[175,176,177,178],[148],"01881efa-ff62-11ef-8c33-569c3dd06744","users.ts","da12a428-f6a4-11ef-9dea-569c3dd06744",["D",1741798186927],10,"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;",[],[154,257],"9ad3d318-f6a4-11ef-9b93-569c3dd06744","6e62fc0a-f6a4-11ef-a86f-569c3dd06744",45,["D",1740837230432],"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;",[],[154,222],"b78e4b44-ff61-11ef-8922-569c3dd06744","home.tsx","b1f79180-f814-11ef-9e2f-569c3dd06744",94,["D",1741798062816],15,"/** @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