private void QueryCacheExpired()
{
using (var db = new LocalTableCache())
{
db.FlushAllCache();
//先查询肯定是没有的
db.Queryable <OperationTest>().Where(t => t.Id == 1).ToList();
Assert.False(db.IsFromCache);
Thread.CurrentThread.Join(_waitScanTableMillisecondsTimeout);
//第二次在缓存中可以查到
db.Queryable <OperationTest>().Where(t => t.Id == 1).ToList();
Assert.True(db.IsFromCache);
Thread.Sleep(_CacheMillisecondsTimeout);
//这时候查询应该从缓存获取不到
db.Queryable <OperationTest>().Where(t => t.Id == 1).ToList();
Assert.False(db.IsFromCache);
}
}
public void QueryCount(int count)
{
using (var db = new LocalTableCache())
{
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 LocalTableCache())
{
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 LocalTableCache())
{
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 LocalTableCache())
{
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);
}
}
}
private void QueryWhereWithUnSameCondition()
{
using (var db = new LocalTableCache())
{
db.FlushAllCache();
db.Queryable <OperationTest>().Where(t => t.Id == 1).FirstOrDefault();
Assert.False(db.IsFromCache);
Thread.CurrentThread.Join(_waitScanTableMillisecondsTimeout);
db.Queryable <OperationTest>().Where(t => t.Id == 2).FirstOrDefault();
Assert.True(db.IsFromCache);
}
}
private void QueryAll()
{
using (var db = new LocalTableCache())
{
db.FlushAllCache();
db.Queryable <OperationTest>().ToList();
Assert.False(db.IsFromCache);
Thread.CurrentThread.Join(_waitScanTableMillisecondsTimeout);
db.Queryable <OperationTest>().ToList();
Assert.True(db.IsFromCache);
}
}
private void QueryCount()
{
using (var db = new LocalTableCache())
{
db.FlushAllCache();
db.Queryable <OperationTest>().Where(t => t.StringKey.Contains("test")).Count();
Assert.False(db.IsFromCache);
Thread.CurrentThread.Join(_waitScanTableMillisecondsTimeout);
var result = db.Queryable <OperationTest>().Where(t => t.StringKey.Contains("test")).Count();
Assert.True(db.IsFromCache);
Assert.Equal(0, result);
}
}
public void QueryAdd()
{
using (var db = new LocalTableCache())
{
//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);
}
}
