Examples with ExecRow org.apache.derby.iapi.sql.execute.ExecRow used on opensource projects

Example 26 with ExecRow

use of org.apache.derby.iapi.sql.execute.ExecRow in project derby by apache.

the class DataDictionaryImpl method addDescriptor.

/**
 * @see DataDictionary#addDescriptor
 */
public void addDescriptor(TupleDescriptor td, TupleDescriptor parent, int catalogNumber, boolean duplicatesAllowed, TransactionController tc) throws StandardException {
    TabInfoImpl ti = (catalogNumber < NUM_CORE) ? coreInfo[catalogNumber] : getNonCoreTI(catalogNumber);
    ExecRow row = ti.getCatalogRowFactory().makeRow(td, parent);
    int insertRetCode = ti.insertRow(row, tc);
    if (!duplicatesAllowed) {
        if (insertRetCode != TabInfoImpl.ROWNOTDUPLICATE)
            throw duplicateDescriptorException(td, parent);
    }
}

Example 27 with ExecRow

use of org.apache.derby.iapi.sql.execute.ExecRow in project derby by apache.

the class SYSTABLEPERMSRowFactory method makeRow.

public ExecRow makeRow(TupleDescriptor td, TupleDescriptor parent) throws StandardException {
    UUID oid;
    DataValueDescriptor grantee = null;
    DataValueDescriptor grantor = null;
    String tablePermID = null;
    String tableID = null;
    String selectPriv = null;
    String deletePriv = null;
    String insertPriv = null;
    String updatePriv = null;
    String referencesPriv = null;
    String triggerPriv = null;
    if (td == null) {
        grantee = getNullAuthorizationID();
        grantor = getNullAuthorizationID();
    } else {
        TablePermsDescriptor tpd = (TablePermsDescriptor) td;
        oid = tpd.getUUID();
        if (oid == null) {
            oid = getUUIDFactory().createUUID();
            tpd.setUUID(oid);
        }
        tablePermID = oid.toString();
        grantee = getAuthorizationID(tpd.getGrantee());
        grantor = getAuthorizationID(tpd.getGrantor());
        tableID = tpd.getTableUUID().toString();
        selectPriv = tpd.getSelectPriv();
        deletePriv = tpd.getDeletePriv();
        insertPriv = tpd.getInsertPriv();
        updatePriv = tpd.getUpdatePriv();
        referencesPriv = tpd.getReferencesPriv();
        triggerPriv = tpd.getTriggerPriv();
    }
    ExecRow row = getExecutionFactory().getValueRow(COLUMN_COUNT);
    row.setColumn(TABLEPERMSID_COL_NUM, new SQLChar(tablePermID));
    row.setColumn(GRANTEE_COL_NUM, grantee);
    row.setColumn(GRANTOR_COL_NUM, grantor);
    row.setColumn(TABLEID_COL_NUM, new SQLChar(tableID));
    row.setColumn(SELECTPRIV_COL_NUM, new SQLChar(selectPriv));
    row.setColumn(DELETEPRIV_COL_NUM, new SQLChar(deletePriv));
    row.setColumn(INSERTPRIV_COL_NUM, new SQLChar(insertPriv));
    row.setColumn(UPDATEPRIV_COL_NUM, new SQLChar(updatePriv));
    row.setColumn(REFERENCESPRIV_COL_NUM, new SQLChar(referencesPriv));
    row.setColumn(TRIGGERPRIV_COL_NUM, new SQLChar(triggerPriv));
    return row;
}

Example 28 with ExecRow

use of org.apache.derby.iapi.sql.execute.ExecRow in project derby by apache.

the class SYSTRIGGERSRowFactory method makeRow.

