Date Me Directory

[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_297":298,"_299":300},"routes/_app.x.$handle.$name",{"_127":126,"_35":73,"_135":117,"_30":136,"_13":14,"_137":-5,"_11":138,"_139":140,"_141":142,"_143":144,"_145":146,"_23":-5,"_147":-5,"_148":-5,"_149":28,"_150":151,"_152":57,"_153":-5,"_154":-5,"_155":156},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_71":72,"_35":73,"_42":74,"_75":-5,"_76":28,"_77":78,"_79":78,"_80":81,"_82":-5,"_18":83,"_84":85,"_86":57,"_87":-5,"_88":-5,"_89":90,"_91":92,"_93":94,"_95":96,"_97":98,"_99":90,"_100":101,"_102":101,"_103":104,"_105":104,"_106":104,"_107":101,"_108":101,"_109":110,"_111":112,"_113":114,"_115":28},"version",136,"changes",[19,20,21,22],"aiChatInfo","userId",{"_23":63,"_25":64,"_27":28,"_29":28,"_30":65,"_32":65},{"_23":55,"_25":56,"_27":57,"_29":28,"_30":58,"_32":58},{"_23":47,"_25":48,"_27":28,"_29":28,"_30":49,"_32":49},{"_23":24,"_25":26,"_27":28,"_29":28,"_30":31,"_32":31},"file",{"_33":34,"_35":36,"_37":38,"_39":41,"_42":43,"_44":14,"_45":46,"_27":28},"previous",{"_33":34,"_35":36,"_37":38,"_39":40},"deleted",false,"deletedHere","path","pages/join","latestPath","fileId","6c8a4e44-e595-11ef-85be-e6cdfca9ef9f","name","join","fileType","script","content","/** @jsxImportSource npm:hono@3/jsx */\nimport { email } from \"https://esm.town/v/std/email?v=11\";\nimport { sqlite } from \"https://esm.town/v/std/sqlite\";\nimport { reloadOnSaveFetchMiddleware } from \"https://esm.town/v/stevekrouse/reloadOnSave\";\nimport { Hono } from \"npm:hono@3\";\nimport locations from \"../locations.json\" with { type: \"json\" };\nimport Layout from \"./layout\";\n\nconst Link = ({ href, children }) => {\n return {children};\n};\n\nexport const Form = (c) =>\n c.html(\n \n

Submit Your Date Me Doc

\n\n

\n \n Name*\n \n \n

\n\n

\n \n Profile URL*\n \n

\n If you don't have a Date Me Doc yet, create one in Notion or{\" \"}\n Google Docs, and then copy its public link here.\n

\n \n

\n\n

\n Age\n \n

\n\n

