org.openanzo.common.rdb.sql
Class NoSequencesSQL

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

public class NoSequencesSQL
extends java.lang.Object

NoSequencesSQL 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	NoSequencesSQL.BatchInsertLiteral Batch operation for adding parameters to the InsertLiteral prepared statement
static class	NoSequencesSQL.BatchInsertLongLiteral Batch operation for adding parameters to the InsertLongLiteral prepared statement
static class	NoSequencesSQL.BatchInsertLongNode Batch operation for adding parameters to the InsertLongNode prepared statement
static class	NoSequencesSQL.BatchInsertNode Batch operation for adding parameters to the InsertNode prepared statement
static class	NoSequencesSQL.BatchUpdateNodeID Batch operation for adding parameters to the UpdateNodeID prepared statement
static interface	NoSequencesSQL.InsertLiteralParams Interface for managing the parameters to the insertLiteral prepared statement.
static class	NoSequencesSQL.InsertLiteralParamsImpl Default implementation of InsertLiteralParams
static interface	NoSequencesSQL.InsertLongLiteralParams Interface for managing the parameters to the insertLongLiteral prepared statement.
static class	NoSequencesSQL.InsertLongLiteralParamsImpl Default implementation of InsertLongLiteralParams
static interface	NoSequencesSQL.InsertLongNodeParams Interface for managing the parameters to the insertLongNode prepared statement.
static class	NoSequencesSQL.InsertLongNodeParamsImpl Default implementation of InsertLongNodeParams
static interface	NoSequencesSQL.InsertNodeParams Interface for managing the parameters to the insertNode prepared statement.
static class	NoSequencesSQL.InsertNodeParamsImpl Default implementation of InsertNodeParams

Field Summary

static java.lang.String	insertLiteral Constant "insertLiteral" used to reference prepared statement no-sequences.insertLiteral INSERT INTO ${a} (ID, VALUE, MODIFIER_ID) VALUES(?, ?, ?)
static java.lang.String	insertLongLiteral Constant "insertLongLiteral" used to reference prepared statement no-sequences.insertLongLiteral INSERT INTO ${a} (ID, HASH, VALUE, MODIFIER_ID) VALUES(?, ?, ?, ?)
static java.lang.String	insertLongNode Constant "insertLongNode" used to reference prepared statement no-sequences.insertLongNode INSERT INTO ${a} (ID, HASH, VALUE) VALUES(?, ?, ?)
static java.lang.String	insertNode Constant "insertNode" used to reference prepared statement no-sequences.insertNode INSERT INTO ${a} (ID, VALUE) VALUES(?, ?)
static java.lang.String	selectNodeID Constant "selectNodeID" used to reference prepared statement no-sequences.selectNodeID SELECT ID FROM ${a}
static java.lang.String	updateNodeID Constant "updateNodeID" used to reference prepared statement no-sequences.updateNodeID UPDATE ${a} SET ID = ?

Constructor Summary

NoSequencesSQL()

Method Summary

