public IActionResult Get(int limit, int year, int?month, int?day,
[FromQuery(Name = "filters")] List <Dictionary <string, string> > filters,
[FromQuery(Name = "order[]")] string[] order)
{
var path = _config.GetValue <string>("LogPath");
var file = String.Format("u_ex{0}{1}{2}.log", year % 100, month?.ToString("00") ?? "??", day?.ToString("00") ?? "??");
if (Directory.GetFiles(path, file).Length == 0)
{
return(BadRequest("No log files"));
}
var sb = new SelectBuilder()
.Select($"TOP {limit} *")
.From(Path.Combine(path, file))
.Where("1 = 1");
foreach (var dict in filters)
{
var value = "'" + (dict["condition"].Contains("LIKE") ? "%" + dict["value"] + "%" : dict["value"]) + "'";
sb.And(String.Concat(dict["field"], " ", dict["condition"], " ", value));
}
sb.OrderBy(order);
if (RuntimeInformation.IsOSPlatform(OSPlatform.Windows))
{
return(Ok(GetData(sb.Build())));
}
else
{
return(StatusCode(StatusCodes.Status501NotImplemented));
}
}