org.openanzo.server.repository.rdb.sql
Class GlitterRdbWrapper

java.lang.Object
  org.openanzo.server.repository.rdb.sql.GlitterRdbWrapper

public class GlitterRdbWrapper
extends java.lang.Object

GlitterRdbWrapper 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 interface	GlitterRdbWrapper.InsertAllValidDatasetGraphsParams Interface for managing the parameters to the insertAllValidDatasetGraphs prepared statement.
static class	GlitterRdbWrapper.InsertAllValidDatasetGraphsParamsImpl Default implementation of InsertAllValidDatasetGraphsParams
static interface	GlitterRdbWrapper.InsertAllValidDatasetMetadataGraphsParams Interface for managing the parameters to the insertAllValidDatasetMetadataGraphs prepared statement.
static class	GlitterRdbWrapper.InsertAllValidDatasetMetadataGraphsParamsImpl Default implementation of InsertAllValidDatasetMetadataGraphsParams
static interface	GlitterRdbWrapper.InsertValidDatasetGraphsParams Interface for managing the parameters to the insertValidDatasetGraphs prepared statement.
static class	GlitterRdbWrapper.InsertValidDatasetGraphsParamsImpl Default implementation of InsertValidDatasetGraphsParams
static interface	GlitterRdbWrapper.InsertValidDatasetMetadataGraphsParams Interface for managing the parameters to the insertValidDatasetMetadataGraphs prepared statement.
static class	GlitterRdbWrapper.InsertValidDatasetMetadataGraphsParamsImpl Default implementation of InsertValidDatasetMetadataGraphsParams
static interface	GlitterRdbWrapper.SelectUnreadableGraphsParams Interface for managing the parameters to the selectUnreadableGraphs prepared statement.
static class	GlitterRdbWrapper.SelectUnreadableGraphsParamsImpl Default implementation of SelectUnreadableGraphsParams
static interface	GlitterRdbWrapper.SelectUnreadableMetadataGraphsParams Interface for managing the parameters to the selectUnreadableMetadataGraphs prepared statement.
static class	GlitterRdbWrapper.SelectUnreadableMetadataGraphsParamsImpl Default implementation of SelectUnreadableMetadataGraphsParams
static interface	GlitterRdbWrapper.SelectUntimelyGraphsParams Interface for managing the parameters to the selectUntimelyGraphs prepared statement.
static class	GlitterRdbWrapper.SelectUntimelyGraphsParamsImpl Default implementation of SelectUntimelyGraphsParams
static interface	GlitterRdbWrapper.SelectUntimelyMetadataGraphsParams Interface for managing the parameters to the selectUntimelyMetadataGraphs prepared statement.
static class	GlitterRdbWrapper.SelectUntimelyMetadataGraphsParamsImpl Default implementation of SelectUntimelyMetadataGraphsParams

Field Summary

static java.lang.String	clearTempDatasetTable Constant "clearTempDatasetTable" used to reference prepared statement Glitter.clearTempDatasetTable DELETE FROM ${a} WHERE ID IS NOT NULL
static java.lang.String	containsGraph Constant "containsGraph" used to reference prepared statement Glitter.containsGraph SELECT COUNT(*) FROM ${a}${b} TG,NAMEDGRAPHS NG WHERE TG.ID = ? and TG.ID=NG.ID
static java.lang.String	containsMetadataGraph Constant "containsMetadataGraph" used to reference prepared statement Glitter.containsMetadataGraph SELECT COUNT(*) FROM ${a}${b} TG,NAMEDGRAPHS NG WHERE TG.ID = ? and TG.ID=NG.METAID
static java.lang.String	countRows Constant "countRows" used to reference prepared statement Glitter.countRows SELECT COUNT(*) FROM ${a}${b}
static java.lang.String	countValidMetadataGraphs Constant "countValidMetadataGraphs" used to reference prepared statement Glitter.countValidMetadataGraphs SELECT COUNT(*) FROM ${b}${a} WHERE ${b}${a}.ID IN (SELECT NG.METAID FROM NAMEDGRAPHS NG)
static java.lang.String	countValidNamedGraphs Constant "countValidNamedGraphs" used to reference prepared statement Glitter.countValidNamedGraphs SELECT COUNT(*) FROM ${b}${a} WHERE ${b}${a}.ID IN (SELECT NG.ID FROM NAMEDGRAPHS NG)
static java.lang.String	insertAllMetadataGraphs Constant "insertAllMetadataGraphs" used to reference prepared statement Glitter.insertAllMetadataGraphs INSERT INTO ${a}TEMPGRAPHS SELECT DISTINCT NG.METAID FROM NAMEDGRAPHS NG
static java.lang.String	insertAllNamedGraphs Constant "insertAllNamedGraphs" used to reference prepared statement Glitter.insertAllNamedGraphs INSERT INTO ${a}TEMPGRAPHS SELECT DISTINCT NG.ID FROM NAMEDGRAPHS NG
static java.lang.String	insertAllValidDatasetGraphs Constant "insertAllValidDatasetGraphs" used to reference prepared statement Glitter.insertAllValidDatasetGraphs INSERT INTO ${b}${a} SELECT DISTINCT NG.ID,0 FROM NAMEDGRAPHS NG, ACIS WHERE ? >= NG.HSTART AND (NG.HEND IS NULL OR ? < NG.HEND) AND NG.ACLID = ACIS.ACLID AND ACIS.CANREAD = 1 AND ACIS.ROLEID IN (SELECT UR.ROLEID FROM USERSROLES UR WHERE UR.USERID = ? AND ? >= UR.HSTART AND (UR.HEND IS NULL OR ? < UR.HEND) )
static java.lang.String	insertAllValidDatasetGraphsLive Constant "insertAllValidDatasetGraphsLive" used to reference prepared statement Glitter.insertAllValidDatasetGraphsLive INSERT INTO ${b}${a} SELECT DISTINCT NG.ID,0 FROM NAMEDGRAPHS NG, ACIS WHERE NG.HEND IS NULL AND NG.ACLID = ACIS.ACLID AND ACIS.CANREAD = 1 AND ACIS.ROLEID IN (SELECT UR.ROLEID FROM USERSROLES UR WHERE UR.USERID = ? AND UR.HEND IS NULL )
static java.lang.String	insertAllValidDatasetMetadataGraphs Constant "insertAllValidDatasetMetadataGraphs" used to reference prepared statement Glitter.insertAllValidDatasetMetadataGraphs INSERT INTO ${b}${a} SELECT DISTINCT NG.METAID,1 FROM NAMEDGRAPHS NG, ACIS WHERE ? >= NG.HSTART AND (NG.HEND IS NULL OR ? < NG.HEND) AND NG.ACLID = ACIS.ACLID AND ACIS.CANREAD = 1 AND ACIS.ROLEID IN (SELECT UR.ROLEID FROM USERSROLES UR WHERE UR.USERID = ? AND ? >= UR.HSTART AND (UR.HEND IS NULL OR ? < UR.HEND) )
static java.lang.String	insertAllValidDatasetMetadataGraphsLive Constant "insertAllValidDatasetMetadataGraphsLive" used to reference prepared statement Glitter.insertAllValidDatasetMetadataGraphsLive INSERT INTO ${b}${a} SELECT DISTINCT NG.METAID,1 FROM NAMEDGRAPHS NG, ACIS WHERE NG.HEND IS NULL AND NG.ACLID = ACIS.ACLID AND ACIS.CANREAD = 1 AND ACIS.ROLEID IN (SELECT UR.ROLEID FROM USERSROLES UR WHERE UR.USERID = ? AND UR.HEND IS NULL )
static java.lang.String	insertTempDatasetGraph Constant "insertTempDatasetGraph" used to reference prepared statement Glitter.insertTempDatasetGraph INSERT INTO ${a}TEMPGRAPHS VALUES (?)
static java.lang.String	insertValidDatasetGraphs Constant "insertValidDatasetGraphs" used to reference prepared statement Glitter.insertValidDatasetGraphs INSERT INTO ${b}${a} SELECT DISTINCT NG.ID,0 FROM NAMEDGRAPHS NG, ACIS, ${b}TEMPGRAPHS TMP WHERE NG.ID = TMP.ID AND ? >= NG.HSTART AND (NG.HEND IS NULL OR ? < NG.HEND) AND NG.ACLID = ACIS.ACLID AND ACIS.CANREAD = 1 AND ACIS.ROLEID IN (SELECT UR.ROLEID FROM USERSROLES UR WHERE UR.USERID = ? AND ? >= UR.HSTART AND (UR.HEND IS NULL OR ? < UR.HEND) )
static java.lang.String	insertValidDatasetGraphsLive Constant "insertValidDatasetGraphsLive" used to reference prepared statement Glitter.insertValidDatasetGraphsLive INSERT INTO ${b}${a} SELECT DISTINCT NG.ID,0 FROM NAMEDGRAPHS NG, ACIS, ${b}TEMPGRAPHS TMP WHERE NG.ID = TMP.ID AND NG.HEND IS NULL AND NG.ACLID = ACIS.ACLID AND ACIS.CANREAD = 1 AND ACIS.ROLEID IN (SELECT UR.ROLEID FROM USERSROLES UR WHERE UR.USERID = ? AND UR.HEND IS NULL )
static java.lang.String	insertValidDatasetMetadataGraphs Constant "insertValidDatasetMetadataGraphs" used to reference prepared statement Glitter.insertValidDatasetMetadataGraphs INSERT INTO ${b}${a} SELECT DISTINCT NG.METAID,1 FROM NAMEDGRAPHS NG, ACIS, ${b}TEMPGRAPHS TMP WHERE NG.METAID = TMP.ID AND ? >= NG.HSTART AND (NG.HEND IS NULL OR ? < NG.HEND) AND NG.ACLID = ACIS.ACLID AND ACIS.CANREAD = 1 AND ACIS.ROLEID IN (SELECT UR.ROLEID FROM USERSROLES UR WHERE UR.USERID = ? AND ? >= UR.HSTART AND (UR.HEND IS NULL OR ? < UR.HEND) )
static java.lang.String	insertValidDatasetMetadataGraphsLive Constant "insertValidDatasetMetadataGraphsLive" used to reference prepared statement Glitter.insertValidDatasetMetadataGraphsLive INSERT INTO ${b}${a} SELECT DISTINCT NG.METAID,1 FROM NAMEDGRAPHS NG, ACIS, ${b}TEMPGRAPHS TMP WHERE NG.METAID = TMP.ID AND NG.HEND IS NULL AND NG.ACLID = ACIS.ACLID AND ACIS.CANREAD = 1 AND ACIS.ROLEID IN (SELECT UR.ROLEID FROM USERSROLES UR WHERE UR.USERID = ? AND UR.HEND IS NULL )
static java.lang.String	selectGraphs Constant "selectGraphs" used to reference prepared statement Glitter.selectGraphs SELECT ID FROM ${a}${b} WHERE META=?
static java.lang.String	selectMetadataGraphs Constant "selectMetadataGraphs" used to reference prepared statement Glitter.selectMetadataGraphs SELECT ${b}${a}.ID FROM ${b}${a} WHERE ${b}${a}.ID IN (SELECT NG.METAID FROM NAMEDGRAPHS NG)
static java.lang.String	selectNamedGraphs Constant "selectNamedGraphs" used to reference prepared statement Glitter.selectNamedGraphs SELECT ${b}${a}.ID FROM ${b}${a} WHERE ${b}${a}.ID IN (SELECT NG.ID FROM NAMEDGRAPHS NG)
static java.lang.String	selectUnreadableGraphs Constant "selectUnreadableGraphs" used to reference prepared statement Glitter.selectUnreadableGraphs SELECT TMP1.ID FROM ${a}${b} TMP1 LEFT JOIN (SELECT NG.ID FROM NAMEDGRAPHS NG, ACIS, ${a}${c} TMP2 WHERE NG.ID = TMP2.ID AND NG.ACLID = ACIS.ACLID AND ACIS.CANREAD = 1 AND ACIS.ROLEID IN (SELECT UR.ROLEID FROM USERSROLES UR WHERE UR.USERID = ? AND ? >= UR.HSTART AND (UR.HEND IS NULL OR ? < UR.HEND) ) )AS TMP2 ON TMP1.ID=TMP2.ID WHERE TMP2.ID IS NULL
static java.lang.String	selectUnreadableGraphsLive Constant "selectUnreadableGraphsLive" used to reference prepared statement Glitter.selectUnreadableGraphsLive SELECT TMP1.ID FROM ${a}${b} TMP1 LEFT JOIN (SELECT NG.ID FROM NAMEDGRAPHS NG, ACIS, ${a}${c} TMP2 WHERE NG.HEND IS NULL AND NG.ID = TMP2.ID AND NG.ACLID = ACIS.ACLID AND ACIS.CANREAD = 1 AND ACIS.ROLEID IN (SELECT UR.ROLEID FROM USERSROLES UR WHERE UR.USERID = ? AND UR.HEND IS NULL ) )AS TMP2 ON TMP1.ID=TMP2.ID WHERE TMP2.ID IS NULL
static java.lang.String	selectUnreadableMetadataGraphs Constant "selectUnreadableMetadataGraphs" used to reference prepared statement Glitter.selectUnreadableMetadataGraphs SELECT TMP1.ID FROM ${a}${b} TMP1 LEFT JOIN (SELECT NG.METAID FROM NAMEDGRAPHS NG, ACIS, ${a}${c} TMP2 WHERE NG.METAID = TMP2.ID AND NG.ACLID = ACIS.ACLID AND ACIS.CANREAD = 1 AND ACIS.ROLEID IN (SELECT UR.ROLEID FROM USERSROLES UR WHERE UR.USERID = ? AND ? >= UR.HSTART AND (UR.HEND IS NULL OR ? < UR.HEND) ) )AS TMP2 ON TMP1.ID=TMP2.METAID WHERE TMP2.METAID IS NULL
static java.lang.String	selectUnreadableMetadataGraphsLive Constant "selectUnreadableMetadataGraphsLive" used to reference prepared statement Glitter.selectUnreadableMetadataGraphsLive SELECT TMP1.ID FROM ${a}${b} TMP1 LEFT JOIN (SELECT NG.METAID FROM NAMEDGRAPHS NG, ACIS, ${a}${c} TMP2 WHERE NG.HEND IS NULL AND NG.METAID = TMP2.ID AND NG.ACLID = ACIS.ACLID AND ACIS.CANREAD = 1 AND ACIS.ROLEID IN (SELECT UR.ROLEID FROM USERSROLES UR WHERE UR.USERID = ? AND UR.HEND IS NULL ) )AS TMP2 ON TMP1.ID=TMP2.METAID WHERE TMP2.METAID IS NULL
static java.lang.String	selectUntimelyGraphs Constant "selectUntimelyGraphs" used to reference prepared statement Glitter.selectUntimelyGraphs SELECT TMP1.ID FROM ${a}${b} TMP1 LEFT JOIN (SELECT NG.ID FROM NAMEDGRAPHS NG, ${a}${c} TMP2 WHERE NG.ID = TMP2.ID AND ? >= NG.HSTART AND (NG.HEND IS NULL OR ? < NG.HEND) )AS TMP2 ON TMP1.ID=TMP2.ID WHERE TMP2.ID IS NULL
static java.lang.String	selectUntimelyMetadataGraphs Constant "selectUntimelyMetadataGraphs" used to reference prepared statement Glitter.selectUntimelyMetadataGraphs SELECT TMP1.ID FROM ${a}${b} TMP1 LEFT JOIN (SELECT DISTINCT NG.METAID FROM NAMEDGRAPHS NG, ${a}${c} TMP2 WHERE NG.METAID = TMP2.ID AND ? >= NG.HSTART AND (NG.HEND IS NULL OR ? < NG.HEND) )AS TMP2 ON TMP1.ID=TMP2.METAID WHERE TMP2.METAID IS NULL
static java.lang.String	truncateTable Constant "truncateTable" used to reference prepared statement Glitter.truncateTable DELETE FROM ${a}

