[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_219":220,"_221":222},"routes/_app.x.$handle.$name",{"_105":104,"_38":50,"_114":95,"_33":115,"_13":14,"_116":-5,"_11":117,"_118":119,"_120":121,"_122":123,"_124":125,"_26":-5,"_126":-5,"_127":-5,"_128":54,"_129":130,"_131":31,"_132":-5,"_133":-5,"_134":135},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":18,"_19":-5},"project",{"_48":49,"_38":50,"_43":51,"_52":-5,"_53":54,"_55":56,"_57":56,"_58":59,"_60":-5,"_19":61,"_62":63,"_64":31,"_65":-5,"_66":-5,"_67":68,"_69":70,"_71":72,"_73":74,"_75":76,"_77":-5,"_78":79,"_80":79,"_81":82,"_83":82,"_84":82,"_85":79,"_86":79,"_87":88,"_89":90,"_91":92,"_93":54},"version",21,"changes",[25],"aiChatInfo",{"_20":21,"_22":-5,"_23":-5,"_24":-5},"userId","aiChatMessageId","5c6ace43-21b3-4adc-b6fb-ea4227201481","aiChatThreadId","aiChatThreadUserId","aiChatThreadTitle",{"_26":27,"_28":29,"_30":31,"_32":31,"_33":34,"_35":34},"file",{"_36":37,"_38":34,"_39":40,"_41":42,"_43":44,"_45":14,"_46":47,"_30":31},"previous",{"_36":37,"_38":34,"_39":40,"_41":42},"deleted",true,"deletedHere","path","debug2.ts","latestPath","fileId","3c464e2c-7fc2-11f1-a4b1-1607ee4eb77e","name","fileType","script","content","// Try different user agents and approaches to get product data from Temu\n\nconst SEARCH_URL =\n \"https://www.temu.com/search_result.html?search_key=%D7%98%D7%9E%D7%95%20%D7%A7%D7%99%D7%A9%D7%95%D7%98%20%D7%A4%D7%A8%D7%97%D7%99%D7%9D%20%D7%9C%D7%A8%D7%90%D7%A9%20%D7%9C%D7%97%D7%AA%D7%95%D7%A0%D7%94%20%D7%96%D7%94%D7%91&search_method=user\";\n\nconst userAgents = [\n \"Mozilla/5.0 (compatible; Googlebot/2.1; +http://www.google.com/bot.html)\",\n \"Mozilla/5.0 (compatible; Googlebot/2.1; +http://www.google.com/bot.html) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0.0.0 Safari/537.36\",\n];\n\nfor (const ua of userAgents) {\n console.log(`\\n=== Trying UA: ${ua.slice(0, 40)}... ===`);\n try {\n const res = await fetch(SEARCH_URL, {\n headers: {\n \"User-Agent\": ua,\n \"Accept\": \"text/html,application/xhtml+xml,*/*\",\n },\n });\n const html = await res.text();\n console.log(`Status: ${res.status}, Length: ${html.length}`);\n\n const priceMatches = [...html.matchAll(/\\$\\d+\\.?\\d{0,2}/g)];\n const goodsNameMatches = [...html.matchAll(/\"goodsName\"\\s*:\\s*\"([^\"]+)\"/g)];\n const salePriceMatches = [...html.matchAll(/\"salePrice\"\\s*:\\s*\\{([^}]+)\\}/g)];\n\n console.log(`$ prices: ${priceMatches.length}, goodsName: ${goodsNameMatches.length}, salePrice: ${salePriceMatches.length}`);\n\n if (goodsNameMatches.length > 0) {\n console.log(\"First 3 goods names:\");\n for (let i = 0; i < Math.min(3, goodsNameMatches.length); i++) {\n console.log(` ${goodsNameMatches[i][1]}`);\n }\n }\n if (salePriceMatches.length > 0) {\n console.log(\"First 3 sale prices:\");\n for (let i = 0; i < Math.min(3, salePriceMatches.length); i++) {\n console.log(` ${salePriceMatches[i][1]}`);\n }\n }\n if (priceMatches.length > 0) {\n console.log(\"First 5 $ prices:\");\n for (let i = 0; i < Math.min(5, priceMatches.length); i++) {\n console.log(` ${priceMatches[i][0]}`);\n }\n }\n } catch (e) {\n console.log(`Error: ${e}`);\n }\n}\n","createdAt",["D",1784061160267],"branchVersion","branchId","bfd879d3-045c-4d12-a588-d9d448133b49","id","8177f21a-8d9a-4836-b161-517fd02a2f59","temu-price-tracker",["D",1784060691062],"deletedAt","legacyEnvVars",false,"privacy","public","httpPrivacy","description","Track Temu product prices and get email alerts when prices drop","imageUrl","b0ddb193-971c-48cf-b6e4-6ae743b9885c","pinnedFileId","1e742346-7fc3-11f1-880d-1607ee4eb77e","pinPreview","pinMigrated","screenshotVersion","likeCount",0,"orgId","019f622f-e377-70a4-887f-3d8c24230afa","tursoName","8177f21a8d9a4836b161517fd02a2f59","tursoHostname","8177f21a8d9a4836b161517fd02a2f59-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789473046147],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_105":104,"_113":109},"org",{"_105":104,"_106":107,"_108":109,"_19":61,"_110":111,"_112":54},"branch",{"_13":94,"_38":95,"_48":47,"_96":49,"_97":-5,"_98":-5,"_99":-5,"_100":-5,"_101":-5,"_102":50,"_103":104},"isOwned",22,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","ayalarot12","handle","displayName","אילה ביכלר","avatar","https://lh3.googleusercontent.com/a/ACg8ocICqPGHEjNc90LBLwJmyiIvzGkWGVrjBPubchUyoDarmDsbIg=s96-c","tier","free","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_48":49,"_38":50,"_43":214,"_52":-5,"_53":54,"_55":56,"_57":56,"_58":59,"_60":-5,"_19":61,"_62":63,"_64":31,"_65":-5,"_66":-5,"_67":68,"_69":70,"_71":72,"_73":74,"_75":215,"_77":-5,"_78":79,"_80":79,"_81":82,"_83":82,"_84":82,"_85":79,"_86":79,"_87":216,"_89":217,"_91":218,"_93":54},"tree",[193,194,195,196,197],"files",[193,194,195,196,197],"counts",{"_182":68,"_183":184,"_185":68,"_186":187,"_188":189},"contents",[136,137,138,139,140],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_48":175,"_38":176,"_36":63,"_144":-5,"_46":47,"_45":177,"_146":31,"_43":178,"_13":68,"_39":179,"_41":180,"_30":54,"_150":-5,"_33":181},{"_48":166,"_38":167,"_36":168,"_144":-5,"_46":47,"_45":169,"_146":31,"_43":170,"_13":171,"_39":172,"_41":173,"_30":54,"_150":-5,"_33":174},{"_48":159,"_38":160,"_36":161,"_144":-5,"_46":47,"_45":162,"_146":54,"_43":163,"_13":68,"_39":40,"_41":164,"_30":54,"_150":-5,"_33":165},{"_48":152,"_38":153,"_36":154,"_144":-5,"_46":47,"_45":155,"_146":31,"_43":156,"_13":68,"_39":40,"_41":157,"_30":54,"_150":-5,"_33":158},{"_48":141,"_38":142,"_36":143,"_144":-5,"_46":47,"_45":145,"_146":31,"_43":147,"_13":148,"_39":40,"_41":149,"_30":54,"_150":-5,"_33":151},"46082513-a3c7-4a3f-8992-c45a6b204259","scrape.ts","1b94ecce-7fc2-11f1-87a8-1607ee4eb77e","parentId",14,"latest",["D",1784061113356],4,"// Scrapes a single Temu product page for its current price\n\nexport interface TemuProduct {\n id: string;\n title: string;\n price: number;\n originalPrice?: number;\n url: string;\n image?: string;\n}\n\nconst UA =\n \"Mozilla/5.0 (compatible; Googlebot/2.1; +http://www.google.com/bot.html) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0.0.0 Safari/537.36\";\n\nexport async function scrapeProduct(url: string): Promise {\n console.log(`Scraping: ${url}`);\n\n // Try Jina Reader first (renders JS)\n try {\n const jinaRes = await fetch(`https://r.jina.ai/${url}`, {\n headers: { \"Accept\": \"text/plain\" },\n });\n if (jinaRes.ok) {\n const text = await jinaRes.text();\n console.log(`Jina returned ${text.length} chars`);\n const product = parseJinaProduct(text, url);\n if (product) return product;\n }\n } catch (e) {\n console.log(`Jina error: ${e}`);\n }\n\n // Fallback: direct fetch\n try {\n const res = await fetch(url, {\n headers: { \"User-Agent\": UA, \"Accept\": \"text/html,*/*\" },\n redirect: \"follow\",\n });\n if (res.ok) {\n const html = await res.text();\n console.log(`Direct fetch: ${html.length} chars`);\n const product = parseHtmlProduct(html, url);\n if (product) return product;\n }\n } catch (e) {\n console.log(`Direct fetch error: ${e}`);\n }\n\n console.log(\"Could not extract product data\");\n return null;\n}\n\nfunction parseJinaProduct(text: string, url: string): TemuProduct | null {\n // Jina Reader returns readable text. Look for price and title.\n // Extract product ID from URL\n const idMatch = url.match(/goods-(\\d+)/) || url.match(/-(\\d{10,})\\.html/);\n const id = idMatch ? idMatch[1] : url;\n\n // Find the title — usually the first meaningful line or og:title\n const titleMatch = text.match(/Title:\\s*(.+)/i) || text.match(/^#\\s*(.+)/m);\n const title = titleMatch ? titleMatch[1].trim() : extractTitleFromUrl(url);\n\n // Find price — look for $XX.XX pattern\n const priceMatch = text.match(/\\$(\\d+\\.?\\d{0,2})/);\n if (!priceMatch) {\n console.log(\"Jina: no price found in text\");\n return null;\n }\n\n const price = parseFloat(priceMatch[1]);\n if (price <= 0) return null;\n\n // Try to find original/market price (usually higher, appears as \"Original price $XX\")\n const originalMatch = text.match(/Original price\\s*\\$(\\d+\\.?\\d{0,2})/i);\n const originalPrice = originalMatch ? parseFloat(originalMatch[1]) : undefined;\n\n // Try to find image\n const imageMatch = text.match(/(https?:\\/\\/[^\\s]*kwcdn[^\\s]*\\.jpg)/i);\n const image = imageMatch ? imageMatch[1] : undefined;\n\n console.log(`Jina parsed: ${title} - $${price}`);\n return { id, title, price, originalPrice, url, image };\n}\n\nfunction parseHtmlProduct(html: string, url: string): TemuProduct | null {\n const idMatch = url.match(/goods-(\\d+)/) || url.match(/-(\\d{10,})\\.html/);\n const id = idMatch ? idMatch[1] : url;\n\n // Try og:title meta tag\n const ogTitleMatch = html.match(/]*property=\"og:title\"[^>]*content=\"([^\"]+)\"/i);\n const title = ogTitleMatch ? ogTitleMatch[1] : extractTitleFromUrl(url);\n\n // Try meta price\n const metaPriceMatch = html.match(/]*itemprop=\"price\"[^>]*content=\"([^\"]+)\"/i);\n if (metaPriceMatch) {\n const price = parseFloat(metaPriceMatch[1]);\n if (price > 0) {\n return { id, title, price, url };\n }\n }\n\n // Try data-type=\"price\" span\n const priceSpanMatch = html.match(\n /data-type=\"price\"[^>]*>[\\s\\S]*?]*>\\$(\\d+\\.?\\d{0,2})<\\/span>/i,\n );\n if (priceSpanMatch) {\n const price = parseFloat(priceSpanMatch[1]);\n if (price > 0) {\n const originalMatch = html.match(\n /data-type=\"marketPrice\"[^>]*>[\\s\\S]*?]*>\\$(\\d+\\.?\\d{0,2})<\\/span>/i,\n );\n return {\n id,\n title,\n price,\n originalPrice: originalMatch ? parseFloat(originalMatch[1]) : undefined,\n url,\n };\n }\n }\n\n // Try any $ price in the page\n const anyPriceMatch = html.match(/\\$(\\d+\\.\\d{2})/);\n if (anyPriceMatch) {\n const price = parseFloat(anyPriceMatch[1]);\n if (price > 0) return { id, title, price, url };\n }\n\n return null;\n}\n\nfunction extractTitleFromUrl(url: string): string {\n const slug = url\n .replace(/https?:\\/\\/www\\.temu\\.com\\//, \"\")\n .replace(/\\.html.*$/, \"\")\n .replace(/^goods-\\d+$/, \"Temu Product\");\n return slug\n .replace(/-/g, \" \")\n .replace(/^\\d+\\s*pc[s]?\\s*/i, \"\")\n .trim()\n .replace(/\\b\\w/g, (c) => c.toUpperCase()) || \"Temu Product\";\n}\n","label",[142],"3676aa7c-21aa-441b-b8d7-aaa550bd8e1f","debug4.ts","51b71d4a-7fc2-11f1-a606-1607ee4eb77e",7,["D",1784060799639],"// Extract the goodsList JSON and inspect its full structure\n\nconst SEARCH_URL =\n \"https://www.temu.com/search_result.html?search_key=%D7%98%D7%9E%D7%95%20%D7%A7%D7%99%D7%A9%D7%95%D7%98%20%D7%A4%D7%A8%D7%97%D7%99%D7%9D%20%D7%9C%D7%A8%D7%90%D7%A9%20%D7%9C%D7%97%D7%AA%D7%95%D7%A0%D7%94%20%D7%96%D7%94%D7%91&search_method=user\";\n\nconst res = await fetch(SEARCH_URL, {\n headers: {\n \"User-Agent\":\n \"Mozilla/5.0 (compatible; Googlebot/2.1; +http://www.google.com/bot.html) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0.0.0 Safari/537.36\",\n \"Accept\": \"text/html,application/xhtml+xml,*/*\",\n },\n});\n\nconst html = await res.text();\n\n// Find goodsList and extract the first item's full structure\nconst goodsListIdx = html.indexOf('\"goodsList\"');\nif (goodsListIdx === -1) {\n console.log(\"No goodsList found\");\n} else {\n // Show a big chunk starting from goodsList\n const chunk = html.slice(goodsListIdx, goodsListIdx + 3000);\n console.log(\"=== goodsList area (first 3000 chars) ===\");\n console.log(chunk);\n}\n\n// Also look at the HTML structure around prices — find a product card\nconst priceIdx = html.indexOf('data-type=\"price\"');\nif (priceIdx !== -1) {\n const start = Math.max(0, priceIdx - 500);\n const end = Math.min(html.length, priceIdx + 500);\n console.log(\"\\n=== HTML around first price element ===\");\n console.log(html.slice(start, end).replace(/\\n/g, \" \"));\n}\n",[153],"c42f49b5-f6ff-40b6-867e-2a1ebb2d149c","debug-product.ts","00ef6970-7fc3-11f1-a415-1607ee4eb77e",13,["D",1784061093611],"// Test if a single Temu product page contains price data in HTML\n\nconst urls = [\n \"https://www.temu.com/1pc-pentagram-gold-rimmed-headband-headband-baroque-bride-headpiece-headband-golden-vintage-goods-605955525810224.html\",\n \"https://www.temu.com/goods-605955525810224.html\",\n];\n\nconst UA =\n \"Mozilla/5.0 (compatible; Googlebot/2.1; +http://www.google.com/bot.html) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0.0.0 Safari/537.36\";\n\nfor (const url of urls) {\n console.log(`\\n=== ${url} ===`);\n try {\n const res = await fetch(url, {\n headers: { \"User-Agent\": UA, \"Accept\": \"text/html,*/*\" },\n redirect: \"follow\",\n });\n const html = await res.text();\n console.log(`Status: ${res.status}, Length: ${html.length}`);\n\n const checks = {\n dollarPrices: [...html.matchAll(/\\$(\\d+\\.\\d{2})/g)].length,\n priceType: html.includes('data-type=\"price\"'),\n goodsName: [...html.matchAll(/\"goodsName\"\\s*:\\s*\"([^\"]+)\"/g)].length,\n salePrice: [...html.matchAll(/\"salePrice\"\\s*:\\s*\\{([^}]+)\\}/g)].length,\n metaPrice: [...html.matchAll(/]*itemprop=\"price\"[^>]*content=\"([^\"]+)\"/g)].length,\n ogTitle: [...html.matchAll(/]*property=\"og:title\"[^>]*content=\"([^\"]+)\"/g)],\n };\n console.log(\"Checks:\", JSON.stringify(checks));\n\n // Show first few prices\n const dollarMatches = [...html.matchAll(/\\$(\\d+\\.\\d{2})/g)];\n if (dollarMatches.length > 0) {\n console.log(\"Prices:\", dollarMatches.slice(0, 10).map((m) => \"$\" + m[1]));\n }\n\n // Show og:title if found\n if (checks.ogTitle.length > 0) {\n console.log(\"og:title:\", checks.ogTitle[0][1]);\n }\n\n // Show any meta price\n const metaMatches = [...html.matchAll(/]*price[^>]*/gi)];\n if (metaMatches.length > 0) {\n console.log(\"Meta price tags:\");\n for (const m of metaMatches.slice(0, 5)) {\n console.log(` ${m[0]}`);\n }\n }\n } catch (e) {\n console.log(`Error: ${e}`);\n }\n}\n",[160],"820ae76c-36fb-41b7-aa77-0a95dde91d3e","check-prices.ts","1104d7d8-7fc2-11f1-9fdf-1607ee4eb77e",16,["D",1784061154002],2,"interval","import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\nimport { scrapeProduct } from \"./scrape.ts\";\nimport { email } from \"https://esm.town/v/std/email\";\n\nexport default async function () {\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS tracked_products (\n url TEXT PRIMARY KEY,\n title TEXT,\n image TEXT,\n last_price REAL,\n last_checked TEXT,\n added_at TEXT DEFAULT (datetime('now'))\n )\n `);\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS price_history (\n url TEXT,\n price REAL,\n checked_at TEXT DEFAULT (datetime('now')),\n PRIMARY KEY (url, checked_at)\n )\n `);\n\n const products = await sqlite.execute(\"SELECT * FROM tracked_products\");\n if (products.rows.length === 0) {\n console.log(\"No tracked products\");\n return;\n }\n\n console.log(`Checking ${products.rows.length} products...`);\n const drops: any[] = [];\n\n for (const row of products.rows) {\n const url = row.url as string;\n const oldPrice = row.last_price as number | null;\n const product = await scrapeProduct(url);\n\n if (!product) {\n console.log(`Failed: ${url}`);\n continue;\n }\n\n await sqlite.execute({\n sql: \"UPDATE tracked_products SET last_price = ?, last_checked = datetime('now') WHERE url = ?\",\n args: [product.price, url],\n });\n await sqlite.execute({\n sql: \"INSERT INTO price_history (url, price, checked_at) VALUES (?, ?, datetime('now'))\",\n args: [url, product.price],\n });\n\n console.log(`${product.title}: $${product.price} (was ${oldPrice ?? \"—\"})`);\n\n if (oldPrice !== null && product.price < oldPrice) {\n drops.push({ url, title: product.title, oldPrice, newPrice: product.price, image: product.image });\n }\n }\n\n if (drops.length > 0) {\n const rows = drops.map((d) =>\n `\n ${d.image ? `

