# sqlx-migrate-validate
With [sqlx](https://docs.rs/sqlx) and its [sqlx::migrate!](https://docs.rs/sqlx/latest/sqlx/macro.migrate.html)
macro it is possible to create migrations and apply them to a database.
When starting an application it is important to validate that the database is in the correct state.
This crate provides a way to validate that the applied migrations match the desired migrations.
In combination with the [sqlx::migrate!](https://docs.rs/sqlx/latest/sqlx/macro.migrate.html) macro it is possible
to validate that the database schema matches the migrations present in the source code at the time of compilation.

While this does not ensure full compatibility between the database and the application it can help
to detect issues early.

Examples:

```rust,no_run
use sqlx_migrate_validate::{Validate, Validator};

#[tokio::main]
async fn main() -> Result<(), anyhow::Error> {
    let pool = sqlx::SqlitePool::connect("sqlite::memory:").await?;
    let mut conn = pool.acquire().await?;

    sqlx::migrate!("./tests/migrations-1")
        .validate(&mut *conn)
        .await?;

    Ok(())
}
```