コード例 #1
0
        /// <summary>
        /// QueryCache级别存储
        /// </summary>
        /// <typeparam name="T"></typeparam>
        /// <param name="cacheValue"></param>
        internal void CacheData <T>(T cacheValue)
        {
            string sqlQueryCacheKey = GetSqlQueryCacheKey();
            string queryCacheKey    = GetQueryCacheKey();

            //如果缓存中存在,则拿到表单位的缓存并更新
            //这里用object类型进行存储,因为字典的value可能有list集合,int,object等多种类型,泛型使用会出现识别异常
            if (CacheStorageManager.IsExist(queryCacheKey, out Dictionary <string, object> t))
            {
                //如果超出单表的query缓存键阈值,则按先后顺序进行移除
                if (t.Count >= CacheOptions.QueryCacheMaxCountPerTable)
                {
                    t.Remove(t.First().Key);
                }

                t.AddOrUpdate(sqlQueryCacheKey, cacheValue);
                CacheStorageManager.Put(queryCacheKey, t, CacheOptions.QueryCacheExpiredTimeSpan);
            }
            //如果缓存中没有表单位的缓存,则直接新增表单位的sql键缓存
            else
            {
                var dic = new Dictionary <string, object> {
                    { sqlQueryCacheKey, cacheValue }
                };
                CacheStorageManager.Put(queryCacheKey, dic, CacheOptions.QueryCacheExpiredTimeSpan);
            }
        }
コード例 #2
0
        /// <summary>
        /// 更新数据到缓存(Add)
        /// </summary>
        /// <typeparam name="TEntity"></typeparam>
        /// <param name="dbContext"></param>
        /// <param name="entity"></param>
        internal void AddCache <TEntity>(TEntity entity)
        {
            var tableName = TableAttribute.GetName(typeof(TEntity));

            //如果存在表级别缓存,则更新数据到缓存
            if (CacheStorageManager.IsExist(GetTableCacheKey(tableName), out List <TEntity> entities))
            {
                if (TableCachingAttribute.IsExistTaleCaching(typeof(TEntity), out TimeSpan tableCacheTimeSpan))
                {
                    entities.Add(entity);
                    //如果过期时间为0,则取上下文的过期时间
                    CacheStorageManager.Put(GetTableCacheKey(tableName), entities, tableCacheTimeSpan == TimeSpan.Zero ? CacheOptions.TableCacheExpiredTimeSpan : tableCacheTimeSpan);
                }
            }
        }
コード例 #3
0
        /// <summary>
        /// 构建sql查询缓存的总key
        /// </summary>
        /// <returns></returns>
        private string GetQueryCacheKey(string collectionName = null)
        {
            string key = $"{CachingConst.CacheKey_QueryCache}{collectionName ?? DbContext.CollectionName}";

            //缓存键更新
            if (!CacheStorageManager.IsExist(CachingConst.GetQueryCacheKeysCacheKey(DbContext.DataBaseName), out HashSet <string> keys))
            {
                keys = new HashSet <string>();
            }

            keys.Add(key);

            CacheStorageManager.Put(CachingConst.GetQueryCacheKeysCacheKey(DbContext.DataBaseName), keys, CacheOptions.MaxExpiredTimeSpan);

            return(key);
        }
コード例 #4
0
        /// <summary>
        /// 更新数据到缓存(Delete)
        /// </summary>
        /// <typeparam name="TEntity"></typeparam>
        /// <param name="dbContext"></param>
        /// <param name="entity"></param>
        internal void DeleteCache <TEntity>(TEntity entity)
        {
            var tableName = TableAttribute.GetName(typeof(TEntity));

            //如果存在表级别缓存,则更新数据到缓存
            if (CacheStorageManager.IsExist(GetTableCacheKey(tableName), out List <TEntity> entities))
            {
                if (TableCachingAttribute.IsExistTaleCaching(typeof(TEntity), out TimeSpan tableCacheTimeSpan))
                {
                    //如果过期时间为0,则取上下文的过期时间
                    TimeSpan timeSpan = tableCacheTimeSpan == TimeSpan.Zero ? CacheOptions.TableCacheExpiredTimeSpan : tableCacheTimeSpan;
                    //从缓存集合中寻找该记录,如果找到,则更新该记录
                    var val = entities.Find(t => t.Equals(entity));
                    if (val != null)
                    {
                        entities.Remove(val);
                        CacheStorageManager.Put(GetTableCacheKey(tableName), entities, tableCacheTimeSpan);
                    }
                }
            }
        }
