//! create a connection pool and setup tables before making avaliable

use crate::config;
use sqlx::{Pool, Postgres, migrate, postgres::PgPool};

pub async fn conn() -> Pool<Postgres> {
    let conn = match PgPool::connect(&config::DATABASE_URL).await {
        Ok(val) => val,
        Err(err) => {
            panic!("Could not connect to the database. Got error {err}");
        }
    };

    migrate!().run(&conn).await.unwrap_or_else(|err| {
        panic!("Error running migrations: {}", err);
    });

    conn
}