Examples of ExecIndexRow

org.apache.derby.iapi.sql.execute.ExecIndexRow
This is an extension of ExecRow for use with indexes and sorting. @author jeff after ames

Examples of org.apache.derby.iapi.sql.execute.ExecIndexRow


    /* Use UUIDStringOrderable in both start and stop positions for scan */
    UUIDStringOrderable = getIDValueAsCHAR(uuid);


    /* Set up the start/stop position for the scan */
    ExecIndexRow keyRow = exFactory.getIndexableRow(1);
    keyRow.setColumn(1, UUIDStringOrderable);


    return (ColumnDescriptor)
          getDescriptorViaIndex(
            SYSCOLUMNSRowFactory.SYSCOLUMNS_INDEX2_ID,
            keyRow,

View Full Code Here

Examples of org.apache.derby.iapi.sql.execute.ExecIndexRow


    /* Use refIDOrderable in both start and stop position for scan. */
    refIDOrderable = getIDValueAsCHAR(uuid);


    /* Set up the start/stop position for the scan */
    ExecIndexRow keyRow = exFactory.getIndexableRow(1);
    keyRow.setColumn(1, refIDOrderable);


    getDescriptorViaIndex(
            SYSCOLUMNSRowFactory.SYSCOLUMNS_INDEX1_ID,
            keyRow,
            (ScanQualifier [][]) null,

View Full Code Here

Examples of org.apache.derby.iapi.sql.execute.ExecIndexRow

     */
    tableIdOrderable = getIDValueAsCHAR(tableID);
    columnNameOrderable = new SQLVarchar(columnName);


    /* Set up the start/stop position for the scan */
    ExecIndexRow keyRow = exFactory.getIndexableRow(2);
    keyRow.setColumn(1, tableIdOrderable);
    keyRow.setColumn(2, columnNameOrderable);


    dropColumnDescriptorCore( tc, keyRow);
  }

View Full Code Here

Examples of org.apache.derby.iapi.sql.execute.ExecIndexRow


    /* Use tableIDOrderable in both start and stop position for scan. */
    tableIdOrderable = getIDValueAsCHAR(tableID);


    /* Set up the start/stop position for the scan */
    ExecIndexRow keyRow = exFactory.getIndexableRow(1);
    keyRow.setColumn(1, tableIdOrderable);


    dropColumnDescriptorCore(tc, keyRow);
  }

View Full Code Here

Examples of org.apache.derby.iapi.sql.execute.ExecIndexRow


    /* Use tableIDOrderable in both start and stop position for scan. */
    tableIdOrderable = getIDValueAsCHAR(tableID);


    /* Set up the start/stop position for the scan */
    ExecIndexRow keyRow = exFactory.getIndexableRow(1);
    keyRow.setColumn(1, tableIdOrderable);


    dropTablePermDescriptor(tc, keyRow);
    dropColumnPermDescriptor(tc, keyRow);
  }

View Full Code Here

