Deveel.Data.Sql.Objects.SqlStringTests Class Reference

Public Member Functions
void	String_Create ()
void	String_Compare_Equal ()
void	String_Equals ()
void	String_Concat ()
void	String_EqualsToNull ()
void	String_Convert_TimeStamp ()
void	String_Convert_Time ()
void	String_Convert_Date ()
void	String_Convert_BigNumber ()
void	String_Convert_BooleanTrue ()
void	String_Convert_BooleanFalse ()
void	String_Convert_BooleanNull ()

Detailed Description

Definition at line 24 of file SqlStringTests.cs.

Member Function Documentation

void Deveel.Data.Sql.Objects.SqlStringTests.String_Compare_Equal ( )

inline

Definition at line 37 of file SqlStringTests.cs.

                                           {
            const string s = "Test string in UTF-16 LE";
            var sqlString1 = new SqlString(s);
            var sqlString2 = new SqlString(s);
            Assert.AreEqual(0, sqlString1.CompareTo(sqlString2));
        }

void Deveel.Data.Sql.Objects.SqlStringTests.String_Concat ( )

inline

Definition at line 55 of file SqlStringTests.cs.

                                    {
            const string s1 = "First string comes before the ";
            const string s2 = "Second string that comes after";
            var sqlString1 = new SqlString(s1);
            var sqlString2 = new SqlString(s2);

            var sqlString3 = new SqlString();
            Assert.DoesNotThrow(() => sqlString3 = sqlString1.Concat(sqlString2));
            Assert.AreEqual("First string comes before the Second string that comes after", sqlString3.ToString(Encoding.UTF8));
        }

void Deveel.Data.Sql.Objects.SqlStringTests.String_Convert_BigNumber ( )

inline

Definition at line 136 of file SqlStringTests.cs.

                                               {
            const string s = "7689994.0000033992988477226661525553666370058812345883288477383";
            var sqlString = new SqlString(s);

            var number = new SqlNumber();
            Assert.DoesNotThrow(() => number = (SqlNumber)Convert.ChangeType(sqlString, typeof(SqlNumber)));
            Assert.IsFalse(number.IsNull);
            Assert.IsFalse(number.CanBeInt32);
            Assert.IsFalse(number.CanBeInt64);
            Assert.AreEqual(NumericState.None, number.State);
        }

void Deveel.Data.Sql.Objects.SqlStringTests.String_Convert_BooleanFalse ( )

inline

Definition at line 164 of file SqlStringTests.cs.

                                                  {
            const string s = "false";
            var sqlString = new SqlString(s);

            var b = new SqlBoolean();
            Assert.DoesNotThrow(() => b = (SqlBoolean)Convert.ChangeType(sqlString, typeof(SqlBoolean)));
            Assert.IsFalse(b.IsNull);
            Assert.AreEqual(SqlBoolean.False, b);
        }

void Deveel.Data.Sql.Objects.SqlStringTests.String_Convert_BooleanNull ( )

inline

Definition at line 177 of file SqlStringTests.cs.

                                                 {
            const string s = "";
            var sqlString = new SqlString(s);

            var b = new SqlBoolean();
            Assert.DoesNotThrow(() => b = (SqlBoolean)Convert.ChangeType(sqlString, typeof(SqlBoolean)));
            Assert.IsTrue(b.IsNull);
            Assert.AreEqual(SqlBoolean.Null, b);
        }

void Deveel.Data.Sql.Objects.SqlStringTests.String_Convert_BooleanTrue ( )

inline

Definition at line 151 of file SqlStringTests.cs.

                                                 {
            const string s = "true";
            var sqlString = new SqlString(s);

            var b = new SqlBoolean();
            Assert.DoesNotThrow(() => b = (SqlBoolean)Convert.ChangeType(sqlString, typeof(SqlBoolean)));
            Assert.IsFalse(b.IsNull);
            Assert.AreEqual(SqlBoolean.True, b);
        }

