feat: add weather pooler and config

1 files changed, 21 insertions, 0 deletions

diff --git a/src/users.rs b/src/users.rs
index 43f190d..dad24bc 100644
--- a/src/users.rs
+++ b/src/users.rs
@@ -20,6 +20,16 @@ pub enum UserRole {
     Admin,
 }
 
+#[derive(Debug, Serialize, Deserialize, FromRow, Clone, PartialEq, ToSchema)]
+pub struct UserWithLocation {
+    pub id: i64,
+    pub user_id: String,
+    pub role: UserRole,
+    pub location_id: i64,
+    pub latitude: f64,
+    pub longitude: f64,
+}
+
 pub struct UserRepository<'a> {
     pub db: &'a sqlx::SqlitePool,
 }
@@ -79,6 +89,17 @@ impl<'a> UserRepository<'a> {
         Ok(())
     }
 
+    pub async fn list_users_with_locations(&self) -> Result<Vec<UserWithLocation>, sqlx::Error> {
+        sqlx::query_as::<_, UserWithLocation>(
+            "SELECT u.id, u.user_id, u.role, l.id as location_id, l.latitude, l.longitude 
+             FROM users u 
+             LEFT JOIN locations l ON u.id = l.user_id 
+             WHERE l.id IS NOT NULL",
+        )
+        .fetch_all(self.db)
+        .await
+    }
+
     pub async fn any_admin_exists(&self) -> Result<bool, sqlx::Error> {
         let count: (i64,) = sqlx::query_as("SELECT COUNT(*) FROM users WHERE role = ?")
             .bind(UserRole::Admin)