public SQLSelectStoredProcedureTemplate(ModelRoot model, CustomStoredProcedure currentStoredProcedure, bool useSingleFile, StringBuilder grantSB)
: base(model)
{
_currentStoredProcedure = currentStoredProcedure;
_useSingleFile = useSingleFile;
_grantSB = grantSB;
}
public string GetStoredProcedurePrefix(CustomStoredProcedure storedProcecdure)
{
if (string.IsNullOrEmpty(storedProcecdure.DatabaseObjectName))
{
return(GetStoredProcedurePrefix());
}
else
{
return(string.Empty);
}
}
public string GetStoredProcedurePrefix(CustomStoredProcedure storedProcecdure)
{
if (string.IsNullOrEmpty(storedProcecdure.DatabaseObjectName))
return GetStoredProcedurePrefix();
else
return string.Empty;
}
public ComplexTypesSPExtenderTemplate(ModelRoot model, CustomStoredProcedure item)
: base(model)
{
_item = item;
}
public ActionTypesExtenderTemplate(ModelRoot model, CustomStoredProcedure storedProcedure)
: base(model)
{
_storedProc = storedProcedure;
}
private static string BuildStoredProcParameterList(CustomStoredProcedure storedProcedure)
{
var output = new StringBuilder();
var parameterList = storedProcedure.GetParameters().Where(x => x.Generated && x.SortOrder > 0).OrderBy(x => x.SortOrder).ToList();
parameterList.AddRange(storedProcedure.GetParameters().Where(x => x.Generated && x.SortOrder == 0).OrderBy(x => x.Name).ToList());
var ii = 0;
foreach (var parameter in parameterList)
{
//Get the default value and make it null if none exists
var defaultValue = parameter.GetSQLDefault();
if (string.IsNullOrEmpty(defaultValue))
defaultValue = "null";
ii++;
output.Append("\t@" + ValidationHelper.MakeDatabaseScriptIdentifier(parameter.DatabaseName) + " " +
parameter.DatabaseType.ToLower() +
(parameter.GetPredefinedSize() == -1 ? "(" + parameter.GetLengthString() + ") " : string.Empty) + (parameter.IsOutputParameter ? " out " : " = " + defaultValue));
if (ii != parameterList.Count)
output.Append(",");
output.AppendLine();
}
return output.ToString();
}
public static string GetSQLCreateStoredProc(CustomStoredProcedure storedProcedure, bool isInternal)
{
var sb = new StringBuilder();
var name = storedProcedure.GetDatabaseObjectName();
sb.AppendLine("if exists(select * from sys.objects where name = '" + name + "' and type = 'P' and type_desc = 'SQL_STORED_PROCEDURE')");
sb.AppendLine("drop procedure [" + storedProcedure.GetSQLSchema() + "].[" + name + "]");
if (isInternal)
{
sb.AppendLine("--MODELID: " + storedProcedure.Key);
}
sb.AppendLine("GO");
sb.AppendLine();
sb.AppendLine("CREATE PROCEDURE [" + storedProcedure.GetSQLSchema() + "].[" + name + "]");
if (storedProcedure.Parameters.Count > 0)
{
sb.AppendLine("(");
sb.Append(BuildStoredProcParameterList(storedProcedure));
sb.AppendLine(")");
}
sb.AppendLine("AS");
sb.AppendLine();
sb.Append(storedProcedure.SQL);
sb.AppendLine();
if (isInternal)
{
sb.AppendLine("--MODELID,BODY: " + storedProcedure.Key);
}
sb.AppendLine("GO");
sb.AppendLine();
return sb.ToString();
}
public DatasiteStoredProcItemTemplate(ModelRoot model, CustomStoredProcedure item, string templateLocation)
: base(model)
{
_item = item;
_templateLocation = templateLocation;
}
public ActionTypesGeneratedTemplate(ModelRoot model, CustomStoredProcedure storedProcedure)
: base(model)
{
_storedProc = storedProcedure;
}
