public void CommandParametersTest()
{
using (var pool = DbManagerTestSettings.CreateConnectionPool())
{
var manager = new DbManager(pool);
for (var i = 0; i < 10; i++)
{
Assert.AreEqual(0, manager.ConnectionPool.LiveObjects, string.Format("Iteration {0}", i));
IDbCommand cmd;
using (cmd = manager.GetCommand())
{
Assert.AreEqual(1, manager.ConnectionPool.LiveObjects, string.Format("Iteration {0}", i));
Assert.IsNotNull(cmd);
cmd.CommandText = "SELECT @left + @right";
var left = new MySqlParameter("@left", null) { Value = 500 };
var right = new MySqlParameter("@right", null) { Value = 100 };
cmd.Parameters.Add(left);
cmd.Parameters.Add(right);
using (var r = cmd.ExecuteReader())
{
r.Read();
Assert.AreEqual("600", r[0].ToString());
}
Assert.AreNotEqual(0, cmd.Parameters.Count);
Assert.IsFalse(string.IsNullOrEmpty(cmd.CommandText));
}
}
}
}
public void CleanupConnectionsTest()
{
using (var pool = DbManagerTestSettings.CreateConnectionPool())
{
var manager = new DbManager(pool);
var stack = new Stack<IPoolableDbConnection>();
Assert.AreEqual(0, manager.ConnectionPool.LiveObjects);
for (var i = 1; i < 20; i++)
{
var item = manager.GetConnection();
stack.Push(item);
Assert.AreEqual(i, manager.ConnectionPool.LiveObjects, string.Format("Iteration {0}", i));
}
while (stack.Count > 0)
{
var item = stack.Pop();
var start = manager.ConnectionPool.LiveObjects;
item.Dispose();
Assert.AreEqual(start - 1, manager.ConnectionPool.LiveObjects);
}
Assert.AreEqual(0, manager.ConnectionPool.LiveObjects);
}
}
public void ExecuteReaderTest()
{
using (var pool = DbManagerTestSettings.CreateConnectionPool())
{
var manager = new DbManager(pool);
for (var i = 0; i < 10; i++)
{
using (var r = manager.ExecuteReader("SELECT 500 + 100"))
{
Assert.IsFalse(r.IsClosed);
r.Read();
Assert.AreEqual("600", r[0].ToString());
}
}
}
}
public void ExecuteNonQueryTest()
{
using (var pool = DbManagerTestSettings.CreateConnectionPool())
{
var manager = new DbManager(pool);
for (var i = 0; i < 10; i++)
{
var ret = manager.ExecuteNonQuery("SELECT 500 + 100");
Assert.AreEqual(-1, ret);
}
}
}
public void ConnectionTest()
{
using (var pool = DbManagerTestSettings.CreateConnectionPool())
{
var manager = new DbManager(pool);
for (var i = 0; i < 10; i++)
{
Assert.AreEqual(0, manager.ConnectionPool.LiveObjects, string.Format("Iteration {0}", i));
IPoolableDbConnection pConn;
IDbConnection conn;
using (pConn = manager.GetConnection())
{
Assert.AreEqual(1, manager.ConnectionPool.LiveObjects, string.Format("Iteration {0}", i));
conn = pConn.Connection;
Assert.IsNotNull(conn);
Assert.AreEqual(ConnectionState.Open, conn.State);
}
Assert.AreEqual(ConnectionState.Closed, conn.State);
}
}
}
public void CommandTest()
{
using (var pool = DbManagerTestSettings.CreateConnectionPool())
{
var manager = new DbManager(pool);
for (var i = 0; i < 10; i++)
{
Assert.AreEqual(0, manager.ConnectionPool.LiveObjects, string.Format("Iteration {0}", i));
IDbCommand cmd;
using (cmd = manager.GetCommand())
{
Assert.AreEqual(1, manager.ConnectionPool.LiveObjects, string.Format("Iteration {0}", i));
Assert.IsNotNull(cmd);
cmd.CommandText = "SELECT 500 + 100";
using (var r = cmd.ExecuteReader())
{
r.Read();
Assert.AreEqual("600", r[0].ToString());
}
}
}
}
}
