public void AddContextParametersTest()
{
DatabaseTraceListener_Accessor target = new DatabaseTraceListener_Accessor(
storedProcedureName, logConnectionStringName, null, null);
TraceEventCache eventCache = null;
TraceEventType eventType = TraceEventType.Information;
int id = 101;
IDbCommand command = new SqlCommand();
target.AddContextParameters(eventCache, eventType, id, command);
IDataParameter midParam = command.Parameters["MessageId"] as IDataParameter;
Assert.IsNotNull(midParam);
Assert.IsNotNull(midParam.Value);
Assert.AreEqual<string>(midParam.Value.ToString(), "101");
}
public void AddTransformerParametersTest()
{
IExtraDataTransformer extraFieldsProvider = new SampleLogDataProvider();
DatabaseTraceListener_Accessor target = new DatabaseTraceListener_Accessor(
storedProcedureName, logConnectionStringName, null, extraFieldsProvider);
object data = new CustomLogEntry { JobId = 12345, RepId = 54321 };
IDbCommand command = new SqlCommand();
//MockRepository mocks = new MockRepository();
//IDbCommand command = mocks.StrictMock<IDbCommand>();
//IDataParameterCollection parameters = mocks.StrictMock<IDataParameterCollection>();
//Expect.Call(command.Parameters).Return(parameters);
//Expect.Call(command.Parameters.Add(target.factory.CreateParameter(
// (p) => { p.DbType = DbType.String; p.Value = 12345; p.ParameterName = "JobId"; })));
//Expect.Call(command.Parameters).Return(parameters);
//Expect.Call(command.Parameters.Add(target.factory.CreateParameter(
// (p) => { p.DbType = DbType.String; p.Value = 54321; p.ParameterName = "RepId"; })));
//mocks.ReplayAll();
target.AddTransformerParameters(data, command);
//mocks.VerifyAll();
IDataParameter jobParam = command.Parameters["JobId"] as IDataParameter;
Assert.IsNotNull(jobParam);
Assert.IsNotNull(jobParam.Value);
Assert.AreEqual<string>(jobParam.Value.ToString(), "12345");
IDataParameter repParam = command.Parameters["RepId"] as IDataParameter;
Assert.IsNotNull(repParam);
Assert.IsNotNull(repParam.Value);
Assert.AreEqual<string>(repParam.Value.ToString(), "54321");
}
private void Setup()
{
parametersList = new List<DbParameter>();
target = new DatabaseTraceListener_Accessor(
storedProcedureName, logConnectionStringName, null, null);
//target.connectionStringName = "TestConnectionString";
target.factory = MockRepository.GenerateStub<DbProviderFactory>();
target.connectionStringProvider = MockRepository.GenerateStub<IConfigurationValueProvider>();
target.connectionStringProvider.Stub((p) => p[target.connectionStringName]).
Return(target.connectionStringName);
connection = MockRepository.GenerateStub<DbConnection>();
command = MockRepository.GenerateStub<DbCommand>();
parameters = MockRepository.GenerateStub<DbParameterCollection>();
// Stubs for the connection and command
target.factory.Stub(
(f) => f.CreateConnection()).Return(connection);
target.factory.Stub((f) => f.CreateCommand()).Return(command);
// Definitely want to verify that Open is called
connection.Stub((c) => connection.Open());
// Unfortunately can't verify Dispose got called
connection.Stub((c) => connection.Dispose());
// Will verify later if ExecuteNonQuery is called
command.Stub((c) => command.ExecuteNonQuery()).Return(1);
command.Stub((c) => c.Dispose());
// Setup repetitive stub for the command parameters
//DbParameter parameter = null;
command.Stub((c) => c.Parameters).Repeat.Any().Return(parameters);
for (int i = 0; i < 12; i++)
{
DbParameter parameter = MockRepository.GenerateStub<DbParameter>();
target.factory.Stub((f) => f.CreateParameter()).Return(parameter);
parameters.Stub((p) => p.Add(parameter)).Do(new HandleParameterDelegate(HandleParameter));
}
}
public void AddTransformerParametersTest()
{
IExtraDataTransformer extraFieldsProvider = new SampleLogDataProvider();
DatabaseTraceListener_Accessor target = new DatabaseTraceListener_Accessor(
storedProcedureName, logConnectionStringName, null, extraFieldsProvider);
//object data = new CustomLogEntry { JobId = 12345, RepId = 54321 };
//IDbCommand command = new SqlCommand();
//target.AddTransformerParameters(data, command);
//IDataParameter jobParam = command.Parameters["JobId"] as IDataParameter;
//Assert.IsNotNull(jobParam);
//Assert.IsNotNull(jobParam.Value);
//Assert.AreEqual<string>(jobParam.Value.ToString(), "12345");
//IDataParameter repParam = command.Parameters["RepId"] as IDataParameter;
//Assert.IsNotNull(repParam);
//Assert.IsNotNull(repParam.Value);
//Assert.AreEqual<string>(repParam.Value.ToString(), "54321");
}
public void InitializeTest()
{
DatabaseTraceListener_Accessor target = new DatabaseTraceListener_Accessor();
target.Initialize();
// No stubbing for the connection string provider so
Assert.IsTrue(target.initializedInFailedMode);
}
