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