{clicks}

Clicks

\n \n

\n );\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 { sqlite } = await import(\"https://esm.town/v/stevekrouse/sqlite\");\n const SCHEMA_VERSION = 2\n const KEY = \"click_counter\";\n\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${KEY}_clicks_${SCHEMA_VERSION} (\n id INTEGER PRIMARY KEY,\n count INTEGER NOT NULL DEFAULT 0\n )\n `);\n\n // Initialize the counter if it doesn't exist\n await sqlite.execute(`\n INSERT OR IGNORE INTO ${KEY}_clicks_${SCHEMA_VERSION} (id, count) VALUES (1, 0)\n `);\n\n const url = new URL(request.url);\n\n if (url.pathname === '/clicks') {\n const result = await sqlite.execute(`SELECT count FROM ${KEY}_clicks_${SCHEMA_VERSION} WHERE id = 1`);\n return new Response(JSON.stringify({ clicks: result.rows[0].count }), {\n headers: { 'Content-Type': 'application/json' }\n });\n }\n\n if (url.pathname === '/increment' && request.method === 'POST') {\n await sqlite.execute(`UPDATE ${KEY}_clicks_${SCHEMA_VERSION} SET count = count + 1 WHERE id = 1`);\n return new Response(JSON.stringify({ success: true }), {\n headers: { 'Content-Type': 'application/json' }\n });\n }\n\n return new Response(`\n \n \n Click Counter\n \n \n \n \n

\n \n \n \n `,\n {\n headers: {\n \"content-type\": \"text/html\",\n },\n });\n}\n\nconst css = `\nbody, html {\n margin: 0;\n padding: 0;\n height: 100%;\n font-family: -apple-system, BlinkMacSystemFont, 'Segoe UI', 'Roboto', 'Helvetica', 'Arial', sans-serif;\n background-color: #f5f5f7;\n color: #1d1d1f;\n}\n.fullscreen {\n width: 100%;\n height: 100vh;\n display: flex;\n justify-content: center;\n align-items: center;\n cursor: pointer;\n position: relative;\n}\n.content {\n text-align: center;\n}\nh1 {\n font-size: 15vw;\n margin: 0;\n line-height: 1;\n transition: transform 0.3s ease;\n}\np {\n font-size: 4vw;\n margin: 0;\n opacity: 0.7;\n}\n.fullscreen:active h1 {\n transform: scale(0.95);\n}\nfooter {\n position: absolute;\n bottom: 20px;\n left: 0;\n right: 0;\n text-align: center;\n display: flex;\n justify-content: center;\n align-items: center;\n gap: 10px;\n}\na {\n color: #0071e3;\n text-decoration: none;\n font-size: 14px;\n}\n.separator {\n font-size: 14px;\n color: #86868b;\n margin: 0 5px;\n}\na:hover {\n text-decoration: underline;\n}\n`;\n\nexport default server;","deleted","label",[98],"permalink","https://www.val.town/x/ankitkr0/clickTrackerWebsite/code/main.tsx","extension","actionData","errors"]