public void ShouldWrapInBracketsWhenIncludedInSchemaButNotName()
{
var sqlServerStoredProc = new RoutinesSqlModel
{
definition = "CREATE PROC [abc].aname",
Specific_Name = "aname",
Specific_Schema = "abc"
};
var converter = new RoutineSqlModelTypeConverter();
var storedProc = converter.Convert(sqlServerStoredProc, null, null);
storedProc.FunctionDefinition.ShouldContain("CREATE PROC [abc].[aname]");
}
public void ShouldAppendSchemaWhenNotAppended()
{
var sqlServerStoredProc = new RoutinesSqlModel
{
definition = "CREATE PROC aname",
Specific_Name = "aname",
Specific_Schema = "abc"
};
var converter = new RoutineSqlModelTypeConverter();
var storedProc = converter.Convert(sqlServerStoredProc, null, null);
storedProc.FunctionDefinition.ShouldContain("CREATE PROC [abc].[aname]");
}