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",[119],"05d75804-3d78-11f1-9314-42b51c65c3df","new-file-8905.ts","05d75930-3d78-11f1-9314-42b51c65c3df",25,["D",1776772112845],"script",[136],"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",[143],"0360bcdc-3d78-11f1-be0d-42b51c65c3df","new-file-1372.ts","0360bdc2-3d78-11f1-be0d-42b51c65c3df",24,["D",1776772108689],[151],"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",[157],"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",[163],"b0a2dac6-3d71-11f1-a08b-42b51c65c3df","shared","b0a2db70-3d71-11f1-a08b-42b51c65c3df",5,["D",1776769392851],"directory",[170],"b0963fb4-3d71-11f1-b3d9-42b51c65c3df","frontend","b0964072-3d71-11f1-b3d9-42b51c65c3df",4,["D",1776769392829],[177],"b03dae62-3d71-11f1-94e7-42b51c65c3df","database","b03daf16-3d71-11f1-94e7-42b51c65c3df",["D",1776769392245],[183],"pulls","branches",1,"forks","envVars",{"_195":42,"_197":42},"connections",{"_195":42,"_196":42},"count","unfilledCount","emptyCount",{"_18":182,"_20":183,"_120":184,"_122":-5,"_123":71,"_124":127,"_125":38,"_22":339,"_68":42,"_128":174,"_130":-5,"_132":26,"_133":-5,"_220":340,"_88":341},{"_18":331,"_20":332,"_120":333,"_122":184,"_123":71,"_124":334,"_125":38,"_22":335,"_68":42,"_128":140,"_130":336,"_132":26,"_133":-5,"_220":337,"_88":338},{"_18":323,"_20":324,"_120":325,"_122":184,"_123":71,"_124":326,"_125":38,"_22":327,"_68":42,"_128":140,"_130":328,"_132":26,"_133":-5,"_220":329,"_88":330},{"_18":176,"_20":177,"_120":178,"_122":-5,"_123":71,"_124":179,"_125":38,"_22":320,"_68":42,"_128":174,"_130":-5,"_132":26,"_133":-5,"_220":321,"_88":322},{"_18":315,"_20":282,"_120":276,"_122":178,"_123":71,"_124":316,"_125":38,"_22":317,"_68":42,"_128":174,"_130":-5,"_132":26,"_133":-5,"_220":318,"_88":319},{"_18":307,"_20":308,"_120":309,"_122":276,"_123":71,"_124":310,"_125":38,"_22":311,"_68":42,"_128":140,"_130":312,"_132":26,"_133":-5,"_220":313,"_88":314},{"_18":299,"_20":300,"_120":301,"_122":276,"_123":71,"_124":302,"_125":38,"_22":303,"_68":42,"_128":140,"_130":304,"_132":26,"_133":-5,"_220":305,"_88":306},{"_18":291,"_20":292,"_120":293,"_122":276,"_123":71,"_124":294,"_125":38,"_22":295,"_68":42,"_128":140,"_130":296,"_132":26,"_133":-5,"_220":297,"_88":298},{"_18":283,"_20":284,"_120":285,"_122":276,"_123":71,"_124":286,"_125":38,"_22":287,"_68":42,"_128":140,"_130":288,"_132":26,"_133":-5,"_220":289,"_88":290},{"_18":273,"_20":274,"_120":275,"_122":276,"_123":71,"_124":277,"_125":38,"_22":278,"_68":42,"_128":140,"_130":279,"_132":26,"_133":-5,"_220":280,"_88":281},{"_18":265,"_20":266,"_120":267,"_122":178,"_123":71,"_124":268,"_125":38,"_22":269,"_68":42,"_128":140,"_130":270,"_132":26,"_133":-5,"_220":271,"_88":272},{"_18":257,"_20":258,"_120":259,"_122":178,"_123":71,"_124":260,"_125":38,"_22":261,"_68":42,"_128":98,"_130":262,"_132":26,"_133":-5,"_220":263,"_88":264},{"_18":249,"_20":250,"_120":251,"_122":178,"_123":71,"_124":252,"_125":38,"_22":253,"_68":42,"_128":140,"_130":254,"_132":26,"_133":-5,"_220":255,"_88":256},{"_18":169,"_20":170,"_120":171,"_122":-5,"_123":71,"_124":172,"_125":38,"_22":246,"_68":42,"_128":174,"_130":-5,"_132":26,"_133":-5,"_220":247,"_88":248},{"_18":238,"_20":239,"_120":240,"_122":171,"_123":71,"_124":241,"_125":38,"_22":242,"_68":42,"_128":140,"_130":243,"_132":26,"_133":-5,"_220":244,"_88":245},{"_18":162,"_20":163,"_120":164,"_122":-5,"_123":71,"_124":165,"_125":38,"_22":235,"_68":42,"_128":98,"_130":167,"_132":26,"_133":-5,"_220":236,"_88":237},{"_18":156,"_20":157,"_120":36,"_122":-5,"_123":71,"_124":158,"_125":38,"_22":232,"_68":147,"_128":129,"_130":160,"_132":26,"_133":-5,"_220":233,"_88":234},{"_18":150,"_20":151,"_120":152,"_122":-5,"_123":71,"_124":153,"_125":38,"_22":229,"_68":42,"_128":140,"_130":82,"_132":26,"_133":-5,"_220":230,"_88":231},{"_18":142,"_20":143,"_120":144,"_122":-5,"_123":71,"_124":145,"_125":38,"_22":226,"_68":147,"_128":129,"_130":148,"_132":26,"_133":-5,"_220":227,"_88":228},{"_18":135,"_20":136,"_120":137,"_122":-5,"_123":71,"_124":138,"_125":38,"_22":223,"_68":42,"_128":140,"_130":82,"_132":26,"_133":-5,"_220":224,"_88":225},{"_18":118,"_20":119,"_120":121,"_122":-5,"_123":71,"_124":69,"_125":38,"_22":219,"_68":127,"_128":129,"_130":131,"_132":26,"_133":-5,"_220":221,"_88":222},["D",1776772451883],"children",[],[119],["D",1776772112845],[],[136],["D",1776771729861],[],[143],["D",1776772108689],[],[151],["D",1776769413169],[],[157],["D",1776769497001],[],[163],"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",[],[170,239],["D",1776769392851],[212],[170],"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",[],[177,250],"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",[],[177,258],"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",[],[177,266],"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",[],[177,282,274],"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",[],[177,282,284],"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",[],[177,282,292],"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",[],[177,282,300],"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",[],[177,282,308],"c9f883f4-3d71-11f1-ad26-42b51c65c3df",13,["D",1776769435421],[203,204,205,206,207],[177,282],["D",1776769392829],[202,208,209,210],[177],"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",[],[183,324],"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",[],[183,332],["D",1776769392245],[199,200],[183],["D",1776769236397],["D",1789500689328],{"_16":17,"_86":82},{"_16":17,"_80":-5,"_81":82,"_33":34,"_83":84,"_85":26},{"_68":69,"_20":70,"_18":71,"_72":19,"_73":-5,"_74":-5,"_75":-5,"_76":-5,"_77":-5,"_78":21,"_79":17},"ctx",{"_61":-5,"_106":380,"_381":382,"_383":384,"_385":26,"_386":26,"_387":26,"_388":38,"_389":-5,"_390":-7,"_391":-7,"_392":42,"_393":26,"_394":26,"_395":-5,"_396":26,"_397":26,"_398":26,"_399":-5},"ENV",{"_351":352,"_353":354,"_355":70,"_356":357,"_358":359,"_360":361,"_362":363,"_364":365,"_366":367,"_368":369,"_370":371,"_372":373,"_374":375,"_376":377,"_378":379},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","811aa22498c9b0b5a47e8d778de579cdb990f332","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"]

Search