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 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 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);
}