Constructor Summary

GlitterRdbWrapper()

Method Summary

static int	clearTempDatasetTable(PreparedStatementCache sqlCache, java.lang.String table) Runs the clearTempDatasetTable prepared statement.
static java.lang.Integer	containsGraph(PreparedStatementCache sqlCache, long id, java.lang.String sessionPrefix, java.lang.String tableName) Runs the containsGraph prepared statement.
static java.lang.Integer	containsMetadataGraph(PreparedStatementCache sqlCache, long id, java.lang.String sessionPrefix, java.lang.String tableName) Runs the containsMetadataGraph prepared statement.
static java.lang.Integer	countRows(PreparedStatementCache sqlCache, java.lang.String sessionPrefix, java.lang.String tableName) Runs the countRows prepared statement.
static java.lang.Long	countValidMetadataGraphs(PreparedStatementCache sqlCache, java.lang.String tableName, java.lang.String sessionPrefix) Runs the countValidMetadataGraphs prepared statement.
static java.lang.Long	countValidNamedGraphs(PreparedStatementCache sqlCache, java.lang.String tableName, java.lang.String sessionPrefix) Runs the countValidNamedGraphs prepared statement.
static int	insertAllMetadataGraphs(PreparedStatementCache sqlCache, java.lang.String sessionPrefix) Runs the insertAllMetadataGraphs prepared statement.
static int	insertAllNamedGraphs(PreparedStatementCache sqlCache, java.lang.String sessionPrefix) Runs the insertAllNamedGraphs prepared statement.
static int	insertAllValidDatasetGraphs(PreparedStatementCache sqlCache, GlitterRdbWrapper.InsertAllValidDatasetGraphsParams params, java.lang.String tableName, java.lang.String sessionPrefix) Runs the insertAllValidDatasetGraphs prepared statement.
static int	insertAllValidDatasetGraphs(PreparedStatementCache sqlCache, java.lang.Long lastTransactionTime1, java.lang.Long lastTransactionTime2, long userId, java.lang.Long lastTransactionTime3, java.lang.Long lastTransactionTime4, java.lang.String tableName, java.lang.String sessionPrefix) Runs the insertAllValidDatasetGraphs prepared statement.
static int	insertAllValidDatasetGraphsLive(PreparedStatementCache sqlCache, long userId, java.lang.String tableName, java.lang.String sessionPrefix) Runs the insertAllValidDatasetGraphsLive prepared statement.
static int	insertAllValidDatasetMetadataGraphs(PreparedStatementCache sqlCache, GlitterRdbWrapper.InsertAllValidDatasetMetadataGraphsParams params, java.lang.String tableName, java.lang.String sessionPrefix) Runs the insertAllValidDatasetMetadataGraphs prepared statement.
static int	insertAllValidDatasetMetadataGraphs(PreparedStatementCache sqlCache, java.lang.Long lastTransactionTime1, java.lang.Long lastTransactionTime2, long userId, java.lang.Long lastTransactionTime3, java.lang.Long lastTransactionTime4, java.lang.String tableName, java.lang.String sessionPrefix) Runs the insertAllValidDatasetMetadataGraphs prepared statement.
static int	insertAllValidDatasetMetadataGraphsLive(PreparedStatementCache sqlCache, long userId, java.lang.String tableName, java.lang.String sessionPrefix) Runs the insertAllValidDatasetMetadataGraphsLive prepared statement.
static int	insertTempDatasetGraph(PreparedStatementCache sqlCache, long id, java.lang.String sessionPrefix) Runs the insertTempDatasetGraph prepared statement.
static int	insertValidDatasetGraphs(PreparedStatementCache sqlCache, GlitterRdbWrapper.InsertValidDatasetGraphsParams params, java.lang.String tableName, java.lang.String sessionPrefix) Runs the insertValidDatasetGraphs prepared statement.
static int	insertValidDatasetGraphs(PreparedStatementCache sqlCache, java.lang.Long lastTransactionTime1, java.lang.Long lastTransactionTime2, long userId, java.lang.Long lastTransactionTime3, java.lang.Long lastTransactionTime4, java.lang.String tableName, java.lang.String sessionPrefix) Runs the insertValidDatasetGraphs prepared statement.
static int	insertValidDatasetGraphsLive(PreparedStatementCache sqlCache, long userId, java.lang.String tableName, java.lang.String sessionPrefix) Runs the insertValidDatasetGraphsLive prepared statement.
static int	insertValidDatasetMetadataGraphs(PreparedStatementCache sqlCache, GlitterRdbWrapper.InsertValidDatasetMetadataGraphsParams params, java.lang.String tableName, java.lang.String sessionPrefix) Runs the insertValidDatasetMetadataGraphs prepared statement.
static int	insertValidDatasetMetadataGraphs(PreparedStatementCache sqlCache, java.lang.Long lastTransactionTime1, java.lang.Long lastTransactionTime2, long userId, java.lang.Long lastTransactionTime3, java.lang.Long lastTransactionTime4, java.lang.String tableName, java.lang.String sessionPrefix) Runs the insertValidDatasetMetadataGraphs prepared statement.
static int	insertValidDatasetMetadataGraphsLive(PreparedStatementCache sqlCache, long userId, java.lang.String tableName, java.lang.String sessionPrefix) Runs the insertValidDatasetMetadataGraphsLive prepared statement.
static void	prepareClearTempDatasetTable(java.sql.PreparedStatement ps) Sets the input parameters for the clearTempDatasetTable prepared statement.
static void	prepareContainsGraph(java.sql.PreparedStatement ps, long id) Sets the input parameters for the containsGraph prepared statement.
static void	prepareContainsMetadataGraph(java.sql.PreparedStatement ps, long id) Sets the input parameters for the containsMetadataGraph prepared statement.
static void	prepareCountRows(java.sql.PreparedStatement ps) Sets the input parameters for the countRows prepared statement.
static void	prepareCountValidMetadataGraphs(java.sql.PreparedStatement ps) Sets the input parameters for the countValidMetadataGraphs prepared statement.
static void	prepareCountValidNamedGraphs(java.sql.PreparedStatement ps) Sets the input parameters for the countValidNamedGraphs prepared statement.
static void	prepareInsertAllMetadataGraphs(java.sql.PreparedStatement ps) Sets the input parameters for the insertAllMetadataGraphs prepared statement.
static void	prepareInsertAllNamedGraphs(java.sql.PreparedStatement ps) Sets the input parameters for the insertAllNamedGraphs prepared statement.
static void	prepareInsertAllValidDatasetGraphs(java.sql.PreparedStatement ps, java.lang.Long lastTransactionTime1, java.lang.Long lastTransactionTime2, long userId, java.lang.Long lastTransactionTime3, java.lang.Long lastTransactionTime4) Sets the input parameters for the insertAllValidDatasetGraphs prepared statement.
static void	prepareInsertAllValidDatasetGraphsLive(java.sql.PreparedStatement ps, long userId) Sets the input parameters for the insertAllValidDatasetGraphsLive prepared statement.
static void	prepareInsertAllValidDatasetMetadataGraphs(java.sql.PreparedStatement ps, java.lang.Long lastTransactionTime1, java.lang.Long lastTransactionTime2, long userId, java.lang.Long lastTransactionTime3, java.lang.Long lastTransactionTime4) Sets the input parameters for the insertAllValidDatasetMetadataGraphs prepared statement.
static void	prepareInsertAllValidDatasetMetadataGraphsLive(java.sql.PreparedStatement ps, long userId) Sets the input parameters for the insertAllValidDatasetMetadataGraphsLive prepared statement.
static void	prepareInsertTempDatasetGraph(java.sql.PreparedStatement ps, long id) Sets the input parameters for the insertTempDatasetGraph prepared statement.
static void	prepareInsertValidDatasetGraphs(java.sql.PreparedStatement ps, java.lang.Long lastTransactionTime1, java.lang.Long lastTransactionTime2, long userId, java.lang.Long lastTransactionTime3, java.lang.Long lastTransactionTime4) Sets the input parameters for the insertValidDatasetGraphs prepared statement.
static void	prepareInsertValidDatasetGraphsLive(java.sql.PreparedStatement ps, long userId) Sets the input parameters for the insertValidDatasetGraphsLive prepared statement.
static void	prepareInsertValidDatasetMetadataGraphs(java.sql.PreparedStatement ps, java.lang.Long lastTransactionTime1, java.lang.Long lastTransactionTime2, long userId, java.lang.Long lastTransactionTime3, java.lang.Long lastTransactionTime4) Sets the input parameters for the insertValidDatasetMetadataGraphs prepared statement.
static void	prepareInsertValidDatasetMetadataGraphsLive(java.sql.PreparedStatement ps, long userId) Sets the input parameters for the insertValidDatasetMetadataGraphsLive prepared statement.
static void	prepareSelectGraphs(java.sql.PreparedStatement ps, java.lang.Long meta) Sets the input parameters for the selectGraphs prepared statement.
static void	prepareSelectMetadataGraphs(java.sql.PreparedStatement ps) Sets the input parameters for the selectMetadataGraphs prepared statement.
static void	prepareSelectNamedGraphs(java.sql.PreparedStatement ps) Sets the input parameters for the selectNamedGraphs prepared statement.
static void	prepareSelectUnreadableGraphs(java.sql.PreparedStatement ps, long userId, java.lang.Long lastTransactionTime1, java.lang.Long lastTransactionTime2) Sets the input parameters for the selectUnreadableGraphs prepared statement.
static void	prepareSelectUnreadableGraphsLive(java.sql.PreparedStatement ps, long userId) Sets the input parameters for the selectUnreadableGraphsLive prepared statement.
static void	prepareSelectUnreadableMetadataGraphs(java.sql.PreparedStatement ps, long userId, java.lang.Long lastTransactionTime1, java.lang.Long lastTransactionTime2) Sets the input parameters for the selectUnreadableMetadataGraphs prepared statement.
static void	prepareSelectUnreadableMetadataGraphsLive(java.sql.PreparedStatement ps, long userId) Sets the input parameters for the selectUnreadableMetadataGraphsLive prepared statement.
static void	prepareSelectUntimelyGraphs(java.sql.PreparedStatement ps, java.lang.Long lastTransactionTime1, java.lang.Long lastTransactionTime2) Sets the input parameters for the selectUntimelyGraphs prepared statement.
static void	prepareSelectUntimelyMetadataGraphs(java.sql.PreparedStatement ps, java.lang.Long lastTransactionTime1, java.lang.Long lastTransactionTime2) Sets the input parameters for the selectUntimelyMetadataGraphs prepared statement.
static void	prepareTruncateTable(java.sql.PreparedStatement ps) Sets the input parameters for the truncateTable prepared statement.
static ClosableIterator<java.lang.Long>	selectGraphs(PreparedStatementCache sqlCache, java.lang.Long meta, java.lang.String tableName, java.lang.String sessionPrefix) Runs the selectGraphs prepared statement with the default transformer.
static ClosableIterator<java.lang.Long>	selectGraphs(PreparedStatementCache sqlCache, java.lang.Long meta, java.lang.String tableName, java.lang.String sessionPrefix, Transformer<java.lang.Long> transform) Runs the selectGraphs prepared statement.
static ClosableIterator<java.lang.Long>	selectMetadataGraphs(PreparedStatementCache sqlCache, java.lang.String tableName, java.lang.String sessionPrefix) Runs the selectMetadataGraphs prepared statement with the default transformer.
static ClosableIterator<java.lang.Long>	selectMetadataGraphs(PreparedStatementCache sqlCache, java.lang.String tableName, java.lang.String sessionPrefix, Transformer<java.lang.Long> transform) Runs the selectMetadataGraphs prepared statement.
static ClosableIterator<java.lang.Long>	selectNamedGraphs(PreparedStatementCache sqlCache, java.lang.String tableName, java.lang.String sessionPrefix) Runs the selectNamedGraphs prepared statement with the default transformer.
static ClosableIterator<java.lang.Long>	selectNamedGraphs(PreparedStatementCache sqlCache, java.lang.String tableName, java.lang.String sessionPrefix, Transformer<java.lang.Long> transform) Runs the selectNamedGraphs prepared statement.
static ClosableIterator<java.lang.Long>	selectUnreadableGraphs(PreparedStatementCache sqlCache, GlitterRdbWrapper.SelectUnreadableGraphsParams params, java.lang.String sessionPrefix, java.lang.String tempgraph1, java.lang.String tempgraph2) Runs the selectUnreadableGraphs prepared statement.
static ClosableIterator<java.lang.Long>	selectUnreadableGraphs(PreparedStatementCache sqlCache, long userId, java.lang.Long lastTransactionTime1, java.lang.Long lastTransactionTime2, java.lang.String sessionPrefix, java.lang.String tempgraph1, java.lang.String tempgraph2) Runs the selectUnreadableGraphs prepared statement with the default transformer.
static ClosableIterator<java.lang.Long>	selectUnreadableGraphs(PreparedStatementCache sqlCache, long userId, java.lang.Long lastTransactionTime1, java.lang.Long lastTransactionTime2, java.lang.String sessionPrefix, java.lang.String tempgraph1, java.lang.String tempgraph2, Transformer<java.lang.Long> transform) Runs the selectUnreadableGraphs prepared statement.
static ClosableIterator<java.lang.Long>	selectUnreadableGraphsLive(PreparedStatementCache sqlCache, long userId, java.lang.String sessionPrefix, java.lang.String tempgraph1, java.lang.String tempgraph2) Runs the selectUnreadableGraphsLive prepared statement with the default transformer.
static ClosableIterator<java.lang.Long>	selectUnreadableGraphsLive(PreparedStatementCache sqlCache, long userId, java.lang.String sessionPrefix, java.lang.String tempgraph1, java.lang.String tempgraph2, Transformer<java.lang.Long> transform) Runs the selectUnreadableGraphsLive prepared statement.
static ClosableIterator<java.lang.Long>	selectUnreadableMetadataGraphs(PreparedStatementCache sqlCache, GlitterRdbWrapper.SelectUnreadableMetadataGraphsParams params, java.lang.String sessionPrefix, java.lang.String tempgraph1, java.lang.String tempgraph2) Runs the selectUnreadableMetadataGraphs prepared statement.
static ClosableIterator<java.lang.Long>	selectUnreadableMetadataGraphs(PreparedStatementCache sqlCache, long userId, java.lang.Long lastTransactionTime1, java.lang.Long lastTransactionTime2, java.lang.String sessionPrefix, java.lang.String tempgraph1, java.lang.String tempgraph2) Runs the selectUnreadableMetadataGraphs prepared statement with the default transformer.
static ClosableIterator<java.lang.Long>	selectUnreadableMetadataGraphs(PreparedStatementCache sqlCache, long userId, java.lang.Long lastTransactionTime1, java.lang.Long lastTransactionTime2, java.lang.String sessionPrefix, java.lang.String tempgraph1, java.lang.String tempgraph2, Transformer<java.lang.Long> transform) Runs the selectUnreadableMetadataGraphs prepared statement.
static ClosableIterator<java.lang.Long>	selectUnreadableMetadataGraphsLive(PreparedStatementCache sqlCache, long userId, java.lang.String sessionPrefix, java.lang.String tempgraph1, java.lang.String tempgraph2) Runs the selectUnreadableMetadataGraphsLive prepared statement with the default transformer.
static ClosableIterator<java.lang.Long>	selectUnreadableMetadataGraphsLive(PreparedStatementCache sqlCache, long userId, java.lang.String sessionPrefix, java.lang.String tempgraph1, java.lang.String tempgraph2, Transformer<java.lang.Long> transform) Runs the selectUnreadableMetadataGraphsLive prepared statement.
static ClosableIterator<java.lang.Long>	selectUntimelyGraphs(PreparedStatementCache sqlCache, GlitterRdbWrapper.SelectUntimelyGraphsParams params, java.lang.String sessionPrefix, java.lang.String tempgraph1, java.lang.String tempgraph2) Runs the selectUntimelyGraphs prepared statement.
static ClosableIterator<java.lang.Long>	selectUntimelyGraphs(PreparedStatementCache sqlCache, java.lang.Long lastTransactionTime1, java.lang.Long lastTransactionTime2, java.lang.String sessionPrefix, java.lang.String tempgraph1, java.lang.String tempgraph2) Runs the selectUntimelyGraphs prepared statement with the default transformer.
static ClosableIterator<java.lang.Long>	selectUntimelyGraphs(PreparedStatementCache sqlCache, java.lang.Long lastTransactionTime1, java.lang.Long lastTransactionTime2, java.lang.String sessionPrefix, java.lang.String tempgraph1, java.lang.String tempgraph2, Transformer<java.lang.Long> transform) Runs the selectUntimelyGraphs prepared statement.
static ClosableIterator<java.lang.Long>	selectUntimelyMetadataGraphs(PreparedStatementCache sqlCache, GlitterRdbWrapper.SelectUntimelyMetadataGraphsParams params, java.lang.String sessionPrefix, java.lang.String tempgraph1, java.lang.String tempgraph2) Runs the selectUntimelyMetadataGraphs prepared statement.
static ClosableIterator<java.lang.Long>	selectUntimelyMetadataGraphs(PreparedStatementCache sqlCache, java.lang.Long lastTransactionTime1, java.lang.Long lastTransactionTime2, java.lang.String sessionPrefix, java.lang.String tempgraph1, java.lang.String tempgraph2) Runs the selectUntimelyMetadataGraphs prepared statement with the default transformer.
static ClosableIterator<java.lang.Long>	selectUntimelyMetadataGraphs(PreparedStatementCache sqlCache, java.lang.Long lastTransactionTime1, java.lang.Long lastTransactionTime2, java.lang.String sessionPrefix, java.lang.String tempgraph1, java.lang.String tempgraph2, Transformer<java.lang.Long> transform) Runs the selectUntimelyMetadataGraphs prepared statement.
static int	truncateTable(PreparedStatementCache sqlCache, java.lang.String table) Runs the truncateTable prepared statement.

