org.openanzo.common.rdb.sql
Class SequencesSQL

java.lang.Object
  org.openanzo.common.rdb.sql.SequencesSQL

public class SequencesSQL
extends java.lang.Object

SequencesSQL provides wrappers around SQL queries and transforms ResultSets into java objects

Author:

Generated Source from org.openanzo.jdbc.utils.opgen.jet

Nested Class Summary

static class	SequencesSQL.BatchInsertLiteral Batch operation for adding parameters to the InsertLiteral prepared statement
static class	SequencesSQL.BatchInsertLongLiteral Batch operation for adding parameters to the InsertLongLiteral prepared statement
static class	SequencesSQL.BatchInsertLongNode Batch operation for adding parameters to the InsertLongNode prepared statement
static class	SequencesSQL.BatchInsertNode Batch operation for adding parameters to the InsertNode prepared statement
static interface	SequencesSQL.InsertLiteralParams Interface for managing the parameters to the insertLiteral prepared statement.
static class	SequencesSQL.InsertLiteralParamsImpl Default implementation of InsertLiteralParams
static interface	SequencesSQL.InsertLongLiteralParams Interface for managing the parameters to the insertLongLiteral prepared statement.
static class	SequencesSQL.InsertLongLiteralParamsImpl Default implementation of InsertLongLiteralParams
static interface	SequencesSQL.InsertLongNodeParams Interface for managing the parameters to the insertLongNode prepared statement.
static class	SequencesSQL.InsertLongNodeParamsImpl Default implementation of InsertLongNodeParams

Field Summary

static java.lang.String	getNodeID Constant "getNodeID" used to reference prepared statement with-sequences.getNodeID SELECT NEXT VALUE FOR ${a} FROM GLITTERUNIT
static java.lang.String	insertLiteral Constant "insertLiteral" used to reference prepared statement with-sequences.insertLiteral INSERT INTO ${a} (ID, VALUE, DATATYPE_ID, LANGUAGE_ID) VALUES(NEXT VALUE FOR ${b}, ?, ?, ?)
static java.lang.String	insertLongLiteral Constant "insertLongLiteral" used to reference prepared statement with-sequences.insertLongLiteral INSERT INTO ${a} (ID, HASH, VALUE, DATATYPE_ID, LANGUAGE_ID) VALUES(NEXT VALUE FOR ${b}, ?, ?, ?, ?)
static java.lang.String	insertLongNode Constant "insertLongNode" used to reference prepared statement with-sequences.insertLongNode INSERT INTO ${a} (ID, HASH, VALUE) VALUES(NEXT VALUE FOR ${b}, ?, ?)
static java.lang.String	insertNode Constant "insertNode" used to reference prepared statement with-sequences.insertNode INSERT INTO ${a} (id, value) VALUES(NEXT VALUE FOR ${b}, ?)

Constructor Summary

SequencesSQL()

Method Summary

static java.lang.Long	getNodeID(PreparedStatementCache sqlCache, java.lang.String sequenceName) Runs the getNodeID prepared statement.
static void	insertLiteral(PreparedStatementCache sqlCache, SequencesSQL.InsertLiteralParams params, java.lang.String literalNodeTableName, java.lang.String sequenceName) Runs the insertLiteral prepared statement.
static void	insertLiteral(PreparedStatementCache sqlCache, java.lang.String value, long modifier_id, java.lang.String literalNodeTableName, java.lang.String sequenceName) Runs the insertLiteral prepared statement.
static void	insertLongLiteral(PreparedStatementCache sqlCache, SequencesSQL.InsertLongLiteralParams params, java.lang.String literalNodeTableName, java.lang.String sequenceName) Runs the insertLongLiteral prepared statement.
static void	insertLongLiteral(PreparedStatementCache sqlCache, java.lang.String value, long hash, long modifier_id, java.lang.String literalNodeTableName, java.lang.String sequenceName) Runs the insertLongLiteral prepared statement.
static void	insertLongNode(PreparedStatementCache sqlCache, long hash, java.lang.String value, java.lang.String nodeTableName, java.lang.String sequenceName) Runs the insertLongNode prepared statement.
static void	insertLongNode(PreparedStatementCache sqlCache, SequencesSQL.InsertLongNodeParams params, java.lang.String nodeTableName, java.lang.String sequenceName) Runs the insertLongNode prepared statement.
static void	insertNode(PreparedStatementCache sqlCache, java.lang.String value, java.lang.String nodeTableName, java.lang.String sequenceName) Runs the insertNode prepared statement.
static void	prepareGetNodeID(java.sql.PreparedStatement ps) Sets the input parameters for the getNodeID prepared statement.
static void	prepareInsertLiteral(java.sql.PreparedStatement ps, java.lang.String value, long modifier_id) Sets the input parameters for the insertLiteral prepared statement.
static void	prepareInsertLongLiteral(java.sql.PreparedStatement ps, java.lang.String value, long hash, long modifier_id) Sets the input parameters for the insertLongLiteral prepared statement.
static void	prepareInsertLongNode(java.sql.PreparedStatement ps, long hash, java.lang.String value) Sets the input parameters for the insertLongNode prepared statement.
static void	prepareInsertNode(java.sql.PreparedStatement ps, java.lang.String value) Sets the input parameters for the insertNode prepared statement.

