public async Task <int> GetRequestCountAsync(RequestCountFilterOption filterOption)
{
var sql = $"SELECT COUNT(1) FROM RequestInfo {BuildSqlFilter(filterOption)}";
TraceLogSql(sql);
return(await LoggingSqlOperation(async connection => await connection.QueryFirstOrDefaultAsync <int>(sql).ConfigureAwait(false)));
}
public async Task <int> GetTimeoutResponeCountAsync(RequestCountFilterOption filterOption, int timeoutThreshold)
{
var where = BuildSqlFilter(filterOption);
var sql = $"SELECT COUNT(1) FROM RequestInfo {(string.IsNullOrWhiteSpace(where) ? "WHERE" : where)} AND Milliseconds >= {timeoutThreshold}";
TraceLogSql(sql);
return(await LoggingSqlOperation(async connection => await connection.QueryFirstOrDefaultAsync <int>(sql).ConfigureAwait(false)));
}
public async Task <int> GetTimeoutResponeCountAsync(RequestCountFilterOption option, int timeoutThreshold)
{
var response = await Client.SearchAsync <RequestInfo>(x => x.Index(GetIndexName <RequestInfo>())
.Query(d =>
d.HasDateWhere(option.StartTime, option.EndTime) &&
d.Terms(f => f.Field(e => e.Node).Terms(option.Service)) &&
d.Terms(f => f.Field(e => e.StatusCode).Terms(option.StatusCodes)) &&
d.Range(f => f.Field(e => e.Milliseconds).GreaterThanOrEquals(timeoutThreshold))
).Size(0));
if (response != null && response.IsValid)
{
return(Convert.ToInt32(response.Total));
}
return(0);
}
public async Task <int> GetRequestCountAsync(RequestCountFilterOption option)
{
var response = await Client.SearchAsync <RequestInfo>(x => x.Index(GetIndexName <RequestInfo>())
.Query(c =>
c.HasDateWhere(option.StartTime, option.EndTime)
&& c.Terms(f => f.Field(e => e.StatusCode).Terms(option.StatusCodes))
&& c.Terms(f => f.Field(e => e.Node).Terms(option.Service.ToLowerInvariant()))
).Size(0));
if (response != null && response.IsValid)
{
return(Convert.ToInt32(response.Total));
}
return(0);
}
public Task <int> GetTimeoutResponeCountAsync(RequestCountFilterOption filterOption, int timeoutThreshold)
{
throw new NotImplementedException();
}
public Task <int> GetRequestCountAsync(RequestCountFilterOption filterOption)
{
throw new NotImplementedException();
}
