Exemple #1
0
        public List <int> SearchOne(SearchInfo info, ReadOptions ro, bool partial, bool timeLimited, int timeLimitInMs, out double?searchPercintile, int?steps = null, int?start_step = null)
        {
            searchPercintile = null;
            if (!info.Name.ToLower().EndsWith("search") && !info.Name.ToLower().EndsWith("searchs"))
            {
                throw new LinqDbException("Linqdb: only string properties named ...Search (or ...SearchS) are indexed and can be searched.");
            }
            int totalSteps = GetLastStep(info.TableInfo.Name);

            if (!timeLimited)
            {
                return(MakeSearch(info.SearchQuery, info.TableInfo, info.Name, ro, partial, steps, start_step));
            }
            else
            {
                var sw = new Stopwatch();
                sw.Start();
                int oneSearchSteps = 50;
                var res            = new List <int>();
                int stepCount      = 0;
                for (; sw.ElapsedMilliseconds < timeLimitInMs && stepCount <= totalSteps; stepCount += oneSearchSteps)
                {
                    res.AddRange(MakeSearch(info.SearchQuery, info.TableInfo, info.Name, ro, partial, oneSearchSteps, stepCount));
                }
                if (stepCount > totalSteps)
                {
                    searchPercintile = 100;
                }
                else
                {
                    searchPercintile = (double)(stepCount * 100) / (double)totalSteps;
                }
                return(res);
            }
        }
Exemple #2
0
        public IDbQueryable <T> Search <T, TKey>(IDbQueryable <T> source, Expression <Func <T, TKey> > keySelector, string search_query, bool partial, bool timeLimited, int timeLimitInMs, int?start_step, int?steps)
        {
            if (start_step != null && steps == null || start_step == null && steps != null)
            {
                throw new LinqDbException("Linqdb: start_step and steps parameters must be used together.");
            }

            CheckTableInfo <T>();
            if (string.IsNullOrEmpty(search_query))
            {
                return(source);
            }
            if (source.LDBTree == null)
            {
                source.LDBTree = new QueryTree();
            }
            var tree = source.LDBTree;

            if (tree.SearchInfo == null)
            {
                tree.SearchInfo = new List <SearchInfo>();
            }
            var info = new SearchInfo();

            tree.SearchInfo.Add(info);
            info.SearchQuery    = search_query;
            info.Partial        = partial;
            info.TimeLimited    = timeLimited;
            info.SearchTimeInMs = timeLimitInMs;
            info.Start_step     = start_step;
            info.Steps          = steps;

            var par        = keySelector.Parameters.First();
            var name       = SharedUtils.GetPropertyName(keySelector.Body.ToString());
            var table_info = GetTableInfo(typeof(T).Name);

            info.TableInfo = table_info;
            info.Name      = name;

            source.LDBTree.Prev    = info;
            source.LDBTree.Prev.Id = source.LDBTree.Counter + 1;
            source.LDBTree.Counter++;

            return(source);
        }