org.apache.ddlutils.model.Table#getIndex

Source File: AxionModelReader.java From gemfirexd-oss with Apache License 2.0

6 votes

/**
 * {@inheritDoc}
 */
protected void removeSystemIndices(DatabaseMetaDataWrapper metaData, Table table) throws SQLException
{
    // Axion's JDBC driver does not support primary key reading, so we have to filter at this level
    for (int indexIdx = 0; indexIdx < table.getIndexCount();)
    {
        Index index = table.getIndex(indexIdx);

        // also, Axion's internal indices are not unique
        if (index.getName().startsWith("SYS_"))
        {
            table.removeIndex(indexIdx);
        }
        else
        {
            indexIdx++;
        }
    }
}

Source File: JdbcModelReader.java From gemfirexd-oss with Apache License 2.0

6 votes

/**
 * Tries to remove the internal index for the table's primary key.
 * 
 * @param metaData The database meta data
 * @param table    The table
 */
protected void removeInternalPrimaryKeyIndex(DatabaseMetaDataWrapper metaData, Table table) throws SQLException
{
    Column[] pks         = table.getPrimaryKeyColumns();
    List     columnNames = new ArrayList();

    for (int columnIdx = 0; columnIdx < pks.length; columnIdx++)
    {
        columnNames.add(pks[columnIdx].getName());
    }

    for (int indexIdx = 0; indexIdx < table.getIndexCount();)
    {
        Index index = table.getIndex(indexIdx);

        if (index.isUnique() && matches(index, columnNames) && 
            isInternalPrimaryKeyIndex(metaData, table, index))
        {
            table.removeIndex(indexIdx);
        }
        else
        {
            indexIdx++;
        }
    }
}

Source File: JdbcModelReader.java From gemfirexd-oss with Apache License 2.0

6 votes

/**
 * Tries to remove the internal index for the table's primary key.
 * 
 * @param metaData The database meta data
 * @param table    The table
 */
protected void removeInternalPrimaryKeyIndex(DatabaseMetaDataWrapper metaData, Table table) throws SQLException
{
    Column[] pks         = table.getPrimaryKeyColumns();
    List     columnNames = new ArrayList();

    for (int columnIdx = 0; columnIdx < pks.length; columnIdx++)
    {
        columnNames.add(pks[columnIdx].getName());
    }

    for (int indexIdx = 0; indexIdx < table.getIndexCount();)
    {
        Index index = table.getIndex(indexIdx);

        if (index.isUnique() && matches(index, columnNames) && 
            isInternalPrimaryKeyIndex(metaData, table, index))
        {
            table.removeIndex(indexIdx);
        }
        else
        {
            indexIdx++;
        }
    }
}

Source File: AxionModelReader.java From gemfirexd-oss with Apache License 2.0

6 votes

/**
 * {@inheritDoc}
 */
protected void removeSystemIndices(DatabaseMetaDataWrapper metaData, Table table) throws SQLException
{
    // Axion's JDBC driver does not support primary key reading, so we have to filter at this level
    for (int indexIdx = 0; indexIdx < table.getIndexCount();)
    {
        Index index = table.getIndex(indexIdx);

        // also, Axion's internal indices are not unique
        if (index.getName().startsWith("SYS_"))
        {
            table.removeIndex(indexIdx);
        }
        else
        {
            indexIdx++;
        }
    }
}

Source File: MSSqlModelReader.java From gemfirexd-oss with Apache License 2.0

5 votes

/**
    * {@inheritDoc}
    */
protected Table readTable(DatabaseMetaDataWrapper metaData, Map values) throws SQLException
{
       String tableName = (String)values.get("TABLE_NAME");

       for (int idx = 0; idx < KNOWN_SYSTEM_TABLES.length; idx++)
       {
           if (KNOWN_SYSTEM_TABLES[idx].equals(tableName))
           {
               return null;
           }
       }

       Table table = super.readTable(metaData, values);

       if (table != null)
       {
           // Sql Server does not return the auto-increment status via the database metadata
           determineAutoIncrementFromResultSetMetaData(table, table.getColumns());

           // TODO: Replace this manual filtering using named pks once they are available
           //       This is then probably of interest to every platform
           for (int idx = 0; idx < table.getIndexCount();)
           {
               Index index = table.getIndex(idx);

               if (index.isUnique() && existsPKWithName(metaData, table, index.getName()))
               {
                   table.removeIndex(idx);
               }
               else
               {
                   idx++;
               }
           }
       }
       return table;
}

