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}",[150],"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}",[159],"e8c57e8e-fd86-11f0-8047-42dde27851f2","layout.tsx","d7e8c8e6-fd86-11f0-8ea0-42dde27851f2",108,["D",1769741632103],2,"/** @jsxImportSource https://esm.sh/hono@latest/jsx **/\n\nexport default function File() {\n return

File

;\n}",[167],"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}",[175],"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}",[182],"d44f6e88-fd86-11f0-9907-42dde27851f2","app.tsx","9c21651e-fa1d-11f0-a684-42dde27851f2",105,["D",1769741597774],45,"http","/** @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 );\n}\n\nhono.get(\"/\", (c: Context) => {\n return c.html();\n});\n\nhono.get(\"/create\", ()=>{\n return c.html();\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;",[190],"pulls","branches",1,"forks","envVars",{"_206":60,"_208":60},"connections",{"_206":60,"_207":60},"count","unfilledCount","emptyCount",{"_42":189,"_32":190,"_30":191,"_136":-5,"_40":41,"_39":192,"_137":24,"_37":239,"_13":194,"_33":195,"_35":196,"_23":24,"_139":-5,"_218":240,"_26":241},{"_42":181,"_32":182,"_30":183,"_136":-5,"_40":41,"_39":184,"_137":24,"_37":236,"_13":186,"_33":34,"_35":187,"_23":24,"_139":-5,"_218":237,"_26":238},{"_42":174,"_32":175,"_30":176,"_136":-5,"_40":41,"_39":177,"_137":24,"_37":233,"_13":163,"_33":34,"_35":179,"_23":24,"_139":-5,"_218":234,"_26":235},{"_42":166,"_32":167,"_30":168,"_136":-5,"_40":41,"_39":169,"_137":24,"_37":230,"_13":171,"_33":34,"_35":172,"_23":24,"_139":-5,"_218":231,"_26":232},{"_42":158,"_32":159,"_30":160,"_136":-5,"_40":41,"_39":161,"_137":24,"_37":227,"_13":163,"_33":34,"_35":164,"_23":24,"_139":-5,"_218":228,"_26":229},{"_42":149,"_32":150,"_30":151,"_136":-5,"_40":41,"_39":152,"_137":122,"_37":224,"_13":154,"_33":155,"_35":156,"_23":24,"_139":-5,"_218":225,"_26":226},{"_42":141,"_32":142,"_30":143,"_136":-5,"_40":41,"_39":144,"_137":24,"_37":221,"_13":146,"_33":34,"_35":147,"_23":24,"_139":-5,"_218":222,"_26":223},{"_42":135,"_32":27,"_30":31,"_136":-5,"_40":41,"_39":14,"_137":24,"_37":217,"_13":60,"_33":34,"_35":36,"_23":24,"_139":-5,"_218":219,"_26":220},["D",1769741646158],"children",[],[27],["D",1769740905072],[],[142],["D",1769366527462],[],[150],["D",1769740913568],[],[159],["D",1769741632103],[],[167],["D",1769740279576],[],[175],["D",1769736615964],[],[182],["D",1769741597774],[],[190],["D",1767093358821],["D",1789533648586],{"_97":96,"_104":100},{"_97":96,"_98":-5,"_99":100,"_18":54,"_101":102,"_103":24},{"_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,"_124":280,"_281":282,"_283":284,"_285":24,"_286":24,"_287":24,"_288":122,"_289":-5,"_290":-7,"_291":-7,"_292":60,"_293":24,"_294":24,"_295":-5,"_296":24,"_297":24,"_298":24,"_299":-5},"ENV",{"_251":252,"_253":254,"_255":87,"_256":257,"_258":259,"_260":261,"_262":263,"_264":265,"_266":267,"_268":269,"_270":271,"_272":273,"_274":275,"_276":277,"_278":279},"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 · v109