[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_293":294,"_295":296},"routes/_app.x.$handle.$name",{"_11":12,"_13":14,"_15":16,"_106":107,"_39":-7,"_108":-5,"_17":109,"_110":111,"_112":113,"_114":115,"_116":117,"_118":-5,"_119":120,"_121":122,"_123":25,"_124":125,"_126":76,"_127":-5,"_128":-5,"_129":130},"routes/_app.x.$handle.$name.compare.$branch",{"_11":12,"_13":14,"_15":16,"_17":18,"_19":20,"_21":20,"_22":23,"_24":25,"_26":27,"_28":29,"_30":-5},"handle","charmaine","name","HONC","branchName","main","project",{"_31":56,"_13":14,"_33":66,"_45":-5,"_67":25,"_47":48,"_68":48,"_69":-5,"_70":-5,"_71":72,"_73":74,"_75":76,"_77":-5,"_78":-5,"_79":20,"_51":80,"_81":-5,"_82":-5,"_83":-5,"_84":-5,"_85":86,"_87":86,"_88":89,"_90":89,"_91":89,"_92":86,"_93":86,"_94":95,"_96":97,"_98":27,"_46":25},"ahead",0,"behind","diff",{"_60":61,"_62":63,"_64":65},"hasChanges",false,"sourceBranch",{"_39":54,"_13":16,"_31":55,"_37":56,"_41":32,"_42":40,"_57":48,"_58":38,"_59":52,"_53":14,"_49":12},"targetBranch",{"_31":32,"_33":34,"_35":36,"_13":16,"_37":38,"_39":40,"_41":-5,"_42":-5,"_43":44,"_45":-5,"_46":25,"_47":48,"_49":50,"_51":52,"_53":14},"pull","id","413bdebc-f6a0-11ef-969a-569c3dd06744","createdAt",["D",1740835362112],"updatedAt",["D",1741798186927],"projectId","413b5bb8-f6a0-11ef-969a-569c3dd06744","version",95,"forkedBranchId","forkedBranchVersion","lockfileKey","1766788753419-esm.town_v_fiberplane_HONC@95-main","deletedAt","isOwned","privacy","public","userHandle","fiberplane","orgId","2cdea40e-3470-4c15-b791-920f79c299a9","projectName",2,"ada0be34-0018-11f0-9579-569c3dd06744","ad9cea0c-0018-11f0-9579-569c3dd06744","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","added",[],"deleted",[],"modified",[],["D",1741876644034],"legacyEnvVars","httpPrivacy","description","imageUrl","userId","c156eb0e-8b9d-4104-a055-502e9a0eb441","pinnedFileId","4ee66784-dcf5-424c-a522-39dcb1c0219a","pinPreview",true,"pinMigrated","screenshotVersion","likeCount","2019e55b-c541-4c51-bef0-008eef10ef88","tursoName","tursoHostname","tursoMeasuredAt","pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_11":12,"_105":101},"org",{"_11":12,"_99":-5,"_100":101,"_71":72,"_102":103,"_104":25},"branch","displayName","avatar","https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvdXBsb2FkZWQvaW1nXzJ4cFpFME5pSXNZamJNd296dlZSYVJ0OVF1RSJ9","tier","pro","canRestrictVals","profileImageUrl","path","","adoptOrgId",{"_31":56,"_13":14,"_33":289,"_45":-5,"_67":25,"_47":48,"_68":48,"_69":-5,"_70":-5,"_71":72,"_73":74,"_75":76,"_77":-5,"_78":-5,"_79":20,"_51":80,"_81":-5,"_82":-5,"_83":-5,"_84":-5,"_85":86,"_87":86,"_88":89,"_90":89,"_91":89,"_92":86,"_93":86,"_94":290,"_96":291,"_98":292,"_46":25},"tree",[188,192,197,201,202],"files",[188,189,190,191,192,193,194,195,196,197,198,199,200,201,202],"counts",{"_178":20,"_179":147,"_180":20,"_181":182,"_183":184},"contents",[136,137,138,139,140],"file","upstreamProject",{"_31":38,"_13":14,"_69":133,"_70":-5,"_47":48,"_94":134},"upstreamBranch",{"_31":32,"_33":131,"_35":132,"_13":16,"_37":38,"_39":40,"_41":-5,"_42":-5,"_43":44,"_45":-5,"_46":25,"_47":48,"_49":50,"_51":52,"_53":14},"emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},["D",1740835362112],["D",1741798186927],"HONC app template on Val Town (honc.dev)",{"_11":50,"_105":135},"https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvdXBsb2FkZWQvaW1nXzJ0OXJLaXVodjZKMUU4QnFhODNCVkJ4aVRQSyJ9",{"_31":173,"_13":174,"_143":175,"_144":-5,"_145":55,"_146":147,"_148":76,"_33":176,"_39":20,"_150":166,"_152":-5,"_62":25,"_154":-5,"_106":177},{"_31":168,"_13":169,"_143":170,"_144":-5,"_145":55,"_146":147,"_148":76,"_33":171,"_39":20,"_150":166,"_152":-5,"_62":25,"_154":-5,"_106":172},{"_31":162,"_13":163,"_143":164,"_144":-5,"_145":55,"_146":147,"_148":76,"_33":165,"_39":20,"_150":166,"_152":-5,"_62":25,"_154":-5,"_106":167},{"_31":156,"_13":157,"_143":158,"_144":-5,"_145":55,"_146":147,"_148":76,"_33":159,"_39":20,"_150":118,"_152":160,"_62":25,"_154":-5,"_106":161},{"_31":141,"_13":142,"_143":74,"_144":-5,"_145":55,"_146":147,"_148":76,"_33":149,"_39":20,"_150":151,"_152":153,"_62":25,"_154":-5,"_106":155},"ada2bac2-0018-11f0-9579-569c3dd06744","index.ts","fileId","parentId","branchId","branchVersion",1,"latest",["D",1741876644034],"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}","label",[142],"ada2b900-0018-11f0-9579-569c3dd06744","README.md","760c4874-f4af-482e-adc3-382e807b523e",["D",1741876644034],"# 🪿 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.",[157],"ada2b784-0018-11f0-9579-569c3dd06744","deps","96f7b48c-1454-453e-b6e4-c184f18c44f4",["D",1741876644034],"directory",[163],"ada2b180-0018-11f0-9579-569c3dd06744","db","c792738c-93d5-42b5-8a55-cbacbbb9f158",["D",1741876644034],[169],"ada2aa82-0018-11f0-9579-569c3dd06744","app","0953de3d-c066-41a6-9c87-c50d00caad9a",["D",1741876644034],[174],"pulls","branches","forks","envVars",{"_185":20,"_187":20},"connections",{"_185":20,"_186":20},"count","unfilledCount","emptyCount",{"_31":173,"_13":174,"_143":175,"_144":-5,"_145":55,"_146":147,"_148":76,"_33":286,"_39":20,"_150":166,"_152":-5,"_62":25,"_154":-5,"_204":287,"_106":288},{"_31":279,"_13":280,"_143":281,"_144":175,"_145":55,"_146":147,"_148":76,"_33":282,"_39":20,"_150":214,"_152":283,"_62":25,"_154":-5,"_204":284,"_106":285},{"_31":273,"_13":236,"_143":274,"_144":175,"_145":55,"_146":147,"_148":76,"_33":275,"_39":20,"_150":214,"_152":276,"_62":25,"_154":-5,"_204":277,"_106":278},{"_31":266,"_13":267,"_143":268,"_144":175,"_145":55,"_146":147,"_148":76,"_33":269,"_39":20,"_150":214,"_152":270,"_62":25,"_154":-5,"_204":271,"_106":272},{"_31":168,"_13":169,"_143":170,"_144":-5,"_145":55,"_146":147,"_148":76,"_33":263,"_39":20,"_150":166,"_152":-5,"_62":25,"_154":-5,"_204":264,"_106":265},{"_31":256,"_13":257,"_143":258,"_144":170,"_145":55,"_146":147,"_148":76,"_33":259,"_39":20,"_150":214,"_152":260,"_62":25,"_154":-5,"_204":261,"_106":262},{"_31":249,"_13":250,"_143":251,"_144":170,"_145":55,"_146":54,"_148":76,"_33":252,"_39":147,"_150":214,"_152":253,"_62":25,"_154":-5,"_204":254,"_106":255},{"_31":242,"_13":243,"_143":244,"_144":170,"_145":55,"_146":147,"_148":76,"_33":245,"_39":20,"_150":214,"_152":246,"_62":25,"_154":-5,"_204":247,"_106":248},{"_31":235,"_13":236,"_143":237,"_144":170,"_145":55,"_146":147,"_148":76,"_33":238,"_39":20,"_150":214,"_152":239,"_62":25,"_154":-5,"_204":240,"_106":241},{"_31":162,"_13":163,"_143":164,"_144":-5,"_145":55,"_146":147,"_148":76,"_33":232,"_39":20,"_150":166,"_152":-5,"_62":25,"_154":-5,"_204":233,"_106":234},{"_31":225,"_13":226,"_143":227,"_144":164,"_145":55,"_146":147,"_148":76,"_33":228,"_39":20,"_150":214,"_152":229,"_62":25,"_154":-5,"_204":230,"_106":231},{"_31":218,"_13":219,"_143":220,"_144":164,"_145":55,"_146":147,"_148":76,"_33":221,"_39":20,"_150":214,"_152":222,"_62":25,"_154":-5,"_204":223,"_106":224},{"_31":210,"_13":211,"_143":212,"_144":164,"_145":55,"_146":147,"_148":76,"_33":213,"_39":20,"_150":214,"_152":215,"_62":25,"_154":-5,"_204":216,"_106":217},{"_31":156,"_13":157,"_143":158,"_144":-5,"_145":55,"_146":147,"_148":76,"_33":207,"_39":20,"_150":118,"_152":160,"_62":25,"_154":-5,"_204":208,"_106":209},{"_31":141,"_13":142,"_143":74,"_144":-5,"_145":55,"_146":147,"_148":76,"_33":203,"_39":20,"_150":151,"_152":153,"_62":25,"_154":-5,"_204":205,"_106":206},["D",1741876644034],"children",[],[142],["D",1741876644034],[],[157],"ada2b63a-0018-11f0-9579-569c3dd06744","hono.ts","c03bac84-1eb3-4d3b-a88b-719d624b333d",["D",1741876644034],"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 };",[],[163,211],"ada2b4aa-0018-11f0-9579-569c3dd06744","fiberplane.ts","21cc8125-ca22-41b1-8746-42e4f6ddff73",["D",1741876644034],"import { createFiberplane, createOpenAPISpec } from \"https://esm.sh/@fiberplane/hono@0.4.4\";\n\nexport { createFiberplane, createOpenAPISpec };",[],[163,219],"ada2b31a-0018-11f0-9579-569c3dd06744","drizzle.ts","6ac0dc7e-8ab4-4172-ac38-3f7f740fb51b",["D",1741876644034],"// 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 };",[],[163,226],["D",1741876644034],[198,199,200],[163],"ada2b02c-0018-11f0-9579-569c3dd06744","types.ts","5d60c49b-5ef0-44b3-bfc0-5f23695a18be",["D",1741876644034],"import type { LibSQLDatabase } from \"../deps/drizzle.ts\";\nimport type * as schema from \"./schema\";\n\nexport type DBType = LibSQLDatabase;",[],[169,236],"ada2ae60-0018-11f0-9579-569c3dd06744","schema.ts","a9a2e054-669b-4a13-909f-cf4b7c4b977c",["D",1741876644034],"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});",[],[169,243],"baf819c4-0018-11f0-bffb-569c3dd06744","migrate.ts","b565fba6-8bdf-4190-b464-bfa27844241f",["D",1741876666441],"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};",[],[169,250],"ada2ab7c-0018-11f0-9579-569c3dd06744","client.ts","80e81699-5440-4978-88c5-7572553704b3",["D",1741876644034],"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});",[],[169,257],["D",1741876644034],[193,194,195,196],[169],"ada2a7b2-0018-11f0-9579-569c3dd06744","users.ts","ebab3011-93c8-498a-a4a3-3eb5709d63bd",["D",1741876644034],"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;",[],[174,267],"ada2a5dc-0018-11f0-9579-569c3dd06744","cb316fa0-2e9c-4cc4-824b-4e10a6ee669b",["D",1741876644034],"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;",[],[174,236],"ada29dd0-0018-11f0-9579-569c3dd06744","home.tsx","0bcbd84c-d6f8-4cbc-b80a-d88af561a14d",["D",1741876644034],"/** @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

Compare

Mergecharmaine/mainintofiberplane/main