[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_263":264,"_265":266},"routes/_app.x.$handle.$name",{"_98":97,"_32":45,"_106":88,"_27":107,"_13":14,"_108":-5,"_11":109,"_110":111,"_112":113,"_114":115,"_116":117,"_20":-5,"_118":-5,"_119":-5,"_120":25,"_121":122,"_123":124,"_125":-5,"_126":-5,"_127":128},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_43":44,"_32":45,"_38":46,"_47":-5,"_48":25,"_49":50,"_51":50,"_52":53,"_54":-5,"_18":55,"_56":-5,"_57":25,"_58":-5,"_59":-5,"_60":61,"_62":63,"_64":65,"_66":67,"_68":69,"_70":-5,"_71":72,"_73":72,"_74":75,"_76":75,"_77":75,"_78":72,"_79":72,"_80":81,"_82":83,"_84":85,"_86":25},"version",151,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":23,"_24":25,"_26":25,"_27":28,"_29":28},"file",{"_30":31,"_32":28,"_33":34,"_35":37,"_38":39,"_40":14,"_41":42,"_24":25},"previous",{"_30":31,"_32":28,"_33":34,"_35":36},"deleted",false,"deletedHere","path","db.ts","latestPath","fileId","ab18a210-fd6c-11f0-9b2a-42dde27851f2","name","fileType","script","content","// import { nanoid } from \"https://esm.sh/nanoid@5.0.5\";\nimport { sqlite } from \"https://esm.town/v/std/sqlite\";\nimport { eq, sql } from \"npm:drizzle-orm\";\nimport { drizzle } from \"npm:drizzle-orm/libsql\";\nimport { int, sqliteTable, text } from \"npm:drizzle-orm/sqlite-core\";\n\nexport const db = drizzle(sqlite as any);\n\nconst EVENCE_TABLE_NAME = \"evence_items\";\n\nexport const evenceItems = sqliteTable(EVENCE_TABLE_NAME, {\n id: int(\"id\").primaryKey({ autoIncrement: true }),\n uniqueId: text(\"uniqueId\").notNull(),\n title: text(\"title\").notNull(),\n content: text(\"content\").notNull(),\n type: text(\"type\").notNull(), // bill, task, note, dump\n created_at: text(\"created_at\").notNull().default(sql`current_timestamp`),\n deleted_at: text(\"deleted_at\").default(sql`null`),\n});\n\nexport type NewEvenceItem = typeof evenceItems.$inferInsert;\nexport type EvenceItem = typeof evenceItems.$inferSelect;\n\nexport async function insertEvenceItem(\n uniqueId: string,\n title: string,\n content: string,\n type: string,\n) {\n await db.insert(evenceItems).values({\n title,\n content,\n uniqueId,\n type,\n });\n}\n\nexport async function getEvenceItems(): Promise {\n return await db.select().from(evenceItems);\n}\n\nexport async function getEvenceItem(id: number): Promise {\n return await db.select().from(evenceItems).where(eq(evenceItems.id, id));\n}\n\nexport async function deleteEvenceItem(id: number) {\n // move to trash before deleting\n // insert then delete\n // await db.insert(evenceItemTrash).values(getEvenceItem(id)[0]);\n // update deleted_at\n // await db.update(evenceItemsTrash).set({ deleted_at: new Date().toDateString() }).where(eq(evenceItemsTrash.id, id));\n // then delete\n // await db.delete(evenceItems).where(eq(evenceItems.id, id));\n\n // or use soft-deletes\n await db\n .update(evenceItems)\n .set({ deleted_at: new Date().toDateString() })\n .where(eq(evenceItems.id, id));\n}\n\nexport async function updateEvenceItem(\n id: number,\n title: string,\n content: string,\n type?: string,\n) {\n // check if type is passed and update if so\n if (type && type !== \"undefined\" && type.length !== 0) {\n await db\n .update(evenceItems)\n .set({ title, content, type })\n .where(eq(evenceItems.id, id));\n }\n\n // if type is not passed, just update title and content\n await db\n .update(evenceItems)\n .set({ title, content })\n .where(eq(evenceItems.id, id));\n}","// import { nanoid } from \"https://esm.sh/nanoid@5.0.5\";\nimport { sqlite } from \"https://esm.town/v/std/sqlite\";\nimport { eq, sql } from \"npm:drizzle-orm\";\nimport { drizzle } from \"npm:drizzle-orm/libsql\";\nimport { int, sqliteTable, text } from \"npm:drizzle-orm/sqlite-core\";\n\nexport const db = drizzle(sqlite as any);\n\nconst EVENCE_TABLE_NAME = \"evence_items\";\n\nexport const evenceItems = sqliteTable(EVENCE_TABLE_NAME, {\n id: int().primaryKey({ autoIncrement: true }),\n uniqueId: text().notNull(),\n title: text().notNull(),\n content: text().notNull(),\n type: text().notNull(), // bill, task, note, dump\n created_at: text().notNull().default(sql`current_timestamp`),\n deleted_at: text().default(sql`null`),\n});\n\nexport type NewEvenceItem = typeof evenceItems.$inferInsert;\nexport type EvenceItem = typeof evenceItems.$inferSelect;\n\nexport async function insertEvenceItem(\n uniqueId: string,\n title: string,\n content: string,\n type: string,\n) {\n await db.insert(evenceItems).values({\n title,\n content,\n uniqueId,\n type,\n });\n}\n\nexport async function getEvenceItems(): Promise {\n return await db.select().from(evenceItems);\n}\n\nexport async function getEvenceItem(id: number): Promise {\n return await db.select().from(evenceItems).where(eq(evenceItems.id, id));\n}\n\nexport async function deleteEvenceItem(id: number) {\n // move to trash before deleting\n // insert then delete\n // await db.insert(evenceItemTrash).values(getEvenceItem(id)[0]);\n // update deleted_at\n // await db.update(evenceItemsTrash).set({ deleted_at: new Date().toDateString() }).where(eq(evenceItemsTrash.id, id));\n // then delete\n // await db.delete(evenceItems).where(eq(evenceItems.id, id));\n\n // or use soft-deletes\n await db\n .update(evenceItems)\n .set({ deleted_at: new Date().toDateString() })\n .where(eq(evenceItems.id, id));\n}\n\nexport async function updateEvenceItem(\n id: number,\n title: string,\n content: string,\n type?: string,\n) {\n // check if type is passed and update if so\n if (type && type !== \"undefined\" && type.length !== 0) {\n await db\n .update(evenceItems)\n .set({ title, content, type })\n .where(eq(evenceItems.id, id));\n }\n\n // if type is not passed, just update title and content\n await db\n .update(evenceItems)\n .set({ title, content })\n .where(eq(evenceItems.id, id));\n}","createdAt",["D",1769929105296],"branchVersion","branchId","eae1fd1a-e570-11f0-b53f-42dde27851f2","id","eae1c4bc-e570-11f0-b53f-42dde27851f2","spaced-remember-notify",["D",1767093358821],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","System to send messages to my email","imageUrl","d2953520-5bfe-11f0-8277-01ae82f9a955","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount",0,"orgId","d2953521-5bfe-11f0-8277-01ae82f9a955","tursoName","eae1c4bce57011f0b53f42dde27851f2","tursoHostname","eae1c4bce57011f0b53f42dde27851f2-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789533648586],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_98":97,"_105":101},"org",{"_98":97,"_99":-5,"_100":101,"_18":55,"_102":103,"_104":25},"branch",{"_13":87,"_32":88,"_43":42,"_89":44,"_90":-5,"_91":-5,"_92":-5,"_93":-5,"_94":-5,"_95":45,"_96":97},"isOwned",153,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","eniolajayi","handle","displayName","avatar","https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvb2F1dGhfZ2l0aHViL2ltZ18yemF0VkN0TU5wTmJQWENOS0FHRmlMZWNwbUMifQ","tier","free","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_43":44,"_32":45,"_38":258,"_47":-5,"_48":25,"_49":50,"_51":50,"_52":53,"_54":-5,"_18":55,"_56":-5,"_57":25,"_58":-5,"_59":-5,"_60":61,"_62":63,"_64":65,"_66":67,"_68":259,"_70":-5,"_71":72,"_73":72,"_74":75,"_76":75,"_77":75,"_78":72,"_79":72,"_80":260,"_82":261,"_84":262,"_86":25},"tree",[221,222,223,224,225,226,227,228,229],"files",[221,222,223,224,225,226,227,228,229],"counts",{"_210":61,"_211":212,"_213":61,"_214":215,"_216":217},"contents",[129,130,131,132,133,134,135,136,137],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles",true,"grants","orgs","customDomains",{},{"_43":201,"_32":202,"_30":203,"_141":-5,"_41":42,"_40":204,"_143":124,"_38":205,"_13":206,"_33":207,"_35":208,"_24":25,"_147":-5,"_27":209},{"_43":193,"_32":194,"_30":195,"_141":-5,"_41":42,"_40":196,"_143":124,"_38":197,"_13":198,"_33":34,"_35":199,"_24":25,"_147":-5,"_27":200},{"_43":189,"_32":28,"_30":31,"_141":-5,"_41":42,"_40":14,"_143":25,"_38":190,"_13":191,"_33":34,"_35":37,"_24":25,"_147":-5,"_27":192},{"_43":181,"_32":182,"_30":183,"_141":-5,"_41":42,"_40":184,"_143":124,"_38":185,"_13":186,"_33":34,"_35":187,"_24":25,"_147":-5,"_27":188},{"_43":173,"_32":174,"_30":175,"_141":-5,"_41":42,"_40":176,"_143":124,"_38":177,"_13":178,"_33":34,"_35":179,"_24":25,"_147":-5,"_27":180},{"_43":166,"_32":167,"_30":168,"_141":-5,"_41":42,"_40":169,"_143":124,"_38":170,"_13":145,"_33":34,"_35":171,"_24":25,"_147":-5,"_27":172},{"_43":157,"_32":158,"_30":159,"_141":-5,"_41":42,"_40":160,"_143":124,"_38":161,"_13":162,"_33":163,"_35":164,"_24":25,"_147":-5,"_27":165},{"_43":149,"_32":150,"_30":151,"_141":-5,"_41":42,"_40":152,"_143":124,"_38":153,"_13":154,"_33":34,"_35":155,"_24":25,"_147":-5,"_27":156},{"_43":138,"_32":139,"_30":140,"_141":-5,"_41":42,"_40":142,"_143":124,"_38":144,"_13":145,"_33":34,"_35":146,"_24":25,"_147":-5,"_27":148},"409f378c-ff38-11f0-937f-42dde27851f2","view-evence-list-page.tsx","0ad7a380-fd87-11f0-ba8d-42dde27851f2","parentId",144,"latest",["D",1769927751576],5,"/** @jsxImportSource https://esm.sh/hono@latest/jsx **/\n\nimport BaseLayout from \"./layout.tsx\";\nimport { EvenceList } from \"./list.tsx\";\n\nexport default function ViewEvenceListPage() {\n return (\n \n

