Deveel.Data.Routines.RoutineManager Class Reference

Inheritance diagram for Deveel.Data.Routines.RoutineManager:

Classes
class	RoutinesTableContainer

Public Member Functions
	RoutineManager (ITransaction transaction)
void	Dispose ()
void	Create ()
	Initializes the manager into the underlying system. More...
void	CreateRoutine (RoutineInfo routineInfo)
bool	RoutineExists (ObjectName objName)
IRoutine	GetRoutine (ObjectName routineName)
bool	AlterRoutine (RoutineInfo routineInfo)
bool	DropRoutine (ObjectName objName)
ObjectName	ResolveName (ObjectName objName, bool ignoreCase)
	Normalizes the input object name using the case sensitivity specified. More...
IRoutine	ResolveRoutine (Invoke request, IQuery context)
	Resolves a routine that matches the given invocation within the context provided. More...

Properties
DbObjectType IObjectManager.	ObjectType [get]
Properties inherited from Deveel.Data.Sql.IObjectManager
DbObjectType	ObjectType [get]
	Gets the type of objects managed by this instance. More...

Private Member Functions
ITable	FindEntry (Table table, ObjectName routineName)
void IObjectManager.	CreateObject (IObjectInfo objInfo)
	Create a new object of the ObjectType given the specifications given. More...
bool IObjectManager.	RealObjectExists (ObjectName objName)
	Checks if an object really exists in the system. More...
bool IObjectManager.	ObjectExists (ObjectName objName)
	Checks if an object identified by the given name is managed by this instance. More...
IDbObject IObjectManager.	GetObject (ObjectName objName)
	Gets a database object managed by this manager. More...
bool IObjectManager.	AlterObject (IObjectInfo objInfo)
	Modifies an existing object managed, identified by IObjectInfo.FullName component of the given specification, with the format given. More...
bool IObjectManager.	DropObject (ObjectName objName)
	Deletes a database object handled by this manager from the system. More...

Private Attributes
const string	ProcedureType = "procedure"
const string	ExternalProcedureType = "ext_procedure"
const string	FunctionType = "function"
const string	ExtrernalFunctionType = "ext_function"
ITransaction	transaction

Detailed Description

Definition at line 29 of file RoutineManager.cs.

Constructor & Destructor Documentation

Deveel.Data.Routines.RoutineManager.RoutineManager ( ITransaction  transaction )

inline

Definition at line 37 of file RoutineManager.cs.

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

            this.transaction = transaction;
        }

Member Function Documentation

bool IObjectManager. Deveel.Data.Routines.RoutineManager.AlterObject ( IObjectInfo  objInfo )

inlineprivate

Modifies an existing object managed, identified by IObjectInfo.FullName component of the given specification, with the format given.

Parameters

objInfo

The object specification used to alter an existing object.

Returns

Returns true an object was identified and successfully altered, or false if none database object was found for the unique name given.

Exceptions

ArgumentNullException	If the given objInfo object is null.
ArgumentException	If the type of the object specified (IObjectInfo.ObjectType) is different than the type of objects handled by this manager.

Implements Deveel.Data.Sql.IObjectManager.

Definition at line 141 of file RoutineManager.cs.

                                                             {
            var routineInfo = objInfo as RoutineInfo;
            if (routineInfo == null)
                throw new ArgumentException();

            return AlterRoutine(routineInfo);
        }

bool Deveel.Data.Routines.RoutineManager.AlterRoutine ( RoutineInfo  routineInfo )

inline

Definition at line 153 of file RoutineManager.cs.

                                                          {
            // TODO: implement
            return false;
        }

void Deveel.Data.Routines.RoutineManager.Create ( )

inline

Initializes the manager into the underlying system.

Typically this method generates the tables required to manage the features relative to the objects.

Implements Deveel.Data.Sql.IObjectManager.

