Search in sources :

Example 11 with Column

use of org.apache.ddlutils.model.Column in project otter by alibaba.

the class DdlUtils method readColumns.

private static List<Column> readColumns(DatabaseMetaDataWrapper metaData, String tableName) throws SQLException {
    ResultSet columnData = null;
    try {
        columnData = metaData.getColumns(tableName, null);
        List<Column> columns = new ArrayList<Column>();
        Map<String, Object> values = null;
        for (; columnData.next(); columns.add(readColumn(metaData, values))) {
            Map<String, Object> tmp = readColumns(columnData, initColumnsForColumn());
            if (tableName.equalsIgnoreCase((String) tmp.get("TABLE_NAME"))) {
                values = tmp;
            } else {
                break;
            }
        }
        return columns;
    } finally {
        JdbcUtils.closeResultSet(columnData);
    }
}
Also used : Column(org.apache.ddlutils.model.Column) ResultSet(java.sql.ResultSet) ArrayList(java.util.ArrayList)

Aggregations

Column (org.apache.ddlutils.model.Column)11 Table (org.apache.ddlutils.model.Table)8 DbDialect (com.alibaba.otter.node.etl.common.db.dialect.DbDialect)4 ArrayList (java.util.ArrayList)3 Test (org.testng.annotations.Test)3 BaseDbTest (com.alibaba.otter.node.etl.BaseDbTest)2 DbDataMedia (com.alibaba.otter.shared.common.model.config.data.db.DbDataMedia)2 EventColumn (com.alibaba.otter.shared.etl.model.EventColumn)2 EventType (com.alibaba.otter.shared.etl.model.EventType)2 DataSource (javax.sql.DataSource)2 IndexColumn (org.apache.ddlutils.model.IndexColumn)2 JdbcTemplate (org.springframework.jdbc.core.JdbcTemplate)2 ManagerException (com.alibaba.otter.manager.biz.common.exceptions.ManagerException)1 RepeatConfigureException (com.alibaba.otter.manager.biz.common.exceptions.RepeatConfigureException)1 ExtractException (com.alibaba.otter.node.etl.extract.exceptions.ExtractException)1 TransformException (com.alibaba.otter.node.etl.transform.exception.TransformException)1 ConfigException (com.alibaba.otter.shared.common.model.config.ConfigException)1 DataMedia (com.alibaba.otter.shared.common.model.config.data.DataMedia)1 DbMediaSource (com.alibaba.otter.shared.common.model.config.data.db.DbMediaSource)1 Pipeline (com.alibaba.otter.shared.common.model.config.pipeline.Pipeline)1