Struct ProcedureSqlGenerator 

pub struct ProcedureSqlGenerator {
    pub db_type: DatabaseType,
}

Generate SQL for procedure migrations.

Fields

db_type: DatabaseType

Database type.

Implementations

impl ProcedureSqlGenerator

pub fn new(db_type: DatabaseType) -> Self

Create a new generator.

pub fn create_procedure(&self, proc: &ProcedureDefinition) -> String

Generate CREATE FUNCTION/PROCEDURE SQL.

pub fn drop_procedure(&self, proc: &ProcedureDefinition) -> String

Generate DROP FUNCTION/PROCEDURE SQL.

pub fn alter_procedure(&self, diff: &ProcedureAlterDiff) -> String

Generate ALTER FUNCTION/PROCEDURE SQL (usually CREATE OR REPLACE).

pub fn create_trigger(&self, trigger: &TriggerDefinition) -> String

Generate CREATE TRIGGER SQL.

pub fn drop_trigger(&self, trigger: &TriggerDefinition) -> String

Generate DROP TRIGGER SQL.

pub fn generate_migration(&self, diff: &ProcedureDiff) -> MigrationSql

Generate full migration SQL for a procedure diff.

impl ProcedureSqlGenerator

pub fn create_event(&self, event: &ScheduledEvent) -> String

Generate CREATE EVENT SQL (MySQL).

pub fn drop_event(&self, event: &ScheduledEvent) -> String

Generate DROP EVENT SQL.

pub fn create_sql_agent_job(&self, job: &SqlAgentJob) -> String

Generate SQL Agent job creation script.

pub fn drop_sql_agent_job(&self, job_name: &str) -> String

Generate DROP SQL Agent job script.