コード例 #5
0
        /// <summary>
        /// 后台扫描全表数据
        /// </summary>
        /// <typeparam name="TEntity"></typeparam>
        /// <param name="dbContext">上下文</param>
        /// <param name="tableCacheTimeSpan">tableCache过期时间</param>
        private void ScanTableBackground <TEntity>(TimeSpan tableCacheTimeSpan) where TEntity : class
        {
            string scanKey = $"{CachingConst.CacheKey_TableScanning}{DbContext.CollectionName}";

            //1.判断正在扫描键是否存在,如果存在,则返回null,继续等待扫描任务完成
            if (CacheStorageManager.IsExist(scanKey))
            {
                return;
            }

            //设置扫描键,标识当前正在进行扫描
            CacheStorageManager.Put(scanKey, 1, CachingConst.SpanScaningKeyExpiredTime);

            //2.如果没有扫描键,则执行后台扫描任务
            Task.Factory.StartNew(() =>
            {
                //对扫描任务加锁,防止多线程环境多次执行任务
                lock (tableScaningLocker)
                {
                    var tableName = TableAttribute.GetName(typeof(TEntity));
                    //双重校验当前缓存是否存在TableCache,防止重复获取
                    if (CacheStorageManager.IsExist(GetTableCacheKey(tableName)))
                    {
                        return;
                    }

                    //如果过期时间为0,则取上下文的过期时间
                    TimeSpan timeSpan = tableCacheTimeSpan == TimeSpan.Zero ? CacheOptions.TableCacheExpiredTimeSpan : tableCacheTimeSpan;

                    //执行扫描全表任务,并将结果存入缓存中
                    var data = DbContext.GetFullCollectionData <TEntity>();

                    //如果没查到,会存个空的集合
                    CacheStorageManager.Put(GetTableCacheKey(tableName), data ?? new List <TEntity>(), CacheOptions.TableCacheExpiredTimeSpan);
                }
                //将扫描键移除,表示已经扫描完成
                CacheStorageManager.Delete(scanKey);
            });
        }
コード例 #6
0
        /// <summary>
        /// 更新数据到缓存(Delete)
        /// </summary>
        /// <typeparam name="TEntity"></typeparam>
        /// <param name="dbContext"></param>
        /// <param name="filter"></param>
        internal void DeleteCache <TEntity>(Expression <Func <TEntity, bool> > filter)
        {
            Ensure.ArgumentNotNullOrEmpty(filter, nameof(filter));

            var tableName = TableAttribute.GetName(typeof(TEntity));

            //如果存在表级别缓存,则更新数据到缓存
            if (CacheStorageManager.IsExist(GetTableCacheKey(tableName), out List <TEntity> entities))
            {
                if (TableCachingAttribute.IsExistTaleCaching(typeof(TEntity), out TimeSpan tableCacheTimeSpan))
                {
                    //从缓存集合中寻找该记录,如果找到,则更新该记录
                    var list = entities.Where(filter.Compile()).ToList();
                    if (list != null && list.Any())
                    {
                        entities.RemoveAll(t => list.Contains(t));
                        //如果过期时间为0,则取上下文的过期时间
                        CacheStorageManager.Put(GetTableCacheKey(tableName), entities, tableCacheTimeSpan == TimeSpan.Zero ? CacheOptions.TableCacheExpiredTimeSpan : tableCacheTimeSpan);
                    }
                }
            }
        }
コード例 #7
0
        /// <summary>
        /// 更新数据到缓存(Update)
        /// </summary>
        /// <typeparam name="TEntity"></typeparam>
        /// <param name="dbContext"></param>
        /// <param name="entity"></param>
        /// <param name="filter"></param>
        internal void UpdateCache <TEntity>(TEntity entity, Expression <Func <TEntity, bool> > filter)
        {
            Ensure.ArgumentNotNullOrEmpty(filter, nameof(filter));

            var tableName = TableAttribute.GetName(typeof(TEntity));

            //如果存在表级别缓存,则更新数据到缓存
            if (CacheStorageManager.IsExist(GetTableCacheKey(tableName), out List <TEntity> entities))
            {
                if (TableCachingAttribute.IsExistTaleCaching(typeof(TEntity), out TimeSpan tableCacheTimeSpan))
                {
                    //如果过期时间为0,则取上下文的过期时间
                    TimeSpan timeSpan = tableCacheTimeSpan == TimeSpan.Zero ? CacheOptions.TableCacheExpiredTimeSpan : tableCacheTimeSpan;
                    //从缓存集合中寻找该记录,如果找到,则更新该记录
                    var val = entities.Where(filter.Compile()).FirstOrDefault();
                    if (val != null)
                    {
                        val = entity;
                        CacheStorageManager.Put(GetTableCacheKey(tableName), entities, timeSpan);
                    }
                }
            }
        }