From b7a2265e9b29d8fa09f84f5213ef7f8ed3045ca6 Mon Sep 17 00:00:00 2001
From: cel 🌸 <cel@blos.sm>
Date: Wed, 13 Nov 2024 20:00:15 +0000
Subject: initial commit

---
 src/db/artworks.rs |  1 +
 src/db/mod.rs      | 20 ++++++++++++++++++++
 2 files changed, 21 insertions(+)
 create mode 100644 src/db/artworks.rs
 create mode 100644 src/db/mod.rs

(limited to 'src/db')

diff --git a/src/db/artworks.rs b/src/db/artworks.rs
new file mode 100644
index 0000000..8b13789
--- /dev/null
+++ b/src/db/artworks.rs
@@ -0,0 +1 @@
+
diff --git a/src/db/mod.rs b/src/db/mod.rs
new file mode 100644
index 0000000..97a5b25
--- /dev/null
+++ b/src/db/mod.rs
@@ -0,0 +1,20 @@
+use sqlx::{postgres::PgPoolOptions, Pool, Postgres};
+
+mod artworks;
+
+#[derive(Clone)]
+pub struct Database(Pool<Postgres>);
+
+impl Database {
+    pub async fn new(connection_string: &str) -> Self {
+        let pool = PgPoolOptions::new()
+            .max_connections(5)
+            .connect(connection_string)
+            .await
+            .unwrap();
+
+        sqlx::migrate!("./migrations").run(&pool).await.unwrap();
+
+        Self(pool)
+    }
+}
-- 
cgit