[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_155":156,"_157":158},"routes/_app.x.$handle.$name",{"_95":94,"_32":45,"_104":85,"_27":105,"_13":14,"_106":-5,"_11":107,"_108":109,"_110":111,"_112":113,"_114":115,"_20":-5,"_116":-5,"_117":-5,"_118":25,"_119":120,"_121":122,"_123":-5,"_124":-5,"_125":126},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_43":44,"_32":45,"_38":46,"_47":-5,"_48":25,"_49":50,"_51":50,"_52":53,"_54":-5,"_18":55,"_56":-5,"_57":25,"_58":-5,"_59":-5,"_60":61,"_62":63,"_64":-5,"_65":-5,"_66":-5,"_67":-5,"_68":69,"_70":69,"_71":72,"_73":72,"_74":72,"_75":69,"_76":69,"_77":78,"_79":80,"_81":82,"_83":25},"version",6,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":23,"_24":25,"_26":25,"_27":28,"_29":28},"file",{"_30":31,"_32":28,"_33":34,"_35":37,"_38":39,"_40":14,"_41":42,"_24":25},"previous",{"_30":31,"_32":28,"_33":34,"_35":36},"deleted",false,"deletedHere","path","main.tsx","latestPath","fileId","c64e70c6-674f-11f1-8d90-1607ee4eb77e","name","fileType","http","content","// Singapore house hunt — Val Town HTTP val\n// Serves a single-page gallery of the scraped PropertyGuru listings, plus a\n// SQLite-backed shared notes/ratings API so two people see each other's input.\n// Listings data lives in Val Town blob storage (key below), pushed by deploy.mjs.\nimport { blob } from \"https://esm.town/v/std/blob\";\nimport { sqlite } from \"https://esm.town/v/std/sqlite\";\nimport { email } from \"https://esm.town/v/std/email\";\n\nconst DATA_KEY = \"sg_house_data\";\nconst RATINGS = \"sg_house_ratings_v1\";\nconst COMMENTS = \"sg_house_comments_v1\";\nconst SUBMISSIONS = \"sg_house_submissions_v1\";\nconst VISITS = \"sg_house_visits_v1\";\n\nawait sqlite.execute(\n `CREATE TABLE IF NOT EXISTS ${RATINGS} (\n listing_id TEXT NOT NULL,\n author TEXT NOT NULL,\n value INTEGER NOT NULL,\n updated_at TEXT NOT NULL,\n PRIMARY KEY (listing_id, author)\n )`,\n);\nawait sqlite.execute(\n `CREATE TABLE IF NOT EXISTS ${COMMENTS} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n listing_id TEXT NOT NULL,\n author TEXT NOT NULL,\n text TEXT NOT NULL,\n created_at TEXT NOT NULL\n )`,\n);\nawait sqlite.execute(\n `CREATE TABLE IF NOT EXISTS ${SUBMISSIONS} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n url TEXT NOT NULL,\n comment TEXT,\n created_at TEXT NOT NULL\n )`,\n);\nawait sqlite.execute(\n `CREATE TABLE IF NOT EXISTS ${VISITS} (\n listing_id TEXT PRIMARY KEY,\n requested INTEGER NOT NULL,\n by_who TEXT,\n updated_at TEXT NOT NULL\n )`,\n);\n\nconst rowsToObjects = (r: { columns: string[]; rows: unknown[][] }) =>\n r.rows.map((row) => Object.fromEntries(row.map((v, i) => [r.columns[i], v])));\n\nconst json = (data: unknown, status = 200) =>\n new Response(JSON.stringify(data), {\n status,\n headers: { \"content-type\": \"application/json; charset=utf-8\" },\n });\n\nexport default async function (req: Request): Promise {\n const url = new URL(req.url);\n const p = url.pathname;\n\n if (p === \"/api/data\") {\n const data = (await blob.getJSON(DATA_KEY)) ?? { buildings: [] };\n return json(data);\n }\n\n if (p === \"/api/notes\" && req.method === \"GET\") {\n const ratings = rowsToObjects(\n await sqlite.execute(`SELECT listing_id, author, value FROM ${RATINGS}`),\n );\n const comments = rowsToObjects(\n await sqlite.execute(\n `SELECT id, listing_id, author, text, created_at FROM ${COMMENTS} ORDER BY created_at ASC`,\n ),\n );\n const visits = rowsToObjects(\n await sqlite.execute(`SELECT listing_id, requested, by_who FROM ${VISITS} WHERE requested != 0`),\n );\n return json({ ratings, comments, visits });\n }\n\n if (p === \"/api/visit\" && req.method === \"POST\") {\n const b = await req.json();\n if (!b.listingId) return json({ error: \"missing listingId\" }, 400);\n await sqlite.execute({\n sql:\n `INSERT INTO ${VISITS} (listing_id, requested, by_who, updated_at)\n VALUES (?, ?, ?, ?)\n ON CONFLICT(listing_id) DO UPDATE SET requested = excluded.requested, by_who = excluded.by_who, updated_at = excluded.updated_at`,\n args: [b.listingId, Number(b.requested) || 0, b.author || null, new Date().toISOString()],\n });\n return json({ ok: true });\n }\n\n if (p === \"/api/rating\" && req.method === \"POST\") {\n const b = await req.json();\n if (!b.listingId || !b.author) return json({ error: \"missing fields\" }, 400);\n await sqlite.execute({\n sql:\n `INSERT INTO ${RATINGS} (listing_id, author, value, updated_at)\n VALUES (?, ?, ?, ?)\n ON CONFLICT(listing_id, author) DO UPDATE SET value = excluded.value, updated_at = excluded.updated_at`,\n args: [b.listingId, b.author, Number(b.value) || 0, new Date().toISOString()],\n });\n return json({ ok: true });\n }\n\n if (p === \"/api/comment\" && req.method === \"POST\") {\n const b = await req.json();\n if (!b.listingId || !b.author || !b.text?.trim()) {\n return json({ error: \"missing fields\" }, 400);\n }\n await sqlite.execute({\n sql: `INSERT INTO ${COMMENTS} (listing_id, author, text, created_at) VALUES (?, ?, ?, ?)`,\n args: [b.listingId, b.author, b.text.trim().slice(0, 2000), new Date().toISOString()],\n });\n return json({ ok: true });\n }\n\n if (p === \"/api/comment\" && req.method === \"DELETE\") {\n const id = url.searchParams.get(\"id\");\n if (id) await sqlite.execute({ sql: `DELETE FROM ${COMMENTS} WHERE id = ?`, args: [Number(id)] });\n return json({ ok: true });\n }\n\n if (p === \"/api/submissions\" && req.method === \"GET\") {\n const subs = rowsToObjects(\n await sqlite.execute(`SELECT id, url, comment, created_at FROM ${SUBMISSIONS} ORDER BY created_at DESC`),\n );\n return json(subs);\n }\n\n if (p === \"/api/submit\" && req.method === \"POST\") {\n const b = await req.json();\n const u = String(b.url || \"\").trim();\n if (!/propertyguru\\.com\\.sg\\/listing\\//i.test(u)) {\n return json({ error: \"Please paste a PropertyGuru listing link.\" }, 400);\n }\n const comment = String(b.comment || \"\").slice(0, 2000);\n await sqlite.execute({\n sql: `INSERT INTO ${SUBMISSIONS} (url, comment, created_at) VALUES (?, ?, ?)`,\n args: [u, comment, new Date().toISOString()],\n });\n try {\n await email({\n subject: \"🏠 Cyril added a new property\",\n html: `

