[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_163":164,"_165":166},"routes/_app.x.$handle.$name",{"_105":104,"_39":52,"_113":95,"_34":107,"_13":14,"_114":-5,"_11":115,"_116":117,"_118":119,"_120":121,"_122":123,"_26":-5,"_124":-5,"_125":-5,"_126":33,"_127":128,"_129":31,"_130":-5,"_131":-5,"_132":133},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":18,"_19":-5},"project",{"_50":51,"_39":52,"_45":53,"_54":-5,"_55":33,"_56":57,"_58":57,"_59":60,"_61":-5,"_19":62,"_63":-5,"_64":33,"_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":33},"version",5,"changes",[25],"aiChatInfo",{"_20":21,"_22":-5,"_23":-5,"_24":-5},"userId","aiChatMessageId","3b38433d-c4c9-4b1f-99e2-859b39d212da","aiChatThreadId","aiChatThreadUserId","aiChatThreadTitle",{"_26":27,"_28":29,"_30":31,"_32":33,"_34":35,"_36":35},"file",{"_37":38,"_39":35,"_40":41,"_42":44,"_45":46,"_47":14,"_48":49,"_30":33},"previous",{"_37":38,"_39":35,"_40":41,"_42":43},"deleted",true,"deletedHere",false,"path","main.ts","latestPath","fileId","43e87abe-52b9-11f1-9d55-ee650bb23af1","name","fileType","http","content","import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\nimport { email } from \"https://esm.town/v/std/email\";\nimport { parseVal } from \"https://esm.town/v/std/utils/index.ts\";\n\n// Initialize DB\nawait sqlite.execute(`CREATE TABLE IF NOT EXISTS products (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n name TEXT NOT NULL,\n url TEXT NOT NULL,\n keyword TEXT DEFAULT 'in stock',\n last_status TEXT DEFAULT 'unknown',\n created_at TEXT DEFAULT (datetime('now'))\n)`);\n\nawait sqlite.execute(`CREATE TABLE IF NOT EXISTS checks (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n product_id INTEGER,\n status TEXT,\n checked_at TEXT DEFAULT (datetime('now'))\n)`);\n\nexport default async function(req: Request): Promise {\n const url = new URL(req.url);\n\n // API: Add product\n if (req.method === \"POST\" && url.pathname === \"/add\") {\n const body = await req.json();\n await sqlite.execute({\n sql: \"INSERT INTO products (name, url, keyword) VALUES (?, ?, ?)\",\n args: [body.name, body.url, body.keyword || \"in stock\"],\n });\n return Response.json({ ok: true });\n }\n\n // API: Delete product\n if (req.method === \"POST\" && url.pathname === \"/delete\") {\n const body = await req.json();\n await sqlite.execute({ sql: \"DELETE FROM products WHERE id = ?\", args: [body.id] });\n await sqlite.execute({ sql: \"DELETE FROM checks WHERE product_id = ?\", args: [body.id] });\n return Response.json({ ok: true });\n }\n\n // API: Check stock now\n if (req.method === \"POST\" && url.pathname === \"/check\") {\n const products = await sqlite.execute(\"SELECT * FROM products\");\n const results = [];\n\n for (const product of products.rows) {\n try {\n const resp = await fetch(product.url as string, {\n headers: { \"User-Agent\": \"Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0.0.0 Safari/537.36\" },\n });\n const html = await resp.text();\n const status = checkStockStatus(html);\n const prevStatus = product.last_status as string;\n\n await sqlite.execute({\n sql: \"UPDATE products SET last_status = ? WHERE id = ?\",\n args: [status, product.id],\n });\n await sqlite.execute({\n sql: \"INSERT INTO checks (product_id, status) VALUES (?, ?)\",\n args: [product.id, status],\n });\n\n // Alert if status changed to in stock\n if (status === \"✅ In Stock\" && prevStatus !== \"✅ In Stock\") {\n await email.send({\n subject: `🔔 Stock Alert: ${product.name} is now available!`,\n text: `Good news! \"${product.name}\" appears to be in stock.\\n\\nCheck it out: ${product.url}`,\n });\n }\n\n results.push({ name: product.name, status });\n } catch (e) {\n results.push({ name: product.name, status: \"⚠️ Error checking\" });\n }\n }\n\n return Response.json({ results });\n }\n\n // API: Get products\n if (url.pathname === \"/products\") {\n const products = await sqlite.execute(\"SELECT * FROM products ORDER BY created_at DESC\");\n return Response.json(products.rows);\n }\n\n // Source link\n if (url.pathname === \"/source\") {\n return new Response(null, { status: 302, headers: { Location: parseVal().links.self.val } });\n }\n\n // Serve the dashboard\n return new Response(dashboardHTML(url.origin), {\n headers: { \"Content-Type\": \"text/html\" },\n });\n}\n\n// Smart stock detection — checks for out-of-stock indicators first\n// This avoids false positives from \"notify me when in stock\" text\nfunction checkStockStatus(html: string): string {\n const text = html.toLowerCase();\n\n // Out-of-stock indicators (checked FIRST — these are highly reliable)\n const outOfStockPatterns = [\n \"out of stock\",\n \"out_of_stock\",\n \"outofstock\",\n \"sold out\",\n \"soldout\",\n \"currently unavailable\",\n \"currently not available\",\n \"not available\",\n \"unavailable\",\n \"coming soon\",\n \"pre-order\",\n \"preorder\",\n \"notify me when\",\n \"notify when available\",\n \"back in stock\",\n \"register for availability\",\n \"stock alert\",\n \"waitlist\",\n \"wait list\",\n '\"availability\":\"OutOfStock\"', // JSON-LD schema\n '\"availability\":\"https://schema.org/OutOfStock\"',\n '\"availability\": \"OutOfStock\"',\n '\"availability\": \"https://schema.org/OutOfStock\"',\n ];\n\n // In-stock indicators\n const inStockPatterns = [\n \"add to cart\",\n \"add to bag\",\n \"buy now\",\n \"add to basket\",\n '\"availability\":\"InStock\"',\n '\"availability\":\"https://schema.org/InStock\"',\n '\"availability\": \"InStock\"',\n '\"availability\": \"https://schema.org/InStock\"',\n ];\n\n const oosScore = outOfStockPatterns.filter(p => text.includes(p)).length;\n const isScore = inStockPatterns.filter(p => text.includes(p)).length;\n\n // If we found out-of-stock indicators, it's OOS\n // Even if \"add to cart\" exists (could be for related products),\n // explicit OOS text takes priority\n if (oosScore > 0 && oosScore >= isScore) {\n return \"❌ Out of Stock\";\n }\n\n // If we found in-stock indicators and NO oos indicators\n if (isScore > 0 && oosScore === 0) {\n return \"✅ In Stock\";\n }\n\n // Ambiguous — both or neither found\n if (isScore > 0 && oosScore > 0) {\n return \"❌ Out of Stock\"; // err on the side of OOS to avoid false alerts\n }\n\n return \"⚠️ Unknown (couldn't detect)\";\n}\n\nfunction dashboardHTML(origin: string) {\n return `\n\n\n \n \n 📦 Stock Alert Monitor\n \n\n\n

