kettle转换中使用javascript例子整理（1）

墨蓝 2022-01-20 03:39 898阅读 0赞

转自： [https://blog.csdn.net/man\_earth/article/details/39525651][https_blog.csdn.net_man_earth_article_details_39525651]

Kettle (5) - 获取 Web 数据:  [https://blog.csdn.net/stone0823/article/details/78823052][https_blog.csdn.net_stone0823_article_details_78823052]

码云：[https://gitee.com/liuxiaogang1987/kettle][https_gitee.com_liuxiaogang1987_kettle]

[Kettle (5) - 获取 Web 数据][Kettle _5_ - _ Web]： [https://www.cnblogs.com/guohu/p/10721196.html][Kettle _5_ - _ Web]

在web中集成kettle: [http://www.360doc.com/content/14/1102/11/1180274\_421875421.shtml][http_www.360doc.com_content_14_1102_11_1180274_421875421.shtml]

Kettle的Web版分享： [https://www.oschina.net/question/2615834\_2149419][https_www.oschina.net_question_2615834_2149419]

[Kettle(Pentaho)实现web方式远程执行job或transformation][Kettle_Pentaho_web_job_transformation]：[https://www.cnblogs.com/John-Young/p/6349252.html][Kettle_Pentaho_web_job_transformation]

kettle调度监控最佳实践： [https://blog.csdn.net/maenlai0086/article/details/80586538][https_blog.csdn.net_maenlai0086_article_details_80586538]

kettle源码安装及Spoon启动界面修改:  [https://blog.csdn.net/w864518106/article/details/77773569][https_blog.csdn.net_w864518106_article_details_77773569]

这些例子在（\\data-integration\\samples\\transformations目录下）

1 JavaScript - Access database connection metadata.ktr（访问数据库连接）

var db = \_step\_.getTransMeta().findDatabase("db\_mysql\_etltest\_repository\_4.2");//db\_mysql\_etltest\_repository\_4.2,是自己起的名字，是在数据库连接的时候连接名

var url = db.getURL();

var hostname = db.getHostname();

文本文件中的输出：

url：jdbc:mysql://localhost:3306/etltest\_repository4\_2?defaultFetchSize=500&useCursorFetch=true

hostname：localhost

2 JavaScript - Access environment variables.ktr（访问环境变量，参数与变量相同）

var v1 = getVariable("VAR1", "啊啊啊啊");//第二个参数表示为空时默认取值

var v2 = getVariable("java.io.tmpdir", "");

文本文件输出

v1@v2

呵呵@C:\\Users\\ADMINI~1\\AppData\\Local\\Temp\\

3 JavaScript - Add 2 and a half seconds to a Date.ktr（时间相加）

var thenInt = now.getInteger()+2500;//ms

var then = newjava.util.Date( thenInt );

文本文件输出：

now@thenInt@then

2014/09/23 14:09:40.653@ 1411452583153@2014/09/23 14:09:43.153

4 JavaScript - Base64 Decoder and Encoder.ktr（64位解码、编码）

var bytes = Packages.org.apache.commons.codec.binary.Base64.decodeBase64( F1.getString().getBytes() );

var decString =new Packages.java.lang.String( bytes );//64位解码器

//编码器

var encString =new Packages.java.lang.String( Packages.org.apache.commons.codec.binary.Base64.encodeBase64( decString.getBytes() ) );

文本文件输出：

F1@decString@bytes@encString

VGV4dCBmaWxlIGlucHV0  @Text file input  @"\[B@43e76d"@VGV4dCBmaWxlIGlucHV0

5 （重）JavaScript -create new rows.ktr（创建新的行）

if (groupsField!=null)

var groups = groupsField.split(",");

for (i=0;i<groups.length;i++)

newRow = createRowCopy(getOutputRowMeta().size());//新的一行，输出的列数

var rowIndex = getInputRowMeta().size();//输入的列数

newRow\[rowIndex++\] = trim( groups\[i\] );//对应列的值

newRow\[rowIndex++\] = "N";

putRow(newRow);//输出该行

var subgroup = "";//对应上面的列名

var ignore = "Y";//对应上面的列名

文本文件输出：

member@groupsField@subgroup@ignore

Member 2 @Group1, Group2                @Group1@N

Member 2 @Group1, Group2                @Group2@N

Member 1 @Group1, Group2, Group3, Group4  @Group1@N

Member 1 @Group1, Group2, Group3, Group4  @Group2@N

Member 1 @Group1, Group2, Group3, Group4  @Group3@N

Member 1 @Group1, Group2, Group3, Group4  @Group4@N

6 JavaScript - date to string conversion.ktr（日期->字符串）

var datString =date2str(datOriginal, "yyyy\*\*MM\*\*dd hh&&mm&&ss\#SSS");

// other date formats can be found in the manual searching for "date formats"

// remeber to change to length below of datString if you change the format

文本文件输出：

datOriginal@datString

2007/01/27 00:00:00.000@2007\*\*01\*\*27 12&&00&&00\#000

\---------------------   
作者：不知不觉地   
来源：CSDN   
原文：https://blog.csdn.net/man\_earth/article/details/39525651   
版权声明：本文为博主原创文章，转载请附上博文链接！

[https_blog.csdn.net_man_earth_article_details_39525651]: https://blog.csdn.net/man_earth/article/details/39525651
[https_blog.csdn.net_stone0823_article_details_78823052]: https://blog.csdn.net/stone0823/article/details/78823052
[https_gitee.com_liuxiaogang1987_kettle]: https://gitee.com/liuxiaogang1987/kettle
[Kettle _5_ - _ Web]: https://www.cnblogs.com/guohu/p/10721196.html
[http_www.360doc.com_content_14_1102_11_1180274_421875421.shtml]: http://www.360doc.com/content/14/1102/11/1180274_421875421.shtml
[https_www.oschina.net_question_2615834_2149419]: https://www.oschina.net/question/2615834_2149419
[Kettle_Pentaho_web_job_transformation]: https://www.cnblogs.com/John-Young/p/6349252.html
[https_blog.csdn.net_maenlai0086_article_details_80586538]: https://blog.csdn.net/maenlai0086/article/details/80586538
[https_blog.csdn.net_w864518106_article_details_77773569]: https://blog.csdn.net/w864518106/article/details/77773569