\n ${l.bedrooms} bed · ${l.bathrooms} bath · $${l.rent.toLocaleString()}/mo · ${l.neighborhood}\n ${l.noFee ? ' · NO FEE' : \"\"}\n

\n \n `).join(\"\")\n : `No new listings today. Check back tomorrow!`;\n\n return `\n\n\n

🗽 NYC Apartment Digest

${date}

${count}

new listings

$4K

max rent

2BR+

bedrooms

\n Today's Matches\n

\n ${listingRows}

🔍 Search directly on:

\n \n StreetEasy →\n \n \n Zillow →\n \n \n RentHop →\n \n

\n Watching: ${NEIGHBORHOODS.join(\" · \")}\n

\n\n`;\n}\n",[],[135,170],"17567524-5a24-11f1-82ab-ee650bb23af1","db.ts","175675d8-5a24-11f1-82ab-ee650bb23af1",9,["D",1779924648198],"import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\nimport type { Listing } from \"./streeteasy.ts\";\n\nexport async function initDB() {\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS seen_listings (\n id TEXT PRIMARY KEY,\n address TEXT,\n neighborhood TEXT,\n rent INTEGER,\n bedrooms INTEGER,\n url TEXT,\n source TEXT,\n first_seen_at TEXT DEFAULT (datetime('now'))\n )\n `);\n}\n\nexport async function filterNewListings(listings: Listing[]): Promise {\n if (listings.length === 0) return [];\n\n const placeholders = listings.map(() => \"?\").join(\",\");\n const ids = listings.map((l) => l.id);\n const result = await sqlite.execute({\n sql: `SELECT id FROM seen_listings WHERE id IN (${placeholders})`,\n args: ids,\n });\n\n const seenIds = new Set(result.rows.map((r: any) => r.id));\n return listings.filter((l) => !seenIds.has(l.id));\n}\n\nexport async function markListingsSeen(listings: Listing[]) {\n if (listings.length === 0) return;\n\n const statements = listings.map((l) => ({\n sql: `INSERT OR IGNORE INTO seen_listings (id, address, neighborhood, rent, bedrooms, url, source) VALUES (?, ?, ?, ?, ?, ?, ?)`,\n args: [l.id, l.address, l.neighborhood, l.rent, l.bedrooms, l.url, l.source],\n }));\n\n await sqlite.batch(statements);\n}\n\nexport async function cleanOldListings(daysToKeep = 30) {\n await sqlite.execute({\n sql: `DELETE FROM seen_listings WHERE first_seen_at < datetime('now', ?)`,\n args: [`-${daysToKeep} days`],\n });\n}\n",[],[135,178],["D",1779924630488],[152,153,154],[135],["D",1779923719999],["D",1789509672838],{"_11":12,"_89":85},{"_11":12,"_82":83,"_84":85,"_44":45,"_86":87,"_88":38},{"_29":30,"_13":26,"_20":21,"_27":28,"_31":-5,"_32":-5,"_77":-5,"_78":-5,"_79":-5,"_80":14,"_81":12},"ctx",{"_70":-5,"_111":226,"_227":228,"_229":230,"_231":38,"_232":38,"_233":38,"_234":124,"_235":-5,"_236":-7,"_237":-7,"_238":51,"_239":38,"_240":38,"_241":-5,"_242":38,"_243":38,"_244":38,"_245":-5},"ENV",{"_197":198,"_199":200,"_201":26,"_202":203,"_204":205,"_206":207,"_208":209,"_210":211,"_212":213,"_214":215,"_216":217,"_218":219,"_220":221,"_222":223,"_224":225},"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"]

Branches1

Branches
1