Problem with migrations

[kirillsalykin]

I have next code which creates a db pool and runs a migration:

use sqlx::postgres::{PgConnectOptions, PgPoolOptions};
use sqlx::PgPool;
use underway;

use crate::configuration::DatabaseConfig;

impl From<DatabaseConfig> for PgConnectOptions {
    fn from(config: DatabaseConfig) -> Self {
        PgConnectOptions::new()
            .host(&config.host)
            .port(config.port)
            .username(&config.username)
            .password(&config.password)
            .database(&config.database)
    }
}

pub async fn get_connection_pool(config: DatabaseConfig) -> PgPool {
    let pool = PgPoolOptions::new()
        .connect_with(config.into())
        .await
        .expect("fail to connect to db");

    underway::MIGRATOR.run(&pool).await.unwrap();

    // TODO: handle errors
    sqlx::migrate!("./migrations").run(&pool).await.unwrap();

    pool
}

Unfortunately it keeps failing with this:

thread 'main' panicked at /Users/kirill/Dev/Playground/prostor/src/backend/src/database.rs:27:53:
called `Result::unwrap()` on an `Err` value: VersionMissing(20240921151751)

which is underway migration.

sqlx knows about 20240921151751 migration because it is in _migrations table, but it is missing from the migrations directory.

if you change order of migrators - underway migrator will start to complain about missing migrations from the project.

[kirillsalykin]

I dont think there is a way to add multiple sources for migrations in sqlx.

Options to have this working:

1. turn on ignore-missing in both migrators, which probably nice to have, so not the best option
2. copy manually migration from the underway
3. copy automatically migration from the underway
4. ask sqlx to support multiple sources

[kirillsalykin]

FYI: launchbadge/sqlx#3573

[maxcountryman]

This is a dupe of #11