Definition at line 74 of file RoutineManager.cs.

                             {
            // SYSTEM.ROUTINE
            var tableInfo = new TableInfo(SystemSchema.RoutineTableName);
            tableInfo.AddColumn("schema", PrimitiveTypes.String());
            tableInfo.AddColumn("name", PrimitiveTypes.String());
            tableInfo.AddColumn("type", PrimitiveTypes.String());
            tableInfo.AddColumn("location", PrimitiveTypes.String());
            tableInfo.AddColumn("return_type", PrimitiveTypes.String());
            tableInfo.AddColumn("username", PrimitiveTypes.String());
            transaction.CreateTable(tableInfo);

            // SYSTEM.ROUTINE_PARAM
            tableInfo = new TableInfo(SystemSchema.RoutineParameterTableName);
            tableInfo.AddColumn("schema", PrimitiveTypes.String());
            tableInfo.AddColumn("name", PrimitiveTypes.String());
            tableInfo.AddColumn("arg_name", PrimitiveTypes.String());
            tableInfo.AddColumn("arg_type", PrimitiveTypes.String());
            tableInfo.AddColumn("in_out", PrimitiveTypes.String());
            tableInfo.AddColumn("offset", PrimitiveTypes.Integer());
            transaction.CreateTable(tableInfo);

            var fkCol = new[] {"routine_schema", "routine_name"};
            var refCol = new[] {"schema", "name"};
            const ForeignKeyAction onUpdate = ForeignKeyAction.NoAction;
            const ForeignKeyAction onDelete = ForeignKeyAction.Cascade;

            transaction.AddForeignKey(SystemSchema.RoutineParameterTableName, fkCol, SystemSchema.RoutineTableName, refCol,
                onDelete, onUpdate, "ROUTINE_PARAMS_FK");
        }

void IObjectManager. Deveel.Data.Routines.RoutineManager.CreateObject ( IObjectInfo  objInfo )

inlineprivate

Create a new object of the ObjectType given the specifications given.

Parameters

objInfo

The object specifications used to create a new object.

Exceptions

ArgumentNullException	If the given objInfo is null.
ArgumentException	If the object type of the specification (IObjectInfo.ObjectType) is different than the ObjectType of this manager.

Implements Deveel.Data.Sql.IObjectManager.

Definition at line 104 of file RoutineManager.cs.

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

            var routineInfo = objInfo as RoutineInfo;
            if (routineInfo == null)
                throw new ArgumentException();

            CreateRoutine(routineInfo);
        }

void Deveel.Data.Routines.RoutineManager.CreateRoutine ( RoutineInfo  routineInfo )

inline

Definition at line 115 of file RoutineManager.cs.

                                                           {
            throw new NotImplementedException();
        }

void Deveel.Data.Routines.RoutineManager.Dispose ( )

inline

Definition at line 66 of file RoutineManager.cs.

                              {
            transaction = null;
        }

bool IObjectManager. Deveel.Data.Routines.RoutineManager.DropObject ( ObjectName  objName )

inlineprivate

Deletes a database object handled by this manager from the system.

Parameters

objName

The unique name of the object to be deleted.

Returns

Returns true if a database object was found with the given unique name and successfully deleted from the system, or false if none object was found.

Implements Deveel.Data.Sql.IObjectManager.

Definition at line 149 of file RoutineManager.cs.

                                                           {
            return DropRoutine(objName);
        }

bool Deveel.Data.Routines.RoutineManager.DropRoutine ( ObjectName  objName )

inline

Definition at line 158 of file RoutineManager.cs.

                                                    {
            // TODO: implement
            return false;
        }

ITable Deveel.Data.Routines.RoutineManager.FindEntry ( Table  table, ObjectName  routineName  )

inlineprivate

Definition at line 44 of file RoutineManager.cs.

                                                                      {
            var schemav = table.GetResolvedColumnName(0);
            var namev = table.GetResolvedColumnName(1);

            using (var session = new SystemSession(transaction)) {
                using (var context = session.CreateQuery()) {
                    var t = table.SimpleSelect(context, namev, SqlExpressionType.Equal,
                        SqlExpression.Constant(DataObject.String(routineName.Name)));
                    t = t.ExhaustiveSelect(context,
                        SqlExpression.Equal(SqlExpression.Reference(schemav),
                            SqlExpression.Constant(DataObject.String(routineName.ParentName))));

                    // This should be at most 1 row in size
                    if (t.RowCount > 1)
                        throw new Exception("Assert failed: multiple procedure names for " + routineName);

                    // Return the entries found.
                    return t;
                }
            }
        }

