public IActionResult RangeGet(string resource, string field) { try { if (Request.Query.ContainsKey("start") || Request.Query.ContainsKey("end")) { var q = SpecialQueries.TryGetRangeQuery(resource, field, Request.Query); if (q == null) { return(StatusCode(400)); } return(Json(DBProvider.Select(q))); } else { return(StatusCode(400)); } } catch (Npgsql.PostgresException) { return(StatusCode(400)); } catch (DBProviderExecuteException) { return(StatusCode(500)); } }
public IActionResult ExpandGet(string resource) { try { // Try find expand query string q = SpecialQueries.TryGetExpandQuery(resource); if (q != null) { return(Json(DBProvider.Select(q))); } else { return(Json(DBProvider.Select("SELECT * FROM " + resource))); } } catch (Npgsql.PostgresException) { return(StatusCode(400)); } catch (DBProviderExecuteException) { return(StatusCode(500)); } }