Deveel.Data.Types.DateType Class Reference

Inheritance diagram for Deveel.Data.Types.DateType:

Public Member Functions
	DateType (SqlTypeCode typeCode)
override bool	IsCacheable (ISqlObject value)
override Type	GetObjectType ()
override Type	GetRuntimeType ()
override bool	Equals (object obj)
override int	GetHashCode ()
override bool	IsComparable (SqlType type)
	Verifies if a given SqlType is comparable to this data-type. More...
override bool	CanCastTo (SqlType destType)
	Verifies if this type can cast any value to the given SqlType. More...
override DataObject	CastTo (DataObject value, SqlType destType)
	Converts the given object value to a SqlType specified. More...
override void	SerializeObject (Stream stream, ISqlObject obj)
override ISqlObject	DeserializeObject (Stream stream)
Public Member Functions inherited from Deveel.Data.Types.SqlType
virtual object	ConvertTo (ISqlObject obj, Type destType)
virtual ISqlObject	Add (ISqlObject a, ISqlObject b)
virtual ISqlObject	Subtract (ISqlObject a, ISqlObject b)
virtual ISqlObject	Multiply (ISqlObject a, ISqlObject b)
virtual ISqlObject	Divide (ISqlObject a, ISqlObject b)
virtual ISqlObject	Modulus (ISqlObject a, ISqlObject b)
virtual ISqlObject	Negate (ISqlObject value)
virtual SqlBoolean	IsEqualTo (ISqlObject a, ISqlObject b)
virtual SqlBoolean	IsNotEqualTo (ISqlObject a, ISqlObject b)
virtual SqlBoolean	IsGreatherThan (ISqlObject a, ISqlObject b)
virtual SqlBoolean	IsSmallerThan (ISqlObject a, ISqlObject b)
virtual SqlBoolean	IsGreaterOrEqualThan (ISqlObject a, ISqlObject b)
virtual SqlBoolean	IsSmallerOrEqualThan (ISqlObject a, ISqlObject b)
virtual ISqlObject	And (ISqlObject a, ISqlObject b)
virtual ISqlObject	Or (ISqlObject a, ISqlObject b)
virtual ISqlObject	XOr (ISqlObject x, ISqlObject y)
virtual ISqlObject	UnaryPlus (ISqlObject value)
virtual ISqlObject	Reverse (ISqlObject value)
virtual SqlType	Wider (SqlType otherType)
	Gets the one data-type between this and the other one given that handles the wider range of values. More...
virtual int	Compare (ISqlObject x, ISqlObject y)
override bool	Equals (object obj)
override int	GetHashCode ()
virtual bool	Equals (SqlType other)
override string	ToString ()
virtual ISqlObject	CreateFromLargeObject (ILargeObject objRef)
virtual ISqlObject	CreateFrom (object value)

Static Public Attributes
static readonly string[]	DateFormatSql
static readonly string[]	TimeFormatSql
static readonly string[]	TsFormatSql

Package Functions
override int	ColumnSizeOf (ISqlObject obj)
Package Functions inherited from Deveel.Data.Types.SqlType
virtual int	GetCacheUsage (ISqlObject value)

Static Package Functions
static bool	IsDateType (SqlTypeCode sqlType)

Properties
override bool	IsStorable [get]
Properties inherited from Deveel.Data.Types.SqlType
string	Name [get, private set]
	Gets the name of the data-type that is used to resolve it within the context. More...
SqlTypeCode	TypeCode [get, private set]
	Gets the kind of SQL type this data-type handles. More...
virtual bool	IsIndexable [get]
	Indicates if the values handled by the type can be part of an index. More...
bool	IsPrimitive [get]
	Gets a value indicating if this data-type is primitive. More...
bool	IsNull [get]
virtual bool	IsStorable [get]

Private Member Functions
SqlString	ToString (SqlDateTime dateTime)

Static Private Member Functions
static void	AssertDateType (SqlTypeCode sqlType)
static SqlDateTime	ToTime (SqlDateTime dateTime)
static SqlDateTime	ToDate (SqlDateTime dateTime)

