public void TestThatDisposeCanBeCalledMoreThanOnce()
{
using (var oracleClient = new OracleClient())
{
Assert.That(oracleClient, Is.Not.Null);
oracleClient.Dispose();
oracleClient.Dispose();
}
}
public void TestThatValidateTableThrowsDeliveryEngineMetadataExceptionIfColumnDoesNotExist()
{
var fixture = new Fixture();
var fieldCollectionMock = new List <IField>(1)
{
MockRepository.GenerateMock <IField>()
};
fieldCollectionMock.ElementAt(0).Expect(m => m.NameSource)
.Return(fixture.CreateAnonymous <string>())
.Repeat.Any();
var tableMock = MockRepository.GenerateMock <ITable>();
tableMock.Expect(m => m.NameSource)
.Return("TABEL")
.Repeat.Any();
tableMock.Expect(m => m.Fields)
.Return(new ReadOnlyObservableCollection <IField>(new ObservableCollection <IField>(fieldCollectionMock)))
.Repeat.Any();
using (var oracleClient = new OracleClient())
{
Assert.Throws <DeliveryEngineMetadataException>(() => oracleClient.ValidateTable(tableMock));
oracleClient.Dispose();
}
tableMock.AssertWasCalled(m => m.Fields);
fieldCollectionMock.ElementAt(0).AssertWasCalled(m => m.NameSource);
}
public void TestThatValidateTableThrowsDeliveryEngineMetadataExceptionIfDatatypeFromDatabaseCanNotBeMapped()
{
var fieldCollectionMock = new List <IField>(1)
{
MockRepository.GenerateMock <IField>()
};
fieldCollectionMock.ElementAt(0).Expect(m => m.NameSource)
.Return("SYSTEM_NR")
.Repeat.Any();
fieldCollectionMock.ElementAt(0).Expect(m => m.DatatypeOfSource)
.Return(typeof(string))
.Repeat.Any();
var tableMock = MockRepository.GenerateMock <ITable>();
tableMock.Expect(m => m.NameSource)
.Return("TABEL")
.Repeat.Any();
tableMock.Expect(m => m.Fields)
.Return(new ReadOnlyObservableCollection <IField>(new ObservableCollection <IField>(fieldCollectionMock)))
.Repeat.Any();
using (var oracleClient = new OracleClient())
{
Assert.Throws <DeliveryEngineMetadataException>(() => oracleClient.ValidateTable(tableMock));
oracleClient.Dispose();
}
tableMock.AssertWasCalled(m => m.Fields);
fieldCollectionMock.ElementAt(0).AssertWasCalled(m => m.DatatypeOfSource);
}
public void TestThatValidateTableThrowsArgumentNullExceptionIfTableIsNull()
{
using (var oracleClient = new OracleClient())
{
Assert.Throws <ArgumentNullException>(() => oracleClient.ValidateTable(null));
oracleClient.Dispose();
}
}
public void TestThatConstructorInitializeOracleClient()
{
using (var oracleClient = new OracleClient())
{
Assert.That(oracleClient, Is.Not.Null);
oracleClient.Dispose();
}
}
public void TestThatGetNumberOfEqualKeyValuesThrowsArgumentNullExceptionIfExtraCriteriasIsNull()
{
var fixture = new Fixture();
fixture.Customize <IKey>(e => e.FromFactory(() => MockRepository.GenerateMock <IKey>()));
using (var oracleClient = new OracleClient())
{
Assert.Throws <ArgumentNullException>(() => oracleClient.GetNumberOfEqualKeyValues(fixture.CreateAnonymous <IKey>(), null, fixture.CreateAnonymous <string>()));
oracleClient.Dispose();
}
}
public void TestThatGetNumberOfEqualKeyValuesThrowsArgumentNullExceptionIfKeyIsNull()
{
var fixture = new Fixture();
fixture.Customize <KeyValuePair <string, object> >(e => e.FromFactory(() => new KeyValuePair <string, object>(fixture.CreateAnonymous <string>(), fixture.CreateAnonymous <object>())));
using (var oracleClient = new OracleClient())
{
Assert.Throws <ArgumentNullException>(() => oracleClient.GetNumberOfEqualKeyValues(null, fixture.CreateMany <KeyValuePair <string, object> >(5).ToList(), fixture.CreateAnonymous <string>()));
oracleClient.Dispose();
}
}
public void TestThatGetNumberOfEqualKeyValuesThrowsArgumentNullExceptionIfMatchingKeyValueIsEmpty()
{
var fixture = new Fixture();
fixture.Customize <IKey>(e => e.FromFactory(() => MockRepository.GenerateMock <IKey>()));
fixture.Customize <KeyValuePair <string, object> >(e => e.FromFactory(() => new KeyValuePair <string, object>(fixture.CreateAnonymous <string>(), fixture.CreateAnonymous <object>())));
using (var oracleClient = new OracleClient())
{
Assert.Throws <ArgumentNullException>(() => oracleClient.GetNumberOfEqualKeyValues(fixture.CreateAnonymous <IKey>(), fixture.CreateMany <KeyValuePair <string, object> >(5).ToList(), string.Empty));
oracleClient.Dispose();
}
}
public void TestThatValidateTableThrowsDeliveryEngineMetadataExceptionIfTableDoesNotExist()
{
var fixture = new Fixture();
var tableMock = MockRepository.GenerateMock <ITable>();
tableMock.Expect(m => m.NameSource)
.Return(fixture.CreateAnonymous <string>())
.Repeat.Any();
using (var oracleClient = new OracleClient())
{
Assert.Throws <DeliveryEngineMetadataException>(() => oracleClient.ValidateTable(tableMock));
oracleClient.Dispose();
}
tableMock.AssertWasCalled(m => m.NameSource);
}
public void TestThatGetDataThrowsArgumentNullExceptionIfOnHandleOracleDataIsNull()
{
var fixture = new Fixture();
fixture.Customize <ITable>(e => e.FromFactory(() => MockRepository.GenerateMock <ITable>()));
var tableMock = fixture.CreateAnonymous <ITable>();
using (var oracleClient = new OracleClient())
{
Assert.Throws <ArgumentNullException>(() => oracleClient.GetData(tableMock, null));
oracleClient.Dispose();
}
tableMock.AssertWasNotCalled(m => m.Fields);
tableMock.AssertWasNotCalled(m => m.RecordFilters);
tableMock.AssertWasNotCalled(m => m.PrimaryKey);
tableMock.AssertWasNotCalled(m => m.NameSource);
}
public void TestThatGetDataThrowsArgumentNullExceptionIfTableIsNull()
{
var fixture = new Fixture();
fixture.Customize <IHandleDataEventArgs>(e => e.FromFactory(() => MockRepository.GenerateMock <IHandleDataEventArgs>()));
DeliveryEngineEventHandler <IHandleDataEventArgs> onHandleOracleData = (s, e) =>
{
Assert.That(s, Is.Not.Null);
Assert.That(e, Is.Not.Null);
};
onHandleOracleData.Invoke(fixture.CreateAnonymous <object>(), fixture.CreateAnonymous <IHandleDataEventArgs>());
using (var oracleClient = new OracleClient())
{
Assert.Throws <ArgumentNullException>(() => oracleClient.GetData(null, onHandleOracleData));
oracleClient.Dispose();
}
}
public void TestThatGetNumberOfEqualKeyValuesThrowsDeliveryEngineMetadataExceptionIfTableIsNullOnKey()
{
var fixture = new Fixture();
fixture.Customize <KeyValuePair <string, object> >(e => e.FromFactory(() => new KeyValuePair <string, object>(fixture.CreateAnonymous <string>(), fixture.CreateAnonymous <object>())));
var keyMock = MockRepository.GenerateMock <IKey>();
keyMock.Expect(m => m.Table)
.Return(null)
.Repeat.Any();
using (var oracleClient = new OracleClient())
{
Assert.Throws <DeliveryEngineMetadataException>(() => oracleClient.GetNumberOfEqualKeyValues(keyMock, fixture.CreateMany <KeyValuePair <string, object> >(5).ToList(), fixture.CreateAnonymous <string>()));
oracleClient.Dispose();
}
keyMock.AssertWasCalled(m => m.Table);
}
public void TestThatSelectCountForTableGetNumberOfRecordsWithoutRecordFilters()
{
var tableMock = MockRepository.GenerateMock <ITable>();
tableMock.Expect(m => m.NameSource)
.Return("TABEL")
.Repeat.Any();
tableMock.Expect(m => m.RecordFilters)
.Return(new ReadOnlyObservableCollection <IFilter>(new ObservableCollection <IFilter>(new List <IFilter>(0))))
.Repeat.Any();
using (var oracleClient = new OracleClient())
{
var numberOfRecords = oracleClient.SelectCountForTable(tableMock);
Assert.That(numberOfRecords, Is.GreaterThan(0));
oracleClient.Dispose();
}
tableMock.AssertWasCalled(m => m.NameSource);
tableMock.AssertWasCalled(m => m.RecordFilters);
}
public void TestThatSelectCountForTableGetNumberOfRecordsWithRecordFilters()
{
var firstFilter = MockRepository.GenerateMock <IFilter>();
firstFilter.Expect(m => m.AsSql())
.Return("SYSTEM_NR=0 AND TABEL=0 AND NR='00'")
.Repeat.Any();
var secordFilter = MockRepository.GenerateMock <IFilter>();
secordFilter.Expect(m => m.AsSql())
.Return("SYSTEM_NR=0 AND TABEL=0 AND NR='01'")
.Repeat.Any();
var tableMock = MockRepository.GenerateMock <ITable>();
tableMock.Expect(m => m.NameSource)
.Return("TABEL")
.Repeat.Any();
tableMock.Expect(m => m.RecordFilters)
.Return(new ReadOnlyObservableCollection <IFilter>(new ObservableCollection <IFilter>(new List <IFilter> {
firstFilter, secordFilter
})))
.Repeat.Any();
using (var oracleClient = new OracleClient())
{
var numberOfRecords = oracleClient.SelectCountForTable(tableMock);
Assert.That(numberOfRecords, Is.EqualTo(2));
oracleClient.Dispose();
}
tableMock.AssertWasCalled(m => m.NameSource);
tableMock.AssertWasCalled(m => m.RecordFilters);
firstFilter.AssertWasCalled(m => m.AsSql());
secordFilter.AssertWasCalled(m => m.AsSql());
}
public void TestThatGetNumberOfEqualKeyValuesGetsNumberOfEqualKeyValuesForKeyWhereThereMultipleRecords()
{
var fieldCollection = new List <IField>
{
MockRepository.GenerateMock <IField>(),
MockRepository.GenerateMock <IField>(),
MockRepository.GenerateMock <IField>(),
MockRepository.GenerateMock <IField>()
};
fieldCollection.ElementAt(0).Expect(m => m.NameSource)
.Return("SYSTEM_NR")
.Repeat.Any();
fieldCollection.ElementAt(0).Expect(m => m.DatatypeOfSource)
.Return(typeof(int?))
.Repeat.Any();
fieldCollection.ElementAt(0).Expect(m => m.DatatypeOfTarget)
.Return(typeof(int?))
.Repeat.Any();
fieldCollection.ElementAt(1).Expect(m => m.NameSource)
.Return("TABEL")
.Repeat.Any();
fieldCollection.ElementAt(1).Expect(m => m.DatatypeOfSource)
.Return(typeof(int?))
.Repeat.Any();
fieldCollection.ElementAt(1).Expect(m => m.DatatypeOfTarget)
.Return(typeof(int?))
.Repeat.Any();
fieldCollection.ElementAt(2).Expect(m => m.NameSource)
.Return("NR")
.Repeat.Any();
fieldCollection.ElementAt(2).Expect(m => m.DatatypeOfSource)
.Return(typeof(string))
.Repeat.Any();
fieldCollection.ElementAt(2).Expect(m => m.DatatypeOfTarget)
.Return(typeof(string))
.Repeat.Any();
fieldCollection.ElementAt(3).Expect(m => m.NameSource)
.Return("TEKST")
.Repeat.Any();
fieldCollection.ElementAt(3).Expect(m => m.DatatypeOfSource)
.Return(typeof(string))
.Repeat.Any();
fieldCollection.ElementAt(3).Expect(m => m.DatatypeOfTarget)
.Return(typeof(string))
.Repeat.Any();
var filterCollection = new List <IFilter>();
var tableMock = MockRepository.GenerateMock <ITable>();
var keyMock = MockRepository.GenerateMock <ICandidateKey>();
keyMock.Expect(m => m.Table)
.Return(tableMock)
.Repeat.Any();
keyMock.Expect(m => m.Fields)
.Return(new ReadOnlyObservableCollection <KeyValuePair <IField, IMap> >(new ObservableCollection <KeyValuePair <IField, IMap> >(new List <KeyValuePair <IField, IMap> >(fieldCollection.GetRange(0, 3).Select(field => new KeyValuePair <IField, IMap>(field, null))))))
.Repeat.Any();
tableMock.Expect(m => m.NameSource)
.Return("TABEL")
.Repeat.Any();
tableMock.Expect(m => m.Fields)
.Return(new ReadOnlyObservableCollection <IField>(new ObservableCollection <IField>(fieldCollection)))
.Repeat.Any();
tableMock.Expect(m => m.PrimaryKey)
.Return(keyMock)
.Repeat.Any();
tableMock.Expect(m => m.RecordFilters)
.WhenCalled(e => e.ReturnValue = new ReadOnlyObservableCollection <IFilter>(new ObservableCollection <IFilter>(filterCollection)))
.Return(new ReadOnlyObservableCollection <IFilter>(new ObservableCollection <IFilter>(filterCollection)))
.Repeat.Any();
tableMock.Expect(m => m.AddRecordFilter(Arg <IFilter> .Is.NotNull))
.WhenCalled(e => filterCollection.Add((IFilter)e.Arguments.ElementAt(0)))
.Repeat.Any();
tableMock.Expect(m => m.Clone())
.Return(tableMock)
.Repeat.Any();
var mocker = new MockRepository();
var dataManipulatorsMock = mocker.DynamicMultiMock <IDataManipulators>(new[] { typeof(IEnumerable <IDataManipulator>) });
Expect.Call(dataManipulatorsMock.GetEnumerator())
.Return(new List <IDataManipulator>(0).GetEnumerator())
.Repeat.Any();
mocker.ReplayAll();
using (var oracleClient = new OracleClient(dataManipulatorsMock))
{
var extraCriterias = new List <KeyValuePair <string, object> >
{
new KeyValuePair <string, object>("SYSTEM_NR", 0),
new KeyValuePair <string, object>("TABEL", 0)
};
var numberOfEqualKeys = oracleClient.GetNumberOfEqualKeyValues(keyMock, extraCriterias, "0|0|00");
Assert.That(numberOfEqualKeys, Is.EqualTo(1));
oracleClient.Dispose();
}
keyMock.AssertWasCalled(m => m.Table);
tableMock.AssertWasCalled(m => m.Clone());
tableMock.AssertWasCalled(m => m.RecordFilters, opt => opt.Repeat.Times(6));
tableMock.AssertWasCalled(m => m.AddRecordFilter(Arg <IFilter> .Is.NotNull));
dataManipulatorsMock.AssertWasCalled(m => m.GetEnumerator());
}
public void TestThatGetNumberOfEqualKeyValuesGetsNumberOfEqualKeyValuesForKeyWhereThereOnlyAreOnRecord()
{
var fixture = new Fixture();
var fieldCollection = new List <IField>
{
MockRepository.GenerateMock <IField>(),
MockRepository.GenerateMock <IField>(),
MockRepository.GenerateMock <IField>(),
MockRepository.GenerateMock <IField>()
};
fieldCollection.ElementAt(0).Expect(m => m.NameSource)
.Return("SYSTEM_NR")
.Repeat.Any();
fieldCollection.ElementAt(0).Expect(m => m.DatatypeOfSource)
.Return(typeof(int?))
.Repeat.Any();
fieldCollection.ElementAt(1).Expect(m => m.NameSource)
.Return("TABEL")
.Repeat.Any();
fieldCollection.ElementAt(1).Expect(m => m.DatatypeOfSource)
.Return(typeof(int?))
.Repeat.Any();
fieldCollection.ElementAt(2).Expect(m => m.NameSource)
.Return("NR")
.Repeat.Any();
fieldCollection.ElementAt(2).Expect(m => m.DatatypeOfSource)
.Return(typeof(string))
.Repeat.Any();
fieldCollection.ElementAt(3).Expect(m => m.NameSource)
.Return("TEKST")
.Repeat.Any();
fieldCollection.ElementAt(3).Expect(m => m.DatatypeOfSource)
.Return(typeof(string))
.Repeat.Any();
var filterCollection = new List <IFilter>();
var tableMock = MockRepository.GenerateMock <ITable>();
var keyMock = MockRepository.GenerateMock <ICandidateKey>();
keyMock.Expect(m => m.Table)
.Return(tableMock)
.Repeat.Any();
keyMock.Expect(m => m.Fields)
.Return(new ReadOnlyObservableCollection <KeyValuePair <IField, IMap> >(new ObservableCollection <KeyValuePair <IField, IMap> >(fieldCollection.GetRange(0, 3).Select(field => new KeyValuePair <IField, IMap>(field, null)))))
.Repeat.Any();
tableMock.Expect(m => m.NameSource)
.Return("TABEL")
.Repeat.Any();
tableMock.Expect(m => m.Fields)
.Return(new ReadOnlyObservableCollection <IField>(new ObservableCollection <IField>(fieldCollection)))
.Repeat.Any();
tableMock.Expect(m => m.PrimaryKey)
.Return(keyMock)
.Repeat.Any();
tableMock.Expect(m => m.RecordFilters)
.WhenCalled(e => e.ReturnValue = new ReadOnlyObservableCollection <IFilter>(new ObservableCollection <IFilter>(filterCollection)))
.Return(new ReadOnlyObservableCollection <IFilter>(new ObservableCollection <IFilter>(filterCollection)))
.Repeat.Any();
tableMock.Expect(m => m.AddRecordFilter(Arg <IFilter> .Is.NotNull))
.WhenCalled(e => filterCollection.Add((IFilter)e.Arguments.ElementAt(0)))
.Repeat.Any();
tableMock.Expect(m => m.Clone())
.Return(tableMock)
.Repeat.Any();
using (var oracleClient = new OracleClient())
{
var extraCriterias = new List <KeyValuePair <string, object> >
{
new KeyValuePair <string, object>("SYSTEM_NR", 0),
new KeyValuePair <string, object>("TABEL", 0),
new KeyValuePair <string, object>("NR", "00")
};
var numberOfEqualKeys = oracleClient.GetNumberOfEqualKeyValues(keyMock, extraCriterias, fixture.CreateAnonymous <string>());
Assert.That(numberOfEqualKeys, Is.EqualTo(1));
oracleClient.Dispose();
}
keyMock.AssertWasCalled(m => m.Table);
tableMock.AssertWasCalled(m => m.Clone());
tableMock.AssertWasCalled(m => m.RecordFilters, opt => opt.Repeat.Times(7));
tableMock.AssertWasCalled(m => m.AddRecordFilter(Arg <IFilter> .Is.NotNull));
}
public void TestThatValidateTableValidatesTable()
{
var fieldCollectionMock = new List <IField>(7)
{
MockRepository.GenerateMock <IField>(),
MockRepository.GenerateMock <IField>(),
MockRepository.GenerateMock <IField>(),
MockRepository.GenerateMock <IField>(),
MockRepository.GenerateMock <IField>(),
MockRepository.GenerateMock <IField>(),
MockRepository.GenerateMock <IField>()
};
fieldCollectionMock.ElementAt(0).Expect(m => m.NameSource)
.Return("SYSTEM_NR")
.Repeat.Any();
fieldCollectionMock.ElementAt(0).Expect(m => m.DatatypeOfSource)
.Return(typeof(int?))
.Repeat.Any();
fieldCollectionMock.ElementAt(1).Expect(m => m.NameSource)
.Return("TABEL")
.Repeat.Any();
fieldCollectionMock.ElementAt(1).Expect(m => m.DatatypeOfSource)
.Return(typeof(int?))
.Repeat.Any();
fieldCollectionMock.ElementAt(2).Expect(m => m.NameSource)
.Return("NR")
.Repeat.Any();
fieldCollectionMock.ElementAt(2).Expect(m => m.DatatypeOfSource)
.Return(typeof(string))
.Repeat.Any();
fieldCollectionMock.ElementAt(3).Expect(m => m.NameSource)
.Return("TEKST")
.Repeat.Any();
fieldCollectionMock.ElementAt(3).Expect(m => m.DatatypeOfSource)
.Return(typeof(string))
.Repeat.Any();
fieldCollectionMock.ElementAt(4).Expect(m => m.NameSource)
.Return("FORDELPCT")
.Repeat.Any();
fieldCollectionMock.ElementAt(4).Expect(m => m.DatatypeOfSource)
.Return(typeof(decimal?))
.Repeat.Any();
fieldCollectionMock.ElementAt(5).Expect(m => m.NameSource)
.Return("O_DATO")
.Repeat.Any();
fieldCollectionMock.ElementAt(5).Expect(m => m.DatatypeOfSource)
.Return(typeof(DateTime?))
.Repeat.Any();
fieldCollectionMock.ElementAt(6).Expect(m => m.NameSource)
.Return("O_TID")
.Repeat.Any();
fieldCollectionMock.ElementAt(6).Expect(m => m.DatatypeOfSource)
.Return(typeof(TimeSpan?))
.Repeat.Any();
var tableMock = MockRepository.GenerateMock <ITable>();
tableMock.Expect(m => m.NameSource)
.Return("TABEL")
.Repeat.Any();
tableMock.Expect(m => m.Fields)
.Return(new ReadOnlyObservableCollection <IField>(new ObservableCollection <IField>(fieldCollectionMock)))
.Repeat.Any();
using (var oracleClient = new OracleClient())
{
oracleClient.ValidateTable(tableMock);
oracleClient.Dispose();
}
tableMock.AssertWasCalled(m => m.NameSource);
tableMock.AssertWasCalled(m => m.Fields);
fieldCollectionMock.ElementAt(0).AssertWasCalled(m => m.NameSource);
fieldCollectionMock.ElementAt(0).AssertWasCalled(m => m.DatatypeOfSource);
fieldCollectionMock.ElementAt(1).AssertWasCalled(m => m.NameSource);
fieldCollectionMock.ElementAt(1).AssertWasCalled(m => m.DatatypeOfSource);
fieldCollectionMock.ElementAt(2).AssertWasCalled(m => m.NameSource);
fieldCollectionMock.ElementAt(2).AssertWasCalled(m => m.DatatypeOfSource);
fieldCollectionMock.ElementAt(3).AssertWasCalled(m => m.NameSource);
fieldCollectionMock.ElementAt(3).AssertWasCalled(m => m.DatatypeOfSource);
}
public void TestThatGetDataGetDataWithRecordFilters()
{
var fieldCollectionMock = new List <IField>(7)
{
MockRepository.GenerateMock <IField>(),
MockRepository.GenerateMock <IField>(),
MockRepository.GenerateMock <IField>(),
MockRepository.GenerateMock <IField>(),
MockRepository.GenerateMock <IField>(),
MockRepository.GenerateMock <IField>(),
MockRepository.GenerateMock <IField>()
};
fieldCollectionMock.ElementAt(0).Expect(m => m.NameSource)
.Return("SYSTEM_NR")
.Repeat.Any();
fieldCollectionMock.ElementAt(0).Expect(m => m.DatatypeOfSource)
.Return(typeof(int?))
.Repeat.Any();
fieldCollectionMock.ElementAt(0).Expect(m => m.DatatypeOfTarget)
.Return(typeof(int?))
.Repeat.Any();
fieldCollectionMock.ElementAt(0).Expect(m => m.Nullable)
.Return(false)
.Repeat.Any();
fieldCollectionMock.ElementAt(1).Expect(m => m.NameSource)
.Return("TABEL")
.Repeat.Any();
fieldCollectionMock.ElementAt(1).Expect(m => m.DatatypeOfSource)
.Return(typeof(int?))
.Repeat.Any();
fieldCollectionMock.ElementAt(1).Expect(m => m.DatatypeOfTarget)
.Return(typeof(int?))
.Repeat.Any();
fieldCollectionMock.ElementAt(1).Expect(m => m.Nullable)
.Return(false)
.Repeat.Any();
fieldCollectionMock.ElementAt(2).Expect(m => m.NameSource)
.Return("NR")
.Repeat.Any();
fieldCollectionMock.ElementAt(2).Expect(m => m.DatatypeOfSource)
.Return(typeof(string))
.Repeat.Any();
fieldCollectionMock.ElementAt(2).Expect(m => m.DatatypeOfTarget)
.Return(typeof(string))
.Repeat.Any();
fieldCollectionMock.ElementAt(2).Expect(m => m.Nullable)
.Return(false)
.Repeat.Any();
fieldCollectionMock.ElementAt(3).Expect(m => m.NameSource)
.Return("TEKST")
.Repeat.Any();
fieldCollectionMock.ElementAt(3).Expect(m => m.DatatypeOfSource)
.Return(typeof(string))
.Repeat.Any();
fieldCollectionMock.ElementAt(3).Expect(m => m.DatatypeOfTarget)
.Return(typeof(string))
.Repeat.Any();
fieldCollectionMock.ElementAt(3).Expect(m => m.Nullable)
.Return(true)
.Repeat.Any();
fieldCollectionMock.ElementAt(4).Expect(m => m.NameSource)
.Return("FORDELPCT")
.Repeat.Any();
fieldCollectionMock.ElementAt(4).Expect(m => m.DatatypeOfSource)
.Return(typeof(decimal?))
.Repeat.Any();
fieldCollectionMock.ElementAt(4).Expect(m => m.DatatypeOfTarget)
.Return(typeof(decimal?))
.Repeat.Any();
fieldCollectionMock.ElementAt(4).Expect(m => m.Nullable)
.Return(true)
.Repeat.Any();
fieldCollectionMock.ElementAt(5).Expect(m => m.NameSource)
.Return("O_DATO")
.Repeat.Any();
fieldCollectionMock.ElementAt(5).Expect(m => m.DatatypeOfSource)
.Return(typeof(DateTime?))
.Repeat.Any();
fieldCollectionMock.ElementAt(5).Expect(m => m.DatatypeOfTarget)
.Return(typeof(DateTime?))
.Repeat.Any();
fieldCollectionMock.ElementAt(5).Expect(m => m.Nullable)
.Return(true)
.Repeat.Any();
fieldCollectionMock.ElementAt(6).Expect(m => m.NameSource)
.Return("O_TID")
.Repeat.Any();
fieldCollectionMock.ElementAt(6).Expect(m => m.DatatypeOfSource)
.Return(typeof(TimeSpan?))
.Repeat.Any();
fieldCollectionMock.ElementAt(6).Expect(m => m.DatatypeOfTarget)
.Return(typeof(TimeSpan?))
.Repeat.Any();
fieldCollectionMock.ElementAt(6).Expect(m => m.Nullable)
.Return(true)
.Repeat.Any();
var primaryKeyMock = MockRepository.GenerateMock <ICandidateKey>();
primaryKeyMock.Expect(m => m.Fields)
.Return(new ReadOnlyObservableCollection <KeyValuePair <IField, IMap> >(new ObservableCollection <KeyValuePair <IField, IMap> >(fieldCollectionMock.GetRange(0, 3).Select(field => new KeyValuePair <IField, IMap>(field, null)))))
.Repeat.Any();
var recordFilterCollectionMock = new List <IFilter>(2)
{
MockRepository.GenerateMock <IFilter>(),
MockRepository.GenerateMock <IFilter>()
};
recordFilterCollectionMock.ElementAt(0).Expect(m => m.AsSql())
.Return("TABEL=0")
.Repeat.Any();
recordFilterCollectionMock.ElementAt(1).Expect(m => m.AsSql())
.Return("TABEL=1")
.Repeat.Any();
var tableMock = MockRepository.GenerateMock <ITable>();
tableMock.Expect(m => m.NameSource)
.Return("TABEL")
.Repeat.Any();
tableMock.Expect(m => m.PrimaryKey)
.Return(primaryKeyMock)
.Repeat.Any();
tableMock.Expect(m => m.RecordFilters)
.Return(new ReadOnlyObservableCollection <IFilter>(new ObservableCollection <IFilter>(recordFilterCollectionMock)))
.Repeat.Any();
tableMock.Expect(m => m.Fields)
.Return(new ReadOnlyObservableCollection <IField>(new ObservableCollection <IField>(fieldCollectionMock)))
.Repeat.Any();
using (var oracleClient = new OracleClient())
{
var data = new List <IEnumerable <IDataObjectBase> >();
oracleClient.GetData(tableMock, (s, e) =>
{
data.AddRange(e.Data);
Assert.That(data.Any(row =>
{
var dataRow = row.ToList();
return(dataRow.ElementAt(1).GetSourceValue <int?>() == 0 &&
dataRow.ElementAt(1).GetSourceValue <int?>() == 1);
}), Is.False);
});
Assert.That(data, Is.Not.Null);
var dataAsList = data.ToList();
Assert.That(dataAsList, Is.Not.Null);
Assert.That(dataAsList.Count(), Is.GreaterThan(0));
oracleClient.Dispose();
}
tableMock.AssertWasCalled(m => m.Fields);
tableMock.AssertWasCalled(m => m.RecordFilters);
tableMock.AssertWasCalled(m => m.PrimaryKey);
tableMock.AssertWasCalled(m => m.NameSource);
recordFilterCollectionMock.ElementAt(0).AssertWasCalled(m => m.AsSql());
recordFilterCollectionMock.ElementAt(1).AssertWasCalled(m => m.AsSql());
primaryKeyMock.AssertWasCalled(m => m.Fields);
}