org.apache.commons.collections.map.ListOrderedMap Java Examples

/**
* 
* json转换map.
* <br>详细说明
* @param jsonStr json字符串
* @return
* @return Map<String,Object> 集合
* @throws
* @author slj
*/
public static Map<String, Object> parseJSON2Map(String jsonStr) {
	ListOrderedMap map = new ListOrderedMap();
	// System.out.println(jsonStr);
	// 最外层解析
	JSONObject json = JSONObject.fromObject(jsonStr);
	for (Object k : json.keySet()) {
		Object v = json.get(k);
		// 如果内层还是数组的话，继续解析
		if (v instanceof JSONArray) {
			List<Map<String, Object>> list = new ArrayList<Map<String, Object>>();
			Iterator<JSONObject> it = ((JSONArray) v).iterator();
			while (it.hasNext()) {
				JSONObject json2 = it.next();
				list.add(parseJSON2Map(json2.toString()));
			}
			map.put(k.toString(), list);
		} else {
			map.put(k.toString(), v);
		}
	}
	return map;
}
 

/**
 * Returns the parameters for the given table.
 * 
 * @param table The table
 * @return The parameters
 */
public Map getParametersFor(Table table)
{
    ListOrderedMap result       = new ListOrderedMap();
    Map            globalParams = (Map)_parametersPerTable.get(null);
    Map            tableParams  = (Map)_parametersPerTable.get(table.getQualifiedName());

    if (globalParams != null)
    {
        result.putAll(globalParams);
    }
    if (tableParams != null)
    {
        result.putAll(tableParams);
    }
    return result;
}
 

/**
 * 根据给定的条件，把 list 中的 javabean 排序。
 * 用到了 commons beanutils 和  commons.collections
 *
 * @param list           待排序的 list
 * @param listOrderedMap 排序条件。
 *                       这是一个有序的 list ，排序条件按照加入到 list 的 bean 的属性(map 的 key)的先后顺序排序。
 *                       listOrderedMap 的 key 为待排序的 bean 的属性名称，值为是否按该属性的正序排序，true 为正序，false 为逆序。
 *                       使用方法见本类的 testSortListBeans() 方法例子，使用时注意不要写错 bean 的属性名称。
 * @param <T>            list 中的 bean 类型
 */
public static <T> void sortListBeans(List<T> list, ListOrderedMap listOrderedMap) {

    int num = listOrderedMap.size();
    ArrayList sortFields = new ArrayList();

    for (int i = 0; i < num; i++) {
        //  System.out.println("key =" + listOrderedMap.get(i) + " , value=" + listOrderedMap.getValue(i));
        Comparator comp = ComparableComparator.getInstance();

        comp = ComparatorUtils.nullLowComparator(comp);  //允许null

        if ((Boolean) listOrderedMap.getValue(i) == false)
            comp = ComparatorUtils.reversedComparator(comp); //逆序

        Comparator cmp = new BeanComparator((String) listOrderedMap.get(i), comp);
        sortFields.add(cmp);
    }

    ComparatorChain multiSort = new ComparatorChain(sortFields);
    Collections.sort(list, multiSort);
}
 

/**
 * Returns the parameters for the given table.
 * 
 * @param table The table
 * @return The parameters
 */
public Map getParametersFor(Table table)
{
    ListOrderedMap result       = new ListOrderedMap();
    Map            globalParams = (Map)_parametersPerTable.get(null);
    Map            tableParams  = (Map)_parametersPerTable.get(table.getQualifiedName());

    if (globalParams != null)
    {
        result.putAll(globalParams);
    }
    if (tableParams != null)
    {
        result.putAll(tableParams);
    }
    return result;
}
 

