public IActionResult SchemaSql([FromBody] TReportsSchemaSqlRequest request)
{
Log.Information("***Executando método 'SchemaSql'***");
Log.Information("-----Leitura dos parâmetros -----" + System.Environment.NewLine);
Log.Information(JsonConvert.SerializeObject(request));
Log.Information(System.Environment.NewLine);
Log.Information("-----Fim da leitura dos parâmetros -----" + System.Environment.NewLine);
try
{
var response = GetSchemaSql(request);
Log.Information("***Resposta do método 'SchemaTable'***");
Log.Information(JsonConvert.SerializeObject(response));
Log.Information(System.Environment.NewLine);
Log.Information("-----Fim da resposta do método 'SchemaTable'-----" + System.Environment.NewLine);
return(Ok(response));
}
catch (Exception ex)
{
Log.Error(ex.Message);
Response.StatusCode = 500;
return(Accepted(new TReportsCustomError()
{
code = "500", detailedMessage = ex.StackTrace, message = ex.Message
}));
}
}
private TReportsSchemaSqlResponse GetSchemaSql(TReportsSchemaSqlRequest request)
{
GetDataSql(GetSentenceSql(request.SqlText, request.SqlParameters), out IEnumerable <Column> columns);
return(new TReportsSchemaSqlResponse
{
SchemaSql = new SchemaSql
{
Columns = columns.ToArray()
}
});
}
protected async Task <IActionResult> SchemaSql([FromBody] TReportsSchemaSqlRequest request)
{
Log.Information("***Executando método 'SchemaSql'***");
Log.Information("-----Leitura dos parâmetros -----" + System.Environment.NewLine);
Log.Information(JsonConvert.SerializeObject(request));
Log.Information(System.Environment.NewLine);
Log.Information("-----Fim da leitura dos parâmetros -----" + System.Environment.NewLine);
return(BadRequest(new TReportsCustomError()
{
code = "400", detailedMessage = "Esse provedor não suporta sql, pois é um exemolo que nao utilizabase de dados.", message = "Não suportado"
}));
}
public async Task <IActionResult> SchemaSql([FromBody] TReportsSchemaSqlRequest request)
{
return(await base.SchemaSql(request));
}
