Text Driver for Scriptella.

Text driver does depends on additional libraries and is generally faster than CSV or Velocity driver.

Note: The driver doesn't use SQL syntax

General information

Driver Specific Properties

Query Syntax

If a line or a part of it matches the pattern this match produces a virtual row in a result set. The column names in a virtual result set correspond to matched regex group names. For example query foo(.*) matches foobar line and the produced result set row contains two columns(groups): 0-foobar, 1-bar. These columns can be referenced in child script or query elements by a numeric name or by a string name columnN.

It also possible to specify more than one regular expressions to match file content. Specify each regular expression on a separate line to match them using OR condition.

The Text driver uses java.util.regex implementation for pattern matching. See java.util.Pattern for supported syntax Javadoc.

Additional notes:

• Regular expressions matching is case-insensitive
• Empty query selects all lines from the input file.
• The 0(zero) column name in the produced result set contains the matched line.
• Leading and trailing whitespaces in query element and input file lines are trimmed by default.
• Use ^ and $ boundary matchers to match the whole line.

<query>
  ^ERROR: (.*)
  WARNING: (.*Failed.*)
  ([\d]+) errors?
</query>
    

1. selects lines starting with ERROR: prefix
2. selects WARNING lines having Failed substring
3. selects lines containg a number of errors, e.g. "Found 5 errors".

Log file started...
INFO: INIT
WARNING: CPU is slow
WARNING: Failed to increase heap size
ERROR: Process interrupted
Operation completed with 1 error.

Script Syntax

Additional notes:

• Lines in the outputted file are separated by a EOL string specified by eol connection property.
• Leading and trailing whitespaces in the output file lines are trimmed by default.
• No escaping is performed when properties are expanded. Use String.replace or other escaping techniques to achieve output similar to CSV etc.
• If a script is executed multiple times (e.g. inside a parent query) the output is appended to the file content.

<script>
    Inserted a record with ID=$id. Table=${table}
</script>
    

Inserted a record with ID=1. Table=system
    

Properties substitution

Examples

<connection id="in" driver="text" url="data.csv">
</connection>
<connection id="out" driver="text" url="report.csv">
</connection>

<script connection-id="out">
    ID;Priority;Summary;Status
</script>

<query connection-id="in">
    <script connection-id="out">
        $rownum;$column0;$column1;$column2
    </script>
</query>

TODO: Move this class to a spi.support.text package.

This class is a simplified template engine similar to Velocity, but of course less powerful.