Your Evences

\n \n

\n \n );\n}","label",[139],"df4cbcc4-ff38-11f0-b03f-42dde27851f2","nav.tsx","a01729d2-fd84-11f0-9184-42dde27851f2",148,["D",1769928017795],8,"/** @jsxImportSource https://esm.sh/hono@latest/jsx **/\n\nexport function SiteNavBar() {\n return (\n \n );\n}",[150],"8cfabb80-fa1d-11f0-a586-42dde27851f2","main.ts","eae37ee2-e570-11f0-b53f-42dde27851f2",15,["D",1769366527462],14,"interval","// Enter and store a message, at a particular time and date, notify me about the message.\n// The message can be repeated.\n// import { sqlite } from \"https://esm.town/v/std/sqlite\";\nimport { email } from \"https://esm.town/v/std/email?v=12\";\n\n// const data = await sqlite.execute(\"SELECT datetime();\");\n// console.log(data.rows[0]);\n\nexport async function sendPersonalMail() {\n await email({\n from: { email: \"eniolajayi.valname@valtown.email\", name: \"Eminence\" },\n subject: `Good morning Eniola! Your tasks and mail for today are ready!`,\n html: `\n \n

Hi Eniola

your tasks and personal mail for today are ready!

Tasks

Make time for 30 minutes with this morning mail project. let's go
Have you gotten your measurements for Creative Casting?
Sign up for your drivers test
Need to do the laundry

