public void TestThatSelectCountForTableThrowsArgumentNullExceptionIfTableIsNull()
{
using (var oracleClient = new OracleClient())
{
Assert.Throws <ArgumentNullException>(() => oracleClient.SelectCountForTable(null));
oracleClient.Dispose();
}
}
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());
}