Additional Inherited Members
Static Public Member Functions inherited from Deveel.Data.Types.SqlType
static SqlType	Parse (string s)
	Parses a SQL formatted string that defines a data-type into a constructed SqlType object equivalent. More...
static SqlType	Parse (IContext context, string s)
	Parses a SQL formatted string that defines a data-type into a constructed SqlType object equivalent. More...
static bool	IsPrimitiveType (SqlTypeCode typeCode)
static SqlType	Resolve (SqlTypeCode typeCode)
static SqlType	Resolve (SqlTypeCode typeCode, DataTypeMeta[] meta)
static SqlType	Resolve (SqlTypeCode typeCode, DataTypeMeta[] meta, ITypeResolver resolver)
static SqlType	Resolve (SqlTypeCode typeCode, string name)
static SqlType	Resolve (SqlTypeCode typeCode, string name, DataTypeMeta[] meta)
static SqlType	Resolve (string name)
static SqlType	Resolve (string name, DataTypeMeta[] meta)
static SqlType	Resolve (string name, DataTypeMeta[] meta, ITypeResolver resolver)
static SqlType	Resolve (SqlTypeCode typeCode, string name, DataTypeMeta[] meta, ITypeResolver resolver)
Protected Member Functions inherited from Deveel.Data.Types.SqlType
	SqlType (SqlTypeCode sqlType)
	Constructs the SqlType for the given specific SQL TYPE. More...
	SqlType (string name, SqlTypeCode typeCode)
	Constructs the SqlType for the given specific SQL TYPE and a given name. More...
	SqlType (ObjectData data)
virtual void	GetData (SerializeData data)

Detailed Description

Definition at line 23 of file DateType.cs.

Constructor & Destructor Documentation

Deveel.Data.Types.DateType.DateType ( SqlTypeCode  typeCode )

inline

Definition at line 24 of file DateType.cs.

            : base("DATE", typeCode) {
            AssertDateType(typeCode);
        }

Member Function Documentation

static void Deveel.Data.Types.DateType.AssertDateType ( SqlTypeCode  sqlType )

inlinestaticprivate

Definition at line 66 of file DateType.cs.

                                                                {
            if (!IsDateType(sqlType))
                throw new ArgumentException(String.Format("The SQL type {0} is not a valid DATE", sqlType), "sqlType");
        }

override bool Deveel.Data.Types.DateType.CanCastTo ( SqlType  destType )

inlinevirtual

Verifies if this type can cast any value to the given SqlType.

Parameters

destType

The other type, destination of the cast, to verify.

By default, this method returns false, because cast process must be specified per type: when overriding the method CastTo, pay attention to also override this method accordingly.

Returns

CastTo

Reimplemented from Deveel.Data.Types.SqlType.

Definition at line 103 of file DateType.cs.

                                                         {
            return destType is StringType || destType is DateType;
        }

override DataObject Deveel.Data.Types.DateType.CastTo ( DataObject  value, SqlType  destType  )

inlinevirtual

Converts the given object value to a SqlType specified.

Parameters

value	The value to convert.
destType	The destination type of the conversion.

If the given destType destination type is equivalent to this type, it will return the value provided, otherwise it will throw an exception by default.

Casting values to specific types is specific to each data-type: override this method to support type-specific conversions.

When overriding this method, CanCastTo should be overridden accordingly to indicate the type supports casting.

Returns

Returns an instance of DataObject that is the result of the conversion from this data-type to the other type given.

Reimplemented from Deveel.Data.Types.SqlType.