Methods inherited from class java.lang.Object

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

Field Detail

insertTempDatasetGraph

public static final java.lang.String insertTempDatasetGraph

Constant "insertTempDatasetGraph" used to reference prepared statement Glitter.insertTempDatasetGraph INSERT INTO ${a}TEMPGRAPHS VALUES (?)

See Also:

Constant Field Values

insertAllNamedGraphs

public static final java.lang.String insertAllNamedGraphs

Constant "insertAllNamedGraphs" used to reference prepared statement Glitter.insertAllNamedGraphs INSERT INTO ${a}TEMPGRAPHS SELECT DISTINCT NG.ID FROM NAMEDGRAPHS NG

See Also:

Constant Field Values

insertAllMetadataGraphs

public static final java.lang.String insertAllMetadataGraphs

Constant "insertAllMetadataGraphs" used to reference prepared statement Glitter.insertAllMetadataGraphs INSERT INTO ${a}TEMPGRAPHS SELECT DISTINCT NG.METAID FROM NAMEDGRAPHS NG

See Also:

Constant Field Values

countRows

public static final java.lang.String countRows

Constant "countRows" used to reference prepared statement Glitter.countRows SELECT COUNT(*) FROM ${a}${b}

See Also:

Constant Field Values

containsGraph

public static final java.lang.String containsGraph

Constant "containsGraph" used to reference prepared statement Glitter.containsGraph SELECT COUNT(*) FROM ${a}${b} TG,NAMEDGRAPHS NG WHERE TG.ID = ? and TG.ID=NG.ID

See Also:

Constant Field Values

containsMetadataGraph

public static final java.lang.String containsMetadataGraph

Constant "containsMetadataGraph" used to reference prepared statement Glitter.containsMetadataGraph SELECT COUNT(*) FROM ${a}${b} TG,NAMEDGRAPHS NG WHERE TG.ID = ? and TG.ID=NG.METAID

See Also:

Constant Field Values

selectGraphs

public static final java.lang.String selectGraphs

Constant "selectGraphs" used to reference prepared statement Glitter.selectGraphs SELECT ID FROM ${a}${b} WHERE META=?

See Also:

Constant Field Values

selectNamedGraphs

public static final java.lang.String selectNamedGraphs

Constant "selectNamedGraphs" used to reference prepared statement Glitter.selectNamedGraphs SELECT ${b}${a}.ID FROM ${b}${a} WHERE ${b}${a}.ID IN (SELECT NG.ID FROM NAMEDGRAPHS NG)

See Also:

Constant Field Values

selectMetadataGraphs

public static final java.lang.String selectMetadataGraphs

Constant "selectMetadataGraphs" used to reference prepared statement Glitter.selectMetadataGraphs SELECT ${b}${a}.ID FROM ${b}${a} WHERE ${b}${a}.ID IN (SELECT NG.METAID FROM NAMEDGRAPHS NG)

See Also:

Constant Field Values

countValidNamedGraphs

public static final java.lang.String countValidNamedGraphs

Constant "countValidNamedGraphs" used to reference prepared statement Glitter.countValidNamedGraphs SELECT COUNT(*) FROM ${b}${a} WHERE ${b}${a}.ID IN (SELECT NG.ID FROM NAMEDGRAPHS NG)

See Also:

Constant Field Values

countValidMetadataGraphs

public static final java.lang.String countValidMetadataGraphs

Constant "countValidMetadataGraphs" used to reference prepared statement Glitter.countValidMetadataGraphs SELECT COUNT(*) FROM ${b}${a} WHERE ${b}${a}.ID IN (SELECT NG.METAID FROM NAMEDGRAPHS NG)

See Also:

Constant Field Values

insertValidDatasetGraphs

public static final java.lang.String insertValidDatasetGraphs

Constant "insertValidDatasetGraphs" used to reference prepared statement Glitter.insertValidDatasetGraphs INSERT INTO ${b}${a} SELECT DISTINCT NG.ID,0 FROM NAMEDGRAPHS NG, ACIS, ${b}TEMPGRAPHS TMP WHERE NG.ID = TMP.ID AND ? >= NG.HSTART AND (NG.HEND IS NULL OR ? < NG.HEND) AND NG.ACLID = ACIS.ACLID AND ACIS.CANREAD = 1 AND ACIS.ROLEID IN (SELECT UR.ROLEID FROM USERSROLES UR WHERE UR.USERID = ? AND ? >= UR.HSTART AND (UR.HEND IS NULL OR ? < UR.HEND) )

See Also:

Constant Field Values

insertValidDatasetGraphsLive

public static final java.lang.String insertValidDatasetGraphsLive

Constant "insertValidDatasetGraphsLive" used to reference prepared statement Glitter.insertValidDatasetGraphsLive INSERT INTO ${b}${a} SELECT DISTINCT NG.ID,0 FROM NAMEDGRAPHS NG, ACIS, ${b}TEMPGRAPHS TMP WHERE NG.ID = TMP.ID AND NG.HEND IS NULL AND NG.ACLID = ACIS.ACLID AND ACIS.CANREAD = 1 AND ACIS.ROLEID IN (SELECT UR.ROLEID FROM USERSROLES UR WHERE UR.USERID = ? AND UR.HEND IS NULL )

See Also:

Constant Field Values

insertValidDatasetMetadataGraphs

public static final java.lang.String insertValidDatasetMetadataGraphs

Constant "insertValidDatasetMetadataGraphs" used to reference prepared statement Glitter.insertValidDatasetMetadataGraphs INSERT INTO ${b}${a} SELECT DISTINCT NG.METAID,1 FROM NAMEDGRAPHS NG, ACIS, ${b}TEMPGRAPHS TMP WHERE NG.METAID = TMP.ID AND ? >= NG.HSTART AND (NG.HEND IS NULL OR ? < NG.HEND) AND NG.ACLID = ACIS.ACLID AND ACIS.CANREAD = 1 AND ACIS.ROLEID IN (SELECT UR.ROLEID FROM USERSROLES UR WHERE UR.USERID = ? AND ? >= UR.HSTART AND (UR.HEND IS NULL OR ? < UR.HEND) )

See Also:

Constant Field Values

insertValidDatasetMetadataGraphsLive

public static final java.lang.String insertValidDatasetMetadataGraphsLive

Constant "insertValidDatasetMetadataGraphsLive" used to reference prepared statement Glitter.insertValidDatasetMetadataGraphsLive INSERT INTO ${b}${a} SELECT DISTINCT NG.METAID,1 FROM NAMEDGRAPHS NG, ACIS, ${b}TEMPGRAPHS TMP WHERE NG.METAID = TMP.ID AND NG.HEND IS NULL AND NG.ACLID = ACIS.ACLID AND ACIS.CANREAD = 1 AND ACIS.ROLEID IN (SELECT UR.ROLEID FROM USERSROLES UR WHERE UR.USERID = ? AND UR.HEND IS NULL )

See Also:

Constant Field Values

insertAllValidDatasetGraphs

public static final java.lang.String insertAllValidDatasetGraphs

