public void QueryCount(int count)
{
using (var db = new RedisQueryCache())
{
for (int i = 0; i < count; i++)
{
var re = db.Queryable <OperateTestModel>().Where(t => t.StringKey.Contains("test")).Count();
Assert.Equal(1000, re);
}
}
}
public void QueryAll(int count)
{
using (var db = new RedisQueryCache())
{
for (int i = 0; i < count; i++)
{
var re = db.Queryable <OperateTestModel>().ToList();
Assert.Equal(1000, re.Count);
}
}
}
public void QueryCacheExpired(int count)
{
using (var db = new RedisQueryCache())
{
for (int i = 0; i < count; i++)
{
var re = db.Queryable <OperateTestModel>().Where(t => t.StringKey.Contains("test")).ToOne();
Assert.NotNull(re);
}
}
}
public void QueryWhereWithUnSameCondition(int count)
{
using (var db = new RedisQueryCache())
{
for (int i = 0; i < count; i++)
{
var re = db.Queryable <OperateTestModel>().Where(t => t.Id == 1).ToOne();
var re1 = db.Queryable <OperateTestModel>().Where(t => t.Id == 2).ToOne();
Assert.NotEqual(re.StringKey, re1.StringKey);
}
}
}
public void QueryBugRepaire2()
{
int metaObjectId = 1;
using (var db = new RedisQueryCache())
{
for (int i = 0; i < 3; i++)
{
var re = db.Queryable <OperateTestModel>().Where(t => t.IntNullKey == 1 && t.IntKey == metaObjectId).ToList();
Assert.NotNull(re);
}
}
}
public void QueryAdd()
{
using (var db = new RedisQueryCache())
{
//1.先查询肯定是没有的
var re0 = db.Queryable <OperateTestModel>().Where(t => t.StringKey.StartsWith("CacheAddTest")).ToList();
Assert.Null(re0);
db.Add(new OperateTestModel
{
IntKey = 123,
StringKey = "CacheAddTest123"
});
//2.这时候查询应该有一条，这次查询才加入缓存
var re = db.Queryable <OperateTestModel>().Where(t => t.StringKey.StartsWith("CacheAddTest")).ToList();
Assert.Single(re);
//3.重复查询，这次是从缓存查的，还是一条
var re2 = db.Queryable <OperateTestModel>().Where(t => t.StringKey.StartsWith("CacheAddTest")).ToList();
Assert.Single(re2);
//再次新增，清楚一级缓存
db.Add(new OperateTestModel
{
IntKey = 123,
StringKey = "CacheAddTest123"
});
//4.这次查应该从数据库查询，加入缓存，2条
var re4 = db.Queryable <OperateTestModel>().Where(t => t.StringKey.StartsWith("CacheAddTest")).ToList();
Assert.Equal(2, re4.Count);
db.Delete <OperateTestModel>(t => t.StringKey.StartsWith("CacheAddTest"));
//4.删除完毕以后，查询是没有的
var re3 = db.Queryable <OperateTestModel>().Where(t => t.StringKey.StartsWith("CacheAddTest")).ToList();
Assert.Null(re3);
}
}