static void	insertLiteral(PreparedStatementCache sqlCache, long id, java.lang.String value, long modifier_id, java.lang.String literalNodeTableName) Runs the insertLiteral prepared statement.
static void	insertLiteral(PreparedStatementCache sqlCache, NoSequencesSQL.InsertLiteralParams params, java.lang.String literalNodeTableName) Runs the insertLiteral prepared statement.
static void	insertLongLiteral(PreparedStatementCache sqlCache, long id, long hash, java.lang.String value, long modifier_id, java.lang.String longLiteralNodeTableName) Runs the insertLongLiteral prepared statement.
static void	insertLongLiteral(PreparedStatementCache sqlCache, NoSequencesSQL.InsertLongLiteralParams params, java.lang.String longLiteralNodeTableName) Runs the insertLongLiteral prepared statement.
static void	insertLongNode(PreparedStatementCache sqlCache, long id, long hash, java.lang.String value, java.lang.String nodeTableName) Runs the insertLongNode prepared statement.
static void	insertLongNode(PreparedStatementCache sqlCache, NoSequencesSQL.InsertLongNodeParams params, java.lang.String nodeTableName) Runs the insertLongNode prepared statement.
static void	insertNode(PreparedStatementCache sqlCache, long id, java.lang.String value, java.lang.String nodeTableName) Runs the insertNode prepared statement.
static void	insertNode(PreparedStatementCache sqlCache, NoSequencesSQL.InsertNodeParams params, java.lang.String nodeTableName) Runs the insertNode prepared statement.
static void	prepareInsertLiteral(java.sql.PreparedStatement ps, long id, java.lang.String value, long modifier_id) Sets the input parameters for the insertLiteral prepared statement.
static void	prepareInsertLongLiteral(java.sql.PreparedStatement ps, long id, long hash, java.lang.String value, long modifier_id) Sets the input parameters for the insertLongLiteral prepared statement.
static void	prepareInsertLongNode(java.sql.PreparedStatement ps, long id, long hash, java.lang.String value) Sets the input parameters for the insertLongNode prepared statement.
static void	prepareInsertNode(java.sql.PreparedStatement ps, long id, java.lang.String value) Sets the input parameters for the insertNode prepared statement.
static void	prepareSelectNodeID(java.sql.PreparedStatement ps) Sets the input parameters for the selectNodeID prepared statement.
static void	prepareUpdateNodeID(java.sql.PreparedStatement ps, long id) Sets the input parameters for the updateNodeID prepared statement.
static java.lang.Long	selectNodeID(PreparedStatementCache sqlCache, java.lang.String sequenceName) Runs the selectNodeID prepared statement.
static void	updateNodeID(PreparedStatementCache sqlCache, long id, java.lang.String sequenceName) Runs the updateNodeID 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 no-sequences.insertNode INSERT INTO ${a} (ID, VALUE) VALUES(?, ?)

See Also:

Constant Field Values

insertLongNode

public static final java.lang.String insertLongNode

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

See Also:

Constant Field Values

insertLiteral

public static final java.lang.String insertLiteral

Constant "insertLiteral" used to reference prepared statement no-sequences.insertLiteral INSERT INTO ${a} (ID, VALUE, MODIFIER_ID) VALUES(?, ?, ?)

See Also:

Constant Field Values

insertLongLiteral

public static final java.lang.String insertLongLiteral

Constant "insertLongLiteral" used to reference prepared statement no-sequences.insertLongLiteral INSERT INTO ${a} (ID, HASH, VALUE, MODIFIER_ID) VALUES(?, ?, ?, ?)

See Also:

Constant Field Values

selectNodeID

public static final java.lang.String selectNodeID

Constant "selectNodeID" used to reference prepared statement no-sequences.selectNodeID SELECT ID FROM ${a}

See Also:

Constant Field Values

updateNodeID

public static final java.lang.String updateNodeID

Constant "updateNodeID" used to reference prepared statement no-sequences.updateNodeID UPDATE ${a} SET ID = ?

See Also:

Constant Field Values

Constructor Detail

NoSequencesSQL

public NoSequencesSQL()

Method Detail

insertNode

public static void insertNode(PreparedStatementCache sqlCache,
                              NoSequencesSQL.InsertNodeParams params,
                              java.lang.String nodeTableName)
                       throws RdbException

Runs the insertNode prepared statement. INSERT INTO ${a} (ID, VALUE) VALUES(?, ?)

Parameters:

sqlCache - factory and cache of PreparedStatments

params - InsertNodeParams input Interface

nodeTableName - template parameter

Throws:

RdbException

insertNode

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

Runs the insertNode prepared statement. INSERT INTO ${a} (ID, VALUE) VALUES(?, ?)

Parameters:

sqlCache - factory and cache of PreparedStatments

id - template parameter

value - template parameter

nodeTableName - template parameter

Throws:

RdbException

prepareInsertNode