/**
* 
* json转换map.
* <br>详细说明
* @param jsonStr json字符串
* @return
* @return Map<String,Object> 集合
* @throws
* @author slj
*/
public static Map<String, Object> parseJSON2Map(String jsonStr) {
	ListOrderedMap map = new ListOrderedMap();
	// System.out.println(jsonStr);
	// 最外层解析
	JSONObject json = JSONObject.fromObject(jsonStr);
	for (Object k : json.keySet()) {
		Object v = json.get(k);
		// 如果内层还是数组的话，继续解析
		if (v instanceof JSONArray) {
			List<Map<String, Object>> list = new ArrayList<Map<String, Object>>();
			Iterator<JSONObject> it = ((JSONArray) v).iterator();
			while (it.hasNext()) {
				JSONObject json2 = it.next();
				list.add(parseJSON2Map(json2.toString()));
			}
			map.put(k.toString(), list);
		} else {
			map.put(k.toString(), v);
		}
	}
	return map;
}
 

@SuppressWarnings("unchecked")
protected Map<String, Object> reorderJsonAttributes(Map<String, Object> jsonMap) {

    ListOrderedMap orderedJsonMap = new ListOrderedMap();
    orderedJsonMap.putAll(jsonMap);

    Object context = orderedJsonMap.get(JSONLDConstants.ATTRIBUTE_CONTEXT);
    if (context != null) {
        orderedJsonMap.remove(JSONLDConstants.ATTRIBUTE_CONTEXT);
        orderedJsonMap.put(0, JSONLDConstants.ATTRIBUTE_CONTEXT, context);
    }

    return orderedJsonMap;
}
 

static List<Map<String, Object>> transformToIndex(Collection<Map<String, Object>> v, int columnIndex) {
  List<Map<String, Object>> result = new ArrayList<>();
  for (Map<String, Object> item : v) {
    ListOrderedMap listOrderedMap = new ListOrderedMap();
    listOrderedMap.putAll(item);
    Object key = listOrderedMap.get(columnIndex);
    Object value = listOrderedMap.getValue(columnIndex);
    listOrderedMap.remove(columnIndex);
    listOrderedMap.put(0, key, value);
    result.add(listOrderedMap);
  }
  return result;
}
 

/**
 * Determines the indices for the indicated table.
 * 
 * @param metaData  The database meta data
 * @param tableName The name of the table
 * @return The list of indices
 */
protected Collection readIndices(DatabaseMetaDataWrapper metaData, String tableName) throws SQLException
{
    Map       indices   = new ListOrderedMap();
    ResultSet indexData = null;

    try 
    {
        // GemStone changes BEGIN
        //indexData = metaData.getIndices(metaData.escapeForSearch(tableName), false, false);
      
        //The underlying DatabaseMetaData.getIndexInfo does not take the string pattern,
        //so do not need escape the _, see ticket 44911
        indexData = metaData.getIndices(tableName, false, false);
        // GemStone changes BEGIN
        while (indexData.next())
        {
            Map values = readColumns(indexData, getColumnsForIndex());

            readIndex(metaData, values, indices);
        }
    }
    finally
    {
        closeResultSet(indexData);
    }
    return indices.values();
}
 

/**
 * Retrieves the foreign keys of the indicated table.
 *
 * @param metaData  The database meta data
 * @param tableName The name of the table from which to retrieve FK information
 * @return The foreign keys
 */
protected Collection readForeignKeys(DatabaseMetaDataWrapper metaData, String tableName) throws SQLException
{
    Map       fks    = new ListOrderedMap();
    ResultSet fkData = null;

    try
    {
        // GemStone changes BEGIN
        //fkData = metaData.getForeignKeys(metaData.escapeForSearch(tableName));
      
        //The underlying DatabaseMetaData.getImportedKeys does not take the string pattern,
        //so do not need escape the _, see ticket 44911
        fkData = metaData.getForeignKeys(tableName);
        // GemStone changes BEGIN
        
        while (fkData.next())
        {
            Map values = readColumns(fkData, getColumnsForFK());

            readForeignKey(metaData, values, fks);
        }
    }
    finally
    {
        closeResultSet(fkData);
    }
    return fks.values();
}
 

/**
 * {@inheritDoc}
 */
