Examples of org.hsqldb_voltpatches.RoutineSchema

org.hsqldb_voltpatches.RoutineSchema
Implementation of SQL procedure and functions @author Fred Toussi (fredt@users dot sourceforge.net) @version 1.9.0 @since 1.9.0


        it = database.schemaManager.databaseObjectIterator(
            SchemaObject.ROUTINE);


        while (it.hasNext()) {
            RoutineSchema routine = (RoutineSchema) it.next();


            if (!session.getGrantee().isAccessible(routine)) {
                continue;
            }


            Routine[] specifics = routine.getSpecificRoutines();


            for (int m = 0; m < specifics.length; m++) {
                OrderedHashSet set = specifics[m].getReferences();


                for (int i = 0; i < set.size(); i++) {
                    HsqlName refName = (HsqlName) set.get(i);


                    if (refName.type != SchemaObject.COLUMN) {
                        continue;
                    }


                    if (!session.getGrantee().isAccessible(refName)) {
                        continue;
                    }


                    row = t.getEmptyRowData();


                    //
                    row[specific_catalog] = database.getCatalogName().name;
                    row[specific_schema]  = specifics[m].getSchemaName().name;
                    row[specific_name]    = specifics[m].getName().name;
                    row[routine_catalog]  = database.getCatalogName().name;
                    row[routine_schema]   = routine.getSchemaName().name;
                    row[routine_name]     = routine.getName().name;
                    row[table_catalog]    = database.getCatalogName().name;
                    row[table_schema]     = refName.parent.schema.name;
                    row[table_name]       = refName.parent.name;
                    row[column_name]      = refName.name;

View Full Code Here

        Grantee granteeObject;
        String  privilege;


        // intermediate holders
        Iterator      routines;
        RoutineSchema routine;
        Object[]      row;
        OrderedHashSet grantees =
            session.getGrantee().getGranteeAndAllRolesWithPublic();


        routines = database.schemaManager.databaseObjectIterator(
            SchemaObject.ROUTINE);


        while (routines.hasNext()) {
            routine = (RoutineSchema) routines.next();


            for (int i = 0; i < grantees.size(); i++) {
                granteeObject = (Grantee) grantees.get(i);


                OrderedHashSet rights =
                    granteeObject.getAllDirectPrivileges(routine);
                OrderedHashSet grants =
                    granteeObject.getAllGrantedPrivileges(routine);


                if (!grants.isEmpty()) {
                    grants.addAll(rights);


                    rights = grants;
                }


                for (int j = 0; j < rights.size(); j++) {
                    Right right          = (Right) rights.get(j);
                    Right grantableRight = right.getGrantableRights();


                    for (int k = 0; k < Right.privilegeTypes.length; k++) {
                        if (!right.canAccess(Right.privilegeTypes[k])) {
                            continue;
                        }


                        Routine[] specifics = routine.getSpecificRoutines();


                        for (int m = 0; m < specifics.length; m++) {
                            privilege = Right.privilegeNames[k];
                            row       = t.getEmptyRowData();


                            //
                            row[grantor] = right.getGrantor().getName().name;
                            row[grantee] = right.getGrantee().getName().name;
                            row[specific_catalog] =
                                database.getCatalogName().name;
                            row[specific_schema] =
                                specifics[m].getSchemaName().name;
                            row[specific_name] = specifics[m].getName().name;
                            row[routine_catalog] =
                                database.getCatalogName().name;
                            row[routine_schema] = routine.getSchemaName().name;
                            row[routine_name]   = routine.getName().name;
                            row[privilege_type] = privilege;
                            row[is_grantable] =
                                right.getGrantee() == routine.getOwner()
                                || grantableRight.canAccess(
                                    Right.privilegeTypes[k]) ? "YES"
                                                             : "NO";


                            try {

View Full Code Here


        it = database.schemaManager.databaseObjectIterator(
            SchemaObject.ROUTINE);


        while (it.hasNext()) {
            RoutineSchema routine = (RoutineSchema) it.next();


            if (!session.getGrantee().isAccessible(routine)) {
                continue;
            }


            Routine[] specifics = routine.getSpecificRoutines();


            for (int m = 0; m < specifics.length; m++) {
                if (specifics[m].getLanguage() != Routine.LANGUAGE_JAVA) {
                    continue;
                }


                row                   = t.getEmptyRowData();
                row[specific_catalog] = database.getCatalogName().name;
                row[specific_schema]  = routine.getSchemaName().name;
                row[specific_name]    = routine.getName().name;
                row[jar_catalog]      = database.getCatalogName().name;
                row[jar_schema] =
                    database.schemaManager.getSQLJSchemaHsqlName();
                row[jar_name] = "CLASSPATH";

View Full Code Here


        it = database.schemaManager.databaseObjectIterator(
            SchemaObject.ROUTINE);


        while (it.hasNext()) {
            RoutineSchema routine = (RoutineSchema) it.next();


            if (!session.getGrantee().isAccessible(routine)) {
                continue;
            }


            Routine[] specifics = routine.getSpecificRoutines();


            for (int m = 0; m < specifics.length; m++) {
                OrderedHashSet set = specifics[m].getReferences();


                for (int i = 0; i < set.size(); i++) {

View Full Code Here


        it = database.schemaManager.databaseObjectIterator(
            SchemaObject.ROUTINE);


        while (it.hasNext()) {
            RoutineSchema routine = (RoutineSchema) it.next();


            if (!session.getGrantee().isAccessible(routine)) {
                continue;
            }


            Routine[] specifics = routine.getSpecificRoutines();


            for (int m = 0; m < specifics.length; m++) {
                OrderedHashSet set = specifics[m].getReferences();


                for (int i = 0; i < set.size(); i++) {

View Full Code Here


        it = database.schemaManager.databaseObjectIterator(
            SchemaObject.ROUTINE);


        while (it.hasNext()) {
            RoutineSchema routine = (RoutineSchema) it.next();


            if (!session.getGrantee().isAccessible(routine)) {
                continue;
            }


            Routine[] specifics = routine.getSpecificRoutines();


            for (int m = 0; m < specifics.length; m++) {
                OrderedHashSet set = specifics[m].getReferences();


                for (int i = 0; i < set.size(); i++) {
                    HsqlName refName = (HsqlName) set.get(i);


                    if (refName.type != SchemaObject.TABLE
                            && refName.type != SchemaObject.VIEW) {
                        continue;
                    }


                    if (!session.getGrantee().isAccessible(refName)) {
                        continue;
                    }


                    row                   = t.getEmptyRowData();
                    row[specific_catalog] = database.getCatalogName().name;
                    row[specific_schema]  = specifics[m].getSchemaName().name;
                    row[specific_name]    = specifics[m].getName().name;
                    row[routine_catalog]  = database.getCatalogName().name;
                    row[routine_schema]   = routine.getSchemaName().name;
                    row[routine_name]     = routine.getName().name;
                    row[table_catalog]    = database.getCatalogName().name;
                    row[table_schema]     = refName.schema.name;
                    row[table_name]       = refName.name;


                    try {

View Full Code Here


        it = database.schemaManager.databaseObjectIterator(
            SchemaObject.ROUTINE);


        while (it.hasNext()) {
            RoutineSchema routine = (RoutineSchema) it.next();


            if (!session.getGrantee().isAccessible(routine)) {
                continue;
            }


            Routine[] specifics = routine.getSpecificRoutines();


            for (int m = 0; m < specifics.length; m++) {
                row = t.getEmptyRowData();


                Routine specific = specifics[m];
                Type    type     = specific.isProcedure() ? null
                                                          : specific
                                                              .getReturnType();


                //
                row[specific_catalog] = database.getCatalogName().name;
                row[specific_schema]  = specific.getSchemaName().name;
                row[specific_name]    = specific.getSpecificName().name;
                row[routine_catalog]  = database.getCatalogName().name;
                row[routine_schema]   = routine.getSchemaName().name;
                row[routine_name]     = specific.getName().name;
                row[routine_type]     = specific.isProcedure() ? "PROCEDURE"
                                                               : "FUNCTION";
                row[module_catalog]   = null;
                row[module_schema]    = null;

View Full Code Here

TOP

Related Classes of org.hsqldb_voltpatches.RoutineSchema

org.hsqldb_voltpatches.dbinfo.DatabaseInformationFull

org.hsqldb_voltpatches.HsqlNameManager.HsqlName

org.hsqldb_voltpatches.lib.HsqlArrayList

org.hsqldb_voltpatches.lib.OrderedHashSet

All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.