public void NotEqualTest() { ExecuteInsideSession(() => { RunTest <SingleDateTimeEntity>(c => c.DateTime != FirstDateTime.AddYears(1)); RunTest <SingleDateTimeEntity>(c => c.MillisecondDateTime != FirstMillisecondDateTime.AddYears(1)); RunTest <SingleDateTimeEntity>(c => c.NullableDateTime != NullableDateTime.AddYears(1)); }); }
public void MysqlExtractMillisecondTest() { Require.ProviderIs(StorageProvider.MySql); ExecuteInsideSession(() => { var firstMillisecondDateTime = FirstMillisecondDateTime.FixDateTimeForProvider(StorageProviderInfo.Instance); RunTest <SingleDateTimeEntity>(c => c.MillisecondDateTime.Millisecond == firstMillisecondDateTime.Millisecond); RunWrongTest <SingleDateTimeEntity>(c => c.MillisecondDateTime.Second == WrongMillisecondDateTime.Millisecond); }); }
public void CompareTest() { ExecuteInsideSession(() => { RunTest <SingleDateTimeEntity>(c => c.DateTime > FirstDateTime.Date); RunTest <SingleDateTimeEntity>(c => c.DateTime > FirstDateTime.AddSeconds(-1)); RunTest <SingleDateTimeEntity>(c => c.MillisecondDateTime > FirstMillisecondDateTime.AddMilliseconds(-1)); RunTest <SingleDateTimeEntity>(c => c.DateTime < FirstDateTime.Date.AddDays(1)); RunTest <SingleDateTimeEntity>(c => c.DateTime < FirstDateTime.AddSeconds(1)); RunTest <SingleDateTimeEntity>(c => c.MillisecondDateTime < FirstMillisecondDateTime.AddMilliseconds(1)); RunWrongTest <SingleDateTimeEntity>(c => c.DateTime > FirstDateTime); RunWrongTest <SingleDateTimeEntity>(c => c.MillisecondDateTime > FirstMillisecondDateTime); RunWrongTest <SingleDateTimeEntity>(c => c.MillisecondDateTime < FirstMillisecondDateTime.Date); }); }
public void CompareTest() { Require.ProviderIsNot(StorageProvider.MySql); ExecuteInsideSession(() => { RunTest <SingleDateTimeEntity>(c => c.DateTime > FirstDateTime.Date); RunTest <SingleDateTimeEntity>(c => c.DateTime > FirstDateTime.AddSeconds(-1)); RunTest <SingleDateTimeEntity>(c => c.MillisecondDateTime > FirstMillisecondDateTime.AddMilliseconds(-1)); RunTest <SingleDateTimeEntity>(c => c.DateTime < FirstDateTime.Date.AddDays(1)); RunTest <SingleDateTimeEntity>(c => c.DateTime < FirstDateTime.AddSeconds(1)); RunTest <SingleDateTimeEntity>(c => c.MillisecondDateTime < FirstMillisecondDateTime.AddMilliseconds(1)); RunWrongTest <SingleDateTimeEntity>(c => c.DateTime > FirstDateTime); RunWrongTest <SingleDateTimeEntity>(c => c.MillisecondDateTime > FirstMillisecondDateTime); RunWrongTest <SingleDateTimeEntity>(c => c.MillisecondDateTime < FirstMillisecondDateTime.Date); }); }
public void MysqlMinisDateTimeTest() { Require.ProviderIs(StorageProvider.MySql); ExecuteInsideSession(() => { var firstDateTime = FirstDateTime.FixDateTimeForProvider(StorageProviderInfo.Instance); var firstMillisecondDateTime = FirstMillisecondDateTime.FixDateTimeForProvider(StorageProviderInfo.Instance); var secondDateTime = SecondDateTime.FixDateTimeForProvider(StorageProviderInfo.Instance); var nullableDateTime = NullableDateTime.FixDateTimeForProvider(StorageProviderInfo.Instance); RunTest <SingleDateTimeEntity>(c => c.DateTime - secondDateTime == firstDateTime - secondDateTime); RunTest <SingleDateTimeEntity>(c => c.MillisecondDateTime - secondDateTime == firstMillisecondDateTime - secondDateTime); RunTest <SingleDateTimeEntity>(c => c.NullableDateTime - secondDateTime == nullableDateTime - secondDateTime); RunWrongTest <SingleDateTimeEntity>(c => c.DateTime - secondDateTime == firstDateTime - WrongDateTime); RunWrongTest <SingleDateTimeEntity>(c => c.MillisecondDateTime - secondDateTime == firstMillisecondDateTime - WrongDateTime); RunWrongTest <SingleDateTimeEntity>(c => c.NullableDateTime - secondDateTime == nullableDateTime - WrongDateTime); }); }
public void AddMillisecondsTest() { Require.ProviderIsNot(StorageProvider.MySql); ExecuteInsideSession(() => { RunTest <SingleDateTimeEntity>(c => c.MillisecondDateTime.AddMilliseconds(-2) == FirstMillisecondDateTime.AddMilliseconds(-2)); RunWrongTest <SingleDateTimeEntity>(c => c.MillisecondDateTime.AddMilliseconds(-1) == FirstMillisecondDateTime.AddMilliseconds(-2)); }); }
public void AddSecondsTest() { ExecuteInsideSession(() => { RunTest <SingleDateTimeEntity>(c => c.DateTime.AddSeconds(1) == FirstDateTime.AddSeconds(1)); RunTest <SingleDateTimeEntity>(c => c.MillisecondDateTime.AddSeconds(-2) == FirstMillisecondDateTime.AddSeconds(-2)); RunTest <SingleDateTimeEntity>(c => c.NullableDateTime.Value.AddSeconds(33) == NullableDateTime.AddSeconds(33)); RunWrongTest <SingleDateTimeEntity>(c => c.DateTime.AddSeconds(1) == FirstDateTime.AddSeconds(2)); RunWrongTest <SingleDateTimeEntity>(c => c.MillisecondDateTime.AddSeconds(-1) == FirstMillisecondDateTime.AddSeconds(-2)); RunWrongTest <SingleDateTimeEntity>(c => c.NullableDateTime.Value.AddSeconds(33) == NullableDateTime.AddSeconds(44)); }); }
public void SubtractDateTimeTest() { Require.ProviderIsNot(StorageProvider.MySql); ExecuteInsideSession(() => { RunTest <SingleDateTimeEntity>(c => c.DateTime.Subtract(SecondDateTime) == FirstDateTime.Subtract(SecondDateTime)); RunTest <SingleDateTimeEntity>(c => c.MillisecondDateTime.Subtract(SecondDateTime) == FirstMillisecondDateTime.Subtract(SecondDateTime)); RunTest <SingleDateTimeEntity>(c => c.NullableDateTime.Value.Subtract(SecondDateTime) == NullableDateTime.Subtract(SecondDateTime)); RunWrongTest <SingleDateTimeEntity>(c => c.DateTime.Subtract(SecondDateTime) == FirstDateTime.Subtract(WrongDateTime)); RunWrongTest <SingleDateTimeEntity>(c => c.MillisecondDateTime.Subtract(SecondDateTime) == FirstMillisecondDateTime.Subtract(WrongDateTime)); RunWrongTest <SingleDateTimeEntity>(c => c.NullableDateTime.Value.Subtract(SecondDateTime) == NullableDateTime.Subtract(WrongDateTime)); }); }
public void SubtractTimeSpanTest() { ExecuteInsideSession(() => { RunTest <SingleDateTimeEntity>(c => c.DateTime.Subtract(FirstOffset) == FirstDateTime.Subtract(FirstOffset)); RunTest <SingleDateTimeEntity>(c => c.MillisecondDateTime.Subtract(SecondOffset) == FirstMillisecondDateTime.Subtract(SecondOffset)); RunTest <SingleDateTimeEntity>(c => c.NullableDateTime.Value.Subtract(FirstOffset) == NullableDateTime.Subtract(FirstOffset)); RunWrongTest <SingleDateTimeEntity>(c => c.DateTime.Subtract(FirstOffset) == FirstDateTime.Subtract(WrongOffset)); RunWrongTest <SingleDateTimeEntity>(c => c.MillisecondDateTime.Subtract(SecondOffset) == FirstMillisecondDateTime.Subtract(WrongOffset)); RunWrongTest <SingleDateTimeEntity>(c => c.NullableDateTime.Value.Subtract(FirstOffset) == NullableDateTime.Subtract(WrongOffset)); }); }
public void AddMillisecondsTest() { ExecuteInsideSession(() => { RunTest <SingleDateTimeEntity>(c => c.MillisecondDateTime.AddMilliseconds(-2) == FirstMillisecondDateTime.AddMilliseconds(-2)); RunWrongTest <SingleDateTimeEntity>(c => c.MillisecondDateTime.AddMilliseconds(-1) == FirstMillisecondDateTime.AddMilliseconds(-2)); }); }