问ODI 11g逆向工程文件修改

EN

//Created by DI Studio
import ro.ns.odi.proxy.*
import oracle.odi.domain.model.*
import oracle.odi.domain.model.finder.*
import oracle.odi.domain.xrefs.expression.*
import oracle.odi.languages.support.*

IOdiEntityFactory odiFactory=OdiEntityFactory.createInstance(odiInstance)
IOdiBasicTemplate odiTemplate=odiFactory.newOdiTemplate()


String TABLE_NAME="SB_FINANCIALS_NEW_UU" //change with what you need
String MODEL_CODE="FILE" //change with what you need

odiTemplate.executeInTransaction{IOdiCommandContext ctx->

  IOdiEntityManager odiManager=ctx.getSupportingOdiInstance().getTransactionalEntityManager()
  IOdiDataStoreFinder dataStoreFinder=odiManager.getFinder(OdiDataStore)
  OdiDataStore dataStore=dataStoreFinder.findByName(TABLE_NAME,MODEL_CODE)

  assert dataStore!=null : "No data store was found. Please review the model code and data store name" 

  for (OdiColumn column:dataStore.columns){
     println "Analyzing column ${column.name} with type ${column.dataType.name}, length ${column.getLength()} and scale ${column.scale}"

     String dataTypeName=column.dataType.name

     column.fileFieldDescriptor.bytes=4000 //change with what you need
     //column.fileFieldDescriptor?.bytes=3000
     column.length=4000 //change with what you need
     column.dataType.name="String"

     switch(dataTypeName){
      case "String":
        //column.scale=2
        //column.fileFieldDescriptor?.decimalSeparator="x"
        println "--Column Modified"
      break
       case "Numeric":
        //column.scale=2
        //column.fileFieldDescriptor?.decimalSeparator="x"
        println "--Column Modified"
      break

    } 


  }
}