Пример #1
0
        public async Task <IList <TResult> > ToListByFilterAsync <TResult>(Func <IRow, TResult> selector,
                                                                           string fields, Func <IRow, bool> filter, int skip = 0, int take = 0)
        {
            builder.Insert(0, fields);
            builder.Insert(0, "SELECT ");
            if (Limit > 0)
            {
                builder.Append($" LIMIT {Limit}");
            }
            if (AllowFiltering)
            {
                builder.Append(" ALLOW FILTERING");
            }

            var cql = StringBuilderCache.GetStringAndRelease(builder);

            builder = null;
            var db = CqlStore.Get(model.CqlStoreOptions.StoreModelId);
            var rs = await db.ExecuteAsync(cql);

            var list    = new List <TResult>();
            int hasSkip = 0;
            int hasTake = 0;

            foreach (var row in rs)
            {
                if (filter(row))
                {
                    if (hasSkip < skip)
                    {
                        hasSkip++;
                    }
                    else
                    {
                        list.Add(row.Fetch(selector));
                        if (take > 0)
                        {
                            hasTake++;
                            if (hasTake == take)
                            {
                                return(list);
                            }
                        }
                    }
                }
            }
            return(list);
        }
Пример #2
0
        public async Task <IList <TResult> > ToListAsync <TResult>(Func <IRow, TResult> selector, string fields)
        {
            builder.Insert(0, fields);
            builder.Insert(0, "SELECT ");
            if (Limit > 0)
            {
                builder.Append($" LIMIT {Limit}");
            }
            if (AllowFiltering)
            {
                builder.Append(" ALLOW FILTERING");
            }

            var cql = StringBuilderCache.GetStringAndRelease(builder);

            builder = null;
            var db = CqlStore.Get(model.CqlStoreOptions.StoreModelId);
            var rs = await db.ExecuteAsync(cql);

            return(rs.ToList(selector));
        }
Пример #3
0
        public async Task <IList <Entity> > ToListAsync()
        {
            builder.Insert(0, "SELECT *");
            if (Limit > 0)
            {
                builder.Append($" LIMIT {Limit}");
            }
            if (AllowFiltering)
            {
                builder.Append(" ALLOW FILTERING");
            }

            var cql = StringBuilderCache.GetStringAndRelease(builder);

            builder = null;
            var db = CqlStore.Get(model.CqlStoreOptions.StoreModelId);

            Log.Debug(cql);
            var rs = await db.ExecuteAsync(cql);

            return(rs.ToEntityList(model));
        }
Пример #4
0
 public CqlBatch(CqlStore store)
 {
     this.store = store;
     Commands   = new List <CqlCommand>();
 }