protected DbConnection OpenNewConnection(string param, bool noServerString,
Dictionary <string, string> props)
{
DbConnection conn = CreateConnection(m_defaultDriverType, param,
noServerString);
GFXDConnection gfxdConn = conn as GFXDConnection;
if (gfxdConn != null)
{
gfxdConn.Open(props);
}
else
{
conn.Open();
}
return(conn);
}
public override void Run(Object context)
{
String tableName = null;
int numRows = 10;
try
{
tableName = DbRandom.BuildRandomTable(numRows);
GFXDConnection conn = Connection.Clone();
conn.Open();
GFXDCommand cmd = conn.CreateCommand();
cmd.CommandText = "SELECT * FROM " + tableName;
DataTable dt = new DataTable();
GFXDDataAdapter adpt = cmd.CreateDataAdapter();
adpt.Fill(dt);
if (dt.Rows.Count != numRows)
{
Fail("Failed to create table new table on cloned connection");
}
DbHelper.ExecuteNonQueryStatement((GFXDClientConnection)conn, "DELETE FROM " + tableName);
dt.Clear();
adpt.Fill(dt);
if (dt.Rows.Count != 0)
{
Fail("Failed to delete all table record on a cloned connection");
}
}
catch (Exception e)
{
}
finally
{
DbHelper.DropTable(tableName);
base.Run(context);
}
}
protected void VerifyInserts(GFXDConnection conn, string cmdText,
int start, int end, string addrPrefix)
{
// check the inserts
GFXDCommand cmd = new GFXDCommand(cmdText, conn);
Dictionary<int, string> result =
new Dictionary<int, string>(end - start + 1);
int id;
string addr;
GFXDDataReader reader = cmd.ExecuteReader();
for (int i = start; i <= end; i++) {
Assert.IsTrue(reader.Read(), "failed in read for i=" + i);
id = reader.GetInt32(0);
addr = reader.GetString(1);
Assert.IsFalse(result.ContainsKey(id),
"unexpected duplicate for id=" + id);
Assert.AreEqual(addrPrefix + id, addr);
result.Add(id, addr);
}
Assert.IsFalse(reader.Read());
}
public void AutoCommitTest()
{
m_conn = OpenNewConnection();
GFXDConnection conn = m_conn as GFXDConnection;
if (conn != null)
{
Assert.False(conn.AutoCommit, "#1");
conn.AutoCommit = true;
Assert.True(conn.AutoCommit, "#2");
conn.Close();
try {
conn.AutoCommit = false;
} catch (DbException ex) {
// cannot change property 'AutoCommit' is connection is closed
Assert.IsNull(ex.InnerException, "#3");
Assert.IsNotNull(ex.Message, "#4");
Assert.IsTrue(ex.Message.Contains("08003"), "#5");
}
}
}
protected void VerifyInserts(GFXDConnection conn, string cmdText,
int start, int end, string addrPrefix)
{
// check the inserts
GFXDCommand cmd = new GFXDCommand(cmdText, conn);
Dictionary <int, string> result =
new Dictionary <int, string>(end - start + 1);
int id;
string addr;
GFXDDataReader reader = cmd.ExecuteReader();
for (int i = start; i <= end; i++)
{
Assert.IsTrue(reader.Read(), "failed in read for i=" + i);
id = reader.GetInt32(0);
addr = reader.GetString(1);
Assert.IsFalse(result.ContainsKey(id),
"unexpected duplicate for id=" + id);
Assert.AreEqual(addrPrefix + id, addr);
result.Add(id, addr);
}
Assert.IsFalse(reader.Read());
}
protected void VerifyInserts(GFXDConnection conn, int numInserts)
{
VerifyInserts(conn, "select * from t1", 0, numInserts - 1, "addr");
}
protected void VerifyInserts(GFXDConnection conn, int numInserts)
{
VerifyInserts(conn, "select * from t1", 0, numInserts - 1, "addr");
}
