jenkins - 如何传递参数
问题描述
我有一个 jenkins JOb,它正在调用 BAT 文件,其中包含对 As java -jar testrunscripts/SQLWorkbench/sqlworkbench.jar -url=jdbc:as400:/;"translate binary"=true;naming=sql;libraries=; -driver=com.ibm.as400.access.AS400JDBCDriver -username=-password=-driverjar=E:\\\\resources\\lib\\jt400.jar -script='testrunscripts/HISTORYANDNEWDIFF.sql'
1-Jenkins 集成了调用sqlscript(HISTORYANDNEWDIFF.sql)
. 这需要所需的动态表名。
WbExport -file='E:\\TestingDATABASE\\history_XAXPGRFE.csv' -type=text -delimiter=',';
select * from %SOURCE%.XAXPGRFE where XPORIG='JAVAPGM'
如何将参数从 jenkins 管道传递到 bat 文件和 sql 脚本的查询
解决方案
您的问题有点不清楚,但请尝试使用键值对从您的 Jenkins 作业中调用 bat 脚本:
your_bat_script.bat param1=value1
然后在 bat 脚本中使用 -variable 标志调用 SQL Workbench /J 脚本 (HISTORYANDNEWDIFF.sql):
java -jar testrunscripts/SQLWorkbench/sqlworkbench.jar -url=jdbc:as400:/;"translate binary"=true;naming=sql;libraries=; -driver=com.ibm.as400.access.AS400JDBCDriver -username=-password=-driverjar=E:\\resources\lib\jt400.jar -script='testrunscripts/HISTORYANDNEWDIFF.sql -variable %1'
http://www.sql-workbench.net/manual/commandline.html#cmdline-vardef
%1
将包含param1=value1
推荐阅读
- python - Is there a function in Pygame to save a portion of the screen as an image?
- angular - Can't resolve 'numeral' in Angular app model
- c - How can I take a screenshot on Wayland?
- javascript - Why node app is consuming more ram usage even the heap memory is low?
- python - Scheduling jobs using schedule - jobs running multiple times
- python - How can I create a ForeignKey field only shows when author are current user?
- pandas - Pandas Pivot-Table Containing List
- amazon-web-services - 从 aws ssm get-parameter 命令中仅检索一个参数值?
- logging - 如何使用 Serilog 将一个请求中的所有日志消息记录到单个条目
- react-redux - Redux Form on Submit 为 SubmissionError 抛出 Uncaught (in promise)