MemoryDatabase CreateDatabase(SequentialCheckMaster[] data1)
{
var bin = new DatabaseBuilder()
.Append(data1)
.Build();
return(new MemoryDatabase(bin, internString: false));
}
MemoryDatabase CreateDatabase(Fail[] data1)
{
var bin = new DatabaseBuilder()
.Append(data1)
.Build();
return(new MemoryDatabase(bin, internString: false));
}
MemoryDatabase CreateDatabase(QuestMasterEmptyValidate[] data1, ItemMasterEmptyValidate[] data2)
{
var bin = new DatabaseBuilder()
.Append(data1)
.Append(data2)
.Build();
return(new MemoryDatabase(bin, internString: false));
}
public void EmptyDb()
{
var builder = new DatabaseBuilder();
var emptyDb = builder.Build();
emptyDb.MemoryCount.Is(0);
var data = emptyDb.Save();
data.IsCollection((byte)144);
}
public void EmptyAll()
{
var builder = new DatabaseBuilder();
builder.Append(new Sample[] { });
var bin = builder.Build();
var db = new MemoryDatabase(bin);
db.SampleTable.All.Any().Should().BeFalse();
}
public void MultiDb()
{
var builder = new DatabaseBuilder();
builder.Add("Sample1", CreateData(), x => x.Id);
builder.Add("Sample2", CreateData(), x => x.Id);
builder.Add("Sample3", CreateData(), x => x.Id);
builder.Add("Sample4", CreateData(), x => x.Id);
builder.Add("Sample5", CreateData(), x => x.Id);
var db = builder.Build();
var memory = db.GetMemory <int, Sample>("Sample1", x => x.Id);
memory.Find(8).Age.Is(49);
var savedDb = db.Save();
var newDb = Database.Open(savedDb);
{
var memory2 = newDb.GetMemory <int, Sample>("Sample1", x => x.Id);
memory2.Find(8).Age.Is(49);
}
{
var memory2 = newDb.GetMemory <int, Sample>("Sample2", x => x.Id);
memory2.Find(8).Age.Is(49);
}
{
var memory2 = newDb.GetMemory <int, Sample>("Sample3", x => x.Id);
memory2.Find(8).Age.Is(49);
}
{
var memory2 = newDb.GetMemory <int, Sample>("Sample4", x => x.Id);
memory2.Find(8).Age.Is(49);
}
{
var memory2 = newDb.GetMemory <int, Sample>("Sample5", x => x.Id);
memory2.Find(8).Age.Is(49);
}
// check report diagnostics
var dumper = Database.ReportDiagnostics(savedDb, true);
for (int i = 0; i < dumper.Length; i++)
{
dumper[i].KeyName.Is("Sample" + (i + 1));
dumper[i].Count.Is(10);
foreach (var item in dumper[i].DumpRows())
{
Console.WriteLine(item); // ....
}
}
}
public void All()
{
var builder = new DatabaseBuilder();
builder.Append(CreateData());
var bin = builder.Build();
var db = new MemoryDatabase(bin);
db.SampleTable.All.Select(x => x.Id).ToArray().Should().BeEquivalentTo(new[] { 1, 2, 3, 4, 5, 6, 7, 8, 9, 10 });
db.SampleTable.AllReverse.Select(x => x.Id).ToArray().Should().BeEquivalentTo(new[] { 1, 2, 3, 4, 5, 6, 7, 8, 9, 10 }.Reverse());
db.SampleTable.SortByAge.Select(x => x.Id).OrderBy(x => x).ToArray().Should().BeEquivalentTo(new[] { 1, 2, 3, 4, 5, 6, 7, 8, 9, 10 });
}
public void Issue57()
{
var builder = new DatabaseBuilder();
builder.Append(CreateData());
var bin = builder.Build();
var db = new MemoryDatabase(bin);
db.SampleTable.FindRangeByAge(2, 2).Select(x => x.Id).ToArray().Should().BeEquivalentTo(new int[] { });
db.SampleTable.FindRangeByAge(30, 50).Select(x => x.Id).ToArray().Should().BeEquivalentTo(new int[] { 7, 8 });
db.SampleTable.FindRangeByAge(100, 100).Select(x => x.Id).ToArray().Should().BeEquivalentTo(new int[] { });
}
public void SingleDb()
{
var builder = new DatabaseBuilder();
builder.Append(CreateData());
var bin = builder.Build();
var db = new MemoryDatabase(bin);
db.SampleTable.FindById(8).Age.Should().Be(49);
var tableInfo = MemoryDatabase.GetTableInfo(bin);
tableInfo[0].TableName.Should().Be("Sample");
}
public void SingleDb()
{
var builder = new DatabaseBuilder();
builder.Add("Sample", CreateData(), x => x.Id);
var db = builder.Build();
var memory = db.GetMemory <int, Sample>("Sample", x => x.Id);
memory.Find(8).Age.Is(49);
var savedDb = db.Save();
var newDb = Database.Open(savedDb);
var memory2 = newDb.GetMemory <int, Sample>("Sample", x => x.Id);
memory2.Find(8).Age.Is(49);
}
public void WithNull()
{
var builder = new DatabaseBuilder();
builder.Append(new Sample[] { new Sample
{
Age = 10,
FirstName = null,
Id = 999,
LastName = "abcde"
} });
var bin = builder.Build();
var db = new MemoryDatabase(bin);
var sample = db.SampleTable.FindById(999);
sample.Age.Should().Be(10);
sample.FirstName.Should().BeNull();
sample.LastName.Should().Be("abcde");
}