protected Collection readIndices(DatabaseMetaDataWrapper metaData, String tableName) throws SQLException
{
    // Jaybird is not able to read indices when delimited identifiers are turned on,
    // so we gather the data manually using Firebird's system tables
    final String query =
        "SELECT a.RDB$INDEX_NAME INDEX_NAME, b.RDB$RELATION_NAME TABLE_NAME, b.RDB$UNIQUE_FLAG NON_UNIQUE, " +
        "a.RDB$FIELD_POSITION ORDINAL_POSITION, a.RDB$FIELD_NAME COLUMN_NAME, 3 INDEX_TYPE " +
        "FROM RDB$INDEX_SEGMENTS a, RDB$INDICES b WHERE a.RDB$INDEX_NAME=b.RDB$INDEX_NAME AND b.RDB$RELATION_NAME = ?";

    Map               indices = new ListOrderedMap();
    PreparedStatement stmt    = null;

    try
    {
        stmt = getConnection().prepareStatement(query);

        stmt.setString(1, getPlatform().isDelimitedIdentifierModeOn() ? tableName : tableName.toUpperCase());

        ResultSet indexData = stmt.executeQuery();

        while (indexData.next())
        {
            Map values = readColumns(indexData, getColumnsForIndex());

            // we have to reverse the meaning of the unique flag; also, null means false
            values.put("NON_UNIQUE", (values.get("NON_UNIQUE") == null) || Boolean.FALSE.equals(values.get("NON_UNIQUE")) ? Boolean.TRUE : Boolean.FALSE);
            // and trim the names
            values.put("INDEX_NAME",  ((String)values.get("INDEX_NAME")).trim());
            values.put("TABLE_NAME",  ((String)values.get("TABLE_NAME")).trim());
            values.put("COLUMN_NAME", ((String)values.get("COLUMN_NAME")).trim());
            readIndex(metaData, values, indices);
        }
    }
    finally
    {
        closeStatement(stmt);
    }
    return indices.values();
}
 

/**
 * {@inheritDoc}
 */
protected Collection readIndices(DatabaseMetaDataWrapper metaData, String tableName) throws SQLException
{
    // Jaybird is not able to read indices when delimited identifiers are turned on,
    // so we gather the data manually using Firebird's system tables
    final String query =
        "SELECT a.RDB$INDEX_NAME INDEX_NAME, b.RDB$RELATION_NAME TABLE_NAME, b.RDB$UNIQUE_FLAG NON_UNIQUE, " +
        "a.RDB$FIELD_POSITION ORDINAL_POSITION, a.RDB$FIELD_NAME COLUMN_NAME, 3 INDEX_TYPE " +
        "FROM RDB$INDEX_SEGMENTS a, RDB$INDICES b WHERE a.RDB$INDEX_NAME=b.RDB$INDEX_NAME AND b.RDB$RELATION_NAME = ?";

    Map               indices = new ListOrderedMap();
    PreparedStatement stmt    = null;

    try
    {
        stmt = getConnection().prepareStatement(query);

        stmt.setString(1, getPlatform().isDelimitedIdentifierModeOn() ? tableName : tableName.toUpperCase());

        ResultSet indexData = stmt.executeQuery();

        while (indexData.next())
        {
            Map values = readColumns(indexData, getColumnsForIndex());

            // we have to reverse the meaning of the unique flag; also, null means false
            values.put("NON_UNIQUE", (values.get("NON_UNIQUE") == null) || Boolean.FALSE.equals(values.get("NON_UNIQUE")) ? Boolean.TRUE : Boolean.FALSE);
            // and trim the names
            values.put("INDEX_NAME",  ((String)values.get("INDEX_NAME")).trim());
            values.put("TABLE_NAME",  ((String)values.get("TABLE_NAME")).trim());
            values.put("COLUMN_NAME", ((String)values.get("COLUMN_NAME")).trim());
            readIndex(metaData, values, indices);
        }
    }
    finally
    {
        closeStatement(stmt);
    }
    return indices.values();
}
 