public static void prepareInsertNode(java.sql.PreparedStatement ps,
                                     long id,
                                     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

id - template parameter

value - template parameter

Throws:

java.sql.SQLException

insertLongNode

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

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

Parameters:

sqlCache - factory and cache of PreparedStatments

params - InsertLongNodeParams input Interface

nodeTableName - template parameter

Throws:

RdbException

insertLongNode

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

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

Parameters:

sqlCache - factory and cache of PreparedStatments

id - template parameter

hash - template parameter

value - template parameter

nodeTableName - template parameter

Throws:

RdbException

prepareInsertLongNode

public static void prepareInsertLongNode(java.sql.PreparedStatement ps,
                                         long id,
                                         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

id - template parameter

hash - template parameter

value - template parameter

Throws:

java.sql.SQLException

insertLiteral

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

Runs the insertLiteral prepared statement. INSERT INTO ${a} (ID, VALUE, MODIFIER_ID) VALUES(?, ?, ?)

Parameters:

sqlCache - factory and cache of PreparedStatments

params - InsertLiteralParams input Interface

literalNodeTableName - template parameter

Throws:

RdbException

insertLiteral

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

Runs the insertLiteral prepared statement. INSERT INTO ${a} (ID, VALUE, MODIFIER_ID) VALUES(?, ?, ?)

Parameters:

sqlCache - factory and cache of PreparedStatments

id - template parameter

value - template parameter

modifier_id - template parameter

literalNodeTableName - template parameter

Throws:

RdbException

prepareInsertLiteral

public static void prepareInsertLiteral(java.sql.PreparedStatement ps,
                                        long id,
                                        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

id - template parameter

value - template parameter

modifier_id - template parameter

Throws:

java.sql.SQLException

insertLongLiteral

public static void insertLongLiteral(PreparedStatementCache sqlCache,
                                     NoSequencesSQL.InsertLongLiteralParams params,
                                     java.lang.String longLiteralNodeTableName)
                              throws RdbException

Runs the insertLongLiteral prepared statement. INSERT INTO ${a} (ID, HASH, VALUE, MODIFIER_ID) VALUES(?, ?, ?, ?)

Parameters:

sqlCache - factory and cache of PreparedStatments

params - InsertLongLiteralParams input Interface

longLiteralNodeTableName - template parameter

Throws:

RdbException

insertLongLiteral

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

Runs the insertLongLiteral prepared statement. INSERT INTO ${a} (ID, HASH, VALUE, MODIFIER_ID) VALUES(?, ?, ?, ?)

Parameters:

sqlCache - factory and cache of PreparedStatments

id - template parameter

hash - template parameter

value - template parameter

modifier_id - template parameter

longLiteralNodeTableName - template parameter

Throws:

RdbException

prepareInsertLongLiteral

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

Sets the input parameters for the insertLongLiteral prepared statement.

Parameters:

ps - PreparedStatement to whose parameters are set

id - template parameter

hash - template parameter

value - template parameter

modifier_id - template parameter

Throws:

java.sql.SQLException

selectNodeID

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

Runs the selectNodeID prepared statement. SELECT ID FROM ${a}

Parameters:

sqlCache - factory and cache of PreparedStatments

sequenceName - template parameter

Returns:

Long

Throws:

RdbException

prepareSelectNodeID

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

Sets the input parameters for the selectNodeID prepared statement.

Parameters:

ps - PreparedStatement to whose parameters are set

Throws:

java.sql.SQLException

updateNodeID

public static void updateNodeID(PreparedStatementCache sqlCache,
                                long id,
                                java.lang.String sequenceName)
                         throws RdbException

Runs the updateNodeID prepared statement. UPDATE ${a} SET ID = ?

Parameters:

sqlCache - factory and cache of PreparedStatments

id - template parameter

sequenceName - template parameter

Throws:

RdbException

prepareUpdateNodeID

public static void prepareUpdateNodeID(java.sql.PreparedStatement ps,
                                       long id)
                                throws java.sql.SQLException

Sets the input parameters for the updateNodeID prepared statement.

Parameters:

ps - PreparedStatement to whose parameters are set

id - template parameter

Throws:

java.sql.SQLException