feat: conn to db

1 files changed, 17 insertions, 0 deletions

diff --git a/src/server/state/database.rs b/src/server/state/database.rs
new file mode 100644
index 0000000..32d3f98
--- /dev/null
+++ b/src/server/state/database.rs
@@ -0,0 +1,17 @@
+use anyhow::Result;
+use sqlx::{PgPool, postgres::PgPoolOptions};
+use tracing::{debug, trace};
+
+use crate::config::DatabaseOptions;
+
+
+pub(super) async fn connect(opts: &DatabaseOptions) -> Result<PgPool> {
+    trace!(host = ?opts.url.host(), "connecting to database");
+    let pg = PgPoolOptions::new()
+        .max_connections(opts.pool_size)
+        .connect(opts.url.as_str())
+        .await?;
+    debug!(host = ?opts.url.host(), "connected to database");
+
+    Ok(pg)
+}