scriptella.driver.csv

1.	6.0 JDK Core
2.	6.0 JDK Modules
3.	6.0 JDK Modules com.sun
4.	6.0 JDK Modules com.sun.java
5.	6.0 JDK Modules sun
6.	6.0 JDK Platform
7.	Ajax
8.	Apache Harmony Java SE
9.	Aspect oriented
10.	Authentication Authorization
11.	Blogger System
12.	Build
13.	Byte Code
14.	Cache
15.	Chart
16.	Chat
17.	Code Analyzer
18.	Collaboration
19.	Content Management System
20.	Database Client
21.	Database DBMS
22.	Database JDBC Connection Pool
23.	Database ORM
24.	Development
25.	EJB Server
26.	ERP CRM Financial
27.	ESB
28.	Forum
29.	Game
30.	GIS
31.	Graphic 3D
32.	Graphic Library
33.	Groupware
34.	HTML Parser
35.	IDE
36.	IDE Eclipse
37.	IDE Netbeans
38.	Installer
39.	Internationalization Localization
40.	Inversion of Control
41.	Issue Tracking
42.	J2EE
43.	J2ME
44.	JBoss
45.	JMS
46.	JMX
47.	Library
48.	Mail Clients
49.	Music
50.	Natural Language Processing
51.	Net
52.	Parser
53.	PDF
54.	Portal
55.	Profiler
56.	Project Management
57.	Report
58.	RSS RDF
59.	Rule Engine
60.	Science
61.	Scripting
62.	Search Engine
63.	Security
64.	Sevlet Container
65.	Source Control
66.	Swing Library
67.	Template Engine
68.	Test Coverage
69.	Testing
70.	UML
71.	Web Crawler
72.	Web Framework
73.	Web Mail
74.	Web Server
75.	Web Services
76.	Web Services apache cxf 2.2.6
77.	Web Services AXIS2
78.	Wiki Engine
79.	Workflow Engines
80.	XML
81.	XML UI

Java Source Code / Java Documentation » Scripting » scriptella » scriptella.driver.csv

CSV Driver for Scriptella.

The driver to write and query CSV files.

Note: The driver doesn't use SQL syntax

General information

Driver class:	`scriptella.driver.csv.Driver`
URL:	`CSV file URL. URIs are resolved relative to a script file directory. If url has no value the output is read from/printed to the console (System.out).`
Runtime dependencies:	`opencsv-1.6+.jar`

Driver Specific Properties

Name	Description	Required
encoding	Specifies charset encoding of CSV files.	No, the system default encoding is used.
separator	The delimiter to use for separating entries when reading from or writing to files.	No, the default value is `,`.
quote	The character to use for quoted elements when reading from or writing to files. Use empty string to suppress quoting.	No, the default value is `"`.
headers	Value of true means the first line contains headers. Only valid for <query> elements.	No, the default value is `true`(first line contains column names).
eol	End-Of-Line suffix. Only valid for <script> elements.	No, the default value is `\n`.
trim	Value of `true` specifies that the leading and trailing whitespaces in CSV fields should be omitted.	No, the default value is `true`.
skip_lines	The number of lines to skip before start reading. Please note that if `headers=true`, the actual number of skipped lines is `skipped_lines+1`	No, the default value is `0` (no lines are skipped).
null_string	Specifies value of a string token to be parsed as Java `null` literal.	No, by default strings are preserved, i.e. empty CSV field is parsed as empty string.

Query Syntax

The driver utilizes query by example approach for CSV content filtering. If you want to read the whole CSV simply use empty query element, otherwise specify a set of lines containing comma-separated case insensitive regular expressions.
Example:


    ,food
,^Beverages$

This query selects rows where the second column equals "Beverages" or contains "food" substring.

The columns of the matched row can be referenced by name in nested queries/scripts. It is also possible to reference columns by an index, i.e. $1, $2, ...

Script Syntax

The script syntax is simple, just specify a comma-separated set of columns.
Example:


    <script>
id,priority,summary,status
1,Critical,NullPointerException in Main class,Open
</script>

This script writes 2 lines to the output file.

IMPORTANT: Always use commas as a column separator inside both <script> and <query> elements no matter what separator is used in files being parsed or produced. This decision allows switching between different formats like tab or semicolumn while keeping scripts and queries unchanged.

Properties substitution

In CSV script and query elements use ${property} syntax for properties/variables substition.

Examples

<connection id="in" driver="csv" url="data.csv" classpath="lib/opencsv.jar">

</connection>
<connection id="out" driver="csv" url="report.csv" classpath="lib/opencsv.jar">
    #Use empty quote to turn off quoting
    quote=
    separator=;
</connection>

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

<query connection-id="in">
    <!--Empty query means select all-->
    <script connection-id="out">
        $rownum,$priority,$summary,$status
    </script>
</query>

Copies rows from data.csv file to report.csv, additionally the ID column is added. The result file will be semicolon separated.

Java Source File Name Type Comment

CsvConnection.java Class Represents a connection to CSV file.

CsvConnectionPerfTest.java Class Tests for scriptella.driver.csv.CsvConnection .

CsvConnectionTest.java Class Tests for CsvConnection .

CsvProviderException.java Class Thrown to indicate a problem with CSV file processing.

CsvQuery.java Class Query for CSV file.

CsvQueryTest.java Class Tests for CsvQuery .

CsvScriptTest.java Class Tests CSV script processing.

Driver.java Class Scriptella driver for CSV files.

ww__w___.jav___a2__s_.__c__o_m_ | Contact Us

All other trademarks are property of their respective owners.