kettle工具坐mysql数据迁移_Kettle实现数据库迁移

5、入库表结构创建

执行的Java代码如下

public boolean processRow(StepMetaInterface smi, StepDataInterface sdi) throws KettleException

{

// First, get a row from the default input hop

Object[] r = getRow();

org.pentaho.di.core.database.DatabaseMeta dbmeta = null;

System.out.println(123);

System.out.println( getTrans().getRepository());

System.out.println(456);

java.util.List list = getTrans().getRepository().readDatabases();

if(list != null && !list.isEmpty())

{

for(int i=0;i

{

dbmeta = (org.pentaho.di.core.database.DatabaseMeta)list.get(i);

//test1 为数据库名称

if("test1".equalsIgnoreCase(dbmeta.getName()))

{

break;

}

}

}

if(dbmeta!=null)

{

org.pentaho.di.core.database.Database db=new org.pentaho.di.core.database.Database(dbmeta);

try

{

db.connect();

String tablename = getVariable("TABLENAME");

logBasic("开始创建表：" + tablename);

if(tablename!=null && tablename.trim().length()>0)

{

String sql = db.getDDLCreationTable(tablename, data.inputRowMeta);//${TABLENAME}

db.execStatement(sql.replace(";", ""));

logBasic(sql);

}

}

catch(Exception e)

{

logError("创建表出现异常",e);

}finally{

db.disconnect();

}

}

return false;

}

6、表数据抽取流程