public async Task SingleQueryThrowsIfEmptyTestAsync()
{
var queryDispatcher =
new QueryDispatcher(
new QueryExecutor(
new CommandPreparer(),
new ConnectionFactory(ConnectionString.Default)));
var setupQueries = new String[]
{
"DROP TABLE IF EXISTS single_query_throws_if_empty_test;",
"CREATE TABLE single_query_throws_if_empty_test (id INT NOT NULL, value TEXT NOT NULL);"
};
foreach (var setupQuery in setupQueries)
{
await queryDispatcher.ExecuteAsync(new Query(setupQuery));
}
var listQuery = @"
SELECT id, value
FROM single_query_throws_if_empty_test;" ;
await Assert.ThrowsAsync <InvalidOperationException>(async() =>
{
await queryDispatcher.SingleAsync(new Query(listQuery), row =>
{
return(new
{
id = row.ReadInt32("id"),
value = row.ReadString("value")
});
});
});
}
public async Task SingleQueryTestAsync()
{
var queryDispatcher =
new QueryDispatcher(
new QueryExecutor(
new CommandPreparer(),
new ConnectionFactory(ConnectionString.Default)));
var setupQueries = new String[]
{
"DROP TABLE IF EXISTS single_query_test;",
"CREATE TABLE single_query_test (id INT NOT NULL, value TEXT NOT NULL);",
"INSERT INTO single_query_test VALUES (1, 'This');",
"INSERT INTO single_query_test VALUES (2, 'is');",
"INSERT INTO single_query_test VALUES (3, 'a');",
"INSERT INTO single_query_test VALUES (4, 'test');"
};
foreach (var setupQuery in setupQueries)
{
await queryDispatcher.ExecuteAsync(new Query(setupQuery));
}
var listQuery = @"
SELECT id, value
FROM single_query_test
WHERE id = 2;" ;
var item = await queryDispatcher.SingleAsync(new Query(listQuery), row =>
{
return(new
{
id = row.ReadInt32("id"),
value = row.ReadString("value")
});
});
Assert.NotNull(item);
Assert.Equal(item.id, 2);
Assert.Equal(item.value, "is");
}