/// <summary>
/// The list of results.
/// </summary>
/// <param name="maxResults">The max results.</param>
/// <param name="start">The start</param>
/// <param name="finish">The finish</param>
/// <param name="orderBy">The order by.</param>
/// <returns>The result set</returns>
public override IEnumerable<Guid> List(
int maxResults,
DateTime? start = null,
DateTime? finish = null,
ListResultsOrder orderBy = ListResultsOrder.Descending)
{
var builder = new SqlBuilder();
var t = builder.AddTemplate("select Id from MiniProfilers /**where**/ /**orderby**/ LIMIT(" + maxResults + ")");
if (start != null)
{
builder.Where("Started > @start", new { start });
}
if (finish != null)
{
builder.Where("Started < @finish", new { finish });
}
builder.OrderBy(orderBy == ListResultsOrder.Descending ? "Started desc" : "Started asc");
using (var conn = GetOpenConnection())
{
return conn.Query<Guid>(t.RawSql, t.Parameters).ToList();
}
}
/// <summary>
/// The list of results.
/// </summary>
/// <param name="maxResults">The max results.</param>
/// <param name="start">The start</param>
/// <param name="finish">The finish</param>
/// <param name="orderBy">The order by.</param>
/// <returns>The result set</returns>
public override IEnumerable<Guid> List(
int maxResults,
DateTime? start = null,
DateTime? finish = null,
ListResultsOrder orderBy = ListResultsOrder.Descending)
{
var sb = new StringBuilder(@"
Select Id
From MiniProfilers
");
if (finish != null)
{
sb.AppendLine("Where Started < @finish");
}
if (start != null)
{
sb.AppendLine(finish != null
? " And Started > @start"
: "Where Started > @start");
}
sb.Append("Order By ").AppendLine(orderBy == ListResultsOrder.Descending ? "Started Desc" : "Started Asc");
sb.Append("LIMIT(").Append(maxResults).AppendLine(")");
using (var conn = GetConnection())
{
return conn.Query<Guid>(sb.ToString(), new { start, finish }).ToList();
}
}
/// <summary>
/// The list of results.
/// </summary>
/// <param name="maxResults">The max results.</param>
/// <param name="start">The start</param>
/// <param name="finish">The finish</param>
/// <param name="orderBy">The order by.</param>
/// <returns>The result set</returns>
public override IEnumerable <Guid> List(
int maxResults,
DateTime?start = null,
DateTime?finish = null,
ListResultsOrder orderBy = ListResultsOrder.Descending)
{
var builder = new SqlBuilder();
var t = builder.AddTemplate("select Id from MiniProfilers /**where**/ /**orderby**/ LIMIT(" + maxResults + ")");
if (start != null)
{
builder.Where("Started > @start", new { start });
}
if (finish != null)
{
builder.Where("Started < @finish", new { finish });
}
builder.OrderBy(orderBy == ListResultsOrder.Descending ? "Started desc" : "Started asc");
using (var conn = GetOpenConnection())
{
return(conn.Query <Guid>(t.RawSql, t.Parameters).ToList());
}
}
public IEnumerable<Guid> List(int maxResults, DateTime? start = null, DateTime? finish = null, ListResultsOrder orderBy = ListResultsOrder.Decending)
{
var primaryList = PrimaryStorage.List(maxResults, start, finish, orderBy);
var shareList = ShareStorage.List(maxResults, start, finish, orderBy);
return primaryList.Union(shareList);
}
/// <summary>
/// List the MiniProfiler Ids for the given search criteria.
/// </summary>
/// <param name="maxResults">The max number of results.</param>
/// <param name="start">Search window start time (inclusive).</param>
/// <param name="finish">Search window end time (inclusive).</param>
/// <param name="orderBy">Result order.</param>
/// <returns>A list of GUID keys matching the search.</returns>
public IEnumerable <Guid> List(int maxResults, DateTime?start = null, DateTime?finish = null,
ListResultsOrder orderBy = ListResultsOrder.Descending)
{
using var session = _store.OpenSession(new SessionOptions
{
NoTracking = true
});
var query = session.Query <MiniProfilerDoc, Index_ByStarted>();
if (start.HasValue)
{
query = query.Where(x => x.Started >= start.Value);
}
if (finish.HasValue)
{
query = query.Where(x => x.Started <= finish.Value);
}
query.Take(maxResults);
query = orderBy == ListResultsOrder.Descending
? query.OrderByDescending(x => x.Started)
: query.OrderBy(x => x.Started);
return(query.Select(x => x.ProfilerId).ToList());
}
public IEnumerable <Guid> List(
int maxResults,
DateTime?start = null,
DateTime?finish = null,
ListResultsOrder orderBy = ListResultsOrder.Descending)
{
return(Enumerable.Empty <Guid>());
}
public Task <IEnumerable <Guid> > ListAsync(
int maxResults,
DateTime?start = null,
DateTime?finish = null,
ListResultsOrder orderBy = ListResultsOrder.Descending)
{
return(Task.FromResult(Enumerable.Empty <Guid>()));
}
/// <summary>
/// List the latest profiling results.
/// </summary>
/// <param name="maxResults">The maximum number of results to return.</param>
/// <param name="start">(Optional) The start of the date range to fetch.</param>
/// <param name="finish">(Optional) The end of the date range to fetch.</param>
/// <param name="orderBy">(Optional) The order to fetch profiler IDs in.</param>
public IEnumerable <Guid> List(
int maxResults,
DateTime?start = null,
DateTime?finish = null,
ListResultsOrder orderBy = ListResultsOrder.Descending)
{
var guids = new List <Guid>();
lock (_profiles)
{
int idxStart = 0;
int idxFinish = _profiles.Count - 1;
if (start != null)
{
idxStart = _profiles.BinaryClosestSearch(start.Value);
}
if (finish != null)
{
idxFinish = _profiles.BinaryClosestSearch(finish.Value);
}
if (idxStart < 0)
{
idxStart = 0;
}
if (idxFinish >= _profiles.Count)
{
idxFinish = _profiles.Count - 1;
}
var keys = _profiles.Keys;
if (orderBy == ListResultsOrder.Ascending)
{
for (int i = idxStart; i <= idxFinish; i++)
{
guids.Add(keys[i].Id);
if (guids.Count == maxResults)
{
break;
}
}
}
else
{
for (int i = idxFinish; i >= idxStart; i--)
{
guids.Add(keys[i].Id);
if (guids.Count == maxResults)
{
break;
}
}
}
}
return(guids);
}
/// <summary>
/// List the latest profiling results.
/// </summary>
public IEnumerable<Guid> List(
int maxResults,
DateTime? start = null,
DateTime? finish = null,
ListResultsOrder orderBy = ListResultsOrder.Descending)
{
// do nothing, i.e. return an empty result
return EmptyEnumerable;
}
/// <summary>
/// Run the List command on the first Store from <see cref="Stores"/> that returns a result with any values.
/// Will NOT return a superset of results from all <see cref="Stores"/>.
/// </summary>
public IEnumerable<Guid> List(int maxResults, DateTime? start = null, DateTime? finish = null, ListResultsOrder orderBy = ListResultsOrder.Descending)
{
if (Stores != null)
{
foreach (var store in Stores)
{
var results = store.List(maxResults, start, finish, orderBy);
if (results != null && results.Any())
{
return results;
}
}
}
return new List<Guid>();
}
private string BuildListQuery(DateTime?start = null, DateTime?finish = null, ListResultsOrder orderBy = ListResultsOrder.Descending)
{
var sb = new StringBuilder(@"
SELECT Id
FROM ").Append(MiniProfilersTable).Append(@"
");
if (finish != null)
{
sb.AppendLine("WHERE Started < @finish");
}
if (start != null)
{
sb.AppendLine(finish != null
? " AND Started > @start"
: "WHERE Started > @start");
}
sb.Append("ORDER BY ").Append(orderBy == ListResultsOrder.Descending ? "Started DESC" : "Started ASC");
sb.Append(" LIMIT @maxResults");
return(sb.ToString());
}
private string BuildListQuery(DateTime?start = null, DateTime?finish = null, ListResultsOrder orderBy = ListResultsOrder.Descending)
{
var sb = StringBuilderCache.Get();
sb.Append(@"
Select Id
From MiniProfilers
");
if (finish != null)
{
sb.AppendLine("Where Started < @finish");
}
if (start != null)
{
sb.AppendLine(finish != null
? " And Started > @start"
: "Where Started > @start");
}
sb.Append("Order By ").Append(orderBy == ListResultsOrder.Descending ? "Started Desc" : "Started Asc");
sb.Append("LIMIT({=maxResults})");
return(sb.ToStringRecycle());
}
/// <summary>
/// Asynchronously returns the MiniProfiler Ids for the given search criteria.
/// </summary>
/// <param name="maxResults">The max number of results</param>
/// <param name="start">Search window start</param>
/// <param name="finish">Search window end</param>
/// <param name="orderBy">Result order</param>
/// <returns>The list of GUID keys</returns>
public async Task <IEnumerable <Guid> > ListAsync(int maxResults, DateTime?start = null, DateTime?finish = null, ListResultsOrder orderBy = ListResultsOrder.Descending)
{
return(await GetListQuery(maxResults, start, finish, orderBy).ToListAsync().ConfigureAwait(false));
}
public IEnumerable <Guid> List(int maxResults, DateTime?start = null, DateTime?finish = null, ListResultsOrder orderBy = ListResultsOrder.Decending)
{
// some brave soul that know WCF needs to implement this
throw new NotImplementedException("Looking for a dev who can support the WCF bits in Mini Profiler");
}
/// <summary>
/// List the MiniProfiler Ids for the given search criteria.
/// </summary>
/// <param name="maxResults">The max number of results</param>
/// <param name="start">Search window start</param>
/// <param name="finish">Search window end</param>
/// <param name="orderBy">Result order</param>
/// <returns>The list of GUID keys</returns>
public IEnumerable <Guid> List(int maxResults, DateTime?start = null, DateTime?finish = null, ListResultsOrder orderBy = ListResultsOrder.Descending)
{
return(GetListQuery(maxResults, start, finish, orderBy).ToList());
}
/// <summary>
/// 获取分页数据
/// </summary>
/// <param name="connectionString">数据信息</param>
/// <param name="builder"></param>
/// <param name="template"></param>
/// <param name="orderColumn">排序列</param>
/// <param name="orderBy">排序类型</param>
/// <param name="offset">开始位置</param>
/// <param name="pageRows">每页显示记录数</param>
/// <param name="totalRows">总记录数</param>
/// <returns>the list of query result.</returns>
protected virtual IEnumerable <TEntity> GetPaggingList(string connectionString, SqlSelectBuilder builder, SqlSelectBuilder.SelectTemplate template, string orderColumn, ListResultsOrder orderBy, int?offset, int?pageRows, out int totalRows)
{
return(GetPaggingList <TEntity>(connectionString, builder, template, orderColumn, orderBy, offset, pageRows, out totalRows));
}
/// <summary>
/// 获取分页数据
/// </summary>
/// <param name="connectionString">数据信息</param>
/// <param name="builder"></param>
/// <param name="template"></param>
/// <param name="orderColumn">排序列</param>
/// <param name="orderBy">排序类型</param>
/// <param name="offset">开始位置</param>
/// <param name="pageRows">每页显示记录数</param>
/// <param name="totalRows">总记录数</param>
/// <returns>the list of query result.</returns>
protected virtual IEnumerable <TResult> GetPaggingList <TResult>(string connectionString, SqlSelectBuilder builder, SqlSelectBuilder.SelectTemplate template, string orderColumn, ListResultsOrder orderBy, int?offset, int?pageRows, out int totalRows)
where TResult : class
{
if (string.IsNullOrEmpty(orderColumn))
{
orderColumn = "1";
}
builder.OrderBy(orderBy == ListResultsOrder.Descending ? orderColumn + " DESC" : orderColumn + " ASC");
builder.Limit(offset, pageRows);
var resolveResult = template.ResolveRawSql(0);
IEnumerable <TResult> list = null;
using (var conn = OpenDbConnection(connectionString))
{
string sql = resolveResult.Item1 + ";\n" + resolveResult.Item2;
using (var multiple = conn.QueryMultiple(sql, template.Parameters))
{
list = multiple.Read <TResult>();
totalRows = multiple.ReadFirst <int>();
}
}
return(list);
}
/// <summary>
/// Asynchronously returns the MiniProfiler Ids for the given search criteria.
/// </summary>
/// <param name="maxResults">The max number of results</param>
/// <param name="start">Search window start</param>
/// <param name="finish">Search window end</param>
/// <param name="orderBy">Result order</param>
/// <returns>The list of GUID keys</returns>
public override async Task <IEnumerable <Guid> > ListAsync(int maxResults, DateTime?start = null, DateTime?finish = null, ListResultsOrder orderBy = ListResultsOrder.Descending)
{
using (var conn = GetConnection())
{
var query = BuildListQuery(start, finish, orderBy);
return(await conn.QueryAsync <Guid>(query, new { maxResults, start, finish }).ConfigureAwait(false));
}
}
/// <summary>
/// List the latest profiling results.
/// </summary>
public IEnumerable <Guid> List(int maxResults, DateTime?start = null, DateTime?finish = null, ListResultsOrder orderBy = ListResultsOrder.Descending)
{
//TODO NotImplementedException();
return(null);
}
/// <inheritdoc/> public IEnumerable <Guid> List(int maxResults, DateTime?start = null, DateTime?finish = null, ListResultsOrder orderBy = ListResultsOrder.Descending) => _storage.List(maxResults, start, finish, orderBy);
/// <summary>
/// List the latest profiling results.
/// </summary>
public IEnumerable<Guid> List(int maxResults, DateTime? start = null, DateTime? finish = null, ListResultsOrder orderBy = ListResultsOrder.Descending)
{
//TODO NotImplementedException();
return null;
}
public IEnumerable <Guid> List(int maxResults, DateTime?start = null, DateTime?finish = null,
ListResultsOrder orderBy = ListResultsOrder.Descending)
{
return(Bag.Select(p => p.Id));
}
public Task <IEnumerable <Guid> > ListAsync(int maxResults, DateTime?start = null, DateTime?finish = null, ListResultsOrder orderBy = ListResultsOrder.Descending) => throw new BoomBoom();
public IEnumerable <Guid> List(int maxResults, DateTime?start = default(DateTime?), DateTime?finish = default(DateTime?), ListResultsOrder orderBy = ListResultsOrder.Descending)
{
return(new List <Guid>());
}
public IEnumerable<Guid> List(int maxResults, DateTime? start = null, DateTime? finish = null,
ListResultsOrder orderBy = ListResultsOrder.Descending)
{
return Bag.Select(p => p.Id);
}
public IEnumerable<Guid> List(int maxResults, DateTime? start = null, DateTime? finish = null, ListResultsOrder orderBy = ListResultsOrder.Decending)
{
// some brave soul that know WCF needs to implement this
throw new NotImplementedException("Looking for a dev who can support the WCF bits in Mini Profiler");
}
private IFindFluent <MiniProfiler, Guid> GetListQuery(int maxResults, DateTime?start, DateTime?finish, ListResultsOrder orderBy)
{
var query = FilterDefinition <MiniProfiler> .Empty;
if (start != null)
{
query = Builders <MiniProfiler> .Filter.And(Builders <MiniProfiler> .Filter.Gte(profiler => profiler.Started, (DateTime)start));
}
if (finish != null)
{
query = Builders <MiniProfiler> .Filter.And(Builders <MiniProfiler> .Filter.Lte(profiler => profiler.Started, (DateTime)finish));
}
var profilers = _collection.Find(query).Limit(maxResults);
profilers = orderBy == ListResultsOrder.Descending
? profilers.SortByDescending(p => p.Started)
: profilers.SortBy(p => p.Started);
return(profilers.Project(p => p.Id));
}
/// <summary>
/// 获取数据列表
/// </summary>
/// <param name="connectionString">数据信息</param>
/// <param name="builder"></param>
/// <param name="template"></param>
/// <param name="orderColumn">排序列</param>
/// <param name="orderBy">排序类型</param>
/// <param name="rows">每页显示记录数</param>
/// <returns>the list of query result.</returns>
protected virtual IEnumerable <TEntity> GetList(string connectionString, SqlBuilder builder, SqlBuilder.Template template, string orderColumn, ListResultsOrder orderBy, int rows)
{
return(GetList <TEntity>(connectionString, builder, template, orderColumn, orderBy, rows));
}
/// <summary>
/// List the MiniProfiler Ids for the given search criteria.
/// </summary>
/// <param name="maxResults">The max number of results</param>
/// <param name="start">Search window start</param>
/// <param name="finish">Search window end</param>
/// <param name="orderBy">Result order</param>
/// <returns>The list of GUID keys</returns>
public override IEnumerable <Guid> List(int maxResults, DateTime?start = null, DateTime?finish = null, ListResultsOrder orderBy = ListResultsOrder.Descending)
{
using (var conn = GetConnection())
{
var query = BuildListQuery(start, finish, orderBy);
return(conn.Query <Guid>(query, new { maxResults, start, finish }).AsList());
}
}
/// <summary>
/// 获取数据列表
/// </summary>
/// <param name="connectionString">数据信息</param>
/// <param name="builder"></param>
/// <param name="template"></param>
/// <param name="orderColumn">排序列</param>
/// <param name="orderBy">排序类型</param>
/// <param name="rows">每页显示记录数</param>
/// <returns>the list of query result.</returns>
protected virtual IEnumerable <TResult> GetList <TResult>(string connectionString, SqlBuilder builder, SqlBuilder.Template template, string orderColumn, ListResultsOrder orderBy, int rows)
where TResult : class
{
if (!string.IsNullOrEmpty(orderColumn))
{
builder.OrderBy(orderBy == ListResultsOrder.Descending ? orderColumn + " DESC" : orderColumn + " ASC");
}
builder.Limit(null, rows);
var sql = template.RawSql;
var param = template.Parameters;
return(GetList <TResult>(connectionString, sql, param));
}
/// <summary>
/// Asynchronously run the List command on the first Store from <see cref="Stores"/> that returns a result with any values.
/// Will NOT return a superset of results from all <see cref="Stores"/>.
/// </summary>
/// <param name="maxResults">The maximum number of results to return.</param>
/// <param name="start">(Optional) The start of the date range to fetch.</param>
/// <param name="finish">(Optional) The end of the date range to fetch.</param>
/// <param name="orderBy">(Optional) The order to fetch profiler IDs in.</param>
public async Task <IEnumerable <Guid> > ListAsync(int maxResults, DateTime?start = null, DateTime?finish = null, ListResultsOrder orderBy = ListResultsOrder.Descending)
{
if (Stores == null)
{
return(Enumerable.Empty <Guid>());
}
foreach (var store in Stores)
{
var results = await store.ListAsync(maxResults, start, finish, orderBy).ConfigureAwait(false);
if (results?.Any() == true)
{
return(results);
}
}
return(Enumerable.Empty <Guid>());
}
/// <summary>
/// list the result keys.
/// </summary>
/// <param name="maxResults">
/// The max results.
/// </param>
/// <param name="start">
/// The start.
/// </param>
/// <param name="finish">
/// The finish.
/// </param>
/// <param name="orderBy">
/// order by.
/// </param>
/// <returns>
/// the list of keys in the result.
/// </returns>
public IEnumerable <Guid> List(int maxResults, DateTime?start = null, DateTime?finish = null,
ListResultsOrder orderBy = ListResultsOrder.Descending)
{
throw new NotSupportedException("This method should never run");
}
public override IEnumerable <Guid> List(int maxResults, DateTime?start = null, DateTime?finish = null, ListResultsOrder orderBy = ListResultsOrder.Descending)
{
IMongoQuery query = null;
if (start != null)
{
query = Query.And(Query.GT("Started", (DateTime)start));
}
if (finish != null)
{
query = Query.And(Query.LT("Started", (DateTime)finish));
}
var profilers = Profilers.Find(query).Take(maxResults);
profilers = orderBy == ListResultsOrder.Descending
? profilers.OrderByDescending(p => p.Started)
: profilers.OrderBy(p => p.Started);
return(profilers.Select(p => p.Id));
}
/// <summary>
/// Run the List command on the first Store from <see cref="Stores"/> that returns a result with any values.
/// Will NOT return a superset of results from all <see cref="Stores"/>.
/// </summary>
public IEnumerable <Guid> List(int maxResults, DateTime?start = null, DateTime?finish = null, ListResultsOrder orderBy = ListResultsOrder.Descending)
{
if (Stores != null)
{
foreach (var store in Stores)
{
var results = store.List(maxResults, start, finish, orderBy);
if (results != null && results.Any())
{
return(results);
}
}
}
return(new List <Guid>());
}
/// <summary>
/// List the latest profiling results.
/// </summary>
/// <param name="maxResults">The maximum number of results to return.</param>
/// <param name="start">(Optional) The start of the date range to fetch.</param>
/// <param name="finish">(Optional) The end of the date range to fetch.</param>
/// <param name="orderBy">(Optional) The order to fetch profiler IDs in.</param>
public Task <IEnumerable <Guid> > ListAsync(
int maxResults,
DateTime?start = null,
DateTime?finish = null,
ListResultsOrder orderBy = ListResultsOrder.Descending) => Task.FromResult(List(maxResults, start, finish, orderBy));
/// <summary> /// Implement a basic list search here /// </summary> /// <param name="maxResults">The max number of results.</param> /// <param name="start">The start.</param> /// <param name="finish">The finish.</param> /// <param name="orderBy">order By.</param> /// <returns>the list of GUID keys</returns> public abstract IEnumerable<Guid> List(int maxResults, DateTime? start = null, DateTime? finish = null, ListResultsOrder orderBy = ListResultsOrder.Descending);
/// <summary> /// Implement a basic list search here /// </summary> /// <param name="maxResults">The max number of results.</param> /// <param name="start">The start.</param> /// <param name="finish">The finish.</param> /// <param name="orderBy">order By.</param> /// <returns>the list of GUID keys</returns> public abstract IEnumerable <Guid> List(int maxResults, DateTime?start = null, DateTime?finish = null, ListResultsOrder orderBy = ListResultsOrder.Descending);
/// <summary>
///获取卡券分页数据
/// </summary>
/// <param name="custId">商户Id</param>
/// <param name="title">卡券名称</param>
/// <param name="cardType">卡券类型(CASH:代金券,DISCOUNT:折扣券,GIFT:兑换券,GROUPON:团购券)</param>
/// <param name="status">卡券状态(0:待审核,1:审核中,2:审核通过,2:审核未通过,3:待投放,4:已投放,5:下架)</param>
/// <param name="orderColumn">排序列</param>
/// <param name="orderBy">排序类型</param>
/// <param name="offset">开始位置</param>
/// <param name="pageRows">每页显示记录数</param>
/// <param name="totalRows">总记录数</param>
/// <returns>the list of query result.</returns>
public IEnumerable <MarCard> GetPaggingList(int custId, string title, string cardType, byte?status, string orderColumn, ListResultsOrder orderBy, int?offset, int?pageRows, out int totalRows)
{
var builder = new SqlSelectBuilder();
var template = builder.AddTemplate(new SqlSever2012Template(builder, "SELECT /**select**/", string.Format("FROM {0} /**where**/", TableName), "/**orderby**/", null));
builder.Select("*");
builder.Where("CustId=@CustId", new { CustId = custId });
if (!string.IsNullOrEmpty(title))
{
title = "%" + title + "%";
builder.Where("Title LIKE @Title", new { Title = title });
}
if (!string.IsNullOrEmpty(cardType))
{
builder.Where("CardType = @CardType", new { CardType = cardType });
}
if (status.HasValue)
{
builder.Where("Status = @Status", new { Status = status.Value });
}
return(base.GetPaggingList(Conn, builder, template, orderColumn, orderBy, offset, pageRows, out totalRows));
}
public override IEnumerable<Guid> List(int maxResults, DateTime? start = null, DateTime? finish = null, ListResultsOrder orderBy = ListResultsOrder.Descending)
{
IMongoQuery query = null;
if(start != null){
query = Query.And(Query.GT("Started", (DateTime)start));
}
if(finish != null){
query = Query.And(Query.LT("Started", (DateTime)finish));
}
var profilers = Profilers.Find(query).Take(maxResults);
if (orderBy == ListResultsOrder.Descending)
{
profilers = profilers.OrderByDescending(p => p.Started);
}
else
{
profilers = profilers.OrderBy(p => p.Started);
}
return profilers.Select(p => Guid.Parse(p.Id));
}
public IEnumerable<Guid> List(int maxResults, DateTime? start = null, DateTime? finish = null, ListResultsOrder orderBy = ListResultsOrder.Descending)
{
throw new NotSupportedException();
}
