Skip to content

Instantly share code, notes, and snippets.

@seansummers
Last active August 29, 2015 14:20
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save seansummers/1a5514557c8633881ea8 to your computer and use it in GitHub Desktop.
Save seansummers/1a5514557c8633881ea8 to your computer and use it in GitHub Desktop.
JEXL looping with Scriptella
<!DOCTYPE etl SYSTEM "http://scriptella.javaforge.com/dtd/etl.dtd">
<etl>
<description>JEXL looping</description>
<properties><include href="etl.properties"/></properties>
<connection id="jexl" driver="jexl"/>
<connection id="sql" url="$url"/>
<query connection-id="jexl">
fileDir = new('java.io.File', '.' + class:forName('java.io.File').separator + etl.getParameter('directory')).getCanonicalFile();
if (fileDir.isDirectory() eq true)
for (sqlFile : fileDir.listFiles())
query.next();
<script connection-id="sql">
USE [${db}];
<include href="$sqlFile"/>
</script>
</query>
</etl>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment