public async Task CountQueryTestAsync()
{
var queryDispatcher =
new QueryDispatcher(
new QueryExecutor(
new CommandPreparer(),
new ConnectionFactory(ConnectionString.Default)));
var arrangeQueries = new String[]
{
"DROP TABLE IF EXISTS count_query_test;",
"CREATE TABLE count_query_test (value TEXT NOT NULL);",
"INSERT INTO count_query_test VALUES ('Sigma');",
"INSERT INTO count_query_test VALUES ('Nu');",
"INSERT INTO count_query_test VALUES ('Iota');",
"INSERT INTO count_query_test VALUES ('Delta');",
"INSERT INTO count_query_test VALUES ('697');",
};
foreach (var arrangeQuery in arrangeQueries)
{
await queryDispatcher.ExecuteAsync(new Query(arrangeQuery));
}
var countQuery = "SELECT COUNT(*) FROM count_query_test;";
var count = await queryDispatcher.ExecuteScalarAsync <Int64>(new Query(countQuery));
Assert.Equal(count, 5);
}
