seansummers
4/27/2015 - 3:35 PM

JEXL looping with Scriptella

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>