Deveel.Data.Routines Namespace Reference

Classes
class	AggregateFunction
class	ExternalFunction
class	ExternalRoutineInfo
class	Function
	A system routine that returns a value at the end of its execution. More...
class	FunctionBuildTests
class	FunctionExtensions
	Extension methods to any IFunction. More...
class	FunctionInfo
	The function signature information that are used to resolve a function within a context. More...
class	FunctionProvider
interface	IFunction
	Defines a routine that is a function, that means it returns a value after its execution. More...
class	ImportedKey
class	Invoke
	The information about the invocation of a routine, including the full name and arguments (as SqlExpression). More...
class	InvokeContext
	Encapsulates the More...
class	InvokeResult
	Represents the result of the execution of a routine. More...
interface	IProcedure
	A specific kind of routine that does not return any value when executed. More...
interface	IRoutine
	The contract to define a program routine that can interact with database objects. More...
interface	IRoutineProvider
interface	IRoutineResolver
	The system uses instances of this interface to resolve routines given a user invocation. More...
interface	IRoutineResolverContainer
class	PlSqlFunction
class	ProcedureInfo
class	Query
class	QueryContextExtensions
class	RoutineExtensions
class	RoutineInfo
	Defines the metadata for a routine that are used to resolve within a context. More...
class	RoutineManager
class	RoutineNotFouncException
class	RoutineParameter
class	RoutineResolverExtensions
	Extension methods to any IRoutineResolver More...
class	SystemContextExtensions
class	SystemFunctions
class	SystemFunctionsProvider
class	SystemFunctionTests
class	SystemProcedureProvider
class	SystemProcedures
class	UserFunction
class	UserSessionExtensions

Enumerations
enum	FunctionType {   FunctionType.Static = 1, FunctionType.Aggregate = 2, FunctionType.StateBased = 3, FunctionType.UserDefined = 4,   FunctionType.External = 5 }
	The different type of a function. More...
enum	ParameterAttributes { ParameterAttributes.None = 0x00, ParameterAttributes.Nullable = 0x01, ParameterAttributes.Unbounded = 0x02 }
enum	ParameterDirection { ParameterDirection.Input = 0x01, ParameterDirection.Output = 0x02, ParameterDirection.InputOutput = Input | Output }
	The possible directions of a procedure parameter. More...
enum	ProcedureType { ProcedureType.Static = 1, ProcedureType.UserDefined = 2, ProcedureType.External = 3 }
	The form of a database stored PROCEDURE. More...
enum	RoutineType { RoutineType.Function = 1, RoutineType.Procedure = 2 }
	The type of routine program. More...

Enumeration Type Documentation

enum Deveel.Data.Routines.FunctionType

strong

The different type of a function.

Enumerator
Static	A type that represents a static function. A static function is not an aggregate therefore does not require a IGroupResolver. The result of a static function is guaranteed the same given identical parameters over subsequent calls.
Aggregate	A type that represents an aggregate function. An aggregate function requires the IGroupResolver variable to be present in able to resolve the function over some set. The result of an aggregate function is guaranteed the same given the same set and identical parameters.
StateBased	A function that is non-aggregate but whose return value is not guaranteed to be the same given the identical parameters over subsequent calls. This would include functions such as RANDOM and UNIQUEKEY. The result is dependent on some other state (a random seed and a sequence value).
UserDefined
External

Definition at line 25 of file FunctionType.cs.

                             {
        Static = 1,

        Aggregate = 2,

        StateBased = 3,

        UserDefined = 4,
        External = 5
    }

enum Deveel.Data.Routines.ParameterAttributes

strong

Enumerator
None
Nullable
Unbounded

Definition at line 21 of file ParameterAttributes.cs.

                                    {
        None = 0x00,
        Nullable = 0x01,
        Unbounded = 0x02
    }

enum Deveel.Data.Routines.ParameterDirection

strong

The possible directions of a procedure parameter.

Enumerator
Input	The parameter provides an input value to the procedure, but won't be able to output a value eventually set.
Output	The parameter will not provide any input value, and will output a value set during the execution of the procedure.
InputOutput	The parameter will provide an input value and will return an output value set during the execution of the procedure.

Definition at line 24 of file ParameterDirection.cs.

                                   {
        Input = 0x01,

        Output = 0x02,

        InputOutput = Input | Output
    }

enum Deveel.Data.Routines.ProcedureType

strong

The form of a database stored PROCEDURE.

Enumerator
Static	A procedure that requires no state to be executed.
UserDefined	A stored procedure defined by a user.
External	An external program that is only referenced by the procedure information.

Definition at line 23 of file ProcedureType.cs.

                              {
        Static = 1,

        UserDefined = 2,

        External = 3
    }

enum Deveel.Data.Routines.RoutineType

strong

The type of routine program.

Enumerator
Function	A program that takes an optional set of arguments and returns a single value as result of the operation.
Procedure	A program that takes a fixed set of arguments and computes an operation, without returning any value.

Definition at line 23 of file RoutineType.cs.

                            {
        Function = 1,

        Procedure = 2
    }