Vals Grid for {username}

Debug Information:

{info}

\n {loading && vals.length === 0 && (\n

\n )}\n {error && (\n

Error: {error}

\n )}\n

\n {vals.map(val => (\n

handleValClick(val.id)}\n >\n

{val.emoji}

{val.name}

\n {val.description && (\n

\n )}\n

\n ))}\n

\n {!loading && vals.length === 0 && (\n

No vals found.

\n )}\n \n

\n );\n}\n\nasync function fetchEmojiForName(name) {\n try {\n const response = await fetch(`/emoji/${encodeURIComponent(name)}`);\n if (response.ok) {\n const data = await response.json();\n return data.emoji;\n }\n console.error('Error fetching emoji:', response.statusText);\n } catch (error) {\n console.error('Error fetching emoji:', error);\n }\n return '❓'; // Placeholder\n}\n\nfunction client() {\n createRoot(document.getElementById(\"root\")).render();\n}\n\nif (typeof document !== \"undefined\") { client(); }\n\nasync function server(request: Request): Promise {\n const url = new URL(request.url);\n const { pathname } = url;\n\n const { sqlite } = await import(\"https://esm.town/v/stevekrouse/sqlite\");\n\n if (pathname.startsWith(\"/vals/\")) {\n const username = pathname.split(\"/\")[2];\n try {\n const ValTown = (await import(\"https://esm.sh/@valtown/sdk\")).default;\n const token = Deno.env.get('valtown');\n if (!token) {\n throw new Error('valtown token is not set');\n }\n\n const client = new ValTown({ apiKey: token });\n const user = await client.alias.username.retrieve(username);\n \n if (!user || !user.id) {\n throw new Error('User not found');\n }\n\n // Create emoji cache table if it doesn't exist\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS emoji_cache (\n name TEXT PRIMARY KEY,\n emoji TEXT NOT NULL\n )\n `);\n\n let vals = [];\n for await (const val of client.users.vals.list(user.id, { limit: 100 })) {\n vals.push(val);\n await new Promise(resolve => setTimeout(resolve, 2000)); // 2 second delay between fetches\n }\n\n return new Response(JSON.stringify({ vals }), {\n headers: { 'Content-Type': 'application/json' }\n });\n } catch (error) {\n console.error('Server error:', error);\n return new Response(JSON.stringify({ error: error.message }), {\n status: 500,\n headers: { 'Content-Type': 'application/json' }\n });\n }\n }\n\n if (pathname.startsWith(\"/emoji/\")) {\n const name = decodeURIComponent(pathname.split(\"/\").pop() || \"\");\n \n try {\n // Check cache first\n const cachedEmoji = await sqlite.execute('SELECT emoji FROM emoji_cache WHERE name = ?', [name]);\n if (cachedEmoji.rows.length > 0) {\n return new Response(JSON.stringify({ emoji: cachedEmoji.rows[0].emoji }), {\n headers: { 'Content-Type': 'application/json' }\n });\n }\n\n // Generate new emoji using OpenAI\n const { OpenAI } = await import(\"https://esm.town/v/std/openai\");\n const openai = new OpenAI();\n const completion = await openai.chat.completions.create({\n messages: [{ role: \"user\", content: `Generate a single emoji that best represents \"${name}\". Respond with only the emoji, nothing else.` }],\n model: \"gpt-4o-mini\",\n max_tokens: 5,\n });\n const emoji = completion.choices[0].message.content.trim();\n\n // Cache the result\n await sqlite.execute('INSERT INTO emoji_cache (name, emoji) VALUES (?, ?)', [name, emoji]);\n\n return new Response(JSON.stringify({ emoji }), {\n headers: { 'Content-Type': 'application/json' }\n });\n } catch (error) {\n console.error('Error generating or caching emoji:', error);\n return new Response(JSON.stringify({ error: error.message }), {\n status: 500,\n headers: { 'Content-Type': 'application/json' }\n });\n }\n }\n\n const username = pathname.split('/')[1] || 'ejfox';\n\n return new Response(`\n \n \n \n \n \n Vals Grid for ${username}\n \n \n \n \n

\n \n \n \n `,\n {\n headers: { \"content-type\": \"text/html\" },\n });\n}\n\nexport default server;","deleted","label",[99],"permalink","https://www.val.town/x/ejfox/extremePlumCaribou/code/main.tsx","extension","actionData","errors"]