private void testSortListBeans() {

        ListOrderedMap properties = new ListOrderedMap();
        // properties.put("name", true);
        properties.put("name", false);
        //properties.put("passwd", false);


        UserBean beanEntity1 = new UserBean();
        beanEntity1.setName("jiang");
        beanEntity1.setPasswd("jiang password");

        UserBean beanEntity2 = new UserBean();
        beanEntity2.setName("hui");
        beanEntity2.setPasswd("hui password");

        UserBean beanEntity3 = new UserBean();
        beanEntity3.setName("123");
        beanEntity3.setPasswd("123 password");

        ArrayList<UserBean> alist = new ArrayList();
        alist.add(beanEntity1);
        alist.add(beanEntity2);
        alist.add(beanEntity3);

        sortListBeans(alist, properties);

        for (UserBean bean : alist) {
            System.out.println("name =" + bean.getName() + ", passwd =" + bean.getPasswd());
        }

    }
 

/**
 * Determines the indices for the indicated table.
 * 
 * @param metaData  The database meta data
 * @param tableName The name of the table
 * @return The list of indices
 */
protected Collection readIndices(DatabaseMetaDataWrapper metaData, String tableName) throws SQLException
{
    Map       indices   = new ListOrderedMap();
    ResultSet indexData = null;

    try 
    {
        // GemStone changes BEGIN
        //indexData = metaData.getIndices(metaData.escapeForSearch(tableName), false, false);
      
        //The underlying DatabaseMetaData.getIndexInfo does not take the string pattern,
        //so do not need escape the _, see ticket 44911
        indexData = metaData.getIndices(tableName, false, false);
        // GemStone changes BEGIN
        while (indexData.next())
        {
            Map values = readColumns(indexData, getColumnsForIndex());

            readIndex(metaData, values, indices);
        }
    }
    finally
    {
        closeResultSet(indexData);
    }
    return indices.values();
}
 

/**
 * Retrieves the foreign keys of the indicated table.
 *
 * @param metaData  The database meta data
 * @param tableName The name of the table from which to retrieve FK information
 * @return The foreign keys
 */
protected Collection readForeignKeys(DatabaseMetaDataWrapper metaData, String tableName) throws SQLException
{
    Map       fks    = new ListOrderedMap();
    ResultSet fkData = null;

    try
    {
        // GemStone changes BEGIN
        //fkData = metaData.getForeignKeys(metaData.escapeForSearch(tableName));
      
        //The underlying DatabaseMetaData.getImportedKeys does not take the string pattern,
        //so do not need escape the _, see ticket 44911
        fkData = metaData.getForeignKeys(tableName);
        // GemStone changes BEGIN
        
        while (fkData.next())
        {
            Map values = readColumns(fkData, getColumnsForFK());

            readForeignKey(metaData, values, fks);
        }
    }
    finally
    {
        closeResultSet(fkData);
    }
    return fks.values();
}
 

/**
 * Writes a statement that copies the data from the source to the target table. Note
 * that this copies only those columns that are in both tables.
 * Database-specific implementations might redefine this method though it usually
 * suffices to redefine the {@link #writeCastExpression(Column, Column)} method.
 * 
 * @param sourceTable The source table
 * @param targetTable The target table
 */
protected void copyData(Table sourceTable, Table targetTable) throws IOException
{
    ListOrderedMap columns = new ListOrderedMap();

    for (int idx = 0; idx < sourceTable.getColumnCount(); idx++)
    {
        Column sourceColumn = sourceTable.getColumn(idx);
        Column targetColumn = targetTable.findColumn(sourceColumn.getName(),
                                                     getPlatform().isDelimitedIdentifierModeOn());


        if (targetColumn != null)
        {
            columns.put(sourceColumn, targetColumn);
        }
    }

    print("INSERT INTO ");
    printIdentifier(getTableName(targetTable));
    print(" (");
    for (Iterator columnIt = columns.keySet().iterator(); columnIt.hasNext();)
    {
        printIdentifier(getColumnName((Column)columnIt.next()));
        if (columnIt.hasNext())
        {
            print(",");
        }
    }
    print(") SELECT ");
    for (Iterator columnsIt = columns.entrySet().iterator(); columnsIt.hasNext();)
    {
        Map.Entry entry = (Map.Entry)columnsIt.next();

        writeCastExpression((Column)entry.getKey(),
                            (Column)entry.getValue());
        if (columnsIt.hasNext())
        {
            print(",");
        }
    }
    print(" FROM ");
    printIdentifier(getTableName(sourceTable));
    printEndOfStatement();
}
 

