Deveel.Data.Routines.SystemFunctions Class Reference

Static Public Member Functions
static DataObject	Or (DataObject ob1, DataObject ob2)
static DataObject	User (IRequest query)
static DataObject	ToDate (DataObject obj)
static DataObject	ToDate (SqlString value)
static DataObject	ToDateTime (DataObject obj)
static DataObject	ToDateTime (SqlString value)
static DataObject	ToTimeStamp (DataObject obj)
static DataObject	ToTimeStamp (SqlString value)
static DataObject	Cast (DataObject value, SqlType destType)
static DataObject	Cast (IQuery query, DataObject value, SqlString typeString)
static DataObject	ToNumber (DataObject value)
static DataObject	ToString (DataObject value)
static DataObject	ToBinary (DataObject value)
static DataObject	UniqueKey (IRequest query, DataObject tableName)
static SqlNumber	UniqueKey (IRequest query, SqlString tableName)
static DataObject	CurrentValue (IRequest query, DataObject tableName)
static SqlNumber	CurrentValue (IRequest query, SqlString tableName)

Static Package Functions
static InvokeResult	Iif (InvokeContext context)
static DataObject	FRuleConvert (DataObject obj)

Properties
static FunctionProvider	Provider [get, private set]

Static Private Member Functions
static	SystemFunctions ()

Detailed Description

Definition at line 28 of file SystemFunctions.cs.

Constructor & Destructor Documentation

static Deveel.Data.Routines.SystemFunctions.SystemFunctions ( )

inlinestaticprivate

Definition at line 29 of file SystemFunctions.cs.

                                 {
            Provider = new SystemFunctionsProvider();
        }

Member Function Documentation

static DataObject Deveel.Data.Routines.SystemFunctions.Cast ( DataObject  value, SqlType  destType  )

inlinestatic

Definition at line 68 of file SystemFunctions.cs.

                                                                          {
            return value.CastTo(destType);
        }

static DataObject Deveel.Data.Routines.SystemFunctions.Cast ( IQuery  query, DataObject  value, SqlString  typeString  )

inlinestatic

Definition at line 72 of file SystemFunctions.cs.

                                                                                            {
            var destType = SqlType.Parse(query.Context, typeString.ToString());
            return Cast(value, destType);
        }

static DataObject Deveel.Data.Routines.SystemFunctions.CurrentValue ( IRequest  query, DataObject  tableName  )

inlinestatic

Definition at line 101 of file SystemFunctions.cs.

                                                                                    {
            var tableNameString = (SqlString)tableName.Value;
            var value = CurrentValue(query, tableNameString);
            return DataObject.Number(value);
        }

static SqlNumber Deveel.Data.Routines.SystemFunctions.CurrentValue ( IRequest  query, SqlString  tableName  )

inlinestatic

Definition at line 107 of file SystemFunctions.cs.

                                                                                  {
            var tableNameString = tableName.ToString();
            var resolvedName = query.Query.ResolveTableName(tableNameString);
            return query.Query.GetCurrentValue(resolvedName);
        }

static DataObject Deveel.Data.Routines.SystemFunctions.FRuleConvert ( DataObject  obj )

inlinestaticpackage

Definition at line 130 of file SystemFunctions.cs.

                                                                {
            if (obj.Type is StringType) {
                String str = null;
                if (!obj.IsNull) {
                    str = obj.Value.ToString();
                }
                int v;
                if (str == null || str.Equals("") || str.Equals("NO ACTION")) {
                    v = ImportedKey.NoAction;
                } else if (str.Equals("CASCADE")) {
                    v = ImportedKey.Cascade;
                } else if (str.Equals("SET NULL")) {
                    v = ImportedKey.SetNull;
                } else if (str.Equals("SET DEFAULT")) {
                    v = ImportedKey.SetDefault;
                } else if (str.Equals("RESTRICT")) {
                    v = ImportedKey.Restrict;
                } else {
                    throw new InvalidOperationException("Unrecognised foreign key rule: " + str);
                }

                // Return the correct enumeration
                return DataObject.Integer(v);
            }
            if (obj.Type is NumericType) {
                var code = ((SqlNumber)obj.AsBigInt().Value).ToInt32();
                string v;
                if (code == (int)ForeignKeyAction.Cascade) {
                    v = "CASCADE";
                } else if (code == (int)ForeignKeyAction.NoAction) {
                    v = "NO ACTION";
                } else if (code == (int)ForeignKeyAction.SetDefault) {
                    v = "SET DEFAULT";
                } else if (code == (int)ForeignKeyAction.SetNull) {
                    v = "SET NULL";
                } else {
                    throw new InvalidOperationException("Unrecognised foreign key rule: " + code);
                }

                return DataObject.String(v);
            }

            throw new InvalidOperationException("Unsupported type in function argument");
        }

