public async void LiteralWhereTest() { var query = "Select number from integers where literal = '2'"; var result = await SimpleDatabase.Query(query); Assert.Single(result[1]); Assert.Equal("2", result[1][0]); }
public async void WhereTest() { var query = "Select number from integers where number > 2"; var result = await SimpleDatabase.Query(query); for (var i = 0; i < 8; i++) { Assert.Equal(i + 3 + "", result[i + 1][0]); Assert.Single(result[i + 1]); } }
public async void SingleColumnTest() { var query = "Select number from integers"; var result = await SimpleDatabase.Query(query); for (var i = 0; i < 10; i++) { Assert.Equal(i + "", result[i + 1][0]); Assert.Single(result[i + 1]); } }
public async Task SimpleTest() { var query = "Select * from integers"; var result = await SimpleDatabase.Query(query); Assert.Equal("Number", result[0][0]); Assert.Equal("Literal", result[0][1]); for (var i = 0; i < 10; i++) { Assert.Equal(i + "", result[i + 1][0]); Assert.Equal(i + "", result[i + 1][1]); } }
public async void MultipleColumnTableTest() { var query = "Select number, Literal from integers, rationals"; var result = await SimpleDatabase.Query(query); for (var i = 0; i < 10; i++) { Assert.Equal(i + "", result[i + 1][0]); Assert.Equal(i + "", result[i + 1][1]); } for (var i = 10; i < 20; i++) { Assert.Equal(i - 10 + "", result[i + 1][0]); Assert.Equal((i - 10) / 10.0 + "", result[i + 1][1]); } }