/**
 * {@inheritDoc}
 */
protected Table readTable(DatabaseMetaDataWrapper metaData, Map values) throws SQLException
{
    // Mckoi does not currently return unique indices in the metadata so we have to query
    // internal tables to get this info
    final String query =
        "SELECT uniqueColumns.column, uniqueColumns.seq_no, uniqueInfo.name" +
        " FROM SYS_INFO.sUSRUniqueColumns uniqueColumns, SYS_INFO.sUSRUniqueInfo uniqueInfo" +
        " WHERE uniqueColumns.un_id = uniqueInfo.id AND uniqueInfo.table = ?";
    final String queryWithSchema =
        query + " AND uniqueInfo.schema = ?";

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

    if (table != null)
    {
        Map               indices = new ListOrderedMap();
        PreparedStatement stmt    = null;

        try
        {
            stmt = getConnection().prepareStatement(table.getSchema() == null ? query : queryWithSchema);
            stmt.setString(1, table.getName());
            if (table.getSchema() != null)
            {
                stmt.setString(2, table.getSchema());
            }

            ResultSet  resultSet   = stmt.executeQuery();
            Map        indexValues = new HashMap();
        
            indexValues.put("NON_UNIQUE", Boolean.FALSE);
            while (resultSet.next())
            {
                indexValues.put("COLUMN_NAME",      resultSet.getString(1));
                indexValues.put("ORDINAL_POSITION", Short.valueOf(resultSet.getShort(2)));
                indexValues.put("INDEX_NAME",       resultSet.getString(3));
        
                readIndex(metaData, indexValues, indices);
            }
        }
        finally
        {
            closeStatement(stmt);
        }
    
        table.addIndices(indices.values());
    }
    
    return table;
}
 

/**
    * {@inheritDoc}
    */
protected Collection readIndices(DatabaseMetaDataWrapper metaData, String tableName) throws SQLException
{
	// Oracle has a bug in the DatabaseMetaData#getIndexInfo method which fails when
	// delimited identifiers are being used
	// Therefore, we're rather accessing the user_indexes table which contains the same info
	// This also allows us to filter system-generated indices which are identified by either
       // having GENERATED='Y' in the query result, or by their index names being equal to the
       // name of the primary key of the table

	final String query =
	    "SELECT a.INDEX_NAME, a.INDEX_TYPE, a.UNIQUENESS, b.COLUMN_NAME, b.COLUMN_POSITION FROM USER_INDEXES a, USER_IND_COLUMNS b WHERE " +
	    "a.TABLE_NAME=? AND a.GENERATED=? AND a.TABLE_TYPE=? AND a.TABLE_NAME=b.TABLE_NAME AND a.INDEX_NAME=b.INDEX_NAME AND " +
	    "a.INDEX_NAME NOT IN (SELECT DISTINCT c.CONSTRAINT_NAME FROM USER_CONSTRAINTS c WHERE c.CONSTRAINT_TYPE=? AND c.TABLE_NAME=a.TABLE_NAME)";
	final String queryWithSchema =
	    query.substring(0, query.length() - 1) + " AND c.OWNER LIKE ?) AND a.TABLE_OWNER LIKE ?";

       Map               indices = new ListOrderedMap();
	PreparedStatement stmt    = null;

       try
       {
   		stmt = getConnection().prepareStatement(metaData.getSchemaPattern() == null ? query : queryWithSchema);
   		stmt.setString(1, getPlatform().isDelimitedIdentifierModeOn() ? tableName : tableName.toUpperCase());
   		stmt.setString(2, "N");
   		stmt.setString(3, "TABLE");
           stmt.setString(4, "P");
   		if (metaData.getSchemaPattern() != null)
   		{
   			stmt.setString(5, metaData.getSchemaPattern().toUpperCase());
               stmt.setString(6, metaData.getSchemaPattern().toUpperCase());
   		}

   		ResultSet rs     = stmt.executeQuery();
       	Map       values = new HashMap();

       	while (rs.next())
       	{
       		values.put("INDEX_NAME",       rs.getString(1));
       		values.put("INDEX_TYPE",       Short.valueOf(DatabaseMetaData.tableIndexOther));
       		values.put("NON_UNIQUE",       "UNIQUE".equalsIgnoreCase(rs.getString(3)) ? Boolean.FALSE : Boolean.TRUE);
       		values.put("COLUMN_NAME",      rs.getString(4));
       		values.put("ORDINAL_POSITION", Short.valueOf(rs.getShort(5)));

       		readIndex(metaData, values, indices);
       	}
       }
       finally
       {
           closeStatement(stmt);
       }
	return indices.values();
}
 

