[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_188":189,"_190":191},"routes/_app.x.$handle.$name",{"_96":95,"_31":44,"_104":86,"_26":105,"_13":14,"_106":-5,"_11":107,"_108":109,"_110":111,"_112":113,"_114":115,"_20":-5,"_116":-5,"_117":-5,"_118":24,"_119":120,"_121":24,"_122":-5,"_123":-5,"_124":125},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_42":43,"_31":44,"_37":45,"_46":-5,"_47":24,"_48":49,"_50":49,"_51":52,"_53":-5,"_18":54,"_55":56,"_57":58,"_59":58,"_60":-5,"_61":62,"_63":64,"_65":-5,"_66":-5,"_67":-5,"_68":-5,"_69":70,"_71":70,"_72":73,"_74":73,"_75":73,"_76":70,"_77":70,"_78":79,"_80":81,"_82":83,"_84":24},"version",3,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":-7,"_23":24,"_25":24,"_26":27,"_28":27},"file",{"_29":30,"_31":32,"_33":34,"_35":36,"_37":38,"_39":14,"_40":41,"_23":24},"previous","deleted",false,"deletedHere","path","backend/database/queries.ts","latestPath","fileId","f4cd9c88-3447-11f0-93a7-9e149126039e","name","queries.ts","fileType","script","content","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}","createdAt",["D",1747614410288],"branchVersion","branchId","719b260a-3447-11f0-ae6c-9e149126039e","id","719af482-3447-11f0-ae6c-9e149126039e","FloodApp",["D",1747614190177],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","A flood app that notify subscriber ahead of flooding","imageUrl","dcf86e80-3442-11f0-b519-ff88f6bc2fe6","pinnedFileId","36a9b060-3448-11f0-ae10-9e149126039e","pinPreview",true,"pinMigrated","screenshotVersion","likeCount",0,"orgId","d12e9468-0713-4b2e-926d-7ccecb147081","tursoName","tursoHostname","tursoMeasuredAt","pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_96":95,"_103":99},"org",{"_96":95,"_97":-5,"_98":99,"_18":54,"_100":101,"_102":24},"branch",{"_13":85,"_31":86,"_42":41,"_87":43,"_88":-5,"_89":-5,"_90":-5,"_91":-5,"_92":-5,"_93":44,"_94":95},"isOwned",16,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","excel","handle","displayName","avatar","https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvb2F1dGhfZ2l0aHViL2ltZ18yeEk0TXdTZ1pDYmt1Y0FqSmFkNWwxMUx6UkMifQ","tier","free","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_42":43,"_31":44,"_37":184,"_46":-5,"_47":24,"_48":49,"_50":49,"_51":52,"_53":-5,"_18":54,"_55":56,"_57":58,"_59":58,"_60":-5,"_61":62,"_63":64,"_65":-5,"_66":-5,"_67":-5,"_68":-5,"_69":70,"_71":70,"_72":73,"_74":73,"_75":73,"_76":70,"_77":70,"_78":185,"_80":186,"_82":187,"_84":24},"tree",[155,159],"files",[155,156,157,158,159],"counts",{"_145":62,"_146":132,"_147":62,"_148":149,"_150":151},"contents",[126,127],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_42":138,"_31":139,"_29":140,"_131":-5,"_40":41,"_39":141,"_133":58,"_37":142,"_13":62,"_33":143,"_35":-5,"_23":24,"_136":-5,"_26":144},{"_42":128,"_31":129,"_29":130,"_131":-5,"_40":41,"_39":132,"_133":58,"_37":134,"_13":62,"_33":20,"_35":135,"_23":24,"_136":-5,"_26":137},"e29c60d0-3447-11f0-941a-9e149126039e","README.md","e29c618e-3447-11f0-941a-9e149126039e","parentId",1,"latest",["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","label",[129],"e9a4d380-3447-11f0-ac65-9e149126039e","backend","494901c2-9114-474e-8493-8fd4d96b25e0",2,["D",1747614391564],"directory",[139],"pulls","branches","forks","envVars",{"_152":62,"_154":62},"connections",{"_152":62,"_153":62},"count","unfilledCount","emptyCount",{"_42":138,"_31":139,"_29":140,"_131":-5,"_40":41,"_39":141,"_133":58,"_37":181,"_13":62,"_33":143,"_35":-5,"_23":24,"_136":-5,"_161":182,"_26":183},{"_42":177,"_31":169,"_29":165,"_131":140,"_40":41,"_39":141,"_133":58,"_37":178,"_13":62,"_33":143,"_35":-5,"_23":24,"_136":-5,"_161":179,"_26":180},{"_42":170,"_31":171,"_29":172,"_131":165,"_40":41,"_39":141,"_133":58,"_37":173,"_13":62,"_33":34,"_35":174,"_23":24,"_136":-5,"_161":175,"_26":176},{"_42":164,"_31":32,"_29":30,"_131":165,"_40":41,"_39":14,"_133":58,"_37":166,"_13":62,"_33":34,"_35":36,"_23":24,"_136":-5,"_161":167,"_26":168},{"_42":128,"_31":129,"_29":130,"_131":-5,"_40":41,"_39":132,"_133":58,"_37":160,"_13":62,"_33":20,"_35":135,"_23":24,"_136":-5,"_161":162,"_26":163},["D",1747614379766],"children",[],[129],"f4cd9bc0-3447-11f0-93a7-9e149126039e","9cf75c7d-cd49-45df-8942-278f9ddd13bf",["D",1747614410288],[],[139,169,32],"database","e9a4afea-3447-11f0-ac65-9e149126039e","migrations.ts","e9a4b094-3447-11f0-ac65-9e149126039e",["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}",[],[139,169,171],"e9a4d52e-3447-11f0-ac65-9e149126039e",["D",1747614391564],[157,158],[139,169],["D",1747614391564],[156],[139],["D",1747614190177],{"_96":95,"_103":99},{"_96":95,"_97":-5,"_98":99,"_18":54,"_100":101,"_102":24},{"_13":85,"_31":86,"_42":41,"_87":43,"_88":-5,"_89":-5,"_90":-5,"_91":-5,"_92":-5,"_93":44,"_94":95},"ctx",{"_78":-5,"_123":221,"_222":223,"_224":225,"_226":24,"_227":24,"_228":24,"_229":58,"_230":-5,"_231":-7,"_232":-7,"_233":62,"_234":24,"_235":24,"_236":-5,"_237":24,"_238":24,"_239":24,"_240":-5},"ENV",{"_192":193,"_194":195,"_196":86,"_197":198,"_199":200,"_201":202,"_203":204,"_205":206,"_207":208,"_209":210,"_211":212,"_213":214,"_215":216,"_217":218,"_219":220},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","e8c4b7030cb7600e4eb0736b15f422c8b8bd130f","RENDER_GIT_BRANCH","POSTHOG_API_TOKEN","phc_nmoyuAkStEZuUp69rYlg1DZgrIt19Gx0Y4Hwf8tGgJP","POSTHOG_API_HOST","https://wart.val.town","WEB_API_TEMPLATE","https://{val}.web.val.run","APP_URL","https://www.val.town","MODULE_URL","https://esm.town","VANITY_WEB_API_TEMPLATE","https://{label}.val.run/","DENOLS_URL","https://lsp.val.town","NODE_ENV","production","CLOUDFLARE_TURNSTILE_SITE_KEY","0x4AAAAAACtaIZJH7s9rBMZ6","GOOGLE_CLIENT_ID","875989696899-jtsqkhlbdv5jrlsk8631p7ipjg3c6o62.apps.googleusercontent.com","STRIPE_PUBLISHABLE_KEY","pk_live_51N2zvWEpZTTLipIkVEwXrUG9AT0yeOOEYxszarZT1jpsZV58Ly6wlg3SltZpHN26CUalOBmUSY7adQRQiSkCZz2500qSXNkf8Y","API_URL","https://api.val.town",[],"preferencesKeybindings","default","preferencesTheme","light","preferencesFixers","preferencesCopilot","preferencesSelectionAi","preferencesCloseBrackets","preferencesChatPanelState","preferencesDprint","preferencesDenofmt","notificationCount","flagDenols","isBusinessOrgMember","businessOrgHandle","isBusinessOrgAdmin","isHigherTownieTier","navCollapsed","currentOrgId"]

Diff · v3