public void GetOracleStringWithContentReturnsContent()
{
var oraString = new OracleString("Foo");
var result = OracleValueConverter.Convert <string>(oraString);
result.Should().Be("Foo");
}
public void GetOracleNumberReturnAsDecimal()
{
decimal expected = 100;
var result = OracleValueConverter.Convert <decimal>(100);
result.Should().Be(expected);
}
public void GetOracleStringAsNullReturnsNull()
{
var oraString = new OracleString();
var result = OracleValueConverter.Convert <string>(oraString);
result.Should().BeNull();
}
public void GetOracleBoolean()
{
var oraBool = new OracleBoolean(true);
var result = OracleValueConverter.Convert <bool>(oraBool);
result.Should().Be(true);
oraBool = new OracleBoolean(-1);
result = OracleValueConverter.Convert <bool>(oraBool);
result.Should().Be(true);
oraBool = new OracleBoolean(1);
result = OracleValueConverter.Convert <bool>(oraBool);
result.Should().Be(true);
oraBool = new OracleBoolean(0);
result = OracleValueConverter.Convert <bool>(oraBool);
result.Should().Be(false);
var oraBoolArr = new OracleBoolean[2] {
true, false
};
var resultArr = OracleValueConverter.Convert <bool[]>(oraBoolArr);
resultArr.Should().BeOfType <bool[]>();
resultArr.Should().HaveCount(2);
}
public void GetOracleString2StringArray()
{
var oraArray = new OracleString[] { "Foo", "Bar" };
var result = OracleValueConverter.Convert <string[]>(oraArray);
result.Should().BeOfType <string[]>();
result.Should().HaveCount(2);
}
public void GetOracleDecimalReturnsNullableDecimal()
{
decimal expected = 100;
var result = OracleValueConverter.Convert <decimal?>(new OracleDecimal(expected));
result.Should().Be(expected);
}
public void GetOracleBinary()
{
var bytes = Encoding.UTF8.GetBytes("Lorem ipsum");
var oracleBytes = new OracleBinary(bytes);
var result = OracleValueConverter.Convert <byte[]>(oracleBytes);
result.Should().Equal(bytes);
}
public void GetIntArray()
{
var oraArray = new OracleDecimal[] { 1, 2 };
var result = OracleValueConverter.Convert <int[]>(oraArray);
result.Should().BeOfType <int[]>();
result.Should().HaveCount(2);
}
public void GetOracleDecimalReturnsNullableInt64()
{
decimal input = 100;
var expected = Convert.ToInt64(input);
var result = OracleValueConverter.Convert <long?>(new OracleDecimal(input));
result.Should().Be(expected);
}
public void GetOracleDecimalReturnsInt32()
{
decimal input = 100;
var expected = Convert.ToInt32(input);
var result = OracleValueConverter.Convert <int>(new OracleDecimal(input));
result.Should().Be(expected);
}
public void GetOracleTimeStamp()
{
var dateNow = DateTime.Now;
var oraTimeStamp = new OracleTimeStamp(dateNow);
var result = OracleValueConverter.Convert <DateTime>(oraTimeStamp);
result.Should().Be(dateNow);
var oraTimeStampArr = new OracleTimeStamp[1] {
dateNow
};
var secondResult = OracleValueConverter.Convert <DateTime[]>(oraTimeStampArr);
secondResult.Should().BeOfType <DateTime[]>();
secondResult.Should().HaveCount(1);
}
public void GetOracleDateArray()
{
var oraDateArray = new OracleDate[] {
(OracleDate)DateTime.Now,
(OracleDate)DateTime.Now.AddYears(1),
new OracleDate("10/29/2020 16:14:23")
};
var nullableOraDateArray = new OracleDate?[] {
(OracleDate)DateTime.Now,
(OracleDate)DateTime.Now.AddYears(1),
null,
new OracleDate("10/29/2020 16:14:23")
};
var result = OracleValueConverter.Convert <DateTime[]>(oraDateArray);
result.Should().BeOfType <DateTime[]>();
result.Should().HaveCount(oraDateArray.Length);
var secondResult = OracleValueConverter.Convert <DateTime?[]>(nullableOraDateArray);
secondResult.Should().BeOfType <DateTime?[]>();
secondResult.Should().HaveCount(nullableOraDateArray.Length);
}
public void GetOracleDateTimeReturnsDateTime()
{
var result = OracleValueConverter.Convert <DateTime>(new OracleDate(DateTime.Today));
result.Should().Be(DateTime.Today);
}
public void GetNullAsDecimalReturns0()
{
var result = OracleValueConverter.Convert <double>(null);
result.Should().Be(0);
}
public void GetNullAsInt64Returns0()
{
var result = OracleValueConverter.Convert <long>(null);
result.Should().Be(0);
}
public void GetDbNullAsInt32Returns0()
{
var result = OracleValueConverter.Convert <int>(DBNull.Value);
result.Should().Be(0);
}
public void GetNullAsStringReturnsNull()
{
var result = OracleValueConverter.Convert <string>(null);
result.Should().BeNull();
}
public void GetNullAsNullableDecimalReturnsNull()
{
var result = OracleValueConverter.Convert <decimal?>(null);
result.Should().BeNull();
}
public void GetOracleDecimalReturnsDecimal()
{
var result = OracleValueConverter.Convert <decimal>(new OracleDecimal(100));
result.Should().Be(100);
}
public void GetStringAsDbNullReturnsNull()
{
var result = OracleValueConverter.Convert <string>(DBNull.Value);
result.Should().BeNull();
}
public void GetNullAsNullableInt64ReturnsNull()
{
var result = OracleValueConverter.Convert <long?>(null);
result.Should().BeNull();
}
public void GetDbNullAsDecimalReturns0()
{
var result = OracleValueConverter.Convert <decimal>(DBNull.Value);
result.Should().Be(0);
}
public void GetDbNullAsInt64ReturnsNull()
{
var result = OracleValueConverter.Convert <long?>(DBNull.Value);
result.Should().Be(null);
}
