public void EmptyProductTest()
{
var dialect = new Dialect.SQLiteDialect();
var command = Substitute.For<IDbCommand>();
dialect.ConfigureCommand(command, new SqlQuery<Product>());
Assert.AreEqual(command.CommandText, "SELECT [Sku], [Description] FROM [Product]");
}
public void EmptyOrderDetailTest()
{
var dialect = new Dialect.SQLiteDialect();
var command = Substitute.For<IDbCommand>();
dialect.ConfigureCommand(command, new SqlQuery<OrderDetail>());
Assert.AreEqual(command.CommandText, "SELECT [Id], [OrderId], [Sku], [Quantity], [Price] FROM [OrderDetail]");
}
public void EmptyOrderTest()
{
var dialect = new Dialect.SQLiteDialect();
var command = Substitute.For<IDbCommand>();
dialect.ConfigureCommand(command, new SqlQuery<Order>());
Assert.AreEqual(command.CommandText, "SELECT [Id], [CreatedDate], [CustomerName] FROM [Order]");
}
public void SimpleSelectAllQuery()
{
using(var connection = new SQLiteConnection("Data Source=testdb.db;Version=3;Read Only=True;"))
{
connection.Open();
var dialect = new Dialect.SQLiteDialect();
var runner = new QueryRunner(connection, dialect);
var query = new SqlQuery<Order>();
var results = runner.ExecuteReader(query).ToList();
Assert.AreEqual(10, results.Count);
results.Select(order => order.Id).AssertSeqeuenceEquals(1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
}
}