/**
 * Helper method that contains common logic for {@code makeRow()} and
 * {@code makeEmptyRowForCurrentVersion()}. Creates a row for the
 * SYSTRIGGERS conglomerate.
 *
 * @param td the {@code TriggerDescriptor} to create a row from (can be
 *   {@code null} if the returned row should be empty)
 * @param columnCount the number of columns in the returned row (used for
 *   trimming off columns in soft upgrade mode to match the format in
 *   the old dictionary version)
 * @return a row for the SYSTRIGGERS conglomerate
 * @throws StandardException if an error happens when creating the row
 */
private ExecRow makeRow(TupleDescriptor td, int columnCount) throws StandardException {
    String name = null;
    UUID uuid = null;
    // schema
    UUID suuid = null;
    // referenced table
    UUID tuuid = null;
    // action sps uuid string
    UUID actionSPSID = null;
    // when clause sps uuid string
    UUID whenSPSID = null;
    Timestamp createTime = null;
    String event = null;
    String time = null;
    String type = null;
    String enabled = null;
    String triggerDefinition = null;
    String oldReferencingName = null;
    String newReferencingName = null;
    ReferencedColumns rcd = null;
    boolean referencingOld = false;
    boolean referencingNew = false;
    String whenClauseText = null;
    if (td != null) {
        TriggerDescriptor triggerDescriptor = (TriggerDescriptor) td;
        name = triggerDescriptor.getName();
        uuid = triggerDescriptor.getUUID();
        suuid = triggerDescriptor.getSchemaDescriptor().getUUID();
        createTime = triggerDescriptor.getCreationTimestamp();
        // for now we are assuming that a trigger can only listen to a single event
        event = triggerDescriptor.listensForEvent(TriggerDescriptor.TRIGGER_EVENT_UPDATE) ? "U" : triggerDescriptor.listensForEvent(TriggerDescriptor.TRIGGER_EVENT_DELETE) ? "D" : "I";
        time = triggerDescriptor.isBeforeTrigger() ? "B" : "A";
        type = triggerDescriptor.isRowTrigger() ? "R" : "S";
        enabled = triggerDescriptor.isEnabled() ? "E" : "D";
        tuuid = triggerDescriptor.getTableDescriptor().getUUID();
        int[] refCols = triggerDescriptor.getReferencedCols();
        int[] refColsInTriggerAction = triggerDescriptor.getReferencedColsInTriggerAction();
        rcd = (refCols != null || refColsInTriggerAction != null) ? new ReferencedColumnsDescriptorImpl(refCols, refColsInTriggerAction) : null;
        actionSPSID = triggerDescriptor.getActionId();
        whenSPSID = triggerDescriptor.getWhenClauseId();
        triggerDefinition = triggerDescriptor.getTriggerDefinition();
        referencingOld = triggerDescriptor.getReferencingOld();
        referencingNew = triggerDescriptor.getReferencingNew();
        oldReferencingName = triggerDescriptor.getOldReferencingName();
        newReferencingName = triggerDescriptor.getNewReferencingName();
        whenClauseText = triggerDescriptor.getWhenClauseText();
    }
    /* Build the row to insert */
    ExecRow row = getExecutionFactory().getValueRow(columnCount);
    /* 1st column is TRIGGERID */
    row.setColumn(1, new SQLChar((uuid == null) ? null : uuid.toString()));
    /* 2nd column is TRIGGERNAME */
    row.setColumn(2, new SQLVarchar(name));
    /* 3rd column is SCHEMAID */
    row.setColumn(3, new SQLChar((suuid == null) ? null : suuid.toString()));
    /* 4th column is CREATIONTIMESTAMP */
    SQLTimestamp creationTimestamp = (createTime == null) ? new SQLTimestamp(null) : new SQLTimestamp(createTime, getCalendarForCreationTimestamp());
    row.setColumn(4, creationTimestamp);
    /* 5th column is EVENT */
    row.setColumn(5, new SQLChar(event));
    /* 6th column is FIRINGTIME */
    row.setColumn(6, new SQLChar(time));
    /* 7th column is TYPE */
    row.setColumn(7, new SQLChar(type));
    /* 8th column is STATE */
    row.setColumn(8, new SQLChar(enabled));
    /* 9th column is TABLEID */
    row.setColumn(9, new SQLChar((tuuid == null) ? null : tuuid.toString()));
    /* 10th column is WHENSTMTID */
    row.setColumn(10, new SQLChar((whenSPSID == null) ? null : whenSPSID.toString()));
    /* 11th column is ACTIONSTMTID */
    row.setColumn(11, new SQLChar((actionSPSID == null) ? null : actionSPSID.toString()));
    /* 12th column is REFERENCEDCOLUMNS 
		 *  (user type org.apache.derby.catalog.ReferencedColumns)
		 */
    row.setColumn(12, new UserType(rcd));
    /* 13th column is TRIGGERDEFINITION */
    row.setColumn(13, dvf.getLongvarcharDataValue(triggerDefinition));
    /* 14th column is REFERENCINGOLD */
    row.setColumn(14, new SQLBoolean(referencingOld));
    /* 15th column is REFERENCINGNEW */
    row.setColumn(15, new SQLBoolean(referencingNew));
    /* 16th column is OLDREFERENCINGNAME */
    row.setColumn(16, new SQLVarchar(oldReferencingName));
    /* 17th column is NEWREFERENCINGNAME */
    row.setColumn(17, new SQLVarchar(newReferencingName));
    /* 18th column is WHENCLAUSETEXT */
    if (row.nColumns() >= 18) {
        // This column is present only if the data dictionary version is
        // 10.11 or higher.
        row.setColumn(18, dvf.getLongvarcharDataValue(whenClauseText));
    }
    return row;
}

