/*
* Copyright (C) 2010-2101 Alibaba Group Holding Limited.
*
* Licensed under the Apache License, Version 2.0 (the "License");
* you may not use this file except in compliance with the License.
* You may obtain a copy of the License at
*
* http://www.apache.org/licenses/LICENSE-2.0
*
* Unless required by applicable law or agreed to in writing, software
* distributed under the License is distributed on an "AS IS" BASIS,
* WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
* See the License for the specific language governing permissions and
* limitations under the License.
*/
package com.alibaba.otter.node.etl.common.db;
import org.apache.ddlutils.model.Column;
import org.apache.ddlutils.model.Table;
import org.jtester.annotations.SpringBeanByName;
import org.testng.annotations.Test;
import com.alibaba.otter.node.etl.BaseDbTest;
import com.alibaba.otter.node.etl.common.db.dialect.DbDialect;
import com.alibaba.otter.node.etl.common.db.dialect.DbDialectFactory;
import com.alibaba.otter.shared.common.model.config.data.db.DbDataMedia;
/**
* 测试下table表的获取操作
*
* @author jianghang 2012-4-20 下午04:56:43
* @version 4.0.2
*/
public class DbDialectTableTest extends BaseDbTest {
@SpringBeanByName
private DbDialectFactory dbDialectFactory;
@Test
public void testMysqlTable() {
DbDataMedia mysqlMedia = getMysqlMedia();
DbDialect dbDialect = dbDialectFactory.getDbDialect(1L, mysqlMedia.getSource());
Table table = dbDialect.findTable(mysqlMedia.getNamespace(), mysqlMedia.getName());
want.object(table).notNull();
System.out.println("tableName = " + table.getName());
Column[] columns = table.getColumns();
for (Column column : columns) {
System.out.println("columnName = " + column.getName() + ",columnType = " + column.getTypeCode()
+ ",isPrimary = " + column.isPrimaryKey() + ",nullable = " + column.isRequired());
}
}
@Test
public void testOracleTable() {
DbDataMedia oracleMedia = getOracleMedia();
DbDialect dbDialect = dbDialectFactory.getDbDialect(1L, oracleMedia.getSource());
Table table = dbDialect.findTable(oracleMedia.getNamespace(), oracleMedia.getName());
want.object(table).notNull();
System.out.println("tableName = " + table.getName());
Column[] columns = table.getColumns();
for (Column column : columns) {
System.out.println("columnName = " + column.getName() + ",columnType = " + column.getTypeCode()
+ ",isPrimary = " + column.isPrimaryKey() + ",nullable = " + column.isRequired());
}
}
}