public void Test1() { var table = ents.GetTable<Tweets>(); int RowsNo = 2000; List<Tweets> entL = new List<Tweets>(); for (int i = 0; i < RowsNo; i++) { var ent = new Tweets() { tweet_id = Guid.NewGuid(), author = "test" + i.ToString(), body = "body" + i.ToString(), isok = (i % 2 == 0) }; ent.exampleSet.Add(i.ToString()); ent.exampleSet.Add((i + 1).ToString()); ent.exampleSet.Add((i - 1).ToString()); table.AddNew(ent, EntityTrackingMode.KeepAttachedAfterSave); entL.Add(ent); } ents.SaveChanges(SaveChangesMode.Batch); var cnt = table.Count().Execute(); Dev.Assert.Equal(RowsNo,cnt); foreach(var ent in entL) table.Delete(ent); ents.SaveChanges(SaveChangesMode.Batch); var cnt2 = table.Count().Execute(); Dev.Assert.Equal(0, cnt2); }
public void TestBuffering() { var table = ents.GetTable<Tweets>(); var q2 = (from e in table where e.idx.CqlToken() <= 0 select e).Take(10).OrderBy((e) => e.idx).ThenByDescending((e) => e.isok); var qxx = q2.ToString(); int RowsNb = 10; for (int i = 0; i < RowsNb; i++) { var ent = new Tweets() { tweet_id = Guid.NewGuid(), author = "author" + i.ToString(), isok =i%2 == 0, body = "blablabla", idx = i}; table.AddNew(ent, EntityTrackingMode.KeepAttachedAfterSave); } var ent2 = new Tweets() { tweet_id = Guid.NewGuid(), author = "author" + RowsNb+1, isok = false, body = "blablabla", idx = RowsNb + 1 }; table.AddNew(ent2, EntityTrackingMode.KeepAttachedAfterSave); ents.SaveChanges(SaveChangesMode.OneByOne); table.Attach(ent2, EntityUpdateMode.ModifiedOnly); ent2.author = "Koko"; ents.SaveChanges(SaveChangesMode.OneByOne); var iq = table.Count(); var c = iq.Execute(); foreach (var r in (from e in table where e.isok == true && e.idx == 0 select e).Execute()) { var x = r; } foreach (var r in (from e in table where e.isok == true && new int[] { 0, 1, 2 }.Contains(e.idx) select new { x = e.idx, y = e.tweet_id }).Execute()) { var x = r; } foreach (var r in (from e in table where e.isok == false && e.idx == 0 select new { Key = e.idx }).Execute()) { var x = r; } foreach (var r in (from e in table where e.isok == true && e.idx == 0 select new { Key = e.idx, e.isok }).Execute()) { var x = r; } foreach (var r in (from e in table where e.isok == true && e.idx == 0 select new X() { x = e.author, y = e.idx }).Execute()) { var x = r; } foreach (var r in (from e in table where e.isok == false && e.idx == 0 select e.author).Execute()) { var x = r; } }