public void AddParameters_OneValue()
{
var specification = new ComparedColumnsSpecification(new[] { new ColumnValue(_column1, _value1) });
_sqlDialectStub.Stub(stub => stub.GetParameterName("First")).Return("pFirst");
var parameterStrictMock = MockRepository.GenerateStrictMock <IDbDataParameter> ();
parameterStrictMock.Expect(mock => mock.ParameterName = "pFirst");
parameterStrictMock.Replay();
_parametersCollectionMock.Expect(mock => mock.Add(parameterStrictMock)).Return(0);
_parametersCollectionMock.Replay();
_storageTypeInformationMock1
.Expect(mock => mock.CreateDataParameter(_commandStub, _value1))
.Return(parameterStrictMock);
_storageTypeInformationMock1.Replay();
specification.AddParameters(_commandStub, _sqlDialectStub);
_parametersCollectionMock.VerifyAllExpectations();
parameterStrictMock.VerifyAllExpectations();
_storageTypeInformationMock1.VerifyAllExpectations();
}
public void GetConvertedValue_ValidType()
{
_storageTypeInformationProviderStub.Stub(stub => stub.GetStorageType(typeof(string))).Return(_storageTypeInformationMock);
var fakeResult = "fake";
_storageTypeInformationMock.Expect(mock => mock.Read(_dataReaderStub, 1)).Return(fakeResult);
var result = _queryResultRow.GetConvertedValue(1, typeof(string));
Assert.That(result, Is.EqualTo(fakeResult));
_storageTypeInformationMock.VerifyAllExpectations();
}
public void Create()
{
var dataParameterCollectionStrictMock = MockRepository.GenerateStrictMock <IDataParameterCollection>();
var dbCommandStub = MockRepository.GenerateStub <IDbCommand> ();
dbCommandStub.Stub(stub => stub.Parameters).Return(dataParameterCollectionStrictMock);
var executionContextStub = MockRepository.GenerateStub <IRdbmsProviderCommandExecutionContext>();
executionContextStub.Stub(stub => stub.CreateDbCommand()).Return(dbCommandStub);
var dbDataParameterStub = MockRepository.GenerateStub <IDbDataParameter>();
_valueParameterStorageTypeInformationMock
.Expect(mock => mock.CreateDataParameter(dbCommandStub, 5))
.Return(dbDataParameterStub);
_valueParameterStorageTypeInformationMock.Replay();
_textParameterStorageTypeInformationMock.Replay();
dataParameterCollectionStrictMock.Expect(mock => mock.Add(dbDataParameterStub)).Return(0);
dataParameterCollectionStrictMock.Replay();
var result = _commandBuilder.Create(executionContextStub);
dataParameterCollectionStrictMock.VerifyAllExpectations();
_valueParameterStorageTypeInformationMock.VerifyAllExpectations();
_textParameterStorageTypeInformationMock.VerifyAllExpectations();
Assert.That(result, Is.SameAs(dbCommandStub));
Assert.That(result.CommandText, Is.EqualTo("Statement @param1 test"));
}
public void GetValueForColumn()
{
_columnOrdinalProviderStub.Stub(stub => stub.GetOrdinal(_columnDefinition, _dataReaderStub)).Return(17);
_storageTypeInformationStrictMock
.Expect(mock => mock.Read(_dataReaderStub, 17))
.Return("value");
_storageTypeInformationStrictMock.Replay();
var result = _columnValueReader.GetValueForColumn(_columnDefinition);
_storageTypeInformationStrictMock.VerifyAllExpectations();
Assert.That(result, Is.EqualTo("value"));
}
