public void run()
{
DoTestTypes(ConnectedDataProvider.GetSimpleDbTypesParameters());
DoTestTypes(ConnectedDataProvider.GetExtendedDbTypesParameters());
DoTestTextualFieldsThatContainNumbers(ConnectedDataProvider.GetSimpleDbTypesParameters());
DoTestTextualFieldsThatContainNumbers(ConnectedDataProvider.GetExtendedDbTypesParameters());
}
public void TestHasRowsFalse()
{
BeginCase("Test HasRows = False");
exp = null;
string rowId = string.Format("43977_{0}", TestCaseNumber);
OracleConnection con = null;
OracleDataReader rdr = null;
try
{
DbTypeParametersCollection row = ConnectedDataProvider.GetSimpleDbTypesParameters();
row.ExecuteDelete(rowId); //Make sure that a row with such ID does not exist.
row.ExecuteSelectReader(rowId, out rdr, out con);
Compare(rdr.HasRows, false);
}
catch (Exception ex)
{
exp = ex;
}
finally
{
EndCase(exp);
exp = null;
}
}
public void TestHasRowsTrue()
{
BeginCase("Test HasRows = True");
exp = null;
string rowId = string.Format("43977_{0}", TestCaseNumber);
OracleConnection con = null;
OracleDataReader rdr = null;
try
{
DbTypeParametersCollection row = ConnectedDataProvider.GetSimpleDbTypesParameters();
row.ExecuteInsert(rowId);
row.ExecuteSelectReader(rowId, out rdr, out con);
Compare(rdr.HasRows, true);
}
catch (Exception ex)
{
exp = ex;
}
finally
{
EndCase(exp);
exp = null;
}
}
public void run()
{
#region Simple Tests
//string str="";
string sql;
OracleConnection con = null;
sql = "UPDATE Employees SET Region = :Region, TitleOfCourtesy = :TitleOfCourtesy WHERE EmployeeID=1";
con = new OracleConnection(MonoTests.System.Data.Utils.ConnectedDataProvider.ConnectionString);
//not testing with DB2 provider
if (ConnectedDataProvider.GetDbType(con) != DataBaseServer.DB2)
{
OracleCommand cmd = new OracleCommand(sql, con);
cmd.Parameters.Add(new OracleParameter(":Region", OracleType.VarChar));
cmd.Parameters.Add(new OracleParameter(":TitleOfCourtesy", OracleType.VarChar));
con.Open();
cmd.Parameters[":Region"].Value = "WA";
cmd.Parameters[":TitleOfCourtesy"].Value = "Mr";
//return the number of rows affected
int i = cmd.ExecuteNonQuery();
try
{
BeginCase("Check row count");
Compare(i, 1);
}
catch (Exception ex)
{
exp = ex;
}
finally
{
EndCase(exp);
exp = null;
}
}
if (con.State == ConnectionState.Open)
{
con.Close();
}
#endregion
#region Test Parameter Types
#region General
TypesSubTests(ConnectedDataProvider.GetSimpleDbTypesParameters());
TypesSubTests(ConnectedDataProvider.GetExtendedDbTypesParameters());
#endregion
#endregion
}
private void ValueInColumn(string columnToTest, string valueToTest)
{
exp = null;
OracleDataReader rdr = null;
OracleConnection con = null;
DbTypeParametersCollection row = ConnectedDataProvider.GetSimpleDbTypesParameters();
BeginCase(string.Format("Use {0} as value", valueToTest));
string rowId = TEST_CASE_ID + TestCaseNumber.ToString();
try
{
foreach (DbTypeParameter param in row)
{
param.Value = DBNull.Value;
}
row[columnToTest].Value = valueToTest;
Log("rowId:" + rowId + " columnToTest:" + columnToTest + " valueToTest:" + valueToTest);
row.ExecuteInsert(rowId);
row.ExecuteSelectReader(rowId, out rdr, out con);
rdr.Read();
int columnOrdinal = rdr.GetOrdinal(columnToTest);
//this.Log(valueToTest);
Compare(valueToTest, rdr.GetValue(columnOrdinal));
}
catch (Exception ex)
{
exp = ex;
}
finally
{
EndCase(exp);
if (rdr != null && !rdr.IsClosed)
{
rdr.Close();
}
row.ExecuteDelete(rowId);
if (con != null && con.State != ConnectionState.Closed)
{
con.Close();
}
}
}
public void run()
{
DoTestTypes(ConnectedDataProvider.GetSimpleDbTypesParameters());
DoTestTypes(ConnectedDataProvider.GetExtendedDbTypesParameters());
}