public void ConvertHexToBytes(string hex, byte b1, byte b2, byte b3)
{
byte[] expectedBytes = new byte[] { b1, b2, b3 };
var resultBytes = SnowflakeTypesConverter.HexToBytes(hex);
Assert.AreEqual(expectedBytes, resultBytes);
}
public void DateTimeOffset_ToSnowflakeTimestampTz(string dateTimeString, string expectedSnowflakeTimestampTz)
{
var dateTimeOffsetUtc = DateTimeOffset.ParseExact(dateTimeString, "yyyy-MM-dd HH:mm:ss.fffffff", CultureInfo.InvariantCulture, DateTimeStyles.AssumeUniversal);
var convertedResult = SnowflakeTypesConverter.ConvertToTimestampTz(dateTimeOffsetUtc);
Assert.AreEqual(expectedSnowflakeTimestampTz, convertedResult);
}
public void DateTime_ToSnowflakeTimestampNtz(string dateTimeString, string expectedSnowflakeTimestampNtz)
{
var dateTime = DateTime.ParseExact(dateTimeString, "yyyy-MM-dd HH:mm:ss.fffffff", CultureInfo.InvariantCulture);
var convertedResult = SnowflakeTypesConverter.ConvertToTimestampNtz(dateTime);
Assert.AreEqual(expectedSnowflakeTimestampNtz, convertedResult);
}
public void SnowflakeDate_ToDateTime(string sfDate, string expectedDateTimeString)
{
var expectedDateTime = DateTime.ParseExact(expectedDateTimeString, "yyyy-MM-dd", CultureInfo.InvariantCulture);
var convertedResult = SnowflakeTypesConverter.ConvertToDateTime(sfDate, "date");
Assert.AreEqual(expectedDateTime, convertedResult);
}
public void SnowflakeTime_ToDateTime(string sfTime, string expectedDateTimeString)
{
var expectedDateTime = DateTime.ParseExact(expectedDateTimeString, "yyyy-MM-dd HH:mm:ss.fffffff", CultureInfo.InvariantCulture);
var convertedResult = SnowflakeTypesConverter.ConvertToDateTime(sfTime, "time"); // same conversion as for "timestamp_ntz"
Assert.AreEqual(expectedDateTime, convertedResult);
}
public void ConvertBytesToHex(byte b1, byte b2, byte b3, string hexExpected)
{
var hexResult = SnowflakeTypesConverter.BytesToHex(new byte[] { b1, b2, b3 });
Assert.AreEqual(hexExpected, hexResult);
}
