feat: add get all repos from db

1 files changed, 36 insertions, 0 deletions

diff --git a/src/repository/models.rs b/src/repository/models.rs
new file mode 100644
index 0000000..ec5559b
--- /dev/null
+++ b/src/repository/models.rs
@@ -0,0 +1,36 @@
+use crate::db::get_client;
+use crate::errors::AppError;
+use chrono::NaiveDateTime;
+use deadpool_postgres::Pool;
+use serde::{Deserialize, Serialize};
+use tokio_pg_mapper::FromTokioPostgresRow;
+use tokio_pg_mapper_derive::PostgresMapper;
+use uuid::Uuid;
+
+#[derive(Serialize, Deserialize, PostgresMapper)]
+#[pg_mapper(table = "repository")]
+pub struct Repository {
+    pub id: Uuid,
+    pub url: String,
+    pub created_at: NaiveDateTime,
+    pub updated_at: NaiveDateTime,
+    pub uploader_ip: String,
+}
+
+impl Repository {
+    pub async fn find_all(pool: Pool) -> Result<Vec<Repository>, AppError> {
+        let client = get_client(pool.clone()).await.unwrap();
+        let statement = client
+            .prepare("SELECT * FROM repository ORDER BY updated_at DESC")
+            .await?;
+
+        let repos = client
+            .query(&statement, &[])
+            .await?
+            .iter()
+            .map(|row| Repository::from_row_ref(row).unwrap())
+            .collect::<Vec<Repository>>();
+
+        Ok(repos)
+    }
+}