Constant "insertAllValidDatasetGraphs" used to reference prepared statement Glitter.insertAllValidDatasetGraphs INSERT INTO ${b}${a} SELECT DISTINCT NG.ID,0 FROM NAMEDGRAPHS NG, ACIS WHERE ? >= NG.HSTART AND (NG.HEND IS NULL OR ? < NG.HEND) AND NG.ACLID = ACIS.ACLID AND ACIS.CANREAD = 1 AND ACIS.ROLEID IN (SELECT UR.ROLEID FROM USERSROLES UR WHERE UR.USERID = ? AND ? >= UR.HSTART AND (UR.HEND IS NULL OR ? < UR.HEND) )

See Also:

Constant Field Values

insertAllValidDatasetGraphsLive

public static final java.lang.String insertAllValidDatasetGraphsLive

Constant "insertAllValidDatasetGraphsLive" used to reference prepared statement Glitter.insertAllValidDatasetGraphsLive INSERT INTO ${b}${a} SELECT DISTINCT NG.ID,0 FROM NAMEDGRAPHS NG, ACIS WHERE NG.HEND IS NULL AND NG.ACLID = ACIS.ACLID AND ACIS.CANREAD = 1 AND ACIS.ROLEID IN (SELECT UR.ROLEID FROM USERSROLES UR WHERE UR.USERID = ? AND UR.HEND IS NULL )

See Also:

Constant Field Values

insertAllValidDatasetMetadataGraphs

public static final java.lang.String insertAllValidDatasetMetadataGraphs

Constant "insertAllValidDatasetMetadataGraphs" used to reference prepared statement Glitter.insertAllValidDatasetMetadataGraphs INSERT INTO ${b}${a} SELECT DISTINCT NG.METAID,1 FROM NAMEDGRAPHS NG, ACIS WHERE ? >= NG.HSTART AND (NG.HEND IS NULL OR ? < NG.HEND) AND NG.ACLID = ACIS.ACLID AND ACIS.CANREAD = 1 AND ACIS.ROLEID IN (SELECT UR.ROLEID FROM USERSROLES UR WHERE UR.USERID = ? AND ? >= UR.HSTART AND (UR.HEND IS NULL OR ? < UR.HEND) )

See Also:

Constant Field Values

insertAllValidDatasetMetadataGraphsLive

public static final java.lang.String insertAllValidDatasetMetadataGraphsLive

Constant "insertAllValidDatasetMetadataGraphsLive" used to reference prepared statement Glitter.insertAllValidDatasetMetadataGraphsLive INSERT INTO ${b}${a} SELECT DISTINCT NG.METAID,1 FROM NAMEDGRAPHS NG, ACIS WHERE NG.HEND IS NULL AND NG.ACLID = ACIS.ACLID AND ACIS.CANREAD = 1 AND ACIS.ROLEID IN (SELECT UR.ROLEID FROM USERSROLES UR WHERE UR.USERID = ? AND UR.HEND IS NULL )

See Also:

Constant Field Values

selectUnreadableGraphs

public static final java.lang.String selectUnreadableGraphs

Constant "selectUnreadableGraphs" used to reference prepared statement Glitter.selectUnreadableGraphs SELECT TMP1.ID FROM ${a}${b} TMP1 LEFT JOIN (SELECT NG.ID FROM NAMEDGRAPHS NG, ACIS, ${a}${c} TMP2 WHERE NG.ID = TMP2.ID AND NG.ACLID = ACIS.ACLID AND ACIS.CANREAD = 1 AND ACIS.ROLEID IN (SELECT UR.ROLEID FROM USERSROLES UR WHERE UR.USERID = ? AND ? >= UR.HSTART AND (UR.HEND IS NULL OR ? < UR.HEND) ) )AS TMP2 ON TMP1.ID=TMP2.ID WHERE TMP2.ID IS NULL

See Also:

Constant Field Values

selectUnreadableGraphsLive

public static final java.lang.String selectUnreadableGraphsLive

Constant "selectUnreadableGraphsLive" used to reference prepared statement Glitter.selectUnreadableGraphsLive SELECT TMP1.ID FROM ${a}${b} TMP1 LEFT JOIN (SELECT NG.ID FROM NAMEDGRAPHS NG, ACIS, ${a}${c} TMP2 WHERE NG.HEND IS NULL AND NG.ID = TMP2.ID AND NG.ACLID = ACIS.ACLID AND ACIS.CANREAD = 1 AND ACIS.ROLEID IN (SELECT UR.ROLEID FROM USERSROLES UR WHERE UR.USERID = ? AND UR.HEND IS NULL ) )AS TMP2 ON TMP1.ID=TMP2.ID WHERE TMP2.ID IS NULL

See Also:

Constant Field Values

selectUnreadableMetadataGraphs

public static final java.lang.String selectUnreadableMetadataGraphs

Constant "selectUnreadableMetadataGraphs" used to reference prepared statement Glitter.selectUnreadableMetadataGraphs SELECT TMP1.ID FROM ${a}${b} TMP1 LEFT JOIN (SELECT NG.METAID FROM NAMEDGRAPHS NG, ACIS, ${a}${c} TMP2 WHERE NG.METAID = TMP2.ID AND NG.ACLID = ACIS.ACLID AND ACIS.CANREAD = 1 AND ACIS.ROLEID IN (SELECT UR.ROLEID FROM USERSROLES UR WHERE UR.USERID = ? AND ? >= UR.HSTART AND (UR.HEND IS NULL OR ? < UR.HEND) ) )AS TMP2 ON TMP1.ID=TMP2.METAID WHERE TMP2.METAID IS NULL

See Also:

Constant Field Values

selectUnreadableMetadataGraphsLive

public static final java.lang.String selectUnreadableMetadataGraphsLive

Constant "selectUnreadableMetadataGraphsLive" used to reference prepared statement Glitter.selectUnreadableMetadataGraphsLive SELECT TMP1.ID FROM ${a}${b} TMP1 LEFT JOIN (SELECT NG.METAID FROM NAMEDGRAPHS NG, ACIS, ${a}${c} TMP2 WHERE NG.HEND IS NULL AND NG.METAID = TMP2.ID AND NG.ACLID = ACIS.ACLID AND ACIS.CANREAD = 1 AND ACIS.ROLEID IN (SELECT UR.ROLEID FROM USERSROLES UR WHERE UR.USERID = ? AND UR.HEND IS NULL ) )AS TMP2 ON TMP1.ID=TMP2.METAID WHERE TMP2.METAID IS NULL

See Also:

Constant Field Values

selectUntimelyGraphs

public static final java.lang.String selectUntimelyGraphs

Constant "selectUntimelyGraphs" used to reference prepared statement Glitter.selectUntimelyGraphs SELECT TMP1.ID FROM ${a}${b} TMP1 LEFT JOIN (SELECT NG.ID FROM NAMEDGRAPHS NG, ${a}${c} TMP2 WHERE NG.ID = TMP2.ID AND ? >= NG.HSTART AND (NG.HEND IS NULL OR ? < NG.HEND) )AS TMP2 ON TMP1.ID=TMP2.ID WHERE TMP2.ID IS NULL

See Also:

Constant Field Values

selectUntimelyMetadataGraphs

public static final java.lang.String selectUntimelyMetadataGraphs

Constant "selectUntimelyMetadataGraphs" used to reference prepared statement Glitter.selectUntimelyMetadataGraphs SELECT TMP1.ID FROM ${a}${b} TMP1 LEFT JOIN (SELECT DISTINCT NG.METAID FROM NAMEDGRAPHS NG, ${a}${c} TMP2 WHERE NG.METAID = TMP2.ID AND ? >= NG.HSTART AND (NG.HEND IS NULL OR ? < NG.HEND) )AS TMP2 ON TMP1.ID=TMP2.METAID WHERE TMP2.METAID IS NULL

See Also:

Constant Field Values

clearTempDatasetTable

public static final java.lang.String clearTempDatasetTable

Constant "clearTempDatasetTable" used to reference prepared statement Glitter.clearTempDatasetTable DELETE FROM ${a} WHERE ID IS NOT NULL

See Also:

Constant Field Values

truncateTable

public static final java.lang.String truncateTable

Constant "truncateTable" used to reference prepared statement Glitter.truncateTable DELETE FROM ${a}

See Also:

Constant Field Values

Constructor Detail

GlitterRdbWrapper

public GlitterRdbWrapper()

Method Detail

insertTempDatasetGraph

public static int insertTempDatasetGraph(PreparedStatementCache sqlCache,
                                         long id,
                                         java.lang.String sessionPrefix)
                                  throws AnzoException,
                                         java.sql.SQLException

Runs the insertTempDatasetGraph prepared statement. INSERT INTO ${a}TEMPGRAPHS VALUES (?)

Parameters:

sqlCache - factory and cache of PreparedStatments

id - template parameter

sessionPrefix - template parameter

Returns:

int

Throws:

AnzoException

java.sql.SQLException

prepareInsertTempDatasetGraph

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

Sets the input parameters for the insertTempDatasetGraph prepared statement.

Parameters:

ps - PreparedStatement to whose parameters are set

id - template parameter

Throws:

java.sql.SQLException

insertAllNamedGraphs

public static int insertAllNamedGraphs(PreparedStatementCache sqlCache,
                                       java.lang.String sessionPrefix)
                                throws AnzoException,
                                       java.sql.SQLException

Runs the insertAllNamedGraphs prepared statement. INSERT INTO ${a}TEMPGRAPHS SELECT DISTINCT NG.ID FROM NAMEDGRAPHS NG

Parameters:

sqlCache - factory and cache of PreparedStatments

sessionPrefix - template parameter

Returns:

int

Throws:

AnzoException

java.sql.SQLException

prepareInsertAllNamedGraphs

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

Sets the input parameters for the insertAllNamedGraphs prepared statement.

Parameters:

ps - PreparedStatement to whose parameters are set

Throws:

java.sql.SQLException

insertAllMetadataGraphs

public static int insertAllMetadataGraphs(PreparedStatementCache sqlCache,
                                          java.lang.String sessionPrefix)
                                   throws AnzoException,
                                          java.sql.SQLException

Runs the insertAllMetadataGraphs prepared statement. INSERT INTO ${a}TEMPGRAPHS SELECT DISTINCT NG.METAID FROM NAMEDGRAPHS NG

Parameters:

sqlCache - factory and cache of PreparedStatments

sessionPrefix - template parameter

Returns:

int

Throws:

AnzoException

java.sql.SQLException

prepareInsertAllMetadataGraphs

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

Sets the input parameters for the insertAllMetadataGraphs prepared statement.

Parameters:

ps - PreparedStatement to whose parameters are set

Throws:

java.sql.SQLException

countRows

public static java.lang.Integer countRows(PreparedStatementCache sqlCache,
                                          java.lang.String sessionPrefix,
                                          java.lang.String tableName)
                                   throws AnzoException,
                                          java.sql.SQLException

Runs the countRows prepared statement. SELECT COUNT(*) FROM ${a}${b}

Parameters:

sqlCache - factory and cache of PreparedStatments

sessionPrefix - template parameter

tableName - template parameter

Returns:

Integer

Throws:

AnzoException

java.sql.SQLException

prepareCountRows

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

Sets the input parameters for the countRows prepared statement.

Parameters:

ps - PreparedStatement to whose parameters are set

Throws:

java.sql.SQLException

containsGraph

public static java.lang.Integer containsGraph(PreparedStatementCache sqlCache,
                                              long id,
                                              java.lang.String sessionPrefix,
                                              java.lang.String tableName)
                                       throws AnzoException,
                                              java.sql.SQLException

Runs the containsGraph prepared statement. SELECT COUNT(*) FROM ${a}${b} TG,NAMEDGRAPHS NG WHERE TG.ID = ? and TG.ID=NG.ID

Parameters:

sqlCache - factory and cache of PreparedStatments

id - template parameter

sessionPrefix - template parameter

tableName - template parameter

Returns:

Integer

Throws:

AnzoException

java.sql.SQLException

prepareContainsGraph

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

Sets the input parameters for the containsGraph prepared statement.

Parameters:

ps - PreparedStatement to whose parameters are set

id - template parameter

Throws:

java.sql.SQLException

containsMetadataGraph

public static java.lang.Integer containsMetadataGraph(PreparedStatementCache sqlCache,
                                                      long id,
                                                      java.lang.String sessionPrefix,
                                                      java.lang.String tableName)
                                               throws AnzoException,
                                                      java.sql.SQLException

Runs the containsMetadataGraph prepared statement. SELECT COUNT(*) FROM ${a}${b} TG,NAMEDGRAPHS NG WHERE TG.ID = ? and TG.ID=NG.METAID

Parameters:

sqlCache - factory and cache of PreparedStatments

id - template parameter

sessionPrefix - template parameter

tableName - template parameter

Returns:

Integer

Throws:

AnzoException

java.sql.SQLException

prepareContainsMetadataGraph

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

Sets the input parameters for the containsMetadataGraph prepared statement.

Parameters:

ps - PreparedStatement to whose parameters are set

id - template parameter

Throws:

java.sql.SQLException

selectGraphs

public static ClosableIterator<java.lang.Long> selectGraphs(PreparedStatementCache sqlCache,
                                                            java.lang.Long meta,
                                                            java.lang.String tableName,
                                                            java.lang.String sessionPrefix)
                                                     throws AnzoException,
                                                            java.sql.SQLException

Runs the selectGraphs prepared statement with the default transformer. SELECT ID FROM ${a}${b} WHERE META=?

Parameters:

sqlCache - factory and cache of PreparedStatments

meta - template parameter

tableName - template parameter

sessionPrefix - template parameter

Returns:

org.openanzo.jdbc.utils.ClosableIterator

Throws:

AnzoException

