schema-sql-generator 0.6.24

A set of tools to manage relational database schemas
Documentation
use crate::common::generator_context::GeneratorContext;
use crate::common::procedure_generator::ProcedureGenerator;
use crate::common::sql_writer::SqlWriter;
use schema_model::model::procedure::Procedure;

pub struct SqliteProcedureGenerator {
    context: GeneratorContext,
}

impl SqliteProcedureGenerator {
    pub fn new(context: GeneratorContext) -> Self {
        Self { context }
    }
}

impl ProcedureGenerator for SqliteProcedureGenerator {
    fn output_procedures(&self) {
        let database_type = self.context.settings().database_type();
        let database_model = self.context.settings().database_model();

        let has_procedures = database_model.schemas().iter().any(|schema| {
            schema
                .procedures()
                .iter()
                .any(|p| p.database_type() == database_type)
        });

        if has_procedures {
            panic!("SQLite does not support stored procedures.");
        }
    }

    fn output_procedure(
        &self,
        _writer: &mut SqlWriter,
        _statement_separator: &str,
        _procedure: &Procedure,
    ) {
        panic!("SQLite does not support stored procedures.");
    }
}

#[cfg(test)]
mod tests {
    use super::*;
    use crate::common::test_support::make_context;
    use schema_model::builder::SchemaBuilder;
    use schema_model::model::database_model::DatabaseModel;
    use schema_model::model::procedure::Procedure;
    use schema_model::model::types::{BooleanMode, DatabaseType, ForeignKeyMode};

    #[test]
    fn output_procedures_does_nothing_when_none_exist() {
        let schema = SchemaBuilder::new(None::<&str>).build();
        let model =
            DatabaseModel::new(BooleanMode::Native, ForeignKeyMode::Relations, vec![schema]);
        let (ctx, buffer) = make_context(model, DatabaseType::Sqlite);

        let generator = SqliteProcedureGenerator::new(ctx);
        generator.output_procedures();

        assert_eq!(buffer.contents(), "");
    }

    #[test]
    #[should_panic(expected = "SQLite does not support stored procedures.")]
    fn output_procedures_panics_when_a_sqlite_procedure_exists() {
        let procedure = Procedure::new(None::<&str>, "proc", DatabaseType::Sqlite, "select 1");
        let schema = SchemaBuilder::new(None::<&str>)
            .add_procedures(vec![procedure])
            .build();
        let model =
            DatabaseModel::new(BooleanMode::Native, ForeignKeyMode::Relations, vec![schema]);
        let (ctx, _buffer) = make_context(model, DatabaseType::Sqlite);

        let generator = SqliteProcedureGenerator::new(ctx);
        generator.output_procedures();
    }
}