📦 Stock Alert

\n view source\n

\n\n

➕ Add Product to Monitor

\n \n

\n\n

\n \n

\n\n \n\n

\n 💡 Tip: Add a cron job to auto-check periodically. You'll get an email when stock status changes!\n

\n\n \n\n`;\n}\n","import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\nimport { email } from \"https://esm.town/v/std/email\";\nimport { parseVal } from \"https://esm.town/v/std/utils/index.ts\";\n\n// Initialize DB\nawait sqlite.execute(`CREATE TABLE IF NOT EXISTS products (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n name TEXT NOT NULL,\n url TEXT NOT NULL,\n keyword TEXT DEFAULT 'in stock',\n last_status TEXT DEFAULT 'unknown',\n created_at TEXT DEFAULT (datetime('now'))\n)`);\n\nawait sqlite.execute(`CREATE TABLE IF NOT EXISTS checks (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n product_id INTEGER,\n status TEXT,\n checked_at TEXT DEFAULT (datetime('now'))\n)`);\n\nexport default async function(req: Request): Promise {\n const url = new URL(req.url);\n\n // API: Add product\n if (req.method === \"POST\" && url.pathname === \"/add\") {\n const body = await req.json();\n await sqlite.execute({\n sql: \"INSERT INTO products (name, url, keyword) VALUES (?, ?, ?)\",\n args: [body.name, body.url, body.keyword || \"in stock\"],\n });\n return Response.json({ ok: true });\n }\n\n // API: Delete product\n if (req.method === \"POST\" && url.pathname === \"/delete\") {\n const body = await req.json();\n await sqlite.execute({ sql: \"DELETE FROM products WHERE id = ?\", args: [body.id] });\n await sqlite.execute({ sql: \"DELETE FROM checks WHERE product_id = ?\", args: [body.id] });\n return Response.json({ ok: true });\n }\n\n // API: Check stock now\n if (req.method === \"POST\" && url.pathname === \"/check\") {\n const products = await sqlite.execute(\"SELECT * FROM products\");\n const results = [];\n\n for (const product of products.rows) {\n try {\n const resp = await fetch(product.url as string, {\n headers: { \"User-Agent\": \"Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0.0.0 Safari/537.36\" },\n });\n const html = await resp.text();\n const status = checkStockStatus(html);\n const prevStatus = product.last_status as string;\n\n await sqlite.execute({\n sql: \"UPDATE products SET last_status = ? WHERE id = ?\",\n args: [status, product.id],\n });\n await sqlite.execute({\n sql: \"INSERT INTO checks (product_id, status) VALUES (?, ?)\",\n args: [product.id, status],\n });\n\n // Alert if status changed to in stock\n if (status === \"✅ In Stock\" && prevStatus !== \"✅ In Stock\") {\n await email.send({\n subject: `🔔 Stock Alert: ${product.name} is now available!`,\n text: `Good news! \"${product.name}\" appears to be in stock.\\n\\nCheck it out: ${product.url}`,\n });\n }\n\n results.push({ name: product.name, status });\n } catch (e) {\n results.push({ name: product.name, status: \"⚠️ Error checking\" });\n }\n }\n\n return Response.json({ results });\n }\n\n // API: Get products\n if (url.pathname === \"/products\") {\n const products = await sqlite.execute(\"SELECT * FROM products ORDER BY created_at DESC\");\n return Response.json(products.rows);\n }\n\n // Source link\n if (url.pathname === \"/source\") {\n return new Response(null, { status: 302, headers: { Location: parseVal().links.self.val } });\n }\n\n // Serve the dashboard\n return new Response(dashboardHTML(url.origin), {\n headers: { \"Content-Type\": \"text/html\" },\n });\n}\n\n// Smart stock detection — checks for out-of-stock indicators first\n// This avoids false positives from \"notify me when in stock\" text\nfunction checkStockStatus(html: string): string {\n const text = html.toLowerCase();\n\n // Out-of-stock indicators (checked FIRST — these are highly reliable)\n const outOfStockPatterns = [\n \"out of stock\",\n \"out_of_stock\",\n \"outofstock\",\n \"sold out\",\n \"soldout\",\n \"currently unavailable\",\n \"currently not available\",\n \"not available\",\n \"unavailable\",\n \"coming soon\",\n \"pre-order\",\n \"preorder\",\n \"notify me when\",\n \"notify when available\",\n \"back in stock\",\n \"register for availability\",\n \"stock alert\",\n \"waitlist\",\n \"wait list\",\n '\"availability\":\"OutOfStock\"', // JSON-LD schema\n '\"availability\":\"https://schema.org/OutOfStock\"',\n '\"availability\": \"OutOfStock\"',\n '\"availability\": \"https://schema.org/OutOfStock\"',\n ];\n\n // In-stock indicators\n const inStockPatterns = [\n \"add to cart\",\n \"add to bag\",\n \"buy now\",\n \"add to basket\",\n '\"availability\":\"InStock\"',\n '\"availability\":\"https://schema.org/InStock\"',\n '\"availability\": \"InStock\"',\n '\"availability\": \"https://schema.org/InStock\"',\n ];\n\n const oosScore = outOfStockPatterns.filter(p => text.includes(p)).length;\n const isScore = inStockPatterns.filter(p => text.includes(p)).length;\n\n // If we found out-of-stock indicators, it's OOS\n // Even if \"add to cart\" exists (could be for related products),\n // explicit OOS text takes priority\n if (oosScore > 0 && oosScore >= isScore) {\n return \"❌ Out of Stock\";\n }\n\n // If we found in-stock indicators and NO oos indicators\n if (isScore > 0 && oosScore === 0) {\n return \"✅ In Stock\";\n }\n\n // Ambiguous — both or neither found\n if (isScore > 0 && oosScore > 0) {\n return \"❌ Out of Stock\"; // err on the side of OOS to avoid false alerts\n }\n\n return \"⚠️ Unknown (couldn't detect)\";\n}\n\nfunction dashboardHTML(origin: string) {\n return `\n\n\n \n \n 📦 Stock Alert Monitor\n \n\n\n

