Examples of org.hsqldb.TriggerDef$DefaultTrigger

org.hsqldb.TriggerDef
Class to store the data used to fire a trigger. The username attribute is not used but it allows developers to change the signature of the fire method of the Trigger class and pass the user name to the Trigger.


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


        while (it.hasNext()) {
            TriggerDef trigger = (TriggerDef) it.next();


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


            OrderedHashSet set = trigger.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[trigger_catalog] = database.getCatalogName().name;
                row[trigger_schema]  = trigger.getSchemaName().name;
                row[trigger_name]    = trigger.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


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


        while (it.hasNext()) {
            TriggerDef trigger = (TriggerDef) it.next();


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


            OrderedHashSet set = trigger.getReferences();


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


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


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


                row                   = t.getEmptyRowData();
                row[trigger_catalog]  = database.getCatalogName().name;
                row[trigger_schema]   = trigger.getSchemaName().name;
                row[trigger_name]     = trigger.getName().name;
                row[specific_catalog] = database.getCatalogName().name;
                row[specific_schema]  = refName.schema.name;
                row[specific_name]    = refName.name;


                try {

View Full Code Here


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


        while (it.hasNext()) {
            TriggerDef trigger = (TriggerDef) it.next();


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


            OrderedHashSet set = trigger.getReferences();


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


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


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


                row                   = t.getEmptyRowData();
                row[trigger_catalog]  = database.getCatalogName().name;
                row[trigger_schema]   = trigger.getSchemaName().name;
                row[trigger_name]     = trigger.getName().name;
                row[sequence_catalog] = database.getCatalogName().name;
                row[sequence_schema]  = refName.schema.name;
                row[sequence_name]    = refName.name;


                try {

View Full Code Here


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


        while (it.hasNext()) {
            TriggerDef trigger = (TriggerDef) it.next();


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


            OrderedHashSet set = trigger.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[trigger_catalog] = database.getCatalogName().name;
                row[trigger_schema]  = trigger.getSchemaName().name;
                row[trigger_name]    = trigger.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.TRIGGER);


        while (it.hasNext()) {
            TriggerDef trigger = (TriggerDef) it.next();


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


            row                       = t.getEmptyRowData();
            row[trigger_catalog]      = database.getCatalogName().name;
            row[trigger_schema]       = trigger.getSchemaName().name;
            row[trigger_name]         = trigger.getName().name;
            row[event_manipulation]   = trigger.getEventTypeString();
            row[event_object_catalog] = database.getCatalogName().name;
            row[event_object_schema] = trigger.getTable().getSchemaName().name;
            row[event_object_table]   = trigger.getTable().getName().name;


            int order =
                trigger.getTable().getTriggerIndex(trigger.getName().name);


            row[action_order]       = ValuePool.getLong(order);
            row[action_condition]   = trigger.getConditionSQL();
            row[action_statement]   = trigger.getProcedureSQL();
            row[action_orientation] = trigger.getActionOrientationString();
            row[action_timing]      = trigger.getActionTimingString();
            row[action_reference_old_table] =
                trigger.getOldTransitionTableName();
            row[action_reference_new_table] =
                trigger.getNewTransitionTableName();
            row[action_reference_old_row] = trigger.getOldTransitionRowName();
            row[action_reference_new_row] = trigger.getNewTransitionRowName();
            row[created]                  = null;


            t.insertSys(store, row);
        }

View Full Code Here


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


        while (it.hasNext()) {
            TriggerDef trigger = (TriggerDef) it.next();


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


            int[] colIndexes = trigger.getUpdateColumnIndexes();


            if (colIndexes == null) {
                continue;
            }


            for (int i = 0; i < colIndexes.length; i++) {
                ColumnSchema column =
                    trigger.getTable().getColumn(colIndexes[i]);


                row                       = t.getEmptyRowData();
                row[trigger_catalog]      = database.getCatalogName().name;
                row[trigger_schema]       = trigger.getSchemaName().name;
                row[trigger_name]         = trigger.getName().name;
                row[event_object_catalog] = database.getCatalogName().name;
                row[event_object_schema] =
                    trigger.getTable().getSchemaName().name;
                row[event_object_table]  = trigger.getTable().getName().name;
                row[event_object_column] = column.getNameString();


                t.insertSys(store, row);
            }
        }

View Full Code Here


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


        while (it.hasNext()) {
            TriggerDef trigger = (TriggerDef) it.next();
            boolean isFullAccess =
                session.getGrantee().isFullyAccessibleByRole(
                    trigger.getName());


            if (!session.getGrantee().hasNonSelectTableRight(
                    trigger.getTable())) {
                continue;
            }


            row                       = t.getEmptyRowData();
            row[trigger_catalog]      = database.getCatalogName().name;
            row[trigger_schema]       = trigger.getSchemaName().name;
            row[trigger_name]         = trigger.getName().name;
            row[event_manipulation]   = trigger.getEventTypeString();
            row[event_object_catalog] = database.getCatalogName().name;
            row[event_object_schema] = trigger.getTable().getSchemaName().name;
            row[event_object_table]   = trigger.getTable().getName().name;


            int order =
                trigger.getTable().getTriggerIndex(trigger.getName().name);


            row[action_order]       = ValuePool.getLong(order);
            row[action_condition]   = isFullAccess ? trigger.getConditionSQL()
                                                   : null;
            row[action_statement]   = isFullAccess ? trigger.getProcedureSQL()
                                                   : null;
            row[action_orientation] = trigger.getActionOrientationString();
            row[action_timing]      = trigger.getActionTimingString();
            row[action_reference_old_table] =
                trigger.getOldTransitionTableName();
            row[action_reference_new_table] =
                trigger.getNewTransitionTableName();
            row[action_reference_old_row] = trigger.getOldTransitionRowName();
            row[action_reference_new_row] = trigger.getNewTransitionRowName();
            row[created]                  = null;


            t.insertSys(session, store, row);
        }

View Full Code Here


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


        while (it.hasNext()) {
            TriggerDef trigger = (TriggerDef) it.next();


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


            int[] colIndexes = trigger.getUpdateColumnIndexes();


            if (colIndexes == null) {
                continue;
            }


            for (int i = 0; i < colIndexes.length; i++) {
                ColumnSchema column =
                    trigger.getTable().getColumn(colIndexes[i]);


                row                       = t.getEmptyRowData();
                row[trigger_catalog]      = database.getCatalogName().name;
                row[trigger_schema]       = trigger.getSchemaName().name;
                row[trigger_name]         = trigger.getName().name;
                row[event_object_catalog] = database.getCatalogName().name;
                row[event_object_schema] =
                    trigger.getTable().getSchemaName().name;
                row[event_object_table]  = trigger.getTable().getName().name;
                row[event_object_column] = column.getNameString();


                t.insertSys(session, store, row);
            }
        }

View Full Code Here


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


        while (it.hasNext()) {
            TriggerDef trigger = (TriggerDef) it.next();


            if (!session.getGrantee().isFullyAccessibleByRole(
                    trigger.getName())) {
                continue;
            }


            OrderedHashSet set = trigger.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[trigger_catalog] = database.getCatalogName().name;
                row[trigger_schema]  = trigger.getSchemaName().name;
                row[trigger_name]    = trigger.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


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


        while (it.hasNext()) {
            TriggerDef trigger = (TriggerDef) it.next();


            if (!session.getGrantee().isFullyAccessibleByRole(
                    trigger.getName())) {
                continue;
            }


            OrderedHashSet set = trigger.getReferences();


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


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


                row                   = t.getEmptyRowData();
                row[trigger_catalog]  = database.getCatalogName().name;
                row[trigger_schema]   = trigger.getSchemaName().name;
                row[trigger_name]     = trigger.getName().name;
                row[specific_catalog] = database.getCatalogName().name;
                row[specific_schema]  = refName.schema.name;
                row[specific_name]    = refName.name;


                try {

View Full Code Here

0 1 2

TOP

Related Classes of org.hsqldb.TriggerDef$DefaultTrigger

org.hsqldb.dbinfo.DatabaseInformationFull

org.hsqldb.HsqlNameManager.HsqlName

org.hsqldb.lib.HsqlDeque

org.hsqldb.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.