[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_326":327,"_328":329},"routes/_app.x.$handle.$name",{"_11":12,"_13":14,"_15":16,"_17":18,"_38":-7,"_120":-5,"_19":121,"_122":123,"_124":125,"_126":127,"_128":129,"_21":130,"_131":-5,"_132":-5,"_133":24,"_134":135,"_136":83,"_137":-5,"_138":-5,"_139":140},"routes/_app.x.$handle.$name.branch.$branch.history_.$",{"_11":12,"_13":14,"_15":16,"_17":18,"_19":20,"_21":22,"_23":24,"_25":26,"_27":28,"_29":24,"_30":-5},"handle","excel","name","FloodApp","branchName","main","path","frontend/index.html","project",{"_32":70,"_13":14,"_36":71,"_72":-5,"_73":24,"_74":75,"_76":75,"_77":78,"_79":-5,"_30":66,"_80":81,"_82":83,"_84":83,"_85":-5,"_86":26,"_40":41,"_87":-5,"_88":-5,"_89":-5,"_90":-5,"_91":92,"_93":92,"_94":95,"_96":95,"_97":95,"_98":92,"_99":92,"_51":100,"_101":102,"_103":104,"_105":24},"file",{"_61":62,"_13":63,"_64":21,"_65":24,"_69":-5},"isDirectory",false,"page",0,"history",[31],"hasNext","userId",{"_32":33,"_34":35,"_36":37,"_38":39,"_40":41,"_42":43,"_44":-5,"_45":-5,"_46":-5,"_47":-5,"_48":-5,"_49":-5,"_50":-5,"_51":52,"_21":53,"_54":-5,"_55":-5,"_56":-5,"_57":-5,"_58":59},"id","5682bf26-3448-11f0-a39d-9e149126039e","branchId","719b260a-3447-11f0-ae6c-9e149126039e","createdAt",["D",1747614574199],"version",12,"orgId","d12e9468-0713-4b2e-926d-7ccecb147081","parentId","3afff08e-3448-11f0-9cc9-9e149126039e","incomingCommitId","aiChatMessageId","aiChatThreadId","aiChatThreadUserId","aiChatThreadTitle","source","clientLabel","user",{"_32":66,"_40":41,"_11":12,"_67":68},{"_61":62,"_13":63,"_64":21,"_65":24},"pull","merge","revert","multiple","commits",[60],{"_32":33,"_34":35,"_36":37,"_38":39,"_40":41,"_42":43,"_44":-5,"_45":-5,"_46":-5,"_47":-5,"_48":-5,"_49":-5,"_50":-5,"_51":52,"_21":53,"_54":-5,"_55":-5,"_56":-5},"fileId","568095ca-3448-11f0-a39d-9e149126039e","index.html","fileType","deleted","dcf86e80-3442-11f0-b519-ff88f6bc2fe6","avatar","https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvb2F1dGhfZ2l0aHViL2ltZ18yeEk0TXdTZ1pDYmt1Y0FqSmFkNWwxMUx6UkMifQ","deletedAtVersion","719af482-3447-11f0-ae6c-9e149126039e",["D",1747614190177],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","A flood app that notify subscriber ahead of flooding","imageUrl","pinnedFileId","36a9b060-3448-11f0-ae10-9e149126039e","pinPreview",true,"pinMigrated","screenshotVersion","likeCount","tursoName","tursoHostname","tursoMeasuredAt","pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm",{"_11":12,"_119":68},"org",{"_11":12,"_115":-5,"_67":68,"_30":66,"_116":117,"_118":24},"branch",{"_38":106,"_13":16,"_32":35,"_107":70,"_108":-5,"_109":-5,"_110":-5,"_111":-5,"_112":-5,"_113":14,"_114":12},"isOwned",16,"projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","displayName","tier","free","canRestrictVals","profileImageUrl","adoptOrgId",{"_32":70,"_13":14,"_36":322,"_72":-5,"_73":24,"_74":75,"_76":75,"_77":78,"_79":-5,"_30":66,"_80":81,"_82":83,"_84":83,"_85":-5,"_86":26,"_40":41,"_87":-5,"_88":-5,"_89":-5,"_90":-5,"_91":92,"_93":92,"_94":95,"_96":95,"_97":95,"_98":92,"_99":92,"_51":323,"_101":324,"_103":325,"_105":24},"tree",[162,174,178,181],"files",[162,163,164,165,166,167,168,169,170,171,172,173,174,175,176,177,178,179,180,181],"counts",{"_151":26,"_152":153,"_154":26,"_155":156,"_157":158},"contents",[],{"_32":141,"_13":63,"_61":62,"_42":142,"_34":35,"_143":39,"_144":83,"_36":145,"_38":26,"_64":21,"_146":147,"_65":24,"_148":-5,"_17":149},"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},"568094f8-3448-11f0-a39d-9e149126039e","e9a061e8-ef24-41db-bd94-d9dd934280f2","branchVersion","latest",["D",1747614574199],"content","\n\n\n \n \n Osun State Flood Alert System\n \n \n \n \n\n\n \n

\n \n Osun State Flood Alert\n

\n \n \n

\n\n \n

\n \n

\n \n\n

Create Account

\n \n

\n\n \n

Your Locations

Add locations in Osun State to receive flood alerts.

\n \n \n \n

\n \n

\n No locations added yet. Add a location to get started.\n

\n\n

Flood Alerts

Recent flood alerts for your locations.

\n \n \n \n

\n \n

\n No alerts at this time. We'll notify you if flooding is predicted.\n

\n\n \n \n

\n\n \n \n\n \n \n \n \n \n \n\n","label",[150,63],"frontend","pulls","branches",1,"forks","envVars",{"_159":26,"_161":26},"connections",{"_159":26,"_160":26},"count","unfilledCount","emptyCount",{"_32":318,"_13":243,"_61":236,"_42":-5,"_34":35,"_143":309,"_144":83,"_36":319,"_38":26,"_64":209,"_146":-5,"_65":24,"_148":-5,"_187":320,"_17":321},{"_32":314,"_13":305,"_61":299,"_42":236,"_34":35,"_143":309,"_144":83,"_36":315,"_38":26,"_64":209,"_146":-5,"_65":24,"_148":-5,"_187":316,"_17":317},{"_32":306,"_13":307,"_61":308,"_42":299,"_34":35,"_143":309,"_144":83,"_36":310,"_38":26,"_64":196,"_146":311,"_65":24,"_148":-5,"_187":312,"_17":313},{"_32":296,"_13":297,"_61":298,"_42":299,"_34":35,"_143":300,"_144":83,"_36":301,"_38":26,"_64":196,"_146":302,"_65":24,"_148":-5,"_187":303,"_17":304},{"_32":292,"_13":283,"_61":277,"_42":236,"_34":35,"_143":287,"_144":83,"_36":293,"_38":26,"_64":209,"_146":-5,"_65":24,"_148":-5,"_187":294,"_17":295},{"_32":284,"_13":285,"_61":286,"_42":277,"_34":35,"_143":287,"_144":83,"_36":288,"_38":26,"_64":196,"_146":289,"_65":24,"_148":-5,"_187":290,"_17":291},{"_32":274,"_13":275,"_61":276,"_42":277,"_34":35,"_143":278,"_144":83,"_36":279,"_38":26,"_64":196,"_146":280,"_65":24,"_148":-5,"_187":281,"_17":282},{"_32":270,"_13":269,"_61":263,"_42":236,"_34":35,"_143":264,"_144":83,"_36":271,"_38":26,"_64":209,"_146":-5,"_65":24,"_148":-5,"_187":272,"_17":273},{"_32":260,"_13":261,"_61":262,"_42":263,"_34":35,"_143":264,"_144":83,"_36":265,"_38":26,"_64":196,"_146":266,"_65":24,"_148":-5,"_187":267,"_17":268},{"_32":253,"_13":183,"_61":254,"_42":236,"_34":35,"_143":255,"_144":83,"_36":256,"_38":26,"_64":21,"_146":257,"_65":24,"_148":-5,"_187":258,"_17":259},{"_32":244,"_13":245,"_61":246,"_42":236,"_34":35,"_143":247,"_144":83,"_36":248,"_38":153,"_64":249,"_146":250,"_65":24,"_148":-5,"_187":251,"_17":252},{"_32":234,"_13":235,"_61":81,"_42":236,"_34":35,"_143":237,"_144":83,"_36":238,"_38":153,"_64":239,"_146":240,"_65":24,"_148":-5,"_187":241,"_17":242},{"_32":230,"_13":150,"_61":142,"_42":-5,"_34":35,"_143":39,"_144":83,"_36":231,"_38":26,"_64":209,"_146":-5,"_65":24,"_148":-5,"_187":232,"_17":233},{"_32":223,"_13":183,"_61":224,"_42":142,"_34":35,"_143":225,"_144":83,"_36":226,"_38":26,"_64":21,"_146":227,"_65":24,"_148":-5,"_187":228,"_17":229},{"_32":141,"_13":63,"_61":62,"_42":142,"_34":35,"_143":39,"_144":83,"_36":220,"_38":26,"_64":21,"_146":147,"_65":24,"_148":-5,"_187":221,"_17":222},{"_32":212,"_13":213,"_61":214,"_42":142,"_34":35,"_143":215,"_144":83,"_36":216,"_38":26,"_64":196,"_146":217,"_65":24,"_148":-5,"_187":218,"_17":219},{"_32":207,"_13":200,"_61":193,"_42":-5,"_34":35,"_143":194,"_144":83,"_36":208,"_38":26,"_64":209,"_146":-5,"_65":24,"_148":-5,"_187":210,"_17":211},{"_32":201,"_13":183,"_61":202,"_42":193,"_34":35,"_143":106,"_144":83,"_36":203,"_38":26,"_64":21,"_146":204,"_65":24,"_148":-5,"_187":205,"_17":206},{"_32":190,"_13":191,"_61":192,"_42":193,"_34":35,"_143":194,"_144":83,"_36":195,"_38":26,"_64":196,"_146":197,"_65":24,"_148":-5,"_187":198,"_17":199},{"_32":182,"_13":183,"_61":184,"_42":-5,"_34":35,"_143":153,"_144":83,"_36":185,"_38":26,"_64":21,"_146":186,"_65":24,"_148":-5,"_187":188,"_17":189},"e29c60d0-3447-11f0-941a-9e149126039e","README.md","e29c618e-3447-11f0-941a-9e149126039e",["D",1747614379766],"# Osun State Flood Alert System\n\nA web application that allows residents of Osun State, Nigeria to receive early flood warnings based on weather forecasts.\n\n## Features\n\n- User authentication (signup and login)\n- Location management for Osun State areas\n- Flood prediction system (2 weeks in advance)\n- Email notifications for flood alerts\n\n## Project Structure\n\n- `/backend` - Server-side code and API endpoints\n- `/frontend` - User interface and client-side code\n- `/shared` - Shared types and utilities\n\n## Technologies\n\n- Backend: Hono (TypeScript)\n- Database: SQLite\n- Frontend: HTML, JavaScript, Tailwind CSS\n- Weather Data: Open-Meteo API\n- Notifications: Email\n\n## How It Works\n\n1. Users sign up with their email and basic details\n2. After login, users can add their location within Osun State\n3. The system checks weather forecasts daily for potential flooding\n4. If flooding is predicted in the next 2 weeks, users receive email notifications","children",[],[183],"fc9d0764-3447-11f0-b18f-9e149126039e","utils.ts","fc9d0836-3447-11f0-b18f-9e149126039e","f0761535-fa4a-4070-b884-3f75c73e7beb",4,["D",1747614423388],"script","// Shared types and utilities for both frontend and backend\n\n// User types (without sensitive data)\nexport interface UserInfo {\n id: number;\n email: string;\n name: string;\n}\n\n// Location types\nexport interface LocationInfo {\n id: number;\n name: string;\n latitude: number;\n longitude: number;\n created_at: string;\n}\n\n// Alert types\nexport interface AlertInfo {\n id: number;\n location_id: number;\n location_name: string;\n alert_date: string;\n message: string;\n created_at: string;\n}\n\n// Auth types\nexport interface SignupRequest {\n email: string;\n password: string;\n name: string;\n}\n\nexport interface LoginRequest {\n email: string;\n password: string;\n}\n\nexport interface AuthResponse {\n user: UserInfo;\n token: string;\n}\n\n// Location types\nexport interface AddLocationRequest {\n name: string;\n latitude: number;\n longitude: number;\n}\n\n// Osun State boundaries (approximate)\nexport const OSUN_STATE_BOUNDS = {\n north: 8.1, // Northern latitude boundary\n south: 7.0, // Southern latitude boundary\n east: 5.1, // Eastern longitude boundary\n west: 4.0 // Western longitude boundary\n};\n\n// Check if coordinates are within Osun State\nexport function isInOsunState(latitude: number, longitude: number): boolean {\n return (\n latitude >= OSUN_STATE_BOUNDS.south &&\n latitude <= OSUN_STATE_BOUNDS.north &&\n longitude >= OSUN_STATE_BOUNDS.west &&\n longitude <= OSUN_STATE_BOUNDS.east\n );\n}\n\n// Format date for display\nexport function formatDate(dateString: string): string {\n const date = new Date(dateString);\n return date.toLocaleDateString('en-NG', {\n weekday: 'long',\n year: 'numeric',\n month: 'long',\n day: 'numeric'\n });\n}",[],[200,191],"shared","8b47051e-3448-11f0-8579-9e149126039e","8b4705fa-3448-11f0-8579-9e149126039e",["D",1747614662743],"# Shared\n\nThis directory contains code that is shared between the frontend and backend.\n\n## Files\n\n- `utils.ts` - Shared types, interfaces, and utility functions\n\n## Types\n\n- `UserInfo` - User information (without sensitive data)\n- `LocationInfo` - Location information\n- `AlertInfo` - Alert information\n- `SignupRequest` - Request body for signup\n- `LoginRequest` - Request body for login\n- `AuthResponse` - Response for authentication\n- `AddLocationRequest` - Request body for adding a location\n\n## Constants\n\n- `OSUN_STATE_BOUNDS` - Geographic boundaries of Osun State, Nigeria\n\n## Utility Functions\n\n- `isInOsunState(latitude, longitude)` - Check if coordinates are within Osun State\n- `formatDate(dateString)` - Format a date string for display",[],[200,183],"fc9d2a5a-3447-11f0-b18f-9e149126039e",["D",1747614423388],"directory",[179,180],[200],"797b2d24-3448-11f0-a39d-9e149126039e","index.js","797b2e3c-3448-11f0-a39d-9e149126039e",13,["D",1747614632881],"import { isInOsunState, OSUN_STATE_BOUNDS, formatDate } from '../shared/utils.ts';\n\n// State management\nconst state = {\n user: null,\n token: null,\n locations: [],\n alerts: [],\n map: null,\n marker: null\n};\n\n// API base URL\nconst API_BASE_URL = '';\n\n// DOM Elements\nconst elements = {\n // Auth elements\n authContainer: document.getElementById('auth-container'),\n authButtons: document.getElementById('auth-buttons'),\n userInfo: document.getElementById('user-info'),\n userName: document.getElementById('user-name'),\n loginBtn: document.getElementById('login-btn'),\n signupBtn: document.getElementById('signup-btn'),\n logoutBtn: document.getElementById('logout-btn'),\n loginForm: document.getElementById('login-form'),\n signupForm: document.getElementById('signup-form'),\n loginFormElement: document.getElementById('login-form-element'),\n signupFormElement: document.getElementById('signup-form-element'),\n showLoginLink: document.getElementById('show-login'),\n showSignupLink: document.getElementById('show-signup'),\n \n // Dashboard elements\n dashboard: document.getElementById('dashboard'),\n locationsList: document.getElementById('locations-list'),\n alertsList: document.getElementById('alerts-list'),\n addLocationBtn: document.getElementById('add-location-btn'),\n checkFloodsBtn: document.getElementById('check-floods-btn'),\n \n // Location modal elements\n locationModal: document.getElementById('location-modal'),\n closeModalBtn: document.getElementById('close-modal-btn'),\n addLocationForm: document.getElementById('add-location-form'),\n locationName: document.getElementById('location-name'),\n latitude: document.getElementById('latitude'),\n longitude: document.getElementById('longitude'),\n locationError: document.getElementById('location-error'),\n \n // Map element\n map: document.getElementById('map'),\n \n // View source link\n viewSource: document.getElementById('view-source')\n};\n\n// Initialize the application\nfunction init() {\n // Set up event listeners\n setupEventListeners();\n \n // Check if user is logged in\n const savedToken = localStorage.getItem('token');\n const savedUser = localStorage.getItem('user');\n \n if (savedToken && savedUser) {\n try {\n state.token = savedToken;\n state.user = JSON.parse(savedUser);\n showDashboard();\n } catch (error) {\n console.error('Error parsing saved user:', error);\n logout();\n }\n }\n \n // Set view source link\n if (window.__PROJECT_URL__) {\n elements.viewSource.href = window.__PROJECT_URL__;\n }\n}\n\n// Set up event listeners\nfunction setupEventListeners() {\n // Auth navigation\n elements.loginBtn.addEventListener('click', () => showElement(elements.authContainer));\n elements.signupBtn.addEventListener('click', () => {\n showElement(elements.authContainer);\n showSignupForm();\n });\n elements.showLoginLink.addEventListener('click', showLoginForm);\n elements.showSignupLink.addEventListener('click', showSignupForm);\n elements.logoutBtn.addEventListener('click', logout);\n \n // Form submissions\n elements.loginFormElement.addEventListener('submit', handleLogin);\n elements.signupFormElement.addEventListener('submit', handleSignup);\n \n // Dashboard actions\n elements.addLocationBtn.addEventListener('click', showLocationModal);\n elements.closeModalBtn.addEventListener('click', hideLocationModal);\n elements.addLocationForm.addEventListener('submit', handleAddLocation);\n elements.checkFloodsBtn.addEventListener('click', checkForFloods);\n}\n\n// Show login form\nfunction showLoginForm(e) {\n if (e) e.preventDefault();\n elements.signupForm.classList.add('hidden');\n elements.loginForm.classList.remove('hidden');\n}\n\n// Show signup form\nfunction showSignupForm(e) {\n if (e) e.preventDefault();\n elements.loginForm.classList.add('hidden');\n elements.signupForm.classList.remove('hidden');\n}\n\n// Show dashboard\nfunction showDashboard() {\n elements.authContainer.classList.add('hidden');\n elements.authButtons.classList.add('hidden');\n elements.userInfo.classList.remove('hidden');\n elements.dashboard.classList.remove('hidden');\n \n // Set user name\n elements.userName.textContent = state.user.name;\n \n // Load user data\n loadLocations();\n loadAlerts();\n}\n\n// Show element\nfunction showElement(element) {\n element.classList.remove('hidden');\n}\n\n// Hide element\nfunction hideElement(element) {\n element.classList.add('hidden');\n}\n\n// Handle login\nasync function handleLogin(e) {\n e.preventDefault();\n \n const email = document.getElementById('login-email').value;\n const password = document.getElementById('login-password').value;\n \n try {\n const response = await fetch(`${API_BASE_URL}/api/auth/login`, {\n method: 'POST',\n headers: {\n 'Content-Type': 'application/json'\n },\n body: JSON.stringify({ email, password })\n });\n \n const data = await response.json();\n \n if (!response.ok) {\n throw new Error(data.error || 'Login failed');\n }\n \n // Save user data\n state.user = data.user;\n state.token = data.token;\n \n // Save to local storage\n localStorage.setItem('user', JSON.stringify(data.user));\n localStorage.setItem('token', data.token);\n \n // Show dashboard\n showDashboard();\n \n // Reset form\n elements.loginFormElement.reset();\n } catch (error) {\n alert(error.message);\n }\n}\n\n// Handle signup\nasync function handleSignup(e) {\n e.preventDefault();\n \n const name = document.getElementById('signup-name').value;\n const email = document.getElementById('signup-email').value;\n const password = document.getElementById('signup-password').value;\n \n try {\n const response = await fetch(`${API_BASE_URL}/api/auth/signup`, {\n method: 'POST',\n headers: {\n 'Content-Type': 'application/json'\n },\n body: JSON.stringify({ name, email, password })\n });\n \n const data = await response.json();\n \n if (!response.ok) {\n throw new Error(data.error || 'Signup failed');\n }\n \n // Save user data\n state.user = data.user;\n state.token = data.token;\n \n // Save to local storage\n localStorage.setItem('user', JSON.stringify(data.user));\n localStorage.setItem('token', data.token);\n \n // Show dashboard\n showDashboard();\n \n // Reset form\n elements.signupFormElement.reset();\n } catch (error) {\n alert(error.message);\n }\n}\n\n// Logout\nfunction logout() {\n // Clear state\n state.user = null;\n state.token = null;\n state.locations = [];\n state.alerts = [];\n \n // Clear local storage\n localStorage.removeItem('user');\n localStorage.removeItem('token');\n \n // Hide dashboard\n elements.dashboard.classList.add('hidden');\n elements.userInfo.classList.add('hidden');\n elements.authButtons.classList.remove('hidden');\n \n // Show login form\n showLoginForm();\n}\n\n// Load user locations\nasync function loadLocations() {\n try {\n const response = await fetch(`${API_BASE_URL}/api/locations`, {\n headers: {\n 'Authorization': `Bearer ${state.token}`\n }\n });\n \n const data = await response.json();\n \n if (!response.ok) {\n throw new Error(data.error || 'Failed to load locations');\n }\n \n state.locations = data.locations;\n renderLocations();\n } catch (error) {\n console.error('Error loading locations:', error);\n }\n}\n\n// Render locations\nfunction renderLocations() {\n if (state.locations.length === 0) {\n elements.locationsList.innerHTML = `\n

\n No locations added yet. Add a location to get started.\n

\n `;\n return;\n }\n \n elements.locationsList.innerHTML = state.locations.map(location => `\n

${location.name}

\n \n ${location.latitude.toFixed(6)}, ${location.longitude.toFixed(6)}\n

Added on ${new Date(location.created_at).toLocaleDateString()}

\n \n

\n `).join('');\n \n // Add event listeners to delete buttons\n document.querySelectorAll('.delete-location-btn').forEach(button => {\n button.addEventListener('click', () => deleteLocation(button.dataset.id));\n });\n}\n\n// Delete location\nasync function deleteLocation(locationId) {\n if (!confirm('Are you sure you want to delete this location?')) {\n return;\n }\n \n try {\n const response = await fetch(`${API_BASE_URL}/api/locations/${locationId}`, {\n method: 'DELETE',\n headers: {\n 'Authorization': `Bearer ${state.token}`\n }\n });\n \n const data = await response.json();\n \n if (!response.ok) {\n throw new Error(data.error || 'Failed to delete location');\n }\n \n // Reload locations\n loadLocations();\n } catch (error) {\n alert(error.message);\n }\n}\n\n// Load alerts\nasync function loadAlerts() {\n // This would be an API call to get alerts\n // For now, we'll just use a placeholder\n state.alerts = [];\n renderAlerts();\n}\n\n// Render alerts\nfunction renderAlerts() {\n if (state.alerts.length === 0) {\n elements.alertsList.innerHTML = `\n

\n No alerts at this time. We'll notify you if flooding is predicted.\n

\n `;\n return;\n }\n \n elements.alertsList.innerHTML = state.alerts.map(alert => `\n

\n \n

Alert for ${alert.location_name}

${alert.message}

\n \n ${formatDate(alert.alert_date)}\n

\n `).join('');\n}\n\n// Show location modal\nfunction showLocationModal() {\n elements.locationModal.classList.remove('hidden');\n elements.locationError.classList.add('hidden');\n elements.addLocationForm.reset();\n \n // Initialize map if not already initialized\n if (!state.map) {\n initMap();\n }\n}\n\n// Hide location modal\nfunction hideLocationModal() {\n elements.locationModal.classList.add('hidden');\n}\n\n// Initialize map\nfunction initMap() {\n // Center of Osun State\n const osunCenter = [7.5, 4.5];\n \n // Create map\n state.map = L.map('map').setView(osunCenter, 9);\n \n // Add tile layer\n L.tileLayer('https://{s}.tile.openstreetmap.org/{z}/{x}/{y}.png', {\n attribution: '© OpenStreetMap contributors'\n }).addTo(state.map);\n \n // Add Osun State boundary (approximate)\n const osunBounds = [\n [OSUN_STATE_BOUNDS.south, OSUN_STATE_BOUNDS.west],\n [OSUN_STATE_BOUNDS.north, OSUN_STATE_BOUNDS.east]\n ];\n \n L.rectangle(osunBounds, {\n color: '#3B82F6',\n weight: 2,\n fillOpacity: 0.1\n }).addTo(state.map);\n \n // Add click event to map\n state.map.on('click', function(e) {\n const lat = e.latlng.lat;\n const lng = e.latlng.lng;\n \n // Update form fields\n elements.latitude.value = lat.toFixed(6);\n elements.longitude.value = lng.toFixed(6);\n \n // Check if location is in Osun State\n if (isInOsunState(lat, lng)) {\n elements.locationError.classList.add('hidden');\n } else {\n elements.locationError.classList.remove('hidden');\n }\n \n // Add or move marker\n if (state.marker) {\n state.marker.setLatLng(e.latlng);\n } else {\n state.marker = L.marker(e.latlng).addTo(state.map);\n }\n });\n \n // Invalidate size to ensure map renders correctly\n setTimeout(() => {\n state.map.invalidateSize();\n }, 100);\n}\n\n// Handle add location\nasync function handleAddLocation(e) {\n e.preventDefault();\n \n const name = elements.locationName.value;\n const latitude = parseFloat(elements.latitude.value);\n const longitude = parseFloat(elements.longitude.value);\n \n // Validate inputs\n if (!name || isNaN(latitude) || isNaN(longitude)) {\n alert('Please fill in all fields and select a location on the map.');\n return;\n }\n \n // Check if location is in Osun State\n if (!isInOsunState(latitude, longitude)) {\n elements.locationError.classList.remove('hidden');\n return;\n }\n \n try {\n const response = await fetch(`${API_BASE_URL}/api/locations`, {\n method: 'POST',\n headers: {\n 'Content-Type': 'application/json',\n 'Authorization': `Bearer ${state.token}`\n },\n body: JSON.stringify({ name, latitude, longitude })\n });\n \n const data = await response.json();\n \n if (!response.ok) {\n throw new Error(data.error || 'Failed to add location');\n }\n \n // Hide modal\n hideLocationModal();\n \n // Reload locations\n loadLocations();\n \n // Reset form\n elements.addLocationForm.reset();\n \n // Remove marker\n if (state.marker) {\n state.map.removeLayer(state.marker);\n state.marker = null;\n }\n } catch (error) {\n alert(error.message);\n }\n}\n\n// Check for floods\nasync function checkForFloods() {\n if (state.locations.length === 0) {\n alert('Please add at least one location to check for floods.');\n return;\n }\n \n try {\n elements.checkFloodsBtn.disabled = true;\n elements.checkFloodsBtn.innerHTML = ' Checking...';\n \n const response = await fetch(`${API_BASE_URL}/api/check-floods`, {\n method: 'POST',\n headers: {\n 'Content-Type': 'application/json',\n 'Authorization': `Bearer ${state.token}`\n },\n body: JSON.stringify({ userId: state.user.id })\n });\n \n const data = await response.json();\n \n if (!response.ok) {\n throw new Error(data.error || 'Failed to check for floods');\n }\n \n // Show message\n alert(data.message);\n \n // Reload alerts\n loadAlerts();\n } catch (error) {\n alert(error.message);\n } finally {\n elements.checkFloodsBtn.disabled = false;\n elements.checkFloodsBtn.innerHTML = ' Check for Floods';\n }\n}\n\n// Initialize the application\ninit();",[],[150,213],["D",1747614574199],[],[150,63],"85928c92-3448-11f0-b155-9e149126039e","85928e40-3448-11f0-b155-9e149126039e",15,["D",1747614653171],"# Frontend\n\nThis directory contains the client-side code for the Osun State Flood Alert System.\n\n## Structure\n\n- `index.html` - Main HTML template\n- `index.js` - JavaScript for the application\n\n## Features\n\n- User authentication (signup and login)\n- Location management with map interface\n- Flood alerts display\n- Manual flood checking\n\n## Technologies\n\n- HTML, JavaScript\n- Tailwind CSS for styling\n- Leaflet.js for maps\n- Font Awesome for icons\n\n## User Flow\n\n1. User signs up or logs in\n2. User adds locations within Osun State using the map\n3. User can check for potential floods manually\n4. Alerts are displayed if flooding is predicted",[],[150,183],"5680c5b8-3448-11f0-a39d-9e149126039e",["D",1747614574199],[175,176,177],[150],"3afef828-3448-11f0-9cc9-9e149126039e","index.ts","494901c2-9114-474e-8493-8fd4d96b25e0",11,["D",1747614528050],"http","import { Hono } from \"https://esm.sh/hono@3.11.7\";\nimport { cors } from \"https://esm.sh/hono@3.11.7/middleware\";\nimport { readFile, serveFile } from \"https://esm.town/v/std/utils@85-main/index.ts\";\nimport { runMigrations } from \"./database/migrations.ts\";\nimport auth from \"./routes/auth.ts\";\nimport locations from \"./routes/locations.ts\";\nimport { createFloodAlertsForUser } from \"./services/floodPredictor.ts\";\n\n// Initialize app\nconst app = new Hono();\n\n// Unwrap Hono errors to see original error details\napp.onError((err, c) => {\n console.error(\"Error:\", err);\n throw err;\n});\n\n// Apply CORS middleware\napp.use(\"*\", cors());\n\n// Initialize database\napp.use(\"*\", async (c, next) => {\n try {\n await runMigrations();\n } catch (error) {\n console.error(\"Database migration error:\", error);\n }\n await next();\n});\n\n// API routes\napp.route(\"/api/auth\", auth);\napp.route(\"/api/locations\", locations);\n\n// Check for floods for a specific user\napp.post(\"/api/check-floods\", async (c) => {\n try {\n const { userId } = await c.req.json();\n \n if (!userId) {\n return c.json({ error: \"User ID is required\" }, 400);\n }\n \n const alertsCreated = await createFloodAlertsForUser(userId);\n \n return c.json({ \n success: true, \n alertsCreated,\n message: alertsCreated > 0 \n ? `Created ${alertsCreated} flood alerts` \n : \"No flooding predicted in the next 2 weeks\" \n });\n } catch (error) {\n console.error(\"Check floods error:\", error);\n return c.json({ error: \"Failed to check for floods\" }, 500);\n }\n});\n\n// Serve static files\napp.get(\"/frontend/*\", c => serveFile(c.req.path, import.meta.url));\napp.get(\"/shared/*\", c => serveFile(c.req.path, import.meta.url));\n\n// Serve index.html for root path\napp.get(\"/\", async c => {\n try {\n let html = await readFile(\"/frontend/index.html\", import.meta.url);\n \n // Add project info for view source link\n const viewSourceUrl = import.meta.url.replace(\"esm.sh\", \"val.town\");\n const dataScript = ``;\n \n html = html.replace(\"\", `${dataScript}`);\n \n return c.html(html);\n } catch (error) {\n console.error(\"Error serving index.html:\", error);\n return c.text(\"Error loading application\", 500);\n }\n});\n\n// This is the entry point for HTTP vals\nexport default app.fetch;",[],[243,235],"backend","2cf54700-3448-11f0-86af-9e149126039e","cron.ts","2a2b9ce0-3448-11f0-8422-9e149126039e",9,["D",1747614504499],"interval","import { runMigrations } from \"./database/migrations.ts\";\nimport { getUserById, getPendingAlerts, markAlertAsSent } from \"./database/queries.ts\";\nimport { sendFloodAlertEmail } from \"./services/floodPredictor.ts\";\nimport { formatDate } from \"../shared/utils.ts\";\n\n// Run daily to check for floods and send alerts\nexport default async function() {\n console.log(\"Running flood alert cron job...\");\n \n try {\n // Ensure database tables exist\n await runMigrations();\n \n // Get all pending alerts\n const pendingAlerts = await getPendingAlerts();\n console.log(`Found ${pendingAlerts.length} pending alerts`);\n \n // Send email for each alert\n for (const alert of pendingAlerts) {\n const user = await getUserById(alert.user_id);\n \n if (!user) {\n console.error(`User not found for alert ${alert.id}`);\n continue;\n }\n \n const formattedDate = formatDate(alert.alert_date);\n \n const sent = await sendFloodAlertEmail(\n user.email,\n user.name,\n alert.location_name,\n formattedDate,\n alert.message\n );\n \n if (sent) {\n await markAlertAsSent(alert.id);\n console.log(`Sent alert ${alert.id} to ${user.email}`);\n }\n }\n \n console.log(\"Flood alert cron job completed\");\n } catch (error) {\n console.error(\"Error in flood alert cron job:\", error);\n }\n}",[],[243,245],"7f43d206-3448-11f0-874a-9e149126039e","7f43d2d8-3448-11f0-874a-9e149126039e",14,["D",1747614642589],"# Backend\n\nThis directory contains the server-side code for the Osun State Flood Alert System.\n\n## Structure\n\n- `index.ts` - Main entry point for the HTTP API\n- `cron.ts` - Scheduled job to check for floods and send alerts\n- `database/` - Database schema and queries\n- `routes/` - API route handlers\n- `services/` - Business logic services\n\n## API Endpoints\n\n### Authentication\n\n- `POST /api/auth/signup` - Create a new user account\n- `POST /api/auth/login` - Log in to an existing account\n- `GET /api/auth/me` - Get current user information\n\n### Locations\n\n- `GET /api/locations` - Get all locations for the current user\n- `POST /api/locations` - Add a new location\n- `GET /api/locations/:id` - Get a specific location\n- `DELETE /api/locations/:id` - Delete a location\n\n### Flood Checking\n\n- `POST /api/check-floods` - Check for potential floods for a user's locations\n\n## Cron Job\n\nThe `cron.ts` file contains a scheduled job that runs daily to:\n\n1. Check for pending flood alerts\n2. Send email notifications to users\n3. Mark alerts as sent\n\n## Environment Variables\n\n- `JWT_SECRET` - Secret key for JWT token generation (optional, has default)",[],[243,183],"21299f16-3448-11f0-8dad-9e149126039e","floodPredictor.ts","2129a01a-3448-11f0-8dad-9e149126039e","3ef83286-fd0a-473e-894e-c0b0e8b7b867",7,["D",1747614484710],"import { Location, createAlert, getLocationsByUserId, getUserById } from \"../database/queries.ts\";\nimport { email } from \"https://esm.town/v/std/email\";\n\n// Threshold for rainfall that might cause flooding (in mm)\nconst RAINFALL_THRESHOLD = 50; // Adjust based on local conditions\n\n// Open-Meteo API for weather forecasts\nconst WEATHER_API_URL = \"https://api.open-meteo.com/v1/forecast\";\n\ninterface WeatherForecast {\n daily: {\n time: string[];\n precipitation_sum: number[];\n };\n}\n\n// Get weather forecast for a location\nasync function getWeatherForecast(latitude: number, longitude: number): Promise {\n const url = new URL(WEATHER_API_URL);\n url.searchParams.append(\"latitude\", latitude.toString());\n url.searchParams.append(\"longitude\", longitude.toString());\n url.searchParams.append(\"daily\", \"precipitation_sum\");\n url.searchParams.append(\"timezone\", \"Africa/Lagos\");\n url.searchParams.append(\"forecast_days\", \"14\"); // 2 weeks forecast\n\n const response = await fetch(url.toString());\n \n if (!response.ok) {\n throw new Error(`Weather API error: ${response.statusText}`);\n }\n \n return await response.json();\n}\n\n// Check if flooding is likely based on rainfall\nfunction isFloodingLikely(precipitationSum: number): boolean {\n return precipitationSum > RAINFALL_THRESHOLD;\n}\n\n// Predict flooding for a location\nasync function predictFloodingForLocation(location: Location): Promise<{ date: string, rainfall: number } | null> {\n try {\n const forecast = await getWeatherForecast(location.latitude, location.longitude);\n \n // Check each day in the forecast\n for (let i = 0; i < forecast.daily.time.length; i++) {\n const date = forecast.daily.time[i];\n const rainfall = forecast.daily.precipitation_sum[i];\n \n if (isFloodingLikely(rainfall)) {\n return { date, rainfall };\n }\n }\n \n return null; // No flooding predicted\n } catch (error) {\n console.error(`Error predicting flooding for location ${location.id}:`, error);\n return null;\n }\n}\n\n// Create flood alerts for a user's locations\nexport async function createFloodAlertsForUser(userId: number): Promise {\n try {\n const locations = await getLocationsByUserId(userId);\n let alertsCreated = 0;\n \n for (const location of locations) {\n const floodPrediction = await predictFloodingForLocation(location);\n \n if (floodPrediction) {\n const message = `Potential flooding predicted on ${floodPrediction.date} with expected rainfall of ${floodPrediction.rainfall}mm.`;\n \n await createAlert(userId, location.id, floodPrediction.date, message);\n alertsCreated++;\n }\n }\n \n return alertsCreated;\n } catch (error) {\n console.error(`Error creating flood alerts for user ${userId}:`, error);\n return 0;\n }\n}\n\n// Send email notification for a flood alert\nexport async function sendFloodAlertEmail(userEmail: string, userName: string, locationName: string, alertDate: string, message: string): Promise {\n try {\n await email({\n to: userEmail,\n subject: `⚠️ Flood Alert for ${locationName}`,\n text: `Hello ${userName},\\n\\nWe are sending this alert to inform you of potential flooding in ${locationName} on ${alertDate}.\\n\\n${message}\\n\\nPlease take necessary precautions.\\n\\nStay safe,\\nOsun State Flood Alert System`,\n html: `\n

⚠️ Flood Alert

Hello ${userName},

We are sending this alert to inform you of potential flooding in ${locationName} on ${alertDate}.

${message}

Please take necessary precautions.

Stay safe,
Osun State Flood Alert System

\n `\n });\n \n return true;\n } catch (error) {\n console.error(`Error sending flood alert email to ${userEmail}:`, error);\n return false;\n }\n}",[],[243,269,261],"services","2129c428-3448-11f0-8dad-9e149126039e",["D",1747614484710],[170],[243,269],"1635e74a-3448-11f0-affd-9e149126039e","locations.ts","1635e808-3448-11f0-affd-9e149126039e","5ac05d44-0472-428d-add2-8df9f4c509aa",6,["D",1747614466333],"import { Hono } from \"https://esm.sh/hono@3.11.7\";\nimport { \n createLocation, \n getLocationsByUserId, \n getLocationById, \n deleteLocation \n} from \"../database/queries.ts\";\nimport { authMiddleware } from \"./auth.ts\";\nimport { AddLocationRequest, isInOsunState } from \"../../shared/utils.ts\";\n\nconst locations = new Hono();\n\n// Apply auth middleware to all routes\nlocations.use(\"*\", authMiddleware);\n\n// Get all locations for the current user\nlocations.get(\"/\", async (c) => {\n try {\n const userId = c.get(\"userId\");\n const userLocations = await getLocationsByUserId(userId);\n \n return c.json({ locations: userLocations });\n } catch (error) {\n console.error(\"Get locations error:\", error);\n return c.json({ error: \"Failed to fetch locations\" }, 500);\n }\n});\n\n// Add a new location\nlocations.post(\"/\", async (c) => {\n try {\n const userId = c.get(\"userId\");\n const data = await c.req.json();\n \n // Validate input\n if (!data.name || data.latitude === undefined || data.longitude === undefined) {\n return c.json({ error: \"Name, latitude, and longitude are required\" }, 400);\n }\n \n // Check if location is within Osun State\n if (!isInOsunState(data.latitude, data.longitude)) {\n return c.json({ error: \"Location must be within Osun State, Nigeria\" }, 400);\n }\n \n // Create location\n const locationId = await createLocation(userId, data.name, data.latitude, data.longitude);\n \n // Get the created location\n const location = await getLocationById(locationId);\n \n return c.json({ location }, 201);\n } catch (error) {\n console.error(\"Add location error:\", error);\n return c.json({ error: \"Failed to add location\" }, 500);\n }\n});\n\n// Get a specific location\nlocations.get(\"/:id\", async (c) => {\n try {\n const userId = c.get(\"userId\");\n const locationId = parseInt(c.req.param(\"id\"));\n \n if (isNaN(locationId)) {\n return c.json({ error: \"Invalid location ID\" }, 400);\n }\n \n const location = await getLocationById(locationId);\n \n if (!location) {\n return c.json({ error: \"Location not found\" }, 404);\n }\n \n // Check if the location belongs to the user\n if (location.user_id !== userId) {\n return c.json({ error: \"Unauthorized\" }, 403);\n }\n \n return c.json({ location });\n } catch (error) {\n console.error(\"Get location error:\", error);\n return c.json({ error: \"Failed to fetch location\" }, 500);\n }\n});\n\n// Delete a location\nlocations.delete(\"/:id\", async (c) => {\n try {\n const userId = c.get(\"userId\");\n const locationId = parseInt(c.req.param(\"id\"));\n \n if (isNaN(locationId)) {\n return c.json({ error: \"Invalid location ID\" }, 400);\n }\n \n const location = await getLocationById(locationId);\n \n if (!location) {\n return c.json({ error: \"Location not found\" }, 404);\n }\n \n // Check if the location belongs to the user\n if (location.user_id !== userId) {\n return c.json({ error: \"Unauthorized\" }, 403);\n }\n \n const deleted = await deleteLocation(locationId, userId);\n \n if (!deleted) {\n return c.json({ error: \"Failed to delete location\" }, 500);\n }\n \n return c.json({ success: true });\n } catch (error) {\n console.error(\"Delete location error:\", error);\n return c.json({ error: \"Failed to delete location\" }, 500);\n }\n});\n\nexport default locations;",[],[243,283,275],"routes","0c449218-3448-11f0-aa2a-9e149126039e","auth.ts","0c44931c-3448-11f0-aa2a-9e149126039e",5,["D",1747614449649],"import { Hono } from \"https://esm.sh/hono@3.11.7\";\nimport { createUser, getUserByEmail } from \"../database/queries.ts\";\nimport { SignupRequest, LoginRequest, AuthResponse } from \"../../shared/utils.ts\";\nimport * as bcrypt from \"https://deno.land/x/bcrypt@v0.4.1/mod.ts\";\nimport { create, verify } from \"https://deno.land/x/djwt@v2.8/mod.ts\";\n\nconst auth = new Hono();\n\n// Secret key for JWT\nconst JWT_SECRET = new TextEncoder().encode(\n Deno.env.get(\"JWT_SECRET\") || \"flood-app-secret-key-change-in-production\"\n);\n\n// Generate JWT token\nasync function generateToken(userId: number): Promise {\n return await create(\n { alg: \"HS256\", typ: \"JWT\" },\n { sub: userId.toString(), exp: Date.now() / 1000 + 60 * 60 * 24 * 7 }, // 7 days\n JWT_SECRET\n );\n}\n\n// Verify JWT token\nexport async function verifyToken(token: string): Promise {\n try {\n const payload = await verify(token, JWT_SECRET);\n return parseInt(payload.sub as string);\n } catch (error) {\n return null;\n }\n}\n\n// Middleware to check authentication\nexport async function authMiddleware(c: any, next: any) {\n const authHeader = c.req.header(\"Authorization\");\n \n if (!authHeader || !authHeader.startsWith(\"Bearer \")) {\n return c.json({ error: \"Unauthorized\" }, 401);\n }\n \n const token = authHeader.split(\" \")[1];\n const userId = await verifyToken(token);\n \n if (!userId) {\n return c.json({ error: \"Invalid token\" }, 401);\n }\n \n c.set(\"userId\", userId);\n await next();\n}\n\n// Signup route\nauth.post(\"/signup\", async (c) => {\n try {\n const data = await c.req.json();\n \n // Validate input\n if (!data.email || !data.password || !data.name) {\n return c.json({ error: \"Email, password, and name are required\" }, 400);\n }\n \n // Check if user already exists\n const existingUser = await getUserByEmail(data.email);\n if (existingUser) {\n return c.json({ error: \"Email already registered\" }, 409);\n }\n \n // Hash password\n const passwordHash = await bcrypt.hash(data.password);\n \n // Create user\n const userId = await createUser(data.email, passwordHash, data.name);\n \n // Generate token\n const token = await generateToken(userId);\n \n // Return user info and token\n const response: AuthResponse = {\n user: {\n id: userId,\n email: data.email,\n name: data.name\n },\n token\n };\n \n return c.json(response, 201);\n } catch (error) {\n console.error(\"Signup error:\", error);\n return c.json({ error: \"Failed to create user\" }, 500);\n }\n});\n\n// Login route\nauth.post(\"/login\", async (c) => {\n try {\n const data = await c.req.json();\n \n // Validate input\n if (!data.email || !data.password) {\n return c.json({ error: \"Email and password are required\" }, 400);\n }\n \n // Get user\n const user = await getUserByEmail(data.email);\n if (!user) {\n return c.json({ error: \"Invalid email or password\" }, 401);\n }\n \n // Verify password\n const passwordMatch = await bcrypt.compare(data.password, user.password_hash);\n if (!passwordMatch) {\n return c.json({ error: \"Invalid email or password\" }, 401);\n }\n \n // Generate token\n const token = await generateToken(user.id);\n \n // Return user info and token\n const response: AuthResponse = {\n user: {\n id: user.id,\n email: user.email,\n name: user.name\n },\n token\n };\n \n return c.json(response);\n } catch (error) {\n console.error(\"Login error:\", error);\n return c.json({ error: \"Failed to login\" }, 500);\n }\n});\n\n// Get current user\nauth.get(\"/me\", authMiddleware, async (c) => {\n const userId = c.get(\"userId\");\n \n return c.json({\n user: {\n id: userId,\n // Other user data would be fetched from the database here\n }\n });\n});\n\nexport default auth;",[],[243,283,285],"0c44befa-3448-11f0-aa2a-9e149126039e",["D",1747614449649],[167,168],[243,283],"f4cd9bc0-3447-11f0-93a7-9e149126039e","queries.ts","f4cd9c88-3447-11f0-93a7-9e149126039e","9cf75c7d-cd49-45df-8942-278f9ddd13bf",3,["D",1747614410288],"import { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\nimport { USERS_TABLE, LOCATIONS_TABLE, ALERTS_TABLE } from \"./migrations.ts\";\n\n// User types\nexport interface User {\n id: number;\n email: string;\n name: string;\n created_at: string;\n}\n\nexport interface UserWithPassword extends User {\n password_hash: string;\n}\n\n// Location types\nexport interface Location {\n id: number;\n user_id: number;\n name: string;\n latitude: number;\n longitude: number;\n created_at: string;\n}\n\n// Alert types\nexport interface Alert {\n id: number;\n user_id: number;\n location_id: number;\n alert_date: string;\n message: string;\n is_sent: boolean;\n created_at: string;\n}\n\n// User queries\nexport async function createUser(email: string, passwordHash: string, name: string): Promise {\n const result = await sqlite.execute(\n `INSERT INTO ${USERS_TABLE} (email, password_hash, name) VALUES (?, ?, ?) RETURNING id`,\n [email, passwordHash, name]\n );\n return result.rows[0].id;\n}\n\nexport async function getUserByEmail(email: string): Promise {\n const result = await sqlite.execute(\n `SELECT * FROM ${USERS_TABLE} WHERE email = ?`,\n [email]\n );\n return result.rows[0] || null;\n}\n\nexport async function getUserById(id: number): Promise {\n const result = await sqlite.execute(\n `SELECT id, email, name, created_at FROM ${USERS_TABLE} WHERE id = ?`,\n [id]\n );\n return result.rows[0] || null;\n}\n\n// Location queries\nexport async function createLocation(userId: number, name: string, latitude: number, longitude: number): Promise {\n const result = await sqlite.execute(\n `INSERT INTO ${LOCATIONS_TABLE} (user_id, name, latitude, longitude) VALUES (?, ?, ?, ?) RETURNING id`,\n [userId, name, latitude, longitude]\n );\n return result.rows[0].id;\n}\n\nexport async function getLocationsByUserId(userId: number): Promise {\n const result = await sqlite.execute(\n `SELECT * FROM ${LOCATIONS_TABLE} WHERE user_id = ?`,\n [userId]\n );\n return result.rows;\n}\n\nexport async function getLocationById(id: number): Promise {\n const result = await sqlite.execute(\n `SELECT * FROM ${LOCATIONS_TABLE} WHERE id = ?`,\n [id]\n );\n return result.rows[0] || null;\n}\n\nexport async function deleteLocation(id: number, userId: number): Promise {\n const result = await sqlite.execute(\n `DELETE FROM ${LOCATIONS_TABLE} WHERE id = ? AND user_id = ?`,\n [id, userId]\n );\n return result.rowsAffected > 0;\n}\n\n// Alert queries\nexport async function createAlert(userId: number, locationId: number, alertDate: string, message: string): Promise {\n const result = await sqlite.execute(\n `INSERT INTO ${ALERTS_TABLE} (user_id, location_id, alert_date, message) VALUES (?, ?, ?, ?) RETURNING id`,\n [userId, locationId, alertDate, message]\n );\n return result.rows[0].id;\n}\n\nexport async function getAlertsByUserId(userId: number): Promise {\n const result = await sqlite.execute(\n `SELECT * FROM ${ALERTS_TABLE} WHERE user_id = ? ORDER BY alert_date DESC`,\n [userId]\n );\n return result.rows;\n}\n\nexport async function markAlertAsSent(id: number): Promise {\n const result = await sqlite.execute(\n `UPDATE ${ALERTS_TABLE} SET is_sent = 1 WHERE id = ?`,\n [id]\n );\n return result.rowsAffected > 0;\n}\n\nexport async function getPendingAlerts(): Promise<(Alert & { user_email: string, location_name: string })[]> {\n const result = await sqlite.execute(`\n SELECT a.*, u.email as user_email, l.name as location_name\n FROM ${ALERTS_TABLE} a\n JOIN ${USERS_TABLE} u ON a.user_id = u.id\n JOIN ${LOCATIONS_TABLE} l ON a.location_id = l.id\n WHERE a.is_sent = 0\n `);\n return result.rows;\n}",[],[243,305,297],"database","e9a4afea-3447-11f0-ac65-9e149126039e","migrations.ts","e9a4b094-3447-11f0-ac65-9e149126039e",2,["D",1747614391564],"import { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\n\n// Table names - change these when modifying schema\nexport const USERS_TABLE = \"flood_app_users\";\nexport const LOCATIONS_TABLE = \"flood_app_locations\";\nexport const ALERTS_TABLE = \"flood_app_alerts\";\n\nexport async function runMigrations() {\n // Create users table\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${USERS_TABLE} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n email TEXT UNIQUE NOT NULL,\n password_hash TEXT NOT NULL,\n name TEXT NOT NULL,\n created_at TEXT DEFAULT CURRENT_TIMESTAMP\n )\n `);\n\n // Create locations table\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${LOCATIONS_TABLE} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n user_id INTEGER NOT NULL,\n name TEXT NOT NULL,\n latitude REAL NOT NULL,\n longitude REAL NOT NULL,\n created_at TEXT DEFAULT CURRENT_TIMESTAMP,\n FOREIGN KEY (user_id) REFERENCES ${USERS_TABLE}(id) ON DELETE CASCADE\n )\n `);\n\n // Create alerts table\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${ALERTS_TABLE} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n user_id INTEGER NOT NULL,\n location_id INTEGER NOT NULL,\n alert_date TEXT NOT NULL,\n message TEXT NOT NULL,\n is_sent BOOLEAN DEFAULT 0,\n created_at TEXT DEFAULT CURRENT_TIMESTAMP,\n FOREIGN KEY (user_id) REFERENCES ${USERS_TABLE}(id) ON DELETE CASCADE,\n FOREIGN KEY (location_id) REFERENCES ${LOCATIONS_TABLE}(id) ON DELETE CASCADE\n )\n `);\n}",[],[243,305,307],"e9a4d52e-3447-11f0-ac65-9e149126039e",["D",1747614391564],[164,165],[243,305],"e9a4d380-3447-11f0-ac65-9e149126039e",["D",1747614391564],[163,166,169,171,172,173],[243],["D",1747614190177],{"_11":12,"_119":68},{"_11":12,"_115":-5,"_67":68,"_30":66,"_116":117,"_118":24},{"_38":106,"_13":16,"_32":35,"_107":70,"_108":-5,"_109":-5,"_110":-5,"_111":-5,"_112":-5,"_113":14,"_114":12},"ctx",{"_51":-5,"_138":359,"_360":361,"_362":363,"_364":24,"_365":24,"_366":24,"_367":83,"_368":-5,"_369":-7,"_370":-7,"_371":26,"_372":24,"_373":24,"_374":-5,"_375":24,"_376":24,"_377":24,"_378":-5},"ENV",{"_330":331,"_332":333,"_334":16,"_335":336,"_337":338,"_339":340,"_341":342,"_343":344,"_345":346,"_347":348,"_349":350,"_351":352,"_353":354,"_355":356,"_357":358},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","71c1b20804b3232a7e513be260cfffc1932a9e97","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"]

Login

Create Account

Your Locations

Flood Alerts

Add Location

${location.name}

Alert for ${alert.location_name}

⚠️ Flood Alert

History · index.html