<!\\[CDATA\\[([^\\]]+)\\]\\]><\\/title>/) ||\n item.match(/<title>([^<]+)<\\/title>/);\n const linkMatch = item.match(/<link>([^<]+)<\\/link>/);\n const sourceMatch = item.match(/<source[^>]*><!\\[CDATA\\[([^\\]]+)\\]\\]><\\/source>/) ||\n item.match(/<source[^>]*>([^<]+)<\\/source>/);\n const pubDateMatch = item.match(/<pubDate>([^<]+)<\\/pubDate>/);\n\n if (titleMatch && linkMatch) {\n const pubDate = pubDateMatch\n ? Math.floor(new Date(pubDateMatch[1]).getTime() / 1000)\n : Math.floor(Date.now() / 1000);\n articles.push({\n title: titleMatch[1].trim(),\n url: linkMatch[1].trim(),\n source: sourceMatch ? sourceMatch[1].trim() : \"Unknown\",\n pubDate,\n });\n }\n }\n\n let collected = 0;\n const today = new Date().toISOString().split(\"T\")[0];\n let posCount = 0, neuCount = 0, negCount = 0;\n\n for (const article of articles.slice(0, 20)) {\n let sentiment = \"neutral\";\n let score = 0.0;\n try {\n const aiResp = await fetch(\n \"https://api.val.town/v1/openai/chat/completions\",\n {\n method: \"POST\",\n headers: {\n \"Authorization\": `Bearer ${Deno.env.get(\"VALTOWN_API_KEY\")}`,\n \"Content-Type\": \"application/json\",\n },\n body: JSON.stringify({\n model: \"gpt-4o-mini\",\n messages: [\n {\n role: \"system\",\n content:\n 'Classify the sentiment of this news headline as exactly one word: positive, neutral, or negative. Then give a score from -1.0 to 1.0. Respond as JSON: {\"sentiment\": \"...\", \"score\": 0.0}',\n },\n { role: \"user\", content: article.title },\n ],\n max_tokens: 50,\n }),\n },\n );\n if (aiResp.ok) {\n const aiData = await aiResp.json();\n const content = aiData.choices?.[0]?.message?.content || \"{}\";\n const parsed = JSON.parse(content);\n sentiment = parsed.sentiment || \"neutral\";\n score = parsed.score || 0.0;\n }\n } catch (_e) {\n // Keep defaults\n }\n\n try {\n await sqlite.execute(\n `INSERT OR IGNORE INTO articles (brand_id, title, url, source_name, published_at, sentiment, sentiment_score) VALUES (?, ?, ?, ?, ?, ?, ?)`,\n [\n brandId,\n article.title,\n article.url,\n article.source,\n article.pubDate,\n sentiment,\n score,\n ],\n );\n collected++;\n if (sentiment === \"positive\") posCount++;\n else if (sentiment === \"negative\") negCount++;\n else neuCount++;\n } catch (_e) {\n // Duplicate URL, skip\n }\n }\n\n // Update daily metrics\n await sqlite.execute(\n `INSERT INTO daily_metrics (brand_id, date, article_count, positive_count, neutral_count, negative_count)\n VALUES (?, ?, ?, ?, ?, ?)\n ON CONFLICT(brand_id, date) DO UPDATE SET\n article_count = article_count + excluded.article_count,\n positive_count = positive_count + excluded.positive_count,\n neutral_count = neutral_count + excluded.neutral_count,\n negative_count = negative_count + excluded.negative_count`,\n [brandId, today, collected, posCount, neuCount, negCount],\n );\n\n return collected;\n}\n\nexport default async function handler(req: Request): Promise<Response> {\n const url = new URL(req.url);\n const path = url.pathname;\n\n if (req.method === \"OPTIONS\") {\n return new Response(null, { headers: corsHeaders });\n }\n\n // GET /api/brands\n if (req.method === \"GET\" && path === \"/api/brands\") {\n const rows = await sqlite.execute(\n `SELECT b.id, b.name, b.created_at, COUNT(a.id) as article_count\n FROM brands b LEFT JOIN articles a ON b.id = a.brand_id\n GROUP BY b.id ORDER BY b.name`,\n );\n const brands = rows.rows.map((r) => ({\n id: r[0],\n name: r[1],\n created_at: r[2],\n article_count: r[3],\n }));\n return jsonResponse(brands);\n }\n\n // POST /api/brands\n if (req.method === \"POST\" && path === \"/api/brands\") {\n const body = await req.json();\n if (!body.name) return jsonResponse({ error: \"name required\" }, 400);\n try {\n const result = await sqlite.execute(\n `INSERT INTO brands (name) VALUES (?) RETURNING id, name`,\n [body.name],\n );\n return jsonResponse({ id: result.rows[0][0], name: result.rows[0][1] }, 201);\n } catch (_e) {\n return jsonResponse({ error: \"Brand already exists\" }, 409);\n }\n }\n\n // DELETE /api/brands/:id\n const brandDeleteMatch = path.match(/^\\/api\\/brands\\/(\\d+)$/);\n if (req.method === \"DELETE\" && brandDeleteMatch) {\n const id = parseInt(brandDeleteMatch[1]);\n await sqlite.execute(`DELETE FROM articles WHERE brand_id = ?`, [id]);\n await sqlite.execute(`DELETE FROM daily_metrics WHERE brand_id = ?`, [id]);\n await sqlite.execute(`DELETE FROM brands WHERE id = ?`, [id]);\n return jsonResponse({ deleted: true });\n }\n\n // GET /api/articles?brand_id=1&days=7\n if (req.method === \"GET\" && path === \"/api/articles\") {\n const brandId = url.searchParams.get(\"brand_id\");\n const days = parseInt(url.searchParams.get(\"days\") || \"7\");\n if (!brandId) return jsonResponse({ error: \"brand_id required\" }, 400);\n const cutoff = Math.floor(Date.now() / 1000) - days * 86400;\n const rows = await sqlite.execute(\n `SELECT id, title, url, source_name, published_at, sentiment, sentiment_score, collected_at\n FROM articles WHERE brand_id = ? AND collected_at >= ? ORDER BY collected_at DESC LIMIT 100`,\n [parseInt(brandId), cutoff],\n );\n const articles = rows.rows.map((r) => ({\n id: r[0], title: r[1], url: r[2], source_name: r[3],\n published_at: r[4], sentiment: r[5], sentiment_score: r[6], collected_at: r[7],\n }));\n return jsonResponse(articles);\n }\n\n // GET /api/report?brand_id=1&period=week\n if (req.method === \"GET\" && path === \"/api/report\") {\n const brandId = url.searchParams.get(\"brand_id\");\n if (!brandId) return jsonResponse({ error: \"brand_id required\" }, 400);\n const period = url.searchParams.get(\"period\") || \"week\";\n const days = period === \"month\" ? 30 : period === \"day\" ? 1 : 7;\n const cutoff = Math.floor(Date.now() / 1000) - days * 86400;\n\n const brandRows = await sqlite.execute(\n `SELECT id, name FROM brands WHERE id = ?`,\n [parseInt(brandId)],\n );\n if (!brandRows.rows.length) return jsonResponse({ error: \"Brand not found\" }, 404);\n const brand = { id: brandRows.rows[0][0], name: brandRows.rows[0][1] };\n\n const articleRows = await sqlite.execute(\n `SELECT id, title, url, source_name, sentiment, sentiment_score, collected_at\n FROM articles WHERE brand_id = ? AND collected_at >= ? ORDER BY collected_at DESC`,\n [parseInt(brandId), cutoff],\n );\n const articles = articleRows.rows.map((r) => ({\n id: r[0], title: r[1], url: r[2], source_name: r[3],\n sentiment: r[4], sentiment_score: r[5], collected_at: r[6],\n }));\n\n const sentimentBreakdown = { positive: 0, neutral: 0, negative: 0 };\n const sourceMap: Record<string, number> = {};\n for (const a of articles) {\n const s = a.sentiment as string;\n if (s in sentimentBreakdown) sentimentBreakdown[s as keyof typeof sentimentBreakdown]++;\n const src = (a.source_name as string) || \"Unknown\";\n sourceMap[src] = (sourceMap[src] || 0) + 1;\n }\n const topSources = Object.entries(sourceMap)\n .sort((a, b) => b[1] - a[1])\n .slice(0, 10)\n .map(([name, count]) => ({ name, count }));\n\n return jsonResponse({\n brand,\n period,\n total_articles: articles.length,\n sentiment_breakdown: sentimentBreakdown,\n top_sources: topSources,\n recent_articles: articles.slice(0, 20),\n });\n }\n\n // POST /api/collect\n if (req.method === \"POST\" && path === \"/api/collect\") {\n const body = await req.json();\n if (!body.brand_id) return jsonResponse({ error: \"brand_id required\" }, 400);\n const collected = await collectArticles(body.brand_id);\n return jsonResponse({ collected });\n }\n\n return jsonResponse({ error: \"Not found\", path }, 404);\n}",["D",1783289363906],"id","02b93d4c-8e45-4618-935a-44aaa786ed62","prMonitorApi",["D",1783289313194],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","PR monitoring API backend","imageUrl","019cdef0-5cd0-7261-bddf-67d3a4efcd7a","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount",0,"orgId","019cdef0-5cd0-7261-bddf-6971337b2068","tursoName","tursoHostname","tursoMeasuredAt","pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_100":99,"_107":103},"org",{"_100":99,"_101":-5,"_102":103,"_18":60,"_104":105,"_106":25},"branch",{"_13":89,"_32":90,"_48":40,"_91":49,"_92":-5,"_93":-5,"_94":-5,"_95":-5,"_96":-5,"_97":50,"_98":99},"isOwned",26,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","lobsterman","handle","displayName","avatar","https://img.clerk.com/eyJ0eXBlIjoiZGVmYXVsdCIsImlpZCI6Imluc18yTm10cGhQUklwU0tqZHNiOHNnNGd2ZjJURFUiLCJyaWQiOiJ1c2VyXzNBb2xGb1hUcU8ydWYzR0FNVzhFRDBaQk5SWCJ9","tier","free","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_48":49,"_32":50,"_36":159,"_52":-5,"_53":25,"_54":55,"_56":55,"_57":58,"_59":-5,"_18":60,"_61":-5,"_62":25,"_63":-5,"_64":-5,"_65":66,"_67":68,"_69":-5,"_70":-5,"_71":-5,"_72":-5,"_73":74,"_75":74,"_76":77,"_78":77,"_79":77,"_80":74,"_81":74,"_82":160,"_84":161,"_86":162,"_88":25},"tree",[149],"files",[149,150],"counts",{"_138":66,"_139":14,"_140":66,"_141":142,"_143":144},"contents",[131],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles",true,"grants","orgs","customDomains",{},{"_48":132,"_32":28,"_30":31,"_133":-5,"_39":40,"_38":14,"_134":126,"_36":135,"_13":66,"_33":34,"_35":-5,"_24":25,"_136":-5,"_27":137},"4a6c5e85-b952-46dd-aaa1-9a41fcfb2f6e","parentId","latest",["D",1783289363906],"label",[28],"pulls","branches","forks","envVars",{"_145":147,"_148":66},"connections",{"_145":66,"_146":66},"count","unfilledCount",3,"emptyCount",{"_48":132,"_32":28,"_30":31,"_133":-5,"_39":40,"_38":14,"_134":126,"_36":156,"_13":66,"_33":34,"_35":-5,"_24":25,"_136":-5,"_153":157,"_27":158},{"_48":151,"_32":44,"_30":43,"_133":31,"_39":40,"_38":14,"_134":25,"_36":152,"_13":66,"_33":45,"_35":46,"_24":25,"_136":-5,"_153":154,"_27":155},"9289b57f-28b4-4b77-b299-8e34f0d6be20",["D",1783289363906],"children",[],[28,44],["D",1783289363906],[150],[28],["D",1783289313194],{"_100":99,"_107":103},{"_100":99,"_101":-5,"_102":103,"_18":60,"_104":105,"_106":25},{"_13":89,"_32":90,"_48":40,"_91":49,"_92":-5,"_93":-5,"_94":-5,"_95":-5,"_96":-5,"_97":50,"_98":99},"ctx",{"_82":-5,"_128":196,"_197":198,"_199":200,"_201":25,"_202":25,"_203":25,"_204":126,"_205":-5,"_206":-7,"_207":-7,"_208":66,"_209":25,"_210":25,"_211":-5,"_212":25,"_213":25,"_214":25,"_215":-5},"ENV",{"_167":168,"_169":170,"_171":90,"_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"] </article></body></html>

[{"_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",{"_100":99,"_32":50,"_108":90,"_27":109,"_13":14,"_110":-5,"_11":111,"_112":113,"_114":115,"_116":117,"_118":119,"_21":-5,"_120":-5,"_121":-5,"_122":25,"_123":124,"_125":126,"_127":-5,"_128":-5,"_129":130},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_48":49,"_32":50,"_36":51,"_52":-5,"_53":25,"_54":55,"_56":55,"_57":58,"_59":-5,"_18":60,"_61":-5,"_62":25,"_63":-5,"_64":-5,"_65":66,"_67":68,"_69":-5,"_70":-5,"_71":-5,"_72":-5,"_73":74,"_75":74,"_76":77,"_78":77,"_79":77,"_80":74,"_81":74,"_82":83,"_84":85,"_86":87,"_88":25},"version",1,"changes",[19,20],"aiChatInfo","userId",{"_21":41,"_23":-7,"_24":25,"_26":25,"_27":42,"_29":42},{"_21":22,"_23":-7,"_24":25,"_26":25,"_27":28,"_29":28},"file",{"_30":31,"_32":28,"_33":34,"_35":-5,"_36":37,"_38":14,"_39":40,"_24":25},"previous","deleted",false,"deletedHere","path","backend","latestPath","fileId","e767cc15-b91e-430a-9ff5-bbe470e7e661","name","fileType","directory","content","createdAt",["D",1783289363906],"branchVersion","branchId","41a11757-2dbb-47d5-a624-ca5832847750",{"_30":43,"_32":44,"_33":45,"_35":46,"_36":47,"_38":14,"_39":40,"_24":25},"backend/main.tsx","2e305658-78be-11f1-9027-1607ee4eb77e","main.tsx","http","import { sqlite } from \"https://esm.town/v/std/sqlite\";\n\n// Initialize tables\nawait sqlite.execute(`CREATE TABLE IF NOT EXISTS brands (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n name TEXT NOT NULL UNIQUE,\n keywords TEXT DEFAULT '[]',\n created_at INTEGER DEFAULT (unixepoch())\n)`);\nawait sqlite.execute(`CREATE TABLE IF NOT EXISTS articles (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n brand_id INTEGER NOT NULL,\n title TEXT NOT NULL,\n url TEXT UNIQUE NOT NULL,\n source_name TEXT,\n published_at INTEGER,\n sentiment TEXT,\n sentiment_score REAL DEFAULT 0,\n collected_at INTEGER DEFAULT (unixepoch())\n)`);\nawait sqlite.execute(`CREATE TABLE IF NOT EXISTS daily_metrics (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n brand_id INTEGER NOT NULL,\n date TEXT NOT NULL,\n article_count INTEGER DEFAULT 0,\n positive_count INTEGER DEFAULT 0,\n neutral_count INTEGER DEFAULT 0,\n negative_count INTEGER DEFAULT 0,\n UNIQUE(brand_id, date)\n)`);\n\nconst corsHeaders = {\n \"Access-Control-Allow-Origin\": \"*\",\n \"Access-Control-Allow-Methods\": \"GET, POST, DELETE, OPTIONS\",\n \"Access-Control-Allow-Headers\": \"Content-Type\",\n};\n\nfunction jsonResponse(data: unknown, status = 200) {\n return new Response(JSON.stringify(data), {\n status,\n headers: { ...corsHeaders, \"Content-Type\": \"application/json\" },\n });\n}\n\nasync function collectArticles(brandId: number): Promise {\n const brandRows = await sqlite.execute(\n `SELECT name FROM brands WHERE id = ?`,\n [brandId],\n );\n if (!brandRows.rows.length) return 0;\n const brandName = brandRows.rows[0][0] as string;\n\n const rssUrl =\n `https://news.google.com/rss/search?q=${encodeURIComponent(brandName)}&hl=en-US&gl=US&ceid=US:en`;\n const rssResp = await fetch(rssUrl, {\n headers: { \"User-Agent\": \"Mozilla/5.0 (compatible; PRMonitor/1.0)\" },\n });\n if (!rssResp.ok) return 0;\n const xml = await rssResp.text();\n\n // Parse items from RSS using regex\n const itemRegex = /([\\s\\S]*?)<\\/item>/g;\n const articles: Array<{\n title: string;\n url: string;\n source: string;\n pubDate: number;\n }> = [];\n\n let itemMatch;\n while ((itemMatch = itemRegex.exec(xml)) !== null) {\n const item = itemMatch[1];\n const titleMatch = item.match(/<!\\[CDATA\\[([^\\]]+)\\]\\]><\\/title>/) ||\n item.match(/<title>([^<]+)<\\/title>/);\n const linkMatch = item.match(/<link>([^<]+)<\\/link>/);\n const sourceMatch = item.match(/<source[^>]*><!\\[CDATA\\[([^\\]]+)\\]\\]><\\/source>/) ||\n item.match(/<source[^>]*>([^<]+)<\\/source>/);\n const pubDateMatch = item.match(/<pubDate>([^<]+)<\\/pubDate>/);\n\n if (titleMatch && linkMatch) {\n const pubDate = pubDateMatch\n ? Math.floor(new Date(pubDateMatch[1]).getTime() / 1000)\n : Math.floor(Date.now() / 1000);\n articles.push({\n title: titleMatch[1].trim(),\n url: linkMatch[1].trim(),\n source: sourceMatch ? sourceMatch[1].trim() : \"Unknown\",\n pubDate,\n });\n }\n }\n\n let collected = 0;\n const today = new Date().toISOString().split(\"T\")[0];\n let posCount = 0, neuCount = 0, negCount = 0;\n\n for (const article of articles.slice(0, 20)) {\n let sentiment = \"neutral\";\n let score = 0.0;\n try {\n const aiResp = await fetch(\n \"https://api.val.town/v1/openai/chat/completions\",\n {\n method: \"POST\",\n headers: {\n \"Authorization\": `Bearer ${Deno.env.get(\"VALTOWN_API_KEY\")}`,\n \"Content-Type\": \"application/json\",\n },\n body: JSON.stringify({\n model: \"gpt-4o-mini\",\n messages: [\n {\n role: \"system\",\n content:\n 'Classify the sentiment of this news headline as exactly one word: positive, neutral, or negative. Then give a score from -1.0 to 1.0. Respond as JSON: {\"sentiment\": \"...\", \"score\": 0.0}',\n },\n { role: \"user\", content: article.title },\n ],\n max_tokens: 50,\n }),\n },\n );\n if (aiResp.ok) {\n const aiData = await aiResp.json();\n const content = aiData.choices?.[0]?.message?.content || \"{}\";\n const parsed = JSON.parse(content);\n sentiment = parsed.sentiment || \"neutral\";\n score = parsed.score || 0.0;\n }\n } catch (_e) {\n // Keep defaults\n }\n\n try {\n await sqlite.execute(\n `INSERT OR IGNORE INTO articles (brand_id, title, url, source_name, published_at, sentiment, sentiment_score) VALUES (?, ?, ?, ?, ?, ?, ?)`,\n [\n brandId,\n article.title,\n article.url,\n article.source,\n article.pubDate,\n sentiment,\n score,\n ],\n );\n collected++;\n if (sentiment === \"positive\") posCount++;\n else if (sentiment === \"negative\") negCount++;\n else neuCount++;\n } catch (_e) {\n // Duplicate URL, skip\n }\n }\n\n // Update daily metrics\n await sqlite.execute(\n `INSERT INTO daily_metrics (brand_id, date, article_count, positive_count, neutral_count, negative_count)\n VALUES (?, ?, ?, ?, ?, ?)\n ON CONFLICT(brand_id, date) DO UPDATE SET\n article_count = article_count + excluded.article_count,\n positive_count = positive_count + excluded.positive_count,\n neutral_count = neutral_count + excluded.neutral_count,\n negative_count = negative_count + excluded.negative_count`,\n [brandId, today, collected, posCount, neuCount, negCount],\n );\n\n return collected;\n}\n\nexport default async function handler(req: Request): Promise<Response> {\n const url = new URL(req.url);\n const path = url.pathname;\n\n if (req.method === \"OPTIONS\") {\n return new Response(null, { headers: corsHeaders });\n }\n\n // GET /api/brands\n if (req.method === \"GET\" && path === \"/api/brands\") {\n const rows = await sqlite.execute(\n `SELECT b.id, b.name, b.created_at, COUNT(a.id) as article_count\n FROM brands b LEFT JOIN articles a ON b.id = a.brand_id\n GROUP BY b.id ORDER BY b.name`,\n );\n const brands = rows.rows.map((r) => ({\n id: r[0],\n name: r[1],\n created_at: r[2],\n article_count: r[3],\n }));\n return jsonResponse(brands);\n }\n\n // POST /api/brands\n if (req.method === \"POST\" && path === \"/api/brands\") {\n const body = await req.json();\n if (!body.name) return jsonResponse({ error: \"name required\" }, 400);\n try {\n const result = await sqlite.execute(\n `INSERT INTO brands (name) VALUES (?) RETURNING id, name`,\n [body.name],\n );\n return jsonResponse({ id: result.rows[0][0], name: result.rows[0][1] }, 201);\n } catch (_e) {\n return jsonResponse({ error: \"Brand already exists\" }, 409);\n }\n }\n\n // DELETE /api/brands/:id\n const brandDeleteMatch = path.match(/^\\/api\\/brands\\/(\\d+)$/);\n if (req.method === \"DELETE\" && brandDeleteMatch) {\n const id = parseInt(brandDeleteMatch[1]);\n await sqlite.execute(`DELETE FROM articles WHERE brand_id = ?`, [id]);\n await sqlite.execute(`DELETE FROM daily_metrics WHERE brand_id = ?`, [id]);\n await sqlite.execute(`DELETE FROM brands WHERE id = ?`, [id]);\n return jsonResponse({ deleted: true });\n }\n\n // GET /api/articles?brand_id=1&days=7\n if (req.method === \"GET\" && path === \"/api/articles\") {\n const brandId = url.searchParams.get(\"brand_id\");\n const days = parseInt(url.searchParams.get(\"days\") || \"7\");\n if (!brandId) return jsonResponse({ error: \"brand_id required\" }, 400);\n const cutoff = Math.floor(Date.now() / 1000) - days * 86400;\n const rows = await sqlite.execute(\n `SELECT id, title, url, source_name, published_at, sentiment, sentiment_score, collected_at\n FROM articles WHERE brand_id = ? AND collected_at >= ? ORDER BY collected_at DESC LIMIT 100`,\n [parseInt(brandId), cutoff],\n );\n const articles = rows.rows.map((r) => ({\n id: r[0], title: r[1], url: r[2], source_name: r[3],\n published_at: r[4], sentiment: r[5], sentiment_score: r[6], collected_at: r[7],\n }));\n return jsonResponse(articles);\n }\n\n // GET /api/report?brand_id=1&period=week\n if (req.method === \"GET\" && path === \"/api/report\") {\n const brandId = url.searchParams.get(\"brand_id\");\n if (!brandId) return jsonResponse({ error: \"brand_id required\" }, 400);\n const period = url.searchParams.get(\"period\") || \"week\";\n const days = period === \"month\" ? 30 : period === \"day\" ? 1 : 7;\n const cutoff = Math.floor(Date.now() / 1000) - days * 86400;\n\n const brandRows = await sqlite.execute(\n `SELECT id, name FROM brands WHERE id = ?`,\n [parseInt(brandId)],\n );\n if (!brandRows.rows.length) return jsonResponse({ error: \"Brand not found\" }, 404);\n const brand = { id: brandRows.rows[0][0], name: brandRows.rows[0][1] };\n\n const articleRows = await sqlite.execute(\n `SELECT id, title, url, source_name, sentiment, sentiment_score, collected_at\n FROM articles WHERE brand_id = ? AND collected_at >= ? ORDER BY collected_at DESC`,\n [parseInt(brandId), cutoff],\n );\n const articles = articleRows.rows.map((r) => ({\n id: r[0], title: r[1], url: r[2], source_name: r[3],\n sentiment: r[4], sentiment_score: r[5], collected_at: r[6],\n }));\n\n const sentimentBreakdown = { positive: 0, neutral: 0, negative: 0 };\n const sourceMap: Record<string, number> = {};\n for (const a of articles) {\n const s = a.sentiment as string;\n if (s in sentimentBreakdown) sentimentBreakdown[s as keyof typeof sentimentBreakdown]++;\n const src = (a.source_name as string) || \"Unknown\";\n sourceMap[src] = (sourceMap[src] || 0) + 1;\n }\n const topSources = Object.entries(sourceMap)\n .sort((a, b) => b[1] - a[1])\n .slice(0, 10)\n .map(([name, count]) => ({ name, count }));\n\n return jsonResponse({\n brand,\n period,\n total_articles: articles.length,\n sentiment_breakdown: sentimentBreakdown,\n top_sources: topSources,\n recent_articles: articles.slice(0, 20),\n });\n }\n\n // POST /api/collect\n if (req.method === \"POST\" && path === \"/api/collect\") {\n const body = await req.json();\n if (!body.brand_id) return jsonResponse({ error: \"brand_id required\" }, 400);\n const collected = await collectArticles(body.brand_id);\n return jsonResponse({ collected });\n }\n\n return jsonResponse({ error: \"Not found\", path }, 404);\n}",["D",1783289363906],"id","02b93d4c-8e45-4618-935a-44aaa786ed62","prMonitorApi",["D",1783289313194],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","PR monitoring API backend","imageUrl","019cdef0-5cd0-7261-bddf-67d3a4efcd7a","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount",0,"orgId","019cdef0-5cd0-7261-bddf-6971337b2068","tursoName","tursoHostname","tursoMeasuredAt","pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_100":99,"_107":103},"org",{"_100":99,"_101":-5,"_102":103,"_18":60,"_104":105,"_106":25},"branch",{"_13":89,"_32":90,"_48":40,"_91":49,"_92":-5,"_93":-5,"_94":-5,"_95":-5,"_96":-5,"_97":50,"_98":99},"isOwned",26,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","lobsterman","handle","displayName","avatar","https://img.clerk.com/eyJ0eXBlIjoiZGVmYXVsdCIsImlpZCI6Imluc18yTm10cGhQUklwU0tqZHNiOHNnNGd2ZjJURFUiLCJyaWQiOiJ1c2VyXzNBb2xGb1hUcU8ydWYzR0FNVzhFRDBaQk5SWCJ9","tier","free","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_48":49,"_32":50,"_36":159,"_52":-5,"_53":25,"_54":55,"_56":55,"_57":58,"_59":-5,"_18":60,"_61":-5,"_62":25,"_63":-5,"_64":-5,"_65":66,"_67":68,"_69":-5,"_70":-5,"_71":-5,"_72":-5,"_73":74,"_75":74,"_76":77,"_78":77,"_79":77,"_80":74,"_81":74,"_82":160,"_84":161,"_86":162,"_88":25},"tree",[149],"files",[149,150],"counts",{"_138":66,"_139":14,"_140":66,"_141":142,"_143":144},"contents",[131],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles",true,"grants","orgs","customDomains",{},{"_48":132,"_32":28,"_30":31,"_133":-5,"_39":40,"_38":14,"_134":126,"_36":135,"_13":66,"_33":34,"_35":-5,"_24":25,"_136":-5,"_27":137},"4a6c5e85-b952-46dd-aaa1-9a41fcfb2f6e","parentId","latest",["D",1783289363906],"label",[28],"pulls","branches","forks","envVars",{"_145":147,"_148":66},"connections",{"_145":66,"_146":66},"count","unfilledCount",3,"emptyCount",{"_48":132,"_32":28,"_30":31,"_133":-5,"_39":40,"_38":14,"_134":126,"_36":156,"_13":66,"_33":34,"_35":-5,"_24":25,"_136":-5,"_153":157,"_27":158},{"_48":151,"_32":44,"_30":43,"_133":31,"_39":40,"_38":14,"_134":25,"_36":152,"_13":66,"_33":45,"_35":46,"_24":25,"_136":-5,"_153":154,"_27":155},"9289b57f-28b4-4b77-b299-8e34f0d6be20",["D",1783289363906],"children",[],[28,44],["D",1783289363906],[150],[28],["D",1783289313194],{"_100":99,"_107":103},{"_100":99,"_101":-5,"_102":103,"_18":60,"_104":105,"_106":25},{"_13":89,"_32":90,"_48":40,"_91":49,"_92":-5,"_93":-5,"_94":-5,"_95":-5,"_96":-5,"_97":50,"_98":99},"ctx",{"_82":-5,"_128":196,"_197":198,"_199":200,"_201":25,"_202":25,"_203":25,"_204":126,"_205":-5,"_206":-7,"_207":-7,"_208":66,"_209":25,"_210":25,"_211":-5,"_212":25,"_213":25,"_214":25,"_215":-5},"ENV",{"_167":168,"_169":170,"_171":90,"_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"] </article></body></html>

Diff · v1