[{"_1":2,"_170":-5,"_171":-5},"loaderData",{"_3":4,"_92":93},"root",{"_5":6,"_35":36,"_65":66},"ctx",{"_7":8,"_23":-5,"_24":25,"_26":27,"_28":20,"_29":20,"_30":20,"_31":32,"_33":20,"_34":20},"auth",{"_9":-5,"_10":-5,"_11":-5,"_12":-5,"_13":-5,"_14":-5,"_15":-5,"_16":-5,"_17":-5,"_18":-5,"_19":20,"_21":22},"sessionClaims","sessionId","sessionStatus","userId","actor","orgId","orgRole","orgSlug","orgPermissions","factorVerificationAge","isAuthenticated",false,"tokenType","session_token","user","preferencesKeybindings","default","preferencesTheme","light","preferencesFixers","preferencesCopilot","preferencesSelectionAi","notificationCount",0,"flagDenols","isTeamOrgMember","ENV",{"_37":38,"_39":40,"_41":42,"_43":44,"_45":46,"_47":48,"_49":50,"_51":52,"_53":54,"_55":56,"_57":58,"_59":60,"_61":62,"_63":64},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","VAL_RUNTIME_NAME","prod","RENDER_GIT_COMMIT","adff7c7aeabd218801703bcdcaac3a168cba1c7b","RENDER_GIT_BRANCH","main","CLERK_PUBLISHABLE_KEY","pk_live_Y2xlcmsudmFsLnRvd24k","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","API_URL","https://api.val.town","clerkState",{"_67":68},"__internal_clerk_state",{"_69":70,"_71":46,"_72":73,"_74":73,"_75":20,"_76":73,"_77":73,"_78":73,"_79":73,"_80":81,"_90":20,"_91":20},"__clerk_ssr_state",{"_21":22,"_9":-5,"_10":-5,"_11":-5,"_12":-5,"_13":-5,"_14":-5,"_15":-5,"_16":-5,"_17":-5,"_18":-5,"_19":20},"__publishableKey","__proxyUrl","","__domain","__isSatellite","__signInUrl","__signUpUrl","__afterSignInUrl","__afterSignUpUrl","__clerk_debug",{"_82":20,"_19":20,"_83":73,"_84":85,"_86":73,"_87":46,"_88":20,"_89":73},"isSignedIn","proxyUrl","reason","session-token-and-uat-missing","message","publishableKey","isSatellite","domain","__telemetryDisabled","__telemetryDebug","routes/embed.x.$handle.$name.$",{"_94":95,"_96":97,"_98":99,"_100":101,"_148":149,"_167":168,"_169":-5},"handle","emrebaranarca","name","water-watch","path","main.ts","project",{"_102":103,"_96":97,"_104":105,"_106":-5,"_107":20,"_108":109,"_110":-5,"_111":-5,"_12":112,"_113":-5,"_114":20,"_115":-5,"_116":-5,"_117":32,"_14":118,"_119":120,"_121":120,"_122":123,"_124":123,"_125":123,"_126":120,"_127":120,"_23":128,"_131":132,"_134":135,"_147":20},"id","2c0f3f86-ee0a-11f0-8731-42dde27851f2","createdAt",["D",1768038790472],"deletedAt","legacyEnvVars","privacy","public","description","imageUrl","019b5081-1032-708e-a656-cf5529467c2d","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount","019b5081-1032-708e-a656-d1b51c9ba1e4","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm",{"_94":95,"_129":130},"profileImageUrl","https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvb2F1dGhfZ2l0aHViL2ltZ18zN0lFVDNIT0E1anJDSWU1NlU1T3FiUDVPSjkifQ","org",{"_94":95,"_133":130,"_12":112},"avatar","branch",{"_136":137,"_96":44,"_102":138,"_139":103,"_140":-5,"_141":-5,"_142":-5,"_143":-5,"_144":-5,"_145":97,"_146":95},"version",65,"2c0f8c34-ee0a-11f0-8731-42dde27851f2","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","isOwned","file",{"_102":150,"_96":99,"_151":152,"_153":-5,"_154":138,"_155":137,"_156":157,"_104":158,"_136":159,"_160":161,"_162":163,"_164":20,"_165":-5,"_98":166},"46c3cd46-ee60-11f0-bcd2-42dde27851f2","fileId","2c118cb4-ee0a-11f0-8731-42dde27851f2","parentId","branchId","branchVersion","latest",true,["D",1768075771987],64,"fileType","http","content","/** @jsxImportSource npm:react */\nimport { sqlite } from \"https://esm.town/v/std/sqlite\";\nimport * as cheerio from \"npm:cheerio\";\n\n// -----------------------------------------------------------------------------\n// 1. TYPES & INTERFACES\n// -----------------------------------------------------------------------------\n\ninterface CityData {\n city_slug: string;\n city_name: string;\n percentage: number;\n current_volume?: number;\n total_capacity?: number;\n recorded_at?: string;\n}\n\ninterface ApiResponse {\n last_updated: string;\n data: CityData[];\n history?: any[]; // For now, we return latest. Can be expanded.\n}\n\n// -----------------------------------------------------------------------------\n// 2. DATABASE SETUP\n// -----------------------------------------------------------------------------\n\nasync function setupDatabase() {\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS daily_records (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n city_slug TEXT NOT NULL,\n city_name TEXT NOT NULL,\n percentage REAL NOT NULL,\n current_volume REAL,\n recorded_at DATETIME DEFAULT CURRENT_TIMESTAMP\n );\n `);\n}\n\nasync function insertRecord(data: CityData) {\n await sqlite.execute({\n sql: `\n INSERT INTO daily_records (city_slug, city_name, percentage, current_volume)\n VALUES (:city_slug, :city_name, :percentage, :current_volume)\n `,\n args: {\n city_slug: data.city_slug,\n city_name: data.city_name,\n percentage: data.percentage,\n current_volume: data.current_volume || null,\n },\n });\n}\n\nasync function getLatestRecords(): Promise {\n // Get the most recent record for each city\n const result = await sqlite.execute(`\n SELECT city_slug, city_name, percentage, current_volume, recorded_at\n FROM daily_records \n WHERE id IN (\n SELECT MAX(id) \n FROM daily_records \n GROUP BY city_slug\n )\n `);\n\n // Map array rows to objects\n return result.rows.map((row: any) => ({\n city_slug: row[0],\n city_name: row[1],\n percentage: row[2],\n current_volume: row[3],\n recorded_at: row[4],\n }));\n}\n\nasync function getHistoryForCity(\n citySlug: string,\n days: number = 30,\n): Promise {\n const result = await sqlite.execute({\n sql: `\n SELECT city_slug, city_name, percentage, current_volume, recorded_at\n FROM daily_records \n WHERE city_slug = :city_slug\n ORDER BY recorded_at DESC\n LIMIT :limit\n `,\n args: { city_slug: citySlug, limit: days },\n });\n\n return result.rows.map((row: any) => ({\n city_slug: row[0],\n city_name: row[1],\n percentage: row[2],\n current_volume: row[3],\n recorded_at: row[4],\n }));\n}\n\nasync function getPreviousDayRecords(): Promise> {\n // Get yesterday's record for each city (for trend comparison)\n const result = await sqlite.execute(`\n SELECT city_slug, percentage\n FROM daily_records \n WHERE DATE(recorded_at) = DATE('now', '-1 day')\n GROUP BY city_slug\n `);\n\n const map = new Map();\n for (const row of result.rows as any[]) {\n map.set(row[0], row[1]);\n }\n return map;\n}\n\n// -----------------------------------------------------------------------------\n// 3. SCRAPERS\n// -----------------------------------------------------------------------------\n\n// Proxy services for SSL bypass (try multiple)\nconst PROXY_SERVICES = [\n (url: string) => `https://corsproxy.io/?${encodeURIComponent(url)}`,\n (url: string) =>\n `https://api.allorigins.win/raw?url=${encodeURIComponent(url)}`,\n (url: string) => `https://proxy.cors.sh/${url}`,\n];\n\n// Helper to fetch with headers (mimic browser)\nasync function fetchHtml(url: string, useProxy = false) {\n const 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 \"Accept\":\n \"text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8\",\n };\n\n if (!useProxy) {\n const res = await fetch(url, { headers });\n if (!res.ok) throw new Error(`HTTP ${res.status}`);\n return res.text();\n }\n\n // Try each proxy service until one works\n for (const proxyFn of PROXY_SERVICES) {\n try {\n const proxyUrl = proxyFn(url);\n const res = await fetch(proxyUrl, { headers });\n if (res.ok) {\n return res.text();\n }\n } catch (e) {\n // Try next proxy\n continue;\n }\n }\n\n throw new Error(`All proxies failed for ${url}`);\n}\n\n// Helper to fetch JSON with proxy support\nasync function fetchJson(url: string, useProxy = false) {\n const headers = {\n \"User-Agent\":\n \"Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36\",\n \"Accept\": \"application/json\",\n };\n\n if (!useProxy) {\n const res = await fetch(url, { headers });\n if (!res.ok) throw new Error(`HTTP ${res.status}`);\n return res.json();\n }\n\n // Try each proxy service until one works\n for (const proxyFn of PROXY_SERVICES) {\n try {\n const proxyUrl = proxyFn(url);\n const res = await fetch(proxyUrl, { headers });\n if (res.ok) {\n const text = await res.text();\n return JSON.parse(text);\n }\n } catch (e) {\n // Try next proxy\n continue;\n }\n }\n\n throw new Error(`All proxies failed for ${url}`);\n}\n\nasync function scrapeIstanbul(): Promise {\n // Istanbul (ISKI) - Try multiple approaches\n const MAIN_URL = \"https://www.iski.istanbul/web/tr-TR/baraj-doluluk\";\n\n try {\n const mainHtml = await fetchHtml(MAIN_URL);\n const $ = cheerio.load(mainHtml);\n\n // Approach 1: Look for the percentage directly in HTML\n // ISKI often displays \"Genel Doluluk Oranı: XX.XX%\" or similar\n const bodyText = $(\"body\").text();\n\n // Try to find percentage near \"Genel\" or \"Toplam\" keywords\n const genelMatch = bodyText.match(\n /(?:Genel|Toplam)[^0-9]*?(\\d{1,2}[.,]\\d{1,2})\\s*%/i,\n );\n if (genelMatch) {\n const percentage = parseFloat(genelMatch[1].replace(\",\", \".\"));\n if (percentage > 0 && percentage <= 100) {\n return {\n city_slug: \"istanbul\",\n city_name: \"Istanbul\",\n percentage: percentage,\n };\n }\n }\n\n // Approach 2: Look for Nuxt payload in script tags\n const scripts = $(\"script\").toArray();\n for (const script of scripts) {\n const content = $(script).html() || \"\";\n\n // Look for __NUXT__ data\n if (content.includes(\"__NUXT__\") || content.includes(\"window.__NUXT__\")) {\n // Try to extract doluluk_orani or similar fields\n const dolulukMatch = content.match(\n /doluluk[_\\s]*(?:orani)?['\":\\s]*(\\d{1,2}[.,]\\d{1,2})/i,\n );\n if (dolulukMatch) {\n const percentage = parseFloat(dolulukMatch[1].replace(\",\", \".\"));\n if (percentage > 0 && percentage <= 100) {\n return {\n city_slug: \"istanbul\",\n city_name: \"Istanbul\",\n percentage: percentage,\n };\n }\n }\n }\n }\n\n // Approach 3: Try to find payload.js URL and fetch it\n const payloadMatch = mainHtml.match(\n /(?:href|src)=\"(\\/_nuxt\\/static\\/[^\"]+\\/(?:baraj-doluluk\\/)?payload\\.js)\"/,\n );\n if (payloadMatch) {\n const payloadPath = payloadMatch[1];\n const PAYLOAD_URL = `https://www.iski.istanbul${payloadPath}`;\n const payloadScript = await fetchHtml(PAYLOAD_URL);\n\n // Look for percentage values in payload\n // Pattern: look for numbers between 20-100 that appear near doluluk context\n const contextMatch = payloadScript.match(\n /doluluk[^}]*?(\\d{1,2}\\.\\d{1,2})/i,\n );\n if (contextMatch) {\n const percentage = parseFloat(contextMatch[1]);\n if (percentage > 0 && percentage <= 100) {\n return {\n city_slug: \"istanbul\",\n city_name: \"Istanbul\",\n percentage: percentage,\n };\n }\n }\n\n // Fallback: find percentage-like numbers\n const numberMatches = payloadScript.matchAll(/(\\d{2}\\.\\d{2})/g);\n const numbers = Array.from(numberMatches).map((m) => parseFloat(m[1]));\n // Filter to realistic dam percentages (between 10 and 90 typically)\n const percentage = numbers.find((n) => n >= 10 && n <= 90);\n if (percentage) {\n return {\n city_slug: \"istanbul\",\n city_name: \"Istanbul\",\n percentage: percentage,\n };\n }\n }\n\n console.error(\n \"Istanbul scraper failed: Could not parse percentage from any source.\",\n );\n return null;\n } catch (error) {\n console.error(\"Istanbul scraper error:\", error);\n return null;\n }\n}\n\nasync function scrapeAnkara(): Promise {\n // Ankara (ASKI) uses an ASP.NET AJAX endpoint for date updates.\n // URL: https://www.aski.gov.tr/TR/Default.aspx/Counter\n\n const API_URL = \"https://www.aski.gov.tr/TR/Default.aspx/Counter\";\n\n try {\n const response = await fetch(API_URL, {\n method: \"POST\",\n headers: {\n \"Content-Type\": \"application/json; charset=utf-8\",\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 body: JSON.stringify({}), // Empty body for this specific endpoint\n });\n\n if (!response.ok) throw new Error(`HTTP helper error ${response.status}`);\n\n const json = await response.json();\n // The API returns { d: \"{\\\"success\\\":true,\\\"BarajDegeri\\\":\\\"13.95\\\",\\\"SonucSu\\\":\\\"29,26\\\",\\\"sonuc\\\":\\\"...\\\"}\" }\n // We need to parse the inner JSON string in 'd'.\n\n if (json.d) {\n const innerData = JSON.parse(json.d);\n // SonucSu contains the actual dam fill percentage, not BarajDegeri\n if (innerData.SonucSu) {\n return {\n city_slug: \"ankara\",\n city_name: \"Ankara\",\n percentage: parseFloat(innerData.SonucSu.replace(\",\", \".\")),\n };\n }\n }\n\n console.error(\n \"Ankara scraper failed: API response structure changed.\",\n json,\n );\n return null;\n } catch (error) {\n console.error(\"Ankara scraper error:\", error);\n return null;\n }\n}\n\nasync function scrapeIzmir(): Promise {\n // Izmir (IZSU) - Multiple URL attempts\n // Note: Main IZSU site requires e-Devlet auth, trying alternative approaches\n\n const URLS = [\n \"https://www.izsu.gov.tr/\",\n \"https://www.izsu.gov.tr/tr/Kurumsal/1\",\n ];\n\n for (const url of URLS) {\n try {\n const 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 \"Accept\":\n \"text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8\",\n \"Accept-Language\": \"tr-TR,tr;q=0.9,en;q=0.8\",\n \"Cookie\": \"AspxAutoDetectCookieSupport=1\",\n };\n\n const res = await fetch(url, {\n headers,\n redirect: \"manual\", // Don't follow redirects automatically\n });\n\n // Handle redirect manually if needed\n if (res.status >= 300 && res.status < 400) {\n const location = res.headers.get(\"Location\");\n if (location) {\n const redirectRes = await fetch(\n location.startsWith(\"http\")\n ? location\n : `https://www.izsu.gov.tr${location}`,\n { headers },\n );\n if (!redirectRes.ok) continue;\n const html = await redirectRes.text();\n const $ = cheerio.load(html);\n const bodyText = $(\"body\").text();\n\n // Look for percentage patterns\n const match = bodyText.match(\n /(?:Doluluk|Baraj)[^0-9]*?(\\d{1,2}[.,]\\d{1,2})\\s*%/i,\n );\n if (match) {\n const percentage = parseFloat(match[1].replace(\",\", \".\"));\n if (percentage > 0 && percentage <= 100) {\n return { city_slug: \"izmir\", city_name: \"Izmir\", percentage };\n }\n }\n }\n continue;\n }\n\n if (!res.ok) continue;\n\n const html = await res.text();\n const $ = cheerio.load(html);\n const bodyText = $(\"body\").text();\n\n // Strategy 1: Look for doluluk/baraj percentage patterns\n const patterns = [\n /(?:Doluluk|Baraj)[^0-9]*?(\\d{1,2}[.,]\\d{1,2})\\s*%/i,\n /(?:Toplam|Genel)[^0-9]*?%?\\s*(\\d{1,2}[.,]\\d{1,2})\\s*%?/i,\n /%\\s*(\\d{1,2}[.,]\\d{1,2})/,\n ];\n\n for (const pattern of patterns) {\n const match = bodyText.match(pattern);\n if (match) {\n const percentage = parseFloat(match[1].replace(\",\", \".\"));\n if (percentage > 0 && percentage <= 100) {\n return { city_slug: \"izmir\", city_name: \"Izmir\", percentage };\n }\n }\n }\n } catch (error) {\n console.error(`Izmir scraper error for ${url}:`, error);\n // Continue to next URL\n }\n }\n\n console.error(\n \"Izmir scraper failed: Could not access data (may require e-Devlet auth).\",\n );\n return null;\n}\n\nasync function scrapeAdana(): Promise {\n // Adana (ASKİ) - Dam fill rate page\n // URL: https://www.adana-aski.gov.tr/web/barajdoluluk.aspx\n // The percentage is shown in the header: \"Barajlarımızdaki Doluluk Oranı: XX,XX\"\n // NOTE: Uses proxy due to SSL certificate issues\n\n const MAIN_URL = \"https://www.adana-aski.gov.tr/web/barajdoluluk.aspx\";\n\n try {\n // Use proxy to bypass SSL issues\n const html = await fetchHtml(MAIN_URL, true);\n const $ = cheerio.load(html);\n const bodyText = $(\"body\").text();\n\n // Strategy 1: Look for the header text \"Doluluk Oranı:XX,XX\"\n // Pattern from site: \"Barajlarımızdaki Doluluk Oranı:65,26\"\n const headerMatch = bodyText.match(\n /Doluluk\\s*Oran[ıi]\\s*:?\\s*(\\d{1,2}[.,]\\d{1,2})/i,\n );\n if (headerMatch) {\n const percentage = parseFloat(headerMatch[1].replace(\",\", \".\"));\n if (percentage > 0 && percentage <= 100) {\n return {\n city_slug: \"adana\",\n city_name: \"Adana\",\n percentage: percentage,\n };\n }\n }\n\n // Strategy 2: Look for percentage in any format\n const percentMatch = bodyText.match(\n /%\\s*(\\d{1,2}[.,]\\d{1,2})|(\\d{1,2}[.,]\\d{1,2})\\s*%/,\n );\n if (percentMatch) {\n const value = percentMatch[1] || percentMatch[2];\n const percentage = parseFloat(value.replace(\",\", \".\"));\n if (percentage > 0 && percentage <= 100) {\n return {\n city_slug: \"adana\",\n city_name: \"Adana\",\n percentage: percentage,\n };\n }\n }\n\n console.error(\"Adana scraper failed: Could not find percentage data.\");\n return null;\n } catch (error) {\n console.error(\"Adana scraper error:\", error);\n return null;\n }\n}\n\nasync function scrapeMugla(): Promise {\n // Muğla (MUSKİ) - Dam fill rate page\n // URL: https://www.muski.gov.tr/baraj-doluluk-orani\n // Shows individual dams with their percentages\n\n const MAIN_URL = \"https://www.muski.gov.tr/baraj-doluluk-orani\";\n\n try {\n const html = await fetchHtml(MAIN_URL);\n const $ = cheerio.load(html);\n const bodyText = $(\"body\").text();\n\n // Strategy 1: Look for \"Doluluk Oranı: %XX\" pattern\n const dolulukMatch = bodyText.match(\n /Doluluk\\s*Oran[ıi]\\s*:?\\s*%?\\s*(\\d{1,2}(?:[.,]\\d{1,2})?)/i,\n );\n if (dolulukMatch) {\n const percentage = parseFloat(dolulukMatch[1].replace(\",\", \".\"));\n if (percentage > 0 && percentage <= 100) {\n return {\n city_slug: \"mugla\",\n city_name: \"Mugla\",\n percentage: percentage,\n };\n }\n }\n\n // Strategy 2: Look for percentage patterns with %\n const percentMatches = bodyText.matchAll(\n /%\\s*(\\d{1,2}(?:[.,]\\d{1,2})?)|(\\d{1,2}(?:[.,]\\d{1,2})?)\\s*%/g,\n );\n const percentages = Array.from(percentMatches)\n .map((m) => parseFloat((m[1] || m[2]).replace(\",\", \".\")))\n .filter((p) => p > 0 && p <= 100);\n\n if (percentages.length > 0) {\n // Return the first (most prominent) percentage\n return {\n city_slug: \"mugla\",\n city_name: \"Mugla\",\n percentage: percentages[0],\n };\n }\n\n console.error(\"Mugla scraper failed: Could not find percentage data.\");\n return null;\n } catch (error) {\n console.error(\"Mugla scraper error:\", error);\n return null;\n }\n}\n\nasync function scrapeSakarya(): Promise {\n // Sakarya (SASKİ) - Uses JSON API endpoints\n // Main dam: Çakmak Barajı\n // API returns: [{\"Doluluk\":XX.XX,\"Meter\":XXX.XX,\"HacimHM3\":XX.XX}]\n // NOTE: Uses proxy due to SSL certificate issues\n\n const MAIN_API = \"https://proxy.saski.gov.tr/cakmak-baraji.php\";\n\n try {\n // Use proxy to bypass SSL issues\n const data = await fetchJson(MAIN_API, true);\n\n if (Array.isArray(data) && data[0] && typeof data[0].Doluluk === \"number\") {\n const percentage = data[0].Doluluk;\n if (percentage > 0 && percentage <= 100) {\n return {\n city_slug: \"sakarya\",\n city_name: \"Sakarya\",\n percentage: Math.round(percentage * 100) / 100,\n };\n }\n }\n\n console.error(\"Sakarya scraper failed: Invalid data format.\", data);\n return null;\n } catch (error) {\n console.error(\"Sakarya scraper error:\", error);\n\n // Fallback: Try scraping the HTML page with proxy\n try {\n const html = await fetchHtml(\"https://www.saski.gov.tr/barajlar/\", true);\n const $ = cheerio.load(html);\n\n // Look for percentage in the page\n const bodyText = $(\"body\").text();\n const match = bodyText.match(/Doluluk[^0-9]*(\\d{1,2}[.,]\\d{1,2})/i);\n if (match) {\n const percentage = parseFloat(match[1].replace(\",\", \".\"));\n if (percentage > 0 && percentage <= 100) {\n return {\n city_slug: \"sakarya\",\n city_name: \"Sakarya\",\n percentage: percentage,\n };\n }\n }\n } catch (fallbackError) {\n console.error(\"Sakarya fallback scraper error:\", fallbackError);\n }\n\n return null;\n }\n}\n\nasync function scrapeKonya(): Promise {\n // Konya (KOSKI) - Altınapa dam values\n // URL: https://www.koski.gov.tr/koski/altinapa-baraj-degerleri\n // Also try homepage if specific page fails\n\n const URLS = [\n \"https://www.koski.gov.tr/koski/altinapa-baraj-degerleri\",\n \"https://www.koski.gov.tr/\",\n \"https://www.koski.gov.tr/su-durumu\",\n ];\n\n for (const url of URLS) {\n try {\n const html = await fetchHtml(url);\n const $ = cheerio.load(html);\n\n const bodyText = $(\"body\").text();\n\n // Strategy 1: Look for \"Baraj\" followed by percentage context\n // Pattern: \"Baraj Doluluk Oranı: %XX\" or \"Baraj: XX%\"\n const barajMatch = bodyText.match(\n /Baraj[^0-9]*?(?:Doluluk)?[^0-9]*?(?:Oran[ıi])?[^0-9]*?%?\\s*(\\d{1,2}[.,]\\d{1,2})\\s*%?/i,\n );\n if (barajMatch) {\n const percentage = parseFloat(barajMatch[1].replace(\",\", \".\"));\n if (percentage > 0 && percentage <= 100) {\n return {\n city_slug: \"konya\",\n city_name: \"Konya\",\n percentage: percentage,\n };\n }\n }\n\n // Strategy 2: Look for \"Doluluk\" keyword\n const dolulukMatch = bodyText.match(\n /Doluluk[^0-9]*?%?\\s*(\\d{1,2}[.,]\\d{1,2})\\s*%?/i,\n );\n if (dolulukMatch) {\n const percentage = parseFloat(dolulukMatch[1].replace(\",\", \".\"));\n if (percentage > 0 && percentage <= 100) {\n return {\n city_slug: \"konya\",\n city_name: \"Konya\",\n percentage: percentage,\n };\n }\n }\n\n // Strategy 3: Look for \"Altınapa\" specific data\n const altinapaMatch = bodyText.match(\n /Alt[ıi]napa[^0-9]*?(\\d{1,2}[.,]\\d{1,2})\\s*%?/i,\n );\n if (altinapaMatch) {\n const percentage = parseFloat(altinapaMatch[1].replace(\",\", \".\"));\n if (percentage > 0 && percentage <= 100) {\n return {\n city_slug: \"konya\",\n city_name: \"Konya\",\n percentage: percentage,\n };\n }\n }\n\n // Strategy 4: Generic percentage search\n const allMatches = bodyText.matchAll(/(\\d{1,2}[.,]\\d{1,2})\\s*%/g);\n const allPercentages = Array.from(allMatches).map((m) =>\n parseFloat(m[1].replace(\",\", \".\"))\n );\n const validPercentages = allPercentages.filter((p) => p > 5 && p <= 100);\n\n if (validPercentages.length > 0) {\n return {\n city_slug: \"konya\",\n city_name: \"Konya\",\n percentage: validPercentages[0],\n };\n }\n } catch (error) {\n console.error(`Konya scraper error for ${url}:`, error);\n // Continue to next URL\n }\n }\n\n console.error(\n \"Konya scraper failed: Could not find percentage data from any URL.\",\n );\n return null;\n}\n\nasync function scrapeGaziantep(): Promise {\n // Gaziantep (GASKİ) - Homepage has percentage data\n // URL: https://www.gaski.gov.tr/\n\n try {\n const html = await fetchHtml(\"https://www.gaski.gov.tr/\");\n const $ = cheerio.load(html);\n const bodyText = $(\"body\").text();\n\n // Look for percentage patterns\n const percentMatches = bodyText.matchAll(/(\\d{1,2}[.,]\\d{1,3})%/g);\n const percentages = Array.from(percentMatches)\n .map((m) => parseFloat(m[1].replace(\",\", \".\")))\n .filter((p) => p > 10 && p <= 100);\n\n if (percentages.length > 0) {\n // First percentage is usually the main dam\n return {\n city_slug: \"gaziantep\",\n city_name: \"Gaziantep\",\n percentage: percentages[0],\n };\n }\n\n console.error(\"Gaziantep scraper failed: Could not find percentage data.\");\n return null;\n } catch (error) {\n console.error(\"Gaziantep scraper error:\", error);\n return null;\n }\n}\n\nasync function scrapeDenizli(): Promise {\n // Denizli (DESKİ) - Homepage has doluluk data\n // URL: https://www.deski.gov.tr/\n\n try {\n const html = await fetchHtml(\"https://www.deski.gov.tr/\");\n const $ = cheerio.load(html);\n const bodyText = $(\"body\").text();\n\n // Look for doluluk percentage\n const dolulukMatch = bodyText.match(/[Dd]oluluk[^0-9]*(\\d{1,2}[.,]\\d+)%?/);\n if (dolulukMatch) {\n const percentage = parseFloat(dolulukMatch[1].replace(\",\", \".\"));\n if (percentage > 0 && percentage <= 100) {\n return {\n city_slug: \"denizli\",\n city_name: \"Denizli\",\n percentage: percentage,\n };\n }\n }\n\n // Fallback: look for percentage patterns\n const percentMatches = bodyText.matchAll(/(\\d{1,2}[.,]\\d+)%/g);\n const percentages = Array.from(percentMatches)\n .map((m) => parseFloat(m[1].replace(\",\", \".\")))\n .filter((p) => p > 5 && p <= 100);\n\n if (percentages.length > 0) {\n return {\n city_slug: \"denizli\",\n city_name: \"Denizli\",\n percentage: percentages[0],\n };\n }\n\n console.error(\"Denizli scraper failed: Could not find percentage data.\");\n return null;\n } catch (error) {\n console.error(\"Denizli scraper error:\", error);\n return null;\n }\n}\n\nasync function scrapeEskisehir(): Promise {\n // Eskişehir (ESKİ) - Has baraj doluluk page\n // URL: https://www.eski.gov.tr/\n\n const URLS = [\n \"https://www.eski.gov.tr/\",\n \"https://www.eski.gov.tr/baraj-doluluk-oranlari\",\n ];\n\n for (const url of URLS) {\n try {\n const html = await fetchHtml(url);\n const $ = cheerio.load(html);\n const bodyText = $(\"body\").text();\n\n // Look for doluluk percentage\n const dolulukMatch = bodyText.match(\n /[Dd]oluluk[^0-9]*(\\d{1,2}[.,]\\d+)%?/,\n );\n if (dolulukMatch) {\n const percentage = parseFloat(dolulukMatch[1].replace(\",\", \".\"));\n if (percentage > 0 && percentage <= 100) {\n return {\n city_slug: \"eskisehir\",\n city_name: \"Eskisehir\",\n percentage: percentage,\n };\n }\n }\n\n // Look for baraj percentage\n const barajMatch = bodyText.match(/[Bb]araj[^0-9]*(\\d{1,2}[.,]\\d+)%?/);\n if (barajMatch) {\n const percentage = parseFloat(barajMatch[1].replace(\",\", \".\"));\n if (percentage > 0 && percentage <= 100) {\n return {\n city_slug: \"eskisehir\",\n city_name: \"Eskisehir\",\n percentage: percentage,\n };\n }\n }\n } catch (error) {\n console.error(`Eskisehir scraper error for ${url}:`, error);\n }\n }\n\n console.error(\"Eskisehir scraper failed: Could not find percentage data.\");\n return null;\n}\n\nasync function scrapeTrabzon(): Promise {\n // Trabzon (TİSKİ) - Has baraj doluluk data\n // URL: https://www.tiski.gov.tr/\n\n try {\n const html = await fetchHtml(\"https://www.tiski.gov.tr/\");\n const $ = cheerio.load(html);\n const bodyText = $(\"body\").text();\n\n // Look for doluluk percentage\n const dolulukMatch = bodyText.match(/[Dd]oluluk[^0-9]*(\\d{1,2}[.,]\\d+)%?/);\n if (dolulukMatch) {\n const percentage = parseFloat(dolulukMatch[1].replace(\",\", \".\"));\n if (percentage > 0 && percentage <= 100) {\n return {\n city_slug: \"trabzon\",\n city_name: \"Trabzon\",\n percentage: percentage,\n };\n }\n }\n\n // Fallback: look for percentage patterns\n const percentMatches = bodyText.matchAll(/(\\d{1,2}[.,]\\d+)%/g);\n const percentages = Array.from(percentMatches)\n .map((m) => parseFloat(m[1].replace(\",\", \".\")))\n .filter((p) => p > 10 && p <= 100);\n\n if (percentages.length > 0) {\n return {\n city_slug: \"trabzon\",\n city_name: \"Trabzon\",\n percentage: percentages[0],\n };\n }\n\n console.error(\"Trabzon scraper failed: Could not find percentage data.\");\n return null;\n } catch (error) {\n console.error(\"Trabzon scraper error:\", error);\n return null;\n }\n}\n\nasync function scrapeKocaeli(): Promise {\n // Kocaeli (İSU) - Baraj doluluk page\n // URL: https://www.isu.gov.tr/\n\n const URLS = [\n \"https://www.isu.gov.tr/\",\n \"https://www.isu.gov.tr/baraj-doluluk-oranlari\",\n ];\n\n for (const url of URLS) {\n try {\n const html = await fetchHtml(url);\n const $ = cheerio.load(html);\n const bodyText = $(\"body\").text();\n\n // Look for doluluk percentage\n const dolulukMatch = bodyText.match(\n /[Dd]oluluk[^0-9]*(\\d{1,2}[.,]\\d+)%?/,\n );\n if (dolulukMatch) {\n const percentage = parseFloat(dolulukMatch[1].replace(\",\", \".\"));\n if (percentage > 0 && percentage <= 100) {\n return {\n city_slug: \"kocaeli\",\n city_name: \"Kocaeli\",\n percentage: percentage,\n };\n }\n }\n\n // Look for baraj percentage\n const barajMatch = bodyText.match(/[Bb]araj[^0-9]*(\\d{1,2}[.,]\\d+)%?/);\n if (barajMatch) {\n const percentage = parseFloat(barajMatch[1].replace(\",\", \".\"));\n if (percentage > 0 && percentage <= 100) {\n return {\n city_slug: \"kocaeli\",\n city_name: \"Kocaeli\",\n percentage: percentage,\n };\n }\n }\n } catch (error) {\n console.error(`Kocaeli scraper error for ${url}:`, error);\n }\n }\n\n console.error(\"Kocaeli scraper failed: Could not find percentage data.\");\n return null;\n}\n\nasync function scrapeAntalya(): Promise {\n // Antalya (ASAT) - Water utility\n // URL: https://www.asat.gov.tr/\n\n try {\n const html = await fetchHtml(\"https://www.asat.gov.tr/\");\n const $ = cheerio.load(html);\n const bodyText = $(\"body\").text();\n\n // Look for doluluk/baraj percentage\n const dolulukMatch = bodyText.match(/[Dd]oluluk[^0-9]*(\\d{1,2}[.,]\\d+)%?/);\n if (dolulukMatch) {\n const percentage = parseFloat(dolulukMatch[1].replace(\",\", \".\"));\n if (percentage > 0 && percentage <= 100) {\n return {\n city_slug: \"antalya\",\n city_name: \"Antalya\",\n percentage: percentage,\n };\n }\n }\n\n // Fallback: percentage patterns\n const percentMatches = bodyText.matchAll(/(\\d{1,2}[.,]\\d+)%/g);\n const percentages = Array.from(percentMatches)\n .map((m) => parseFloat(m[1].replace(\",\", \".\")))\n .filter((p) => p > 10 && p <= 100);\n\n if (percentages.length > 0) {\n return {\n city_slug: \"antalya\",\n city_name: \"Antalya\",\n percentage: percentages[0],\n };\n }\n\n console.error(\"Antalya scraper failed: Could not find percentage data.\");\n return null;\n } catch (error) {\n console.error(\"Antalya scraper error:\", error);\n return null;\n }\n}\n\n// -----------------------------------------------------------------------------\n// 4. MAIN HANDLER\n// -----------------------------------------------------------------------------\n\nexport default async function (req: Request): Promise {\n // Handle CORS preflight\n if (req.method === \"OPTIONS\") {\n return new Response(null, {\n headers: {\n \"Access-Control-Allow-Origin\": \"*\",\n \"Access-Control-Allow-Methods\": \"GET, POST, OPTIONS\",\n \"Access-Control-Allow-Headers\": \"Content-Type\",\n },\n });\n }\n\n // Ensure DB exists on every request (cheap in SQLite)\n await setupDatabase();\n\n const url = new URL(req.url);\n\n // POST: Trigger Scrapers (Scheduled Task)\n if (req.method === \"POST\") {\n console.log(\"Starting Scheduled Scrape...\");\n\n // 5 reliable cities only\n const results = await Promise.all([\n scrapeIstanbul(),\n scrapeAnkara(),\n scrapeIzmir(),\n scrapeKonya(),\n scrapeMugla(),\n ]);\n\n let successCount = 0;\n for (const data of results) {\n if (data) {\n // Validate\n if (data.percentage >= 0 && data.percentage <= 100) {\n await insertRecord(data);\n successCount++;\n }\n }\n }\n\n return Response.json({\n status: \"ok\",\n scraped: successCount,\n total_attempted: results.length,\n });\n }\n\n // GET: Serve Data\n if (req.method === \"GET\") {\n const citySlug = url.searchParams.get(\"city\");\n const historyDays = parseInt(url.searchParams.get(\"history\") || \"0\");\n\n // If requesting specific city history\n if (citySlug && historyDays > 0) {\n const history = await getHistoryForCity(citySlug, historyDays);\n return Response.json({\n last_updated: new Date().toISOString(),\n city: citySlug,\n history: history,\n }, {\n headers: { \"Access-Control-Allow-Origin\": \"*\" },\n });\n }\n\n // Default: return latest records with trend data\n const records = await getLatestRecords();\n const previousDay = await getPreviousDayRecords();\n\n // Add trend to each record\n const dataWithTrend = records.map((record) => ({\n ...record,\n previous_percentage: previousDay.get(record.city_slug) || null,\n trend: previousDay.has(record.city_slug)\n ? (record.percentage > previousDay.get(record.city_slug)!\n ? \"up\"\n : record.percentage < previousDay.get(record.city_slug)!\n ? \"down\"\n : \"stable\")\n : null,\n }));\n\n return Response.json({\n last_updated: new Date().toISOString(),\n data: dataWithTrend,\n }, {\n headers: { \"Access-Control-Allow-Origin\": \"*\" },\n });\n }\n\n return new Response(\"Method Not Allowed\", { status: 405 });\n}","deleted","label",[99],"permalink","https://www.val.town/x/emrebaranarca/water-watch/code/main.ts","extension","actionData","errors"]