[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_154":155,"_156":157},"routes/_app.x.$handle.$name",{"_11":12,"_13":14,"_15":16,"_18":19,"_17":-7,"_117":-5,"_20":118,"_22":119,"_120":121,"_122":123,"_25":124,"_24":-5,"_125":-5,"_126":-5,"_127":53,"_128":129,"_130":44,"_131":-5,"_132":-5,"_133":134},"routes/_app.x.$handle.$name.branch.$branch.code.$",{"_11":12,"_13":14,"_15":16,"_17":-7,"_18":19,"_20":21,"_22":23,"_24":-7,"_25":26,"_27":-5,"_28":-5,"_29":-5,"_30":-5,"_31":-5},"handle","marc1","name","sghomes_jxmbtb","branchName","main","version","path","","project",{"_33":61,"_13":14,"_45":62,"_63":-5,"_64":53,"_65":66,"_67":66,"_68":69,"_70":-5,"_71":72,"_73":-5,"_74":53,"_75":-5,"_76":-5,"_77":78,"_79":80,"_81":-5,"_82":-5,"_83":-5,"_84":-5,"_85":86,"_87":86,"_88":89,"_90":89,"_91":89,"_92":86,"_93":86,"_94":95,"_96":97,"_98":99,"_100":53},"tree",[56],"file","contents",[32],"upstream","pull","ahead","behind","envVars",{"_33":34,"_13":35,"_36":37,"_38":-5,"_39":40,"_41":42,"_43":44,"_45":46,"_17":47,"_48":49,"_50":51,"_52":53,"_54":-5,"_18":55},"id","1f82d04b-c9b2-4a18-aa63-561adda661dc","main.tsx","fileId","c64e70c6-674f-11f1-8d90-1607ee4eb77e","parentId","branchId","f4b18572-01c2-49cd-a6bb-f6ba38b86a02","branchVersion",7,"latest",true,"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",false,"label",[35],{"_33":34,"_13":35,"_36":37,"_38":-5,"_39":40,"_41":42,"_43":44,"_45":57,"_17":47,"_48":49,"_50":51,"_52":53,"_54":-5,"_58":59,"_18":60},["D",1781379774028],"children",[],[35],"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",0,"orgId","019eb420-ab29-777b-a6b0-b715c4bf52ff","tursoName","tursoHostname","tursoMeasuredAt","pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_11":12,"_116":112},"org",{"_11":12,"_109":110,"_111":112,"_71":72,"_113":114,"_115":53},"branch",{"_17":42,"_13":16,"_33":40,"_101":61,"_102":-5,"_103":-5,"_104":-5,"_105":-5,"_106":-5,"_107":14,"_108":12},"isOwned","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",{"_33":61,"_13":14,"_45":150,"_63":-5,"_64":53,"_65":66,"_67":66,"_68":69,"_70":-5,"_71":72,"_73":-5,"_74":53,"_75":-5,"_76":-5,"_77":78,"_79":80,"_81":-5,"_82":-5,"_83":-5,"_84":-5,"_85":86,"_87":86,"_88":89,"_90":89,"_91":89,"_92":86,"_93":86,"_94":151,"_96":152,"_98":153,"_100":53},[147],"files",[147],"counts",{"_137":78,"_138":139,"_140":78,"_31":141,"_142":143},[135],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_33":34,"_13":35,"_36":37,"_38":-5,"_39":40,"_41":42,"_43":44,"_45":46,"_17":47,"_48":49,"_50":51,"_52":53,"_54":-5,"_18":136},[35],"pulls","branches",1,"forks",{"_144":78,"_146":78},"connections",{"_144":78,"_145":78},"count","unfilledCount","emptyCount",{"_33":34,"_13":35,"_36":37,"_38":-5,"_39":40,"_41":42,"_43":44,"_45":57,"_17":47,"_48":49,"_50":51,"_52":53,"_54":-5,"_58":148,"_18":149},[],[35],["D",1781372774995],{"_11":12,"_116":112},{"_11":12,"_109":110,"_111":112,"_71":72,"_113":114,"_115":53},{"_17":42,"_13":16,"_33":40,"_101":61,"_102":-5,"_103":-5,"_104":-5,"_105":-5,"_106":-5,"_107":14,"_108":12},"ctx",{"_94":-5,"_132":187,"_188":189,"_190":191,"_192":53,"_193":53,"_194":53,"_195":44,"_196":-5,"_197":-7,"_198":-7,"_199":78,"_200":53,"_201":53,"_202":-5,"_203":53,"_204":53,"_205":53,"_206":-5},"ENV",{"_158":159,"_160":161,"_162":16,"_163":164,"_165":166,"_167":168,"_169":170,"_171":172,"_173":174,"_175":176,"_177":178,"_179":180,"_181":182,"_183":184,"_185":186},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","5015b8df46402d8bba4f485ecc37aec202b0e06b","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

Code