Example 29 with ExecRow

use of org.apache.derby.iapi.sql.execute.ExecRow in project derby by apache.

the class SYSVIEWSRowFactory method makeRow.

// ///////////////////////////////////////////////////////////////////////////
// 
// METHODS
// 
// ///////////////////////////////////////////////////////////////////////////
/**
 * Make a SYSVIEWS row
 *
 * @return	Row suitable for inserting into SYSVIEWS.
 *
 * @exception   StandardException thrown on failure
 */
public ExecRow makeRow(TupleDescriptor td, TupleDescriptor parent) throws StandardException {
    DataValueDescriptor col;
    ExecRow row;
    String tableID = null;
    String compSchemaId = null;
    String viewText = null;
    String checkSType = null;
    int checkIType;
    if (td != null) {
        UUID tableUUID;
        ViewDescriptor vd = (ViewDescriptor) td;
        /*
			** We only allocate a new UUID if the descriptor doesn't already have one.
			** For descriptors replicated from a Source system, we already have an UUID.
			*/
        tableUUID = vd.getUUID();
        if (tableUUID == null) {
            tableUUID = getUUIDFactory().createUUID();
            vd.setUUID(tableUUID);
        }
        tableID = tableUUID.toString();
        viewText = vd.getViewText();
        /* RESOLVE - check constraints not supported yet */
        checkIType = vd.getCheckOptionType();
        if (SanityManager.DEBUG) {
            if (checkIType != ViewDescriptor.NO_CHECK_OPTION) {
                SanityManager.THROWASSERT("checkIType expected to be " + ViewDescriptor.NO_CHECK_OPTION + ", not " + checkIType);
            }
        }
        checkSType = "N";
        UUID tmpId = vd.getCompSchemaId();
        compSchemaId = (tmpId == null) ? null : tmpId.toString();
    }
    /* Insert info into sysviews */
    /* RESOLVE - It would be nice to require less knowledge about sysviews
		 * and have this be more table driven.
		 */
    /* Build the row to insert  */
    row = getExecutionFactory().getValueRow(SYSVIEWS_COLUMN_COUNT);
    /* 1st column is TABLEID (UUID - char(36)) */
    row.setColumn(SYSVIEWS_TABLEID, new SQLChar(tableID));
    /* 2nd column is VIEWDEFINITION */
    row.setColumn(SYSVIEWS_VIEWDEFINITION, dvf.getLongvarcharDataValue(viewText));
    /* 3rd column is CHECKOPTION (char(1)) */
    row.setColumn(SYSVIEWS_CHECKOPTION, new SQLChar(checkSType));
    /* 4th column is COMPILATIONSCHEMAID (UUID - char(36)) */
    row.setColumn(SYSVIEWS_COMPILATION_SCHEMAID, new SQLChar(compSchemaId));
    return row;
}