Definition at line 129 of file DateType.cs.

                                                                              {
            if (destType == null)
                throw new ArgumentNullException("destType");

            var date = (SqlDateTime) value.Value;
            var sqlType = destType.TypeCode;

            ISqlObject casted;

            switch (sqlType) {
                case SqlTypeCode.String:
                case SqlTypeCode.VarChar:
                    casted = ToString(date);
                    break;
                case SqlTypeCode.Date:
                    casted = ToDate(date);
                    break;
                case SqlTypeCode.Time:
                    casted = ToTime(date);
                    break;
                case SqlTypeCode.TimeStamp:
                case SqlTypeCode.DateTime:
                    // if it is not a TimeStamp already, there's not much we can do
                    casted = date;
                    break;
                default:
                    throw new InvalidCastException(String.Format("Cannot cast type '{0}' to '{1}'.",
                        sqlType.ToString().ToUpperInvariant(), TypeCode.ToString().ToUpperInvariant()));
            }

            return new DataObject(destType, casted);
        }

override int Deveel.Data.Types.DateType.ColumnSizeOf ( ISqlObject  obj )

inlinepackagevirtual

Reimplemented from Deveel.Data.Types.SqlType.

Definition at line 182 of file DateType.cs.

                                                           {
            if (obj is SqlNull)
                return 1;

            if (!(obj is SqlDateTime))
                throw new ArgumentException(String.Format("Cannot determine the size of an object of type '{0}'", obj.GetType()));

            if (obj.IsNull)
                return 1;

            // Type + Length + Bytes
            return 1 + 4 + 13;
        }

override ISqlObject Deveel.Data.Types.DateType.DeserializeObject ( Stream  stream )

inlinevirtual

Reimplemented from Deveel.Data.Types.SqlType.

Definition at line 196 of file DateType.cs.

                                                                    {
            var reader = new BinaryReader(stream);

            var type = reader.ReadByte();
            if (type == 0)
                return SqlDateTime.Null;

            var length = reader.ReadInt32();
            var bytes = reader.ReadBytes(length);
            return new SqlDateTime(bytes);
        }

override bool Deveel.Data.Types.DateType.Equals ( object  obj )

inline

Definition at line 87 of file DateType.cs.

                                                {
            var other = obj as SqlType;
            if (other == null)
                return false;

            return TypeCode == other.TypeCode;
        }

override int Deveel.Data.Types.DateType.GetHashCode ( )

inline

Definition at line 95 of file DateType.cs.

                                          {
            return TypeCode.GetHashCode();
        }

override Type Deveel.Data.Types.DateType.GetObjectType ( )

inlinevirtual

Reimplemented from Deveel.Data.Types.SqlType.

Definition at line 79 of file DateType.cs.

                                             {
            return typeof (SqlDateTime);
        }

override Type Deveel.Data.Types.DateType.GetRuntimeType ( )

inlinevirtual

Reimplemented from Deveel.Data.Types.SqlType.

Definition at line 83 of file DateType.cs.

                                              {
            return typeof (DateTimeOffset);
        }

override bool Deveel.Data.Types.DateType.IsCacheable ( ISqlObject  value )

inlinevirtual

Reimplemented from Deveel.Data.Types.SqlType.

Definition at line 75 of file DateType.cs.

                                                           {
            return value is SqlDateTime || value is SqlNull;
        }

override bool Deveel.Data.Types.DateType.IsComparable ( SqlType  type )

inlinevirtual

Verifies if a given SqlType is comparable to this data-type.

Parameters

type	The other data-type to verify the compatibility.

It is not required two SqlType to be identical to be compared: when overridden by a derived class, this methods verifies the properties of the argument type, to see if values handled by the types can be compared.

By default, this method compares the values returned by TypeCode to see if they are identical.

Returns

Returns true if the values handled by this data-type can be compared to ones handled by the given type , or false otherwise.

Reimplemented from Deveel.Data.Types.SqlType.

Definition at line 99 of file DateType.cs.

                                                        {
            return type is DateType;
        }

static bool Deveel.Data.Types.DateType.IsDateType ( SqlTypeCode  sqlType )

inlinestaticpackage

Definition at line 208 of file DateType.cs.

                                                             {
            return sqlType == SqlTypeCode.Date ||
                   sqlType == SqlTypeCode.Time ||
                   sqlType == SqlTypeCode.TimeStamp ||
                   sqlType == SqlTypeCode.DateTime;
        }

override void Deveel.Data.Types.DateType.SerializeObject ( Stream  stream, ISqlObject  obj  )