` : \"\"}\n ${d.title}\n $${d.oldPrice}\n $${d.newPrice}\n View\n `\n ).join(\"\");\n\n await email({\n subject: `📉 Temu price drop — ${drops.length} product${drops.length > 1 ? \"s\" : \"\"}`,\n html: `

📉 ירידת מחיר ב-Temu!

\n \n \n \n \n \n \n \n \n ${rows}\n

	מוצר	מחיר ישן	מחיר חדש

`,\n });\n console.log(`Email sent for ${drops.length} drops!`);\n } else {\n console.log(\"No price drops detected\");\n }\n}\n",[167],"e79e98c4-8e33-4667-b4c6-e6ba06147424","api.ts",15,["D",1784061143134],"http","import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\nimport { scrapeProduct } from \"./scrape.ts\";\n\n// Setup DB\nasync function initDB() {\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS tracked_products (\n url TEXT PRIMARY KEY,\n title TEXT,\n image TEXT,\n last_price REAL,\n last_checked TEXT,\n added_at TEXT DEFAULT (datetime('now'))\n )\n `);\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS price_history (\n url TEXT,\n price REAL,\n checked_at TEXT DEFAULT (datetime('now')),\n PRIMARY KEY (url, checked_at)\n )\n `);\n}\n\nexport default async function (req: Request): Promise {\n await initDB();\n const url = new URL(req.url);\n const path = url.pathname;\n\n // API routes\n if (path === \"/api/products\" && req.method === \"GET\") {\n return await getProducts();\n }\n if (path === \"/api/products\" && req.method === \"POST\") {\n return await addProduct(req);\n }\n if (path.startsWith(\"/api/products/\") && req.method === \"DELETE\") {\n const productUrl = decodeURIComponent(path.replace(\"/api/products/\", \"\"));\n return await deleteProduct(productUrl);\n }\n if (path === \"/api/check\" && req.method === \"POST\") {\n return await checkAllPrices();\n }\n\n // Serve the UI\n return new Response(HTML_PAGE, {\n headers: { \"Content-Type\": \"text/html; charset=utf-8\" },\n });\n}\n\nasync function getProducts(): Promise {\n const result = await sqlite.execute(\n \"SELECT * FROM tracked_products ORDER BY added_at DESC\",\n );\n return Response.json(result.rows);\n}\n\nasync function addProduct(req: Request): Promise {\n const body = await req.json();\n const productUrl: string = body.url?.trim();\n\n if (!productUrl || !productUrl.includes(\"temu.com\")) {\n return Response.json({ error: \"Invalid URL — must be a temu.com link\" }, { status: 400 });\n }\n\n // Check if already tracked\n const existing = await sqlite.execute({\n sql: \"SELECT url FROM tracked_products WHERE url = ?\",\n args: [productUrl],\n });\n if (existing.rows.length > 0) {\n return Response.json({ error: \"Already tracking this product\" }, { status: 409 });\n }\n\n // Scrape initial data\n const product = await scrapeProduct(productUrl);\n if (!product) {\n // Add anyway with unknown price — we'll try again later\n await sqlite.execute({\n sql: \"INSERT INTO tracked_products (url, title, image, last_price, last_checked) VALUES (?, ?, ?, NULL, datetime('now'))\",\n args: [productUrl, extractTitleFromUrl(productUrl), null],\n });\n return Response.json({\n ok: true,\n message: \"Added! Will try to fetch price on next check.\",\n url: productUrl,\n title: extractTitleFromUrl(productUrl),\n price: null,\n });\n }\n\n await sqlite.execute({\n sql: \"INSERT INTO tracked_products (url, title, image, last_price, last_checked) VALUES (?, ?, ?, ?, datetime('now'))\",\n args: [productUrl, product.title, product.image ?? null, product.price],\n });\n\n await sqlite.execute({\n sql: \"INSERT INTO price_history (url, price, checked_at) VALUES (?, ?, datetime('now'))\",\n args: [productUrl, product.price],\n });\n\n return Response.json({\n ok: true,\n url: productUrl,\n title: product.title,\n price: product.price,\n image: product.image,\n });\n}\n\nasync function deleteProduct(productUrl: string): Promise {\n await sqlite.execute({\n sql: \"DELETE FROM tracked_products WHERE url = ?\",\n args: [productUrl],\n });\n return Response.json({ ok: true });\n}\n\nasync function checkAllPrices(): Promise {\n const products = await sqlite.execute(\"SELECT * FROM tracked_products\");\n const results: any[] = [];\n const drops: any[] = [];\n\n for (const row of products.rows) {\n const url = row.url as string;\n const oldPrice = row.last_price as number | null;\n const product = await scrapeProduct(url);\n\n if (!product) {\n results.push({ url, status: \"failed\" });\n continue;\n }\n\n await sqlite.execute({\n sql: \"UPDATE tracked_products SET last_price = ?, last_checked = datetime('now') WHERE url = ?\",\n args: [product.price, url],\n });\n\n await sqlite.execute({\n sql: \"INSERT INTO price_history (url, price, checked_at) VALUES (?, ?, datetime('now'))\",\n args: [url, product.price],\n });\n\n if (oldPrice !== null && product.price < oldPrice) {\n drops.push({\n url,\n title: product.title,\n oldPrice,\n newPrice: product.price,\n image: product.image,\n });\n }\n\n results.push({\n url,\n title: product.title,\n oldPrice,\n newPrice: product.price,\n status: \"ok\",\n dropped: oldPrice !== null && product.price < oldPrice,\n });\n }\n\n // Send email if drops\n if (drops.length > 0) {\n const { email } = await import(\"https://esm.town/v/std/email\");\n const rows = drops.map((d) =>\n `\n ${d.image ? `

📉 ירידת מחיר ב-Temu!

\n \n \n \n \n \n \n \n \n ${rows}\n

	מוצר	מחיר ישן	מחיר חדש

`,\n });\n }\n\n return Response.json({ results, drops });\n}\n\nfunction extractTitleFromUrl(url: string): string {\n const slug = url\n .replace(/https?:\\/\\/www\\.temu\\.com\\//, \"\")\n .replace(/\\.html.*$/, \"\")\n .replace(/^goods-\\d+$/, \"Temu Product\");\n return slug\n .replace(/-/g, \" \")\n .replace(/^\\d+\\s*pc[s]?\\s*/i, \"\")\n .trim()\n .replace(/\\b\\w/g, (c) => c.toUpperCase()) || \"Temu Product\";\n}\n\nconst HTML_PAGE = `\n\n\n \n \n Temu Price Tracker\n \n\n\n

🛒 Temu Price Tracker

\n \n

\n \n\n`;\n",[176],"pulls","branches",1,"forks","envVars",{"_190":68,"_192":68},"connections",{"_190":68,"_191":68},"count","unfilledCount","emptyCount",{"_48":175,"_38":176,"_36":63,"_144":-5,"_46":47,"_45":177,"_146":31,"_43":211,"_13":68,"_39":179,"_41":180,"_30":54,"_150":-5,"_199":212,"_33":213},{"_48":166,"_38":167,"_36":168,"_144":-5,"_46":47,"_45":169,"_146":31,"_43":208,"_13":171,"_39":172,"_41":173,"_30":54,"_150":-5,"_199":209,"_33":210},{"_48":159,"_38":160,"_36":161,"_144":-5,"_46":47,"_45":162,"_146":54,"_43":205,"_13":68,"_39":40,"_41":164,"_30":54,"_150":-5,"_199":206,"_33":207},{"_48":152,"_38":153,"_36":154,"_144":-5,"_46":47,"_45":155,"_146":31,"_43":202,"_13":68,"_39":40,"_41":157,"_30":54,"_150":-5,"_199":203,"_33":204},{"_48":141,"_38":142,"_36":143,"_144":-5,"_46":47,"_45":145,"_146":31,"_43":198,"_13":148,"_39":40,"_41":149,"_30":54,"_150":-5,"_199":200,"_33":201},["D",1784061113356],"children",[],[142],["D",1784060799639],[],[153],["D",1784061093611],[],[160],["D",1784061154002],[],[167],["D",1784061143134],[],[176],["D",1784060691062],["D",1789473046147],{"_105":104,"_113":109},{"_105":104,"_106":107,"_108":109,"_19":61,"_110":111,"_112":54},{"_13":94,"_38":95,"_48":47,"_96":49,"_97":-5,"_98":-5,"_99":-5,"_100":-5,"_101":-5,"_102":50,"_103":104},"ctx",{"_87":-5,"_133":252,"_253":254,"_255":256,"_257":54,"_258":54,"_259":54,"_260":31,"_261":-5,"_262":-7,"_263":-7,"_264":68,"_265":54,"_266":54,"_267":-5,"_268":54,"_269":54,"_270":54,"_271":-5},"ENV",{"_223":224,"_225":226,"_227":95,"_228":229,"_230":231,"_232":233,"_234":235,"_236":237,"_238":239,"_240":241,"_242":243,"_244":245,"_246":247,"_248":249,"_250":251},"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"]

Diff · v21