IDbObject IObjectManager. Deveel.Data.Routines.RoutineManager.GetObject ( ObjectName  objName )

inlineprivate

Gets a database object managed by this manager.

Parameters

objName

The name that uniquely identifies the object to get.

Returns

Returns a IDbObject instance that is identified by the given unique name, or null if this manager was not able to map any object to the name specified.

Implements Deveel.Data.Sql.IObjectManager.

Definition at line 132 of file RoutineManager.cs.

                                                               {
            return GetRoutine(objName);
        }

IRoutine Deveel.Data.Routines.RoutineManager.GetRoutine ( ObjectName  routineName )

inline

Definition at line 136 of file RoutineManager.cs.

                                                           {
            // TODO: implement!
            return null;
        }

bool IObjectManager. Deveel.Data.Routines.RoutineManager.ObjectExists ( ObjectName  objName )

inlineprivate

Checks if an object identified by the given name is managed by this instance.

Parameters

objName

The name that uniquely identifies the object.

Returns

Implements Deveel.Data.Sql.IObjectManager.

Definition at line 123 of file RoutineManager.cs.

                                                             {
            return RoutineExists(objName);
        }

bool IObjectManager. Deveel.Data.Routines.RoutineManager.RealObjectExists ( ObjectName  objName )

inlineprivate

Checks if an object really exists in the system.

Parameters

objName

The unique name of the object to check.

Returns

Returns true if an object with the given name concretely exists in the system, or false otherwise.

Implements Deveel.Data.Sql.IObjectManager.

Definition at line 119 of file RoutineManager.cs.

                                                                 {
            return RoutineExists(objName);
        }

ObjectName Deveel.Data.Routines.RoutineManager.ResolveName ( ObjectName  objName, bool  ignoreCase  )

inline

Normalizes the input object name using the case sensitivity specified.

Parameters

objName	The input object name, that can be partial or complete, to be normalized to the real name of an object.
ignoreCase	The case sensitivity specification used to compare the input name with the names of the existing objects handled by this manager.

Returns

Returns the fully normalized ObjectName that is the real name of an object matching the input name, or null if the input name was not possible to be resolved.

Implements Deveel.Data.Sql.IObjectManager.

Definition at line 163 of file RoutineManager.cs.

                                                                           {
            throw new NotImplementedException();
        }

IRoutine Deveel.Data.Routines.RoutineManager.ResolveRoutine ( Invoke  request, IQuery  query  )

inline

Resolves a routine that matches the given invocation within the context provided.

Parameters

request	The routine invocation request used to resolve the routine.
query	The parent query context.

Returns

Returns an instance of IRoutine that matches the given request, or null if no routine was found in the underlying context.

Implements Deveel.Data.Routines.IRoutineResolver.

Definition at line 167 of file RoutineManager.cs.

                                                                       {
            // TODO: implement
            return null;
        }

bool Deveel.Data.Routines.RoutineManager.RoutineExists ( ObjectName  objName )

inline

Definition at line 127 of file RoutineManager.cs.

                                                      {
            // TODO: implement
            return false;
        }

Member Data Documentation

const string Deveel.Data.Routines.RoutineManager.ExternalProcedureType = "ext_procedure"

private

Definition at line 31 of file RoutineManager.cs.

const string Deveel.Data.Routines.RoutineManager.ExtrernalFunctionType = "ext_function"

private

Definition at line 33 of file RoutineManager.cs.

const string Deveel.Data.Routines.RoutineManager.FunctionType = "function"

private

Definition at line 32 of file RoutineManager.cs.

const string Deveel.Data.Routines.RoutineManager.ProcedureType = "procedure"

private

Definition at line 30 of file RoutineManager.cs.

ITransaction Deveel.Data.Routines.RoutineManager.transaction

private

Definition at line 35 of file RoutineManager.cs.

Property Documentation

DbObjectType IObjectManager. Deveel.Data.Routines.RoutineManager.ObjectType

getprivate

Definition at line 70 of file RoutineManager.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/RoutineManager.cs