java.sql.SQLException

selectGraphs

public static ClosableIterator<java.lang.Long> selectGraphs(PreparedStatementCache sqlCache,
                                                            java.lang.Long meta,
                                                            java.lang.String tableName,
                                                            java.lang.String sessionPrefix,
                                                            Transformer<java.lang.Long> transform)
                                                     throws AnzoException,
                                                            java.sql.SQLException

Runs the selectGraphs prepared statement. SELECT ID FROM ${a}${b} WHERE META=?

Parameters:

sqlCache - factory and cache of PreparedStatments

meta - template parameter

tableName - template parameter

sessionPrefix - template parameter

transform - org.openanzo.jdbc.utils.Transformer used to transform results into java objects

Returns:

org.openanzo.jdbc.utils.ClosableIterator

Throws:

AnzoException

java.sql.SQLException

prepareSelectGraphs

public static void prepareSelectGraphs(java.sql.PreparedStatement ps,
                                       java.lang.Long meta)
                                throws java.sql.SQLException

Sets the input parameters for the selectGraphs prepared statement.

Parameters:

ps - PreparedStatement to whose parameters are set

meta - template parameter

Throws:

java.sql.SQLException

selectNamedGraphs

public static ClosableIterator<java.lang.Long> selectNamedGraphs(PreparedStatementCache sqlCache,
                                                                 java.lang.String tableName,
                                                                 java.lang.String sessionPrefix)
                                                          throws AnzoException,
                                                                 java.sql.SQLException

Runs the selectNamedGraphs prepared statement with the default transformer. SELECT ${b}${a}.ID FROM ${b}${a} WHERE ${b}${a}.ID IN (SELECT NG.ID FROM NAMEDGRAPHS NG)

Parameters:

sqlCache - factory and cache of PreparedStatments

tableName - template parameter

sessionPrefix - template parameter

Returns:

org.openanzo.jdbc.utils.ClosableIterator

Throws:

AnzoException

java.sql.SQLException

selectNamedGraphs

public static ClosableIterator<java.lang.Long> selectNamedGraphs(PreparedStatementCache sqlCache,
                                                                 java.lang.String tableName,
                                                                 java.lang.String sessionPrefix,
                                                                 Transformer<java.lang.Long> transform)
                                                          throws AnzoException,
                                                                 java.sql.SQLException

Runs the selectNamedGraphs prepared statement. SELECT ${b}${a}.ID FROM ${b}${a} WHERE ${b}${a}.ID IN (SELECT NG.ID FROM NAMEDGRAPHS NG)

Parameters:

sqlCache - factory and cache of PreparedStatments

tableName - template parameter

sessionPrefix - template parameter

transform - org.openanzo.jdbc.utils.Transformer used to transform results into java objects

Returns:

org.openanzo.jdbc.utils.ClosableIterator

Throws:

AnzoException

java.sql.SQLException

prepareSelectNamedGraphs

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

Sets the input parameters for the selectNamedGraphs prepared statement.

Parameters:

ps - PreparedStatement to whose parameters are set

Throws:

java.sql.SQLException

selectMetadataGraphs

public static ClosableIterator<java.lang.Long> selectMetadataGraphs(PreparedStatementCache sqlCache,
                                                                    java.lang.String tableName,
                                                                    java.lang.String sessionPrefix)
                                                             throws AnzoException,
                                                                    java.sql.SQLException

Runs the selectMetadataGraphs prepared statement with the default transformer. SELECT ${b}${a}.ID FROM ${b}${a} WHERE ${b}${a}.ID IN (SELECT NG.METAID FROM NAMEDGRAPHS NG)

Parameters:

sqlCache - factory and cache of PreparedStatments

tableName - template parameter

sessionPrefix - template parameter

Returns:

org.openanzo.jdbc.utils.ClosableIterator

Throws:

AnzoException

java.sql.SQLException

selectMetadataGraphs

public static ClosableIterator<java.lang.Long> selectMetadataGraphs(PreparedStatementCache sqlCache,
                                                                    java.lang.String tableName,
                                                                    java.lang.String sessionPrefix,
                                                                    Transformer<java.lang.Long> transform)
                                                             throws AnzoException,
                                                                    java.sql.SQLException

Runs the selectMetadataGraphs prepared statement. SELECT ${b}${a}.ID FROM ${b}${a} WHERE ${b}${a}.ID IN (SELECT NG.METAID FROM NAMEDGRAPHS NG)

Parameters:

sqlCache - factory and cache of PreparedStatments

tableName - template parameter

sessionPrefix - template parameter

transform - org.openanzo.jdbc.utils.Transformer used to transform results into java objects

Returns:

org.openanzo.jdbc.utils.ClosableIterator

Throws:

AnzoException

java.sql.SQLException

prepareSelectMetadataGraphs

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

Sets the input parameters for the selectMetadataGraphs prepared statement.

Parameters:

ps - PreparedStatement to whose parameters are set

Throws:

java.sql.SQLException

countValidNamedGraphs

public static java.lang.Long countValidNamedGraphs(PreparedStatementCache sqlCache,
                                                   java.lang.String tableName,
                                                   java.lang.String sessionPrefix)
                                            throws AnzoException,
                                                   java.sql.SQLException

Runs the countValidNamedGraphs prepared statement. SELECT COUNT(*) FROM ${b}${a} WHERE ${b}${a}.ID IN (SELECT NG.ID FROM NAMEDGRAPHS NG)

Parameters:

sqlCache - factory and cache of PreparedStatments

tableName - template parameter

sessionPrefix - template parameter

Returns:

Long

Throws:

AnzoException

java.sql.SQLException

prepareCountValidNamedGraphs

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

Sets the input parameters for the countValidNamedGraphs prepared statement.

Parameters:

ps - PreparedStatement to whose parameters are set

Throws:

java.sql.SQLException

countValidMetadataGraphs

public static java.lang.Long countValidMetadataGraphs(PreparedStatementCache sqlCache,
                                                      java.lang.String tableName,
                                                      java.lang.String sessionPrefix)
                                               throws AnzoException,
                                                      java.sql.SQLException

Runs the countValidMetadataGraphs prepared statement. SELECT COUNT(*) FROM ${b}${a} WHERE ${b}${a}.ID IN (SELECT NG.METAID FROM NAMEDGRAPHS NG)

Parameters:

sqlCache - factory and cache of PreparedStatments

tableName - template parameter

sessionPrefix - template parameter

Returns:

Long

Throws:

AnzoException

java.sql.SQLException

prepareCountValidMetadataGraphs

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

Sets the input parameters for the countValidMetadataGraphs prepared statement.

Parameters:

ps - PreparedStatement to whose parameters are set

Throws:

java.sql.SQLException

insertValidDatasetGraphs

public static int insertValidDatasetGraphs(PreparedStatementCache sqlCache,
                                           GlitterRdbWrapper.InsertValidDatasetGraphsParams params,
                                           java.lang.String tableName,
                                           java.lang.String sessionPrefix)
                                    throws AnzoException,
                                           java.sql.SQLException

Runs the insertValidDatasetGraphs prepared statement. INSERT INTO ${b}${a} SELECT DISTINCT NG.ID,0 FROM NAMEDGRAPHS NG, ACIS, ${b}TEMPGRAPHS TMP WHERE NG.ID = TMP.ID AND ? >= NG.HSTART AND (NG.HEND IS NULL OR ? < NG.HEND) AND NG.ACLID = ACIS.ACLID AND ACIS.CANREAD = 1 AND ACIS.ROLEID IN (SELECT UR.ROLEID FROM USERSROLES UR WHERE UR.USERID = ? AND ? >= UR.HSTART AND (UR.HEND IS NULL OR ? < UR.HEND) )

Parameters:

sqlCache - factory and cache of PreparedStatments

params - InsertValidDatasetGraphsParams input Interface

tableName - template parameter

sessionPrefix - template parameter

Returns:

int containing the results of the SQL operation

Throws:

AnzoException

java.sql.SQLException

insertValidDatasetGraphs

public static int insertValidDatasetGraphs(PreparedStatementCache sqlCache,
                                           java.lang.Long lastTransactionTime1,
                                           java.lang.Long lastTransactionTime2,
                                           long userId,
                                           java.lang.Long lastTransactionTime3,
                                           java.lang.Long lastTransactionTime4,
                                           java.lang.String tableName,
                                           java.lang.String sessionPrefix)
                                    throws AnzoException,
                                           java.sql.SQLException

Runs the insertValidDatasetGraphs prepared statement. INSERT INTO ${b}${a} SELECT DISTINCT NG.ID,0 FROM NAMEDGRAPHS NG, ACIS, ${b}TEMPGRAPHS TMP WHERE NG.ID = TMP.ID AND ? >= NG.HSTART AND (NG.HEND IS NULL OR ? < NG.HEND) AND NG.ACLID = ACIS.ACLID AND ACIS.CANREAD = 1 AND ACIS.ROLEID IN (SELECT UR.ROLEID FROM USERSROLES UR WHERE UR.USERID = ? AND ? >= UR.HSTART AND (UR.HEND IS NULL OR ? < UR.HEND) )

Parameters:

sqlCache - factory and cache of PreparedStatments

lastTransactionTime1 - template parameter

lastTransactionTime2 - template parameter

userId - template parameter

lastTransactionTime3 - template parameter

lastTransactionTime4 - template parameter

tableName - template parameter

sessionPrefix - template parameter

Returns:

int

Throws:

AnzoException

java.sql.SQLException

prepareInsertValidDatasetGraphs

public static void prepareInsertValidDatasetGraphs(java.sql.PreparedStatement ps,
                                                   java.lang.Long lastTransactionTime1,
                                                   java.lang.Long lastTransactionTime2,
                                                   long userId,
                                                   java.lang.Long lastTransactionTime3,
                                                   java.lang.Long lastTransactionTime4)
                                            throws java.sql.SQLException

Sets the input parameters for the insertValidDatasetGraphs prepared statement.

Parameters:

ps - PreparedStatement to whose parameters are set

lastTransactionTime1 - template parameter

lastTransactionTime2 - template parameter

userId - template parameter

lastTransactionTime3 - template parameter

lastTransactionTime4 - template parameter

Throws:

java.sql.SQLException

insertValidDatasetGraphsLive

public static int insertValidDatasetGraphsLive(PreparedStatementCache sqlCache,
                                               long userId,
                                               java.lang.String tableName,
                                               java.lang.String sessionPrefix)
                                        throws AnzoException,
                                               java.sql.SQLException

Runs the insertValidDatasetGraphsLive prepared statement. INSERT INTO ${b}${a} SELECT DISTINCT NG.ID,0 FROM NAMEDGRAPHS NG, ACIS, ${b}TEMPGRAPHS TMP WHERE NG.ID = TMP.ID AND NG.HEND IS NULL AND NG.ACLID = ACIS.ACLID AND ACIS.CANREAD = 1 AND ACIS.ROLEID IN (SELECT UR.ROLEID FROM USERSROLES UR WHERE UR.USERID = ? AND UR.HEND IS NULL )

Parameters:

sqlCache - factory and cache of PreparedStatments

userId - template parameter

tableName - template parameter

sessionPrefix - template parameter

Returns:

int

Throws:

AnzoException

java.sql.SQLException

prepareInsertValidDatasetGraphsLive

public static void prepareInsertValidDatasetGraphsLive(java.sql.PreparedStatement ps,
                                                       long userId)
                                                throws java.sql.SQLException

Sets the input parameters for the insertValidDatasetGraphsLive prepared statement.

Parameters:

ps - PreparedStatement to whose parameters are set

userId - template parameter

Throws:

java.sql.SQLException

insertValidDatasetMetadataGraphs

public static int insertValidDatasetMetadataGraphs(PreparedStatementCache sqlCache,
                                                   GlitterRdbWrapper.InsertValidDatasetMetadataGraphsParams params,
                                                   java.lang.String tableName,
                                                   java.lang.String sessionPrefix)
                                            throws AnzoException,
                                                   java.sql.SQLException

Runs the insertValidDatasetMetadataGraphs prepared statement. INSERT INTO ${b}${a} SELECT DISTINCT NG.METAID,1 FROM NAMEDGRAPHS NG, ACIS, ${b}TEMPGRAPHS TMP WHERE NG.METAID = TMP.ID AND ? >= NG.HSTART AND (NG.HEND IS NULL OR ? < NG.HEND) AND NG.ACLID = ACIS.ACLID AND ACIS.CANREAD = 1 AND ACIS.ROLEID IN (SELECT UR.ROLEID FROM USERSROLES UR WHERE UR.USERID = ? AND ? >= UR.HSTART AND (UR.HEND IS NULL OR ? < UR.HEND) )

Parameters:

sqlCache - factory and cache of PreparedStatments

params - InsertValidDatasetMetadataGraphsParams input Interface

tableName - template parameter

sessionPrefix - template parameter

Returns:

int containing the results of the SQL operation

Throws:

AnzoException

java.sql.SQLException

insertValidDatasetMetadataGraphs

public static int insertValidDatasetMetadataGraphs(PreparedStatementCache sqlCache,
                                                   java.lang.Long lastTransactionTime1,
                                                   java.lang.Long lastTransactionTime2,
                                                   long userId,
                                                   java.lang.Long lastTransactionTime3,
                                                   java.lang.Long lastTransactionTime4,
                                                   java.lang.String tableName,
                                                   java.lang.String sessionPrefix)
                                            throws AnzoException,
                                                   java.sql.SQLException

