/** @jsxImportSource npm:hono@3/jsx */ import { sqlite } from "https://esm.town/v/std/sqlite"; import Layout from "https://esm.town/v/stevekrouse/dateme_layout"; import { zip } from "npm:lodash-es"; function absoluteURL(url) { if (url.startsWith("http://") || url.startsWith("https://")) return url; else return "https://" + url; } let headers = [ "Name", "Age", "Gender", "InterestedIn", "Style", "Location", "LocationFlexibility", "Contact", "LastUpdated", ]; let linkClass = "text-sky-600 hover:text-sky-500"; function httpsIfy(url: string) { if (!url.startsWith("http://") && !url.startsWith("https://")) { return `https://${url}`; } return url; } function renderCell(header, row) { let data = row[header]; if (header === "Name") { return {data}; } else if (Array.isArray(data)) { return data.map(d => {d}); } else if (header === "LastUpdated") { return new Date(data).toISOString().split("T")[0]; } else { return data; } } export default async function Browse(c) { const url = new URL(c.req.url); const search = { gender: url.searchParams.get("gender"), desiredGender: url.searchParams.get("desired-gender"), minAge: url.searchParams.get("min-age")?.length ? url.searchParams.get("min-age") : 0, maxAge: url.searchParams.get("max-age")?.length ? url.searchParams.get("max-age") : 100, location: url.searchParams.get("location"), }; let { columns, rows } = await sqlite.execute({ sql: `select * from datemedocs where Location like ? and Age >= ? and Age <= ? and Gender like ? and InterestedIn like ? order by LastUpdated desc `, args: [ "%" + (search.location ?? "") + "%", search.minAge, search.maxAge, "%" + (search.desiredGender ?? "") + "%", "%" + (search.gender ?? "") + "%", ], }); const profiles = rows.map(row => Object.fromEntries(zip( columns, row.map(d => { try { return JSON.parse(d); } catch (_) { return d; } }), )) ); return c.html(

You are {search.gender?.length ? search.gender : "any gender"}{" "}looking for{" "} {search.desiredGender?.length ? search.desiredGender : "any gender"}{" "}between the ages of{" "} {search.minAge}{" "}and{" "}{search.maxAge} in{" "} {search.location?.length ? search.location : "the world"}. There are{" "}{profiles.length}{" "} profiles for you.

Redo Search

Clear filters

{headers.map(h => )} {profiles.map(d => ( {headers.map(h => ( ))} ))}

{h}
{renderCell(h, d)}

, ); }

dateme_browse