Cyril just added a property to your Singapore Home Hunt:

\n ${comment ? `

His comment: ${comment.replace(/[<>]/g, \"\")}

` : \"\"}\n

It'll show photos & price after the next refresh.
\n Open the site →

`,\n });\n } catch (e) { console.error(\"email failed:\", e); }\n return json({ ok: true });\n }\n\n if (p === \"/api/submission\" && req.method === \"DELETE\") {\n const id = url.searchParams.get(\"id\");\n if (id) await sqlite.execute({ sql: `DELETE FROM ${SUBMISSIONS} WHERE id = ?`, args: [Number(id)] });\n return json({ ok: true });\n }\n\n return new Response(HTML, {\n headers: { \"content-type\": \"text/html; charset=utf-8\" },\n });\n}\n\nconst HTML = /* html */ `\n\n\n\n\nSingapore Home Hunt\n\n\n\n\n\n

🏙️ Singapore Home Hunt

Loading…

\n Your name (so your partner sees who said what):\n \n

\n\n\n\n

\n\n

🗺️ Map — click a pin to jump to the listing

\n\n\n\n\n\n\n\n\n`;\n","// Singapore house hunt — Val Town HTTP val\n// Serves a single-page gallery of the scraped PropertyGuru listings, plus a\n// SQLite-backed shared notes/ratings API so two people see each other's input.\n// Listings data lives in Val Town blob storage (key below), pushed by deploy.mjs.\nimport { blob } from \"https://esm.town/v/std/blob\";\nimport { sqlite } from \"https://esm.town/v/std/sqlite\";\nimport { email } from \"https://esm.town/v/std/email\";\n\nconst DATA_KEY = \"sg_house_data\";\nconst RATINGS = \"sg_house_ratings_v1\";\nconst COMMENTS = \"sg_house_comments_v1\";\nconst SUBMISSIONS = \"sg_house_submissions_v1\";\nconst VISITS = \"sg_house_visits_v1\";\n\nawait sqlite.execute(\n `CREATE TABLE IF NOT EXISTS ${RATINGS} (\n listing_id TEXT NOT NULL,\n author TEXT NOT NULL,\n value INTEGER NOT NULL,\n updated_at TEXT NOT NULL,\n PRIMARY KEY (listing_id, author)\n )`,\n);\nawait sqlite.execute(\n `CREATE TABLE IF NOT EXISTS ${COMMENTS} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n listing_id TEXT NOT NULL,\n author TEXT NOT NULL,\n text TEXT NOT NULL,\n created_at TEXT NOT NULL\n )`,\n);\nawait sqlite.execute(\n `CREATE TABLE IF NOT EXISTS ${SUBMISSIONS} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n url TEXT NOT NULL,\n comment TEXT,\n created_at TEXT NOT NULL\n )`,\n);\nawait sqlite.execute(\n `CREATE TABLE IF NOT EXISTS ${VISITS} (\n listing_id TEXT PRIMARY KEY,\n requested INTEGER NOT NULL,\n by_who TEXT,\n updated_at TEXT NOT NULL\n )`,\n);\n\nconst rowsToObjects = (r: { columns: string[]; rows: unknown[][] }) =>\n r.rows.map((row) => Object.fromEntries(row.map((v, i) => [r.columns[i], v])));\n\nconst json = (data: unknown, status = 200) =>\n new Response(JSON.stringify(data), {\n status,\n headers: { \"content-type\": \"application/json; charset=utf-8\" },\n });\n\nexport default async function (req: Request): Promise {\n const url = new URL(req.url);\n const p = url.pathname;\n\n if (p === \"/api/data\") {\n const data = (await blob.getJSON(DATA_KEY)) ?? { buildings: [] };\n return json(data);\n }\n\n if (p === \"/api/notes\" && req.method === \"GET\") {\n const ratings = rowsToObjects(\n await sqlite.execute(`SELECT listing_id, author, value FROM ${RATINGS}`),\n );\n const comments = rowsToObjects(\n await sqlite.execute(\n `SELECT id, listing_id, author, text, created_at FROM ${COMMENTS} ORDER BY created_at ASC`,\n ),\n );\n const visits = rowsToObjects(\n await sqlite.execute(`SELECT listing_id, requested, by_who FROM ${VISITS} WHERE requested != 0`),\n );\n return json({ ratings, comments, visits });\n }\n\n if (p === \"/api/visit\" && req.method === \"POST\") {\n const b = await req.json();\n if (!b.listingId) return json({ error: \"missing listingId\" }, 400);\n await sqlite.execute({\n sql:\n `INSERT INTO ${VISITS} (listing_id, requested, by_who, updated_at)\n VALUES (?, ?, ?, ?)\n ON CONFLICT(listing_id) DO UPDATE SET requested = excluded.requested, by_who = excluded.by_who, updated_at = excluded.updated_at`,\n args: [b.listingId, Number(b.requested) || 0, b.author || null, new Date().toISOString()],\n });\n return json({ ok: true });\n }\n\n if (p === \"/api/rating\" && req.method === \"POST\") {\n const b = await req.json();\n if (!b.listingId || !b.author) return json({ error: \"missing fields\" }, 400);\n await sqlite.execute({\n sql:\n `INSERT INTO ${RATINGS} (listing_id, author, value, updated_at)\n VALUES (?, ?, ?, ?)\n ON CONFLICT(listing_id, author) DO UPDATE SET value = excluded.value, updated_at = excluded.updated_at`,\n args: [b.listingId, b.author, Number(b.value) || 0, new Date().toISOString()],\n });\n return json({ ok: true });\n }\n\n if (p === \"/api/comment\" && req.method === \"POST\") {\n const b = await req.json();\n if (!b.listingId || !b.author || !b.text?.trim()) {\n return json({ error: \"missing fields\" }, 400);\n }\n await sqlite.execute({\n sql: `INSERT INTO ${COMMENTS} (listing_id, author, text, created_at) VALUES (?, ?, ?, ?)`,\n args: [b.listingId, b.author, b.text.trim().slice(0, 2000), new Date().toISOString()],\n });\n return json({ ok: true });\n }\n\n if (p === \"/api/comment\" && req.method === \"DELETE\") {\n const id = url.searchParams.get(\"id\");\n if (id) await sqlite.execute({ sql: `DELETE FROM ${COMMENTS} WHERE id = ?`, args: [Number(id)] });\n return json({ ok: true });\n }\n\n if (p === \"/api/submissions\" && req.method === \"GET\") {\n const subs = rowsToObjects(\n await sqlite.execute(`SELECT id, url, comment, created_at FROM ${SUBMISSIONS} ORDER BY created_at DESC`),\n );\n return json(subs);\n }\n\n if (p === \"/api/submit\" && req.method === \"POST\") {\n const b = await req.json();\n const u = String(b.url || \"\").trim();\n if (!/propertyguru\\.com\\.sg\\/listing\\//i.test(u)) {\n return json({ error: \"Please paste a PropertyGuru listing link.\" }, 400);\n }\n const comment = String(b.comment || \"\").slice(0, 2000);\n await sqlite.execute({\n sql: `INSERT INTO ${SUBMISSIONS} (url, comment, created_at) VALUES (?, ?, ?)`,\n args: [u, comment, new Date().toISOString()],\n });\n try {\n await email({\n subject: \"🏠 Cyril added a new property\",\n html: `

