use sqlx::Executor;
use sqlx::PgPool;
use sqlx::migrate::{MigrateError, Migrator};
pub static MIGRATOR: Migrator = sqlx::migrate!("./migrations");
pub async fn migrate(pool: &PgPool) -> Result<(), MigrateError> {
let mut connection = pool.acquire().await?;
connection
.execute("create schema if not exists fluxpro")
.await?;
connection
.execute("set search_path to fluxpro, public")
.await?;
MIGRATOR.run(&mut *connection).await
}