public void Indexing3()
{
var db = new DbInstance(@"MyDatabase3\Indexing");
db.Map<AData, PrototypeBasedData>().Automap(i => i.Id, true)
.WithIndex("LastName", i => i.Name, StringComparer.CurrentCulture)
.WithIndex("LastNameText", i => i.Name, StringComparer.CurrentCultureIgnoreCase);
db.Initialize();
var table = db.Table<AData>();
table.Purge();
db.BulkWrite(() =>
{
for (var s = 0; s < 100; s++)
for (var i = 0; i < 10; i++)
table.Save(new PrototypeBasedData { Name = "Test" + i });
for (var s = 0; s < 100; s++)
for (var i = 0; i < 10; i++)
table.Save(new PrototypeBasedData { Name = "TeST" + i });
});
var list1count = table.IndexQueryByKey("LastName", "Test5").Count();
var list2count = table.IndexQueryByKey("LastNameText", "TEst5").Count();
Assert.AreEqual(list1count, 100);
Assert.AreEqual(list2count, 200);
}
public void Indexing2()
{
var db = new DbInstance(@"MyDatabase2\Indexing");
db.Map<IData, InterfaceBasedData>().Automap(i => i.Id, true)
.WithIndex("LastName", i => i.Name, StringComparer.CurrentCulture)
.WithIndex("LastNameText", i => i.Name, StringComparer.CurrentCultureIgnoreCase);
db.Initialize();
var table = db.Table<IData>();
table.Purge();
db.BulkWrite(() =>
{
for (var s = 0; s < 100; s++)
for (var i = 0; i < 10; i++)
table.Save(new InterfaceBasedData { Name = "Test" + i });
for (var s = 0; s < 100; s++)
for (var i = 0; i < 10; i++)
table.Save(new InterfaceBasedData { Name = "TeST" + i });
});
var list1 = table.LoadAll("LastName", "Test5");
var list2 = table.LoadAll("LastNameText", "TEst5");
Assert.AreEqual(list1.Count, 100);
Assert.AreEqual(list2.Count, 200);
}
public void Indexing2()
{
db = new DbInstance(@"MyDatabase2\Indexing");
db.Map <IData, InterfaceBasedData>().Automap(i => i.Id, true)
.WithIndex("LastName", i => i.Name, StringComparer.CurrentCulture)
.WithIndex("LastNameText", i => i.Name, StringComparer.CurrentCultureIgnoreCase);
db.Initialize();
var table = db.Table <IData>();
table.Purge();
db.BulkWrite(() =>
{
for (var s = 0; s < 100; s++)
{
for (var i = 0; i < 10; i++)
{
table.Save(new InterfaceBasedData {
Name = "Test" + i
});
}
}
for (var s = 0; s < 100; s++)
{
for (var i = 0; i < 10; i++)
{
table.Save(new InterfaceBasedData {
Name = "TeST" + i
});
}
}
});
var list1count = table.IndexQuery <string>("LastName").Key("Test5").Count();
var list2count = table.IndexQuery <string>("LastNameText").Key("TEst5").Count();
Assert.Equal(list1count, 100);
Assert.Equal(list2count, 200);
var list3count = table.IndexQuery <string>("LastName").GreaterThan("Test5").Count();
var list4count = table.IndexQuery <string>("LastName").LessThan("Test6").Count();
var list5count = table.IndexQuery <string>("LastName").LessThan("Test6").GreaterThan("Test5").Count();
Assert.Equal(900, list3count);
Assert.Equal(1200, list4count);
Assert.Equal(100, list5count);
var list6count = table.IndexQuery <string>("LastName").GreaterThan("Test5", true).Count();
var list7count = table.IndexQuery <string>("LastName").LessThan("Test6", true).Count();
var list8count = table.IndexQuery <string>("LastName").LessThan("Test6", true).GreaterThan("Test5", true).Count();
Assert.Equal(1000, list6count);
Assert.Equal(1300, list7count);
Assert.Equal(300, list8count);
}
public void SaveData()
{
var swatch = DateTime.Now;
db.BulkWrite(() =>
{
table.Purge();
var key = 1;
var newObj = new MyData {
Id = key, Name = "test"
};
table.Save(newObj);
var obj = table.LoadByKey(key);
Assert.Equal(newObj.Name, obj.Name);
});
}
public void SaveData2()
{
db.BulkWrite(() =>
{
table.Purge();
var key = 1;
var newObj = new InterfaceBasedData {
Id = key, Name = "test"
};
table.Save(newObj);
var obj = table.LoadByKey(key);
Assert.Equal(newObj.Name, obj.Name);
});
}
public void Indexing2()
{
var db = new DbInstance(@"MyDatabase2\Indexing");
db.Map<IData, InterfaceBasedData>().Automap(i => i.Id, true)
.WithIndex("LastName", i => i.Name, StringComparer.CurrentCulture)
.WithIndex("LastNameText", i => i.Name, StringComparer.CurrentCultureIgnoreCase);
db.Initialize();
var table = db.Table<IData>();
table.Purge();
db.BulkWrite(() =>
{
for (var s = 0; s < 100; s++)
for (var i = 0; i < 10; i++)
table.Save(new InterfaceBasedData { Name = "Test" + i });
for (var s = 0; s < 100; s++)
for (var i = 0; i < 10; i++)
table.Save(new InterfaceBasedData { Name = "TeST" + i });
});
var list1count = table.IndexQuery<string>("LastName").Key("Test5").Count();
var list2count = table.IndexQuery<string>("LastNameText").Key("TEst5").Count();
Assert.AreEqual(list1count, 100);
Assert.AreEqual(list2count, 200);
var list3count = table.IndexQuery<string>("LastName").GreaterThan("Test5").Count();
var list4count = table.IndexQuery<string>("LastName").LessThan("Test6").Count();
var list5count = table.IndexQuery<string>("LastName").LessThan("Test6").GreaterThan("Test5").Count();
Assert.AreEqual(900, list3count);
Assert.AreEqual(1200, list4count);
Assert.AreEqual(100, list5count);
var list6count = table.IndexQuery<string>("LastName").GreaterThan("Test5", true).Count();
var list7count = table.IndexQuery<string>("LastName").LessThan("Test6", true).Count();
var list8count = table.IndexQuery<string>("LastName").LessThan("Test6", true).GreaterThan("Test5", true).Count();
Assert.AreEqual(1000, list6count);
Assert.AreEqual(1300, list7count);
Assert.AreEqual(300, list8count);
}
public void Indexing()
{
db = new DbInstance(@"My Database\Indexing");
db.Map <MyData>().Automap(i => i.Id, true)
.WithIndex("LastName", i => i.Name, StringComparer.CurrentCulture)
.WithIndex("LastNameText", i => i.Name, StringComparer.CurrentCultureIgnoreCase);
db.Initialize();
var table = db.Table <MyData>();
table.Purge();
db.BulkWrite(() =>
{
for (var s = 0; s < 100; s++)
{
for (var i = 0; i < 10; i++)
{
table.Save(new MyData {
Name = "Test" + i
});
}
}
for (var s = 0; s < 100; s++)
{
for (var i = 0; i < 10; i++)
{
table.Save(new MyData {
Name = "TeST" + i
});
}
}
});
var list1count = table.IndexQueryByKey("LastName", "Test5").Count();
var list2count = table.IndexQueryByKey("LastNameText", "TEst5").Count();
Assert.Equal(list1count, 100);
Assert.Equal(list2count, 200);
}
public void IndexingDetails()
{
var db = new DbInstance(@"My Database\Indexing2");
db.Map<MyData>().Automap(i => i.Id, true).WithIndex("Test", i => i.IntField);
db.Initialize();
var table = db.Table<MyData>();
table.Purge();
db.BulkWrite(() =>
{
table.Save(new MyData { IntField = 1 });
table.Save(new MyData { IntField = 1 });
table.Save(new MyData { IntField = 1 });
table.Save(new MyData { IntField = 1 });
table.Save(new MyData { IntField = 1 });
table.Save(new MyData { IntField = 4 });
table.Save(new MyData { IntField = 4 });
table.Save(new MyData { IntField = 4 });
table.Save(new MyData { IntField = 4 });
table.Save(new MyData { IntField = 4 });
table.Save(new MyData { IntField = 3 });
table.Save(new MyData { IntField = 3 });
table.Save(new MyData { IntField = 3 });
table.Save(new MyData { IntField = 3 });
table.Save(new MyData { IntField = 3 });
table.Save(new MyData { IntField = 4 });
table.Save(new MyData { IntField = 5 });
table.Save(new MyData { IntField = 6 });
table.Save(new MyData { IntField = 6 });
table.Save(new MyData { IntField = 6 });
table.Save(new MyData { IntField = 6 });
table.Save(new MyData { IntField = 6 });
table.Save(new MyData { IntField = 6 });
table.Save(new MyData { IntField = 7 });
table.Save(new MyData { IntField = 8 });
table.Save(new MyData { IntField = 8 });
table.Save(new MyData { IntField = 8 });
table.Save(new MyData { IntField = 8 });
table.Save(new MyData { IntField = 8 });
table.Save(new MyData { IntField = 9 });
});
var list1 = table.LoadAll();
var index = table.IndexQuery<int>("Test");
Assert.AreEqual(index.Key(1).Count(), list1.Count(i => i.IntField == 1));
Assert.AreEqual(index.Key(8).Count(), list1.Count(i => i.IntField == 8));
Assert.AreEqual(index.GreaterThan(6, true).LessThan(8).Count(), list1.Count(i => i.IntField >= 6 && i.IntField < 8));
IdSequenceEqual(index.GreaterThan(6).LessThan(8).ToList(), list1.Where(i => i.IntField > 6 && i.IntField < 8));
IdSequenceEqual(index.LessThan(8).ToList(), list1.Where(i => i.IntField < 8));
IdSequenceEqual(index.GreaterThan(6, true).ToList(), list1.Where(i => i.IntField >= 6));
IdSequenceEqual(index.GreaterThan(7, true).LessThan(7).ToList(), list1.Where(i => i.IntField >= 7 && i.IntField < 7));
IdSequenceEqual(index.GreaterThan(7).LessThan(7, true).ToList(), list1.Where(i => i.IntField > 7 && i.IntField <= 7));
}
public void IndexingDetails()
{
db = new DbInstance(@"My Database\Indexing2");
db.Map <MyData>().Automap(i => i.Id, true).WithIndex("Test", i => i.IntField);
db.Initialize();
var table = db.Table <MyData>();
table.Purge();
db.BulkWrite(() =>
{
table.Save(new MyData {
IntField = 1
});
table.Save(new MyData {
IntField = 1
});
table.Save(new MyData {
IntField = 1
});
table.Save(new MyData {
IntField = 1
});
table.Save(new MyData {
IntField = 1
});
table.Save(new MyData {
IntField = 4
});
table.Save(new MyData {
IntField = 4
});
table.Save(new MyData {
IntField = 4
});
table.Save(new MyData {
IntField = 4
});
table.Save(new MyData {
IntField = 4
});
table.Save(new MyData {
IntField = 3
});
table.Save(new MyData {
IntField = 3
});
table.Save(new MyData {
IntField = 3
});
table.Save(new MyData {
IntField = 3
});
table.Save(new MyData {
IntField = 3
});
table.Save(new MyData {
IntField = 4
});
table.Save(new MyData {
IntField = 5
});
table.Save(new MyData {
IntField = 6
});
table.Save(new MyData {
IntField = 6
});
table.Save(new MyData {
IntField = 6
});
table.Save(new MyData {
IntField = 6
});
table.Save(new MyData {
IntField = 6
});
table.Save(new MyData {
IntField = 6
});
table.Save(new MyData {
IntField = 7
});
table.Save(new MyData {
IntField = 8
});
table.Save(new MyData {
IntField = 8
});
table.Save(new MyData {
IntField = 8
});
table.Save(new MyData {
IntField = 8
});
table.Save(new MyData {
IntField = 8
});
table.Save(new MyData {
IntField = 9
});
});
var list1 = table.LoadAll();
var index = table.IndexQuery <int>("Test");
Assert.Equal(index.Key(1).Count(), list1.Count(i => i.IntField == 1));
Assert.Equal(index.Key(8).Count(), list1.Count(i => i.IntField == 8));
Assert.Equal(index.GreaterThan(6, true).LessThan(8).Count(), list1.Count(i => i.IntField >= 6 && i.IntField < 8));
IdSequenceEqual(index.GreaterThan(6).LessThan(8).ToList(), list1.Where(i => i.IntField > 6 && i.IntField < 8));
IdSequenceEqual(index.LessThan(8).ToList(), list1.Where(i => i.IntField < 8));
IdSequenceEqual(index.GreaterThan(6, true).ToList(), list1.Where(i => i.IntField >= 6));
IdSequenceEqual(index.GreaterThan(7, true).LessThan(7).ToList(), list1.Where(i => i.IntField >= 7 && i.IntField < 7));
IdSequenceEqual(index.GreaterThan(7).LessThan(7, true).ToList(), list1.Where(i => i.IntField > 7 && i.IntField <= 7));
}
