Expand description
Apply migratrom migrations through a sqlx::SqlitePool.
This is the normal application entry point for SQLite. apply_migrations
acquires one pooled connection and pins it for the complete run, ensuring the
engine’s transaction statements use one SQLite session. SQLite has no advisory
locks, so enabling the core advisory-lock option is a no-op for this adapter.
§Quick start
use migratrom::operations::{add_column, create_table};
use migratrom::{ApplyOptions, ColumnDef, Migration, PrimaryKey, SqliteDialect};
use migratrom_sqlite::apply_migrations;
use sqlx::sqlite::SqlitePoolOptions;
let pool = SqlitePoolOptions::new()
.max_connections(1)
.connect("sqlite:app.db")
.await?;
let dialect = SqliteDialect;
let create_users = Migration::new(
1,
None,
vec![create_table(
"main",
"users",
&[ColumnDef::new("id", "INTEGER"), ColumnDef::new("email", "TEXT")],
Some(&PrimaryKey { columns: vec!["id".into()] }),
&dialect,
)?],
);
let add_name = Migration::new(
2,
Some(1),
vec![add_column(
"main",
"users",
&ColumnDef::new("name", "TEXT").nullable(true),
&dialect,
)?],
);
let result = apply_migrations(
&[create_users, add_name],
&pool,
&ApplyOptions::default(),
).await?;
println!("applied: {:?}", result.applied);The core migratrom::operations module documents all available builders.
PostgreSQL-only builders return migratrom::MigratromError::Unsupported when
used with migratrom::SqliteDialect.
Structs§
- Sqlite
Adapter - A
Dbover one pinned SQLite connection.
Functions§
- apply_
migrations - Apply migrations against a SQLite pool using
SqliteDialect.