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