public void SqlFor_AsOf()
{
DateTime date = DateTime.Now;
string actual = SqlFor.Create(TemporalComparison.AsOf, date);
testOutputHelper.WriteLine(actual);
Assert.Equal($"FOR SYSTEM_TIME AS OF '{date.ToString(DATE_FORMAT)}'", actual);
}
public void SqlFor_ContainedIn()
{
DateTime start = DateTime.Now.AddDays(-1);
DateTime finish = DateTime.Now.AddDays(1);
string actual = SqlFor.Create(TemporalComparison.ContainedIn, start, finish);
string expected = $"FOR SYSTEM_TIME CONTAINED IN ('{start.ToString(DATE_FORMAT)}','{finish.ToString(DATE_FORMAT)}')";
Assert.Equal(expected, actual);
}
public void SqlFor_FromTo()
{
DateTime start = DateTime.Now.AddDays(-1);
DateTime finish = DateTime.Now.AddDays(1);
string actual = SqlFor.Create(TemporalComparison.FromTo, start, finish);
string expected = $"FOR SYSTEM_TIME FROM '{start.ToString(DATE_FORMAT)}' TO '{finish.ToString(DATE_FORMAT)}'";
Assert.Equal(expected, actual);
}
public void SqlFor_Between()
{
DateTime start = DateTime.Now.AddDays(-1);
DateTime finish = DateTime.Now.AddDays(1);
string actual = SqlFor.Create(TemporalComparison.Between, start, finish);
string expected = $"FOR SYSTEM_TIME BETWEEN '{start.ToString(DATE_FORMAT)}' AND '{finish.ToString(DATE_FORMAT)}'";
Assert.Equal(expected, actual);
}
public void SqlFor_All()
{
string actual = SqlFor.Create(TemporalComparison.All);
Assert.Equal("FOR SYSTEM_TIME ALL", actual);
}
