[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_223":224,"_225":226},"routes/_app.x.$handle.$name",{"_97":96,"_32":44,"_105":87,"_27":106,"_13":14,"_107":-5,"_11":108,"_109":110,"_111":112,"_113":114,"_115":116,"_20":-5,"_117":-5,"_118":-5,"_119":25,"_120":121,"_122":123,"_124":-5,"_125":-5,"_126":127},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_42":43,"_32":44,"_37":45,"_46":-5,"_47":25,"_48":49,"_50":49,"_51":52,"_53":-5,"_18":54,"_55":-5,"_56":25,"_57":-5,"_58":-5,"_59":60,"_61":62,"_63":64,"_65":66,"_67":68,"_69":-5,"_70":71,"_72":71,"_73":74,"_75":74,"_76":74,"_77":71,"_78":71,"_79":80,"_81":82,"_83":84,"_85":25},"version",95,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":23,"_24":25,"_26":25,"_27":28,"_29":28},"file",{"_30":31,"_32":28,"_33":34,"_35":36,"_37":38,"_39":14,"_40":41,"_24":25},"previous",{"_30":31,"_32":28,"_33":34,"_35":36},"deleted",false,"deletedHere","path","app.tsx","latestPath","fileId","9c21651e-fa1d-11f0-a684-42dde27851f2","name","fileType","http","content","/** @jsxImportSource https://esm.sh/hono@latest/jsx **/\nimport {Context, Hono } from \"npm:hono@3\";\nimport { insertEvenceItem, type EvenceItem} from \"./db.ts\";\nimport { SiteNavBar } from \"./nav.tsx\";\n\nconst hono = new Hono();\n\nfunction MainPage() {\n return (\n \n \n \n \n \n \n Evence\n \n \n

\n \n

\n \n \n