Methods inherited from class java.lang.Object

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

Field Detail

insertNode

public static final java.lang.String insertNode

Constant "insertNode" used to reference prepared statement with-sequences.insertNode INSERT INTO ${a} (id, value) VALUES(NEXT VALUE FOR ${b}, ?)

See Also:

Constant Field Values

insertLongNode

public static final java.lang.String insertLongNode

Constant "insertLongNode" used to reference prepared statement with-sequences.insertLongNode INSERT INTO ${a} (ID, HASH, VALUE) VALUES(NEXT VALUE FOR ${b}, ?, ?)

See Also:

Constant Field Values

insertLiteral

public static final java.lang.String insertLiteral

Constant "insertLiteral" used to reference prepared statement with-sequences.insertLiteral INSERT INTO ${a} (ID, VALUE, DATATYPE_ID, LANGUAGE_ID) VALUES(NEXT VALUE FOR ${b}, ?, ?, ?)

See Also:

Constant Field Values

insertLongLiteral

public static final java.lang.String insertLongLiteral

Constant "insertLongLiteral" used to reference prepared statement with-sequences.insertLongLiteral INSERT INTO ${a} (ID, HASH, VALUE, DATATYPE_ID, LANGUAGE_ID) VALUES(NEXT VALUE FOR ${b}, ?, ?, ?, ?)

See Also:

Constant Field Values

getNodeID

public static final java.lang.String getNodeID

Constant "getNodeID" used to reference prepared statement with-sequences.getNodeID SELECT NEXT VALUE FOR ${a} FROM GLITTERUNIT

See Also:

Constant Field Values

Constructor Detail

SequencesSQL

public SequencesSQL()

Method Detail

insertNode

public static void insertNode(PreparedStatementCache sqlCache,
                              java.lang.String value,
                              java.lang.String nodeTableName,
                              java.lang.String sequenceName)
                       throws RdbException

Runs the insertNode prepared statement. INSERT INTO ${a} (id, value) VALUES(NEXT VALUE FOR ${b}, ?)

Parameters:

sqlCache - factory and cache of PreparedStatments

value - template parameter

nodeTableName - template parameter

sequenceName - template parameter

Throws:

RdbException

prepareInsertNode

public static void prepareInsertNode(java.sql.PreparedStatement ps,
                                     java.lang.String value)
                              throws java.sql.SQLException

Sets the input parameters for the insertNode prepared statement.

Parameters:

ps - PreparedStatement to whose parameters are set

value - template parameter

Throws:

java.sql.SQLException

insertLongNode

public static void insertLongNode(PreparedStatementCache sqlCache,
                                  SequencesSQL.InsertLongNodeParams params,
                                  java.lang.String nodeTableName,
                                  java.lang.String sequenceName)
                           throws RdbException

Runs the insertLongNode prepared statement. INSERT INTO ${a} (ID, HASH, VALUE) VALUES(NEXT VALUE FOR ${b}, ?, ?)

Parameters:

sqlCache - factory and cache of PreparedStatments

params - InsertLongNodeParams input Interface

nodeTableName - template parameter

sequenceName - template parameter

Throws:

RdbException

insertLongNode

public static void insertLongNode(PreparedStatementCache sqlCache,
                                  long hash,
                                  java.lang.String value,
                                  java.lang.String nodeTableName,
                                  java.lang.String sequenceName)
                           throws RdbException

Runs the insertLongNode prepared statement. INSERT INTO ${a} (ID, HASH, VALUE) VALUES(NEXT VALUE FOR ${b}, ?, ?)

Parameters:

sqlCache - factory and cache of PreparedStatments

hash - template parameter

value - template parameter

nodeTableName - template parameter

sequenceName - template parameter

Throws:

RdbException

prepareInsertLongNode

public static void prepareInsertLongNode(java.sql.PreparedStatement ps,
                                         long hash,
                                         java.lang.String value)
                                  throws java.sql.SQLException