Examples of org.apache.derby.iapi.sql.execute.ExecIndexRow

    //SYSCOLPERMS using getDescriptorViaIndex(). 
    List permissionDescriptorsList;//all ColPermsDescriptor for given tableid
    DataValueDescriptor    tableIDOrderable = getIDValueAsCHAR(tableID);
    TabInfoImpl  ti = getNonCoreTI(SYSCOLPERMS_CATALOG_NUM);
    SYSCOLPERMSRowFactory rf = (SYSCOLPERMSRowFactory) ti.getCatalogRowFactory();
    ExecIndexRow keyRow = exFactory.getIndexableRow(1);
    keyRow.setColumn(1, tableIDOrderable);
    permissionDescriptorsList = newSList();
    getDescriptorViaIndex(
      SYSCOLPERMSRowFactory.TABLEID_INDEX_NUM,
      keyRow,
      (ScanQualifier [][]) null,
      ti,
      (TupleDescriptor) null,
      permissionDescriptorsList,
      false);


    /* Next, using each of the ColPermDescriptor's uuid, get the unique row 
    in SYSCOLPERMS and adjust the "COLUMNS" column in SYSCOLPERMS to 
    accomodate the added or dropped column in the tableid*/
    ColPermsDescriptor colPermsDescriptor;
    ExecRow curRow;
    ExecIndexRow uuidKey;
    // Not updating any indexes on SYSCOLPERMS
    boolean[] bArray = new boolean[SYSCOLPERMSRowFactory.TOTAL_NUM_OF_INDEXES];
    int[] colsToUpdate = {SYSCOLPERMSRowFactory.COLUMNS_COL_NUM};
    for (Iterator iterator = permissionDescriptorsList.iterator(); iterator.hasNext(); )
    {

View Full Code Here

Examples of org.apache.derby.iapi.sql.execute.ExecIndexRow


    /* Use tableIDOrderable in both start and stop position for scan. */
    routineIdOrderable = getIDValueAsCHAR(routineID);


    /* Set up the start/stop position for the scan */
    ExecIndexRow keyRow = exFactory.getIndexableRow(1);
    keyRow.setColumn(1, routineIdOrderable);


    while ((curRow=ti.getRow(tc, keyRow, rf.ALIASID_INDEX_NUM)) != null)
    {
      perm = (PermissionsDescriptor)rf.buildDescriptor(curRow, (TupleDescriptor) null, this);
      removePermEntryInCache(perm);


      // Build new key based on UUID and drop the entry as we want to drop
      // only this row
      ExecIndexRow uuidKey;
      uuidKey = rf.buildIndexKeyRow(rf.ROUTINEPERMSID_INDEX_NUM, perm);
      ti.deleteRow(tc, uuidKey, rf.ROUTINEPERMSID_INDEX_NUM);
    }
  }

View Full Code Here

Examples of org.apache.derby.iapi.sql.execute.ExecIndexRow

      (DataValueDescriptor[]) null, // stop position -through last row
      0);                           // stopSearchOperation - none


    try {
      ExecRow outRow = rf.makeEmptyRow();
      ExecIndexRow indexRow = getIndexRowFromHeapRow(
        ti.getIndexRowGenerator(rf.SYSROLES_INDEX_ID_EE_OR_IDX),
        heapCC.newRowLocationTemplate(),
        outRow);


      while (sc.fetchNext(indexRow.getRowArray())) {
        if (action == DataDictionaryImpl.EXISTS) {
          return true;
        } else if (action == DataDictionaryImpl.DROP) {
          ti.deleteRow(tc, indexRow,
                 rf.SYSROLES_INDEX_ID_EE_OR_IDX);

View Full Code Here

Examples of org.apache.derby.iapi.sql.execute.ExecIndexRow

    roleNameOrderable = new SQLVarchar(roleName);
    granteeOrderable = new SQLVarchar(grantee);
    grantorOrderable = new SQLVarchar(grantor);


    /* Set up the start/stop position for the scan */
    ExecIndexRow keyRow = exFactory.getIndexableRow(3);
    keyRow.setColumn(1, roleNameOrderable);
    keyRow.setColumn(2, granteeOrderable);
    keyRow.setColumn(3, grantorOrderable);


    return (RoleGrantDescriptor)
      getDescriptorViaIndex(
        SYSROLESRowFactory.SYSROLES_INDEX_ID_EE_OR_IDX,
        keyRow,

View Full Code Here

Examples of org.apache.derby.iapi.sql.execute.ExecIndexRow

        TabInfoImpl ti = getNonCoreTI(SYSSEQUENCES_CATALOG_NUM);


        sequenceIdOrderable = getIDValueAsCHAR(descriptor.getUUID());


        /* Set up the start/stop position for the scan */
        ExecIndexRow keyRow = (ExecIndexRow) exFactory.getIndexableRow(1);
        keyRow.setColumn(1, sequenceIdOrderable);


        ti.deleteRow(tc, keyRow, SYSSEQUENCESRowFactory.SYSSEQUENCES_INDEX1_ID);
    }

View Full Code Here

0 1 2 3 4 5

TOP

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.