/// <summary>
/// interval
/// </summary>
internal static object ToInterval(NpgsqlBackendTypeInfo typeInfo, byte[] bBackendData, Int16 typeSize,
Int32 typeModifier)
{
string backendData = BackendEncoding.UTF8Encoding.GetString(bBackendData);
return(NpgsqlInterval.Parse(backendData));
}
public void NpgsqlIntervalParse()
{
string input;
NpgsqlInterval test;
input = "1 day";
test = NpgsqlInterval.Parse(input);
Assert.AreEqual(TimeSpan.FromDays(1).Ticks, test.TotalTicks, input);
input = "2 days";
test = NpgsqlInterval.Parse(input);
Assert.AreEqual(TimeSpan.FromDays(2).Ticks, test.TotalTicks, input);
input = "2 days 3:04:05";
test = NpgsqlInterval.Parse(input);
Assert.AreEqual(new TimeSpan(2, 3, 4, 5).Ticks, test.TotalTicks, input);
input = "-2 days";
test = NpgsqlInterval.Parse(input);
Assert.AreEqual(TimeSpan.FromDays(-2).Ticks, test.TotalTicks, input);
input = "-2 days -3:04:05";
test = NpgsqlInterval.Parse(input);
Assert.AreEqual(new TimeSpan(-2, -3, -4, -5).Ticks, test.TotalTicks, input);
input = "-2 days -0:01:02";
test = NpgsqlInterval.Parse(input);
Assert.AreEqual(new TimeSpan(-2, 0, -1, -2).Ticks, test.TotalTicks, input);
input = "2 days -12:00";
test = NpgsqlInterval.Parse(input);
Assert.AreEqual(new TimeSpan(2, -12, 0, 0).Ticks, test.TotalTicks, input);
input = "1 mon";
test = NpgsqlInterval.Parse(input);
Assert.AreEqual(TimeSpan.FromDays(30).Ticks, test.TotalTicks, input);
input = "2 mons";
test = NpgsqlInterval.Parse(input);
Assert.AreEqual(TimeSpan.FromDays(60).Ticks, test.TotalTicks, input);
input = "1 mon -1 day";
test = NpgsqlInterval.Parse(input);
Assert.AreEqual(TimeSpan.FromDays(29).Ticks, test.TotalTicks, input);
input = "1 mon -2 days";
test = NpgsqlInterval.Parse(input);
Assert.AreEqual(TimeSpan.FromDays(28).Ticks, test.TotalTicks, input);
input = "-1 mon -2 days -3:04:05";
test = NpgsqlInterval.Parse(input);
Assert.AreEqual(new TimeSpan(-32, -3, -4, -5).Ticks, test.TotalTicks, input);
input = "1 year";
test = NpgsqlInterval.Parse(input);
Assert.AreEqual(TimeSpan.FromDays(30 * 12).Ticks, test.TotalTicks, input);
input = "2 years";
test = NpgsqlInterval.Parse(input);
Assert.AreEqual(TimeSpan.FromDays(30 * 24).Ticks, test.TotalTicks, input);
input = "1 year -1 mon";
test = NpgsqlInterval.Parse(input);
Assert.AreEqual(TimeSpan.FromDays(30 * 11).Ticks, test.TotalTicks, input);
input = "1 year -2 mons";
test = NpgsqlInterval.Parse(input);
Assert.AreEqual(TimeSpan.FromDays(30 * 10).Ticks, test.TotalTicks, input);
input = "1 year -1 day";
test = NpgsqlInterval.Parse(input);
Assert.AreEqual(TimeSpan.FromDays(30 * 12 - 1).Ticks, test.TotalTicks, input);
input = "1 year -2 days";
test = NpgsqlInterval.Parse(input);
Assert.AreEqual(TimeSpan.FromDays(30 * 12 - 2).Ticks, test.TotalTicks, input);
input = "1 year -1 mon -1 day";
test = NpgsqlInterval.Parse(input);
Assert.AreEqual(TimeSpan.FromDays(30 * 11 - 1).Ticks, test.TotalTicks, input);
input = "1 year -2 mons -2 days";
test = NpgsqlInterval.Parse(input);
Assert.AreEqual(TimeSpan.FromDays(30 * 10 - 2).Ticks, test.TotalTicks, input);
input = "1 day 2:3:4.005";
test = NpgsqlInterval.Parse(input);
Assert.AreEqual(new TimeSpan(1, 2, 3, 4, 5).Ticks, test.TotalTicks, input);
var oldCulture = System.Threading.Thread.CurrentThread.CurrentCulture;
System.Globalization.CultureInfo testCulture = new System.Globalization.CultureInfo("fr-FR");
Assert.AreEqual(",", testCulture.NumberFormat.NumberDecimalSeparator, "decimal seperator");
try
{
System.Threading.Thread.CurrentThread.CurrentCulture = testCulture;
input = "1 day 2:3:4.005";
test = NpgsqlInterval.Parse(input);
Assert.AreEqual(new TimeSpan(1, 2, 3, 4, 5).Ticks, test.TotalTicks, input);
}
finally
{
System.Threading.Thread.CurrentThread.CurrentCulture = oldCulture;
}
}
/// <summary>
/// interval
/// </summary>
internal static object ToInterval(NpgsqlBackendTypeInfo typeInfo, String backendData, Int16 typeSize,
Int32 typeModifier)
{
return(NpgsqlInterval.Parse(backendData));
}