Struct SqlMigration 

pub struct SqlMigration { /* private fields */ }

A migration defined by SQL strings.

Works with any context that implements SqlExecutor.

Implementations

impl SqlMigration

pub fn new( version: u64, name: impl Into<String>, up_sql: impl Into<String>, ) -> Self

Create a new SQL migration

pub fn phase(self, phase: Phase) -> Self

Set the deployment phase

pub fn with_down(self, down_sql: impl Into<String>) -> Self

Add rollback SQL

pub fn up_sql(&self) -> &str

Get the up SQL

pub fn down_sql(&self) -> Option<&str>

Get the down SQL

pub fn version(&self) -> u64

Get the version

pub fn name(&self) -> &str

Get the name

pub fn get_phase(&self) -> Phase

Get the deployment phase

pub fn has_rollback(&self) -> bool

Whether this migration has rollback SQL

Trait Implementations

impl<Ctx> Migration<Ctx> for SqlMigration

where Ctx: SqlExecutor,

fn version(&self) -> u64

Unique version number (must be sequential: 1, 2, 3, …)

fn name(&self) -> &str

Human-readable name for this migration

fn phase(&self) -> Phase

Deployment phase (pre-deploy or post-deploy)

fn apply(&self, ctx: &mut Ctx) -> Result<()>

Apply the migration

fn rollback(&self, ctx: &mut Ctx) -> Result<()>

Rollback the migration (optional)

fn can_rollback(&self) -> bool

Whether this migration supports rollback