void Deveel.Data.Sql.Objects.SqlStringTests.String_Convert_Date ( )

inline

Definition at line 116 of file SqlStringTests.cs.

                                          {
            const string s = "2011-01-23";
            var sqlString = new SqlString(s);

            var date = new SqlDateTime();
            Assert.DoesNotThrow(() => date = (SqlDateTime) Convert.ChangeType(sqlString, typeof(SqlDateTime)));
            Assert.IsFalse(date.IsNull);
            Assert.AreEqual(2011, date.Year);
            Assert.AreEqual(01, date.Month);
            Assert.AreEqual(23, date.Day);
            Assert.AreEqual(0, date.Hour);
            Assert.AreEqual(0, date.Minute);
            Assert.AreEqual(0, date.Millisecond);
            Assert.AreEqual(0, date.Offset.Hours);
            Assert.AreEqual(0, date.Offset.Minutes);            
        }

void Deveel.Data.Sql.Objects.SqlStringTests.String_Convert_Time ( )

inline

Definition at line 97 of file SqlStringTests.cs.

                                          {
            const string s = "23:44:21.525";
            var sqlString = new SqlString(s);

            var time = new SqlDateTime();
            Assert.DoesNotThrow(() => time = (SqlDateTime) Convert.ChangeType(sqlString, typeof(SqlDateTime)));
            Assert.IsFalse(time.IsNull);
            Assert.AreEqual(1, time.Year);
            Assert.AreEqual(1, time.Month);
            Assert.AreEqual(1, time.Day);
            Assert.AreEqual(23, time.Hour);
            Assert.AreEqual(44, time.Minute);
            Assert.AreEqual(21, time.Second);
            Assert.AreEqual(525, time.Millisecond);
        }

void Deveel.Data.Sql.Objects.SqlStringTests.String_Convert_TimeStamp ( )

inline

Definition at line 77 of file SqlStringTests.cs.

                                               {
            const string s = "2011-01-23T23:44:21.525 +01:00";
            var sqlString = new SqlString(s);

            var timeStamp = new SqlDateTime();
            Assert.DoesNotThrow(() => timeStamp = (SqlDateTime) Convert.ChangeType(sqlString, typeof(SqlDateTime)));
            Assert.IsFalse(timeStamp.IsNull);
            Assert.AreEqual(2011, timeStamp.Year);
            Assert.AreEqual(01, timeStamp.Month);
            Assert.AreEqual(23, timeStamp.Day);
            Assert.AreEqual(23, timeStamp.Hour);
            Assert.AreEqual(44, timeStamp.Minute);
            Assert.AreEqual(525, timeStamp.Millisecond);
            Assert.AreEqual(1, timeStamp.Offset.Hours);
            Assert.AreEqual(0, timeStamp.Offset.Minutes);
        }

void Deveel.Data.Sql.Objects.SqlStringTests.String_Create ( )

inline

Definition at line 27 of file SqlStringTests.cs.

                                    {
            const string s = "Test string UTF-16 LE";
            var sqlString = new SqlString(s);
            Assert.IsNotNull(sqlString);
            Assert.AreEqual(s.Length, sqlString.Length);
            Assert.AreEqual(s, sqlString);
        }

void Deveel.Data.Sql.Objects.SqlStringTests.String_Equals ( )

inline

Definition at line 46 of file SqlStringTests.cs.

                                    {
            const string s = "Test string in UTF-16 LE";
            var sqlString1 = new SqlString(s);
            var sqlString2 = new SqlString(s);
            Assert.IsTrue(sqlString1.Equals(sqlString2));
        }

void Deveel.Data.Sql.Objects.SqlStringTests.String_EqualsToNull ( )

inline

Definition at line 67 of file SqlStringTests.cs.

                                          {
            var s = SqlString.Null;
            Assert.IsTrue(s.IsNull);
            Assert.AreEqual(SqlNull.Value, s);
            Assert.AreEqual(s, SqlNull.Value);
        }

---

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/SqlStringTests.cs