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