\n Your Gender\n {[\"F\", \"M\", \"NB\"].map(gender => (\n <>\n \n \n {gender}\n \n \n ))}\n

\n\n

\n Interested In\n {[\"F\", \"M\", \"NB\"].map(gender => (\n <>\n \n \n {gender}\n \n \n ))}\n

\n\n

\n Location\n

\n If you don't see your location represented, request it to be added after you submit your doc.\n

\n \n {locations.map(location => (\n

\n \n \n {location}\n \n

\n ))}\n

\n \n\n

\n Location Flexibility\n \n \n \n \n \n

\n\n

\n Relationship Style\n \n \n \n \n \n

\n\n

\n \n Contact*\n \n \n

\n\n

\n \n Submit\n \n

\n ,\n );\n\nexport const Submit = async (c) => {\n const body = await c.req.parseBody();\n const args = [\n JSON.stringify(body[\"Name\"]),\n JSON.stringify(body[\"Profile\"]),\n parseInt(body[\"Age\"]),\n JSON.stringify(body[\"Gender[]\"]),\n JSON.stringify(body[\"InterestedIn[]\"]),\n JSON.stringify(body[\"location[]\"]),\n JSON.stringify(body[\"LocationFlexibility\"]),\n JSON.stringify(body[\"Style\"] === \"mono\" ? [\"mono\"] : body[\"Style\"] === \"poly\" ? [\"poly\"] : [\"Any\"]),\n JSON.stringify(body[\"Contact\"]),\n new Date().toISOString(),\n ];\n console.log(args);\n try {\n await sqlite.execute(\n {\n sql: `INSERT INTO DateMeDocs (\n Name, \n Profile, \n Age, \n Gender, \n InterestedIn, \n Location, \n LocationFlexibility, \n Style, \n Contact, \n LastUpdated\n ) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)`,\n args,\n },\n );\n await email({ subject: \"Date Me Doc Submit Success: \" + body[\"Name\"], text: args.join(\"\\n\") });\n } catch (e) {\n await email({ subject: \"Date Me Doc Submit Error: \" + body[\"Name\"], text: args.join(\"\\n\") });\n }\n return c.html(\n \n

\n Thanks for your submission!

We hope you find love 🥰\n

\n ,\n );\n};\nexport const join = new Hono();\njoin.get(\"/\", Form);\njoin.post(\"/\", Submit);\nexport default reloadOnSaveFetchMiddleware(join.fetch);","/** @jsxImportSource npm:hono@3/jsx */\nimport { email } from \"https://esm.town/v/std/email?v=11\";\nimport { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\nimport { reloadOnSaveFetchMiddleware } from \"https://esm.town/v/stevekrouse/reloadOnSave\";\nimport { Hono } from \"npm:hono@3\";\nimport locations from \"../locations.json\" with { type: \"json\" };\nimport Layout from \"./layout\";\n\nconst Link = ({ href, children }) => {\n return {children};\n};\n\nexport const Form = (c) =>\n c.html(\n \n

Submit Your Date Me Doc

\n\n

\n \n Name*\n \n \n

\n\n

\n \n Profile URL*\n \n

\n If you don't have a Date Me Doc yet, create one in Notion or{\" \"}\n Google Docs, and then copy its public link here.\n

\n \n

\n\n

\n Age\n \n

\n\n

\n Your Gender\n {[\"F\", \"M\", \"NB\"].map(gender => (\n <>\n \n \n {gender}\n \n \n ))}\n

\n\n

\n Interested In\n {[\"F\", \"M\", \"NB\"].map(gender => (\n <>\n \n \n {gender}\n \n \n ))}\n

\n\n

\n Location\n

\n If you don't see your location represented, request it to be added after you submit your doc.\n

\n \n {locations.map(location => (\n

\n \n \n {location}\n \n

\n ))}\n

\n \n\n

\n Location Flexibility\n \n \n \n \n \n

\n\n

\n Relationship Style\n \n \n \n \n \n

\n\n

\n \n Contact*\n \n \n

\n\n

\n \n Submit\n \n

\n Thanks for your submission!

We hope you find love 🥰\n

\n ,\n );\n};\nexport const join = new Hono();\njoin.get(\"/\", Form);\njoin.post(\"/\", Submit);\nexport default reloadOnSaveFetchMiddleware(join.fetch);","createdAt",["D",1769642292866],"branchVersion","branchId","6ea333ec-e58d-11ef-b8f1-e6cdfca9ef9f",{"_33":50,"_35":51,"_37":38,"_39":53,"_42":54,"_44":14,"_45":46,"_27":28},{"_33":50,"_35":51,"_37":38,"_39":52},"pages/browse","4a7c0892-e595-11ef-bbd6-e6cdfca9ef9f","browse","/** @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 console.log(rows)\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}","/** @jsxImportSource npm:hono@3/jsx */\nimport { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\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 try {\n data = JSON.parse(data);\n } catch (e) {\n \n }\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 try {\n return new Date(data).toISOString().split(\"T\")[0];\n } catch (e) {\n return data;\n }\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 const { columns, rows: profiles } = 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 console.log(profiles)\n\n return c.html(\n \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}",["D",1769642292866],{"_33":59,"_35":58,"_37":38,"_39":61,"_42":62,"_44":14,"_45":46,"_27":28},{"_33":59,"_35":58,"_37":38,"_39":60},true,"MIGRATE.ts","1185f17e-fc9b-11f0-919b-42dde27851f2","import { sqlite as global } from \"https://esm.town/v/std/sqlite\";\nimport { sqlite as scoped } from \"https://esm.town/v/std/sqlite@14-main/main.ts\";\n\n// =============================================================================\n// 1. Configuration\n// =============================================================================\n\nfunction getGlobalTableNamesUsedByVal(): string[] {\n return [\"DateMeDocs\"];\n}\n\n// =============================================================================\n// 2. Schema Helpers\n// =============================================================================\n\n// Get CREATE TABLE statement from sqlite_master\n// Note: sqlite_master.sql includes ALTER TABLE modifications\n// See: https://www.sqlite.org/schematab.html\nasync function getCreateTableStatement(tableName: string): Promise {\n const result = await global.execute({\n sql:\n `SELECT sql FROM sqlite_master WHERE type='table' AND name=? COLLATE NOCASE`,\n args: [tableName],\n });\n if (result.rows.length === 0) {\n throw new Error(`Table ${tableName} not found in global database`);\n }\n const sql = result.rows[0][0] as string;\n // Add IF NOT EXISTS for idempotency\n return sql.replace(/^CREATE TABLE/i, \"CREATE TABLE IF NOT EXISTS\");\n}\n\n// Get all indexes for a table (excluding auto-generated ones)\nasync function getCreateIndexStatements(tableName: string): Promise {\n const result = await global.execute({\n sql:\n `SELECT sql FROM sqlite_master WHERE type='index' AND tbl_name=? COLLATE NOCASE AND sql IS NOT NULL`,\n args: [tableName],\n });\n return result.rows\n .map((row: any) => row[0] as string)\n .filter(Boolean)\n .map((sql) =>\n sql.replace(/^CREATE INDEX/i, \"CREATE INDEX IF NOT EXISTS\")\n .replace(/^CREATE UNIQUE INDEX/i, \"CREATE UNIQUE INDEX IF NOT EXISTS\")\n );\n}\n\n// Get all triggers for a table\nasync function getCreateTriggerStatements(\n tableName: string,\n): Promise {\n const result = await global.execute({\n sql:\n `SELECT sql FROM sqlite_master WHERE type='trigger' AND tbl_name=? COLLATE NOCASE AND sql IS NOT NULL`,\n args: [tableName],\n });\n return result.rows\n .map((row: any) => row[0] as string)\n .filter(Boolean);\n}\n\n// Get column names from PRAGMA table_info\nasync function getColumnNames(tableName: string): Promise {\n const result = await global.execute(`PRAGMA table_info(${tableName})`);\n return result.rows.map((row: any) => row[1] as string);\n}\n\n// =============================================================================\n// 3. Migration Actions\n// =============================================================================\n\nasync function createTableInScoped(tableName: string): Promise {\n // Create table\n const createTableSQL = await getCreateTableStatement(tableName);\n console.log(\"CREATE TABLE:\\n\", createTableSQL);\n await scoped.execute(createTableSQL);\n\n // Create indexes\n const indexStatements = await getCreateIndexStatements(tableName);\n for (const sql of indexStatements) {\n console.log(\"CREATE INDEX:\", sql);\n await scoped.execute(sql);\n }\n\n // Create triggers\n const triggerStatements = await getCreateTriggerStatements(tableName);\n for (const sql of triggerStatements) {\n console.log(\"CREATE TRIGGER:\", sql);\n await scoped.execute(sql);\n }\n}\n\nasync function copyData(tableName: string, batchSize = 100): Promise {\n const columns = await getColumnNames(tableName);\n const columnList = columns.join(\", \");\n const placeholders = columns.map(() => \"?\").join(\", \");\n\n let offset = 0;\n let totalCopied = 0;\n\n while (true) {\n const { rows } = await global.execute({\n sql: `SELECT * FROM ${tableName} LIMIT ? OFFSET ?`,\n args: [batchSize, offset],\n });\n\n if (rows.length === 0) break;\n\n const statements = rows.map((row: any) => ({\n sql:\n `INSERT OR IGNORE INTO ${tableName} (${columnList}) VALUES (${placeholders})`,\n args: Array.isArray(row) ? row : Object.values(row),\n }));\n\n await scoped.batch(statements);\n\n totalCopied += rows.length;\n offset += batchSize;\n console.log(` Copied ${totalCopied} rows...`);\n\n if (rows.length < batchSize) break;\n }\n\n return totalCopied;\n}\n\nasync function verifyMigration(tableName: string): Promise {\n const globalCount = await global.execute(`SELECT COUNT(*) FROM ${tableName}`);\n const scopedCount = await scoped.execute(`SELECT COUNT(*) FROM ${tableName}`);\n\n const globalTotal = globalCount.rows[0][0] as number;\n const scopedTotal = scopedCount.rows[0][0] as number;\n\n console.log(` Global: ${globalTotal} rows, Scoped: ${scopedTotal} rows`);\n\n return globalTotal === scopedTotal;\n}\n\n// =============================================================================\n// 4. Main Migration Orchestrator\n// =============================================================================\n\nexport async function migrate() {\n const tables = getGlobalTableNamesUsedByVal();\n\n for (const tableName of tables) {\n console.log(`\\n${\"=\".repeat(60)}`);\n console.log(`Migrating table: ${tableName}`);\n console.log(\"=\".repeat(60));\n\n // Step 1: Create table, indexes, and triggers in scoped database\n console.log(\"\\n[1/3] Creating schema in scoped database...\");\n await createTableInScoped(tableName);\n console.log(\"✓ Schema created\");\n\n // Step 2: Copy data\n console.log(\"\\n[2/3] Copying data...\");\n const count = await copyData(tableName);\n console.log(`✓ Copied ${count} rows`);\n\n // Step 3: Verify\n console.log(\"\\n[3/3] Verifying migration...\");\n const verified = await verifyMigration(tableName);\n if (verified) {\n console.log(\"✓ Migration verified!\");\n } else {\n console.log(\"✗ Row counts don't match - please investigate\");\n }\n }\n\n console.log(`\\n${\"=\".repeat(60)}`);\n console.log(\"Migration complete!\");\n console.log(\"=\".repeat(60));\n console.log(\"\\nNext steps - update imports in:\");\n console.log(\" • pages/browse (line 2)\");\n console.log(\" • pages/join (line 3)\");\n console.log(\" • rss (line 1)\");\n console.log(\"\\nChange:\");\n console.log(' import { sqlite } from \"https://esm.town/v/std/sqlite\";');\n console.log(\"To:\");\n console.log(\n ' import { sqlite } from \"https://esm.town/v/std/sqlite@14-main/main.ts\";',\n );\n}\n\n// Uncomment to run:\nmigrate();","import { sqlite as global } from \"https://esm.town/v/std/sqlite\";\nimport { sqlite as scoped } from \"https://esm.town/v/std/sqlite/main.ts\";\n\n// =============================================================================\n// 1. Configuration\n// =============================================================================\n\nfunction getGlobalTableNamesUsedByVal(): string[] {\n return [\"DateMeDocs\"];\n}\n\n// =============================================================================\n// 2. Schema Helpers\n// =============================================================================\n\n// Get CREATE TABLE statement from sqlite_master\n// Note: sqlite_master.sql includes ALTER TABLE modifications\n// See: https://www.sqlite.org/schematab.html\nasync function getCreateTableStatement(tableName: string): Promise {\n const result = await global.execute({\n sql:\n `SELECT sql FROM sqlite_master WHERE type='table' AND name=? COLLATE NOCASE`,\n args: [tableName],\n });\n if (result.rows.length === 0) {\n throw new Error(`Table ${tableName} not found in global database`);\n }\n const sql = result.rows[0][0] as string;\n // Add IF NOT EXISTS for idempotency\n return sql.replace(/^CREATE TABLE/i, \"CREATE TABLE IF NOT EXISTS\");\n}\n\n// Get all indexes for a table (excluding auto-generated ones)\nasync function getCreateIndexStatements(tableName: string): Promise {\n const result = await global.execute({\n sql:\n `SELECT sql FROM sqlite_master WHERE type='index' AND tbl_name=? COLLATE NOCASE AND sql IS NOT NULL`,\n args: [tableName],\n });\n return result.rows\n .map((row: any) => row[0] as string)\n .filter(Boolean)\n .map((sql) =>\n sql.replace(/^CREATE INDEX/i, \"CREATE INDEX IF NOT EXISTS\")\n .replace(/^CREATE UNIQUE INDEX/i, \"CREATE UNIQUE INDEX IF NOT EXISTS\")\n );\n}\n\n// Get all triggers for a table\nasync function getCreateTriggerStatements(\n tableName: string,\n): Promise {\n const result = await global.execute({\n sql:\n `SELECT sql FROM sqlite_master WHERE type='trigger' AND tbl_name=? COLLATE NOCASE AND sql IS NOT NULL`,\n args: [tableName],\n });\n return result.rows\n .map((row: any) => row[0] as string)\n .filter(Boolean);\n}\n\n// Get column names from PRAGMA table_info\nasync function getColumnNames(tableName: string): Promise {\n const result = await global.execute(`PRAGMA table_info(${tableName})`);\n return result.rows.map((row: any) => row[1] as string);\n}\n\n// =============================================================================\n// 3. Migration Actions\n// =============================================================================\n\nasync function createTableInScoped(tableName: string): Promise {\n // Create table\n const createTableSQL = await getCreateTableStatement(tableName);\n console.log(\"CREATE TABLE:\\n\", createTableSQL);\n await scoped.execute(createTableSQL);\n\n // Create indexes\n const indexStatements = await getCreateIndexStatements(tableName);\n for (const sql of indexStatements) {\n console.log(\"CREATE INDEX:\", sql);\n await scoped.execute(sql);\n }\n\n // Create triggers\n const triggerStatements = await getCreateTriggerStatements(tableName);\n for (const sql of triggerStatements) {\n console.log(\"CREATE TRIGGER:\", sql);\n await scoped.execute(sql);\n }\n}\n\nasync function copyData(tableName: string, batchSize = 100): Promise {\n const columns = await getColumnNames(tableName);\n const columnList = columns.join(\", \");\n const placeholders = columns.map(() => \"?\").join(\", \");\n\n let offset = 0;\n let totalCopied = 0;\n\n while (true) {\n const { rows } = await global.execute({\n sql: `SELECT * FROM ${tableName} LIMIT ? OFFSET ?`,\n args: [batchSize, offset],\n });\n\n if (rows.length === 0) break;\n\n const statements = rows.map((row: any) => ({\n sql:\n `INSERT OR IGNORE INTO ${tableName} (${columnList}) VALUES (${placeholders})`,\n args: Array.isArray(row) ? row : Object.values(row),\n }));\n\n await scoped.batch(statements);\n\n totalCopied += rows.length;\n offset += batchSize;\n console.log(` Copied ${totalCopied} rows...`);\n\n if (rows.length < batchSize) break;\n }\n\n return totalCopied;\n}\n\nasync function verifyMigration(tableName: string): Promise {\n const globalCount = await global.execute(`SELECT COUNT(*) FROM ${tableName}`);\n const scopedCount = await scoped.execute(`SELECT COUNT(*) FROM ${tableName}`);\n\n const globalTotal = globalCount.rows[0][0] as number;\n const scopedTotal = scopedCount.rows[0][0] as number;\n\n console.log(` Global: ${globalTotal} rows, Scoped: ${scopedTotal} rows`);\n\n return globalTotal === scopedTotal;\n}\n\n// =============================================================================\n// 4. Main Migration Orchestrator\n// =============================================================================\n\nexport async function migrate() {\n const tables = getGlobalTableNamesUsedByVal();\n\n for (const tableName of tables) {\n console.log(`\\n${\"=\".repeat(60)}`);\n console.log(`Migrating table: ${tableName}`);\n console.log(\"=\".repeat(60));\n\n // Step 1: Create table, indexes, and triggers in scoped database\n console.log(\"\\n[1/3] Creating schema in scoped database...\");\n await createTableInScoped(tableName);\n console.log(\"✓ Schema created\");\n\n // Step 2: Copy data\n console.log(\"\\n[2/3] Copying data...\");\n const count = await copyData(tableName);\n console.log(`✓ Copied ${count} rows`);\n\n // Step 3: Verify\n console.log(\"\\n[3/3] Verifying migration...\");\n const verified = await verifyMigration(tableName);\n if (verified) {\n console.log(\"✓ Migration verified!\");\n } else {\n console.log(\"✗ Row counts don't match - please investigate\");\n }\n }\n\n console.log(`\\n${\"=\".repeat(60)}`);\n console.log(\"Migration complete!\");\n console.log(\"=\".repeat(60));\n console.log(\"\\nNext steps - update imports in:\");\n console.log(\" • pages/browse (line 2)\");\n console.log(\" • pages/join (line 3)\");\n console.log(\" • rss (line 1)\");\n console.log(\"\\nChange:\");\n console.log(' import { sqlite } from \"https://esm.town/v/std/sqlite\";');\n console.log(\"To:\");\n console.log(\n ' import { sqlite } from \"https://esm.town/v/std/sqlite@14-main/main.ts\";',\n );\n}\n\n// Uncomment to run:\nmigrate();",["D",1769642292866],{"_33":66,"_35":65,"_37":67,"_39":69,"_42":70,"_44":14,"_45":46,"_27":28},{"_33":66,"_35":65,"_37":67,"_39":68},"rss","0022bb14-e591-11ef-9eb9-e6cdfca9ef9f","http","import { sqlite } from \"https://esm.town/v/std/sqlite\";\nimport { dataToRSS } from \"https://esm.town/v/stevekrouse/dataToRSS\";\nimport { zip } from \"npm:lodash-es\";\n\nexport async function rss(req: Request) {\n let { columns, rows } = await sqlite.execute(`select * from datemedocs order by LastUpdated desc limit 20`);\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 let data = profiles.map((p) => {\n let { Name, Profile, LastUpdated, ...rest } = p;\n return {\n title: Name,\n link: Profile,\n pubDate: new Date(LastUpdated),\n description: Object.entries(rest).filter(([, v]) => v).map(([k, v]) => k + \": \" + v).join(\n \"\\n \",\n ),\n };\n }).sort((a, b) => b.pubDate.getTime() - a.pubDate.getTime());\n return new Response(\n dataToRSS(data, {\n title: \"Date Me Directory RSS\",\n link: \"https://dateme.directory\",\n rssLink: \"https://dateme.directory/rss.xml\",\n }),\n {\n headers: {\n \"Content-type\": \"application/rss+xml\",\n },\n },\n );\n}","import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\nimport { dataToRSS } from \"https://esm.town/v/stevekrouse/dataToRSS\";\nimport { zip } from \"npm:lodash-es\";\n\nexport async function rss(req: Request) {\n let { columns, rows } = await sqlite.execute(`select * from datemedocs order by LastUpdated desc limit 20`);\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 let data = profiles.map((p) => {\n let { Name, Profile, LastUpdated, ...rest } = p;\n return {\n title: Name,\n link: Profile,\n pubDate: new Date(LastUpdated),\n description: Object.entries(rest).filter(([, v]) => v).map(([k, v]) => k + \": \" + v).join(\n \"\\n \",\n ),\n };\n }).sort((a, b) => b.pubDate.getTime() - a.pubDate.getTime());\n return new Response(\n dataToRSS(data, {\n title: \"Date Me Directory RSS\",\n link: \"https://dateme.directory\",\n rssLink: \"https://dateme.directory/rss.xml\",\n }),\n {\n headers: {\n \"Content-type\": \"application/rss+xml\",\n },\n },\n );\n}",["D",1769642292866],"id","6ea2d636-e58d-11ef-b8f1-e6cdfca9ef9f","dateme",["D",1738958108106],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","The Date Me Directory, an alternative dating site","imageUrl","a0bf3b31-15a5-4d5c-880e-4b1e22c9bc18","pinnedFileId","d8c06b22-e58e-11ef-942a-e6cdfca9ef9f","pinPreview","pinMigrated","screenshotVersion","likeCount",2,"orgId","e81e7335-6d4c-4764-a902-d0962bbfa9f7","tursoName","6ea2d636e58d11efb8f1e6cdfca9ef9f","tursoHostname","6ea2d636e58d11efb8f1e6cdfca9ef9f-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789687835965],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_127":126,"_134":130},"org",{"_127":126,"_128":-5,"_129":130,"_18":83,"_131":132,"_133":28},"branch",{"_13":116,"_35":117,"_71":46,"_118":72,"_119":-5,"_120":-5,"_121":-5,"_122":-5,"_123":-5,"_124":73,"_125":126},"isOwned",275,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","stevekrouse","handle","displayName","avatar","https://images.clerk.dev/uploaded/img_2PqHa2Gsy93xQrjh2w78Xu0cChW.jpeg","tier","pro","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_71":72,"_35":73,"_42":292,"_75":-5,"_76":28,"_77":78,"_79":78,"_80":81,"_82":-5,"_18":83,"_84":85,"_86":57,"_87":-5,"_88":-5,"_89":90,"_91":92,"_93":94,"_95":96,"_97":293,"_99":90,"_100":101,"_102":101,"_103":104,"_105":104,"_106":104,"_107":101,"_108":101,"_109":294,"_111":295,"_113":296,"_115":28},"tree",[225,231,232,233,234,235],"files",[225,226,227,228,229,230,231,232,233,234,235],"counts",{"_213":214,"_215":210,"_216":90,"_217":218,"_219":220},"contents",[165,166,167,168,169,170],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[158,159,160],"hasHttpFiles","grants","orgs","customDomains",{"_85":157},"dateme.directory",{"_71":164,"_162":-5},{"_71":163,"_162":-5},{"_71":161,"_162":-5},"668f151e-470b-11f1-9ddf-42b51c65c3df","reporterId","5279f3c8-470b-11f1-9a6f-42b51c65c3df","58c25f54-46ed-11f1-8db1-42b51c65c3df",{"_71":206,"_35":207,"_33":208,"_172":-5,"_45":46,"_44":204,"_173":57,"_42":209,"_13":210,"_37":211,"_39":-5,"_27":28,"_176":-5,"_30":212},{"_71":202,"_35":58,"_33":59,"_172":-5,"_45":46,"_44":14,"_173":28,"_42":203,"_13":204,"_37":38,"_39":61,"_27":28,"_176":-5,"_30":205},{"_71":194,"_35":195,"_33":196,"_172":-5,"_45":46,"_44":197,"_173":28,"_42":198,"_13":199,"_37":23,"_39":200,"_27":28,"_176":-5,"_30":201},{"_71":186,"_35":187,"_33":85,"_172":-5,"_45":46,"_44":188,"_173":28,"_42":189,"_13":190,"_37":67,"_39":191,"_27":28,"_176":192,"_30":193},{"_71":178,"_35":179,"_33":180,"_172":-5,"_45":46,"_44":181,"_173":28,"_42":182,"_13":183,"_37":23,"_39":184,"_27":28,"_176":-5,"_30":185},{"_71":171,"_35":65,"_33":66,"_172":-5,"_45":46,"_44":14,"_173":28,"_42":174,"_13":175,"_37":67,"_39":69,"_27":28,"_176":-5,"_30":177},"9df9e9cc-fc9f-11f0-aca5-42dde27851f2","parentId","latest",["D",1769642292866],8,"label",[65],"8d4eb884-784a-11f0-8edf-0224a6c84d84","locations.json","c1b193ba-e58f-11ef-807b-e6cdfca9ef9f",91,["D",1755092204204],7,"[\n \"San Francisco Bay Area\",\n \"NYC\",\n \"London\",\n \"Central Europe\",\n \"DC\",\n \"UK\",\n \"Los Angeles\",\n \"Berlin\",\n \"Barcelona, Spain\",\n \"North America\",\n \"Flexible\",\n \"Boston\",\n \"NY\",\n \"Western US\",\n \"Seattle\",\n \"Chicago\",\n \"Asia\",\n \"NJ\",\n \"Philadelphia\",\n \"Paris, France\",\n \"Colorado\",\n \"Toronto\",\n \"Austin\",\n \"PA\",\n \"Canada\",\n \"Brighton\",\n \"Southern US\",\n \"Vancouver\",\n \"TX\",\n \"Portland\",\n \"MA\",\n \"Denver\",\n \"Brazil\",\n \"Amsterdam\",\n \"WI\",\n \"South of France\",\n \"Cambridge\",\n \"Berkeley\",\n \"WA\",\n \"Vancouver Island\",\n \"South Bay\",\n \"Oxford\",\n \"Oregon\",\n \"North Carolina\",\n \"Dubai\",\n \"Somerville\",\n \"Seoul\",\n \"Sacramento\",\n \"Ohio\",\n \"Madison\",\n \"Madrid, Spain\",\n \"Ladysmith BC\",\n \"Indianapolis\",\n \"Georgia\",\n \"Asheville\",\n \"Sydney Australia\",\n \"Sweden\",\n \"Ribeirão Bonito\",\n \"ON\",\n \"New Haven\",\n \"Nebraska\",\n \"Monterey\",\n \"Lubbock\",\n \"Ewing\",\n \"Collingswood\",\n \"CT\",\n \"Rhode Island\",\n \"Miami\",\n \"Indonesia\",\n \"Norway\",\n \"Israel\",\n \"Spain\"\n]",[179],"99c2a286-7d15-11f0-a60e-0224a6c84d84","index",108,["D",1755619217577],19,"import { Hono } from \"npm:hono@3\";\nimport browse from \"./pages/browse\";\nimport faq from \"./pages/faq\";\nimport home from \"./pages/home\";\nimport { join } from \"./pages/join\";\nimport { rss } from \"./rss\";\n\nconst app = new Hono();\napp.get(\"/\", home);\napp.get(\"/browse\", browse);\napp.route(\"/join\", join);\napp.get(\"/faq\", faq);\napp.get(\"/rss.xml\", c => rss(c.req.raw));\n\napp.onError(e => Promise.reject(e))\nexport default app.fetch;","date",[187],"e20a5c72-e590-11ef-a769-e6cdfca9ef9f","README.md","b0c1b956-e58d-11ef-b938-e6cdfca9ef9f",30,["D",1738959590188],6,"# The Date Me Directory\n\nThe Date Me Directory is an alternative dating website. \n\nThe directory is a simple\ndatabase of Date Me Docs. Date Me Docs are long-form, earnest dating profiles for romantic partners.\n[Learn more here](https://dateme.directory/faq).\n\n## Todos\n\n- [ ] Make the SQLite database forkable and build a widget/workflow for that, ie fix @stevekrouse/dateme_sqlite\n- [ ] Require an email (that isn't shared publicly)\n - [ ] Verify the email address with a \"magic link\"\n- [ ] Refactor Location to an array of Lat, Lon\n - [ ] Geocode all the existing locations\n - [ ] Add a geocoder map input to the form\n - [ ] Allow selecting multiple location through the form\n- [ ] Profile performance & speed up site, possibly add more caching\n- [ ] Let people edit their forms\n- [ ] Featured profiles",[195],"9df98ce8-fc9f-11f0-aca5-42dde27851f2",["D",1769642292866],14,[58],"7b9de126-e58f-11ef-aa79-e6cdfca9ef9f","pages","78e859c0-e58f-11ef-b429-e6cdfca9ef9f",["D",1738958988872],1,"directory",[207],"pulls",0,"branches","forks","envVars",{"_221":223,"_224":214},"connections",{"_221":214,"_222":214},"count","unfilledCount",3,"emptyCount",{"_71":206,"_35":207,"_33":208,"_172":-5,"_45":46,"_44":204,"_173":57,"_42":289,"_13":210,"_37":211,"_39":-5,"_27":28,"_176":-5,"_237":290,"_30":291},{"_71":284,"_35":51,"_33":50,"_172":208,"_45":46,"_44":14,"_173":28,"_42":285,"_13":286,"_37":38,"_39":53,"_27":28,"_176":-5,"_237":287,"_30":288},{"_71":275,"_35":276,"_33":277,"_172":208,"_45":46,"_44":278,"_173":28,"_42":279,"_13":280,"_37":38,"_39":281,"_27":28,"_176":-5,"_237":282,"_30":283},{"_71":266,"_35":267,"_33":268,"_172":208,"_45":46,"_44":269,"_173":28,"_42":270,"_13":271,"_37":38,"_39":272,"_27":28,"_176":-5,"_237":273,"_30":274},{"_71":261,"_35":36,"_33":34,"_172":208,"_45":46,"_44":14,"_173":28,"_42":262,"_13":263,"_37":38,"_39":41,"_27":28,"_176":-5,"_237":264,"_30":265},{"_71":252,"_35":253,"_33":254,"_172":208,"_45":46,"_44":255,"_173":28,"_42":256,"_13":257,"_37":38,"_39":258,"_27":28,"_176":-5,"_237":259,"_30":260},{"_71":202,"_35":58,"_33":59,"_172":-5,"_45":46,"_44":14,"_173":28,"_42":249,"_13":204,"_37":38,"_39":61,"_27":28,"_176":-5,"_237":250,"_30":251},{"_71":194,"_35":195,"_33":196,"_172":-5,"_45":46,"_44":197,"_173":28,"_42":246,"_13":199,"_37":23,"_39":200,"_27":28,"_176":-5,"_237":247,"_30":248},{"_71":186,"_35":187,"_33":85,"_172":-5,"_45":46,"_44":188,"_173":28,"_42":243,"_13":190,"_37":67,"_39":191,"_27":28,"_176":192,"_237":244,"_30":245},{"_71":178,"_35":179,"_33":180,"_172":-5,"_45":46,"_44":181,"_173":28,"_42":240,"_13":183,"_37":23,"_39":184,"_27":28,"_176":-5,"_237":241,"_30":242},{"_71":171,"_35":65,"_33":66,"_172":-5,"_45":46,"_44":14,"_173":28,"_42":236,"_13":175,"_37":67,"_39":69,"_27":28,"_176":-5,"_237":238,"_30":239},["D",1769642292866],"children",[],[65],["D",1755092204204],[],[179],["D",1755619217577],[],[187],["D",1738959590188],[],[195],["D",1769642292866],[],[58],"ffbd2ca0-e990-11ef-bb7b-e6cdfca9ef9f","layout","44427056-e590-11ef-af82-e6cdfca9ef9f",83,["D",1739399444685],12,"/** @jsxImportSource npm:hono@3/jsx */\nimport { PropsWithChildren } from \"npm:hono/jsx\";\nconst tabs = { \"/\": \"Home\", \"/browse\": \"Browse\", \"/faq\": \"FAQ\" };\nimport { parseProject } from \"https://esm.town/v/std/parseImportMeta/project\";\n\nconst thisURL = parseProject(import.meta.url).links.self.project;\n\nexport default function({ activeTab, children }: PropsWithChildren<{ activeTab: string }>) {\n return (\n \n \n Date Me Directory\n \n

Diff · v136