public void CanExecuteReaderFromDbCommand()
{
using (TestResourceFile dbFile = new TestResourceFile(this, "Datastore.sdf"))
{
using (SmartClientDatabase database = DatabaseFactory.CreateDatabase() as SmartClientDatabase)
{
string queryString = @"select * from TestTable";
DbCommand queryCommand = new SqlCeCommand();
queryCommand.CommandText = queryString;
string accumulator = "";
using (IDataReader reader = database.ExecuteReader(queryCommand))
{
while (reader.Read())
{
accumulator += ((string)reader["TestColumn2"]).Trim();
}
}
Assert.AreEqual("UnoDosTresCuatro", accumulator);
}
}
}
public void CanGetRequestsIteratorByPrice()
{
using (SmartClientDatabase database = GetDatabase())
{
IRequestQueue queue = new DatabaseRequestQueue(database, "Requests");
Assert.AreEqual(0, queue.GetCount());
Request request1 = CreateRequest();
request1.Behavior.Stamps = 8;
Request request2 = CreateRequest();
request2.Behavior.Stamps = 3;
Request request3 = CreateRequest();
request3.Behavior.Stamps = 5;
queue.Enqueue(request1);
queue.Enqueue(request2);
queue.Enqueue(request3);
Assert.AreEqual(3, queue.GetCount());
List <Request> list = new List <Request>();
foreach (Request req in queue.GetRequests(5))
{
list.Add(req);
queue.Remove(req);
}
Assert.AreEqual(2, list.Count);
Assert.IsTrue(AreEqual(request1, list[0]));
Assert.IsTrue(AreEqual(request3, list[1]));
Assert.AreEqual(1, queue.GetCount());
}
}
public void RequestsIteratorIsFifo()
{
using (SmartClientDatabase database = GetDatabase())
{
IRequestQueue queue = new DatabaseRequestQueue(database, "Requests");
Assert.AreEqual(0, queue.GetCount());
Request request1 = CreateRequest();
Request request2 = CreateRequest();
Request request3 = CreateRequest();
Request request4 = CreateRequest();
queue.Enqueue(request1);
queue.Enqueue(request2);
queue.Enqueue(request3);
queue.Enqueue(request4);
Assert.AreEqual(4, queue.GetCount());
List <Request> list = new List <Request>();
foreach (Request req in queue.GetRequests())
{
list.Add(req);
queue.Remove(req);
}
Assert.AreEqual(4, list.Count);
Assert.IsTrue(AreEqual(request1, list[0]));
Assert.IsTrue(AreEqual(request2, list[1]));
Assert.IsTrue(AreEqual(request3, list[2]));
Assert.IsTrue(AreEqual(request4, list[3]));
Assert.AreEqual(0, queue.GetCount());
}
}
