Skip to main content

Crate migratrom_sqlite

Crate migratrom_sqlite 

Source
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§

SqliteAdapter
A Db over one pinned SQLite connection.

Functions§

apply_migrations
Apply migrations against a SQLite pool using SqliteDialect.