use crate::common::function_generator::{DefaultFunctionGenerator, FunctionGenerator};
use crate::common::generator_context::GeneratorContext;
use crate::common::sql_writer::SqlWriter;
use schema_model::model::function::Function;
pub struct SqlServerFunctionGenerator {
function_generator: DefaultFunctionGenerator
}
impl SqlServerFunctionGenerator {
pub fn new(context: GeneratorContext) -> Self {
Self {
function_generator: DefaultFunctionGenerator::new(context),
}
}
}
impl FunctionGenerator for SqlServerFunctionGenerator {
fn output_functions(&self) {
self.function_generator.output_functions();
}
fn output_function(&self, writer: &mut SqlWriter, statement_separator: &str, function: &Function) {
let function_name = function.name();
let schema_name = match function.schema_name() {
Some(s) if s.eq_ignore_ascii_case("public") => "dbo",
Some(s) => s,
None => "dbo",
};
let fully_qualified_name = format!("{}.{}", schema_name, function_name);
writer.println(format!("if exists (select * from dbo.sysobjects where id = object_id(N'[{}].[{}]') and objectproperty(id, N'IsScalarFunction') = 1)", schema_name, function_name).as_str());
writer.print(format!("drop function {}", fully_qualified_name).as_str());
writer.println(statement_separator);
writer.print(function.sql());
writer.println(statement_separator);
writer.newline();
}
}
#[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_function_renders_drop_if_exists_guard() {
let schema = SchemaBuilder::new(None::<&str>).build();
let model = DatabaseModel::new(None, BooleanMode::Native, ForeignKeyMode::Relations, vec![schema]);
let (ctx, buffer) = make_context(model, DatabaseType::SqlServer);
let function = Function::new(
None::<&str>,
"mssql_fn",
DatabaseType::SqlServer,
"create function dbo.mssql_fn() returns int as begin return 1 end",
);
let generator = SqlServerFunctionGenerator::new(ctx.clone());
ctx.with_writer(|writer| {
generator.output_function(writer, ";", &function);
});
let output = buffer.contents();
assert!(output.contains("if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[mssql_fn]') and objectproperty(id, N'IsScalarFunction') = 1)"));
assert!(output.contains("drop function dbo.mssql_fn"));
assert!(output.contains("create function dbo.mssql_fn() returns int as begin return 1 end"));
}
#[test]
fn output_function_respects_explicit_non_default_schema() {
let schema = SchemaBuilder::new(Some("app")).build();
let model = DatabaseModel::new(None, BooleanMode::Native, ForeignKeyMode::Relations, vec![schema]);
let (ctx, buffer) = make_context(model, DatabaseType::SqlServer);
let function = Function::new(
Some("app"),
"mssql_fn",
DatabaseType::SqlServer,
"create function app.mssql_fn() returns int as begin return 1 end",
);
let generator = SqlServerFunctionGenerator::new(ctx.clone());
ctx.with_writer(|writer| {
generator.output_function(writer, ";", &function);
});
let output = buffer.contents();
assert!(output.contains("drop function app.mssql_fn"));
}
#[test]
fn output_functions_does_not_apply_the_drop_if_exists_override_due_to_static_dispatch() {
let schema = SchemaBuilder::new(None::<&str>)
.add_functions(vec![Function::new(
None::<&str>,
"mssql_fn",
DatabaseType::SqlServer,
"create function dbo.mssql_fn() returns int as begin return 1 end",
)])
.build();
let model = DatabaseModel::new(None, BooleanMode::Native, ForeignKeyMode::Relations, vec![schema]);
let (ctx, buffer) = make_context(model, DatabaseType::SqlServer);
let generator = SqlServerFunctionGenerator::new(ctx);
generator.output_functions();
let output = buffer.contents();
assert!(output.contains("create function dbo.mssql_fn() returns int as begin return 1 end"));
assert!(!output.contains("drop function"), "if this now fails, the dispatch bug was fixed - update this test");
}
}