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(())
}