[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8},"actionData","errors","root",{"_108":109,"_110":111},"routes/embed.x.$handle.$name.$",{"_9":10,"_11":12,"_13":14,"_15":16,"_17":18,"_19":20,"_21":-5},"handle","commandertvis","name","dateme","path","pages/browse","project",{"_22":48,"_11":12,"_35":49,"_50":-5,"_51":44,"_52":53,"_54":53,"_55":-5,"_56":-5,"_57":58,"_59":60,"_61":34,"_62":34,"_63":-5,"_64":38,"_65":66,"_67":-5,"_68":-5,"_69":-5,"_70":-5,"_71":72,"_73":72,"_74":75,"_76":75,"_77":75,"_78":72,"_79":72,"_80":81,"_82":83,"_84":85,"_86":44},"file",{"_22":23,"_11":24,"_25":26,"_27":28,"_29":30,"_31":32,"_33":34,"_35":36,"_37":38,"_39":40,"_41":42,"_43":44,"_45":-5,"_13":46},"permalink","https://www.val.town/x/commandertvis/dateme/code/pages/browse","extension","id","939bd974-f398-11ef-b1e1-569c3dd06744","browse","fileId","1a83ca40-a682-4d8a-b812-38a014c4df39","parentId","64b9ae34-6f03-4dff-a7a3-02412853ebd5","branchId","939a7ff2-f398-11ef-b1e1-569c3dd06744","branchVersion",1,"latest",true,"createdAt",["D",1740502210845],"version",0,"fileType","script","content","/** @jsxImportSource npm:hono@3/jsx */\nimport { sqlite } from \"https://esm.town/v/std/sqlite\";\nimport { zip } from \"npm:lodash-es\";\nimport Layout from \"./layout\";\n\nfunction absoluteURL(url) {\n if (url.startsWith(\"http://\") || url.startsWith(\"https://\"))\n return url;\n else return \"https://\" + url;\n}\n\nlet headers = [\n \"Name\",\n \"Age\",\n \"Gender\",\n \"InterestedIn\",\n \"Style\",\n \"Location\",\n \"LocationFlexibility\",\n \"Contact\",\n \"LastUpdated\",\n];\n\nlet linkClass = \"text-sky-600 hover:text-sky-500\";\n\nfunction httpsIfy(url: string) {\n if (!url.startsWith(\"http://\") && !url.startsWith(\"https://\")) {\n return `https://${url}`;\n }\n return url;\n}\n\nfunction renderCell(header, row) {\n let data = row[header];\n if (header === \"Name\") {\n return {data};\n } else if (Array.isArray(data)) {\n return data.map(d => {d});\n } else if (header === \"LastUpdated\") {\n return new Date(data).toISOString().split(\"T\")[0];\n }\n else {\n return data;\n }\n}\n\nexport default async function Browse(c) {\n const url = new URL(c.req.url);\n const search = {\n gender: url.searchParams.get(\"gender\"),\n desiredGender: url.searchParams.get(\"desired-gender\"),\n minAge: url.searchParams.get(\"min-age\")?.length ? url.searchParams.get(\"min-age\") : 0,\n maxAge: url.searchParams.get(\"max-age\")?.length ? url.searchParams.get(\"max-age\") : 100,\n location: url.searchParams.get(\"location\"),\n };\n\n let { columns, rows } = await sqlite.execute({\n sql: `select * from datemedocs\n where\n Location like ?\n and Age >= ?\n and Age <= ?\n and Gender like ?\n and InterestedIn like ?\n order by LastUpdated desc\n `,\n args: [\n \"%\" + (search.location ?? \"\") + \"%\",\n search.minAge,\n search.maxAge,\n \"%\" + (search.desiredGender ?? \"\") + \"%\",\n \"%\" + (search.gender ?? \"\") + \"%\",\n ],\n });\n\n const profiles = rows.map(row =>\n Object.fromEntries(zip(\n columns,\n row.map(d => {\n try {\n return JSON.parse(d);\n } catch (_) {\n return d;\n }\n }),\n ))\n );\n\n return c.html(\n \n

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