Source File: SqlBuilder.java From gemfirexd-oss with Apache License 2.0

5 votes

/**
 * Writes the indexes for the given table using external index creation statements.
 * 
 * @param table The table
 */
public void createIndexes(Table table) throws IOException
{
    for (int idx = 0; idx < table.getIndexCount(); idx++)
    {
        Index index = table.getIndex(idx);

        if (!index.isUnique() && !getPlatformInfo().isIndicesSupported())
        {
            throw new ModelException("Platform does not support non-unique indices");
        }
        createIndex(table, index);
    }
}

Source File: ModelComparator.java From gemfirexd-oss with Apache License 2.0

5 votes

/**
 * Searches in the given table for a corresponding index. If the given index
 * has no name, then a index to the same table with the same columns in the
 * same order is searched. If the given index has a name, then the a corresponding
 * index also needs to have the same name, or no name at all, but not a different one. 
 * 
 * @param table The table to search in
 * @param index The original index
 * @return The corresponding index if found
 */
protected Index findCorrespondingIndex(Table table, Index index)
{
    for (int indexIdx = 0; indexIdx < table.getIndexCount(); indexIdx++)
    {
        Index curIndex = table.getIndex(indexIdx);

        if ((_caseSensitive  && index.equals(curIndex)) ||
            (!_caseSensitive && index.equalsIgnoreCase(curIndex)))
        {
            return curIndex;
        }
    }
    return null;
}

Source File: SqlBuilder.java From gemfirexd-oss with Apache License 2.0

5 votes

/**
 * Writes the indexes for the given table using external index creation statements.
 * 
 * @param table The table
 */
public void createIndexes(Table table) throws IOException
{
    for (int idx = 0; idx < table.getIndexCount(); idx++)
    {
        Index index = table.getIndex(idx);

        if (!index.isUnique() && !getPlatformInfo().isIndicesSupported())
        {
            throw new ModelException("Platform does not support non-unique indices");
        }
        createIndex(table, index);
    }
}

Source File: ModelComparator.java From gemfirexd-oss with Apache License 2.0

5 votes

/**
 * Creates change objects for indexes that are not present in the given source table but are in the target
 * table, and applies them to the given intermediate model.
 * 
 * @param sourceModel       The source model
 * @param sourceTable       The source table
 * @param intermediateModel The intermediate model to apply the changes to
 * @param intermediateTable The table from the intermediate model corresponding to the source table
 * @param targetModel       The target model
 * @param targetTable       The target table
 * @return The changes
 */
protected List checkForAddedIndexes(Database sourceModel,
                                    Table    sourceTable,
                                    Database intermediateModel,
                                    Table    intermediateTable,
                                    Database targetModel,
                                    Table    targetTable)
{
    List changes = new ArrayList();

    for (int indexIdx = 0; indexIdx < targetTable.getIndexCount(); indexIdx++)
    {
        Index targetIndex       = targetTable.getIndex(indexIdx);
        Index intermediateIndex = findCorrespondingIndex(intermediateTable, targetIndex);
        Index sourceIndex       = findCorrespondingIndex(sourceTable, targetIndex);

        if ((sourceIndex == null) && (intermediateIndex == null))
        {
            if (_log.isInfoEnabled())
            {
                _log.info("Index " + targetIndex.getName() + " needs to be created for table " + intermediateTable.getQualifiedName());
            }

            Index          clonedIndex = _cloneHelper.clone(targetIndex, intermediateTable, _caseSensitive);
            AddIndexChange change      = new AddIndexChange(intermediateTable.getQualifiedName(), clonedIndex);

            changes.add(change);
            change.apply(intermediateModel, _caseSensitive);
        }
    }
    return changes;
}

Source File: JdbcModelReader.java From gemfirexd-oss with Apache License 2.0

5 votes

/**
 * Tries to remove the internal index for the given foreign key.
 * 
 * @param metaData The database meta data
 * @param table    The table where the table is defined
 * @param fk       The foreign key
 */
