public static void Compare_ToSqlDayToSecond(string dts1, string dts2, int expected)
{
var d1 = SqlDayToSecond.Parse(dts1);
var d2 = SqlDayToSecond.Parse(dts2);
var result = d1.CompareTo(d2);
Assert.Equal(expected, result);
}
public static void Equal(string dts1, string dts2, bool expected)
{
var d1 = SqlDayToSecond.Parse(dts1);
var d2 = SqlDayToSecond.Parse(dts2);
var result = d1 == d2;
Assert.Equal(expected, result);
}
public static void Subtract(string dts1, string dts2, string expected)
{
var d1 = SqlDayToSecond.Parse(dts1);
var d2 = SqlDayToSecond.Parse(dts2);
var result = d1 - d2;
var expectedResult = SqlDayToSecond.Parse(expected);
Assert.Equal(expectedResult, result);
}
private static void BinaryWithInterval(Func<SqlDateTimeType, Func<ISqlValue, ISqlValue, ISqlValue>> selector, string date, string offset, string expected) {
var type = new SqlDateTimeType(SqlTypeCode.DateTime);
var sqlDate = SqlDateTime.Parse(date);
var dts = SqlDayToSecond.Parse(offset);
var op = selector(type);
var result = op(sqlDate, dts);
var expectedResult = SqlDateTime.Parse(expected);
Assert.Equal(expectedResult, result);
}
public static void CastToString(string value, SqlTypeCode destTypeCode, int size, string expexted)
{
var dts = SqlDayToSecond.Parse(value);
var type = new SqlDayToSecondType();
var destType = PrimitiveTypes.Type(destTypeCode, new { size });
var result = type.Cast(dts, destType);
var exp = SqlValueUtil.FromObject(expexted);
Assert.NotNull(result);
Assert.Equal(exp, result);
}
private static void BinaryOp(Func <SqlDateTime, SqlDayToSecond, SqlDateTime> op,
string s1,
string s2,
string expected)
{
var date = SqlDateTime.Parse(s1);
var date2 = SqlDayToSecond.Parse(s2);
var result = op(date, date2);
var expectedResult = SqlDateTime.Parse(expected);
Assert.Equal(expectedResult, result);
}
public static void Add(string dts1, string dts2, string expected)
{
var d1 = SqlDayToSecond.Parse(dts1);
var d2 = SqlDayToSecond.Parse(dts2);
var result = d1 + d2;
Assert.NotNull(result);
var expectedResult = SqlDayToSecond.Parse(expected);
Assert.Equal(expectedResult, result);
}
public static void SerializeValue(string s)
{
var dts = SqlDayToSecond.Parse(s);
var type = new SqlDayToSecondType();
var stream = new MemoryStream();
type.Serialize(stream, dts);
stream.Seek(0, SeekOrigin.Begin);
var result = type.Deserialize(stream);
Assert.Equal(dts, result);
}
private static void Binary(Func <SqlType, Func <ISqlValue, ISqlValue, ISqlValue> > selector,
string value1,
string value2,
string expected)
{
var type = new SqlDayToSecondType();
var a = SqlDayToSecond.Parse(value1);
var b = SqlDayToSecond.Parse(value2);
var op = selector(type);
var result = op(a, b);
var exp = SqlDayToSecond.Parse(expected);
Assert.Equal(exp, result);
}
public static void CastToBinary(string value, SqlTypeCode destTypeCode, int size)
{
var dts = SqlDayToSecond.Parse(value);
var type = new SqlDayToSecondType();
var destType = PrimitiveTypes.Type(destTypeCode, new { size });
var result = type.Cast(dts, destType);
Assert.IsType <SqlBinary>(result);
var binary = (SqlBinary)result;
var bytes = binary.ToByteArray();
var back = new SqlDayToSecond(bytes);
Assert.Equal(dts, back);
}
public static void CastToDayToSecond(string s, string expected)
{
var expectedResult = SqlDayToSecond.Parse(expected);
Cast(s, SqlTypeCode.DayToSecond, -1, -1, expectedResult);
}
public static void ParseInvalid(string s)
{
Assert.Throws <FormatException>(() => SqlDayToSecond.Parse(s));
}
