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;
}
}