inlinevirtual

Reimplemented from Deveel.Data.Types.SqlType.

Definition at line 162 of file DateType.cs.

                                                                            {
            var writer = new BinaryWriter(stream);

            if (obj is SqlNull) {
                writer.Write((byte) 0);
            } else {
                var date = (SqlDateTime) obj;

                if (date.IsNull) {
                    writer.Write((byte)0);
                } else {
                    var bytes = date.ToByteArray(true);

                    writer.Write((byte)1);
                    writer.Write(bytes.Length);
                    writer.Write(bytes);
                }
            }
        }

static SqlDateTime Deveel.Data.Types.DateType.ToDate ( SqlDateTime  dateTime )

inlinestaticprivate

Definition at line 125 of file DateType.cs.

                                                                {
            return new SqlDateTime(dateTime.Year, dateTime.Month, dateTime.Day, 0, 0, 0, 0, dateTime.Offset);
        }

SqlString Deveel.Data.Types.DateType.ToString ( SqlDateTime  dateTime )

inlineprivate

Definition at line 107 of file DateType.cs.

                                                         {
            if (dateTime.IsNull)
                return SqlString.Null;

            if (TypeCode == SqlTypeCode.Date)
                return dateTime.ToDateString();
            if (TypeCode == SqlTypeCode.Time)
                return dateTime.ToTimeString();
            if (TypeCode == SqlTypeCode.TimeStamp)
                return dateTime.ToTimeStampString();

            return SqlString.Null;
        }

static SqlDateTime Deveel.Data.Types.DateType.ToTime ( SqlDateTime  dateTime )

inlinestaticprivate

Definition at line 121 of file DateType.cs.

                                                                {
            return new SqlDateTime(0, 0, 0, dateTime.Hour, dateTime.Minute, dateTime.Second, dateTime.Millisecond, dateTime.Offset);
        }

Member Data Documentation

readonly string [] Deveel.Data.Types.DateType.DateFormatSql

static

Initial value:

= {
            "yyyy-MM-dd",
            "yyyy MM dd"
        }

Definition at line 29 of file DateType.cs.

readonly string [] Deveel.Data.Types.DateType.TimeFormatSql

static

Initial value:

= {
            "HH:mm:ss.fff z",
            "HH:mm:ss.fff zz",
            "HH:mm:ss.fff zzz",
            "HH:mm:ss.fff",
            "HH:mm:ss z",
            "HH:mm:ss zz",
            "HH:mm:ss zzz",
            "HH:mm:ss"
        }

Definition at line 34 of file DateType.cs.

readonly string [] Deveel.Data.Types.DateType.TsFormatSql

static

Initial value:

= {
            "yyyy-MM-dd HH:mm:ss.fff",
            "yyyy-MM-dd HH:mm:ss.fff z",
            "yyyy-MM-dd HH:mm:ss.fff zz",
            "yyyy-MM-dd HH:mm:ss.fff zzz",
            "yyyy-MM-dd HH:mm:ss",
            "yyyy-MM-dd HH:mm:ss z",
            "yyyy-MM-dd HH:mm:ss zz",
            "yyyy-MM-dd HH:mm:ss zzz",

            "yyyy-MM-ddTHH:mm:ss.fff",
            "yyyy-MM-ddTHH:mm:ss.fff z",
            "yyyy-MM-ddTHH:mm:ss.fff zz",
            "yyyy-MM-ddTHH:mm:ss.fff zzz",
            "yyyy-MM-ddTHH:mm:ss",
            "yyyy-MM-ddTHH:mm:ss z",
            "yyyy-MM-ddTHH:mm:ss zz",
            "yyyy-MM-ddTHH:mm:ss zzz",
        }

Definition at line 45 of file DateType.cs.

Property Documentation

override bool Deveel.Data.Types.DateType.IsStorable

get

Definition at line 71 of file DateType.cs.

---

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

• /var/calculate/remote/distfiles/egit-src/deveeldb.git/src/deveeldb/Deveel.Data.Types/DateType.cs