1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18

use sqlx::migrate::MigrateError;
use sqlx::{sqlite::SqliteConnectOptions, SqlitePool};
use std::path::Path;

pub async fn do_migrate(
    file: impl AsRef<Path> + std::fmt::Debug,
) -> Result<SqlitePool, MigrateError> {
    log::info!("進行資料庫遷移 {:?}！", file);
    let pool = SqlitePool::connect_with(
        SqliteConnectOptions::new()
            .filename(file)
            .create_if_missing(true),
    )
    .await?;

    sqlx::migrate!("./migrations").run(&pool).await?;
    Ok(pool)
}