/**
    * {@inheritDoc}
    */
protected Collection readIndices(DatabaseMetaDataWrapper metaData, String tableName) throws SQLException
{
	// Oracle has a bug in the DatabaseMetaData#getIndexInfo method which fails when
	// delimited identifiers are being used
	// Therefore, we're rather accessing the user_indexes table which contains the same info
	// This also allows us to filter system-generated indices which are identified by either
       // having GENERATED='Y' in the query result, or by their index names being equal to the
       // name of the primary key of the table

	final String query =
	    "SELECT a.INDEX_NAME, a.INDEX_TYPE, a.UNIQUENESS, b.COLUMN_NAME, b.COLUMN_POSITION FROM USER_INDEXES a, USER_IND_COLUMNS b WHERE " +
	    "a.TABLE_NAME=? AND a.GENERATED=? AND a.TABLE_TYPE=? AND a.TABLE_NAME=b.TABLE_NAME AND a.INDEX_NAME=b.INDEX_NAME AND " +
	    "a.INDEX_NAME NOT IN (SELECT DISTINCT c.CONSTRAINT_NAME FROM USER_CONSTRAINTS c WHERE c.CONSTRAINT_TYPE=? AND c.TABLE_NAME=a.TABLE_NAME)";
	final String queryWithSchema =
	    query.substring(0, query.length() - 1) + " AND c.OWNER LIKE ?) AND a.TABLE_OWNER LIKE ?";

       Map               indices = new ListOrderedMap();
	PreparedStatement stmt    = null;

       try
       {
   		stmt = getConnection().prepareStatement(metaData.getSchemaPattern() == null ? query : queryWithSchema);
   		stmt.setString(1, getPlatform().isDelimitedIdentifierModeOn() ? tableName : tableName.toUpperCase());
   		stmt.setString(2, "N");
   		stmt.setString(3, "TABLE");
           stmt.setString(4, "P");
   		if (metaData.getSchemaPattern() != null)
   		{
   			stmt.setString(5, metaData.getSchemaPattern().toUpperCase());
               stmt.setString(6, metaData.getSchemaPattern().toUpperCase());
   		}

   		ResultSet rs     = stmt.executeQuery();
       	Map       values = new HashMap();

       	while (rs.next())
       	{
       		values.put("INDEX_NAME",       rs.getString(1));
       		values.put("INDEX_TYPE",       Short.valueOf(DatabaseMetaData.tableIndexOther));
       		values.put("NON_UNIQUE",       "UNIQUE".equalsIgnoreCase(rs.getString(3)) ? Boolean.FALSE : Boolean.TRUE);
       		values.put("COLUMN_NAME",      rs.getString(4));
       		values.put("ORDINAL_POSITION", Short.valueOf(rs.getShort(5)));

       		readIndex(metaData, values, indices);
       	}
       }
       finally
       {
           closeStatement(stmt);
       }
	return indices.values();
}
 

