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