Deveel.Data.Sql.Objects.SqlDateTimeTests Class Reference

Public Member Functions
void	Add_TimeSpan_NoDays ()
void	Subtract_TimeSpan_NoDays ()
void	Add_MonthSpan ()
void	Subtract_MonthSpan ()
void	Operator_Add_TimeSpan ()
void	Operator_Subtract_TimeSpan ()
void	Equality_True ()
void	Inequality_True ()
void	Greater_True ()

Detailed Description

Definition at line 24 of file SqlDateTimeTests.cs.

Member Function Documentation

void Deveel.Data.Sql.Objects.SqlDateTimeTests.Add_MonthSpan ( )

inline

Definition at line 59 of file SqlDateTimeTests.cs.

                                    {
            var value = new SqlDateTime(2001, 11, 03, 10, 22, 03, 0);
            var ms = new SqlYearToMonth(1, 3);

            var result = new SqlDateTime();
            Assert.DoesNotThrow(() => result = value.Add(ms));
            Assert.IsFalse(result.IsNull);
            Assert.AreEqual(2003, result.Year);
            Assert.AreEqual(02, result.Month);
            Assert.AreEqual(10, result.Hour);
            Assert.AreEqual(22, result.Minute);
            Assert.AreEqual(03, result.Second);
            Assert.AreEqual(0, result.Millisecond);
        }

void Deveel.Data.Sql.Objects.SqlDateTimeTests.Add_TimeSpan_NoDays ( )

inline

Definition at line 27 of file SqlDateTimeTests.cs.

                                          {
            var value = new SqlDateTime(2001, 01, 03, 10, 22, 03, 0);
            var ts = new SqlDayToSecond(0, 2, 03, 0);

            var result = new SqlDateTime();
            Assert.DoesNotThrow(() => result = value.Add(ts));
            Assert.IsFalse(result.IsNull);
            Assert.AreEqual(2001, result.Year);
            Assert.AreEqual(01, result.Month);
            Assert.AreEqual(03, result.Day);
            Assert.AreEqual(12, result.Hour);
            Assert.AreEqual(25, result.Minute);
        }

void Deveel.Data.Sql.Objects.SqlDateTimeTests.Equality_True ( )

inline

Definition at line 127 of file SqlDateTimeTests.cs.

                                    {
            var value1 = new SqlDateTime(2030, 03, 01, 11, 05, 54, 0);
            var value2 = new SqlDateTime(2030, 03, 01, 11, 05, 54, 0);

            Assert.IsTrue(value1 == value2);
        }

void Deveel.Data.Sql.Objects.SqlDateTimeTests.Greater_True ( )

inline

Definition at line 145 of file SqlDateTimeTests.cs.

                                   {
            var value1 = new SqlDateTime(2030, 03, 01, 11, 05, 54, 0);
            var value2 = new SqlDateTime(2020, 05, 01, 11, 05, 54, 0);
            
            Assert.IsTrue(value1 > value2);
        }

void Deveel.Data.Sql.Objects.SqlDateTimeTests.Inequality_True ( )

inline

Definition at line 136 of file SqlDateTimeTests.cs.

                                      {
            var value1 = new SqlDateTime(2030, 03, 01, 11, 05, 54, 0);
            var value2 = new SqlDateTime(2020, 05, 01, 11, 05, 54, 0);

            Assert.IsTrue(value1 != value2);
        }

void Deveel.Data.Sql.Objects.SqlDateTimeTests.Operator_Add_TimeSpan ( )

inline

Definition at line 94 of file SqlDateTimeTests.cs.

                                            {
            var value = new SqlDateTime(2001, 01, 03, 10, 22, 03, 0);
            var ts = new SqlDayToSecond(0, 2, 03, 0);

            var result = new SqlDateTime();
            Assert.DoesNotThrow(() => result = value + ts);
            Assert.IsFalse(result.IsNull);
            Assert.AreEqual(2001, result.Year);
            Assert.AreEqual(01, result.Month);
            Assert.AreEqual(03, result.Day);
            Assert.AreEqual(12, result.Hour);
            Assert.AreEqual(25, result.Minute);         
        }

void Deveel.Data.Sql.Objects.SqlDateTimeTests.Operator_Subtract_TimeSpan ( )

inline

Definition at line 111 of file SqlDateTimeTests.cs.

                                                 {
            var value = new SqlDateTime(2001, 01, 03, 10, 22, 03, 0);
            var ts = new SqlDayToSecond(0, 2, 03, 0);

            var result = new SqlDateTime();
            Assert.DoesNotThrow(() => result = value - ts);
            Assert.IsFalse(result.IsNull);
            Assert.AreEqual(2001, result.Year);
            Assert.AreEqual(01, result.Month);
            Assert.AreEqual(03, result.Day);
            Assert.AreEqual(8, result.Hour);
            Assert.AreEqual(19, result.Minute);
        }

void Deveel.Data.Sql.Objects.SqlDateTimeTests.Subtract_MonthSpan ( )

inline

Definition at line 76 of file SqlDateTimeTests.cs.

                                         {
            var value = new SqlDateTime(2001, 11, 03, 10, 22, 03, 0);
            var ms = new SqlYearToMonth(1, 3);

            var result = new SqlDateTime();
            Assert.DoesNotThrow(() => result = value.Subtract(ms));
            Assert.IsFalse(result.IsNull);
            Assert.AreEqual(2000, result.Year);
            Assert.AreEqual(08, result.Month);
            Assert.AreEqual(10, result.Hour);
            Assert.AreEqual(22, result.Minute);
            Assert.AreEqual(03, result.Second);
            Assert.AreEqual(0, result.Millisecond);         
        }

void Deveel.Data.Sql.Objects.SqlDateTimeTests.Subtract_TimeSpan_NoDays ( )

inline

Definition at line 43 of file SqlDateTimeTests.cs.

                                               {
            var value = new SqlDateTime(2001, 01, 03, 10, 22, 03, 0);
            var ts = new SqlDayToSecond(0, 2, 03, 0);

            var result = new SqlDateTime();
            Assert.DoesNotThrow(() => result = value.Subtract(ts));
            Assert.IsFalse(result.IsNull);
            Assert.AreEqual(2001, result.Year);
            Assert.AreEqual(01, result.Month);
            Assert.AreEqual(03, result.Day);
            Assert.AreEqual(8, result.Hour);
            Assert.AreEqual(19, result.Minute);
        }

---

The documentation for this class was generated from the following file:

• /var/calculate/remote/distfiles/egit-src/deveeldb.git/src/deveeldb-nunit/Deveel.Data.Sql.Objects/SqlDateTimeTests.cs