Runs the insertValidDatasetMetadataGraphs prepared statement. INSERT INTO ${b}${a} SELECT DISTINCT NG.METAID,1 FROM NAMEDGRAPHS NG, ACIS, ${b}TEMPGRAPHS TMP WHERE NG.METAID = TMP.ID AND ? >= NG.HSTART AND (NG.HEND IS NULL OR ? < NG.HEND) AND NG.ACLID = ACIS.ACLID AND ACIS.CANREAD = 1 AND ACIS.ROLEID IN (SELECT UR.ROLEID FROM USERSROLES UR WHERE UR.USERID = ? AND ? >= UR.HSTART AND (UR.HEND IS NULL OR ? < UR.HEND) )

Parameters:

sqlCache - factory and cache of PreparedStatments

lastTransactionTime1 - template parameter

lastTransactionTime2 - template parameter

userId - template parameter

lastTransactionTime3 - template parameter

lastTransactionTime4 - template parameter

tableName - template parameter

sessionPrefix - template parameter

Returns:

int

Throws:

AnzoException

java.sql.SQLException

prepareInsertValidDatasetMetadataGraphs

public static void prepareInsertValidDatasetMetadataGraphs(java.sql.PreparedStatement ps,
                                                           java.lang.Long lastTransactionTime1,
                                                           java.lang.Long lastTransactionTime2,
                                                           long userId,
                                                           java.lang.Long lastTransactionTime3,
                                                           java.lang.Long lastTransactionTime4)
                                                    throws java.sql.SQLException

Sets the input parameters for the insertValidDatasetMetadataGraphs prepared statement.

Parameters:

ps - PreparedStatement to whose parameters are set

lastTransactionTime1 - template parameter

lastTransactionTime2 - template parameter

userId - template parameter

lastTransactionTime3 - template parameter

lastTransactionTime4 - template parameter

Throws:

java.sql.SQLException

insertValidDatasetMetadataGraphsLive

public static int insertValidDatasetMetadataGraphsLive(PreparedStatementCache sqlCache,
                                                       long userId,
                                                       java.lang.String tableName,
                                                       java.lang.String sessionPrefix)
                                                throws AnzoException,
                                                       java.sql.SQLException

Runs the insertValidDatasetMetadataGraphsLive prepared statement. INSERT INTO ${b}${a} SELECT DISTINCT NG.METAID,1 FROM NAMEDGRAPHS NG, ACIS, ${b}TEMPGRAPHS TMP WHERE NG.METAID = TMP.ID AND NG.HEND IS NULL AND NG.ACLID = ACIS.ACLID AND ACIS.CANREAD = 1 AND ACIS.ROLEID IN (SELECT UR.ROLEID FROM USERSROLES UR WHERE UR.USERID = ? AND UR.HEND IS NULL )

Parameters:

sqlCache - factory and cache of PreparedStatments

userId - template parameter

tableName - template parameter

sessionPrefix - template parameter

Returns:

int

Throws:

AnzoException

java.sql.SQLException

prepareInsertValidDatasetMetadataGraphsLive

public static void prepareInsertValidDatasetMetadataGraphsLive(java.sql.PreparedStatement ps,
                                                               long userId)
                                                        throws java.sql.SQLException

Sets the input parameters for the insertValidDatasetMetadataGraphsLive prepared statement.

Parameters:

ps - PreparedStatement to whose parameters are set

userId - template parameter

Throws:

java.sql.SQLException

insertAllValidDatasetGraphs

public static int insertAllValidDatasetGraphs(PreparedStatementCache sqlCache,
                                              GlitterRdbWrapper.InsertAllValidDatasetGraphsParams params,
                                              java.lang.String tableName,
                                              java.lang.String sessionPrefix)
                                       throws AnzoException,
                                              java.sql.SQLException

Runs the insertAllValidDatasetGraphs prepared statement. INSERT INTO ${b}${a} SELECT DISTINCT NG.ID,0 FROM NAMEDGRAPHS NG, ACIS WHERE ? >= NG.HSTART AND (NG.HEND IS NULL OR ? < NG.HEND) AND NG.ACLID = ACIS.ACLID AND ACIS.CANREAD = 1 AND ACIS.ROLEID IN (SELECT UR.ROLEID FROM USERSROLES UR WHERE UR.USERID = ? AND ? >= UR.HSTART AND (UR.HEND IS NULL OR ? < UR.HEND) )

Parameters:

sqlCache - factory and cache of PreparedStatments

params - InsertAllValidDatasetGraphsParams input Interface

tableName - template parameter

sessionPrefix - template parameter

Returns:

int containing the results of the SQL operation

Throws:

AnzoException

java.sql.SQLException

insertAllValidDatasetGraphs

public static int insertAllValidDatasetGraphs(PreparedStatementCache sqlCache,
                                              java.lang.Long lastTransactionTime1,
                                              java.lang.Long lastTransactionTime2,
                                              long userId,
                                              java.lang.Long lastTransactionTime3,
                                              java.lang.Long lastTransactionTime4,
                                              java.lang.String tableName,
                                              java.lang.String sessionPrefix)
                                       throws AnzoException,
                                              java.sql.SQLException

Runs the insertAllValidDatasetGraphs prepared statement. INSERT INTO ${b}${a} SELECT DISTINCT NG.ID,0 FROM NAMEDGRAPHS NG, ACIS WHERE ? >= NG.HSTART AND (NG.HEND IS NULL OR ? < NG.HEND) AND NG.ACLID = ACIS.ACLID AND ACIS.CANREAD = 1 AND ACIS.ROLEID IN (SELECT UR.ROLEID FROM USERSROLES UR WHERE UR.USERID = ? AND ? >= UR.HSTART AND (UR.HEND IS NULL OR ? < UR.HEND) )

Parameters:

sqlCache - factory and cache of PreparedStatments

lastTransactionTime1 - template parameter

lastTransactionTime2 - template parameter

userId - template parameter

lastTransactionTime3 - template parameter

lastTransactionTime4 - template parameter

tableName - template parameter

sessionPrefix - template parameter

Returns:

int

Throws:

AnzoException

java.sql.SQLException

prepareInsertAllValidDatasetGraphs

public static void prepareInsertAllValidDatasetGraphs(java.sql.PreparedStatement ps,
                                                      java.lang.Long lastTransactionTime1,
                                                      java.lang.Long lastTransactionTime2,
                                                      long userId,
                                                      java.lang.Long lastTransactionTime3,
                                                      java.lang.Long lastTransactionTime4)
                                               throws java.sql.SQLException

Sets the input parameters for the insertAllValidDatasetGraphs prepared statement.

Parameters:

ps - PreparedStatement to whose parameters are set

lastTransactionTime1 - template parameter

lastTransactionTime2 - template parameter

userId - template parameter

lastTransactionTime3 - template parameter

lastTransactionTime4 - template parameter

Throws:

java.sql.SQLException

insertAllValidDatasetGraphsLive

public static int insertAllValidDatasetGraphsLive(PreparedStatementCache sqlCache,
                                                  long userId,
                                                  java.lang.String tableName,
                                                  java.lang.String sessionPrefix)
                                           throws AnzoException,
                                                  java.sql.SQLException

Runs the insertAllValidDatasetGraphsLive prepared statement. INSERT INTO ${b}${a} SELECT DISTINCT NG.ID,0 FROM NAMEDGRAPHS NG, ACIS WHERE NG.HEND IS NULL AND NG.ACLID = ACIS.ACLID AND ACIS.CANREAD = 1 AND ACIS.ROLEID IN (SELECT UR.ROLEID FROM USERSROLES UR WHERE UR.USERID = ? AND UR.HEND IS NULL )

Parameters:

sqlCache - factory and cache of PreparedStatments

userId - template parameter

tableName - template parameter

sessionPrefix - template parameter

Returns:

int

Throws:

AnzoException

java.sql.SQLException

prepareInsertAllValidDatasetGraphsLive

public static void prepareInsertAllValidDatasetGraphsLive(java.sql.PreparedStatement ps,
                                                          long userId)
                                                   throws java.sql.SQLException

Sets the input parameters for the insertAllValidDatasetGraphsLive prepared statement.

Parameters:

ps - PreparedStatement to whose parameters are set

userId - template parameter

Throws:

java.sql.SQLException

insertAllValidDatasetMetadataGraphs

public static int insertAllValidDatasetMetadataGraphs(PreparedStatementCache sqlCache,
                                                      GlitterRdbWrapper.InsertAllValidDatasetMetadataGraphsParams params,
                                                      java.lang.String tableName,
                                                      java.lang.String sessionPrefix)
                                               throws AnzoException,
                                                      java.sql.SQLException

Runs the insertAllValidDatasetMetadataGraphs prepared statement. INSERT INTO ${b}${a} SELECT DISTINCT NG.METAID,1 FROM NAMEDGRAPHS NG, ACIS WHERE ? >= NG.HSTART AND (NG.HEND IS NULL OR ? < NG.HEND) AND NG.ACLID = ACIS.ACLID AND ACIS.CANREAD = 1 AND ACIS.ROLEID IN (SELECT UR.ROLEID FROM USERSROLES UR WHERE UR.USERID = ? AND ? >= UR.HSTART AND (UR.HEND IS NULL OR ? < UR.HEND) )

Parameters:

sqlCache - factory and cache of PreparedStatments

params - InsertAllValidDatasetMetadataGraphsParams input Interface

tableName - template parameter

sessionPrefix - template parameter

Returns:

int containing the results of the SQL operation

Throws:

AnzoException

java.sql.SQLException

insertAllValidDatasetMetadataGraphs

public static int insertAllValidDatasetMetadataGraphs(PreparedStatementCache sqlCache,
                                                      java.lang.Long lastTransactionTime1,
                                                      java.lang.Long lastTransactionTime2,
                                                      long userId,
                                                      java.lang.Long lastTransactionTime3,
                                                      java.lang.Long lastTransactionTime4,
                                                      java.lang.String tableName,
                                                      java.lang.String sessionPrefix)
                                               throws AnzoException,
                                                      java.sql.SQLException

Runs the insertAllValidDatasetMetadataGraphs prepared statement. INSERT INTO ${b}${a} SELECT DISTINCT NG.METAID,1 FROM NAMEDGRAPHS NG, ACIS WHERE ? >= NG.HSTART AND (NG.HEND IS NULL OR ? < NG.HEND) AND NG.ACLID = ACIS.ACLID AND ACIS.CANREAD = 1 AND ACIS.ROLEID IN (SELECT UR.ROLEID FROM USERSROLES UR WHERE UR.USERID = ? AND ? >= UR.HSTART AND (UR.HEND IS NULL OR ? < UR.HEND) )

Parameters:

sqlCache - factory and cache of PreparedStatments

lastTransactionTime1 - template parameter

lastTransactionTime2 - template parameter

userId - template parameter

lastTransactionTime3 - template parameter

lastTransactionTime4 - template parameter

tableName - template parameter

sessionPrefix - template parameter

Returns:

int

Throws:

AnzoException

java.sql.SQLException

prepareInsertAllValidDatasetMetadataGraphs

public static void prepareInsertAllValidDatasetMetadataGraphs(java.sql.PreparedStatement ps,
                                                              java.lang.Long lastTransactionTime1,
                                                              java.lang.Long lastTransactionTime2,
                                                              long userId,
                                                              java.lang.Long lastTransactionTime3,
                                                              java.lang.Long lastTransactionTime4)
                                                       throws java.sql.SQLException

Sets the input parameters for the insertAllValidDatasetMetadataGraphs prepared statement.

Parameters:

ps - PreparedStatement to whose parameters are set

lastTransactionTime1 - template parameter

lastTransactionTime2 - template parameter

userId - template parameter

lastTransactionTime3 - template parameter

lastTransactionTime4 - template parameter

Throws:

java.sql.SQLException

insertAllValidDatasetMetadataGraphsLive

public static int insertAllValidDatasetMetadataGraphsLive(PreparedStatementCache sqlCache,
                                                          long userId,
                                                          java.lang.String tableName,
                                                          java.lang.String sessionPrefix)
                                                   throws AnzoException,
                                                          java.sql.SQLException

Runs the insertAllValidDatasetMetadataGraphsLive prepared statement. INSERT INTO ${b}${a} SELECT DISTINCT NG.METAID,1 FROM NAMEDGRAPHS NG, ACIS WHERE NG.HEND IS NULL AND NG.ACLID = ACIS.ACLID AND ACIS.CANREAD = 1 AND ACIS.ROLEID IN (SELECT UR.ROLEID FROM USERSROLES UR WHERE UR.USERID = ? AND UR.HEND IS NULL )

Parameters:

sqlCache - factory and cache of PreparedStatments

userId - template parameter

tableName - template parameter

sessionPrefix - template parameter

Returns:

int

Throws:

AnzoException

java.sql.SQLException

prepareInsertAllValidDatasetMetadataGraphsLive

public static void prepareInsertAllValidDatasetMetadataGraphsLive(java.sql.PreparedStatement ps,
                                                                  long userId)
                                                           throws java.sql.SQLException

Sets the input parameters for the insertAllValidDatasetMetadataGraphsLive prepared statement.

Parameters:

ps - PreparedStatement to whose parameters are set

userId - template parameter

Throws:

java.sql.SQLException

selectUnreadableGraphs

public static ClosableIterator<java.lang.Long> selectUnreadableGraphs(PreparedStatementCache sqlCache,
                                                                      GlitterRdbWrapper.SelectUnreadableGraphsParams params,
                                                                      java.lang.String sessionPrefix,
                                                                      java.lang.String tempgraph1,
                                                                      java.lang.String tempgraph2)
                                                               throws AnzoException,
                                                                      java.sql.SQLException