static InvokeResult Deveel.Data.Routines.SystemFunctions.Iif ( InvokeContext  context )

inlinestaticpackage

Definition at line 113 of file SystemFunctions.cs.

                                                                {
            var result = DataObject.Null();

            var evalContext = new EvaluateContext(context.Request, context.VariableResolver, context.GroupResolver);

            var condition = context.Arguments[0].EvaluateToConstant(evalContext);
            if (condition.Type is BooleanType) {
                if (condition.Equals(DataObject.BooleanTrue)) {
                    result = context.Arguments[1].EvaluateToConstant(evalContext);
                } else if (condition.Equals(DataObject.BooleanFalse)) {
                    result = context.Arguments[2].EvaluateToConstant(evalContext);
                }
            }

            return context.Result(result);
        }

static DataObject Deveel.Data.Routines.SystemFunctions.Or ( DataObject  ob1, DataObject  ob2  )

inlinestatic

Definition at line 35 of file SystemFunctions.cs.

                                                                    {
            return ob1 != null ? (ob2.IsNull ? ob1 : (!ob1.IsNull ? ob1.Or(ob2) : ob2)) : ob2;
        }

static DataObject Deveel.Data.Routines.SystemFunctions.ToBinary ( DataObject  value )

inlinestatic

Definition at line 85 of file SystemFunctions.cs.

                                                            {
            return value.CastTo(PrimitiveTypes.Binary());
        }

static DataObject Deveel.Data.Routines.SystemFunctions.ToDate ( DataObject  obj )

inlinestatic

Definition at line 44 of file SystemFunctions.cs.

                                                        {
            return obj.CastTo(PrimitiveTypes.Date());
        }

static DataObject Deveel.Data.Routines.SystemFunctions.ToDate ( SqlString  value )

inlinestatic

Definition at line 48 of file SystemFunctions.cs.

                                                         {
            return ToDate(DataObject.String(value));
        }

static DataObject Deveel.Data.Routines.SystemFunctions.ToDateTime ( DataObject  obj )

inlinestatic

Definition at line 52 of file SystemFunctions.cs.

                                                            {
            return obj.CastTo(PrimitiveTypes.DateTime());
        }

static DataObject Deveel.Data.Routines.SystemFunctions.ToDateTime ( SqlString  value )

inlinestatic

Definition at line 56 of file SystemFunctions.cs.

                                                             {
            return ToDateTime(DataObject.String(value));
        }

static DataObject Deveel.Data.Routines.SystemFunctions.ToNumber ( DataObject  value )

inlinestatic

Definition at line 77 of file SystemFunctions.cs.

                                                            {
            return value.CastTo(PrimitiveTypes.Numeric());
        }

static DataObject Deveel.Data.Routines.SystemFunctions.ToString ( DataObject  value )

inlinestatic

Definition at line 81 of file SystemFunctions.cs.

                                                            {
            return value.CastTo(PrimitiveTypes.String());
        }

static DataObject Deveel.Data.Routines.SystemFunctions.ToTimeStamp ( DataObject  obj )

inlinestatic

Definition at line 60 of file SystemFunctions.cs.

                                                             {
            return obj.CastTo(PrimitiveTypes.TimeStamp());
        }

static DataObject Deveel.Data.Routines.SystemFunctions.ToTimeStamp ( SqlString  value )

inlinestatic

Definition at line 64 of file SystemFunctions.cs.

                                                              {
            return ToTimeStamp(DataObject.String(value));
        }

static DataObject Deveel.Data.Routines.SystemFunctions.UniqueKey ( IRequest  query, DataObject  tableName  )

inlinestatic

Definition at line 89 of file SystemFunctions.cs.

                                                                                 {
            var tableNameString = (SqlString)tableName.Value;
            var value = UniqueKey(query, tableNameString);
            return DataObject.Number(value);
        }

static SqlNumber Deveel.Data.Routines.SystemFunctions.UniqueKey ( IRequest  query, SqlString  tableName  )

inlinestatic

Definition at line 95 of file SystemFunctions.cs.

                                                                               {
            var tableNameString = tableName.ToString();
            var resolvedName = query.Query.ResolveTableName(tableNameString);
            return query.Query.GetNextValue(resolvedName);
        }

static DataObject Deveel.Data.Routines.SystemFunctions.User ( IRequest  query )

inlinestatic

Definition at line 39 of file SystemFunctions.cs.

                                                      {
            return DataObject.String(query.User().Name);
        }

Property Documentation

FunctionProvider Deveel.Data.Routines.SystemFunctions.Provider

staticgetprivate set

Definition at line 33 of file SystemFunctions.cs.

---

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

• /var/calculate/remote/distfiles/egit-src/deveeldb.git/src/deveeldb/Deveel.Data.Routines/SystemFunctions.cs