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