Anyway to run migration in migration or transaction block?

[abdulalalalalala]

Is there a way to perform migration in a transaction block, such as:

pub async fn custom_migrate(pool: &sqlx::Pool<Postgres>) -> Result<(), AppError> {
    // fetch environment variables
    let contact = fetch_env_vars(".env").await.expect("Failed to fetch env");

    let mut transaction = pool.migration
        .begin()
        .await
        .expect("Failed to begin seeding transaction");
    
  // seed a default user as example
  sqlx::query(
        r#"
        INSERT INTO db.accounts
        (name, email, app_name)
        VALUES ($1, $2, $3);
        "#,
    )
    .bind("John Doe")
    .bind("[email protected]")
    .bind(contact.app_name) // <== this is the interesting & dynamic part
    .execute(&mut *transaction)
    .await
    .expect("Failed to perform query mid of transaction");

    transaction
        .commit()
        .await
        .expect("Failed to commit seeding transaction");
    Ok(())
}

The reason for asking this because I ran into a unique use case when doing database seeding: I wanted to get insert some records that are unique and relatively static. That means the "insertion" above should only happen ONCE. However, it's not all static, because there is "app_name", for example as String the developers define in the .env file.

It can be "my_app__name_dev" or "my_app_name_prod" or whatever.