Example 30 with ExecRow

use of org.apache.derby.iapi.sql.execute.ExecRow in project derby by apache.

the class SYSCOLUMNSRowFactory method makeRow.

private ExecRow makeRow(TupleDescriptor td, int columnCount) throws StandardException {
    ExecRow row;
    String colName = null;
    String defaultID = null;
    String tabID = null;
    Integer colID = null;
    TypeDescriptor typeDesc = null;
    Object defaultSerializable = null;
    long autoincStart = 0;
    long autoincInc = 0;
    long autoincValue = 0;
    boolean autoincCycle = false;
    // The SYSCOLUMNS table's autoinc related columns change with different
    // values depending on what happened to the autoinc column, ie is the
    // user adding an autoincrement column, or is user changing the existing
    // autoincrement column to change it's increment value or to change it's
    // start value? Following variable is used to keep track of what happened
    // to the autoincrement column.
    long autoinc_create_or_modify_Start_Increment = -1;
    if (td != null) {
        ColumnDescriptor column = (ColumnDescriptor) td;
        /* Lots of info in the column's type descriptor */
        typeDesc = column.getType().getCatalogType();
        tabID = column.getReferencingUUID().toString();
        colName = column.getColumnName();
        colID = column.getPosition();
        autoincStart = column.getAutoincStart();
        autoincInc = column.getAutoincInc();
        autoincValue = column.getAutoincValue();
        autoinc_create_or_modify_Start_Increment = column.getAutoinc_create_or_modify_Start_Increment();
        autoincCycle = column.getAutoincCycle();
        if (column.getDefaultInfo() != null) {
            defaultSerializable = column.getDefaultInfo();
        } else {
            defaultSerializable = column.getDefaultValue();
        }
        if (column.getDefaultUUID() != null) {
            defaultID = column.getDefaultUUID().toString();
        }
    }
    /* Insert info into syscolumns */
    /* RESOLVE - It would be nice to require less knowledge about syscolumns
		 * and have this be more table driven.
		 * RESOLVE - We'd like to store the DataTypeDescriptor in a column.
		 */
    /* Build the row to insert  */
    row = getExecutionFactory().getValueRow(columnCount);
    /* 1st column is REFERENCEID (UUID - char(36)) */
    row.setColumn(SYSCOLUMNS_REFERENCEID, new SQLChar(tabID));
    /* 2nd column is COLUMNNAME (varchar(128)) */
    row.setColumn(SYSCOLUMNS_COLUMNNAME, new SQLVarchar(colName));
    /* 3rd column is COLUMNNUMBER (int) */
    row.setColumn(SYSCOLUMNS_COLUMNNUMBER, new SQLInteger(colID));
    /* 4th column is COLUMNDATATYPE */
    row.setColumn(SYSCOLUMNS_COLUMNDATATYPE, new UserType(typeDesc));
    /* 5th column is COLUMNDEFAULT */
    row.setColumn(SYSCOLUMNS_COLUMNDEFAULT, new UserType(defaultSerializable));
    /* 6th column is DEFAULTID (UUID - char(36)) */
    row.setColumn(SYSCOLUMNS_COLUMNDEFAULTID, new SQLChar(defaultID));
    if ((autoinc_create_or_modify_Start_Increment == ColumnDefinitionNode.CREATE_AUTOINCREMENT) || (autoinc_create_or_modify_Start_Increment == ColumnDefinitionNode.MODIFY_AUTOINCREMENT_INC_VALUE) || (autoinc_create_or_modify_Start_Increment == ColumnDefinitionNode.MODIFY_AUTOINCREMENT_ALWAYS_VS_DEFAULT)) {
        // user is adding an autoinc column
        // or is changing the increment value of autoinc column
        // or is changing an autoinc column between ALWAYS and DEFAULT.
        // This code also gets run when ALTER TABLE DROP COLUMN
        // is used to drop a column other than the autoinc
        // column, and the autoinc column gets removed from
        // SYSCOLUMNS and immediately re-added with a different
        // column position (to account for the dropped column).
        // In this case, the autoincValue may have a
        // different value than the autoincStart.
        row.setColumn(SYSCOLUMNS_AUTOINCREMENTVALUE, new SQLLongint(autoincValue));
        row.setColumn(SYSCOLUMNS_AUTOINCREMENTSTART, new SQLLongint(autoincStart));
        row.setColumn(SYSCOLUMNS_AUTOINCREMENTINC, new SQLLongint(autoincInc));
        if (row.nColumns() >= 10) {
            // This column is present only if the data dictionary version is
            // 10.14 or higher.
            row.setColumn(SYSCOLUMNS_AUTOINCREMENTINCCYCLE, new SQLBoolean(autoincCycle));
        }
    } else if (autoinc_create_or_modify_Start_Increment == ColumnDefinitionNode.MODIFY_AUTOINCREMENT_RESTART_VALUE) {
        // user asked for restart with a new value, so don't change increment by and original start
        // with values in the SYSCOLUMNS table. Just record the RESTART WITH value as the
        // next value to be generated in the SYSCOLUMNS table
        ColumnDescriptor column = (ColumnDescriptor) td;
        row.setColumn(SYSCOLUMNS_AUTOINCREMENTVALUE, new SQLLongint(autoincStart));
        row.setColumn(SYSCOLUMNS_AUTOINCREMENTSTART, new SQLLongint(autoincStart));
        row.setColumn(SYSCOLUMNS_AUTOINCREMENTINC, new SQLLongint(column.getTableDescriptor().getColumnDescriptor(colName).getAutoincInc()));
        if (row.nColumns() >= 10) {
            // This column is present only if the data dictionary version is
            // 10.14 or higher.
            row.setColumn(SYSCOLUMNS_AUTOINCREMENTINCCYCLE, new SQLBoolean(autoincCycle));
        }
    } else if (autoinc_create_or_modify_Start_Increment == ColumnDefinitionNode.MODIFY_AUTOINCREMENT_CYCLE_VALUE) {
        ColumnDescriptor column = (ColumnDescriptor) td;
        row.setColumn(SYSCOLUMNS_AUTOINCREMENTVALUE, new SQLLongint(column.getTableDescriptor().getColumnDescriptor(colName).getAutoincValue()));
        row.setColumn(SYSCOLUMNS_AUTOINCREMENTSTART, new SQLLongint(column.getTableDescriptor().getColumnDescriptor(colName).getAutoincStart()));
        row.setColumn(SYSCOLUMNS_AUTOINCREMENTINC, new SQLLongint(column.getTableDescriptor().getColumnDescriptor(colName).getAutoincInc()));
        if (row.nColumns() >= 10) {
            // This column is present only if the data dictionary version is
            // 10.14 or higher.
            row.setColumn(SYSCOLUMNS_AUTOINCREMENTINCCYCLE, new SQLBoolean(autoincCycle));
        }
    } else {
        row.setColumn(SYSCOLUMNS_AUTOINCREMENTVALUE, new SQLLongint());
        row.setColumn(SYSCOLUMNS_AUTOINCREMENTSTART, new SQLLongint());
        row.setColumn(SYSCOLUMNS_AUTOINCREMENTINC, new SQLLongint());
        if (row.nColumns() >= 10) {
            // This column is present only if the data dictionary version is
            // 10.14 or higher.
            row.setColumn(SYSCOLUMNS_AUTOINCREMENTINCCYCLE, new SQLBoolean(autoincCycle));
        }
    }
    return row;
}