📦 Stock Alert

\n view source\n

\n\n

➕ Add Product to Monitor

\n \n

\n\n

\n \n

\n\n \n\n

\n 💡 Tip: Add a cron job to auto-check periodically. You'll get an email when stock status changes!\n

\n\n \n\n`;\n}\n","createdAt",["D",1779109816925],"branchVersion","branchId","2f3d123c-52b9-11f1-b179-ee650bb23af1","id","2f3c2106-52b9-11f1-b179-ee650bb23af1","stock-alert",["D",1779109074008],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","Monitor products and get stock notifications","imageUrl","2f059f47-b27c-4f35-9561-3246b409be30","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount",0,"orgId","019e3b29-1fce-706b-b56b-075ca80ea7e8","tursoName","2f3c210652b911f1b179ee650bb23af1","tursoHostname","2f3c210652b911f1b179ee650bb23af1-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789491713377],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_105":104,"_112":107},"org",{"_105":104,"_106":107,"_108":107,"_19":62,"_109":110,"_111":33},"branch",{"_13":94,"_39":95,"_50":49,"_96":51,"_97":-5,"_98":-5,"_99":-5,"_100":-5,"_101":-5,"_102":52,"_103":104},"isOwned",9,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","ugaachkadhle","handle","displayName","","avatar","tier","free","canRestrictVals","profileImageUrl","branchName","adoptOrgId",{"_50":51,"_39":52,"_45":158,"_54":-5,"_55":33,"_56":57,"_58":57,"_59":60,"_61":-5,"_19":62,"_63":-5,"_64":33,"_65":-5,"_66":-5,"_67":68,"_69":70,"_71":72,"_73":74,"_75":159,"_77":-5,"_78":79,"_80":79,"_81":82,"_83":82,"_84":82,"_85":79,"_86":79,"_87":160,"_89":161,"_91":162,"_93":33},"tree",[153],"files",[153],"counts",{"_142":68,"_143":144,"_145":68,"_146":147,"_148":149},"contents",[134],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_50":135,"_39":35,"_37":38,"_136":-5,"_48":49,"_47":14,"_137":33,"_45":138,"_13":139,"_40":41,"_42":44,"_30":33,"_140":-5,"_34":141},"ea105410-52ba-11f1-a1c0-ee650bb23af1","parentId","latest",["D",1779109816925],4,"label",[35],"pulls","branches",1,"forks","envVars",{"_150":68,"_152":68},"connections",{"_150":68,"_151":68},"count","unfilledCount","emptyCount",{"_50":135,"_39":35,"_37":38,"_136":-5,"_48":49,"_47":14,"_137":33,"_45":154,"_13":139,"_40":41,"_42":44,"_30":33,"_140":-5,"_155":156,"_34":157},["D",1779109816925],"children",[],[35],["D",1779109074008],["D",1789491713377],{"_105":104,"_112":107},{"_105":104,"_106":107,"_108":107,"_19":62,"_109":110,"_111":33},{"_13":94,"_39":95,"_50":49,"_96":51,"_97":-5,"_98":-5,"_99":-5,"_100":-5,"_101":-5,"_102":52,"_103":104},"ctx",{"_87":-5,"_131":196,"_197":198,"_199":200,"_201":33,"_202":33,"_203":33,"_204":31,"_205":-5,"_206":-7,"_207":-7,"_208":68,"_209":33,"_210":33,"_211":-5,"_212":33,"_213":33,"_214":33,"_215":-5},"ENV",{"_167":168,"_169":170,"_171":95,"_172":173,"_174":175,"_176":177,"_178":179,"_180":181,"_182":183,"_184":185,"_186":187,"_188":189,"_190":191,"_192":193,"_194":195},"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 · v5