migratrom-sqlite 0.2.0

SQLite (sqlx) adapter for migratrom.
Documentation
//! Runnable example: apply two migrations to an in-memory SQLite database.
//!
//! ```sh
//! cargo run -p migratrom-sqlite --example basic
//! ```

use migratrom::operations::{add_column, create_table};
use migratrom::{ApplyOptions, ColumnDef, Migration, PrimaryKey, SqliteDialect};
use migratrom_sqlite::apply_migrations;
use sqlx::sqlite::SqlitePoolOptions;

#[tokio::main]
async fn main() -> Result<(), Box<dyn std::error::Error>> {
    let pool = SqlitePoolOptions::new()
        .max_connections(1)
        .connect("sqlite::memory:")
        .await?;

    let dialect = SqliteDialect;
    let schema = "main";

    let m1 = Migration::new(
        1,
        None,
        vec![create_table(
            schema,
            "users",
            &[
                ColumnDef::new("id", "INTEGER"),
                ColumnDef::new("email", "TEXT"),
            ],
            Some(&PrimaryKey {
                columns: vec!["id".into()],
            }),
            &dialect,
        )?],
    );

    let m2 = Migration::new(
        2,
        Some(1),
        vec![add_column(
            schema,
            "users",
            &ColumnDef::new("name", "TEXT").nullable(true),
            &dialect,
        )?],
    );

    let result = apply_migrations(&[m1, m2], &pool, &ApplyOptions::default()).await?;
    println!("applied migration ids: {:?}", result.applied);
    if !result.skipped_ops.is_empty() {
        println!("skipped operations: {:?}", result.skipped_ops);
    }
    Ok(())
}