Happy Birthday! 🎉

🎂 Customize Birthday Card

\n \n

\n Celebrant's Name:\n \n

\n\n

\n Photo URL (optional):\n \n \n Upload to Imgur, Google Drive, or any image host\n \n

\n\n

\n Personal Message:\n \n

\n\n

\n \n \n

\n \n

\n 💡 After previewing, copy the final URL to share!\n

\n\n \n

\n \n

🎈

\n\n \n

\n\n \n \n\n \n

\n $\"Celebrant$ \n

\n 📸
Add a photo above!\n

\n\n \n

Your message will appear here...

\n\n \n \n

\n\n \n\n`;\n\nexport default function(req: Request): Response {\n return new Response(html, {\n headers: { \"Content-Type\": \"text/html; charset=utf-8\" },\n });\n}\n","deleted","label",[125],"05d75804-3d78-11f1-9314-42b51c65c3df","new-file-8905.ts","05d75930-3d78-11f1-9314-42b51c65c3df",25,["D",1776772112845],"script",[142],"2191c22e-3d77-11f1-9945-42b51c65c3df","new-file-5776.ts","6f2c7cfa-3d76-11f1-9fd2-42b51c65c3df",22,["D",1776771729861],2,"\n\n\n \n \n Happy Birthday! 🎉\n \n\n\n \n

🎂 Customize Birthday Card

\n \n

\n Celebrant's Name:\n \n

\n\n

\n Photo URL (optional):\n \n \n Upload to Imgur, Google Drive, or any image host\n \n

\n\n

\n Personal Message:\n \n

\n\n

\n \n \n

\n \n

\n 💡 After previewing, copy the final URL to share!\n

\n\n \n

\n \n

🎈

\n\n \n

\n\n \n \n\n \n

\n $\"Celebrant$ \n

\n 📸
Add a photo above!\n

\n\n \n

Your message will appear here...

\n\n \n \n

\n\n \n\n",[149],"0360bcdc-3d78-11f1-be0d-42b51c65c3df","new-file-1372.ts","0360bdc2-3d78-11f1-be0d-42b51c65c3df",24,["D",1776772108689],[157],"bcb77344-3d71-11f1-a974-42b51c65c3df","main.ts",9,["D",1776769413169],"import { Hono } from \"npm:hono@4\";\nimport { serveFile } from \"https://esm.town/v/std/utils/index.ts\";\nimport { parseVal } from \"https://esm.town/v/std/utils/index.ts\";\nimport { runMigrations } from \"./database/migrations.ts\";\nimport { createMessage, getMessagesForCelebrant, getAllMessages, getCelebrants } from \"./database/queries.ts\";\n\nconst app = new Hono();\n\n// Run migrations on startup\nlet migrated = false;\napp.use(\"*\", async (c, next) => {\n if (!migrated) {\n await runMigrations();\n migrated = true;\n }\n await next();\n});\n\napp.onError((err) => Promise.reject(err));\n\n// API routes\napp.get(\"/api/messages\", async (c) => {\n const celebrant = c.req.query(\"celebrant\");\n const messages = celebrant\n ? await getMessagesForCelebrant(celebrant)\n : await getAllMessages();\n return c.json(messages);\n});\n\napp.get(\"/api/celebrants\", async (c) => {\n const celebrants = await getCelebrants();\n return c.json(celebrants);\n});\n\napp.post(\"/api/messages\", async (c) => {\n const body = await c.req.json();\n if (!body.celebrantName || !body.senderName || !body.message) {\n return c.json({ error: \"All fields are required\" }, 400);\n }\n const msg = await createMessage(body);\n return c.json(msg, 201);\n});\n\n// View source\napp.get(\"/source\", (c) => c.redirect(parseVal().links.self.val));\n\n// Serve frontend files\napp.get(\"/frontend/*\", (c) => serveFile(c.req.path));\n\n// Serve index\napp.get(\"*\", (c) => serveFile(\"/frontend/index.html\"));\n\nexport default app.fetch;\n",[163],"eeb8dae0-3d71-11f1-8429-42b51c65c3df","README.md","eeb8db8a-3d71-11f1-8429-42b51c65c3df",19,["D",1776769497001],"# 🎂 Birthday Wishes\n\nA beautiful website for sending heartfelt birthday messages to celebrants!\n\n## Features\n\n- ✉️ **Send Birthday Wishes** — Write a personalized message for any birthday person\n- 🎊 **Confetti Animation** — Celebrate with confetti when a wish is sent\n- 🎈 **Birthday Wall** — Browse all wishes or filter by celebrant name\n- 📱 **Responsive Design** — Works beautifully on desktop and mobile\n\n## Architecture\n\n```mermaid\ngraph TB\n User[🧑 User] --> Frontend[React SPA]\n Frontend --> Hono[Hono API Server]\n Hono --> SQLite[(SQLite Database)]\n\n subgraph Frontend Components\n App --> MessageForm[Message Form]\n App --> CelebrantPicker[Celebrant Filter]\n App --> MessageList[Message List]\n MessageList --> MessageCard[Message Card]\n App --> Confetti[Confetti Effect]\n end\n```\n\n## Tech Stack\n\n- **Frontend**: React 18 + Twind (Tailwind CSS)\n- **Backend**: Hono on Val Town\n- **Database**: Val Town SQLite\n- **Fonts**: Pacifico (headings) + Inter (body)\n",[169],"b0a2dac6-3d71-11f1-a08b-42b51c65c3df","shared","b0a2db70-3d71-11f1-a08b-42b51c65c3df",5,["D",1776769392851],"directory",[176],"b0963fb4-3d71-11f1-b3d9-42b51c65c3df","frontend","b0964072-3d71-11f1-b3d9-42b51c65c3df",4,["D",1776769392829],[183],"b03dae62-3d71-11f1-94e7-42b51c65c3df","database","b03daf16-3d71-11f1-94e7-42b51c65c3df",["D",1776769392245],[189],"pulls",1,"forks","envVars",{"_200":54,"_202":54},"connections",{"_200":54,"_201":54},"count","unfilledCount","emptyCount",{"_20":188,"_13":189,"_126":190,"_128":-5,"_129":21,"_130":133,"_131":50,"_22":344,"_29":54,"_134":180,"_136":-5,"_138":38,"_139":-5,"_225":345,"_93":346},{"_20":336,"_13":337,"_126":338,"_128":190,"_129":21,"_130":339,"_131":50,"_22":340,"_29":54,"_134":146,"_136":341,"_138":38,"_139":-5,"_225":342,"_93":343},{"_20":328,"_13":329,"_126":330,"_128":190,"_129":21,"_130":331,"_131":50,"_22":332,"_29":54,"_134":146,"_136":333,"_138":38,"_139":-5,"_225":334,"_93":335},{"_20":182,"_13":183,"_126":184,"_128":-5,"_129":21,"_130":185,"_131":50,"_22":325,"_29":54,"_134":180,"_136":-5,"_138":38,"_139":-5,"_225":326,"_93":327},{"_20":320,"_13":287,"_126":281,"_128":184,"_129":21,"_130":321,"_131":50,"_22":322,"_29":54,"_134":180,"_136":-5,"_138":38,"_139":-5,"_225":323,"_93":324},{"_20":312,"_13":313,"_126":314,"_128":281,"_129":21,"_130":315,"_131":50,"_22":316,"_29":54,"_134":146,"_136":317,"_138":38,"_139":-5,"_225":318,"_93":319},{"_20":304,"_13":305,"_126":306,"_128":281,"_129":21,"_130":307,"_131":50,"_22":308,"_29":54,"_134":146,"_136":309,"_138":38,"_139":-5,"_225":310,"_93":311},{"_20":296,"_13":297,"_126":298,"_128":281,"_129":21,"_130":299,"_131":50,"_22":300,"_29":54,"_134":146,"_136":301,"_138":38,"_139":-5,"_225":302,"_93":303},{"_20":288,"_13":289,"_126":290,"_128":281,"_129":21,"_130":291,"_131":50,"_22":292,"_29":54,"_134":146,"_136":293,"_138":38,"_139":-5,"_225":294,"_93":295},{"_20":278,"_13":279,"_126":280,"_128":281,"_129":21,"_130":282,"_131":50,"_22":283,"_29":54,"_134":146,"_136":284,"_138":38,"_139":-5,"_225":285,"_93":286},{"_20":270,"_13":271,"_126":272,"_128":184,"_129":21,"_130":273,"_131":50,"_22":274,"_29":54,"_134":146,"_136":275,"_138":38,"_139":-5,"_225":276,"_93":277},{"_20":262,"_13":263,"_126":264,"_128":184,"_129":21,"_130":265,"_131":50,"_22":266,"_29":54,"_134":104,"_136":267,"_138":38,"_139":-5,"_225":268,"_93":269},{"_20":254,"_13":255,"_126":256,"_128":184,"_129":21,"_130":257,"_131":50,"_22":258,"_29":54,"_134":146,"_136":259,"_138":38,"_139":-5,"_225":260,"_93":261},{"_20":175,"_13":176,"_126":177,"_128":-5,"_129":21,"_130":178,"_131":50,"_22":251,"_29":54,"_134":180,"_136":-5,"_138":38,"_139":-5,"_225":252,"_93":253},{"_20":243,"_13":244,"_126":245,"_128":177,"_129":21,"_130":246,"_131":50,"_22":247,"_29":54,"_134":146,"_136":248,"_138":38,"_139":-5,"_225":249,"_93":250},{"_20":168,"_13":169,"_126":170,"_128":-5,"_129":21,"_130":171,"_131":50,"_22":240,"_29":54,"_134":104,"_136":173,"_138":38,"_139":-5,"_225":241,"_93":242},{"_20":162,"_13":163,"_126":48,"_128":-5,"_129":21,"_130":164,"_131":50,"_22":237,"_29":153,"_134":135,"_136":166,"_138":38,"_139":-5,"_225":238,"_93":239},{"_20":156,"_13":157,"_126":158,"_128":-5,"_129":21,"_130":159,"_131":50,"_22":234,"_29":54,"_134":146,"_136":87,"_138":38,"_139":-5,"_225":235,"_93":236},{"_20":148,"_13":149,"_126":150,"_128":-5,"_129":21,"_130":151,"_131":50,"_22":231,"_29":153,"_134":135,"_136":154,"_138":38,"_139":-5,"_225":232,"_93":233},{"_20":141,"_13":142,"_126":143,"_128":-5,"_129":21,"_130":144,"_131":50,"_22":228,"_29":54,"_134":146,"_136":87,"_138":38,"_139":-5,"_225":229,"_93":230},{"_20":124,"_13":125,"_126":127,"_128":-5,"_129":21,"_130":30,"_131":50,"_22":224,"_29":133,"_134":135,"_136":137,"_138":38,"_139":-5,"_225":226,"_93":227},["D",1776772451883],"children",[],[125],["D",1776772112845],[],[142],["D",1776771729861],[],[149],["D",1776772108689],[],[157],["D",1776769413169],[],[163],["D",1776769497001],[],[169],"b2d2c7ca-3d71-11f1-a08b-42b51c65c3df","types.ts","b2d2c8b0-3d71-11f1-a08b-42b51c65c3df",6,["D",1776769396578],"export interface BirthdayMessage {\n id: number;\n celebrantName: string;\n senderName: string;\n message: string;\n createdAt: string;\n}\n\nexport interface CreateMessagePayload {\n celebrantName: string;\n senderName: string;\n message: string;\n}\n",[],[176,244],["D",1776769392851],[217],[176],"c208756e-3d71-11f1-ad26-42b51c65c3df","index.tsx","c208764a-3d71-11f1-ad26-42b51c65c3df",11,["D",1776769422100],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React from \"https://esm.sh/react@18.2.0\";\nimport ReactDOM from \"https://esm.sh/react-dom@18.2.0/client\";\nimport { App } from \"./App.tsx\";\n\nconst root = ReactDOM.createRoot(document.getElementById(\"root\")!);\nroot.render();\n",[],[183,255],"bed5d1c0-3d71-11f1-843d-42b51c65c3df","index.html","bed5d27e-3d71-11f1-843d-42b51c65c3df",10,["D",1776769416739],"\n\n\n \n \n 🎂 Birthday Wishes\n \n \n \n \n \n\n\n

\n \n\n\n",[],[183,263],"c87ccb20-3d71-11f1-94e7-42b51c65c3df","App.tsx","c87ccbc0-3d71-11f1-94e7-42b51c65c3df",12,["D",1776769432929],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useState } from \"https://esm.sh/react@18.2.0\";\nimport { MessageForm } from \"./components/MessageForm.tsx\";\nimport { MessageList } from \"./components/MessageList.tsx\";\nimport { CelebrantPicker } from \"./components/CelebrantPicker.tsx\";\nimport { Confetti } from \"./components/Confetti.tsx\";\nimport type { BirthdayMessage } from \"../shared/types.ts\";\n\nexport function App() {\n const [messages, setMessages] = useState([]);\n const [selectedCelebrant, setSelectedCelebrant] = useState(\"\");\n const [showConfetti, setShowConfetti] = useState(false);\n const [refreshKey, setRefreshKey] = useState(0);\n\n const handleMessageSent = (msg: BirthdayMessage) => {\n setMessages((prev) => [msg, ...prev]);\n setSelectedCelebrant(msg.celebrantName);\n setShowConfetti(true);\n setRefreshKey((k) => k + 1);\n setTimeout(() => setShowConfetti(false), 4000);\n };\n\n return (\n \n {showConfetti && }\n\n {/* Header */}\n

🎂

\n \n Happy Birthday!\n \n

\n Send a warm birthday wish to someone special 🎉🎈\n

\n\n

\n {/* Send a wish form */}\n \n\n {/* Browse wishes */}\n

\n \n Birthday Wall 🎊\n \n \n \n

\n\n {/* Footer */}\n \n \n );\n}\n",[],[183,271],"d7500c98-3d71-11f1-ad26-42b51c65c3df","MessageList.tsx","d7500d74-3d71-11f1-ad26-42b51c65c3df","c9f884a8-3d71-11f1-ad26-42b51c65c3df",15,["D",1776769457802],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useState, useEffect } from \"https://esm.sh/react@18.2.0\";\nimport type { BirthdayMessage } from \"../../shared/types.ts\";\nimport { MessageCard } from \"./MessageCard.tsx\";\n\ninterface Props {\n celebrant: string;\n externalMessages: BirthdayMessage[];\n}\n\nexport function MessageList({ celebrant, externalMessages }: Props) {\n const [messages, setMessages] = useState([]);\n const [loading, setLoading] = useState(false);\n\n useEffect(() => {\n const fetchMessages = async () => {\n setLoading(true);\n try {\n const url = celebrant\n ? `/api/messages?celebrant=${encodeURIComponent(celebrant)}`\n : \"/api/messages\";\n const res = await fetch(url);\n const data = await res.json();\n setMessages(data);\n } catch {\n setMessages([]);\n } finally {\n setLoading(false);\n }\n };\n fetchMessages();\n }, [celebrant, externalMessages.length]);\n\n if (loading) {\n return (\n

🎈

Loading wishes...

\n );\n }\n\n if (messages.length === 0) {\n return (\n

🎁

\n {celebrant\n ? `No wishes for ${celebrant} yet. Be the first!`\n : \"No wishes yet. Send the first one!\"}\n

\n );\n }\n\n return (\n

\n {messages.map((msg) => (\n \n ))}\n

\n );\n}\n",[],[183,287,279],"components","d3ae8042-3d71-11f1-ad26-42b51c65c3df","MessageForm.tsx","d3ae80f6-3d71-11f1-ad26-42b51c65c3df",14,["D",1776769451693],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useState } from \"https://esm.sh/react@18.2.0\";\nimport type { BirthdayMessage } from \"../../shared/types.ts\";\n\ninterface Props {\n onMessageSent: (msg: BirthdayMessage) => void;\n}\n\nexport function MessageForm({ onMessageSent }: Props) {\n const [celebrantName, setCelebrantName] = useState(\"\");\n const [senderName, setSenderName] = useState(\"\");\n const [message, setMessage] = useState(\"\");\n const [loading, setLoading] = useState(false);\n const [error, setError] = useState(\"\");\n\n const handleSubmit = async (e: React.FormEvent) => {\n e.preventDefault();\n if (!celebrantName.trim() || !senderName.trim() || !message.trim()) {\n setError(\"Please fill in all fields!\");\n return;\n }\n setLoading(true);\n setError(\"\");\n try {\n const res = await fetch(\"/api/messages\", {\n method: \"POST\",\n headers: { \"Content-Type\": \"application/json\" },\n body: JSON.stringify({\n celebrantName: celebrantName.trim(),\n senderName: senderName.trim(),\n message: message.trim(),\n }),\n });\n if (!res.ok) throw new Error(\"Failed to send wish\");\n const msg = await res.json();\n onMessageSent(msg);\n setMessage(\"\");\n setCelebrantName(\"\");\n setSenderName(\"\");\n } catch {\n setError(\"Something went wrong. Please try again!\");\n } finally {\n setLoading(false);\n }\n };\n\n return (\n \n \n ✉️ Send a Birthday Wish\n \n\n {error && (\n

\n {error}\n

\n )}\n\n

\n \n 🎂 Birthday Person's Name\n \n setCelebrantName(e.target.value)}\n placeholder=\"e.g. Sarah\"\n className=\"w-full border-2 border-pink-200 rounded-xl px-4 py-3 text-gray-700 focus(outline-none border-pink-400) transition-colors\"\n maxLength={100}\n />\n

\n \n 👤 Your Name\n \n setSenderName(e.target.value)}\n placeholder=\"e.g. John\"\n className=\"w-full border-2 border-pink-200 rounded-xl px-4 py-3 text-gray-700 focus(outline-none border-pink-400) transition-colors\"\n maxLength={100}\n />\n

\n\n

\n \n 💌 Your Birthday Message\n \n setMessage(e.target.value)}\n placeholder=\"Write a heartfelt birthday message...\"\n rows={4}\n className=\"w-full border-2 border-pink-200 rounded-xl px-4 py-3 text-gray-700 focus(outline-none border-pink-400) transition-colors resize-none\"\n maxLength={1000}\n />\n

{message.length}/1000

\n\n \n {loading ? \"Sending... 💫\" : \"Send Birthday Wish 🎉\"}\n \n \n );\n}\n",[],[183,287,289],"db994f4e-3d71-11f1-ae40-42b51c65c3df","MessageCard.tsx","db994ff8-3d71-11f1-ae40-42b51c65c3df",16,["D",1776769464996],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React from \"https://esm.sh/react@18.2.0\";\nimport type { BirthdayMessage } from \"../../shared/types.ts\";\n\nconst emojis = [\"🎂\", \"🎉\", \"🎈\", \"🎁\", \"🥳\", \"🎊\", \"✨\", \"💖\", \"🌟\", \"🍰\"];\n\nfunction getRandomEmoji(id: number) {\n return emojis[id % emojis.length];\n}\n\nfunction timeAgo(dateStr: string): string {\n const now = new Date();\n const date = new Date(dateStr + \"Z\");\n const diffMs = now.getTime() - date.getTime();\n const diffMins = Math.floor(diffMs / 60000);\n if (diffMins < 1) return \"just now\";\n if (diffMins < 60) return `${diffMins}m ago`;\n const diffHrs = Math.floor(diffMins / 60);\n if (diffHrs < 24) return `${diffHrs}h ago`;\n const diffDays = Math.floor(diffHrs / 24);\n if (diffDays < 30) return `${diffDays}d ago`;\n return date.toLocaleDateString();\n}\n\ninterface Props {\n message: BirthdayMessage;\n}\n\nexport function MessageCard({ message }: Props) {\n const emoji = getRandomEmoji(message.id);\n\n return (\n \n

{emoji}

\n \n To: {message.celebrantName}\n \n {timeAgo(message.createdAt)}\n

\n {message.message}\n

\n — From {message.senderName} 💝\n

\n \n );\n}\n",[],[183,287,297],"e26308f6-3d71-11f1-a60a-42b51c65c3df","Confetti.tsx","e26309c8-3d71-11f1-a60a-42b51c65c3df",18,["D",1776769476386],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useMemo } from \"https://esm.sh/react@18.2.0\";\n\nconst CONFETTI_PIECES = 50;\nconst COLORS = [\"#ec4899\", \"#f472b6\", \"#f9a8d4\", \"#fbbf24\", \"#34d399\", \"#60a5fa\", \"#a78bfa\", \"#f87171\"];\n\nexport function Confetti() {\n const pieces = useMemo(() => {\n return Array.from({ length: CONFETTI_PIECES }, (_, i) => ({\n id: i,\n left: Math.random() * 100,\n delay: Math.random() * 2,\n duration: 2 + Math.random() * 2,\n color: COLORS[Math.floor(Math.random() * COLORS.length)],\n size: 6 + Math.random() * 8,\n rotation: Math.random() * 360,\n }));\n }, []);\n\n return (\n

\n \n {pieces.map((p) => (\n 0.5 ? \"50%\" : \"2px\",\n animation: `confetti-fall ${p.duration}s ease-in ${p.delay}s forwards`,\n transform: `rotate(${p.rotation}deg)`,\n }}\n />\n ))}\n

\n );\n}\n",[],[183,287,305],"def9d1d6-3d71-11f1-a60a-42b51c65c3df","CelebrantPicker.tsx","def9d2bc-3d71-11f1-a60a-42b51c65c3df",17,["D",1776769470662],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useState, useEffect } from \"https://esm.sh/react@18.2.0\";\n\ninterface Props {\n selected: string;\n onSelect: (name: string) => void;\n}\n\nexport function CelebrantPicker({ selected, onSelect }: Props) {\n const [celebrants, setCelebrants] = useState([]);\n\n useEffect(() => {\n fetch(\"/api/celebrants\")\n .then((r) => r.json())\n .then(setCelebrants)\n .catch(() => setCelebrants([]));\n }, []);\n\n if (celebrants.length === 0 && !selected) return null;\n\n const allNames = selected && !celebrants.includes(selected)\n ? [selected, ...celebrants]\n : celebrants;\n\n return (\n

\n onSelect(\"\")}\n className={`px-4 py-2 rounded-full text-sm font-semibold transition-all ${\n !selected\n ? \"bg-pink-500 text-white shadow-md\"\n : \"bg-white text-pink-500 hover(bg-pink-50)\"\n }`}\n >\n All ✨\n \n {allNames.map((name) => (\n onSelect(name)}\n className={`px-4 py-2 rounded-full text-sm font-semibold transition-all ${\n selected === name\n ? \"bg-pink-500 text-white shadow-md\"\n : \"bg-white text-pink-500 hover(bg-pink-50)\"\n }`}\n >\n 🎂 {name}\n \n ))}\n

\n );\n}\n",[],[183,287,313],"c9f883f4-3d71-11f1-ad26-42b51c65c3df",13,["D",1776769435421],[208,209,210,211,212],[183,287],["D",1776769392829],[207,213,214,215],[183],"b763226c-3d71-11f1-8169-42b51c65c3df","queries.ts","b7632302-3d71-11f1-8169-42b51c65c3df",8,["D",1776769404243],"import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\nimport type { BirthdayMessage, CreateMessagePayload } from \"../shared/types.ts\";\n\nexport async function createMessage(payload: CreateMessagePayload): Promise {\n const result = await sqlite.execute({\n sql: \"INSERT INTO birthday_messages (celebrant_name, sender_name, message) VALUES (?, ?, ?)\",\n args: [payload.celebrantName, payload.senderName, payload.message],\n });\n const row = await sqlite.execute({\n sql: \"SELECT * FROM birthday_messages WHERE id = ?\",\n args: [result.lastInsertRowid!],\n });\n const r = row.rows[0] as Record;\n return {\n id: r.id as number,\n celebrantName: r.celebrant_name as string,\n senderName: r.sender_name as string,\n message: r.message as string,\n createdAt: r.created_at as string,\n };\n}\n\nexport async function getMessagesForCelebrant(celebrantName: string): Promise {\n const result = await sqlite.execute({\n sql: \"SELECT * FROM birthday_messages WHERE LOWER(celebrant_name) = LOWER(?) ORDER BY created_at DESC\",\n args: [celebrantName],\n });\n return result.rows.map((r: Record) => ({\n id: r.id as number,\n celebrantName: r.celebrant_name as string,\n senderName: r.sender_name as string,\n message: r.message as string,\n createdAt: r.created_at as string,\n }));\n}\n\nexport async function getAllMessages(): Promise {\n const result = await sqlite.execute(\n \"SELECT * FROM birthday_messages ORDER BY created_at DESC\",\n );\n return result.rows.map((r: Record) => ({\n id: r.id as number,\n celebrantName: r.celebrant_name as string,\n senderName: r.sender_name as string,\n message: r.message as string,\n createdAt: r.created_at as string,\n }));\n}\n\nexport async function getCelebrants(): Promise {\n const result = await sqlite.execute(\n \"SELECT DISTINCT celebrant_name FROM birthday_messages ORDER BY celebrant_name ASC\",\n );\n return result.rows.map((r: Record) => r.celebrant_name as string);\n}\n",[],[189,329],"b401837a-3d71-11f1-b900-42b51c65c3df","migrations.ts","b401842e-3d71-11f1-b900-42b51c65c3df",7,["D",1776769398567],"import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\n\nexport async function runMigrations() {\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS birthday_messages (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n celebrant_name TEXT NOT NULL,\n sender_name TEXT NOT NULL,\n message TEXT NOT NULL,\n created_at TEXT NOT NULL DEFAULT (datetime('now'))\n )\n `);\n}\n",[],[189,337],["D",1776769392245],[204,205],[189],["D",1776769236397],["D",1789500689328],{"_11":12,"_91":87},{"_11":12,"_85":-5,"_86":87,"_45":46,"_88":89,"_90":38},{"_29":30,"_13":26,"_20":21,"_27":28,"_31":-5,"_32":-5,"_80":-5,"_81":-5,"_82":-5,"_83":14,"_84":12},"ctx",{"_73":-5,"_112":385,"_386":387,"_388":389,"_390":38,"_391":38,"_392":38,"_393":50,"_394":-5,"_395":-7,"_396":-7,"_397":54,"_398":38,"_399":38,"_400":-5,"_401":38,"_402":38,"_403":38,"_404":-5},"ENV",{"_356":357,"_358":359,"_360":26,"_361":362,"_363":364,"_365":366,"_367":368,"_369":370,"_371":372,"_373":374,"_375":376,"_377":378,"_379":380,"_381":382,"_383":384},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","fdb67791413f4386b4dbf18f354029a617f6160f","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"]

Branches1

Branches
1