internal void GetOracleParameters_Object_Metadata_CollectionProperty_ObjectProperty_ReturnsSubPropertyParameters(MetadataOracleNetTypeDefinition typedef, CollectionPropertyTestClass model, MetadataOracleNetTypeDefinition metaTypeDef, int startNumber)
{
var prop = typedef.Properties.OrderBy(c => c.Order).First();
prop.NETProperty = typeof(CollectionPropertyTestClass).GetProperty(nameof(CollectionPropertyTestClass.Prop2));
prop.PropertyMetadata = metaTypeDef;
var subProp = metaTypeDef.Properties.OrderBy(c => c.Order).First();
subProp.NETProperty = typeof(SimpleTestClass).GetProperty(nameof(SimpleTestClass.Prop1));
var metadata = new MetadataOracleObject <CollectionPropertyTestClass>(typedef, new MetadataOracleCommon());
var actual = metadata.GetOracleParameters(model, startNumber);
Assert.NotNull(actual);
Assert.All(actual, c => Assert.Equal(ParameterDirection.Input, c.Direction));
Assert.Collection(actual,
(c) =>
{
Assert.Equal($":{startNumber++}", c.ParameterName);
Assert.Equal(model.Prop2[0].Prop1, c.Value);
},
(c) =>
{
Assert.Equal($":{startNumber++}", c.ParameterName);
Assert.Equal(model.Prop2[1].Prop1, c.Value);
},
(c) =>
{
Assert.Equal($":{startNumber}", c.ParameterName);
Assert.Equal(model.Prop2[2].Prop1, c.Value);
});
}
internal void GetValueFromRefCursor_Object_WithMetadata(MetadataOracleNetTypeDefinition typedef, MetadataOracleNetTypeDefinition subTypedef, Mock <IOracleRefCursorWrapper> refCursorWrapper, Mock <IOracleDataReaderWrapper> dataReaderWrapper, Mock <MetadataOracleCommon> common, SimpleTestClass oracleValue)
{
var prop = typedef.Properties.OrderBy(c => c.Order).First();
prop.NETProperty = typeof(ComplexTestClass).GetProperty(nameof(ComplexTestClass.ObjectProp));
prop.PropertyMetadata = subTypedef;
refCursorWrapper.Setup(r => r.GetDataReader()).Returns(dataReaderWrapper.Object);
dataReaderWrapper.SetupSequence(d => d.Read())
.Returns(true)
.Returns(false);
common.Setup(c => c.GetValueFromOracleXML(typeof(SimpleTestClass), null))
.Returns(oracleValue)
.Verifiable();
var metadata = new MetadataOracleObject <ComplexTestClass>(typedef, common.Object);
var result = metadata.GetValueFromRefCursor(typeof(ComplexTestClass), refCursorWrapper.Object);
common.Verify();
Assert.NotNull(result);
var actual = Assert.IsType <ComplexTestClass>(result);
Assert.NotNull(actual.ObjectProp);
Assert.Equal(oracleValue, actual.ObjectProp);
}
internal void GetValueFromRefCursor_Object_NullValue(MetadataOracleNetTypeDefinition typedef, Mock <IOracleRefCursorWrapper> refCursorWrapper, Mock <IOracleDataReaderWrapper> dataReaderWrapper, Mock <MetadataOracleCommon> common)
{
var prop = typedef.Properties.OrderBy(c => c.Order).First();
prop.NETProperty = typeof(SimpleTestClass).GetProperty(nameof(SimpleTestClass.Prop1));
refCursorWrapper.Setup(r => r.GetDataReader()).Returns(dataReaderWrapper.Object);
dataReaderWrapper.SetupSequence(d => d.Read())
.Returns(true)
.Returns(false);
dataReaderWrapper.Setup(d => d.GetOracleValue(0))
.Returns(null)
.Verifiable();
common.Setup(c => c.ConvertOracleParameterToBaseType(typeof(string), null))
.Returns(null)
.Verifiable();
var metadata = new MetadataOracleObject <SimpleTestClass>(typedef, common.Object);
var result = metadata.GetValueFromRefCursor(typeof(SimpleTestClass), refCursorWrapper.Object);
dataReaderWrapper.Verify();
common.Verify();
Assert.NotNull(result);
var actual = Assert.IsType <SimpleTestClass>(result);
Assert.NotNull(actual);
Assert.Null(actual.Prop1);
}
internal void GetRefCursorQuery_NoMetadata_ReturnsDummyQuery(MetadataOracleNetTypeDefinition typedef, int startNumber, string fieldName)
{
var metadata = new MetadataOracleObject <SimpleTestClass>(typedef, new MetadataOracleCommon());
var actual = metadata.GetRefCursorQuery(startNumber, fieldName);
Assert.NotNull(actual);
Assert.Equal($"open :{startNumber} for select 1 dummy{Environment.NewLine} from dual;", actual);
}
internal void GetOracleParameters_Array_NoMatch_ReturnsEmpty(MetadataOracleNetTypeDefinition typedef, SimpleTestClass[] model, int startNumber)
{
var metadata = new MetadataOracleObject <SimpleTestClass[]>(typedef, new MetadataOracleCommon());
var actual = metadata.GetOracleParameters(model, startNumber);
Assert.NotNull(actual);
Assert.Empty(actual);
}
internal void GetDeclareLine_Object_Simple(MetadataOracleNetTypeDefinition typedef, MetadataOracleCommon common, string parameterName, OracleUdtInfo udtInfo)
{
var type = typeof(SimpleTestClass);
var metadata = new MetadataOracleObject <SimpleTestClass>(typedef, common);
var declareLine = metadata.GetDeclareLine(type, parameterName, udtInfo);
Assert.Equal($"{parameterName} {udtInfo.FullObjectName};" + Environment.NewLine, declareLine);
}
internal void MetadataOracleObject_Constructor_Collection(ServForOracleCache cache, MetadataOracleTypeDefinition metadataOracleType, UdtPropertyNetPropertyMap[] customProperties, bool fuzzyNameMatch)
{
var typedef = new MetadataOracleNetTypeDefinition(cache, typeof(TestClass[]).GetCollectionUnderType(), metadataOracleType, customProperties, fuzzyNameMatch);
var metadata = new MetadataOracleObject <TestClass[]>(typedef, new MetadataOracleCommon());
Assert.NotNull(metadata);
Assert.NotNull(metadata.OracleTypeNetMetadata);
Assert.NotNull(metadata.OracleTypeNetMetadata.Properties);
CompareOracleTypeNetMetadata(metadataOracleType.Properties.ToArray(), metadata.OracleTypeNetMetadata.Properties.ToArray());
Assert.Equal(metadataOracleType.UDTInfo, metadata.OracleTypeNetMetadata.UDTInfo);
}
internal void GetDeclareLine_Collection(MetadataOracleNetTypeDefinition typedef, MetadataOracleCommon common, string parameterName, OracleUdtInfo udtInfo)
{
var type = typeof(ComplexTestClass[]);
var metadata = new MetadataOracleObject <ComplexTestClass[]>(typedef, common);
var declareLine = metadata.GetDeclareLine(type, parameterName, udtInfo);
var expected = $"{parameterName} {udtInfo.FullCollectionName} := {udtInfo.FullCollectionName}();" + Environment.NewLine;
Assert.Equal(expected, declareLine);
}
internal void GetRefCursorQuery_NetProperty_ReturnsRootQuery(MetadataOracleNetTypeDefinition typedef, int startNumber, string fieldName)
{
var prop = typedef.Properties.OrderBy(c => c.Order).First();
prop.NETProperty = typeof(SimpleTestClass).GetProperty(nameof(SimpleTestClass.Prop1));
var metadata = new MetadataOracleObject <SimpleTestClass>(typedef, new MetadataOracleCommon());
var actual = metadata.GetRefCursorQuery(startNumber, fieldName);
Assert.NotNull(actual);
Assert.Equal($"open :{startNumber} for select value({fieldName}).{prop.Name} {prop.NETProperty.Name}{Environment.NewLine} from dual;", actual);
}
internal void BuildQueryConstructorString_Object_NoMatch_AllPropertiesNull(ServForOracleCache cache, MetadataOracleTypeDefinition metadataOracleType, UdtPropertyNetPropertyMap[] customProperties, bool fuzzyNameMatch, TestClass model, string name, int startNumber)
{
var typedef = new MetadataOracleNetTypeDefinition(cache, typeof(TestClass), metadataOracleType, customProperties, fuzzyNameMatch);
var metadata = new MetadataOracleObject <TestClass>(typedef, new MetadataOracleCommon());
var(constructor, lastNumber) = metadata.BuildQueryConstructorString(model, name, startNumber);
Assert.NotNull(constructor);
var expectedConstructor = $"{name} := {metadataOracleType.UDTInfo.FullObjectName}({string.Join(',', metadataOracleType.Properties.OrderBy(c => c.Order).Select(c => $"{c.Name}=>null"))});" + Environment.NewLine;
Assert.Equal(expectedConstructor, constructor);
Assert.Equal(startNumber, lastNumber);
}
internal void GetOracleParameterForRefCursor_CallsCommon(MetadataOracleNetTypeDefinition typedef, Mock <MetadataOracleCommon> common, int startNumber, OracleParameter parameter)
{
common.Setup(c => c.GetOracleParameterForRefCursor(startNumber))
.Returns(parameter)
.Verifiable();
var metadata = new MetadataOracleObject <SimpleTestClass>(typedef, common.Object);
var actual = metadata.GetOracleParameterForRefCursor(startNumber);
Assert.NotNull(actual);
common.Verify();
Assert.Same(parameter, actual);
}
internal async Task GetMetadataOracleObjectAsync_FindsInCache(OracleUdtInfo info, MetadataOracleTypeDefinition typeDefinition, UdtPropertyNetPropertyMap[] properties)
{
var typedef = new MetadataOracleNetTypeDefinition(cacheMoq.Object, typeof(TestRoy), typeDefinition, properties, fuzzyNameMatch: true);
var metadata = new MetadataOracleObject <TestRoy>(typedef, new MetadataOracleCommon());
cacheMoq.Setup(c => c.GetMetadata(typeof(TestRoy).FullName))
.Returns(metadata)
.Verifiable();
var builder = new MetadataBuilder(connectionMoq.Object, cacheMoq.Object, loggerMoq.Object);
var result = await builder.GetOrRegisterMetadataOracleObjectAsync <TestRoy>(info);
cacheMoq.Verify();
Assert.Equal(metadata, result);
}
internal void BuildQueryConstructorString_Object_SimpleNetProperty_NullPropertyValue(MetadataOracleNetTypeDefinition typedef, string name, int startNumber)
{
var prop = typedef.Properties.OrderBy(c => c.Order).First();
prop.NETProperty = typeof(SimpleTestClass).GetProperty(nameof(SimpleTestClass.Prop1));
var metadata = new MetadataOracleObject <SimpleTestClass>(typedef, new MetadataOracleCommon());
var(constructor, lastNumber) = metadata.BuildQueryConstructorString(new SimpleTestClass(), name, startNumber);
Assert.NotNull(constructor);
var expectedConstructor = $"{name} := {typedef.UDTInfo.FullObjectName}({string.Join(',', typedef.Properties.OrderBy(c => c.Order).Select(c => $"{c.Name}=>null"))});" + Environment.NewLine;
Assert.Equal(expectedConstructor, constructor);
Assert.Equal(startNumber, lastNumber);
}
private AdditionalInformation ReturnValueAdditionalInformation <T>(ExecutionInformation info, OracleUdtInfo udt,
MetadataOracleObject <T> metadata, out OracleParameter parameter)
{
var returnType = typeof(T);
parameter = FunctionReturnOracleParameter <T>(info, metadata);
var name = "ret";
var returnInfo = new AdditionalInformation
{
Declare = metadata.GetDeclareLine(returnType, name, udt ?? metadata.OracleTypeNetMetadata.UDTInfo),
Output = metadata.GetRefCursorQuery(info.ParameterCounter, name)
};
return(returnInfo);
}
internal void GetValueFromRefCursor_Object(MetadataOracleNetTypeDefinition typedef, Mock <IOracleRefCursorWrapper> refCursorWrapper,
Mock <IOracleDataReaderWrapper> dataReaderWrapper)
{
var metadata = new MetadataOracleObject <SimpleTestClass>(typedef, new MetadataOracleCommon());
refCursorWrapper.Setup(r => r.GetDataReader()).Returns(dataReaderWrapper.Object);
dataReaderWrapper.SetupSequence(d => d.Read())
.Returns(true)
.Returns(false);
var result = metadata.GetValueFromRefCursor(typeof(SimpleTestClass), refCursorWrapper.Object);
Assert.NotNull(result);
var actual = Assert.IsType <SimpleTestClass>(result);
Assert.Null(actual.Prop1);
}
internal void GetDeclareLine_Object_WithMetadata(MetadataOracleNetTypeDefinition typedef, MetadataOracleNetTypeDefinition subTypeDef, MetadataOracleCommon common, string parameterName, OracleUdtInfo udtInfo)
{
var type = typeof(ComplexTestClass);
var prop = typedef.Properties.First();
prop.PropertyMetadata = subTypeDef;
prop.NETProperty = type.GetProperty(nameof(ComplexTestClass.ObjectProp));
var metadata = new MetadataOracleObject <ComplexTestClass>(typedef, common);
var declareLine = metadata.GetDeclareLine(type, parameterName, udtInfo);
var expected = $"{parameterName}_0 {subTypeDef.UDTInfo.FullObjectName};" + Environment.NewLine
+ $"{parameterName} {udtInfo.FullObjectName};" + Environment.NewLine;
Assert.Equal(expected, declareLine);
}
internal void GetOracleParameters_Object_NetProperty_NoMetadata_ReturnsParameters(MetadataOracleNetTypeDefinition typedef, SimpleTestClass model, int startNumber)
{
var prop = typedef.Properties.OrderBy(c => c.Order).First();
prop.NETProperty = typeof(SimpleTestClass).GetProperty(nameof(SimpleTestClass.Prop1));
var metadata = new MetadataOracleObject <SimpleTestClass>(typedef, new MetadataOracleCommon());
var actual = metadata.GetOracleParameters(model, startNumber);
Assert.NotNull(actual);
var oraProp = Assert.Single(actual);
Assert.NotNull(oraProp);
Assert.Equal($":{startNumber}", oraProp.ParameterName);
Assert.Equal(ParameterDirection.Input, oraProp.Direction);
Assert.Equal(model.Prop1, oraProp.Value);
}
internal void GetRefCursorQuery_WithMetadata_Array_ReturnsXMLElement_WithDummy(MetadataOracleNetTypeDefinition typedef, MetadataOracleNetTypeDefinition metaTypeProp, int startNumber, string fieldName)
{
var prop = typedef.Properties.OrderBy(c => c.Order).First();
prop.NETProperty = typeof(SimpleTestClass).GetProperty(nameof(SimpleTestClass.Prop1));
prop.PropertyMetadata = metaTypeProp;
var metadata = new MetadataOracleObject <SimpleTestClass[]>(typedef, new MetadataOracleCommon());
var actual = metadata.GetRefCursorQuery(startNumber, fieldName);
Assert.NotNull(actual);
var expected = $"open :{startNumber} for select (select xmlelement( \"{prop.NETProperty.Name}\", xmlconcat( 1 dummy) "
+ $") from dual) {prop.NETProperty.Name}{Environment.NewLine} from table({fieldName}) c;";
Assert.Equal(expected, actual);
}
internal void BuildQueryConstructorString_Array(MetadataOracleNetTypeDefinition typedef, SimpleTestClass[] model, string name, int startNumber)
{
var metadata = new MetadataOracleObject <SimpleTestClass[]>(typedef, new MetadataOracleCommon());
var(constructor, lastNumber) = metadata.BuildQueryConstructorString(model, name, startNumber);
Assert.NotNull(constructor);
var expectedConstructor = new StringBuilder();
for (var i = 0; i < model.Length; i++)
{
expectedConstructor.AppendLine($"{name}.extend;");
expectedConstructor.Append($"{name}({name}.last) := {typedef.UDTInfo.FullObjectName}(");
expectedConstructor.Append(string.Join(',', typedef.Properties.OrderBy(c => c.Order).Select(c => $"{c.Name}=>null")));
expectedConstructor.AppendLine(");");
}
Assert.Equal(expectedConstructor.ToString(), constructor);
Assert.Equal(startNumber, lastNumber);
}
internal void GetRefCursorQuery_NetProperty_MultipleProperties(MetadataOracleNetTypeDefinition typedef, int startNumber, string fieldName)
{
var prop = typedef.Properties.OrderBy(c => c.Order).First();
prop.NETProperty = typeof(MultiplePropertiesTestClass).GetProperty(nameof(MultiplePropertiesTestClass.Prop1));
var anotherProp = typedef.Properties.Where(c => c != prop).OrderBy(c => c.Order).First();
anotherProp.NETProperty = typeof(MultiplePropertiesTestClass).GetProperty(nameof(MultiplePropertiesTestClass.Prop2));
var metadata = new MetadataOracleObject <SimpleTestClass>(typedef, new MetadataOracleCommon());
var actual = metadata.GetRefCursorQuery(startNumber, fieldName);
Assert.NotNull(actual);
var expected = $"open :{startNumber} for select value({fieldName}).{prop.Name} {prop.NETProperty.Name},"
+ Environment.NewLine
+ $"value({fieldName}).{anotherProp.Name} {anotherProp.NETProperty.Name}"
+ $"{Environment.NewLine} from dual;";
Assert.Equal(expected, actual);
}
internal void BuildQueryConstructorString_Object_SimpleNetProperty_WithMetadata(MetadataOracleNetTypeDefinition typedef, MetadataOracleNetTypeDefinition metTypeDef, SimpleTestClass model, string name, int startNumber)
{
var prop = typedef.Properties.OrderBy(c => c.Order).First();
prop.NETProperty = typeof(SimpleTestClass).GetProperty(nameof(SimpleTestClass.Prop1));
prop.PropertyMetadata = metTypeDef;
var metadata = new MetadataOracleObject <SimpleTestClass>(typedef, new MetadataOracleCommon());
var(constructor, lastNumber) = metadata.BuildQueryConstructorString(model, name, startNumber);
Assert.NotNull(constructor);
var expectedConstructor = new StringBuilder();
expectedConstructor.AppendLine($"{name}_0 := {metTypeDef.UDTInfo.FullObjectName}({string.Join(',', metTypeDef.Properties.OrderBy(c => c.Order).Select(c => $"{c.Name}=>null"))});");
expectedConstructor.Append($"{name} := {typedef.UDTInfo.FullObjectName}({prop.Name}=>{name}_0,");
expectedConstructor.Append(string.Join(',', typedef.Properties.OrderBy(c => c.Order).Where(c => c.Name != prop.Name).Select(c => $"{c.Name}=>null")));
expectedConstructor.AppendLine(");");
Assert.Equal(expectedConstructor.ToString(), constructor);
Assert.Equal(startNumber, lastNumber);
}
internal void GetValueFromRefCursor_Collection_NullValue(MetadataOracleNetTypeDefinition typedef, Mock <IOracleRefCursorWrapper> refCursorWrapper, Mock <IOracleDataReaderWrapper> dataReaderWrapper, Mock <MetadataOracleCommon> common, SimpleTestClass[] simples, object oracleValue)
{
var prop = typedef.Properties.OrderBy(c => c.Order).First();
prop.NETProperty = typeof(SimpleTestClass).GetProperty(nameof(SimpleTestClass.Prop1));
refCursorWrapper.Setup(r => r.GetDataReader()).Returns(dataReaderWrapper.Object);
dataReaderWrapper.SetupSequence(d => d.Read())
.Returns(true).Returns(true).Returns(true)
.Returns(false);
int i = 0;
dataReaderWrapper.Setup(d => d.GetOracleValue(i))
.Callback(() => i++)
.Returns(oracleValue);
common.SetupSequence(c => c.ConvertOracleParameterToBaseType(typeof(string), oracleValue))
.Returns(simples[0].Prop1)
.Returns(simples[1].Prop1)
.Returns(simples[2].Prop1);
//.Verifiable();
var metadata = new MetadataOracleObject <SimpleTestClass>(typedef, common.Object);
var result = metadata.GetValueFromRefCursor(typeof(SimpleTestClass[]), refCursorWrapper.Object);
dataReaderWrapper.Verify();
common.Verify();
Assert.NotNull(result);
var actual = Assert.IsType <SimpleTestClass[]>(result);
Assert.NotNull(actual);
Assert.Collection(actual,
c => Assert.Equal(simples[0].Prop1, c.Prop1),
c => Assert.Equal(simples[1].Prop1, c.Prop1),
c => Assert.Equal(simples[2].Prop1, c.Prop1)
);
}
internal void GetRefCursorQuery_WithMetadata_CollectionProperty_ReturnsXMLElement(MetadataOracleNetTypeDefinition typedef, MetadataOracleNetTypeDefinition metaTypeProp, int startNumber, string fieldName)
{
var prop = typedef.Properties.OrderBy(c => c.Order).First();
prop.NETProperty = typeof(CollectionPropertyTestClass).GetProperty(nameof(CollectionPropertyTestClass.Prop2));
prop.PropertyMetadata = metaTypeProp;
var subProp = metaTypeProp.Properties.OrderBy(c => c.Order).First();
subProp.NETProperty = typeof(SimpleTestClass).GetProperty(nameof(SimpleTestClass.Prop1));
var metadata = new MetadataOracleObject <CollectionPropertyTestClass>(typedef, new MetadataOracleCommon());
var actual = metadata.GetRefCursorQuery(startNumber, fieldName);
Assert.NotNull(actual);
var expected = $"open :{startNumber} for select (select xmlelement( \"{prop.NETProperty.Name}\", xmlagg( xmlconcat( xmlelement( \"{prop.NETProperty.Name}\", "
+ $"XmlElement(\"{subProp.NETProperty.Name}\", d1.{subProp.Name})"
+ $") ) ) ) from table(value({fieldName}).{prop.Name}) d1)"
+ $" {prop.Name}{Environment.NewLine} from dual;";
Assert.Equal(expected, actual);
}
internal async Task LoadObjectMetadataAsync_Works(Mock <MetadataBuilder> builder, TestClass model, ParameterDirection direction, OracleUdtInfo info, MetadataOracleObject <TestClass> metadataObject)
{
builder.Setup(b => b.GetOrRegisterMetadataOracleObjectAsync <TestClass>(info))
.ReturnsAsync(metadataObject)
.Verifiable();
var param = new ParamObject <TestClass>(model, direction, info);
await param.LoadObjectMetadataAsync(builder.Object);
builder.Verify();
Assert.True(param.MetadataLoaded);
}
