public WhereTest() { _db = new SQLiteDb(); _db.DataTable.Insert(Enumerable.Range(0, RowCount).Select(i => new Data { TextValue = $"Some Text {i}" })); }
public AggregateTest() { _db = new SQLiteDb <string>(); _db.DataTable.Insert(Enumerable.Range(0, RowCount).Select(i => new Data <string> { Value = $"Some Text {i}" })); }
public StringTest() { _db = new SQLiteDb <string>(); _db.DataTable.Insert(new Data <string> { Value = TestString }); }
public DateTimeTest() { _db = new SQLiteDb <DateTime>(); _db.DataTable.Insert(new Data <DateTime> { Value = _testDate }); }
public TimeSpanTest() { _db = new SQLiteDb <TimeSpan>(); _db.DataTable.Insert(new Data <TimeSpan> { Value = _testTimeSpan }); }
public void TestFirstOrDefault() { using (var db = new SQLiteDb <string>()) { Assert.Null(db.DataTable.FirstOrDefault()); db.DataTable.Insert(new Data <string>() { Value = "Random Text" }); db.DataTable.Insert(new Data <string>() { Value = "Random Text 2" }); var result = db.DataTable.FirstOrDefault(); Assert.NotNull(result); Assert.Equal(1, result.Id); Assert.Equal("Random Text", result.Value); result = db.DataTable.FirstOrDefault(d => d.Id == 2); Assert.NotNull(result); Assert.Equal(2, result.Id); Assert.Equal("Random Text 2", result.Value); Assert.Null(db.DataTable.FirstOrDefault(d => d.Id == 3)); } }
public void TestFirst() { using (var db = new SQLiteDb <string>()) { Assert.Throws <InvalidOperationException>(() => db.DataTable.First()); db.DataTable.Insert(new Data <string>() { Value = "Random Text" }); db.DataTable.Insert(new Data <string>() { Value = "Random Text 2" }); var result = db.DataTable.First(); Assert.Equal(1, result.Id); Assert.Equal("Random Text", result.Value); result = db.DataTable.First(d => d.Id == 2); Assert.Equal(2, result.Id); Assert.Equal("Random Text 2", result.Value); Assert.Throws <InvalidOperationException>(() => db.DataTable.First(d => d.Id == 3)); } }
public void TestAny() { using (var db = new SQLiteDb <string>()) { Assert.False(db.DataTable.Any()); db.DataTable.Insert(new Data <string>() { Value = "Random Text" }); db.DataTable.Insert(new Data <string>() { Value = "Random Text 2" }); Assert.True(db.DataTable.Any()); Assert.True(db.DataTable.Any(d => d.Id == 1)); Assert.True(db.DataTable.Any(d => d.Id == 2)); Assert.False(db.DataTable.Any(d => d.Id == 3)); Assert.True(db.DataTable.Any(d => d.Value == "Random Text")); Assert.True(db.DataTable.Any(d => d.Value == "Random Text 2")); Assert.False(db.DataTable.Any(d => d.Value == "Other Text")); } }
private static void SimpleTest <T>(T value) { using (var db = new SQLiteDb <T>()) { db.DataTable.Insert(new Data <T> { Value = value }); Assert.Equal(value, db.DataTable.Single().Value); } }
public void TestContains() { using (var db = new SQLiteDb <string>()) { db.DataTable.Insert(new Data <string>() { Value = "Random Text" }); db.DataTable.Insert(new Data <string>() { Value = "Random Text 2" }); Assert.True(db.DataTable.Select(d => d.Id).Contains(1)); Assert.True(db.DataTable.Select(d => d.Id).Contains(2)); Assert.False(db.DataTable.Select(d => d.Id).Contains(3)); Assert.True(db.DataTable.Select(d => d.Value).Contains("Random Text")); Assert.True(db.DataTable.Select(d => d.Value).Contains("Random Text 2")); Assert.False(db.DataTable.Select(d => d.Value).Contains("Other Text")); } }