Sets the input parameters for the insertLongNode prepared statement.

Parameters:

ps - PreparedStatement to whose parameters are set

hash - template parameter

value - template parameter

Throws:

java.sql.SQLException

insertLiteral

public static void insertLiteral(PreparedStatementCache sqlCache,
                                 SequencesSQL.InsertLiteralParams params,
                                 java.lang.String literalNodeTableName,
                                 java.lang.String sequenceName)
                          throws RdbException

Runs the insertLiteral prepared statement. INSERT INTO ${a} (ID, VALUE, DATATYPE_ID, LANGUAGE_ID) VALUES(NEXT VALUE FOR ${b}, ?, ?, ?)

Parameters:

sqlCache - factory and cache of PreparedStatments

params - InsertLiteralParams input Interface

literalNodeTableName - template parameter

sequenceName - template parameter

Throws:

RdbException

insertLiteral

public static void insertLiteral(PreparedStatementCache sqlCache,
                                 java.lang.String value,
                                 long modifier_id,
                                 java.lang.String literalNodeTableName,
                                 java.lang.String sequenceName)
                          throws RdbException

Runs the insertLiteral prepared statement. INSERT INTO ${a} (ID, VALUE, DATATYPE_ID, LANGUAGE_ID) VALUES(NEXT VALUE FOR ${b}, ?, ?, ?)

Parameters:

sqlCache - factory and cache of PreparedStatments

value - template parameter

modifier_id - template parameter

literalNodeTableName - template parameter

sequenceName - template parameter

Throws:

RdbException

prepareInsertLiteral

public static void prepareInsertLiteral(java.sql.PreparedStatement ps,
                                        java.lang.String value,
                                        long modifier_id)
                                 throws java.sql.SQLException

Sets the input parameters for the insertLiteral prepared statement.

Parameters:

ps - PreparedStatement to whose parameters are set

value - template parameter

modifier_id - template parameter

Throws:

java.sql.SQLException

insertLongLiteral

public static void insertLongLiteral(PreparedStatementCache sqlCache,
                                     SequencesSQL.InsertLongLiteralParams params,
                                     java.lang.String literalNodeTableName,
                                     java.lang.String sequenceName)
                              throws RdbException

Runs the insertLongLiteral prepared statement. INSERT INTO ${a} (ID, HASH, VALUE, DATATYPE_ID, LANGUAGE_ID) VALUES(NEXT VALUE FOR ${b}, ?, ?, ?, ?)

Parameters:

sqlCache - factory and cache of PreparedStatments

params - InsertLongLiteralParams input Interface

literalNodeTableName - template parameter

sequenceName - template parameter

Throws:

RdbException

insertLongLiteral

public static void insertLongLiteral(PreparedStatementCache sqlCache,
                                     java.lang.String value,
                                     long hash,
                                     long modifier_id,
                                     java.lang.String literalNodeTableName,
                                     java.lang.String sequenceName)
                              throws RdbException

Runs the insertLongLiteral prepared statement. INSERT INTO ${a} (ID, HASH, VALUE, DATATYPE_ID, LANGUAGE_ID) VALUES(NEXT VALUE FOR ${b}, ?, ?, ?, ?)

Parameters:

sqlCache - factory and cache of PreparedStatments

value - template parameter

hash - template parameter

modifier_id - template parameter

literalNodeTableName - template parameter

sequenceName - template parameter

Throws:

RdbException

prepareInsertLongLiteral

public static void prepareInsertLongLiteral(java.sql.PreparedStatement ps,
                                            java.lang.String value,
                                            long hash,
                                            long modifier_id)
                                     throws java.sql.SQLException

Sets the input parameters for the insertLongLiteral prepared statement.

Parameters:

ps - PreparedStatement to whose parameters are set

value - template parameter

hash - template parameter

modifier_id - template parameter

Throws:

java.sql.SQLException

getNodeID

public static java.lang.Long getNodeID(PreparedStatementCache sqlCache,
                                       java.lang.String sequenceName)
                                throws RdbException

Runs the getNodeID prepared statement. SELECT NEXT VALUE FOR ${a} FROM GLITTERUNIT

Parameters:

sqlCache - factory and cache of PreparedStatments

sequenceName - template parameter

Returns:

Long

Throws:

RdbException

prepareGetNodeID

public static void prepareGetNodeID(java.sql.PreparedStatement ps)
                             throws java.sql.SQLException

Sets the input parameters for the getNodeID prepared statement.

Parameters:

ps - PreparedStatement to whose parameters are set

Throws:

java.sql.SQLException