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 AppendComparisons_OneValue()
{
var specification = new ComparedColumnsSpecification(new[] { new ColumnValue(_column1, _value1) });
_statement.Append("<existingtext>");
_sqlDialectStub.Stub(stub => stub.GetParameterName("First")).Return("pFirst");
_sqlDialectStub.Stub(mock => mock.DelimitIdentifier("First")).Return("[First]");
specification.AppendComparisons(_statement, _commandStub, _sqlDialectStub);
_parametersCollectionMock.VerifyAllExpectations();
_storageTypeInformationMock1.VerifyAllExpectations();
Assert.That(_statement.ToString(), Is.EqualTo("<existingtext>[First] = pFirst"));
}
public void AppendComparisons_MultipleValues_EmptyParameterDictionary()
{
var columnValue1 = new ColumnValue(_column1, _value1);
var columnValue2 = new ColumnValue(_column2, _value2);
var specification = new ComparedColumnsSpecification(new[] { columnValue1, columnValue2 });
_statement.Append("<existingtext>");
_sqlDialectStub.Stub(stub => stub.GetParameterName("First")).Return("pFirst");
_sqlDialectStub.Stub(stub => stub.GetParameterName("Second")).Return("pSecond");
_sqlDialectStub.Stub(mock => mock.DelimitIdentifier("First")).Return("[First]");
_sqlDialectStub.Stub(mock => mock.DelimitIdentifier("Second")).Return("[Second]");
specification.AppendComparisons(_statement, _commandStub, _sqlDialectStub);
Assert.That(_statement.ToString(), Is.EqualTo("<existingtext>[First] = pFirst AND [Second] = pSecond"));
}
public void Initialization_NonEmpty()
{
var specification = new ComparedColumnsSpecification(new[] { new ColumnValue(_column1, _value1) });
Assert.That(specification.ComparedColumnValues, Is.EqualTo(new[] { new ColumnValue(_column1, _value1) }));
}