[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_164":165,"_166":167},"routes/_app.x.$handle.$name",{"_11":12,"_13":14,"_15":-7,"_61":134,"_16":-7,"_135":-5,"_17":136,"_137":138,"_28":139,"_21":140,"_23":141,"_142":-5,"_143":-5,"_144":-5,"_145":36,"_146":147,"_148":34,"_149":-5,"_150":-5,"_151":152},"routes/_app.x.$handle.$name._index",{"_11":12,"_13":14,"_15":-7,"_16":-7,"_17":18,"_19":20,"_21":22,"_23":24,"_25":-7,"_26":-5,"_27":-5,"_28":29,"_30":-5,"_31":-5,"_32":-5,"_33":34,"_35":36,"_37":34},"handle","marc1","name","sghomes_jxmbtb","branchName","version","project",{"_39":78,"_13":14,"_50":79,"_80":-5,"_81":36,"_82":83,"_84":83,"_85":86,"_87":-5,"_88":89,"_90":-5,"_91":36,"_92":-5,"_93":-5,"_94":67,"_95":96,"_97":-5,"_98":-5,"_99":-5,"_100":-5,"_101":102,"_103":102,"_104":105,"_106":105,"_107":105,"_108":102,"_109":102,"_110":111,"_112":113,"_114":115,"_116":36},"tags",[],"counts",{"_66":67,"_68":69,"_70":67,"_71":72,"_73":74},"contents",[63],"readme","upstream","pull","files",[38],"preview","ahead","behind","showHomeCustomizationHint",true,"showHTTPPreviewSettingsHint",false,"hasHTTPFiles",{"_39":40,"_13":41,"_42":43,"_44":-5,"_45":46,"_47":48,"_49":34,"_50":51,"_16":52,"_53":54,"_55":56,"_57":36,"_58":-5,"_59":60,"_61":62},"id","1f82d04b-c9b2-4a18-aa63-561adda661dc","main.tsx","fileId","c64e70c6-674f-11f1-8d90-1607ee4eb77e","parentId","branchId","f4b18572-01c2-49cd-a6bb-f6ba38b86a02","branchVersion",7,"latest","createdAt",["D",1781379774028],6,"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","deleted","label","children",[],"path",[41],{"_39":40,"_13":41,"_42":43,"_44":-5,"_45":46,"_47":48,"_49":34,"_50":64,"_16":52,"_53":54,"_55":56,"_57":36,"_58":-5,"_61":65},["D",1781379774028],[41],"pulls",0,"branches",1,"forks","envVars",{"_75":67,"_77":67},"connections",{"_75":67,"_76":67},"count","unfilledCount","emptyCount","f93211ac-acad-4ba5-bc53-09ec5544f768",["D",1781372774995],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","Singapore home hunt — shared listings + notes","imageUrl","userId","09d0017f-b431-4bfe-98be-204d22547721","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount","orgId","019eb420-ab29-777b-a6b0-b715c4bf52ff","tursoName","tursoHostname","tursoMeasuredAt","pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_11":12,"_133":129},"org",{"_11":12,"_126":127,"_128":129,"_88":89,"_130":131,"_132":36},"branch",{"_16":48,"_13":117,"_39":46,"_118":78,"_119":-5,"_120":-5,"_121":-5,"_122":-5,"_123":-5,"_124":14,"_125":12},"isOwned","main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","displayName","Marc","avatar","https://lh3.googleusercontent.com/a/ACg8ocLUz6whQ8rM9wDF8thCZsGM5Haat5v2fLvGtdw-mkhsa2Q22u96KA=s96-c","tier","free","canRestrictVals","profileImageUrl","","adoptOrgId",{"_39":78,"_13":14,"_50":160,"_80":-5,"_81":36,"_82":83,"_84":83,"_85":86,"_87":-5,"_88":89,"_90":-5,"_91":36,"_92":-5,"_93":-5,"_94":67,"_95":96,"_97":-5,"_98":-5,"_99":-5,"_100":-5,"_101":102,"_103":102,"_104":105,"_106":105,"_107":105,"_108":102,"_109":102,"_110":161,"_112":162,"_114":163,"_116":36},"tree",[157],[157],{"_66":67,"_68":69,"_70":67,"_71":155,"_73":156},[153],"file","upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_39":40,"_13":41,"_42":43,"_44":-5,"_45":46,"_47":48,"_49":34,"_50":64,"_16":52,"_53":54,"_55":56,"_57":36,"_58":-5,"_61":154},[41],{"_75":67,"_77":67},{"_75":67,"_76":67},{"_39":40,"_13":41,"_42":43,"_44":-5,"_45":46,"_47":48,"_49":34,"_50":51,"_16":52,"_53":54,"_55":56,"_57":36,"_58":-5,"_59":158,"_61":159},[],[41],["D",1781372774995],{"_11":12,"_133":129},{"_11":12,"_126":127,"_128":129,"_88":89,"_130":131,"_132":36},{"_16":48,"_13":117,"_39":46,"_118":78,"_119":-5,"_120":-5,"_121":-5,"_122":-5,"_123":-5,"_124":14,"_125":12},"ctx",{"_110":-5,"_150":197,"_198":199,"_200":201,"_202":36,"_203":36,"_204":36,"_205":34,"_206":-5,"_207":-7,"_208":-7,"_209":67,"_210":36,"_211":36,"_212":-5,"_213":36,"_214":36,"_215":36,"_216":-5},"ENV",{"_168":169,"_170":171,"_172":117,"_173":174,"_175":176,"_177":178,"_179":180,"_181":182,"_183":184,"_185":186,"_187":188,"_189":190,"_191":192,"_193":194,"_195":196},"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