Scriptella excel and javascript and database working demo
etl.xml
<!DOCTYPE etl SYSTEM "http://scriptella.javaforge.com/dtd/etl.dtd">
<etl>
<connection id="log" driver="text"/>
<connection id="log2" driver="text"/>
<connection id="out" driver="text" url="data.sql"/>
<connection id="in" driver="csv" url="tjzy.csv"/>
<connection id="script" driver="script"/>
<connection id="db" driver="oracle" url="jdbc:oracle:thin:@9.9.9.9:1528:r0Name" user="UserName"
password="PASSWORD" classpath="$classpath"/>
<!-- use JDK 1.7 change $JAVA_HOME , use IDEA -->
<!-- <query connection-id="script">-->
<!-- <![CDATA[-->
<!-- var daycount = 1;-->
<!-- for (var i = 0; i < 60; i++) {-->
<!-- daycount=i;-->
<!-- query.next(); //Executes a child script element-->
<!-- }]]>-->
<!-- <script connection-id="log">-->
<!-- </script>-->
<!-- </query>-->
<query connection-id="in">
<query connection-id="db">
SELECT ID FROM SECURITY.SEC_RESOURCE_T WHERE URL = '$URL';
<script connection-id="log2" if="ID != null">
$URL, $ID
</script>
</query>
<script connection-id="out">
-- $PAGE
DELETE FROM SECURITYDATA.SEC_RESOURCE_T WHERE ID = '$RESOURCEID';
INSERT INTO SECURITYDATA.SEC
</script>
<script connection-id="out">
-- $PAGE
DELETE FROM SECURITYDATA.SEC_MEMBER_RESOURCE_PAGE_T WHERE ID = '$RESOURCEPAGEID';
</script>
</query>
</etl>
image.png
