Date Me Directory

/** @jsxImportSource https://esm.sh/react@18.2.0 */ import { renderToString } from "https://esm.sh/react-dom@18.2.0/server"; import { createStaticHandler, createStaticRouter, StaticRouterProvider, } from "https://esm.sh/react-router-dom@6.23.0/server?deps=react@18.2.0"; import { sqlite } from "https://esm.town/v/std/sqlite?v=6"; import { routes } from "https://esm.town/v/stevekrouse/dateme_routes"; import { html } from "https://esm.town/v/stevekrouse/html"; export default async function(req: Request) { let handler = createStaticHandler(routes); let context = await handler.query(req); if ( req.headers.get("Content-Type") === "application/json" || req.method !== "GET" ) { return Response.json(context.loaderData["0-1"]); // TODO figure out why ["0-1"] // TODO check if action works } else { let router = createStaticRouter(routes, context); return html(renderToString( Date Me Directory , )); } } // This ensures I'm not accidentally DOSing myself by making a loop on this server // We need to do this better at the platform level await sqlite.execute(`create table if not exists deletme_requests (time timestamp default current_timestamp)`); await sqlite.execute(`insert into deletme_requests (time) values (current_timestamp)`); const data = await sqlite.execute(`select count(*) from deletme_requests where time > datetime('now', '-1 second')`); const count = data.rows[0][0]; if (count > 3) { throw Error("loop!!"); }