\n 🎥 YouTube Shorts Collector\n

\n\n {!isAdmin ? (\n

\n setAdminCode(e.target.value)}\n style={{\n width: '100%',\n padding: '10px',\n marginBottom: '10px',\n backgroundColor: '#1E2A3A', // Darker input background\n color: '#E2E8F0', // Light text\n border: '1px solid #4A90E2', // Blue border\n borderRadius: '5px'\n }}\n />\n \n {error &&

{error}

}\n

\n ) : (\n

\n setNewShortLink(e.target.value)}\n style={{\n flex: 1,\n padding: '10px',\n marginRight: '10px',\n backgroundColor: '#1E2A3A', // Darker input background\n color: '#E2E8F0', // Light text\n border: '1px solid #4A90E2', // Blue border\n borderRadius: '5px'\n }}\n />\n \n

\n {error &&

{error}

}\n

\n )}\n\n

\n Shorts Collection\n

\n {shorts.map((short, index) => (\n

\n \n

\n ))}\n

\n );\n}\n\nfunction client() {\n createRoot(document.getElementById(\"root\")).render();\n}\n\nif (typeof document !== \"undefined\") { client(); }\n\nexport default async function handler(request: Request): Promise {\n const { sqlite } = await import(\"https://esm.town/v/stevekrouse/sqlite\");\n const KEY = \"wonderfulBlushMagpie\";\n\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${KEY}_shorts (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n link TEXT NOT NULL,\n timestamp DATETIME DEFAULT CURRENT_TIMESTAMP\n )\n `);\n\n if (request.method === 'GET') {\n if (new URL(request.url).pathname === '/get-shorts') {\n const result = await sqlite.execute(`SELECT * FROM ${KEY}_shorts ORDER BY id DESC`);\n return new Response(JSON.stringify(result.rows), {\n headers: { 'Content-Type': 'application/json' }\n });\n }\n\n return new Response(`\n \n \n YouTube Shorts Collector\n \n \n \n \n

\n \n \n \n \n `, {\n headers: { 'Content-Type': 'text/html' }\n });\n }\n\n if (request.method === 'POST') {\n const body = await request.json();\n await sqlite.execute(`\n INSERT INTO ${KEY}_shorts (link) VALUES (?)\n `, [body.link]);\n\n return new Response(JSON.stringify({ success: true }), {\n headers: { 'Content-Type': 'application/json' }\n });\n }\n\n return new Response('Method Not Allowed', { status: 405 });\n}","deleted","label",[99],"permalink","https://www.val.town/x/bgtgtgfgvbtgvgb/wonderfulBlushMagpie/code/main.tsx","extension","actionData","errors"]