public async Task When_executing_some_sql()
{
using (var conn = new SQLiteInMemoryConnection())
{
await conn.ExecuteAsync(TableQuery);
(await conn.ExecuteScalarAsync <int>("SELECT COUNT(*) FROM Person")).ShouldBe(0);
var allRows = await conn.QueryAsync <dynamic>("SELECT * FROM Person");
allRows.ShouldBeEmpty();
var ex = Should.Throw <SQLiteException>(async() => await conn.ExecuteAsync("SELECT * FROM SomeTable;"));
ex.Message.ShouldBe("SQL logic error\r\nno such table: SomeTable");
ex.InnerException.ShouldBeNull();
}
}
public async Task When_binding_an_aggregate_function_to_an_opened_connection()
{
using (var conn = new SQLiteInMemoryConnection())
{
conn.Open();
await conn.ExecuteAsync("CREATE TABLE Numbers(No INTEGER NOT NULL);");
await conn.ExecuteAsync("INSERT INTO Numbers VALUES (1), (2), (3), (4);");
const int InitState = 0;
Func <object[], int, object, object> step = (objects, i, state) =>
{
var newNo = Convert.ToInt32(objects[0]);
return((int)state + newNo);
};
Func <object, object> final = finalState => finalState;
conn.BindFunction(new SQLiteAggregateFunction("FunkySum", 1, InitState, step, final));
var funkySum = await conn.ExecuteScalarAsync <long>("SELECT FunkySum(No) FROM Numbers;");
funkySum.ShouldBe(10);
}
}