use crate::common::generator_context::GeneratorContext;
use crate::common::procedure_generator::{DefaultProcedureGenerator, ProcedureGenerator};
use crate::common::sql_writer::SqlWriter;
use schema_model::model::procedure::Procedure;
pub struct PostgresProcedureGenerator {
procedure_generator: DefaultProcedureGenerator,
}
impl PostgresProcedureGenerator {
pub fn new(context: GeneratorContext) -> Self {
Self {
procedure_generator: DefaultProcedureGenerator::new(context),
}
}
}
impl ProcedureGenerator for PostgresProcedureGenerator {
fn output_procedures(&self) {
self.procedure_generator.output_procedures();
}
fn output_procedure(
&self,
writer: &mut SqlWriter,
statement_separator: &str,
procedure: &Procedure,
) {
self.procedure_generator
.output_procedure(writer, statement_separator, procedure);
}
}
#[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::types::{BooleanMode, DatabaseType, ForeignKeyMode};
#[test]
fn output_procedures_renders_matching_database_type_only() {
let schema = SchemaBuilder::new(None::<&str>)
.add_procedures(vec![
Procedure::new(
None::<&str>,
"pg_only",
DatabaseType::Postgresql,
"create procedure pg_only() as $$ begin end $$ language plpgsql",
),
Procedure::new(
None::<&str>,
"sqlserver_only",
DatabaseType::SqlServer,
"create procedure sqlserver_only",
),
])
.build();
let model =
DatabaseModel::new(BooleanMode::Native, ForeignKeyMode::Relations, vec![schema]);
let (ctx, buffer) = make_context(model, DatabaseType::Postgresql);
let generator = PostgresProcedureGenerator::new(ctx);
generator.output_procedures();
let output = buffer.contents();
assert!(output.contains("create procedure pg_only()"));
assert!(!output.contains("sqlserver_only"));
}
}