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