org.nuxeo.ecm.core.storage.sql.jdbc.dialect

Class SQLStatement

java.lang.Object

org.nuxeo.ecm.core.storage.sql.jdbc.dialect.SQLStatement

public class SQLStatement
extends Object

A SQL statement and some optional tags that condition execution.

Nested Class Summary

Nested Classes

Modifier and Type	Class and Description
static class	SQLStatement.Tag Tags that may condition execution of the statement.

Field Summary

Fields

Modifier and Type	Field and Description
static String	CATEGORY Category pseudo-tag
static String	DIALECT_WITH_NO_SEMICOLON
String	sql SQL statement
List<SQLStatement.Tag>	tags Tags on the statement

Constructor Summary

Constructors

Constructor and Description
SQLStatement(String sql, List<SQLStatement.Tag> tags)

Method Summary

Methods

Modifier and Type	Method and Description
static void	execute(List<SQLStatement> statements, Map<String,Serializable> properties, JDBCConnection jdbc) Executes a list of SQL statements, following the tags.
static Map<String,List<SQLStatement>>	read(String filename, Map<String,List<SQLStatement>> statements) Reads SQL statements from a text file.
String	toString()

Methods inherited from class java.lang.Object

equals, getClass, hashCode, notify, notifyAll, wait, wait, wait

Field Detail

DIALECT_WITH_NO_SEMICOLON

public static final String DIALECT_WITH_NO_SEMICOLON

See Also:

Constant Field Values

CATEGORY

public static final String CATEGORY

Category pseudo-tag

See Also:

Constant Field Values

sql

public final String sql

SQL statement

tags

public final List<SQLStatement.Tag> tags

Tags on the statement

Constructor Detail

SQLStatement

public SQLStatement(String sql,
            List<SQLStatement.Tag> tags)

Method Detail

toString

public String toString()

Overrides:

toString in class Object

read

public static Map<String,List<SQLStatement>> read(String filename,
                                  Map<String,List<SQLStatement>> statements)
                                           throws IOException

Reads SQL statements from a text file.

Statements have a category, and optional tags (that may condition execution).

   #CATEGORY: mycat
   #TEST:
   SELECT foo
     from bar;
 

   #CATEGORY: mycat
   #IF: emptyResult
   #IF: somethingEnabled
   INSERT INTO ...;
 

An empty line terminates a statement.

Throws:

IOException

execute

public static void execute(List<SQLStatement> statements,
           Map<String,Serializable> properties,
           JDBCConnection jdbc)
                    throws SQLException

Executes a list of SQL statements, following the tags.

Throws:

SQLException