public ExecuteResultEnum List(IStoredProcedureCommandOptions options) { var storedProcedures = _configFile.Config?.Schema.FirstOrDefault(_ => _.Name.Equals(options.SchemaName))?.StoredProcedures?.ToList(); if (!(storedProcedures?.Any() ?? false)) { if (!options.Silent) { _reportService.Warn($"No StoredProcduress found"); } return(ExecuteResultEnum.Aborted); } _reportService.Output($"[{(storedProcedures.Count > 0 ? "{" : "")}"); storedProcedures.ForEach(storedprocdures => { _reportService.Output($"\t\"name\": \"{storedprocdures.Name}\""); // _reportService.Output($"\t\"name\": \"{storedprocdures.Name}\","); // _reportService.Output($"\t\"status\": \"{storedprocdures.Status}\""); if (storedProcedures.FindIndex(_ => _ == storedprocdures) < storedProcedures.Count - 1) { _reportService.Output("}, {"); } }); _reportService.Output($"{(storedProcedures.Count > 0 ? "}" : "")}]"); return(ExecuteResultEnum.Succeeded); }
public StoredProcedureCommandOptions(IStoredProcedureCommandOptions options) : base(options) { _options = options; }