Runs the selectUnreadableGraphs prepared statement. SELECT TMP1.ID FROM ${a}${b} TMP1 LEFT JOIN (SELECT NG.ID FROM NAMEDGRAPHS NG, ACIS, ${a}${c} TMP2 WHERE NG.ID = TMP2.ID AND NG.ACLID = ACIS.ACLID AND ACIS.CANREAD = 1 AND ACIS.ROLEID IN (SELECT UR.ROLEID FROM USERSROLES UR WHERE UR.USERID = ? AND ? >= UR.HSTART AND (UR.HEND IS NULL OR ? < UR.HEND) ) )AS TMP2 ON TMP1.ID=TMP2.ID WHERE TMP2.ID IS NULL

Parameters:

sqlCache - factory and cache of PreparedStatments

params - SelectUnreadableGraphsParams input Interface

sessionPrefix - template parameter

tempgraph1 - template parameter

tempgraph2 - template parameter

Returns:

org.openanzo.jdbc.utils.ClosableIterator containing the results of the SQL operation

Throws:

AnzoException

java.sql.SQLException

selectUnreadableGraphs

public static ClosableIterator<java.lang.Long> selectUnreadableGraphs(PreparedStatementCache sqlCache,
                                                                      long userId,
                                                                      java.lang.Long lastTransactionTime1,
                                                                      java.lang.Long lastTransactionTime2,
                                                                      java.lang.String sessionPrefix,
                                                                      java.lang.String tempgraph1,
                                                                      java.lang.String tempgraph2)
                                                               throws AnzoException,
                                                                      java.sql.SQLException

Runs the selectUnreadableGraphs prepared statement with the default transformer. SELECT TMP1.ID FROM ${a}${b} TMP1 LEFT JOIN (SELECT NG.ID FROM NAMEDGRAPHS NG, ACIS, ${a}${c} TMP2 WHERE NG.ID = TMP2.ID AND NG.ACLID = ACIS.ACLID AND ACIS.CANREAD = 1 AND ACIS.ROLEID IN (SELECT UR.ROLEID FROM USERSROLES UR WHERE UR.USERID = ? AND ? >= UR.HSTART AND (UR.HEND IS NULL OR ? < UR.HEND) ) )AS TMP2 ON TMP1.ID=TMP2.ID WHERE TMP2.ID IS NULL

Parameters:

sqlCache - factory and cache of PreparedStatments

userId - template parameter

lastTransactionTime1 - template parameter

lastTransactionTime2 - template parameter

sessionPrefix - template parameter

tempgraph1 - template parameter

tempgraph2 - template parameter

Returns:

org.openanzo.jdbc.utils.ClosableIterator

Throws:

AnzoException

java.sql.SQLException

selectUnreadableGraphs

public static ClosableIterator<java.lang.Long> selectUnreadableGraphs(PreparedStatementCache sqlCache,
                                                                      long userId,
                                                                      java.lang.Long lastTransactionTime1,
                                                                      java.lang.Long lastTransactionTime2,
                                                                      java.lang.String sessionPrefix,
                                                                      java.lang.String tempgraph1,
                                                                      java.lang.String tempgraph2,
                                                                      Transformer<java.lang.Long> transform)
                                                               throws AnzoException,
                                                                      java.sql.SQLException

Runs the selectUnreadableGraphs prepared statement. SELECT TMP1.ID FROM ${a}${b} TMP1 LEFT JOIN (SELECT NG.ID FROM NAMEDGRAPHS NG, ACIS, ${a}${c} TMP2 WHERE NG.ID = TMP2.ID AND NG.ACLID = ACIS.ACLID AND ACIS.CANREAD = 1 AND ACIS.ROLEID IN (SELECT UR.ROLEID FROM USERSROLES UR WHERE UR.USERID = ? AND ? >= UR.HSTART AND (UR.HEND IS NULL OR ? < UR.HEND) ) )AS TMP2 ON TMP1.ID=TMP2.ID WHERE TMP2.ID IS NULL

Parameters:

sqlCache - factory and cache of PreparedStatments

userId - template parameter

lastTransactionTime1 - template parameter

lastTransactionTime2 - template parameter

sessionPrefix - template parameter

tempgraph1 - template parameter

tempgraph2 - template parameter

transform - org.openanzo.jdbc.utils.Transformer used to transform results into java objects

Returns:

org.openanzo.jdbc.utils.ClosableIterator

Throws:

AnzoException

java.sql.SQLException

prepareSelectUnreadableGraphs

public static void prepareSelectUnreadableGraphs(java.sql.PreparedStatement ps,
                                                 long userId,
                                                 java.lang.Long lastTransactionTime1,
                                                 java.lang.Long lastTransactionTime2)
                                          throws java.sql.SQLException

Sets the input parameters for the selectUnreadableGraphs prepared statement.

Parameters:

ps - PreparedStatement to whose parameters are set

userId - template parameter

lastTransactionTime1 - template parameter

lastTransactionTime2 - template parameter

Throws:

java.sql.SQLException

selectUnreadableGraphsLive

public static ClosableIterator<java.lang.Long> selectUnreadableGraphsLive(PreparedStatementCache sqlCache,
                                                                          long userId,
                                                                          java.lang.String sessionPrefix,
                                                                          java.lang.String tempgraph1,
                                                                          java.lang.String tempgraph2)
                                                                   throws AnzoException,
                                                                          java.sql.SQLException

Runs the selectUnreadableGraphsLive prepared statement with the default transformer. SELECT TMP1.ID FROM ${a}${b} TMP1 LEFT JOIN (SELECT NG.ID FROM NAMEDGRAPHS NG, ACIS, ${a}${c} TMP2 WHERE NG.HEND IS NULL AND NG.ID = TMP2.ID AND NG.ACLID = ACIS.ACLID AND ACIS.CANREAD = 1 AND ACIS.ROLEID IN (SELECT UR.ROLEID FROM USERSROLES UR WHERE UR.USERID = ? AND UR.HEND IS NULL ) )AS TMP2 ON TMP1.ID=TMP2.ID WHERE TMP2.ID IS NULL

Parameters:

sqlCache - factory and cache of PreparedStatments

userId - template parameter

sessionPrefix - template parameter

tempgraph1 - template parameter

tempgraph2 - template parameter

Returns:

org.openanzo.jdbc.utils.ClosableIterator

Throws:

AnzoException

java.sql.SQLException

selectUnreadableGraphsLive

public static ClosableIterator<java.lang.Long> selectUnreadableGraphsLive(PreparedStatementCache sqlCache,
                                                                          long userId,
                                                                          java.lang.String sessionPrefix,
                                                                          java.lang.String tempgraph1,
                                                                          java.lang.String tempgraph2,
                                                                          Transformer<java.lang.Long> transform)
                                                                   throws AnzoException,
                                                                          java.sql.SQLException

Runs the selectUnreadableGraphsLive prepared statement. SELECT TMP1.ID FROM ${a}${b} TMP1 LEFT JOIN (SELECT NG.ID FROM NAMEDGRAPHS NG, ACIS, ${a}${c} TMP2 WHERE NG.HEND IS NULL AND NG.ID = TMP2.ID AND NG.ACLID = ACIS.ACLID AND ACIS.CANREAD = 1 AND ACIS.ROLEID IN (SELECT UR.ROLEID FROM USERSROLES UR WHERE UR.USERID = ? AND UR.HEND IS NULL ) )AS TMP2 ON TMP1.ID=TMP2.ID WHERE TMP2.ID IS NULL

Parameters:

sqlCache - factory and cache of PreparedStatments

userId - template parameter

sessionPrefix - template parameter

tempgraph1 - template parameter

tempgraph2 - template parameter

transform - org.openanzo.jdbc.utils.Transformer used to transform results into java objects

Returns:

org.openanzo.jdbc.utils.ClosableIterator

Throws:

AnzoException

java.sql.SQLException

prepareSelectUnreadableGraphsLive

public static void prepareSelectUnreadableGraphsLive(java.sql.PreparedStatement ps,
                                                     long userId)
                                              throws java.sql.SQLException

Sets the input parameters for the selectUnreadableGraphsLive prepared statement.

Parameters:

ps - PreparedStatement to whose parameters are set

userId - template parameter

Throws:

java.sql.SQLException

selectUnreadableMetadataGraphs

public static ClosableIterator<java.lang.Long> selectUnreadableMetadataGraphs(PreparedStatementCache sqlCache,
                                                                              GlitterRdbWrapper.SelectUnreadableMetadataGraphsParams params,
                                                                              java.lang.String sessionPrefix,
                                                                              java.lang.String tempgraph1,
                                                                              java.lang.String tempgraph2)
                                                                       throws AnzoException,
                                                                              java.sql.SQLException

Runs the selectUnreadableMetadataGraphs prepared statement. SELECT TMP1.ID FROM ${a}${b} TMP1 LEFT JOIN (SELECT NG.METAID FROM NAMEDGRAPHS NG, ACIS, ${a}${c} TMP2 WHERE NG.METAID = TMP2.ID AND NG.ACLID = ACIS.ACLID AND ACIS.CANREAD = 1 AND ACIS.ROLEID IN (SELECT UR.ROLEID FROM USERSROLES UR WHERE UR.USERID = ? AND ? >= UR.HSTART AND (UR.HEND IS NULL OR ? < UR.HEND) ) )AS TMP2 ON TMP1.ID=TMP2.METAID WHERE TMP2.METAID IS NULL

Parameters:

sqlCache - factory and cache of PreparedStatments

params - SelectUnreadableMetadataGraphsParams input Interface

sessionPrefix - template parameter

tempgraph1 - template parameter

tempgraph2 - template parameter

Returns:

org.openanzo.jdbc.utils.ClosableIterator containing the results of the SQL operation

Throws:

AnzoException

java.sql.SQLException

selectUnreadableMetadataGraphs

public static ClosableIterator<java.lang.Long> selectUnreadableMetadataGraphs(PreparedStatementCache sqlCache,
                                                                              long userId,
                                                                              java.lang.Long lastTransactionTime1,
                                                                              java.lang.Long lastTransactionTime2,
                                                                              java.lang.String sessionPrefix,
                                                                              java.lang.String tempgraph1,
                                                                              java.lang.String tempgraph2)
                                                                       throws AnzoException,
                                                                              java.sql.SQLException

Runs the selectUnreadableMetadataGraphs prepared statement with the default transformer. SELECT TMP1.ID FROM ${a}${b} TMP1 LEFT JOIN (SELECT NG.METAID FROM NAMEDGRAPHS NG, ACIS, ${a}${c} TMP2 WHERE NG.METAID = TMP2.ID AND NG.ACLID = ACIS.ACLID AND ACIS.CANREAD = 1 AND ACIS.ROLEID IN (SELECT UR.ROLEID FROM USERSROLES UR WHERE UR.USERID = ? AND ? >= UR.HSTART AND (UR.HEND IS NULL OR ? < UR.HEND) ) )AS TMP2 ON TMP1.ID=TMP2.METAID WHERE TMP2.METAID IS NULL

Parameters:

sqlCache - factory and cache of PreparedStatments

userId - template parameter

lastTransactionTime1 - template parameter

lastTransactionTime2 - template parameter

sessionPrefix - template parameter

tempgraph1 - template parameter

tempgraph2 - template parameter

Returns:

org.openanzo.jdbc.utils.ClosableIterator

Throws:

AnzoException

java.sql.SQLException

selectUnreadableMetadataGraphs

public static ClosableIterator<java.lang.Long> selectUnreadableMetadataGraphs(PreparedStatementCache sqlCache,
                                                                              long userId,
                                                                              java.lang.Long lastTransactionTime1,
                                                                              java.lang.Long lastTransactionTime2,
                                                                              java.lang.String sessionPrefix,
                                                                              java.lang.String tempgraph1,
                                                                              java.lang.String tempgraph2,
                                                                              Transformer<java.lang.Long> transform)
                                                                       throws AnzoException,
                                                                              java.sql.SQLException

Runs the selectUnreadableMetadataGraphs prepared statement. SELECT TMP1.ID FROM ${a}${b} TMP1 LEFT JOIN (SELECT NG.METAID FROM NAMEDGRAPHS NG, ACIS, ${a}${c} TMP2 WHERE NG.METAID = TMP2.ID AND NG.ACLID = ACIS.ACLID AND ACIS.CANREAD = 1 AND ACIS.ROLEID IN (SELECT UR.ROLEID FROM USERSROLES UR WHERE UR.USERID = ? AND ? >= UR.HSTART AND (UR.HEND IS NULL OR ? < UR.HEND) ) )AS TMP2 ON TMP1.ID=TMP2.METAID WHERE TMP2.METAID IS NULL

Parameters:

sqlCache - factory and cache of PreparedStatments

userId - template parameter

lastTransactionTime1 - template parameter

lastTransactionTime2 - template parameter

sessionPrefix - template parameter

tempgraph1 - template parameter

tempgraph2 - template parameter

transform - org.openanzo.jdbc.utils.Transformer used to transform results into java objects

Returns:

org.openanzo.jdbc.utils.ClosableIterator

Throws:

AnzoException

java.sql.SQLException

prepareSelectUnreadableMetadataGraphs

public static void prepareSelectUnreadableMetadataGraphs(java.sql.PreparedStatement ps,
                                                         long userId,
                                                         java.lang.Long lastTransactionTime1,
                                                         java.lang.Long lastTransactionTime2)
                                                  throws java.sql.SQLException

Sets the input parameters for the selectUnreadableMetadataGraphs prepared statement.

Parameters:

ps - PreparedStatement to whose parameters are set

userId - template parameter

lastTransactionTime1 - template parameter

lastTransactionTime2 - template parameter

Throws:

java.sql.SQLException

selectUnreadableMetadataGraphsLive

