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; }