\n \n Redo Search\n \n

\n Clear filters\n

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

{h}
\n \n {renderCell(h, d)}\n \n

\n ,\n );\n}","deleted",false,"label",[47,24],"pages","9397a6e2-f398-11ef-b1e1-569c3dd06744",["D",1740502210845],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","imageUrl","userId","84b52fa0-f398-11ef-90d3-996a98d04f37","pinnedFileId","2ecc8dc8-cf4a-415f-b787-14250abee282","pinPreview","pinMigrated","screenshotVersion","likeCount","orgId","50725c27-7f88-4f07-84a9-f6463591c30f","tursoName","tursoHostname","tursoMeasuredAt","pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_9":10,"_107":103},"org",{"_9":10,"_101":-5,"_102":103,"_57":58,"_104":105,"_106":44},"branch",{"_37":87,"_11":88,"_22":30,"_89":48,"_90":91,"_92":93,"_94":53,"_95":96,"_97":98,"_99":12,"_100":10},"isOwned",2,"main","projectId","forkedBranchId","6ea333ec-e58d-11ef-b8f1-e6cdfca9ef9f","forkedBranchVersion",86,"forkedProjectPrivacy","forkedProjectId","6ea2d636-e58d-11ef-b8f1-e6cdfca9ef9f","forkedProjectOrgId","e81e7335-6d4c-4764-a902-d0962bbfa9f7","projectName","userHandle","displayName","avatar","https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvb2F1dGhfZ2l0aHViL2ltZ18ydFhkNmRnMkQ1bVNhQkpJWW94S3dOZkNOR2YifQ","tier","free","canRestrictVals","profileImageUrl","ctx",{"_80":-5,"_141":142,"_143":144,"_145":146,"_147":44,"_148":44,"_149":44,"_150":34,"_151":-5,"_152":-7,"_153":-7,"_154":38,"_155":44,"_156":44,"_157":-5,"_158":44,"_159":44,"_160":44,"_161":-5},"ENV",{"_112":113,"_114":115,"_116":88,"_117":118,"_119":120,"_121":122,"_123":124,"_125":126,"_127":128,"_129":130,"_131":132,"_133":134,"_135":136,"_137":138,"_139":140},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","e8c4b7030cb7600e4eb0736b15f422c8b8bd130f","RENDER_GIT_BRANCH","POSTHOG_API_TOKEN","phc_nmoyuAkStEZuUp69rYlg1DZgrIt19Gx0Y4Hwf8tGgJP","POSTHOG_API_HOST","https://wart.val.town","WEB_API_TEMPLATE","https://{val}.web.val.run","APP_URL","https://www.val.town","MODULE_URL","https://esm.town","VANITY_WEB_API_TEMPLATE","https://{label}.val.run/","DENOLS_URL","https://lsp.val.town","NODE_ENV","production","CLOUDFLARE_TURNSTILE_SITE_KEY","0x4AAAAAACtaIZJH7s9rBMZ6","GOOGLE_CLIENT_ID","875989696899-jtsqkhlbdv5jrlsk8631p7ipjg3c6o62.apps.googleusercontent.com","STRIPE_PUBLISHABLE_KEY","pk_live_51N2zvWEpZTTLipIkVEwXrUG9AT0yeOOEYxszarZT1jpsZV58Ly6wlg3SltZpHN26CUalOBmUSY7adQRQiSkCZz2500qSXNkf8Y","API_URL","https://api.val.town","orgs",[],"preferencesKeybindings","default","preferencesTheme","light","preferencesFixers","preferencesCopilot","preferencesSelectionAi","preferencesCloseBrackets","preferencesChatPanelState","preferencesDprint","preferencesDenofmt","notificationCount","flagDenols","isBusinessOrgMember","businessOrgHandle","isBusinessOrgAdmin","isHigherTownieTier","navCollapsed","currentOrgId"]