Cyril just added a property to your Singapore Home Hunt:

${u}

\n ${comment ? `

His comment: ${comment.replace(/[<>]/g, \"\")}

` : \"\"}\n

It'll show photos & price after the next refresh.
\n Open the site →

🏙️ Singapore Home Hunt

Loading…

\n Your name (so your partner sees who said what):\n \n

\n\n\n\n

\n\n

🗺️ Map — click a pin to jump to the listing

\n\n\n\n\n\n\n\n\n`;\n","createdAt",["D",1781379609445],"branchVersion","branchId","f4b18572-01c2-49cd-a6bb-f6ba38b86a02","id","f93211ac-acad-4ba5-bc53-09ec5544f768","sghomes_jxmbtb",["D",1781372774995],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","Singapore home hunt — shared listings + notes","imageUrl","09d0017f-b431-4bfe-98be-204d22547721","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount",0,"orgId","019eb420-ab29-777b-a6b0-b715c4bf52ff","tursoName","tursoHostname","tursoMeasuredAt","pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_95":94,"_103":99},"org",{"_95":94,"_96":97,"_98":99,"_18":55,"_100":101,"_102":25},"branch",{"_13":84,"_32":85,"_43":42,"_86":44,"_87":-5,"_88":-5,"_89":-5,"_90":-5,"_91":-5,"_92":45,"_93":94},"isOwned",7,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","marc1","handle","displayName","Marc","avatar","https://lh3.googleusercontent.com/a/ACg8ocLUz6whQ8rM9wDF8thCZsGM5Haat5v2fLvGtdw-mkhsa2Q22u96KA=s96-c","tier","free","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_43":44,"_32":45,"_38":151,"_47":-5,"_48":25,"_49":50,"_51":50,"_52":53,"_54":-5,"_18":55,"_56":-5,"_57":25,"_58":-5,"_59":-5,"_60":61,"_62":63,"_64":-5,"_65":-5,"_66":-5,"_67":-5,"_68":69,"_70":69,"_71":72,"_73":72,"_74":72,"_75":69,"_76":69,"_77":152,"_79":153,"_81":154,"_83":25},"tree",[146],"files",[146],"counts",{"_135":61,"_136":137,"_138":61,"_139":140,"_141":142},"contents",[127],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles",true,"grants","orgs","customDomains",{},{"_43":128,"_32":28,"_30":31,"_129":-5,"_41":42,"_40":14,"_130":25,"_38":131,"_13":132,"_33":34,"_35":37,"_24":25,"_133":-5,"_27":134},"40d3dac0-1936-4b64-8097-a052e0a32985","parentId","latest",["D",1781379609445],5,"label",[28],"pulls","branches",1,"forks","envVars",{"_143":61,"_145":61},"connections",{"_143":61,"_144":61},"count","unfilledCount","emptyCount",{"_43":128,"_32":28,"_30":31,"_129":-5,"_41":42,"_40":14,"_130":25,"_38":147,"_13":132,"_33":34,"_35":37,"_24":25,"_133":-5,"_148":149,"_27":150},["D",1781379609445],"children",[],[28],["D",1781372774995],{"_95":94,"_103":99},{"_95":94,"_96":97,"_98":99,"_18":55,"_100":101,"_102":25},{"_13":84,"_32":85,"_43":42,"_86":44,"_87":-5,"_88":-5,"_89":-5,"_90":-5,"_91":-5,"_92":45,"_93":94},"ctx",{"_77":-5,"_124":188,"_189":190,"_191":192,"_193":25,"_194":25,"_195":25,"_196":122,"_197":-5,"_198":-7,"_199":-7,"_200":61,"_201":25,"_202":25,"_203":-5,"_204":25,"_205":25,"_206":25,"_207":-5},"ENV",{"_159":160,"_161":162,"_163":85,"_164":165,"_166":167,"_168":169,"_170":171,"_172":173,"_174":175,"_176":177,"_178":179,"_180":181,"_182":183,"_184":185,"_186":187},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","e87eb04e707cf64e7e532c8e8ec395f209e17f15","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",[],"preferencesKeybindings","default","preferencesTheme","light","preferencesFixers","preferencesCopilot","preferencesSelectionAi","preferencesCloseBrackets","preferencesChatPanelState","preferencesDprint","preferencesDenofmt","notificationCount","flagDenols","isBusinessOrgMember","businessOrgHandle","isBusinessOrgAdmin","isHigherTownieTier","navCollapsed","currentOrgId"]

Add a property

Add a property

Diff · v6