public static ClosableIterator<java.lang.Long> selectUnreadableMetadataGraphsLive(PreparedStatementCache sqlCache,
                                                                                  long userId,
                                                                                  java.lang.String sessionPrefix,
                                                                                  java.lang.String tempgraph1,
                                                                                  java.lang.String tempgraph2)
                                                                           throws AnzoException,
                                                                                  java.sql.SQLException

Runs the selectUnreadableMetadataGraphsLive prepared statement with the default transformer. SELECT TMP1.ID FROM ${a}${b} TMP1 LEFT JOIN (SELECT NG.METAID FROM NAMEDGRAPHS NG, ACIS, ${a}${c} TMP2 WHERE NG.HEND IS NULL AND NG.METAID = TMP2.ID AND NG.ACLID = ACIS.ACLID AND ACIS.CANREAD = 1 AND ACIS.ROLEID IN (SELECT UR.ROLEID FROM USERSROLES UR WHERE UR.USERID = ? AND UR.HEND IS NULL ) )AS TMP2 ON TMP1.ID=TMP2.METAID WHERE TMP2.METAID IS NULL

Parameters:

sqlCache - factory and cache of PreparedStatments

userId - template parameter

sessionPrefix - template parameter

tempgraph1 - template parameter

tempgraph2 - template parameter

Returns:

org.openanzo.jdbc.utils.ClosableIterator

Throws:

AnzoException

java.sql.SQLException

selectUnreadableMetadataGraphsLive

public static ClosableIterator<java.lang.Long> selectUnreadableMetadataGraphsLive(PreparedStatementCache sqlCache,
                                                                                  long userId,
                                                                                  java.lang.String sessionPrefix,
                                                                                  java.lang.String tempgraph1,
                                                                                  java.lang.String tempgraph2,
                                                                                  Transformer<java.lang.Long> transform)
                                                                           throws AnzoException,
                                                                                  java.sql.SQLException

Runs the selectUnreadableMetadataGraphsLive prepared statement. SELECT TMP1.ID FROM ${a}${b} TMP1 LEFT JOIN (SELECT NG.METAID FROM NAMEDGRAPHS NG, ACIS, ${a}${c} TMP2 WHERE NG.HEND IS NULL AND NG.METAID = TMP2.ID AND NG.ACLID = ACIS.ACLID AND ACIS.CANREAD = 1 AND ACIS.ROLEID IN (SELECT UR.ROLEID FROM USERSROLES UR WHERE UR.USERID = ? AND UR.HEND IS NULL ) )AS TMP2 ON TMP1.ID=TMP2.METAID WHERE TMP2.METAID IS NULL

Parameters:

sqlCache - factory and cache of PreparedStatments

userId - template parameter

sessionPrefix - template parameter

tempgraph1 - template parameter

tempgraph2 - template parameter

transform - org.openanzo.jdbc.utils.Transformer used to transform results into java objects

Returns:

org.openanzo.jdbc.utils.ClosableIterator

Throws:

AnzoException

java.sql.SQLException

prepareSelectUnreadableMetadataGraphsLive

public static void prepareSelectUnreadableMetadataGraphsLive(java.sql.PreparedStatement ps,
                                                             long userId)
                                                      throws java.sql.SQLException

Sets the input parameters for the selectUnreadableMetadataGraphsLive prepared statement.

Parameters:

ps - PreparedStatement to whose parameters are set

userId - template parameter

Throws:

java.sql.SQLException

selectUntimelyGraphs

public static ClosableIterator<java.lang.Long> selectUntimelyGraphs(PreparedStatementCache sqlCache,
                                                                    GlitterRdbWrapper.SelectUntimelyGraphsParams params,
                                                                    java.lang.String sessionPrefix,
                                                                    java.lang.String tempgraph1,
                                                                    java.lang.String tempgraph2)
                                                             throws AnzoException,
                                                                    java.sql.SQLException

Runs the selectUntimelyGraphs prepared statement. SELECT TMP1.ID FROM ${a}${b} TMP1 LEFT JOIN (SELECT NG.ID FROM NAMEDGRAPHS NG, ${a}${c} TMP2 WHERE NG.ID = TMP2.ID AND ? >= NG.HSTART AND (NG.HEND IS NULL OR ? < NG.HEND) )AS TMP2 ON TMP1.ID=TMP2.ID WHERE TMP2.ID IS NULL

Parameters:

sqlCache - factory and cache of PreparedStatments

params - SelectUntimelyGraphsParams input Interface

sessionPrefix - template parameter

tempgraph1 - template parameter

tempgraph2 - template parameter

Returns:

org.openanzo.jdbc.utils.ClosableIterator containing the results of the SQL operation

Throws:

AnzoException

java.sql.SQLException

selectUntimelyGraphs

public static ClosableIterator<java.lang.Long> selectUntimelyGraphs(PreparedStatementCache sqlCache,
                                                                    java.lang.Long lastTransactionTime1,
                                                                    java.lang.Long lastTransactionTime2,
                                                                    java.lang.String sessionPrefix,
                                                                    java.lang.String tempgraph1,
                                                                    java.lang.String tempgraph2)
                                                             throws AnzoException,
                                                                    java.sql.SQLException

Runs the selectUntimelyGraphs prepared statement with the default transformer. SELECT TMP1.ID FROM ${a}${b} TMP1 LEFT JOIN (SELECT NG.ID FROM NAMEDGRAPHS NG, ${a}${c} TMP2 WHERE NG.ID = TMP2.ID AND ? >= NG.HSTART AND (NG.HEND IS NULL OR ? < NG.HEND) )AS TMP2 ON TMP1.ID=TMP2.ID WHERE TMP2.ID IS NULL

Parameters:

sqlCache - factory and cache of PreparedStatments

lastTransactionTime1 - template parameter

lastTransactionTime2 - template parameter

sessionPrefix - template parameter

tempgraph1 - template parameter

tempgraph2 - template parameter

Returns:

org.openanzo.jdbc.utils.ClosableIterator

Throws:

AnzoException

java.sql.SQLException

selectUntimelyGraphs

public static ClosableIterator<java.lang.Long> selectUntimelyGraphs(PreparedStatementCache sqlCache,
                                                                    java.lang.Long lastTransactionTime1,
                                                                    java.lang.Long lastTransactionTime2,
                                                                    java.lang.String sessionPrefix,
                                                                    java.lang.String tempgraph1,
                                                                    java.lang.String tempgraph2,
                                                                    Transformer<java.lang.Long> transform)
                                                             throws AnzoException,
                                                                    java.sql.SQLException

Runs the selectUntimelyGraphs prepared statement. SELECT TMP1.ID FROM ${a}${b} TMP1 LEFT JOIN (SELECT NG.ID FROM NAMEDGRAPHS NG, ${a}${c} TMP2 WHERE NG.ID = TMP2.ID AND ? >= NG.HSTART AND (NG.HEND IS NULL OR ? < NG.HEND) )AS TMP2 ON TMP1.ID=TMP2.ID WHERE TMP2.ID IS NULL

Parameters:

sqlCache - factory and cache of PreparedStatments

lastTransactionTime1 - template parameter

lastTransactionTime2 - template parameter

sessionPrefix - template parameter

tempgraph1 - template parameter

tempgraph2 - template parameter

transform - org.openanzo.jdbc.utils.Transformer used to transform results into java objects

Returns:

org.openanzo.jdbc.utils.ClosableIterator

Throws:

AnzoException

java.sql.SQLException

prepareSelectUntimelyGraphs

public static void prepareSelectUntimelyGraphs(java.sql.PreparedStatement ps,
                                               java.lang.Long lastTransactionTime1,
                                               java.lang.Long lastTransactionTime2)
                                        throws java.sql.SQLException

Sets the input parameters for the selectUntimelyGraphs prepared statement.

Parameters:

ps - PreparedStatement to whose parameters are set

lastTransactionTime1 - template parameter

lastTransactionTime2 - template parameter

Throws:

java.sql.SQLException

selectUntimelyMetadataGraphs

public static ClosableIterator<java.lang.Long> selectUntimelyMetadataGraphs(PreparedStatementCache sqlCache,
                                                                            GlitterRdbWrapper.SelectUntimelyMetadataGraphsParams params,
                                                                            java.lang.String sessionPrefix,
                                                                            java.lang.String tempgraph1,
                                                                            java.lang.String tempgraph2)
                                                                     throws AnzoException,
                                                                            java.sql.SQLException

Runs the selectUntimelyMetadataGraphs prepared statement. SELECT TMP1.ID FROM ${a}${b} TMP1 LEFT JOIN (SELECT DISTINCT NG.METAID FROM NAMEDGRAPHS NG, ${a}${c} TMP2 WHERE NG.METAID = TMP2.ID AND ? >= NG.HSTART AND (NG.HEND IS NULL OR ? < NG.HEND) )AS TMP2 ON TMP1.ID=TMP2.METAID WHERE TMP2.METAID IS NULL

Parameters:

sqlCache - factory and cache of PreparedStatments

params - SelectUntimelyMetadataGraphsParams input Interface

sessionPrefix - template parameter

tempgraph1 - template parameter

tempgraph2 - template parameter

Returns:

org.openanzo.jdbc.utils.ClosableIterator containing the results of the SQL operation

Throws:

AnzoException

java.sql.SQLException

selectUntimelyMetadataGraphs

public static ClosableIterator<java.lang.Long> selectUntimelyMetadataGraphs(PreparedStatementCache sqlCache,
                                                                            java.lang.Long lastTransactionTime1,
                                                                            java.lang.Long lastTransactionTime2,
                                                                            java.lang.String sessionPrefix,
                                                                            java.lang.String tempgraph1,
                                                                            java.lang.String tempgraph2)
                                                                     throws AnzoException,
                                                                            java.sql.SQLException

Runs the selectUntimelyMetadataGraphs prepared statement with the default transformer. SELECT TMP1.ID FROM ${a}${b} TMP1 LEFT JOIN (SELECT DISTINCT NG.METAID FROM NAMEDGRAPHS NG, ${a}${c} TMP2 WHERE NG.METAID = TMP2.ID AND ? >= NG.HSTART AND (NG.HEND IS NULL OR ? < NG.HEND) )AS TMP2 ON TMP1.ID=TMP2.METAID WHERE TMP2.METAID IS NULL

Parameters:

sqlCache - factory and cache of PreparedStatments

lastTransactionTime1 - template parameter

lastTransactionTime2 - template parameter

sessionPrefix - template parameter

tempgraph1 - template parameter

tempgraph2 - template parameter

Returns:

org.openanzo.jdbc.utils.ClosableIterator

Throws:

AnzoException

java.sql.SQLException

selectUntimelyMetadataGraphs

public static ClosableIterator<java.lang.Long> selectUntimelyMetadataGraphs(PreparedStatementCache sqlCache,
                                                                            java.lang.Long lastTransactionTime1,
                                                                            java.lang.Long lastTransactionTime2,
                                                                            java.lang.String sessionPrefix,
                                                                            java.lang.String tempgraph1,
                                                                            java.lang.String tempgraph2,
                                                                            Transformer<java.lang.Long> transform)
                                                                     throws AnzoException,
                                                                            java.sql.SQLException

Runs the selectUntimelyMetadataGraphs prepared statement. SELECT TMP1.ID FROM ${a}${b} TMP1 LEFT JOIN (SELECT DISTINCT NG.METAID FROM NAMEDGRAPHS NG, ${a}${c} TMP2 WHERE NG.METAID = TMP2.ID AND ? >= NG.HSTART AND (NG.HEND IS NULL OR ? < NG.HEND) )AS TMP2 ON TMP1.ID=TMP2.METAID WHERE TMP2.METAID IS NULL

Parameters:

sqlCache - factory and cache of PreparedStatments

lastTransactionTime1 - template parameter

lastTransactionTime2 - template parameter

sessionPrefix - template parameter

tempgraph1 - template parameter

tempgraph2 - template parameter

transform - org.openanzo.jdbc.utils.Transformer used to transform results into java objects

Returns:

org.openanzo.jdbc.utils.ClosableIterator

Throws:

AnzoException

java.sql.SQLException

prepareSelectUntimelyMetadataGraphs

public static void prepareSelectUntimelyMetadataGraphs(java.sql.PreparedStatement ps,
                                                       java.lang.Long lastTransactionTime1,
                                                       java.lang.Long lastTransactionTime2)
                                                throws java.sql.SQLException

Sets the input parameters for the selectUntimelyMetadataGraphs prepared statement.

Parameters:

ps - PreparedStatement to whose parameters are set

lastTransactionTime1 - template parameter

lastTransactionTime2 - template parameter

Throws:

java.sql.SQLException

clearTempDatasetTable

public static int clearTempDatasetTable(PreparedStatementCache sqlCache,
                                        java.lang.String table)
                                 throws AnzoException,
                                        java.sql.SQLException

Runs the clearTempDatasetTable prepared statement. DELETE FROM ${a} WHERE ID IS NOT NULL

Parameters:

sqlCache - factory and cache of PreparedStatments

table - template parameter

Returns:

int

Throws:

AnzoException

java.sql.SQLException

prepareClearTempDatasetTable

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

Sets the input parameters for the clearTempDatasetTable prepared statement.

Parameters:

ps - PreparedStatement to whose parameters are set

Throws:

java.sql.SQLException

truncateTable

public static int truncateTable(PreparedStatementCache sqlCache,
                                java.lang.String table)
                         throws AnzoException,
                                java.sql.SQLException

Runs the truncateTable prepared statement. DELETE FROM ${a}

Parameters:

sqlCache - factory and cache of PreparedStatments

table - template parameter

Returns:

int

Throws:

AnzoException

java.sql.SQLException

prepareTruncateTable

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

Sets the input parameters for the truncateTable prepared statement.

Parameters:

ps - PreparedStatement to whose parameters are set

Throws:

java.sql.SQLException