[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_283":284,"_285":286},"routes/_app.x.$handle.$name",{"_11":12,"_13":14,"_15":16,"_17":18,"_78":-7,"_101":-5,"_19":102,"_103":104,"_105":106,"_107":108,"_109":110,"_21":111,"_112":113,"_114":115,"_116":30,"_117":118,"_119":24,"_120":-5,"_121":-5,"_122":123},"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","cameronpak","name","HONC","branchName","main","path","db","project",{"_38":39,"_13":14,"_40":41,"_42":-5,"_43":30,"_44":45,"_46":45,"_47":-5,"_48":-5,"_31":49,"_50":51,"_52":24,"_53":-5,"_54":-5,"_55":26,"_56":57,"_58":-5,"_59":-5,"_60":-5,"_61":-5,"_62":63,"_64":63,"_65":66,"_67":66,"_68":66,"_69":63,"_70":63,"_71":72,"_73":74,"_75":76,"_77":30},"file",{"_32":33,"_13":18,"_34":35,"_36":30,"_37":-5},"isDirectory",true,"page",0,"history",[],"hasNext",false,"userId","fileId","efdef806-3f4c-404a-9ed5-f3fdc1c9b8c6","fileType","directory","deleted","deletedAtVersion","id","1d7022c2-ff6a-11ef-859d-569c3dd06744","createdAt",["D",1741801669719],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","imageUrl","35ef5666-3780-42d5-ade0-86fe3fdb6bb1","pinnedFileId","6071f964-b74b-4162-9fcb-8fba1d0bf8d3","pinPreview","pinMigrated","screenshotVersion","likeCount","orgId","47e0b4b2-7d41-46e6-8dce-0ae3d76e1a8f","tursoName","tursoHostname","tursoMeasuredAt","pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_11":12,"_100":96},"org",{"_11":12,"_93":94,"_95":96,"_31":49,"_97":98,"_99":30},"branch",{"_78":79,"_13":16,"_38":80,"_81":39,"_82":83,"_84":85,"_86":45,"_87":88,"_89":90,"_91":14,"_92":12},"isOwned","version",1,"1d72ecaa-ff6a-11ef-859d-569c3dd06744","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","Cam","avatar","https://imagedelivery.net/iHX6Ovru0O7AjmyT5yZRoA/7fcc9ac1-f8fb-41e2-0168-af29ef7c6400/square512?exp=1789585199&sig=3ffdbdabe52178cff14f29ed36c8fb754dd43993a5642231f39a7eb1fece8819","tier","pro","canRestrictVals","profileImageUrl","adoptOrgId",{"_38":39,"_13":14,"_40":279,"_42":-5,"_43":30,"_44":45,"_46":45,"_47":-5,"_48":-5,"_31":49,"_50":51,"_52":24,"_53":-5,"_54":-5,"_55":26,"_56":57,"_58":-5,"_59":-5,"_60":-5,"_61":-5,"_62":63,"_64":63,"_65":66,"_67":66,"_68":66,"_69":63,"_70":63,"_71":280,"_73":281,"_75":282,"_77":30},"tree",[181,185,190,194,195],"files",[181,182,183,184,185,186,187,188,189,190,191,192,193,194,195],"counts",{"_171":26,"_172":79,"_173":26,"_174":175,"_176":177},"contents",[142,143,144,145],{"_38":133,"_13":18,"_32":33,"_134":-5,"_135":80,"_136":79,"_137":24,"_40":138,"_78":26,"_34":35,"_139":-5,"_36":30,"_140":-5,"_17":141},"upstreamProject",{"_38":88,"_13":14,"_47":130,"_48":-5,"_44":45,"_71":131},"upstreamBranch",{"_38":83,"_40":124,"_125":126,"_13":16,"_81":88,"_78":85,"_82":-5,"_84":-5,"_127":128,"_42":-5,"_77":30,"_44":45,"_92":129,"_56":90,"_91":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":129,"_100":132},"https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvdXBsb2FkZWQvaW1nXzJ0OXJLaXVodjZKMUU4QnFhODNCVkJ4aVRQSyJ9","1d7492c6-ff6a-11ef-859d-569c3dd06744","parentId","branchId","branchVersion","latest",["D",1741801669719],"content","label",[18],{"_38":165,"_13":166,"_32":167,"_134":33,"_135":80,"_136":79,"_137":24,"_40":168,"_78":26,"_34":150,"_139":169,"_36":30,"_140":-5,"_17":170},{"_38":159,"_13":160,"_32":161,"_134":33,"_135":80,"_136":79,"_137":24,"_40":162,"_78":26,"_34":150,"_139":163,"_36":30,"_140":-5,"_17":164},{"_38":153,"_13":154,"_32":155,"_134":33,"_135":80,"_136":79,"_137":24,"_40":156,"_78":26,"_34":150,"_139":157,"_36":30,"_140":-5,"_17":158},{"_38":146,"_13":147,"_32":148,"_134":33,"_135":80,"_136":79,"_137":24,"_40":149,"_78":26,"_34":150,"_139":151,"_36":30,"_140":-5,"_17":152},"1d7491d6-ff6a-11ef-859d-569c3dd06744","types.ts","233d53a8-628a-4de2-b1b2-388b83bc5281",["D",1741801669719],"script","import type { LibSQLDatabase } from \"../deps/drizzle.ts\";\nimport type * as schema from \"./schema\";\n\nexport type DBType = LibSQLDatabase;",[18,147],"1d749032-ff6a-11ef-859d-569c3dd06744","schema.ts","2099f6e5-72b9-431a-874d-1961a3e876e6",["D",1741801669719],"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,154],"1d748f2e-ff6a-11ef-859d-569c3dd06744","migrate.ts","8535b9ec-16b0-465b-ae87-f1d209d6134f",["D",1741801669719],"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,160],"1d748d26-ff6a-11ef-859d-569c3dd06744","client.ts","89b7e760-421c-4056-a1f8-3cbf706f16ec",["D",1741801669719],"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,166],"pulls","branches","forks","envVars",{"_178":26,"_180":26},"connections",{"_178":26,"_179":26},"count","unfilledCount","emptyCount",{"_38":275,"_13":261,"_32":256,"_134":-5,"_135":80,"_136":79,"_137":24,"_40":276,"_78":26,"_34":35,"_139":-5,"_36":30,"_140":-5,"_201":277,"_17":278},{"_38":268,"_13":269,"_32":270,"_134":256,"_135":80,"_136":79,"_137":24,"_40":271,"_78":26,"_34":150,"_139":272,"_36":30,"_140":-5,"_201":273,"_17":274},{"_38":262,"_13":147,"_32":263,"_134":256,"_135":80,"_136":79,"_137":24,"_40":264,"_78":26,"_34":150,"_139":265,"_36":30,"_140":-5,"_201":266,"_17":267},{"_38":253,"_13":254,"_32":255,"_134":256,"_135":80,"_136":79,"_137":24,"_40":257,"_78":26,"_34":150,"_139":258,"_36":30,"_140":-5,"_201":259,"_17":260},{"_38":133,"_13":18,"_32":33,"_134":-5,"_135":80,"_136":79,"_137":24,"_40":250,"_78":26,"_34":35,"_139":-5,"_36":30,"_140":-5,"_201":251,"_17":252},{"_38":165,"_13":166,"_32":167,"_134":33,"_135":80,"_136":79,"_137":24,"_40":247,"_78":26,"_34":150,"_139":169,"_36":30,"_140":-5,"_201":248,"_17":249},{"_38":159,"_13":160,"_32":161,"_134":33,"_135":80,"_136":79,"_137":24,"_40":244,"_78":26,"_34":150,"_139":163,"_36":30,"_140":-5,"_201":245,"_17":246},{"_38":153,"_13":154,"_32":155,"_134":33,"_135":80,"_136":79,"_137":24,"_40":241,"_78":26,"_34":150,"_139":157,"_36":30,"_140":-5,"_201":242,"_17":243},{"_38":146,"_13":147,"_32":148,"_134":33,"_135":80,"_136":79,"_137":24,"_40":238,"_78":26,"_34":150,"_139":151,"_36":30,"_140":-5,"_201":239,"_17":240},{"_38":234,"_13":219,"_32":214,"_134":-5,"_135":80,"_136":79,"_137":24,"_40":235,"_78":26,"_34":35,"_139":-5,"_36":30,"_140":-5,"_201":236,"_17":237},{"_38":227,"_13":228,"_32":229,"_134":214,"_135":80,"_136":79,"_137":24,"_40":230,"_78":26,"_34":150,"_139":231,"_36":30,"_140":-5,"_201":232,"_17":233},{"_38":220,"_13":221,"_32":222,"_134":214,"_135":80,"_136":79,"_137":24,"_40":223,"_78":26,"_34":150,"_139":224,"_36":30,"_140":-5,"_201":225,"_17":226},{"_38":211,"_13":212,"_32":213,"_134":214,"_135":80,"_136":79,"_137":24,"_40":215,"_78":26,"_34":150,"_139":216,"_36":30,"_140":-5,"_201":217,"_17":218},{"_38":204,"_13":205,"_32":206,"_134":-5,"_135":80,"_136":79,"_137":24,"_40":207,"_78":26,"_34":21,"_139":208,"_36":30,"_140":-5,"_201":209,"_17":210},{"_38":196,"_13":197,"_32":51,"_134":-5,"_135":80,"_136":79,"_137":24,"_40":198,"_78":26,"_34":199,"_139":200,"_36":30,"_140":-5,"_201":202,"_17":203},"1d74b4f4-ff6a-11ef-859d-569c3dd06744","index.ts",["D",1741801669719],"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",[],[197],"1d74b1c0-ff6a-11ef-859d-569c3dd06744","README.md","17f7e7e5-376e-4971-b740-551fbdadfa3b",["D",1741801669719],"# 🪿 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.",[],[205],"1d74ad4c-ff6a-11ef-859d-569c3dd06744","hono.ts","cc77c1b8-8894-49d0-ae19-1f06c07e7437","000a27bc-a6d2-41b2-a084-5ead218de9e2",["D",1741801669719],"/**\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 };",[],[219,212],"deps","1d749686-ff6a-11ef-859d-569c3dd06744","fiberplane.ts","28455308-b376-42a9-9079-660be02c5bfb",["D",1741801669719],"import { createFiberplane, createOpenAPISpec } from \"https://esm.sh/@fiberplane/hono@0.4.4\";\n\nexport { createFiberplane, createOpenAPISpec };",[],[219,221],"1d74946a-ff6a-11ef-859d-569c3dd06744","drizzle.ts","5e9e889b-1ea4-4a71-b7a6-60031c321f63",["D",1741801669719],"// 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 };",[],[219,228],"1d74afd6-ff6a-11ef-859d-569c3dd06744",["D",1741801669719],[191,192,193],[219],["D",1741801669719],[],[18,147],["D",1741801669719],[],[18,154],["D",1741801669719],[],[18,160],["D",1741801669719],[],[18,166],["D",1741801669719],[186,187,188,189],[18],"1d7489b6-ff6a-11ef-859d-569c3dd06744","users.ts","e76467fe-5aa1-4bb4-98eb-3db9f8d0c839","30001992-c835-4abd-babf-1adf0f5abda0",["D",1741801669719],"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;",[],[261,254],"app","1d748754-ff6a-11ef-859d-569c3dd06744","a9e30272-347c-4577-9603-da03d615ea6c",["D",1741801669719],"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;",[],[261,147],"1d747ebc-ff6a-11ef-859d-569c3dd06744","home.tsx","f8d8f90e-623b-41c4-bbec-55ba6962d687",["D",1741801669719],"/** @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