/**
 * {@inheritDoc}
 */
protected Table readTable(DatabaseMetaDataWrapper metaData, Map values) throws SQLException
{
    // Mckoi does not currently return unique indices in the metadata so we have to query
    // internal tables to get this info
    final String query =
        "SELECT uniqueColumns.column, uniqueColumns.seq_no, uniqueInfo.name" +
        " FROM SYS_INFO.sUSRUniqueColumns uniqueColumns, SYS_INFO.sUSRUniqueInfo uniqueInfo" +
        " WHERE uniqueColumns.un_id = uniqueInfo.id AND uniqueInfo.table = ?";
    final String queryWithSchema =
        query + " AND uniqueInfo.schema = ?";

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

    if (table != null)
    {
        Map               indices = new ListOrderedMap();
        PreparedStatement stmt    = null;

        try
        {
            stmt = getConnection().prepareStatement(table.getSchema() == null ? query : queryWithSchema);
            stmt.setString(1, table.getName());
            if (table.getSchema() != null)
            {
                stmt.setString(2, table.getSchema());
            }

            ResultSet  resultSet   = stmt.executeQuery();
            Map        indexValues = new HashMap();
        
            indexValues.put("NON_UNIQUE", Boolean.FALSE);
            while (resultSet.next())
            {
                indexValues.put("COLUMN_NAME",      resultSet.getString(1));
                indexValues.put("ORDINAL_POSITION", Short.valueOf(resultSet.getShort(2)));
                indexValues.put("INDEX_NAME",       resultSet.getString(3));
        
                readIndex(metaData, indexValues, indices);
            }
        }
        finally
        {
            closeStatement(stmt);
        }
    
        table.addIndices(indices.values());
    }
    
    return table;
}
 

/**
 * Writes a statement that copies the data from the source to the target table. Note
 * that this copies only those columns that are in both tables.
 * Database-specific implementations might redefine this method though it usually
 * suffices to redefine the {@link #writeCastExpression(Column, Column)} method.
 * 
 * @param sourceTable The source table
 * @param targetTable The target table
 */
protected void copyData(Table sourceTable, Table targetTable) throws IOException
{
    ListOrderedMap columns = new ListOrderedMap();

    for (int idx = 0; idx < sourceTable.getColumnCount(); idx++)
    {
        Column sourceColumn = sourceTable.getColumn(idx);
        Column targetColumn = targetTable.findColumn(sourceColumn.getName(),
                                                     getPlatform().isDelimitedIdentifierModeOn());


        if (targetColumn != null)
        {
            columns.put(sourceColumn, targetColumn);
        }
    }

    print("INSERT INTO ");
    printIdentifier(getTableName(targetTable));
    print(" (");
    for (Iterator columnIt = columns.keySet().iterator(); columnIt.hasNext();)
    {
        printIdentifier(getColumnName((Column)columnIt.next()));
        if (columnIt.hasNext())
        {
            print(",");
        }
    }
    print(") SELECT ");
    for (Iterator columnsIt = columns.entrySet().iterator(); columnsIt.hasNext();)
    {
        Map.Entry entry = (Map.Entry)columnsIt.next();

        writeCastExpression((Column)entry.getKey(),
                            (Column)entry.getValue());
        if (columnsIt.hasNext())
        {
            print(",");
        }
    }
    print(" FROM ");
    printIdentifier(getTableName(sourceTable));
    printEndOfStatement();
}
 

/**
 * Returns a map that maintains the order of keys that are added
 * backed by the given map.
 * <p>
 * If a key is added twice, the order is determined by the first add.
 * The order is observed through the keySet, values and entrySet.
 *
 * @param map  the map to order, must not be null
 * @return an ordered map backed by the given map
 * @throws IllegalArgumentException  if the Map is null
 */
public static Map orderedMap(Map map) {
    return ListOrderedMap.decorate(map);
}