\n \n \n\n );\n}\n\nhono.get(\"/\", (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;","createdAt",["D",1769740971469],"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",{"_97":96,"_104":100},"org",{"_97":96,"_98":-5,"_99":100,"_18":54,"_101":102,"_103":25},"branch",{"_13":86,"_32":87,"_42":41,"_88":43,"_89":-5,"_90":-5,"_91":-5,"_92":-5,"_93":-5,"_94":44,"_95":96},"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",{"_42":43,"_32":44,"_37":218,"_46":-5,"_47":25,"_48":49,"_50":49,"_51":52,"_53":-5,"_18":54,"_55":-5,"_56":25,"_57":-5,"_58":-5,"_59":60,"_61":62,"_63":64,"_65":66,"_67":219,"_69":-5,"_70":71,"_72":71,"_73":74,"_75":74,"_76":74,"_77":71,"_78":71,"_79":220,"_81":221,"_83":222,"_85":25},"tree",[193,194,195,196,197,198],"files",[193,194,195,196,197,198],"counts",{"_182":60,"_183":184,"_185":60,"_186":187,"_188":189},"contents",[128,129,130,131,132,133],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles",true,"grants","orgs","customDomains",{},{"_42":178,"_32":28,"_30":31,"_137":-5,"_40":41,"_39":14,"_139":25,"_37":179,"_13":180,"_33":34,"_35":36,"_24":25,"_144":-5,"_27":181},{"_42":170,"_32":171,"_30":172,"_137":-5,"_40":41,"_39":173,"_139":25,"_37":174,"_13":175,"_33":142,"_35":176,"_24":25,"_144":-5,"_27":177},{"_42":163,"_32":164,"_30":165,"_137":-5,"_40":41,"_39":166,"_139":25,"_37":167,"_13":160,"_33":142,"_35":168,"_24":25,"_144":-5,"_27":169},{"_42":155,"_32":156,"_30":157,"_137":-5,"_40":41,"_39":158,"_139":25,"_37":159,"_13":160,"_33":142,"_35":161,"_24":25,"_144":-5,"_27":162},{"_42":146,"_32":147,"_30":148,"_137":-5,"_40":41,"_39":149,"_139":123,"_37":150,"_13":151,"_33":152,"_35":153,"_24":25,"_144":-5,"_27":154},{"_42":134,"_32":135,"_30":136,"_137":-5,"_40":41,"_39":138,"_139":25,"_37":140,"_13":141,"_33":142,"_35":143,"_24":25,"_144":-5,"_27":145},"376d905a-fd85-11f0-ad94-42dde27851f2","nav.tsx","a01729d2-fd84-11f0-9184-42dde27851f2","parentId",92,"latest",["D",1769740905072],5,"script","/** @jsxImportSource https://esm.sh/hono@latest/jsx **/\n\nexport function SiteNavBar() {\n return (\n \n);\n}","label",[135],"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}",[147],"3c7ddaf0-fd85-11f0-8bab-42dde27851f2","list.tsx","d2021ffc-fd83-11f0-b4b5-42dde27851f2",93,["D",1769740913568],3,"/** @jsxImportSource https://esm.sh/hono@latest/jsx **/\n\nexport function EvenceListPage(){\n return

EvenceListPage

;\n}",[156],"c29a2e2e-fd83-11f0-8745-42dde27851f2","form.tsx","75da34b2-fd83-11f0-92e0-42dde27851f2",81,["D",1769740279576],"/** @jsxImportSource https://esm.sh/hono@latest/jsx **/\n\nfunction AddEvenceForm(){\n return \n}",[164],"3aeb7378-fd7b-11f0-99cb-42dde27851f2","db.ts","ab18a210-fd6c-11f0-9b2a-42dde27851f2",56,["D",1769736615964],29,"// 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 { integer, 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: integer(\"id\").primaryKey(),\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 \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}",[171],"5f019062-fd85-11f0-8d21-42dde27851f2",["D",1769740971469],35,[28],"pulls","branches",1,"forks","envVars",{"_190":60,"_192":60},"connections",{"_190":60,"_191":60},"count","unfilledCount","emptyCount",{"_42":178,"_32":28,"_30":31,"_137":-5,"_40":41,"_39":14,"_139":25,"_37":215,"_13":180,"_33":34,"_35":36,"_24":25,"_144":-5,"_200":216,"_27":217},{"_42":170,"_32":171,"_30":172,"_137":-5,"_40":41,"_39":173,"_139":25,"_37":212,"_13":175,"_33":142,"_35":176,"_24":25,"_144":-5,"_200":213,"_27":214},{"_42":163,"_32":164,"_30":165,"_137":-5,"_40":41,"_39":166,"_139":25,"_37":209,"_13":160,"_33":142,"_35":168,"_24":25,"_144":-5,"_200":210,"_27":211},{"_42":155,"_32":156,"_30":157,"_137":-5,"_40":41,"_39":158,"_139":25,"_37":206,"_13":160,"_33":142,"_35":161,"_24":25,"_144":-5,"_200":207,"_27":208},{"_42":146,"_32":147,"_30":148,"_137":-5,"_40":41,"_39":149,"_139":123,"_37":203,"_13":151,"_33":152,"_35":153,"_24":25,"_144":-5,"_200":204,"_27":205},{"_42":134,"_32":135,"_30":136,"_137":-5,"_40":41,"_39":138,"_139":25,"_37":199,"_13":141,"_33":142,"_35":143,"_24":25,"_144":-5,"_200":201,"_27":202},["D",1769740905072],"children",[],[135],["D",1769366527462],[],[147],["D",1769740913568],[],[156],["D",1769740279576],[],[164],["D",1769736615964],[],[171],["D",1769740971469],[],[28],["D",1767093358821],["D",1789533648586],{"_97":96,"_104":100},{"_97":96,"_98":-5,"_99":100,"_18":54,"_101":102,"_103":25},{"_13":86,"_32":87,"_42":41,"_88":43,"_89":-5,"_90":-5,"_91":-5,"_92":-5,"_93":-5,"_94":44,"_95":96},"ctx",{"_79":-5,"_125":256,"_257":258,"_259":260,"_261":25,"_262":25,"_263":25,"_264":123,"_265":-5,"_266":-7,"_267":-7,"_268":60,"_269":25,"_270":25,"_271":-5,"_272":25,"_273":25,"_274":25,"_275":-5},"ENV",{"_227":228,"_229":230,"_231":87,"_232":233,"_234":235,"_236":237,"_238":239,"_240":241,"_242":243,"_244":245,"_246":247,"_248":249,"_250":251,"_252":253,"_254":255},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","e87eb04e707cf64e7e532c8e8ec395f209e17f15","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 · v95