To Note

We can push this eminence project further.

\n \n `,\n });\n}",[158],"969db7f4-fd89-11f0-9f78-42dde27851f2","list.tsx","d2021ffc-fd83-11f0-b4b5-42dde27851f2",135,["D",1769742782760],"/** @jsxImportSource https://esm.sh/hono@latest/jsx **/\n\nexport function EvenceList() {\n return (\n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n

Planet	Diameter (km)	Distance to Sun (AU)	Orbit (days)
Mercury	4,880	0.39	88
Venus	12,104	0.72	225
Earth	12,742	1.00	365
Mars	6,779	1.52	687
Average	9,126	0.91	341

\n );\n}",[167],"73682f12-fd89-11f0-8b2b-42dde27851f2","layout.tsx","d7e8c8e6-fd86-11f0-8ea0-42dde27851f2",134,["D",1769742723690],7,"/** @jsxImportSource https://esm.sh/hono@latest/jsx **/\n\nimport { SiteNavBar } from \"./nav.tsx\";\n\nexport default function BaseLayout({ children }) {\n return (\n \n \n \n \n \n \n Evence\n \n \n \n

\n \n

\n {children}\n \n \n \n );\n}",[174],"c389daf6-fd87-11f0-b9b2-42dde27851f2","form.tsx","75da34b2-fd83-11f0-92e0-42dde27851f2",119,["D",1769741999140],4,"/** @jsxImportSource https://esm.sh/hono@latest/jsx **/\n\nexport function AddEvenceForm(){\n return \n}",[182],"678066de-ff3b-11f0-bb46-42dde27851f2",["D",1769929105296],32,[28],"bcc119bc-ff37-11f0-af9a-42dde27851f2","create-evence-page.tsx","f124e39e-fd86-11f0-a927-42dde27851f2",140,["D",1769927530342],11,"/** @jsxImportSource https://esm.sh/hono@latest/jsx **/\n\nimport { AddEvenceForm } from \"./form.tsx\";\nimport BaseLayout from \"./layout.tsx\";\n\nexport default function CreateEvencePage() {\n return (\n \n

Create Evence

\n \n

\n \n );\n}",[194],"672bbe70-ff38-11f0-a0ea-42dde27851f2","app.tsx","9c21651e-fa1d-11f0-a684-42dde27851f2",146,["D",1769927816256],56,"http","/** @jsxImportSource https://esm.sh/hono@latest/jsx **/\nimport { Context, Hono } from \"npm:hono@3\";\nimport { type EvenceItem, insertEvenceItem } from \"./db.ts\";\nimport BaseLayout from \"./layout.tsx\";\nimport CreateEvencePage from \"./create-evence-page.tsx\";\nimport ViewEvenceListPage from \"./view-evence-list-page.tsx\";\n\nconst hono = new Hono();\n\nfunction MainPage() {\n return (\n \n

\n \n \n

\n \n );\n}\n\nhono.get(\"/\", (c: Context) => {\n return c.html();\n});\n\nhono.get(\"/evence/create\", (c: Context) => {\n return c.html();\n});\n\nhono.get(\"/evence/view\", (c: Context) => {\n return c.html();\n});\n\nhono.post(\"/api/evence/new\", async (c: Context) => {\n // const body = await c.req.parseBody();\n return c.json({\n ok: true,\n });\n});\n\nexport default hono.fetch;",[202],"pulls","branches",1,"forks","envVars",{"_218":61,"_220":61},"connections",{"_218":61,"_219":61},"count","unfilledCount","emptyCount",{"_43":201,"_32":202,"_30":203,"_141":-5,"_41":42,"_40":204,"_143":124,"_38":255,"_13":206,"_33":207,"_35":208,"_24":25,"_147":-5,"_231":256,"_27":257},{"_43":193,"_32":194,"_30":195,"_141":-5,"_41":42,"_40":196,"_143":124,"_38":252,"_13":198,"_33":34,"_35":199,"_24":25,"_147":-5,"_231":253,"_27":254},{"_43":189,"_32":28,"_30":31,"_141":-5,"_41":42,"_40":14,"_143":25,"_38":249,"_13":191,"_33":34,"_35":37,"_24":25,"_147":-5,"_231":250,"_27":251},{"_43":181,"_32":182,"_30":183,"_141":-5,"_41":42,"_40":184,"_143":124,"_38":246,"_13":186,"_33":34,"_35":187,"_24":25,"_147":-5,"_231":247,"_27":248},{"_43":173,"_32":174,"_30":175,"_141":-5,"_41":42,"_40":176,"_143":124,"_38":243,"_13":178,"_33":34,"_35":179,"_24":25,"_147":-5,"_231":244,"_27":245},{"_43":166,"_32":167,"_30":168,"_141":-5,"_41":42,"_40":169,"_143":124,"_38":240,"_13":145,"_33":34,"_35":171,"_24":25,"_147":-5,"_231":241,"_27":242},{"_43":157,"_32":158,"_30":159,"_141":-5,"_41":42,"_40":160,"_143":124,"_38":237,"_13":162,"_33":163,"_35":164,"_24":25,"_147":-5,"_231":238,"_27":239},{"_43":149,"_32":150,"_30":151,"_141":-5,"_41":42,"_40":152,"_143":124,"_38":234,"_13":154,"_33":34,"_35":155,"_24":25,"_147":-5,"_231":235,"_27":236},{"_43":138,"_32":139,"_30":140,"_141":-5,"_41":42,"_40":142,"_143":124,"_38":230,"_13":145,"_33":34,"_35":146,"_24":25,"_147":-5,"_231":232,"_27":233},["D",1769927751576],"children",[],[139],["D",1769928017795],[],[150],["D",1769366527462],[],[158],["D",1769742782760],[],[167],["D",1769742723690],[],[174],["D",1769741999140],[],[182],["D",1769929105296],[],[28],["D",1769927530342],[],[194],["D",1769927816256],[],[202],["D",1767093358821],["D",1789533648586],{"_98":97,"_105":101},{"_98":97,"_99":-5,"_100":101,"_18":55,"_102":103,"_104":25},{"_13":87,"_32":88,"_43":42,"_89":44,"_90":-5,"_91":-5,"_92":-5,"_93":-5,"_94":-5,"_95":45,"_96":97},"ctx",{"_80":-5,"_126":296,"_297":298,"_299":300,"_301":25,"_302":25,"_303":25,"_304":124,"_305":-5,"_306":-7,"_307":-7,"_308":61,"_309":25,"_310":25,"_311":-5,"_312":25,"_313":25,"_314":25,"_315":-5},"ENV",{"_267":268,"_269":270,"_271":88,"_272":273,"_274":275,"_276":277,"_278":279,"_280":281,"_282":283,"_284":285,"_286":287,"_288":289,"_290":291,"_292":293,"_294":295},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","5015b8df46402d8bba4f485ecc37aec202b0e06b","RENDER_GIT_BRANCH","POSTHOG_API_TOKEN","phc_nmoyuAkStEZuUp69rYlg1DZgrIt19Gx0Y4Hwf8tGgJP","POSTHOG_API_HOST","https://wart.val.town","WEB_API_TEMPLATE","https://{val}.web.val.run","APP_URL","https://www.val.town","MODULE_URL","https://esm.town","VANITY_WEB_API_TEMPLATE","https://{label}.val.run/","DENOLS_URL","https://lsp.val.town","NODE_ENV","production","CLOUDFLARE_TURNSTILE_SITE_KEY","0x4AAAAAACtaIZJH7s9rBMZ6","GOOGLE_CLIENT_ID","875989696899-jtsqkhlbdv5jrlsk8631p7ipjg3c6o62.apps.googleusercontent.com","STRIPE_PUBLISHABLE_KEY","pk_live_51N2zvWEpZTTLipIkVEwXrUG9AT0yeOOEYxszarZT1jpsZV58Ly6wlg3SltZpHN26CUalOBmUSY7adQRQiSkCZz2500qSXNkf8Y","API_URL","https://api.val.town",[],"preferencesKeybindings","default","preferencesTheme","light","preferencesFixers","preferencesCopilot","preferencesSelectionAi","preferencesCloseBrackets","preferencesChatPanelState","preferencesDprint","preferencesDenofmt","notificationCount","flagDenols","isBusinessOrgMember","businessOrgHandle","isBusinessOrgAdmin","isHigherTownieTier","navCollapsed","currentOrgId"]

Diff · v151