Examples of org.hsqldb_voltpatches.TriggerDef$TriggerData

org.hsqldb_voltpatches.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.FUNCTION
                        && refName.type != SchemaObject.PROCEDURE) {
                    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;
            row[action_order] =
                trigger.getTable().getTriggerIndex(trigger.getName().name);
            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

TOP

Related Classes of org.hsqldb_voltpatches.TriggerDef$TriggerData

org.hsqldb_voltpatches.dbinfo.DatabaseInformationFull

org.hsqldb_voltpatches.lib.HsqlDeque

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.