protected void removeInternalForeignKeyIndex(DatabaseMetaDataWrapper metaData, Table table, ForeignKey fk) throws SQLException
{
    List    columnNames  = new ArrayList();
    boolean mustBeUnique = !getPlatformInfo().isSystemForeignKeyIndicesAlwaysNonUnique();

    for (int columnIdx = 0; columnIdx < fk.getReferenceCount(); columnIdx++)
    {
        String name        = fk.getReference(columnIdx).getLocalColumnName();
        Column localColumn = table.findColumn(name,
                                              getPlatform().isDelimitedIdentifierModeOn());

        if (mustBeUnique && !localColumn.isPrimaryKey())
        {
            mustBeUnique = false;
        }
        columnNames.add(name);
    }

    for (int indexIdx = 0; indexIdx < table.getIndexCount();)
    {
        Index index = table.getIndex(indexIdx);

        if ((!mustBeUnique || index.isUnique()) && matches(index, columnNames) && 
            isInternalForeignKeyIndex(metaData, table, fk, index))
        {
            fk.setAutoIndexPresent(true);
            table.removeIndex(indexIdx);
        }
        else
        {
            indexIdx++;
        }
    }
}

Source File: ModelComparator.java From gemfirexd-oss with Apache License 2.0

5 votes

/**
 * Searches in the given table for a corresponding index. If the given index
 * has no name, then a index to the same table with the same columns in the
 * same order is searched. If the given index has a name, then the a corresponding
 * index also needs to have the same name, or no name at all, but not a different one. 
 * 
 * @param table The table to search in
 * @param index The original index
 * @return The corresponding index if found
 */
protected Index findCorrespondingIndex(Table table, Index index)
{
    for (int indexIdx = 0; indexIdx < table.getIndexCount(); indexIdx++)
    {
        Index curIndex = table.getIndex(indexIdx);

        if ((_caseSensitive  && index.equals(curIndex)) ||
            (!_caseSensitive && index.equalsIgnoreCase(curIndex)))
        {
            return curIndex;
        }
    }
    return null;
}

Source File: ModelComparator.java From gemfirexd-oss with Apache License 2.0

5 votes

/**
 * Creates change objects for indexes that are not present in the given source table but are in the target
 * table, and applies them to the given intermediate model.
 * 
 * @param sourceModel       The source model
 * @param sourceTable       The source table
 * @param intermediateModel The intermediate model to apply the changes to
 * @param intermediateTable The table from the intermediate model corresponding to the source table
 * @param targetModel       The target model
 * @param targetTable       The target table
 * @return The changes
 */
protected List checkForAddedIndexes(Database sourceModel,
                                    Table    sourceTable,
                                    Database intermediateModel,
                                    Table    intermediateTable,
                                    Database targetModel,
                                    Table    targetTable)
{
    List changes = new ArrayList();

    for (int indexIdx = 0; indexIdx < targetTable.getIndexCount(); indexIdx++)
    {
        Index targetIndex       = targetTable.getIndex(indexIdx);
        Index intermediateIndex = findCorrespondingIndex(intermediateTable, targetIndex);
        Index sourceIndex       = findCorrespondingIndex(sourceTable, targetIndex);

        if ((sourceIndex == null) && (intermediateIndex == null))
        {
            if (_log.isInfoEnabled())
            {
                _log.info("Index " + targetIndex.getName() + " needs to be created for table " + intermediateTable.getQualifiedName());
            }

            Index          clonedIndex = _cloneHelper.clone(targetIndex, intermediateTable, _caseSensitive);
            AddIndexChange change      = new AddIndexChange(intermediateTable.getQualifiedName(), clonedIndex);

            changes.add(change);
            change.apply(intermediateModel, _caseSensitive);
        }
    }
    return changes;
}

Source File: IndexChangeImplBase.java From gemfirexd-oss with Apache License 2.0

5 votes

/**
 * {@inheritDoc}
 */
public Index findChangedIndex(Database model, boolean caseSensitive)
{
    Table table = findChangedTable(model, caseSensitive);

    if (table != null)
    {
        for (int indexIdx = 0; indexIdx < table.getIndexCount(); indexIdx++)
        {
            Index curIndex = table.getIndex(indexIdx);

            if (curIndex.getColumnCount() == _columnNames.size())
            {
                for (int colIdx = 0; colIdx < curIndex.getColumnCount(); colIdx++)
                {
                    String curColName      = curIndex.getColumn(colIdx).getName();
                    String expectedColName = (String)_columnNames.get(colIdx);

                    if ((caseSensitive  && curColName.equals(expectedColName)) ||
                        (!caseSensitive && curColName.equalsIgnoreCase(expectedColName)))
                    {
                        return curIndex;
                    }
                }
            }
        }
    }
    return null;
}