[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_152":153,"_154":155},"routes/_app.x.$handle.$name",{"_94":93,"_32":45,"_102":84,"_27":103,"_13":14,"_104":-5,"_11":105,"_106":107,"_108":109,"_110":111,"_112":113,"_20":-5,"_114":-5,"_115":-5,"_116":25,"_117":118,"_119":25,"_120":-5,"_121":-5,"_122":123},"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":-5,"_53":-5,"_18":54,"_55":-5,"_56":25,"_57":-5,"_58":-5,"_59":60,"_61":62,"_63":-5,"_64":-5,"_65":-5,"_66":-5,"_67":68,"_69":68,"_70":71,"_72":71,"_73":71,"_74":68,"_75":68,"_76":77,"_78":79,"_80":81,"_82":25},"version",7,"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.ts","latestPath","fileId","8d5eb386-f060-11f0-a253-42dde27851f2","name","fileType","interval","content","import { sqlite } from \"https://esm.town/v/std/sqlite\";\nimport { email } from \"https://esm.town/v/std/email\";\nimport * as cheerio from \"npm:cheerio\";\n\ntype Interval = any;\n\ninterface SearchQuery {\n label: string;\n url: string;\n}\n\n// Add your searches here\nconst QUERIES: SearchQuery[] = [\n {\n label: \"Apple Home Pod Mini\",\n url:\n \"https://www.olx.pl/oferty/q-apple-home-pod-mini/?search%5Bfilter_float_price:from%5D=100&search%5Bfilter_float_price:to%5D=500\",\n },\n {\n label: \"Symfonisk Lamp\",\n url: \"https://www.olx.pl/oferty/q-symfonisk-lamp\",\n },\n {\n label: \"Apple Watch Alpine\",\n url:\n \"https://www.olx.pl/oferty/q-apple-watch-alpine/?search%5Bfilter_float_price:from%5D=100&search%5Bfilter_float_price:to%5D=300\",\n },\n];\n\nasync function initDb() {\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS listings (\n id TEXT PRIMARY KEY,\n url TEXT,\n title TEXT,\n price TEXT,\n created_at DATETIME DEFAULT CURRENT_TIMESTAMP\n )\n `);\n}\n\nasync function scrapeOlx(url: string) {\n console.log(`Fetching OLX results for: ${url}`);\n const response = await fetch(url, {\n headers: {\n \"User-Agent\":\n \"Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0.0.0 Safari/537.36\",\n },\n });\n const html = await response.text();\n const $ = cheerio.load(html);\n\n const listings: { id: string; title: string; price: string; url: string }[] =\n [];\n\n // Selector based on browser investigation: div[data-cy=\"l-card\"]\n $('div[data-cy=\"l-card\"]').each((_, element) => {\n const card = $(element);\n\n // Extract title (h4 found to be more reliable in tests)\n const title = card.find(\"h4\").text().trim();\n\n // Extract price with regex cleaning\n const rawPrice = card.find('[data-testid=\"ad-price\"]').text().trim();\n const priceMatch = rawPrice.match(/[\\d\\s]+zł/);\n const price = priceMatch ? priceMatch[0] : rawPrice.split(\"css\")[0].trim();\n\n // Extract URL\n let itemUrl = card.find(\"a\").attr(\"href\");\n\n if (itemUrl && !itemUrl.startsWith(\"http\")) {\n itemUrl = `https://www.olx.pl${itemUrl}`;\n }\n\n // Generate a unique ID (hash or just use URL)\n const id = itemUrl;\n\n if (id && title && itemUrl) {\n listings.push({ id, title, price, url: itemUrl });\n }\n });\n\n return listings;\n}\n\nexport default async function (interval: Interval) {\n await initDb();\n\n const allNewListings: { queryLabel: string; item: any }[] = [];\n\n for (const query of QUERIES) {\n const currentListings = await scrapeOlx(query.url);\n console.log(\n `Found ${currentListings.length} listings for \"${query.label}\".`,\n );\n\n for (const item of currentListings) {\n const result = await sqlite.execute({\n sql: \"SELECT price FROM listings WHERE id = ?\",\n args: [item.id],\n });\n\n if (result.rows.length === 0) {\n console.log(`New listing found for ${query.label}: ${item.title}`);\n await sqlite.execute({\n sql:\n \"INSERT INTO listings (id, url, title, price) VALUES (?, ?, ?, ?)\",\n args: [item.id, item.url, item.title, item.price],\n });\n allNewListings.push({ queryLabel: query.label, item, type: \"new\" });\n } else {\n const storedPrice = result.rows[0][0];\n if (storedPrice !== item.price) {\n console.log(\n `Price change for ${item.title}: ${storedPrice} -> ${item.price}`,\n );\n await sqlite.execute({\n sql: \"UPDATE listings SET price = ? WHERE id = ?\",\n args: [item.price, item.id],\n });\n allNewListings.push({\n queryLabel: query.label,\n item,\n type: \"updated\",\n oldPrice: storedPrice,\n });\n }\n }\n }\n }\n\n if (allNewListings.length > 0) {\n console.log(`Sending notification for ${allNewListings.length} items.`);\n\n const htmlLines = allNewListings.map((entry) => {\n const { queryLabel, item, type } = entry;\n if (type === \"updated\") {\n return `

[${queryLabel}] [Price Update] ${item.title}: ${entry.oldPrice} ➝ ${item.price}

`;\n }\n return `

[${queryLabel}] [New] ${item.title} - ${item.price}

`;\n }).join(\"\");\n\n await email({\n subject: `OLX: ${allNewListings.length} Updates (New/Price Changes)`,\n html: `\n

Updates Found

\n ${htmlLines}\n \n

Checked at: ${new Date().toLocaleString()}

\n `,\n });\n } else {\n console.log(\"No new listings or price changes found.\");\n }\n}","import { sqlite } from \"https://esm.town/v/std/sqlite\";\nimport { email } from \"https://esm.town/v/std/email\";\nimport * as cheerio from \"npm:cheerio\";\n\ntype Interval = any;\n\ninterface SearchQuery {\n label: string;\n url: string;\n}\n\n// Add your searches here\nconst QUERIES: SearchQuery[] = [\n {\n label: \"Apple Home Pod Mini\",\n url:\n \"https://www.olx.pl/oferty/q-apple-home-pod-mini/?search%5Bfilter_float_price:from%5D=100&search%5Bfilter_float_price:to%5D=290\",\n },\n {\n label: \"Symfonisk Lamp\",\n url:\n \"https://www.olx.pl/oferty/q-symfonisk-lamp/?search%5Bfilter_float_price:from%5D=100&search%5Bfilter_float_price:to%5D=500\",\n },\n {\n label: \"Apple Watch Alpine\",\n url:\n \"https://www.olx.pl/oferty/q-apple-watch-alpine/?search%5Bfilter_float_price:from%5D=100&search%5Bfilter_float_price:to%5D=200\",\n },\n];\n\nasync function initDb() {\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS listings (\n id TEXT PRIMARY KEY,\n url TEXT,\n title TEXT,\n price TEXT,\n created_at DATETIME DEFAULT CURRENT_TIMESTAMP\n )\n `);\n}\n\nasync function scrapeOlx(url: string) {\n console.log(`Fetching OLX results for: ${url}`);\n const response = await fetch(url, {\n headers: {\n \"User-Agent\":\n \"Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0.0.0 Safari/537.36\",\n },\n });\n const html = await response.text();\n const $ = cheerio.load(html);\n\n const listings: { id: string; title: string; price: string; url: string }[] =\n [];\n\n // Selector based on browser investigation: div[data-cy=\"l-card\"]\n $('div[data-cy=\"l-card\"]').each((_, element) => {\n const card = $(element);\n\n // Extract title (h4 found to be more reliable in tests)\n const title = card.find(\"h4\").text().trim();\n\n // Extract price with regex cleaning\n const rawPrice = card.find('[data-testid=\"ad-price\"]').text().trim();\n const priceMatch = rawPrice.match(/[\\d\\s]+zł/);\n const price = priceMatch ? priceMatch[0] : rawPrice.split(\"css\")[0].trim();\n\n // Extract URL\n let itemUrl = card.find(\"a\").attr(\"href\");\n\n if (itemUrl && !itemUrl.startsWith(\"http\")) {\n itemUrl = `https://www.olx.pl${itemUrl}`;\n }\n\n // Generate a unique ID (hash or just use URL)\n const id = itemUrl;\n\n if (id && title && itemUrl) {\n listings.push({ id, title, price, url: itemUrl });\n }\n });\n\n return listings;\n}\n\nexport default async function (interval: Interval) {\n await initDb();\n\n const allNewListings: { queryLabel: string; item: any }[] = [];\n\n for (const query of QUERIES) {\n const currentListings = await scrapeOlx(query.url);\n console.log(\n `Found ${currentListings.length} listings for \"${query.label}\".`,\n );\n\n for (const item of currentListings) {\n const result = await sqlite.execute({\n sql: \"SELECT price FROM listings WHERE id = ?\",\n args: [item.id],\n });\n\n if (result.rows.length === 0) {\n console.log(`New listing found for ${query.label}: ${item.title}`);\n await sqlite.execute({\n sql:\n \"INSERT INTO listings (id, url, title, price) VALUES (?, ?, ?, ?)\",\n args: [item.id, item.url, item.title, item.price],\n });\n allNewListings.push({ queryLabel: query.label, item, type: \"new\" });\n } else {\n const storedPrice = result.rows[0][0];\n if (storedPrice !== item.price) {\n console.log(\n `Price change for ${item.title}: ${storedPrice} -> ${item.price}`,\n );\n await sqlite.execute({\n sql: \"UPDATE listings SET price = ? WHERE id = ?\",\n args: [item.price, item.id],\n });\n allNewListings.push({\n queryLabel: query.label,\n item,\n type: \"updated\",\n oldPrice: storedPrice,\n });\n }\n }\n }\n }\n\n if (allNewListings.length > 0) {\n console.log(`Sending notification for ${allNewListings.length} items.`);\n\n const htmlLines = allNewListings.map((entry) => {\n const { queryLabel, item, type } = entry;\n if (type === \"updated\") {\n return `

[${queryLabel}] [Price Update] ${item.title}: ${entry.oldPrice} ➝ ${item.price}

`;\n }\n return `

[${queryLabel}] [New] ${item.title} - ${item.price}

`;\n }).join(\"\");\n\n await email({\n subject: `OLX: ${allNewListings.length} Updates (New/Price Changes)`,\n html: `\n

Updates Found

\n ${htmlLines}\n \n

Checked at: ${new Date().toLocaleString()}

\n `,\n });\n } else {\n console.log(\"No new listings or price changes found.\");\n }\n}","createdAt",["D",1769179870596],"branchVersion","branchId","8d5d339e-f060-11f0-a253-42dde27851f2","id","8d5cf85c-f060-11f0-a253-42dde27851f2","olx-bot",["D",1768295792767],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","imageUrl","20f5406c-0713-400a-abb9-b8c3ffc8fe74","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount",0,"orgId","187670db-abf4-4154-ad32-97b090933f0a","tursoName","tursoHostname","tursoMeasuredAt","pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_94":93,"_101":97},"org",{"_94":93,"_95":-5,"_96":97,"_18":54,"_98":99,"_100":25},"branch",{"_13":83,"_32":84,"_43":42,"_85":44,"_86":-5,"_87":-5,"_88":-5,"_89":-5,"_90":-5,"_91":45,"_92":93},"isOwned",9,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","ciebiada","handle","displayName","avatar","https://img.clerk.com/eyJ0eXBlIjoiZGVmYXVsdCIsImlpZCI6Imluc18yTm10cGhQUklwU0tqZHNiOHNnNGd2ZjJURFUiLCJyaWQiOiJ1c2VyXzJrSW5tbVIwQkhLOVBLTk5NUUZza2h2TGkzSCJ9","tier","free","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_43":44,"_32":45,"_38":148,"_47":-5,"_48":25,"_49":50,"_51":50,"_52":-5,"_53":-5,"_18":54,"_55":-5,"_56":25,"_57":-5,"_58":-5,"_59":60,"_61":62,"_63":-5,"_64":-5,"_65":-5,"_66":-5,"_67":68,"_69":68,"_70":71,"_72":71,"_73":71,"_74":68,"_75":68,"_76":149,"_78":150,"_80":151,"_82":25},"tree",[143],"files",[143],"counts",{"_132":60,"_133":134,"_135":60,"_136":137,"_138":139},"contents",[124],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_43":125,"_32":28,"_30":31,"_126":-5,"_41":42,"_40":14,"_127":25,"_38":128,"_13":129,"_33":34,"_35":37,"_24":25,"_130":-5,"_27":131},"f4d26820-f86a-11f0-b071-42dde27851f2","parentId","latest",["D",1769179870596],6,"label",[28],"pulls","branches",1,"forks","envVars",{"_140":60,"_142":60},"connections",{"_140":60,"_141":60},"count","unfilledCount","emptyCount",{"_43":125,"_32":28,"_30":31,"_126":-5,"_41":42,"_40":14,"_127":25,"_38":144,"_13":129,"_33":34,"_35":37,"_24":25,"_130":-5,"_145":146,"_27":147},["D",1769179870596],"children",[],[28],["D",1768295792767],{"_94":93,"_101":97},{"_94":93,"_95":-5,"_96":97,"_18":54,"_98":99,"_100":25},{"_13":83,"_32":84,"_43":42,"_85":44,"_86":-5,"_87":-5,"_88":-5,"_89":-5,"_90":-5,"_91":45,"_92":93},"ctx",{"_76":-5,"_121":185,"_186":187,"_188":189,"_190":25,"_191":25,"_192":25,"_193":194,"_195":-5,"_196":-7,"_197":-7,"_198":60,"_199":25,"_200":25,"_201":-5,"_202":25,"_203":25,"_204":25,"_205":-5},"ENV",{"_156":157,"_158":159,"_160":84,"_161":162,"_163":164,"_165":166,"_167":168,"_169":170,"_171":172,"_173":174,"_175":176,"_177":178,"_179":180,"_181":182,"_183":184},"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",true,"preferencesChatPanelState","preferencesDprint","preferencesDenofmt","notificationCount","flagDenols","isBusinessOrgMember","businessOrgHandle","isBusinessOrgAdmin","isHigherTownieTier","navCollapsed","currentOrgId"]

Diff · v7