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

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

public class NamedGraphRdbWrapper
extends java.lang.Object

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

Author:

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

Nested Class Summary

static class	NamedGraphRdbWrapper.BatchDeleteNamedGraph Batch operation for adding parameters to the DeleteNamedGraph prepared statement
static class	NamedGraphRdbWrapper.BatchDeleteStatementsForNamedGraph Batch operation for adding parameters to the DeleteStatementsForNamedGraph prepared statement
static class	NamedGraphRdbWrapper.BatchInsertNamedGraph Batch operation for adding parameters to the InsertNamedGraph prepared statement
static class	NamedGraphRdbWrapper.BatchLookupNamedGraphRevision Batch operation for adding parameters to the LookupNamedGraphRevision prepared statement
static interface	NamedGraphRdbWrapper.DeleteNamedGraphParams Interface for managing the parameters to the deleteNamedGraph prepared statement.
static class	NamedGraphRdbWrapper.DeleteNamedGraphParamsImpl Default implementation of DeleteNamedGraphParams
static interface	NamedGraphRdbWrapper.DeleteStatementsForNamedGraphParams Interface for managing the parameters to the deleteStatementsForNamedGraph prepared statement.
static class	NamedGraphRdbWrapper.DeleteStatementsForNamedGraphParamsImpl Default implementation of DeleteStatementsForNamedGraphParams
static interface	NamedGraphRdbWrapper.GetAllStoredNamedGraphsNoWithParams Interface for managing the parameters to the getAllStoredNamedGraphsNoWith prepared statement.
static class	NamedGraphRdbWrapper.GetAllStoredNamedGraphsNoWithParamsImpl Default implementation of GetAllStoredNamedGraphsNoWithParams
static interface	NamedGraphRdbWrapper.GetMetadatasGraphIdHistoryParams Interface for managing the parameters to the getMetadatasGraphIdHistory prepared statement.
static class	NamedGraphRdbWrapper.GetMetadatasGraphIdHistoryParamsImpl Default implementation of GetMetadatasGraphIdHistoryParams
static interface	NamedGraphRdbWrapper.GetNamedGraphAtRevisionParams Interface for managing the parameters to the getNamedGraphAtRevision prepared statement.
static class	NamedGraphRdbWrapper.GetNamedGraphAtRevisionParamsImpl Default implementation of GetNamedGraphAtRevisionParams
static interface	NamedGraphRdbWrapper.GetNamedGraphAtRevisionResult Interface for holding the results of the getNamedGraphAtRevision prepared statement.
static class	NamedGraphRdbWrapper.GetNamedGraphAtRevisionResultImpl Default implementation of GetNamedGraphAtRevisionResult
static interface	NamedGraphRdbWrapper.GetNamedGraphsMetaIdAndAciHistoryNewParams Interface for managing the parameters to the getNamedGraphsMetaIdAndAciHistoryNew prepared statement.
static class	NamedGraphRdbWrapper.GetNamedGraphsMetaIdAndAciHistoryNewParamsImpl Default implementation of GetNamedGraphsMetaIdAndAciHistoryNewParams
static interface	NamedGraphRdbWrapper.GetNamedGraphsMetaIdAndAciHistoryNewResult Interface for holding the results of the getNamedGraphsMetaIdAndAciHistoryNew prepared statement.
static class	NamedGraphRdbWrapper.GetNamedGraphsMetaIdAndAciHistoryNewResultImpl Default implementation of GetNamedGraphsMetaIdAndAciHistoryNewResult
static interface	NamedGraphRdbWrapper.GetNamedGraphsMetaIdAndAciHistoryParams Interface for managing the parameters to the getNamedGraphsMetaIdAndAciHistory prepared statement.
static class	NamedGraphRdbWrapper.GetNamedGraphsMetaIdAndAciHistoryParamsImpl Default implementation of GetNamedGraphsMetaIdAndAciHistoryParams
static interface	NamedGraphRdbWrapper.GetNamedGraphsMetaIdAndAciHistoryResult Interface for holding the results of the getNamedGraphsMetaIdAndAciHistory prepared statement.
static class	NamedGraphRdbWrapper.GetNamedGraphsMetaIdAndAciHistoryResultImpl Default implementation of GetNamedGraphsMetaIdAndAciHistoryResult
static interface	NamedGraphRdbWrapper.GetNamedGraphsMetaIdHistoryNewParams Interface for managing the parameters to the getNamedGraphsMetaIdHistoryNew prepared statement.
static class	NamedGraphRdbWrapper.GetNamedGraphsMetaIdHistoryNewParamsImpl Default implementation of GetNamedGraphsMetaIdHistoryNewParams
static interface	NamedGraphRdbWrapper.GetNamedGraphsMetaIdHistoryParams Interface for managing the parameters to the getNamedGraphsMetaIdHistory prepared statement.
static class	NamedGraphRdbWrapper.GetNamedGraphsMetaIdHistoryParamsImpl Default implementation of GetNamedGraphsMetaIdHistoryParams
static interface	NamedGraphRdbWrapper.GetStoredNamedGraphsNoWithParams Interface for managing the parameters to the getStoredNamedGraphsNoWith prepared statement.
static class	NamedGraphRdbWrapper.GetStoredNamedGraphsNoWithParamsImpl Default implementation of GetStoredNamedGraphsNoWithParams
static interface	NamedGraphRdbWrapper.GetTotalNumberOfStoredNamedGraphsNoWithParams Interface for managing the parameters to the getTotalNumberOfStoredNamedGraphsNoWith prepared statement.
static class	NamedGraphRdbWrapper.GetTotalNumberOfStoredNamedGraphsNoWithParamsImpl Default implementation of GetTotalNumberOfStoredNamedGraphsNoWithParams
static interface	NamedGraphRdbWrapper.InsertNamedGraphParams Interface for managing the parameters to the insertNamedGraph prepared statement.
static class	NamedGraphRdbWrapper.InsertNamedGraphParamsImpl Default implementation of InsertNamedGraphParams
static interface	NamedGraphRdbWrapper.LookupNamedGraphRevisionParams Interface for managing the parameters to the lookupNamedGraphRevision prepared statement.
static class	NamedGraphRdbWrapper.LookupNamedGraphRevisionParamsImpl Default implementation of LookupNamedGraphRevisionParams
static interface	NamedGraphRdbWrapper.SelectMetaGraphUrisResult Interface for holding the results of the selectMetaGraphUris prepared statement.
static class	NamedGraphRdbWrapper.SelectMetaGraphUrisResultImpl Default implementation of SelectMetaGraphUrisResult
static interface	NamedGraphRdbWrapper.SelectNamedGraphResult Interface for holding the results of the selectNamedGraph prepared statement.
static class	NamedGraphRdbWrapper.SelectNamedGraphResultImpl Default implementation of SelectNamedGraphResult
static interface	NamedGraphRdbWrapper.SelectNamedGraphRevisionResult Interface for holding the results of the selectNamedGraphRevision prepared statement.
static class	NamedGraphRdbWrapper.SelectNamedGraphRevisionResultImpl Default implementation of SelectNamedGraphRevisionResult
static interface	NamedGraphRdbWrapper.SelectNamedGraphSizeHistoryNoWithParams Interface for managing the parameters to the selectNamedGraphSizeHistoryNoWith prepared statement.
static class	NamedGraphRdbWrapper.SelectNamedGraphSizeHistoryNoWithParamsImpl Default implementation of SelectNamedGraphSizeHistoryNoWithParams
static interface	NamedGraphRdbWrapper.SelectNamedGraphUrisResult Interface for holding the results of the selectNamedGraphUris prepared statement.
static class	NamedGraphRdbWrapper.SelectNamedGraphUrisResultImpl Default implementation of SelectNamedGraphUrisResult

Field Summary

static java.lang.String	deleteNamedGraph Constant "deleteNamedGraph" used to reference prepared statement NamedGraph.deleteNamedGraph UPDATE NAMEDGRAPHS SET HEND=? WHERE ID = ?;
static java.lang.String	deleteStatementsForNamedGraph Constant "deleteStatementsForNamedGraph" used to reference prepared statement NamedGraph.deleteStatementsForNamedGraph UPDATE STATEMENTS SET HEND=? WHERE NAMEDGRAPHID = ?;
static java.lang.String	getAllStoredNamedGraphs Constant "getAllStoredNamedGraphs" used to reference prepared statement NamedGraph.getAllStoredNamedGraphs WITH LT (COMMITED) AS ( SELECT MAX(COMMITED) FROM TRANSACTIONTIMES ) SELECT DISTINCT ${a}_U.VALUE FROM ${a}_U WHERE ${a}_U.ID IN( SELECT NG.ID FROM NAMEDGRAPHS NG,LT WHERE NG.HSTART <= LT.COMMITED AND (NG.HEND IS NULL OR NG.HEND > LT.COMMITED) )
static java.lang.String	getAllStoredNamedGraphsNoWith Constant "getAllStoredNamedGraphsNoWith" used to reference prepared statement NamedGraph.getAllStoredNamedGraphsNoWith SELECT DISTINCT ${a}_U.VALUE FROM ${a}_U WHERE ${a}_U.ID IN( SELECT NG.ID FROM NAMEDGRAPHS NG WHERE NG.HSTART <= ? AND (NG.HEND IS NULL OR NG.HEND > ?)) ;
static java.lang.String	getMetadatasGraphId Constant "getMetadatasGraphId" used to reference prepared statement NamedGraph.getMetadatasGraphId SELECT ID FROM NAMEDGRAPHS WHERE METAID = ? AND HEND IS NULL;
static java.lang.String	getMetadatasGraphIdHistory Constant "getMetadatasGraphIdHistory" used to reference prepared statement NamedGraph.getMetadatasGraphIdHistory SELECT DISTINCT NG.ID FROM NAMEDGRAPHS NG,ACIS ACIS WHERE NG.METAID = ? AND NG.HSTART <= ? AND (NG.HEND IS NULL OR NG.HEND > ?) AND NG.ACLID=ACIS.ACLID AND ACIS.HSTART <= ? AND (ACIS.HEND IS NULL OR ACIS.HEND > ?) AND ACIS.ROLEID IN( SELECT UR.ROLEID FROM USERSROLES UR WHERE UR.HSTART <= ? AND (UR.HEND IS NULL OR UR.HEND > ?) AND UR.USERID = ? ) AND ACIS.CANREAD=1;
static java.lang.String	getNamedGraphAtRevision Constant "getNamedGraphAtRevision" used to reference prepared statement NamedGraph.getNamedGraphAtRevision SELECT METAID,HSTART,ACLID,CREATEDBY,LASTMODIFIEDBY FROM NAMEDGRAPHS WHERE ID=? AND REVISION=?
static java.lang.String	getNamedGraphCurrentRevision Constant "getNamedGraphCurrentRevision" used to reference prepared statement NamedGraph.getNamedGraphCurrentRevision SELECT REVISION FROM NAMEDGRAPHS WHERE ID=? AND HEND IS NULL;
static java.lang.String	getNamedGraphsMetaId Constant "getNamedGraphsMetaId" used to reference prepared statement NamedGraph.getNamedGraphsMetaId SELECT NG.METAID FROM NAMEDGRAPHS NG WHERE NG.ID = ? AND NG.HEND IS NULL;
static java.lang.String	getNamedGraphsMetaIdAndAciHistory Constant "getNamedGraphsMetaIdAndAciHistory" used to reference prepared statement NamedGraph.getNamedGraphsMetaIdAndAciHistory SELECT DISTINCT NG.METAID,ACIS.CANREAD FROM NAMEDGRAPHS NG,ACIS ACIS WHERE NG.ID = ? AND NG.HSTART <= ? AND (NG.HEND IS NULL OR NG.HEND > ?) AND NG.ACLID=ACIS.ACLID AND ACIS.HSTART <= ? AND (ACIS.HEND IS NULL OR ACIS.HEND > ?) AND ACIS.ROLEID IN( SELECT UR.ROLEID FROM USERSROLES UR WHERE UR.HSTART <= ? AND (UR.HEND IS NULL OR UR.HEND > ?) AND UR.USERID = ? );
static java.lang.String	getNamedGraphsMetaIdAndAciHistoryNew Constant "getNamedGraphsMetaIdAndAciHistoryNew" used to reference prepared statement NamedGraph.getNamedGraphsMetaIdAndAciHistoryNew WITH LT (COMMITED) AS ( SELECT MAX(COMMITED) FROM TRANSACTIONTIMES ) SELECT NG.METAID,ACIS.CANREAD FROM NAMEDGRAPHS NG,ACIS ACIS,LT WHERE NG.ID = ? AND NG.HSTART <= LT.COMMITED AND (NG.HEND IS NULL OR NG.HEND > LT.COMMITED) AND NG.ACLID=ACIS.ACLID AND ACIS.HSTART <= LT.COMMITED AND (ACIS.HEND IS NULL OR ACIS.HEND > LT.COMMITED) AND ACIS.ROLEID IN( SELECT UR.ROLEID FROM USERSROLES UR WHERE UR.HSTART <= LT.COMMITED AND (UR.HEND IS NULL OR UR.HEND > LT.COMMITED) AND UR.USERID = ? );
static java.lang.String	getNamedGraphsMetaIdHistory Constant "getNamedGraphsMetaIdHistory" used to reference prepared statement NamedGraph.getNamedGraphsMetaIdHistory SELECT DISTINCT NG.METAID FROM NAMEDGRAPHS NG,ACIS ACIS WHERE NG.ID = ? AND NG.HSTART <= ? AND (NG.HEND IS NULL OR NG.HEND > ?) AND NG.ACLID=ACIS.ACLID AND ACIS.HSTART <= ? AND (ACIS.HEND IS NULL OR ACIS.HEND > ?) AND ACIS.ROLEID IN( SELECT UR.ROLEID FROM USERSROLES UR WHERE UR.HSTART <= ? AND (UR.HEND IS NULL OR UR.HEND > ?) AND UR.USERID = ? ) AND ACIS.CANREAD=1;
static java.lang.String	getNamedGraphsMetaIdHistoryNew Constant "getNamedGraphsMetaIdHistoryNew" used to reference prepared statement NamedGraph.getNamedGraphsMetaIdHistoryNew WITH LT (COMMITED) AS ( SELECT MAX(COMMITED) FROM TRANSACTIONTIMES ) SELECT NG.METAID FROM NAMEDGRAPHS NG,ACIS ACIS,LT WHERE NG.ID = ? AND NG.HSTART <= LT.COMMITED AND (NG.HEND IS NULL OR NG.HEND > LT.COMMITED) AND NG.ACLID=ACIS.ACLID AND ACIS.HSTART <= LT.COMMITED AND (ACIS.HEND IS NULL OR ACIS.HEND > LT.COMMITED) AND ACIS.ROLEID IN( SELECT UR.ROLEID FROM USERSROLES UR WHERE UR.HSTART <= LT.COMMITED AND (UR.HEND IS NULL OR UR.HEND > LT.COMMITED) AND UR.USERID = ? ) AND ACIS.CANREAD=1;
static java.lang.String	getStoredNamedGraphs Constant "getStoredNamedGraphs" used to reference prepared statement NamedGraph.getStoredNamedGraphs WITH LT (COMMITED) AS ( SELECT MAX(COMMITED) FROM TRANSACTIONTIMES ) SELECT ${a}_U.VALUE FROM ${a}_U WHERE ${a}_U.ID IN ( SELECT NG.ID FROM NAMEDGRAPHS NG,ACIS ACIS,LT WHERE NG.HSTART <= LT.COMMITED AND (NG.HEND IS NULL OR NG.HEND > LT.COMMITED) AND NG.ACLID=ACIS.ACLID AND ACIS.HSTART <= LT.COMMITED AND (ACIS.HEND IS NULL OR ACIS.HEND > LT.COMMITED) AND ACIS.ROLEID IN( SELECT UR.ROLEID FROM USERSROLES UR WHERE UR.HSTART <= LT.COMMITED AND (UR.HEND IS NULL OR UR.HEND > LT.COMMITED) AND UR.USERID = ? ) AND ACIS.CANREAD=1);
static java.lang.String	getStoredNamedGraphsNoWith Constant "getStoredNamedGraphsNoWith" used to reference prepared statement NamedGraph.getStoredNamedGraphsNoWith SELECT ${a}_U.VALUE FROM ${a}_U WHERE ${a}_U.ID IN ( SELECT DISTINCT NAMEDGRAPHS.ID FROM NAMEDGRAPHS,ACIS WHERE NAMEDGRAPHS.HSTART <= ? AND (NAMEDGRAPHS.HEND IS NULL OR NAMEDGRAPHS.HEND > ?) AND NAMEDGRAPHS.ACLID=ACIS.ACLID AND ACIS.HSTART <= ? AND (ACIS.HEND IS NULL OR ACIS.HEND > ?) AND ACIS.ROLEID IN( SELECT USERSROLES.ROLEID FROM USERSROLES WHERE USERSROLES.HSTART <= ? AND (USERSROLES.HEND IS NULL OR USERSROLES.HEND > ?) AND USERSROLES.USERID = ? ) AND ACIS.CANREAD=1 );
static java.lang.String	getTotalNumberOfStoredNamedGraphs Constant "getTotalNumberOfStoredNamedGraphs" used to reference prepared statement NamedGraph.getTotalNumberOfStoredNamedGraphs WITH LT (COMMITED) AS ( SELECT MAX(COMMITED) FROM TRANSACTIONTIMES ) SELECT COUNT(*) FROM NAMEDGRAPHS NG,LT WHERE NG.HSTART <= LT.COMMITED AND (NG.HEND IS NULL OR NG.HEND > LT.COMMITED)
static java.lang.String	getTotalNumberOfStoredNamedGraphsNoWith Constant "getTotalNumberOfStoredNamedGraphsNoWith" used to reference prepared statement NamedGraph.getTotalNumberOfStoredNamedGraphsNoWith SELECT COUNT(*) FROM NAMEDGRAPHS NG WHERE NG.HSTART <= ? AND (NG.HEND IS NULL OR NG.HEND > ?) ;
static java.lang.String	insertNamedGraph Constant "insertNamedGraph" used to reference prepared statement NamedGraph.insertNamedGraph INSERT INTO NAMEDGRAPHS (HSTART, ID, METAID,ACLID, CREATEDBY, REVISION,LASTMODIFIEDBY) VALUES (?, ?,?, ?, ?, ?,?);
static java.lang.String	lookupNamedGraphRevision Constant "lookupNamedGraphRevision" used to reference prepared statement NamedGraph.lookupNamedGraphRevision INSERT INTO ${a}RESULTS_TMP (ID, NAMEDGRAPHID, SUBJ, PROP, OBJ) SELECT SH.ID,SH.NAMEDGRAPHID,SH.SUBJ, SH.PROP, SH.OBJ FROM STATEMENTS SH,NAMEDGRAPHS NG,ACIS WHERE NG.ID=? AND SH.NAMEDGRAPHID = ? AND SH.HSTART <= ? AND (SH.HEND IS NULL OR SH.HEND > ?) AND SH.NAMEDGRAPHID = NG.ID AND NG.HSTART <= ? AND (NG.HEND IS NULL OR NG.HEND > ?) AND NG.ACLID=ACIS.ACLID AND ACIS.HSTART <= ? AND (ACIS.HEND IS NULL OR ACIS.HEND > ?) AND ACIS.ROLEID IN(SELECT UR.ROLEID FROM USERSROLES UR WHERE UR.HSTART <= ? AND (UR.HEND IS NULL OR UR.HEND > ?) AND UR.USERID = ? ) AND ACIS.CANREAD = 1
static java.lang.String	purgeNamedGraphRevisionTmp Constant "purgeNamedGraphRevisionTmp" used to reference prepared statement NamedGraph.purgeNamedGraphRevisionTmp DELETE FROM ${a}RESULTS_TMP
static java.lang.String	selectMetaGraphUris Constant "selectMetaGraphUris" used to reference prepared statement NamedGraph.selectMetaGraphUris SELECT DISTINCT ${a}_U.ID,${a}_U.VALUE FROM ${a}_U WHERE ${a}_U.ID IN (SELECT METAID FROM NAMEDGRAPHS WHERE HEND IS NULL);
static java.lang.String	selectNamedGraph Constant "selectNamedGraph" used to reference prepared statement NamedGraph.selectNamedGraph SELECT NG.METAID,NG.ACLID, NG.CREATEDBY, NG.REVISION,NG.LASTMODIFIEDBY FROM NAMEDGRAPHS NG WHERE NG.ID = ? AND NG.HEND IS NULL;
static java.lang.String	selectNamedGraphRevision Constant "selectNamedGraphRevision" used to reference prepared statement NamedGraph.selectNamedGraphRevision SELECT ID,SUBJ,PROP,OBJ,NAMEDGRAPHID FROM ${a}RESULTS_TMP WHERE ID IS NOT NULL;
static java.lang.String	selectNamedGraphSizeHistory Constant "selectNamedGraphSizeHistory" used to reference prepared statement NamedGraph.selectNamedGraphSizeHistory WITH LT (COMMITED) AS ( SELECT MAX(COMMITED) FROM TRANSACTIONTIMES ) SELECT DISTINCT COUNT(*) FROM STATEMENTS SH,LT WHERE SH.NAMEDGRAPHID = ? AND SH.HSTART <= LT.COMMITED AND (SH.HEND IS NULL OR SH.HEND > LT.COMMITED)
static java.lang.String	selectNamedGraphSizeHistoryNoWith Constant "selectNamedGraphSizeHistoryNoWith" used to reference prepared statement NamedGraph.selectNamedGraphSizeHistoryNoWith SELECT DISTINCT COUNT(*) FROM STATEMENTS SH WHERE SH.NAMEDGRAPHID = ? AND SH.HSTART <= ? AND (SH.HEND IS NULL OR SH.HEND > ?)
static java.lang.String	selectNamedGraphUriIds Constant "selectNamedGraphUriIds" used to reference prepared statement NamedGraph.selectNamedGraphUriIds SELECT ID FROM NAMEDGRAPHS WHERE HEND IS NULL;
static java.lang.String	selectNamedGraphUris Constant "selectNamedGraphUris" used to reference prepared statement NamedGraph.selectNamedGraphUris SELECT DISTINCT ${a}_U.ID,${a}_U.VALUE FROM ${a}_U WHERE ${a}_U.ID IN (SELECT ID FROM NAMEDGRAPHS WHERE HEND IS NULL);

Constructor Summary

NamedGraphRdbWrapper()

Method Summary

static void	deleteNamedGraph(PreparedStatementCache sqlCache, java.lang.Long hend, long id) Runs the deleteNamedGraph prepared statement.
static void	deleteNamedGraph(PreparedStatementCache sqlCache, NamedGraphRdbWrapper.DeleteNamedGraphParams params) Runs the deleteNamedGraph prepared statement.
static void	deleteStatementsForNamedGraph(PreparedStatementCache sqlCache, java.lang.Long hend, long id) Runs the deleteStatementsForNamedGraph prepared statement.
static void	deleteStatementsForNamedGraph(PreparedStatementCache sqlCache, NamedGraphRdbWrapper.DeleteStatementsForNamedGraphParams params) Runs the deleteStatementsForNamedGraph prepared statement.
static ClosableIterator<java.lang.String>	getAllStoredNamedGraphs(PreparedStatementCache sqlCache, java.lang.String tableNamePrefix) Runs the getAllStoredNamedGraphs prepared statement with the default transformer.
static ClosableIterator<java.lang.String>	getAllStoredNamedGraphs(PreparedStatementCache sqlCache, java.lang.String tableNamePrefix, Transformer<java.lang.String> transform) Runs the getAllStoredNamedGraphs prepared statement.
static ClosableIterator<java.lang.String>	getAllStoredNamedGraphsNoWith(PreparedStatementCache sqlCache, java.lang.Long now, java.lang.Long now2, java.lang.String tableNamePrefix) Runs the getAllStoredNamedGraphsNoWith prepared statement with the default transformer.
static ClosableIterator<java.lang.String>	getAllStoredNamedGraphsNoWith(PreparedStatementCache sqlCache, java.lang.Long now, java.lang.Long now2, java.lang.String tableNamePrefix, Transformer<java.lang.String> transform) Runs the getAllStoredNamedGraphsNoWith prepared statement.
static ClosableIterator<java.lang.String>	getAllStoredNamedGraphsNoWith(PreparedStatementCache sqlCache, NamedGraphRdbWrapper.GetAllStoredNamedGraphsNoWithParams params, java.lang.String tableNamePrefix) Runs the getAllStoredNamedGraphsNoWith prepared statement.
static java.lang.Long	getMetadatasGraphId(PreparedStatementCache sqlCache, long metaid) Runs the getMetadatasGraphId prepared statement.
static java.lang.Long	getMetadatasGraphIdHistory(PreparedStatementCache sqlCache, long metaid, java.lang.Long now, java.lang.Long now2, java.lang.Long now3, java.lang.Long now4, java.lang.Long now5, java.lang.Long now6, long userId) Runs the getMetadatasGraphIdHistory prepared statement.
static java.lang.Long	getMetadatasGraphIdHistory(PreparedStatementCache sqlCache, NamedGraphRdbWrapper.GetMetadatasGraphIdHistoryParams params) Runs the getMetadatasGraphIdHistory prepared statement.
static NamedGraphRdbWrapper.GetNamedGraphAtRevisionResult	getNamedGraphAtRevision(PreparedStatementCache sqlCache, long namedGraphId, long revision) Runs the getNamedGraphAtRevision prepared statement.
static NamedGraphRdbWrapper.GetNamedGraphAtRevisionResult	getNamedGraphAtRevision(PreparedStatementCache sqlCache, long namedGraphId, long revision, NamedGraphRdbWrapper.GetNamedGraphAtRevisionResult result) Runs the getNamedGraphAtRevision prepared statement.
static NamedGraphRdbWrapper.GetNamedGraphAtRevisionResult	getNamedGraphAtRevision(PreparedStatementCache sqlCache, NamedGraphRdbWrapper.GetNamedGraphAtRevisionParams params) Runs the getNamedGraphAtRevision prepared statement.
static java.lang.Long	getNamedGraphCurrentRevision(PreparedStatementCache sqlCache, long namedGraphId) Runs the getNamedGraphCurrentRevision prepared statement.
static java.lang.Long	getNamedGraphsMetaId(PreparedStatementCache sqlCache, long id) Runs the getNamedGraphsMetaId prepared statement.
static ClosableIterator<NamedGraphRdbWrapper.GetNamedGraphsMetaIdAndAciHistoryResult>	getNamedGraphsMetaIdAndAciHistory(PreparedStatementCache sqlCache, long id, java.lang.Long now, java.lang.Long now2, java.lang.Long now3, java.lang.Long now4, java.lang.Long now5, java.lang.Long now6, long userId) Runs the getNamedGraphsMetaIdAndAciHistory prepared statement with the default transformer.
static ClosableIterator<NamedGraphRdbWrapper.GetNamedGraphsMetaIdAndAciHistoryResult>	getNamedGraphsMetaIdAndAciHistory(PreparedStatementCache sqlCache, long id, java.lang.Long now, java.lang.Long now2, java.lang.Long now3, java.lang.Long now4, java.lang.Long now5, java.lang.Long now6, long userId, Transformer<NamedGraphRdbWrapper.GetNamedGraphsMetaIdAndAciHistoryResult> transform) Runs the getNamedGraphsMetaIdAndAciHistory prepared statement.
static ClosableIterator<NamedGraphRdbWrapper.GetNamedGraphsMetaIdAndAciHistoryResult>	getNamedGraphsMetaIdAndAciHistory(PreparedStatementCache sqlCache, NamedGraphRdbWrapper.GetNamedGraphsMetaIdAndAciHistoryParams params) Runs the getNamedGraphsMetaIdAndAciHistory prepared statement.
static ClosableIterator<NamedGraphRdbWrapper.GetNamedGraphsMetaIdAndAciHistoryNewResult>	getNamedGraphsMetaIdAndAciHistoryNew(PreparedStatementCache sqlCache, long id, long userId) Runs the getNamedGraphsMetaIdAndAciHistoryNew prepared statement with the default transformer.
static ClosableIterator<NamedGraphRdbWrapper.GetNamedGraphsMetaIdAndAciHistoryNewResult>	getNamedGraphsMetaIdAndAciHistoryNew(PreparedStatementCache sqlCache, long id, long userId, Transformer<NamedGraphRdbWrapper.GetNamedGraphsMetaIdAndAciHistoryNewResult> transform) Runs the getNamedGraphsMetaIdAndAciHistoryNew prepared statement.
static ClosableIterator<NamedGraphRdbWrapper.GetNamedGraphsMetaIdAndAciHistoryNewResult>	getNamedGraphsMetaIdAndAciHistoryNew(PreparedStatementCache sqlCache, NamedGraphRdbWrapper.GetNamedGraphsMetaIdAndAciHistoryNewParams params) Runs the getNamedGraphsMetaIdAndAciHistoryNew prepared statement.
static java.lang.Long	getNamedGraphsMetaIdHistory(PreparedStatementCache sqlCache, long id, java.lang.Long now, java.lang.Long now2, java.lang.Long now3, java.lang.Long now4, java.lang.Long now5, java.lang.Long now6, long userId) Runs the getNamedGraphsMetaIdHistory prepared statement.
static java.lang.Long	getNamedGraphsMetaIdHistory(PreparedStatementCache sqlCache, NamedGraphRdbWrapper.GetNamedGraphsMetaIdHistoryParams params) Runs the getNamedGraphsMetaIdHistory prepared statement.
static java.lang.Long	getNamedGraphsMetaIdHistoryNew(PreparedStatementCache sqlCache, long id, long userId) Runs the getNamedGraphsMetaIdHistoryNew prepared statement.
static java.lang.Long	getNamedGraphsMetaIdHistoryNew(PreparedStatementCache sqlCache, NamedGraphRdbWrapper.GetNamedGraphsMetaIdHistoryNewParams params) Runs the getNamedGraphsMetaIdHistoryNew prepared statement.
static ClosableIterator<java.lang.String>	getStoredNamedGraphs(PreparedStatementCache sqlCache, long userId, java.lang.String tableNamePrefix) Runs the getStoredNamedGraphs prepared statement with the default transformer.
static ClosableIterator<java.lang.String>	getStoredNamedGraphs(PreparedStatementCache sqlCache, long userId, java.lang.String tableNamePrefix, Transformer<java.lang.String> transform) Runs the getStoredNamedGraphs prepared statement.
static ClosableIterator<java.lang.String>	getStoredNamedGraphsNoWith(PreparedStatementCache sqlCache, java.lang.Long now, java.lang.Long now2, java.lang.Long now3, java.lang.Long now4, java.lang.Long now5, java.lang.Long now6, long userId, java.lang.String tableNamePrefix) Runs the getStoredNamedGraphsNoWith prepared statement with the default transformer.
static ClosableIterator<java.lang.String>	getStoredNamedGraphsNoWith(PreparedStatementCache sqlCache, java.lang.Long now, java.lang.Long now2, java.lang.Long now3, java.lang.Long now4, java.lang.Long now5, java.lang.Long now6, long userId, java.lang.String tableNamePrefix, Transformer<java.lang.String> transform) Runs the getStoredNamedGraphsNoWith prepared statement.
static ClosableIterator<java.lang.String>	getStoredNamedGraphsNoWith(PreparedStatementCache sqlCache, NamedGraphRdbWrapper.GetStoredNamedGraphsNoWithParams params, java.lang.String tableNamePrefix) Runs the getStoredNamedGraphsNoWith prepared statement.
static java.lang.Long	getTotalNumberOfStoredNamedGraphs(PreparedStatementCache sqlCache) Runs the getTotalNumberOfStoredNamedGraphs prepared statement.
static java.lang.Long	getTotalNumberOfStoredNamedGraphsNoWith(PreparedStatementCache sqlCache, java.lang.Long now, java.lang.Long now2) Runs the getTotalNumberOfStoredNamedGraphsNoWith prepared statement.
static java.lang.Long	getTotalNumberOfStoredNamedGraphsNoWith(PreparedStatementCache sqlCache, NamedGraphRdbWrapper.GetTotalNumberOfStoredNamedGraphsNoWithParams params) Runs the getTotalNumberOfStoredNamedGraphsNoWith prepared statement.
static void	insertNamedGraph(PreparedStatementCache sqlCache, java.lang.Long modified, long namedgraphid, long metaId, long aclid, long createdBy, long revision, long lastModifiedBy) Runs the insertNamedGraph prepared statement.
static void	insertNamedGraph(PreparedStatementCache sqlCache, NamedGraphRdbWrapper.InsertNamedGraphParams params) Runs the insertNamedGraph prepared statement.
static void	lookupNamedGraphRevision(PreparedStatementCache sqlCache, long namedGraphId, long namedGraphId2, java.lang.Long start1, java.lang.Long end1, java.lang.Long start2, java.lang.Long end2, java.lang.Long start3, java.lang.Long end3, java.lang.Long start4, java.lang.Long end4, long userId, java.lang.String sessionPrefix) Runs the lookupNamedGraphRevision prepared statement.
static void	lookupNamedGraphRevision(PreparedStatementCache sqlCache, NamedGraphRdbWrapper.LookupNamedGraphRevisionParams params, java.lang.String sessionPrefix) Runs the lookupNamedGraphRevision prepared statement.
static void	prepareDeleteNamedGraph(java.sql.PreparedStatement ps, java.lang.Long hend, long id) Sets the input parameters for the deleteNamedGraph prepared statement.
static void	prepareDeleteStatementsForNamedGraph(java.sql.PreparedStatement ps, java.lang.Long hend, long id) Sets the input parameters for the deleteStatementsForNamedGraph prepared statement.
static void	prepareGetAllStoredNamedGraphs(java.sql.PreparedStatement ps) Sets the input parameters for the getAllStoredNamedGraphs prepared statement.
static void	prepareGetAllStoredNamedGraphsNoWith(java.sql.PreparedStatement ps, java.lang.Long now, java.lang.Long now2) Sets the input parameters for the getAllStoredNamedGraphsNoWith prepared statement.
static void	prepareGetMetadatasGraphId(java.sql.PreparedStatement ps, long metaid) Sets the input parameters for the getMetadatasGraphId prepared statement.
static void	prepareGetMetadatasGraphIdHistory(java.sql.PreparedStatement ps, long metaid, java.lang.Long now, java.lang.Long now2, java.lang.Long now3, java.lang.Long now4, java.lang.Long now5, java.lang.Long now6, long userId) Sets the input parameters for the getMetadatasGraphIdHistory prepared statement.
static void	prepareGetNamedGraphAtRevision(java.sql.PreparedStatement ps, long namedGraphId, long revision) Sets the input parameters for the getNamedGraphAtRevision prepared statement.
static void	prepareGetNamedGraphCurrentRevision(java.sql.PreparedStatement ps, long namedGraphId) Sets the input parameters for the getNamedGraphCurrentRevision prepared statement.
static void	prepareGetNamedGraphsMetaId(java.sql.PreparedStatement ps, long id) Sets the input parameters for the getNamedGraphsMetaId prepared statement.
static void	prepareGetNamedGraphsMetaIdAndAciHistory(java.sql.PreparedStatement ps, long id, java.lang.Long now, java.lang.Long now2, java.lang.Long now3, java.lang.Long now4, java.lang.Long now5, java.lang.Long now6, long userId) Sets the input parameters for the getNamedGraphsMetaIdAndAciHistory prepared statement.
static void	prepareGetNamedGraphsMetaIdAndAciHistoryNew(java.sql.PreparedStatement ps, long id, long userId) Sets the input parameters for the getNamedGraphsMetaIdAndAciHistoryNew prepared statement.
static void	prepareGetNamedGraphsMetaIdHistory(java.sql.PreparedStatement ps, long id, java.lang.Long now, java.lang.Long now2, java.lang.Long now3, java.lang.Long now4, java.lang.Long now5, java.lang.Long now6, long userId) Sets the input parameters for the getNamedGraphsMetaIdHistory prepared statement.
static void	prepareGetNamedGraphsMetaIdHistoryNew(java.sql.PreparedStatement ps, long id, long userId) Sets the input parameters for the getNamedGraphsMetaIdHistoryNew prepared statement.
static void	prepareGetStoredNamedGraphs(java.sql.PreparedStatement ps, long userId) Sets the input parameters for the getStoredNamedGraphs prepared statement.
static void	prepareGetStoredNamedGraphsNoWith(java.sql.PreparedStatement ps, java.lang.Long now, java.lang.Long now2, java.lang.Long now3, java.lang.Long now4, java.lang.Long now5, java.lang.Long now6, long userId) Sets the input parameters for the getStoredNamedGraphsNoWith prepared statement.
static void	prepareGetTotalNumberOfStoredNamedGraphs(java.sql.PreparedStatement ps) Sets the input parameters for the getTotalNumberOfStoredNamedGraphs prepared statement.
static void	prepareGetTotalNumberOfStoredNamedGraphsNoWith(java.sql.PreparedStatement ps, java.lang.Long now, java.lang.Long now2) Sets the input parameters for the getTotalNumberOfStoredNamedGraphsNoWith prepared statement.
static void	prepareInsertNamedGraph(java.sql.PreparedStatement ps, java.lang.Long modified, long namedgraphid, long metaId, long aclid, long createdBy, long revision, long lastModifiedBy) Sets the input parameters for the insertNamedGraph prepared statement.
static void	prepareLookupNamedGraphRevision(java.sql.PreparedStatement ps, long namedGraphId, long namedGraphId2, java.lang.Long start1, java.lang.Long end1, java.lang.Long start2, java.lang.Long end2, java.lang.Long start3, java.lang.Long end3, java.lang.Long start4, java.lang.Long end4, long userId) Sets the input parameters for the lookupNamedGraphRevision prepared statement.
static void	preparePurgeNamedGraphRevisionTmp(java.sql.PreparedStatement ps) Sets the input parameters for the purgeNamedGraphRevisionTmp prepared statement.
static void	prepareSelectMetaGraphUris(java.sql.PreparedStatement ps) Sets the input parameters for the selectMetaGraphUris prepared statement.
static void	prepareSelectNamedGraph(java.sql.PreparedStatement ps, long id) Sets the input parameters for the selectNamedGraph prepared statement.
static void	prepareSelectNamedGraphRevision(java.sql.PreparedStatement ps) Sets the input parameters for the selectNamedGraphRevision prepared statement.
static void	prepareSelectNamedGraphSizeHistory(java.sql.PreparedStatement ps, long id) Sets the input parameters for the selectNamedGraphSizeHistory prepared statement.
static void	prepareSelectNamedGraphSizeHistoryNoWith(java.sql.PreparedStatement ps, long id, java.lang.Long now1, java.lang.Long now2) Sets the input parameters for the selectNamedGraphSizeHistoryNoWith prepared statement.
static void	prepareSelectNamedGraphUriIds(java.sql.PreparedStatement ps) Sets the input parameters for the selectNamedGraphUriIds prepared statement.
static void	prepareSelectNamedGraphUris(java.sql.PreparedStatement ps) Sets the input parameters for the selectNamedGraphUris prepared statement.
static int	purgeNamedGraphRevisionTmp(PreparedStatementCache sqlCache, java.lang.String sessionPrefix) Runs the purgeNamedGraphRevisionTmp prepared statement.
static ClosableIterator<NamedGraphRdbWrapper.SelectMetaGraphUrisResult>	selectMetaGraphUris(PreparedStatementCache sqlCache, java.lang.String tableNamePrefix) Runs the selectMetaGraphUris prepared statement with the default transformer.
static ClosableIterator<NamedGraphRdbWrapper.SelectMetaGraphUrisResult>	selectMetaGraphUris(PreparedStatementCache sqlCache, java.lang.String tableNamePrefix, Transformer<NamedGraphRdbWrapper.SelectMetaGraphUrisResult> transform) Runs the selectMetaGraphUris prepared statement.
static NamedGraphRdbWrapper.SelectNamedGraphResult	selectNamedGraph(PreparedStatementCache sqlCache, long id) Runs the selectNamedGraph prepared statement.
static NamedGraphRdbWrapper.SelectNamedGraphResult	selectNamedGraph(PreparedStatementCache sqlCache, long id, NamedGraphRdbWrapper.SelectNamedGraphResult result) Runs the selectNamedGraph prepared statement.
static ClosableIterator<NamedGraphRdbWrapper.SelectNamedGraphRevisionResult>	selectNamedGraphRevision(PreparedStatementCache sqlCache, java.lang.String sessionPrefix) Runs the selectNamedGraphRevision prepared statement with the default transformer.
static ClosableIterator<NamedGraphRdbWrapper.SelectNamedGraphRevisionResult>	selectNamedGraphRevision(PreparedStatementCache sqlCache, java.lang.String sessionPrefix, Transformer<NamedGraphRdbWrapper.SelectNamedGraphRevisionResult> transform) Runs the selectNamedGraphRevision prepared statement.
static java.lang.Long	selectNamedGraphSizeHistory(PreparedStatementCache sqlCache, long id) Runs the selectNamedGraphSizeHistory prepared statement.
static java.lang.Long	selectNamedGraphSizeHistoryNoWith(PreparedStatementCache sqlCache, long id, java.lang.Long now1, java.lang.Long now2) Runs the selectNamedGraphSizeHistoryNoWith prepared statement.
static java.lang.Long	selectNamedGraphSizeHistoryNoWith(PreparedStatementCache sqlCache, NamedGraphRdbWrapper.SelectNamedGraphSizeHistoryNoWithParams params) Runs the selectNamedGraphSizeHistoryNoWith prepared statement.
static ClosableIterator<java.lang.Long>	selectNamedGraphUriIds(PreparedStatementCache sqlCache) Runs the selectNamedGraphUriIds prepared statement with the default transformer.
static ClosableIterator<java.lang.Long>	selectNamedGraphUriIds(PreparedStatementCache sqlCache, Transformer<java.lang.Long> transform) Runs the selectNamedGraphUriIds prepared statement.
static ClosableIterator<NamedGraphRdbWrapper.SelectNamedGraphUrisResult>	selectNamedGraphUris(PreparedStatementCache sqlCache, java.lang.String tableNamePrefix) Runs the selectNamedGraphUris prepared statement with the default transformer.
static ClosableIterator<NamedGraphRdbWrapper.SelectNamedGraphUrisResult>	selectNamedGraphUris(PreparedStatementCache sqlCache, java.lang.String tableNamePrefix, Transformer<NamedGraphRdbWrapper.SelectNamedGraphUrisResult> transform) Runs the selectNamedGraphUris prepared statement.

Methods inherited from class java.lang.Object

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

Field Detail

selectNamedGraph

public static final java.lang.String selectNamedGraph

Constant "selectNamedGraph" used to reference prepared statement NamedGraph.selectNamedGraph SELECT NG.METAID,NG.ACLID, NG.CREATEDBY, NG.REVISION,NG.LASTMODIFIEDBY FROM NAMEDGRAPHS NG WHERE NG.ID = ? AND NG.HEND IS NULL;

See Also:

Constant Field Values

getNamedGraphsMetaId

public static final java.lang.String getNamedGraphsMetaId

Constant "getNamedGraphsMetaId" used to reference prepared statement NamedGraph.getNamedGraphsMetaId SELECT NG.METAID FROM NAMEDGRAPHS NG WHERE NG.ID = ? AND NG.HEND IS NULL;

See Also:

Constant Field Values

getNamedGraphsMetaIdAndAciHistory

public static final java.lang.String getNamedGraphsMetaIdAndAciHistory

Constant "getNamedGraphsMetaIdAndAciHistory" used to reference prepared statement NamedGraph.getNamedGraphsMetaIdAndAciHistory SELECT DISTINCT NG.METAID,ACIS.CANREAD FROM NAMEDGRAPHS NG,ACIS ACIS WHERE NG.ID = ? AND NG.HSTART <= ? AND (NG.HEND IS NULL OR NG.HEND > ?) AND NG.ACLID=ACIS.ACLID AND ACIS.HSTART <= ? AND (ACIS.HEND IS NULL OR ACIS.HEND > ?) AND ACIS.ROLEID IN( SELECT UR.ROLEID FROM USERSROLES UR WHERE UR.HSTART <= ? AND (UR.HEND IS NULL OR UR.HEND > ?) AND UR.USERID = ? );

See Also:

Constant Field Values

getNamedGraphsMetaIdHistory

public static final java.lang.String getNamedGraphsMetaIdHistory

Constant "getNamedGraphsMetaIdHistory" used to reference prepared statement NamedGraph.getNamedGraphsMetaIdHistory SELECT DISTINCT NG.METAID FROM NAMEDGRAPHS NG,ACIS ACIS WHERE NG.ID = ? AND NG.HSTART <= ? AND (NG.HEND IS NULL OR NG.HEND > ?) AND NG.ACLID=ACIS.ACLID AND ACIS.HSTART <= ? AND (ACIS.HEND IS NULL OR ACIS.HEND > ?) AND ACIS.ROLEID IN( SELECT UR.ROLEID FROM USERSROLES UR WHERE UR.HSTART <= ? AND (UR.HEND IS NULL OR UR.HEND > ?) AND UR.USERID = ? ) AND ACIS.CANREAD=1;

See Also:

Constant Field Values

getMetadatasGraphIdHistory

public static final java.lang.String getMetadatasGraphIdHistory

Constant "getMetadatasGraphIdHistory" used to reference prepared statement NamedGraph.getMetadatasGraphIdHistory SELECT DISTINCT NG.ID FROM NAMEDGRAPHS NG,ACIS ACIS WHERE NG.METAID = ? AND NG.HSTART <= ? AND (NG.HEND IS NULL OR NG.HEND > ?) AND NG.ACLID=ACIS.ACLID AND ACIS.HSTART <= ? AND (ACIS.HEND IS NULL OR ACIS.HEND > ?) AND ACIS.ROLEID IN( SELECT UR.ROLEID FROM USERSROLES UR WHERE UR.HSTART <= ? AND (UR.HEND IS NULL OR UR.HEND > ?) AND UR.USERID = ? ) AND ACIS.CANREAD=1;

See Also:

Constant Field Values

getNamedGraphsMetaIdAndAciHistoryNew

public static final java.lang.String getNamedGraphsMetaIdAndAciHistoryNew

Constant "getNamedGraphsMetaIdAndAciHistoryNew" used to reference prepared statement NamedGraph.getNamedGraphsMetaIdAndAciHistoryNew WITH LT (COMMITED) AS ( SELECT MAX(COMMITED) FROM TRANSACTIONTIMES ) SELECT NG.METAID,ACIS.CANREAD FROM NAMEDGRAPHS NG,ACIS ACIS,LT WHERE NG.ID = ? AND NG.HSTART <= LT.COMMITED AND (NG.HEND IS NULL OR NG.HEND > LT.COMMITED) AND NG.ACLID=ACIS.ACLID AND ACIS.HSTART <= LT.COMMITED AND (ACIS.HEND IS NULL OR ACIS.HEND > LT.COMMITED) AND ACIS.ROLEID IN( SELECT UR.ROLEID FROM USERSROLES UR WHERE UR.HSTART <= LT.COMMITED AND (UR.HEND IS NULL OR UR.HEND > LT.COMMITED) AND UR.USERID = ? );

See Also:

Constant Field Values

getNamedGraphsMetaIdHistoryNew

public static final java.lang.String getNamedGraphsMetaIdHistoryNew

Constant "getNamedGraphsMetaIdHistoryNew" used to reference prepared statement NamedGraph.getNamedGraphsMetaIdHistoryNew WITH LT (COMMITED) AS ( SELECT MAX(COMMITED) FROM TRANSACTIONTIMES ) SELECT NG.METAID FROM NAMEDGRAPHS NG,ACIS ACIS,LT WHERE NG.ID = ? AND NG.HSTART <= LT.COMMITED AND (NG.HEND IS NULL OR NG.HEND > LT.COMMITED) AND NG.ACLID=ACIS.ACLID AND ACIS.HSTART <= LT.COMMITED AND (ACIS.HEND IS NULL OR ACIS.HEND > LT.COMMITED) AND ACIS.ROLEID IN( SELECT UR.ROLEID FROM USERSROLES UR WHERE UR.HSTART <= LT.COMMITED AND (UR.HEND IS NULL OR UR.HEND > LT.COMMITED) AND UR.USERID = ? ) AND ACIS.CANREAD=1;

See Also:

Constant Field Values

getStoredNamedGraphs

public static final java.lang.String getStoredNamedGraphs

Constant "getStoredNamedGraphs" used to reference prepared statement NamedGraph.getStoredNamedGraphs WITH LT (COMMITED) AS ( SELECT MAX(COMMITED) FROM TRANSACTIONTIMES ) SELECT ${a}_U.VALUE FROM ${a}_U WHERE ${a}_U.ID IN ( SELECT NG.ID FROM NAMEDGRAPHS NG,ACIS ACIS,LT WHERE NG.HSTART <= LT.COMMITED AND (NG.HEND IS NULL OR NG.HEND > LT.COMMITED) AND NG.ACLID=ACIS.ACLID AND ACIS.HSTART <= LT.COMMITED AND (ACIS.HEND IS NULL OR ACIS.HEND > LT.COMMITED) AND ACIS.ROLEID IN( SELECT UR.ROLEID FROM USERSROLES UR WHERE UR.HSTART <= LT.COMMITED AND (UR.HEND IS NULL OR UR.HEND > LT.COMMITED) AND UR.USERID = ? ) AND ACIS.CANREAD=1);

See Also:

Constant Field Values

getStoredNamedGraphsNoWith

public static final java.lang.String getStoredNamedGraphsNoWith

Constant "getStoredNamedGraphsNoWith" used to reference prepared statement NamedGraph.getStoredNamedGraphsNoWith SELECT ${a}_U.VALUE FROM ${a}_U WHERE ${a}_U.ID IN ( SELECT DISTINCT NAMEDGRAPHS.ID FROM NAMEDGRAPHS,ACIS WHERE NAMEDGRAPHS.HSTART <= ? AND (NAMEDGRAPHS.HEND IS NULL OR NAMEDGRAPHS.HEND > ?) AND NAMEDGRAPHS.ACLID=ACIS.ACLID AND ACIS.HSTART <= ? AND (ACIS.HEND IS NULL OR ACIS.HEND > ?) AND ACIS.ROLEID IN( SELECT USERSROLES.ROLEID FROM USERSROLES WHERE USERSROLES.HSTART <= ? AND (USERSROLES.HEND IS NULL OR USERSROLES.HEND > ?) AND USERSROLES.USERID = ? ) AND ACIS.CANREAD=1 );

See Also:

Constant Field Values

getTotalNumberOfStoredNamedGraphs

public static final java.lang.String getTotalNumberOfStoredNamedGraphs

Constant "getTotalNumberOfStoredNamedGraphs" used to reference prepared statement NamedGraph.getTotalNumberOfStoredNamedGraphs WITH LT (COMMITED) AS ( SELECT MAX(COMMITED) FROM TRANSACTIONTIMES ) SELECT COUNT(*) FROM NAMEDGRAPHS NG,LT WHERE NG.HSTART <= LT.COMMITED AND (NG.HEND IS NULL OR NG.HEND > LT.COMMITED)

See Also:

Constant Field Values

getTotalNumberOfStoredNamedGraphsNoWith

public static final java.lang.String getTotalNumberOfStoredNamedGraphsNoWith

Constant "getTotalNumberOfStoredNamedGraphsNoWith" used to reference prepared statement NamedGraph.getTotalNumberOfStoredNamedGraphsNoWith SELECT COUNT(*) FROM NAMEDGRAPHS NG WHERE NG.HSTART <= ? AND (NG.HEND IS NULL OR NG.HEND > ?) ;

See Also:

Constant Field Values

getAllStoredNamedGraphs

public static final java.lang.String getAllStoredNamedGraphs

Constant "getAllStoredNamedGraphs" used to reference prepared statement NamedGraph.getAllStoredNamedGraphs WITH LT (COMMITED) AS ( SELECT MAX(COMMITED) FROM TRANSACTIONTIMES ) SELECT DISTINCT ${a}_U.VALUE FROM ${a}_U WHERE ${a}_U.ID IN( SELECT NG.ID FROM NAMEDGRAPHS NG,LT WHERE NG.HSTART <= LT.COMMITED AND (NG.HEND IS NULL OR NG.HEND > LT.COMMITED) )

See Also:

Constant Field Values

getAllStoredNamedGraphsNoWith

public static final java.lang.String getAllStoredNamedGraphsNoWith

Constant "getAllStoredNamedGraphsNoWith" used to reference prepared statement NamedGraph.getAllStoredNamedGraphsNoWith SELECT DISTINCT ${a}_U.VALUE FROM ${a}_U WHERE ${a}_U.ID IN( SELECT NG.ID FROM NAMEDGRAPHS NG WHERE NG.HSTART <= ? AND (NG.HEND IS NULL OR NG.HEND > ?)) ;

See Also:

Constant Field Values

getMetadatasGraphId

public static final java.lang.String getMetadatasGraphId

Constant "getMetadatasGraphId" used to reference prepared statement NamedGraph.getMetadatasGraphId SELECT ID FROM NAMEDGRAPHS WHERE METAID = ? AND HEND IS NULL;

See Also:

Constant Field Values

selectNamedGraphSizeHistory

public static final java.lang.String selectNamedGraphSizeHistory

Constant "selectNamedGraphSizeHistory" used to reference prepared statement NamedGraph.selectNamedGraphSizeHistory WITH LT (COMMITED) AS ( SELECT MAX(COMMITED) FROM TRANSACTIONTIMES ) SELECT DISTINCT COUNT(*) FROM STATEMENTS SH,LT WHERE SH.NAMEDGRAPHID = ? AND SH.HSTART <= LT.COMMITED AND (SH.HEND IS NULL OR SH.HEND > LT.COMMITED)

See Also:

Constant Field Values

selectNamedGraphSizeHistoryNoWith

public static final java.lang.String selectNamedGraphSizeHistoryNoWith

Constant "selectNamedGraphSizeHistoryNoWith" used to reference prepared statement NamedGraph.selectNamedGraphSizeHistoryNoWith SELECT DISTINCT COUNT(*) FROM STATEMENTS SH WHERE SH.NAMEDGRAPHID = ? AND SH.HSTART <= ? AND (SH.HEND IS NULL OR SH.HEND > ?)

See Also:

Constant Field Values

selectNamedGraphUriIds

public static final java.lang.String selectNamedGraphUriIds

Constant "selectNamedGraphUriIds" used to reference prepared statement NamedGraph.selectNamedGraphUriIds SELECT ID FROM NAMEDGRAPHS WHERE HEND IS NULL;

See Also:

Constant Field Values

selectNamedGraphUris

public static final java.lang.String selectNamedGraphUris

Constant "selectNamedGraphUris" used to reference prepared statement NamedGraph.selectNamedGraphUris SELECT DISTINCT ${a}_U.ID,${a}_U.VALUE FROM ${a}_U WHERE ${a}_U.ID IN (SELECT ID FROM NAMEDGRAPHS WHERE HEND IS NULL);

See Also:

Constant Field Values

selectMetaGraphUris

public static final java.lang.String selectMetaGraphUris

Constant "selectMetaGraphUris" used to reference prepared statement NamedGraph.selectMetaGraphUris SELECT DISTINCT ${a}_U.ID,${a}_U.VALUE FROM ${a}_U WHERE ${a}_U.ID IN (SELECT METAID FROM NAMEDGRAPHS WHERE HEND IS NULL);

See Also:

Constant Field Values

insertNamedGraph

public static final java.lang.String insertNamedGraph

Constant "insertNamedGraph" used to reference prepared statement NamedGraph.insertNamedGraph INSERT INTO NAMEDGRAPHS (HSTART, ID, METAID,ACLID, CREATEDBY, REVISION,LASTMODIFIEDBY) VALUES (?, ?,?, ?, ?, ?,?);

See Also:

Constant Field Values

deleteNamedGraph

public static final java.lang.String deleteNamedGraph

Constant "deleteNamedGraph" used to reference prepared statement NamedGraph.deleteNamedGraph UPDATE NAMEDGRAPHS SET HEND=? WHERE ID = ?;

See Also:

Constant Field Values

deleteStatementsForNamedGraph

public static final java.lang.String deleteStatementsForNamedGraph

Constant "deleteStatementsForNamedGraph" used to reference prepared statement NamedGraph.deleteStatementsForNamedGraph UPDATE STATEMENTS SET HEND=? WHERE NAMEDGRAPHID = ?;

See Also:

Constant Field Values

getNamedGraphAtRevision

public static final java.lang.String getNamedGraphAtRevision

Constant "getNamedGraphAtRevision" used to reference prepared statement NamedGraph.getNamedGraphAtRevision SELECT METAID,HSTART,ACLID,CREATEDBY,LASTMODIFIEDBY FROM NAMEDGRAPHS WHERE ID=? AND REVISION=?

See Also:

Constant Field Values

getNamedGraphCurrentRevision

public static final java.lang.String getNamedGraphCurrentRevision

Constant "getNamedGraphCurrentRevision" used to reference prepared statement NamedGraph.getNamedGraphCurrentRevision SELECT REVISION FROM NAMEDGRAPHS WHERE ID=? AND HEND IS NULL;

See Also:

Constant Field Values

lookupNamedGraphRevision

public static final java.lang.String lookupNamedGraphRevision

Constant "lookupNamedGraphRevision" used to reference prepared statement NamedGraph.lookupNamedGraphRevision INSERT INTO ${a}RESULTS_TMP (ID, NAMEDGRAPHID, SUBJ, PROP, OBJ) SELECT SH.ID,SH.NAMEDGRAPHID,SH.SUBJ, SH.PROP, SH.OBJ FROM STATEMENTS SH,NAMEDGRAPHS NG,ACIS WHERE NG.ID=? AND SH.NAMEDGRAPHID = ? AND SH.HSTART <= ? AND (SH.HEND IS NULL OR SH.HEND > ?) AND SH.NAMEDGRAPHID = NG.ID AND NG.HSTART <= ? AND (NG.HEND IS NULL OR NG.HEND > ?) AND NG.ACLID=ACIS.ACLID AND ACIS.HSTART <= ? AND (ACIS.HEND IS NULL OR ACIS.HEND > ?) AND ACIS.ROLEID IN(SELECT UR.ROLEID FROM USERSROLES UR WHERE UR.HSTART <= ? AND (UR.HEND IS NULL OR UR.HEND > ?) AND UR.USERID = ? ) AND ACIS.CANREAD = 1

See Also:

Constant Field Values

purgeNamedGraphRevisionTmp

public static final java.lang.String purgeNamedGraphRevisionTmp

Constant "purgeNamedGraphRevisionTmp" used to reference prepared statement NamedGraph.purgeNamedGraphRevisionTmp DELETE FROM ${a}RESULTS_TMP

See Also:

Constant Field Values

selectNamedGraphRevision

public static final java.lang.String selectNamedGraphRevision

Constant "selectNamedGraphRevision" used to reference prepared statement NamedGraph.selectNamedGraphRevision SELECT ID,SUBJ,PROP,OBJ,NAMEDGRAPHID FROM ${a}RESULTS_TMP WHERE ID IS NOT NULL;

See Also:

Constant Field Values

Constructor Detail

NamedGraphRdbWrapper

public NamedGraphRdbWrapper()

Method Detail

selectNamedGraph

public static NamedGraphRdbWrapper.SelectNamedGraphResult selectNamedGraph(PreparedStatementCache sqlCache,
                                                                           long id)
                                                                    throws AnzoException,
                                                                           java.sql.SQLException

Runs the selectNamedGraph prepared statement. SELECT NG.METAID,NG.ACLID, NG.CREATEDBY, NG.REVISION,NG.LASTMODIFIEDBY FROM NAMEDGRAPHS NG WHERE NG.ID = ? AND NG.HEND IS NULL;

Parameters:

sqlCache - factory and cache of PreparedStatments

id - template parameter

Returns:

SelectNamedGraphResult containing the results of the SQL operation

Throws:

AnzoException

java.sql.SQLException

selectNamedGraph

public static NamedGraphRdbWrapper.SelectNamedGraphResult selectNamedGraph(PreparedStatementCache sqlCache,
                                                                           long id,
                                                                           NamedGraphRdbWrapper.SelectNamedGraphResult result)
                                                                    throws AnzoException,
                                                                           java.sql.SQLException

Runs the selectNamedGraph prepared statement. SELECT NG.METAID,NG.ACLID, NG.CREATEDBY, NG.REVISION,NG.LASTMODIFIEDBY FROM NAMEDGRAPHS NG WHERE NG.ID = ? AND NG.HEND IS NULL;

Parameters:

sqlCache - factory and cache of PreparedStatments

id - template parameter

result - SelectNamedGraphResult result object

Returns:

SelectNamedGraphResult

Throws:

AnzoException

java.sql.SQLException

prepareSelectNamedGraph

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

Sets the input parameters for the selectNamedGraph prepared statement.

Parameters:

ps - PreparedStatement to whose parameters are set

id - template parameter

Throws:

java.sql.SQLException

getNamedGraphsMetaId

public static java.lang.Long getNamedGraphsMetaId(PreparedStatementCache sqlCache,
                                                  long id)
                                           throws AnzoException,
                                                  java.sql.SQLException

Runs the getNamedGraphsMetaId prepared statement. SELECT NG.METAID FROM NAMEDGRAPHS NG WHERE NG.ID = ? AND NG.HEND IS NULL;

Parameters:

sqlCache - factory and cache of PreparedStatments

id - template parameter

Returns:

Long

Throws:

AnzoException

java.sql.SQLException

prepareGetNamedGraphsMetaId

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

Sets the input parameters for the getNamedGraphsMetaId prepared statement.

Parameters:

ps - PreparedStatement to whose parameters are set

id - template parameter

Throws:

java.sql.SQLException

getNamedGraphsMetaIdAndAciHistory

public static ClosableIterator<NamedGraphRdbWrapper.GetNamedGraphsMetaIdAndAciHistoryResult> getNamedGraphsMetaIdAndAciHistory(PreparedStatementCache sqlCache,
                                                                                                                               NamedGraphRdbWrapper.GetNamedGraphsMetaIdAndAciHistoryParams params)
                                                                                                                        throws AnzoException,
                                                                                                                               java.sql.SQLException

Runs the getNamedGraphsMetaIdAndAciHistory prepared statement. SELECT DISTINCT NG.METAID,ACIS.CANREAD FROM NAMEDGRAPHS NG,ACIS ACIS WHERE NG.ID = ? AND NG.HSTART <= ? AND (NG.HEND IS NULL OR NG.HEND > ?) AND NG.ACLID=ACIS.ACLID AND ACIS.HSTART <= ? AND (ACIS.HEND IS NULL OR ACIS.HEND > ?) AND ACIS.ROLEID IN( SELECT UR.ROLEID FROM USERSROLES UR WHERE UR.HSTART <= ? AND (UR.HEND IS NULL OR UR.HEND > ?) AND UR.USERID = ? );

Parameters:

sqlCache - factory and cache of PreparedStatments

params - GetNamedGraphsMetaIdAndAciHistoryParams input Interface

Returns:

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

Throws:

AnzoException

java.sql.SQLException

getNamedGraphsMetaIdAndAciHistory

public static ClosableIterator<NamedGraphRdbWrapper.GetNamedGraphsMetaIdAndAciHistoryResult> getNamedGraphsMetaIdAndAciHistory(PreparedStatementCache sqlCache,
                                                                                                                               long id,
                                                                                                                               java.lang.Long now,
                                                                                                                               java.lang.Long now2,
                                                                                                                               java.lang.Long now3,
                                                                                                                               java.lang.Long now4,
                                                                                                                               java.lang.Long now5,
                                                                                                                               java.lang.Long now6,
                                                                                                                               long userId)
                                                                                                                        throws AnzoException,
                                                                                                                               java.sql.SQLException

Runs the getNamedGraphsMetaIdAndAciHistory prepared statement with the default transformer. SELECT DISTINCT NG.METAID,ACIS.CANREAD FROM NAMEDGRAPHS NG,ACIS ACIS WHERE NG.ID = ? AND NG.HSTART <= ? AND (NG.HEND IS NULL OR NG.HEND > ?) AND NG.ACLID=ACIS.ACLID AND ACIS.HSTART <= ? AND (ACIS.HEND IS NULL OR ACIS.HEND > ?) AND ACIS.ROLEID IN( SELECT UR.ROLEID FROM USERSROLES UR WHERE UR.HSTART <= ? AND (UR.HEND IS NULL OR UR.HEND > ?) AND UR.USERID = ? );

Parameters:

sqlCache - factory and cache of PreparedStatments

id - template parameter

now - template parameter

now2 - template parameter

now3 - template parameter

now4 - template parameter

now5 - template parameter

now6 - template parameter

userId - template parameter

Returns:

org.openanzo.jdbc.utils.ClosableIterator

Throws:

AnzoException

java.sql.SQLException

getNamedGraphsMetaIdAndAciHistory

public static ClosableIterator<NamedGraphRdbWrapper.GetNamedGraphsMetaIdAndAciHistoryResult> getNamedGraphsMetaIdAndAciHistory(PreparedStatementCache sqlCache,
                                                                                                                               long id,
                                                                                                                               java.lang.Long now,
                                                                                                                               java.lang.Long now2,
                                                                                                                               java.lang.Long now3,
                                                                                                                               java.lang.Long now4,
                                                                                                                               java.lang.Long now5,
                                                                                                                               java.lang.Long now6,
                                                                                                                               long userId,
                                                                                                                               Transformer<NamedGraphRdbWrapper.GetNamedGraphsMetaIdAndAciHistoryResult> transform)
                                                                                                                        throws AnzoException,
                                                                                                                               java.sql.SQLException

Runs the getNamedGraphsMetaIdAndAciHistory prepared statement. SELECT DISTINCT NG.METAID,ACIS.CANREAD FROM NAMEDGRAPHS NG,ACIS ACIS WHERE NG.ID = ? AND NG.HSTART <= ? AND (NG.HEND IS NULL OR NG.HEND > ?) AND NG.ACLID=ACIS.ACLID AND ACIS.HSTART <= ? AND (ACIS.HEND IS NULL OR ACIS.HEND > ?) AND ACIS.ROLEID IN( SELECT UR.ROLEID FROM USERSROLES UR WHERE UR.HSTART <= ? AND (UR.HEND IS NULL OR UR.HEND > ?) AND UR.USERID = ? );

Parameters:

sqlCache - factory and cache of PreparedStatments

id - template parameter

now - template parameter

now2 - template parameter

now3 - template parameter

now4 - template parameter

now5 - template parameter

now6 - template parameter

userId - 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

prepareGetNamedGraphsMetaIdAndAciHistory

public static void prepareGetNamedGraphsMetaIdAndAciHistory(java.sql.PreparedStatement ps,
                                                            long id,
                                                            java.lang.Long now,
                                                            java.lang.Long now2,
                                                            java.lang.Long now3,
                                                            java.lang.Long now4,
                                                            java.lang.Long now5,
                                                            java.lang.Long now6,
                                                            long userId)
                                                     throws java.sql.SQLException

Sets the input parameters for the getNamedGraphsMetaIdAndAciHistory prepared statement.

Parameters:

ps - PreparedStatement to whose parameters are set

id - template parameter

now - template parameter

now2 - template parameter

now3 - template parameter

now4 - template parameter

now5 - template parameter

now6 - template parameter

userId - template parameter

Throws:

java.sql.SQLException

getNamedGraphsMetaIdHistory

public static java.lang.Long getNamedGraphsMetaIdHistory(PreparedStatementCache sqlCache,
                                                         NamedGraphRdbWrapper.GetNamedGraphsMetaIdHistoryParams params)
                                                  throws AnzoException,
                                                         java.sql.SQLException

Runs the getNamedGraphsMetaIdHistory prepared statement. SELECT DISTINCT NG.METAID FROM NAMEDGRAPHS NG,ACIS ACIS WHERE NG.ID = ? AND NG.HSTART <= ? AND (NG.HEND IS NULL OR NG.HEND > ?) AND NG.ACLID=ACIS.ACLID AND ACIS.HSTART <= ? AND (ACIS.HEND IS NULL OR ACIS.HEND > ?) AND ACIS.ROLEID IN( SELECT UR.ROLEID FROM USERSROLES UR WHERE UR.HSTART <= ? AND (UR.HEND IS NULL OR UR.HEND > ?) AND UR.USERID = ? ) AND ACIS.CANREAD=1;

Parameters:

sqlCache - factory and cache of PreparedStatments

params - GetNamedGraphsMetaIdHistoryParams input Interface

Returns:

Long containing the results of the SQL operation

Throws:

AnzoException

java.sql.SQLException

getNamedGraphsMetaIdHistory

public static java.lang.Long getNamedGraphsMetaIdHistory(PreparedStatementCache sqlCache,
                                                         long id,
                                                         java.lang.Long now,
                                                         java.lang.Long now2,
                                                         java.lang.Long now3,
                                                         java.lang.Long now4,
                                                         java.lang.Long now5,
                                                         java.lang.Long now6,
                                                         long userId)
                                                  throws AnzoException,
                                                         java.sql.SQLException

Runs the getNamedGraphsMetaIdHistory prepared statement. SELECT DISTINCT NG.METAID FROM NAMEDGRAPHS NG,ACIS ACIS WHERE NG.ID = ? AND NG.HSTART <= ? AND (NG.HEND IS NULL OR NG.HEND > ?) AND NG.ACLID=ACIS.ACLID AND ACIS.HSTART <= ? AND (ACIS.HEND IS NULL OR ACIS.HEND > ?) AND ACIS.ROLEID IN( SELECT UR.ROLEID FROM USERSROLES UR WHERE UR.HSTART <= ? AND (UR.HEND IS NULL OR UR.HEND > ?) AND UR.USERID = ? ) AND ACIS.CANREAD=1;

Parameters:

sqlCache - factory and cache of PreparedStatments

id - template parameter

now - template parameter

now2 - template parameter

now3 - template parameter

now4 - template parameter

now5 - template parameter

now6 - template parameter

userId - template parameter

Returns:

Long

Throws:

AnzoException

java.sql.SQLException

prepareGetNamedGraphsMetaIdHistory

public static void prepareGetNamedGraphsMetaIdHistory(java.sql.PreparedStatement ps,
                                                      long id,
                                                      java.lang.Long now,
                                                      java.lang.Long now2,
                                                      java.lang.Long now3,
                                                      java.lang.Long now4,
                                                      java.lang.Long now5,
                                                      java.lang.Long now6,
                                                      long userId)
                                               throws java.sql.SQLException

Sets the input parameters for the getNamedGraphsMetaIdHistory prepared statement.

Parameters:

ps - PreparedStatement to whose parameters are set

id - template parameter

now - template parameter

now2 - template parameter

now3 - template parameter

now4 - template parameter

now5 - template parameter

now6 - template parameter

userId - template parameter

Throws:

java.sql.SQLException

getMetadatasGraphIdHistory

public static java.lang.Long getMetadatasGraphIdHistory(PreparedStatementCache sqlCache,
                                                        NamedGraphRdbWrapper.GetMetadatasGraphIdHistoryParams params)
                                                 throws AnzoException,
                                                        java.sql.SQLException

Runs the getMetadatasGraphIdHistory prepared statement. SELECT DISTINCT NG.ID FROM NAMEDGRAPHS NG,ACIS ACIS WHERE NG.METAID = ? AND NG.HSTART <= ? AND (NG.HEND IS NULL OR NG.HEND > ?) AND NG.ACLID=ACIS.ACLID AND ACIS.HSTART <= ? AND (ACIS.HEND IS NULL OR ACIS.HEND > ?) AND ACIS.ROLEID IN( SELECT UR.ROLEID FROM USERSROLES UR WHERE UR.HSTART <= ? AND (UR.HEND IS NULL OR UR.HEND > ?) AND UR.USERID = ? ) AND ACIS.CANREAD=1;

Parameters:

sqlCache - factory and cache of PreparedStatments

params - GetMetadatasGraphIdHistoryParams input Interface

Returns:

Long containing the results of the SQL operation

Throws:

AnzoException

java.sql.SQLException

getMetadatasGraphIdHistory

public static java.lang.Long getMetadatasGraphIdHistory(PreparedStatementCache sqlCache,
                                                        long metaid,
                                                        java.lang.Long now,
                                                        java.lang.Long now2,
                                                        java.lang.Long now3,
                                                        java.lang.Long now4,
                                                        java.lang.Long now5,
                                                        java.lang.Long now6,
                                                        long userId)
                                                 throws AnzoException,
                                                        java.sql.SQLException

Runs the getMetadatasGraphIdHistory prepared statement. SELECT DISTINCT NG.ID FROM NAMEDGRAPHS NG,ACIS ACIS WHERE NG.METAID = ? AND NG.HSTART <= ? AND (NG.HEND IS NULL OR NG.HEND > ?) AND NG.ACLID=ACIS.ACLID AND ACIS.HSTART <= ? AND (ACIS.HEND IS NULL OR ACIS.HEND > ?) AND ACIS.ROLEID IN( SELECT UR.ROLEID FROM USERSROLES UR WHERE UR.HSTART <= ? AND (UR.HEND IS NULL OR UR.HEND > ?) AND UR.USERID = ? ) AND ACIS.CANREAD=1;

Parameters:

sqlCache - factory and cache of PreparedStatments

metaid - template parameter

now - template parameter

now2 - template parameter

now3 - template parameter

now4 - template parameter

now5 - template parameter

now6 - template parameter

userId - template parameter

Returns:

Long

Throws:

AnzoException

java.sql.SQLException

prepareGetMetadatasGraphIdHistory

public static void prepareGetMetadatasGraphIdHistory(java.sql.PreparedStatement ps,
                                                     long metaid,
                                                     java.lang.Long now,
                                                     java.lang.Long now2,
                                                     java.lang.Long now3,
                                                     java.lang.Long now4,
                                                     java.lang.Long now5,
                                                     java.lang.Long now6,
                                                     long userId)
                                              throws java.sql.SQLException

Sets the input parameters for the getMetadatasGraphIdHistory prepared statement.

Parameters:

ps - PreparedStatement to whose parameters are set

metaid - template parameter

now - template parameter

now2 - template parameter

now3 - template parameter

now4 - template parameter

now5 - template parameter

now6 - template parameter

userId - template parameter

Throws:

java.sql.SQLException

getNamedGraphsMetaIdAndAciHistoryNew

public static ClosableIterator<NamedGraphRdbWrapper.GetNamedGraphsMetaIdAndAciHistoryNewResult> getNamedGraphsMetaIdAndAciHistoryNew(PreparedStatementCache sqlCache,
                                                                                                                                     NamedGraphRdbWrapper.GetNamedGraphsMetaIdAndAciHistoryNewParams params)
                                                                                                                              throws AnzoException,
                                                                                                                                     java.sql.SQLException

Runs the getNamedGraphsMetaIdAndAciHistoryNew prepared statement. WITH LT (COMMITED) AS ( SELECT MAX(COMMITED) FROM TRANSACTIONTIMES ) SELECT NG.METAID,ACIS.CANREAD FROM NAMEDGRAPHS NG,ACIS ACIS,LT WHERE NG.ID = ? AND NG.HSTART <= LT.COMMITED AND (NG.HEND IS NULL OR NG.HEND > LT.COMMITED) AND NG.ACLID=ACIS.ACLID AND ACIS.HSTART <= LT.COMMITED AND (ACIS.HEND IS NULL OR ACIS.HEND > LT.COMMITED) AND ACIS.ROLEID IN( SELECT UR.ROLEID FROM USERSROLES UR WHERE UR.HSTART <= LT.COMMITED AND (UR.HEND IS NULL OR UR.HEND > LT.COMMITED) AND UR.USERID = ? );

Parameters:

sqlCache - factory and cache of PreparedStatments

params - GetNamedGraphsMetaIdAndAciHistoryNewParams input Interface

Returns:

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

Throws:

AnzoException

java.sql.SQLException

getNamedGraphsMetaIdAndAciHistoryNew

public static ClosableIterator<NamedGraphRdbWrapper.GetNamedGraphsMetaIdAndAciHistoryNewResult> getNamedGraphsMetaIdAndAciHistoryNew(PreparedStatementCache sqlCache,
                                                                                                                                     long id,
                                                                                                                                     long userId)
                                                                                                                              throws AnzoException,
                                                                                                                                     java.sql.SQLException

Runs the getNamedGraphsMetaIdAndAciHistoryNew prepared statement with the default transformer. WITH LT (COMMITED) AS ( SELECT MAX(COMMITED) FROM TRANSACTIONTIMES ) SELECT NG.METAID,ACIS.CANREAD FROM NAMEDGRAPHS NG,ACIS ACIS,LT WHERE NG.ID = ? AND NG.HSTART <= LT.COMMITED AND (NG.HEND IS NULL OR NG.HEND > LT.COMMITED) AND NG.ACLID=ACIS.ACLID AND ACIS.HSTART <= LT.COMMITED AND (ACIS.HEND IS NULL OR ACIS.HEND > LT.COMMITED) AND ACIS.ROLEID IN( SELECT UR.ROLEID FROM USERSROLES UR WHERE UR.HSTART <= LT.COMMITED AND (UR.HEND IS NULL OR UR.HEND > LT.COMMITED) AND UR.USERID = ? );

Parameters:

sqlCache - factory and cache of PreparedStatments

id - template parameter

userId - template parameter

Returns:

org.openanzo.jdbc.utils.ClosableIterator

Throws:

AnzoException

java.sql.SQLException

getNamedGraphsMetaIdAndAciHistoryNew

public static ClosableIterator<NamedGraphRdbWrapper.GetNamedGraphsMetaIdAndAciHistoryNewResult> getNamedGraphsMetaIdAndAciHistoryNew(PreparedStatementCache sqlCache,
                                                                                                                                     long id,
                                                                                                                                     long userId,
                                                                                                                                     Transformer<NamedGraphRdbWrapper.GetNamedGraphsMetaIdAndAciHistoryNewResult> transform)
                                                                                                                              throws AnzoException,
                                                                                                                                     java.sql.SQLException

Runs the getNamedGraphsMetaIdAndAciHistoryNew prepared statement. WITH LT (COMMITED) AS ( SELECT MAX(COMMITED) FROM TRANSACTIONTIMES ) SELECT NG.METAID,ACIS.CANREAD FROM NAMEDGRAPHS NG,ACIS ACIS,LT WHERE NG.ID = ? AND NG.HSTART <= LT.COMMITED AND (NG.HEND IS NULL OR NG.HEND > LT.COMMITED) AND NG.ACLID=ACIS.ACLID AND ACIS.HSTART <= LT.COMMITED AND (ACIS.HEND IS NULL OR ACIS.HEND > LT.COMMITED) AND ACIS.ROLEID IN( SELECT UR.ROLEID FROM USERSROLES UR WHERE UR.HSTART <= LT.COMMITED AND (UR.HEND IS NULL OR UR.HEND > LT.COMMITED) AND UR.USERID = ? );

Parameters:

sqlCache - factory and cache of PreparedStatments

id - template parameter

userId - 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

prepareGetNamedGraphsMetaIdAndAciHistoryNew

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

Sets the input parameters for the getNamedGraphsMetaIdAndAciHistoryNew prepared statement.

Parameters:

ps - PreparedStatement to whose parameters are set

id - template parameter

userId - template parameter

Throws:

java.sql.SQLException

getNamedGraphsMetaIdHistoryNew

public static java.lang.Long getNamedGraphsMetaIdHistoryNew(PreparedStatementCache sqlCache,
                                                            NamedGraphRdbWrapper.GetNamedGraphsMetaIdHistoryNewParams params)
                                                     throws AnzoException,
                                                            java.sql.SQLException

Runs the getNamedGraphsMetaIdHistoryNew prepared statement. WITH LT (COMMITED) AS ( SELECT MAX(COMMITED) FROM TRANSACTIONTIMES ) SELECT NG.METAID FROM NAMEDGRAPHS NG,ACIS ACIS,LT WHERE NG.ID = ? AND NG.HSTART <= LT.COMMITED AND (NG.HEND IS NULL OR NG.HEND > LT.COMMITED) AND NG.ACLID=ACIS.ACLID AND ACIS.HSTART <= LT.COMMITED AND (ACIS.HEND IS NULL OR ACIS.HEND > LT.COMMITED) AND ACIS.ROLEID IN( SELECT UR.ROLEID FROM USERSROLES UR WHERE UR.HSTART <= LT.COMMITED AND (UR.HEND IS NULL OR UR.HEND > LT.COMMITED) AND UR.USERID = ? ) AND ACIS.CANREAD=1;

Parameters:

sqlCache - factory and cache of PreparedStatments

params - GetNamedGraphsMetaIdHistoryNewParams input Interface

Returns:

Long containing the results of the SQL operation

Throws:

AnzoException

java.sql.SQLException

getNamedGraphsMetaIdHistoryNew

public static java.lang.Long getNamedGraphsMetaIdHistoryNew(PreparedStatementCache sqlCache,
                                                            long id,
                                                            long userId)
                                                     throws AnzoException,
                                                            java.sql.SQLException

Runs the getNamedGraphsMetaIdHistoryNew prepared statement. WITH LT (COMMITED) AS ( SELECT MAX(COMMITED) FROM TRANSACTIONTIMES ) SELECT NG.METAID FROM NAMEDGRAPHS NG,ACIS ACIS,LT WHERE NG.ID = ? AND NG.HSTART <= LT.COMMITED AND (NG.HEND IS NULL OR NG.HEND > LT.COMMITED) AND NG.ACLID=ACIS.ACLID AND ACIS.HSTART <= LT.COMMITED AND (ACIS.HEND IS NULL OR ACIS.HEND > LT.COMMITED) AND ACIS.ROLEID IN( SELECT UR.ROLEID FROM USERSROLES UR WHERE UR.HSTART <= LT.COMMITED AND (UR.HEND IS NULL OR UR.HEND > LT.COMMITED) AND UR.USERID = ? ) AND ACIS.CANREAD=1;

Parameters:

sqlCache - factory and cache of PreparedStatments

id - template parameter

userId - template parameter

Returns:

Long

Throws:

AnzoException

java.sql.SQLException

prepareGetNamedGraphsMetaIdHistoryNew

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

Sets the input parameters for the getNamedGraphsMetaIdHistoryNew prepared statement.

Parameters:

ps - PreparedStatement to whose parameters are set

id - template parameter

userId - template parameter

Throws:

java.sql.SQLException

getStoredNamedGraphs

public static ClosableIterator<java.lang.String> getStoredNamedGraphs(PreparedStatementCache sqlCache,
                                                                      long userId,
                                                                      java.lang.String tableNamePrefix)
                                                               throws AnzoException,
                                                                      java.sql.SQLException

Runs the getStoredNamedGraphs prepared statement with the default transformer. WITH LT (COMMITED) AS ( SELECT MAX(COMMITED) FROM TRANSACTIONTIMES ) SELECT ${a}_U.VALUE FROM ${a}_U WHERE ${a}_U.ID IN ( SELECT NG.ID FROM NAMEDGRAPHS NG,ACIS ACIS,LT WHERE NG.HSTART <= LT.COMMITED AND (NG.HEND IS NULL OR NG.HEND > LT.COMMITED) AND NG.ACLID=ACIS.ACLID AND ACIS.HSTART <= LT.COMMITED AND (ACIS.HEND IS NULL OR ACIS.HEND > LT.COMMITED) AND ACIS.ROLEID IN( SELECT UR.ROLEID FROM USERSROLES UR WHERE UR.HSTART <= LT.COMMITED AND (UR.HEND IS NULL OR UR.HEND > LT.COMMITED) AND UR.USERID = ? ) AND ACIS.CANREAD=1);

Parameters:

sqlCache - factory and cache of PreparedStatments

userId - template parameter

tableNamePrefix - template parameter

Returns:

org.openanzo.jdbc.utils.ClosableIterator

Throws:

AnzoException

java.sql.SQLException

getStoredNamedGraphs

public static ClosableIterator<java.lang.String> getStoredNamedGraphs(PreparedStatementCache sqlCache,
                                                                      long userId,
                                                                      java.lang.String tableNamePrefix,
                                                                      Transformer<java.lang.String> transform)
                                                               throws AnzoException,
                                                                      java.sql.SQLException

Runs the getStoredNamedGraphs prepared statement. WITH LT (COMMITED) AS ( SELECT MAX(COMMITED) FROM TRANSACTIONTIMES ) SELECT ${a}_U.VALUE FROM ${a}_U WHERE ${a}_U.ID IN ( SELECT NG.ID FROM NAMEDGRAPHS NG,ACIS ACIS,LT WHERE NG.HSTART <= LT.COMMITED AND (NG.HEND IS NULL OR NG.HEND > LT.COMMITED) AND NG.ACLID=ACIS.ACLID AND ACIS.HSTART <= LT.COMMITED AND (ACIS.HEND IS NULL OR ACIS.HEND > LT.COMMITED) AND ACIS.ROLEID IN( SELECT UR.ROLEID FROM USERSROLES UR WHERE UR.HSTART <= LT.COMMITED AND (UR.HEND IS NULL OR UR.HEND > LT.COMMITED) AND UR.USERID = ? ) AND ACIS.CANREAD=1);

Parameters:

sqlCache - factory and cache of PreparedStatments

userId - template parameter

tableNamePrefix - 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

prepareGetStoredNamedGraphs

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

Sets the input parameters for the getStoredNamedGraphs prepared statement.

Parameters:

ps - PreparedStatement to whose parameters are set

userId - template parameter

Throws:

java.sql.SQLException

getStoredNamedGraphsNoWith

public static ClosableIterator<java.lang.String> getStoredNamedGraphsNoWith(PreparedStatementCache sqlCache,
                                                                            NamedGraphRdbWrapper.GetStoredNamedGraphsNoWithParams params,
                                                                            java.lang.String tableNamePrefix)
                                                                     throws AnzoException,
                                                                            java.sql.SQLException

Runs the getStoredNamedGraphsNoWith prepared statement. SELECT ${a}_U.VALUE FROM ${a}_U WHERE ${a}_U.ID IN ( SELECT DISTINCT NAMEDGRAPHS.ID FROM NAMEDGRAPHS,ACIS WHERE NAMEDGRAPHS.HSTART <= ? AND (NAMEDGRAPHS.HEND IS NULL OR NAMEDGRAPHS.HEND > ?) AND NAMEDGRAPHS.ACLID=ACIS.ACLID AND ACIS.HSTART <= ? AND (ACIS.HEND IS NULL OR ACIS.HEND > ?) AND ACIS.ROLEID IN( SELECT USERSROLES.ROLEID FROM USERSROLES WHERE USERSROLES.HSTART <= ? AND (USERSROLES.HEND IS NULL OR USERSROLES.HEND > ?) AND USERSROLES.USERID = ? ) AND ACIS.CANREAD=1 );

Parameters:

sqlCache - factory and cache of PreparedStatments

params - GetStoredNamedGraphsNoWithParams input Interface

tableNamePrefix - template parameter

Returns:

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

Throws:

AnzoException

java.sql.SQLException

getStoredNamedGraphsNoWith

public static ClosableIterator<java.lang.String> getStoredNamedGraphsNoWith(PreparedStatementCache sqlCache,
                                                                            java.lang.Long now,
                                                                            java.lang.Long now2,
                                                                            java.lang.Long now3,
                                                                            java.lang.Long now4,
                                                                            java.lang.Long now5,
                                                                            java.lang.Long now6,
                                                                            long userId,
                                                                            java.lang.String tableNamePrefix)
                                                                     throws AnzoException,
                                                                            java.sql.SQLException

Runs the getStoredNamedGraphsNoWith prepared statement with the default transformer. SELECT ${a}_U.VALUE FROM ${a}_U WHERE ${a}_U.ID IN ( SELECT DISTINCT NAMEDGRAPHS.ID FROM NAMEDGRAPHS,ACIS WHERE NAMEDGRAPHS.HSTART <= ? AND (NAMEDGRAPHS.HEND IS NULL OR NAMEDGRAPHS.HEND > ?) AND NAMEDGRAPHS.ACLID=ACIS.ACLID AND ACIS.HSTART <= ? AND (ACIS.HEND IS NULL OR ACIS.HEND > ?) AND ACIS.ROLEID IN( SELECT USERSROLES.ROLEID FROM USERSROLES WHERE USERSROLES.HSTART <= ? AND (USERSROLES.HEND IS NULL OR USERSROLES.HEND > ?) AND USERSROLES.USERID = ? ) AND ACIS.CANREAD=1 );

Parameters:

sqlCache - factory and cache of PreparedStatments

now - template parameter

now2 - template parameter

now3 - template parameter

now4 - template parameter

now5 - template parameter

now6 - template parameter

userId - template parameter

tableNamePrefix - template parameter

Returns:

org.openanzo.jdbc.utils.ClosableIterator

Throws:

AnzoException

java.sql.SQLException

getStoredNamedGraphsNoWith

public static ClosableIterator<java.lang.String> getStoredNamedGraphsNoWith(PreparedStatementCache sqlCache,
                                                                            java.lang.Long now,
                                                                            java.lang.Long now2,
                                                                            java.lang.Long now3,
                                                                            java.lang.Long now4,
                                                                            java.lang.Long now5,
                                                                            java.lang.Long now6,
                                                                            long userId,
                                                                            java.lang.String tableNamePrefix,
                                                                            Transformer<java.lang.String> transform)
                                                                     throws AnzoException,
                                                                            java.sql.SQLException

Runs the getStoredNamedGraphsNoWith prepared statement. SELECT ${a}_U.VALUE FROM ${a}_U WHERE ${a}_U.ID IN ( SELECT DISTINCT NAMEDGRAPHS.ID FROM NAMEDGRAPHS,ACIS WHERE NAMEDGRAPHS.HSTART <= ? AND (NAMEDGRAPHS.HEND IS NULL OR NAMEDGRAPHS.HEND > ?) AND NAMEDGRAPHS.ACLID=ACIS.ACLID AND ACIS.HSTART <= ? AND (ACIS.HEND IS NULL OR ACIS.HEND > ?) AND ACIS.ROLEID IN( SELECT USERSROLES.ROLEID FROM USERSROLES WHERE USERSROLES.HSTART <= ? AND (USERSROLES.HEND IS NULL OR USERSROLES.HEND > ?) AND USERSROLES.USERID = ? ) AND ACIS.CANREAD=1 );

Parameters:

sqlCache - factory and cache of PreparedStatments

now - template parameter

now2 - template parameter

now3 - template parameter

now4 - template parameter

now5 - template parameter

now6 - template parameter

userId - template parameter

tableNamePrefix - 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

prepareGetStoredNamedGraphsNoWith

public static void prepareGetStoredNamedGraphsNoWith(java.sql.PreparedStatement ps,
                                                     java.lang.Long now,
                                                     java.lang.Long now2,
                                                     java.lang.Long now3,
                                                     java.lang.Long now4,
                                                     java.lang.Long now5,
                                                     java.lang.Long now6,
                                                     long userId)
                                              throws java.sql.SQLException

Sets the input parameters for the getStoredNamedGraphsNoWith prepared statement.

Parameters:

ps - PreparedStatement to whose parameters are set

now - template parameter

now2 - template parameter

now3 - template parameter

now4 - template parameter

now5 - template parameter

now6 - template parameter

userId - template parameter

Throws:

java.sql.SQLException

getTotalNumberOfStoredNamedGraphs

public static java.lang.Long getTotalNumberOfStoredNamedGraphs(PreparedStatementCache sqlCache)
                                                        throws AnzoException,
                                                               java.sql.SQLException

Runs the getTotalNumberOfStoredNamedGraphs prepared statement. WITH LT (COMMITED) AS ( SELECT MAX(COMMITED) FROM TRANSACTIONTIMES ) SELECT COUNT(*) FROM NAMEDGRAPHS NG,LT WHERE NG.HSTART <= LT.COMMITED AND (NG.HEND IS NULL OR NG.HEND > LT.COMMITED)

Parameters:

sqlCache - factory and cache of PreparedStatments

Returns:

Long

Throws:

AnzoException

java.sql.SQLException

prepareGetTotalNumberOfStoredNamedGraphs

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

Sets the input parameters for the getTotalNumberOfStoredNamedGraphs prepared statement.

Parameters:

ps - PreparedStatement to whose parameters are set

Throws:

java.sql.SQLException

getTotalNumberOfStoredNamedGraphsNoWith

public static java.lang.Long getTotalNumberOfStoredNamedGraphsNoWith(PreparedStatementCache sqlCache,
                                                                     NamedGraphRdbWrapper.GetTotalNumberOfStoredNamedGraphsNoWithParams params)
                                                              throws AnzoException,
                                                                     java.sql.SQLException

Runs the getTotalNumberOfStoredNamedGraphsNoWith prepared statement. SELECT COUNT(*) FROM NAMEDGRAPHS NG WHERE NG.HSTART <= ? AND (NG.HEND IS NULL OR NG.HEND > ?) ;

Parameters:

sqlCache - factory and cache of PreparedStatments

params - GetTotalNumberOfStoredNamedGraphsNoWithParams input Interface

Returns:

Long containing the results of the SQL operation

Throws:

AnzoException

java.sql.SQLException

getTotalNumberOfStoredNamedGraphsNoWith

public static java.lang.Long getTotalNumberOfStoredNamedGraphsNoWith(PreparedStatementCache sqlCache,
                                                                     java.lang.Long now,
                                                                     java.lang.Long now2)
                                                              throws AnzoException,
                                                                     java.sql.SQLException

Runs the getTotalNumberOfStoredNamedGraphsNoWith prepared statement. SELECT COUNT(*) FROM NAMEDGRAPHS NG WHERE NG.HSTART <= ? AND (NG.HEND IS NULL OR NG.HEND > ?) ;

Parameters:

sqlCache - factory and cache of PreparedStatments

now - template parameter

now2 - template parameter

Returns:

Long

Throws:

AnzoException

java.sql.SQLException

prepareGetTotalNumberOfStoredNamedGraphsNoWith

public static void prepareGetTotalNumberOfStoredNamedGraphsNoWith(java.sql.PreparedStatement ps,
                                                                  java.lang.Long now,
                                                                  java.lang.Long now2)
                                                           throws java.sql.SQLException

Sets the input parameters for the getTotalNumberOfStoredNamedGraphsNoWith prepared statement.

Parameters:

ps - PreparedStatement to whose parameters are set

now - template parameter

now2 - template parameter

Throws:

java.sql.SQLException

getAllStoredNamedGraphs

public static ClosableIterator<java.lang.String> getAllStoredNamedGraphs(PreparedStatementCache sqlCache,
                                                                         java.lang.String tableNamePrefix)
                                                                  throws AnzoException,
                                                                         java.sql.SQLException

Runs the getAllStoredNamedGraphs prepared statement with the default transformer. WITH LT (COMMITED) AS ( SELECT MAX(COMMITED) FROM TRANSACTIONTIMES ) SELECT DISTINCT ${a}_U.VALUE FROM ${a}_U WHERE ${a}_U.ID IN( SELECT NG.ID FROM NAMEDGRAPHS NG,LT WHERE NG.HSTART <= LT.COMMITED AND (NG.HEND IS NULL OR NG.HEND > LT.COMMITED) )

Parameters:

sqlCache - factory and cache of PreparedStatments

tableNamePrefix - template parameter

Returns:

org.openanzo.jdbc.utils.ClosableIterator

Throws:

AnzoException

java.sql.SQLException

getAllStoredNamedGraphs

public static ClosableIterator<java.lang.String> getAllStoredNamedGraphs(PreparedStatementCache sqlCache,
                                                                         java.lang.String tableNamePrefix,
                                                                         Transformer<java.lang.String> transform)
                                                                  throws AnzoException,
                                                                         java.sql.SQLException

Runs the getAllStoredNamedGraphs prepared statement. WITH LT (COMMITED) AS ( SELECT MAX(COMMITED) FROM TRANSACTIONTIMES ) SELECT DISTINCT ${a}_U.VALUE FROM ${a}_U WHERE ${a}_U.ID IN( SELECT NG.ID FROM NAMEDGRAPHS NG,LT WHERE NG.HSTART <= LT.COMMITED AND (NG.HEND IS NULL OR NG.HEND > LT.COMMITED) )

Parameters:

sqlCache - factory and cache of PreparedStatments

tableNamePrefix - 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

prepareGetAllStoredNamedGraphs

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

Sets the input parameters for the getAllStoredNamedGraphs prepared statement.

Parameters:

ps - PreparedStatement to whose parameters are set

Throws:

java.sql.SQLException

getAllStoredNamedGraphsNoWith

public static ClosableIterator<java.lang.String> getAllStoredNamedGraphsNoWith(PreparedStatementCache sqlCache,
                                                                               NamedGraphRdbWrapper.GetAllStoredNamedGraphsNoWithParams params,
                                                                               java.lang.String tableNamePrefix)
                                                                        throws AnzoException,
                                                                               java.sql.SQLException

Runs the getAllStoredNamedGraphsNoWith prepared statement. SELECT DISTINCT ${a}_U.VALUE FROM ${a}_U WHERE ${a}_U.ID IN( SELECT NG.ID FROM NAMEDGRAPHS NG WHERE NG.HSTART <= ? AND (NG.HEND IS NULL OR NG.HEND > ?)) ;

Parameters:

sqlCache - factory and cache of PreparedStatments

params - GetAllStoredNamedGraphsNoWithParams input Interface

tableNamePrefix - template parameter

Returns:

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

Throws:

AnzoException

java.sql.SQLException

getAllStoredNamedGraphsNoWith

public static ClosableIterator<java.lang.String> getAllStoredNamedGraphsNoWith(PreparedStatementCache sqlCache,
                                                                               java.lang.Long now,
                                                                               java.lang.Long now2,
                                                                               java.lang.String tableNamePrefix)
                                                                        throws AnzoException,
                                                                               java.sql.SQLException

Runs the getAllStoredNamedGraphsNoWith prepared statement with the default transformer. SELECT DISTINCT ${a}_U.VALUE FROM ${a}_U WHERE ${a}_U.ID IN( SELECT NG.ID FROM NAMEDGRAPHS NG WHERE NG.HSTART <= ? AND (NG.HEND IS NULL OR NG.HEND > ?)) ;

Parameters:

sqlCache - factory and cache of PreparedStatments

now - template parameter

now2 - template parameter

tableNamePrefix - template parameter

Returns:

org.openanzo.jdbc.utils.ClosableIterator

Throws:

AnzoException

java.sql.SQLException

getAllStoredNamedGraphsNoWith

public static ClosableIterator<java.lang.String> getAllStoredNamedGraphsNoWith(PreparedStatementCache sqlCache,
                                                                               java.lang.Long now,
                                                                               java.lang.Long now2,
                                                                               java.lang.String tableNamePrefix,
                                                                               Transformer<java.lang.String> transform)
                                                                        throws AnzoException,
                                                                               java.sql.SQLException

Runs the getAllStoredNamedGraphsNoWith prepared statement. SELECT DISTINCT ${a}_U.VALUE FROM ${a}_U WHERE ${a}_U.ID IN( SELECT NG.ID FROM NAMEDGRAPHS NG WHERE NG.HSTART <= ? AND (NG.HEND IS NULL OR NG.HEND > ?)) ;

Parameters:

sqlCache - factory and cache of PreparedStatments

now - template parameter

now2 - template parameter

tableNamePrefix - 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

prepareGetAllStoredNamedGraphsNoWith

public static void prepareGetAllStoredNamedGraphsNoWith(java.sql.PreparedStatement ps,
                                                        java.lang.Long now,
                                                        java.lang.Long now2)
                                                 throws java.sql.SQLException

Sets the input parameters for the getAllStoredNamedGraphsNoWith prepared statement.

Parameters:

ps - PreparedStatement to whose parameters are set

now - template parameter

now2 - template parameter

Throws:

java.sql.SQLException

getMetadatasGraphId

public static java.lang.Long getMetadatasGraphId(PreparedStatementCache sqlCache,
                                                 long metaid)
                                          throws AnzoException,
                                                 java.sql.SQLException

Runs the getMetadatasGraphId prepared statement. SELECT ID FROM NAMEDGRAPHS WHERE METAID = ? AND HEND IS NULL;

Parameters:

sqlCache - factory and cache of PreparedStatments

metaid - template parameter

Returns:

Long

Throws:

AnzoException

java.sql.SQLException

prepareGetMetadatasGraphId

public static void prepareGetMetadatasGraphId(java.sql.PreparedStatement ps,
                                              long metaid)
                                       throws java.sql.SQLException

Sets the input parameters for the getMetadatasGraphId prepared statement.

Parameters:

ps - PreparedStatement to whose parameters are set

metaid - template parameter

Throws:

java.sql.SQLException

selectNamedGraphSizeHistory

public static java.lang.Long selectNamedGraphSizeHistory(PreparedStatementCache sqlCache,
                                                         long id)
                                                  throws AnzoException,
                                                         java.sql.SQLException

Runs the selectNamedGraphSizeHistory prepared statement. WITH LT (COMMITED) AS ( SELECT MAX(COMMITED) FROM TRANSACTIONTIMES ) SELECT DISTINCT COUNT(*) FROM STATEMENTS SH,LT WHERE SH.NAMEDGRAPHID = ? AND SH.HSTART <= LT.COMMITED AND (SH.HEND IS NULL OR SH.HEND > LT.COMMITED)

Parameters:

sqlCache - factory and cache of PreparedStatments

id - template parameter

Returns:

Long

Throws:

AnzoException

java.sql.SQLException

prepareSelectNamedGraphSizeHistory

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

Sets the input parameters for the selectNamedGraphSizeHistory prepared statement.

Parameters:

ps - PreparedStatement to whose parameters are set

id - template parameter

Throws:

java.sql.SQLException

selectNamedGraphSizeHistoryNoWith

public static java.lang.Long selectNamedGraphSizeHistoryNoWith(PreparedStatementCache sqlCache,
                                                               NamedGraphRdbWrapper.SelectNamedGraphSizeHistoryNoWithParams params)
                                                        throws AnzoException,
                                                               java.sql.SQLException

Runs the selectNamedGraphSizeHistoryNoWith prepared statement. SELECT DISTINCT COUNT(*) FROM STATEMENTS SH WHERE SH.NAMEDGRAPHID = ? AND SH.HSTART <= ? AND (SH.HEND IS NULL OR SH.HEND > ?)

Parameters:

sqlCache - factory and cache of PreparedStatments

params - SelectNamedGraphSizeHistoryNoWithParams input Interface

Returns:

Long containing the results of the SQL operation

Throws:

AnzoException

java.sql.SQLException

selectNamedGraphSizeHistoryNoWith

public static java.lang.Long selectNamedGraphSizeHistoryNoWith(PreparedStatementCache sqlCache,
                                                               long id,
                                                               java.lang.Long now1,
                                                               java.lang.Long now2)
                                                        throws AnzoException,
                                                               java.sql.SQLException

Runs the selectNamedGraphSizeHistoryNoWith prepared statement. SELECT DISTINCT COUNT(*) FROM STATEMENTS SH WHERE SH.NAMEDGRAPHID = ? AND SH.HSTART <= ? AND (SH.HEND IS NULL OR SH.HEND > ?)

Parameters:

sqlCache - factory and cache of PreparedStatments

id - template parameter

now1 - template parameter

now2 - template parameter

Returns:

Long

Throws:

AnzoException

java.sql.SQLException

prepareSelectNamedGraphSizeHistoryNoWith

public static void prepareSelectNamedGraphSizeHistoryNoWith(java.sql.PreparedStatement ps,
                                                            long id,
                                                            java.lang.Long now1,
                                                            java.lang.Long now2)
                                                     throws java.sql.SQLException

Sets the input parameters for the selectNamedGraphSizeHistoryNoWith prepared statement.

Parameters:

ps - PreparedStatement to whose parameters are set

id - template parameter

now1 - template parameter

now2 - template parameter

Throws:

java.sql.SQLException

selectNamedGraphUriIds

public static ClosableIterator<java.lang.Long> selectNamedGraphUriIds(PreparedStatementCache sqlCache)
                                                               throws AnzoException,
                                                                      java.sql.SQLException

Runs the selectNamedGraphUriIds prepared statement with the default transformer. SELECT ID FROM NAMEDGRAPHS WHERE HEND IS NULL;

Parameters:

sqlCache - factory and cache of PreparedStatments

Returns:

org.openanzo.jdbc.utils.ClosableIterator

Throws:

AnzoException

java.sql.SQLException

selectNamedGraphUriIds

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

Runs the selectNamedGraphUriIds prepared statement. SELECT ID FROM NAMEDGRAPHS WHERE HEND IS NULL;

Parameters:

sqlCache - factory and cache of PreparedStatments

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

Returns:

org.openanzo.jdbc.utils.ClosableIterator

Throws:

AnzoException

java.sql.SQLException

prepareSelectNamedGraphUriIds

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

Sets the input parameters for the selectNamedGraphUriIds prepared statement.

Parameters:

ps - PreparedStatement to whose parameters are set

Throws:

java.sql.SQLException

selectNamedGraphUris

public static ClosableIterator<NamedGraphRdbWrapper.SelectNamedGraphUrisResult> selectNamedGraphUris(PreparedStatementCache sqlCache,
                                                                                                     java.lang.String tableNamePrefix)
                                                                                              throws AnzoException,
                                                                                                     java.sql.SQLException

Runs the selectNamedGraphUris prepared statement with the default transformer. SELECT DISTINCT ${a}_U.ID,${a}_U.VALUE FROM ${a}_U WHERE ${a}_U.ID IN (SELECT ID FROM NAMEDGRAPHS WHERE HEND IS NULL);

Parameters:

sqlCache - factory and cache of PreparedStatments

tableNamePrefix - template parameter

Returns:

org.openanzo.jdbc.utils.ClosableIterator

Throws:

AnzoException

java.sql.SQLException

selectNamedGraphUris

public static ClosableIterator<NamedGraphRdbWrapper.SelectNamedGraphUrisResult> selectNamedGraphUris(PreparedStatementCache sqlCache,
                                                                                                     java.lang.String tableNamePrefix,
                                                                                                     Transformer<NamedGraphRdbWrapper.SelectNamedGraphUrisResult> transform)
                                                                                              throws AnzoException,
                                                                                                     java.sql.SQLException

Runs the selectNamedGraphUris prepared statement. SELECT DISTINCT ${a}_U.ID,${a}_U.VALUE FROM ${a}_U WHERE ${a}_U.ID IN (SELECT ID FROM NAMEDGRAPHS WHERE HEND IS NULL);

Parameters:

sqlCache - factory and cache of PreparedStatments

tableNamePrefix - 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

prepareSelectNamedGraphUris

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

Sets the input parameters for the selectNamedGraphUris prepared statement.

Parameters:

ps - PreparedStatement to whose parameters are set

Throws:

java.sql.SQLException

selectMetaGraphUris

public static ClosableIterator<NamedGraphRdbWrapper.SelectMetaGraphUrisResult> selectMetaGraphUris(PreparedStatementCache sqlCache,
                                                                                                   java.lang.String tableNamePrefix)
                                                                                            throws AnzoException,
                                                                                                   java.sql.SQLException

Runs the selectMetaGraphUris prepared statement with the default transformer. SELECT DISTINCT ${a}_U.ID,${a}_U.VALUE FROM ${a}_U WHERE ${a}_U.ID IN (SELECT METAID FROM NAMEDGRAPHS WHERE HEND IS NULL);

Parameters:

sqlCache - factory and cache of PreparedStatments

tableNamePrefix - template parameter

Returns:

org.openanzo.jdbc.utils.ClosableIterator

Throws:

AnzoException

java.sql.SQLException

selectMetaGraphUris

public static ClosableIterator<NamedGraphRdbWrapper.SelectMetaGraphUrisResult> selectMetaGraphUris(PreparedStatementCache sqlCache,
                                                                                                   java.lang.String tableNamePrefix,
                                                                                                   Transformer<NamedGraphRdbWrapper.SelectMetaGraphUrisResult> transform)
                                                                                            throws AnzoException,
                                                                                                   java.sql.SQLException

Runs the selectMetaGraphUris prepared statement. SELECT DISTINCT ${a}_U.ID,${a}_U.VALUE FROM ${a}_U WHERE ${a}_U.ID IN (SELECT METAID FROM NAMEDGRAPHS WHERE HEND IS NULL);

Parameters:

sqlCache - factory and cache of PreparedStatments

tableNamePrefix - 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

prepareSelectMetaGraphUris

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

Sets the input parameters for the selectMetaGraphUris prepared statement.

Parameters:

ps - PreparedStatement to whose parameters are set

Throws:

java.sql.SQLException

insertNamedGraph

public static void insertNamedGraph(PreparedStatementCache sqlCache,
                                    NamedGraphRdbWrapper.InsertNamedGraphParams params)
                             throws AnzoException,
                                    java.sql.SQLException

Runs the insertNamedGraph prepared statement. INSERT INTO NAMEDGRAPHS (HSTART, ID, METAID,ACLID, CREATEDBY, REVISION,LASTMODIFIEDBY) VALUES (?, ?,?, ?, ?, ?,?);

Parameters:

sqlCache - factory and cache of PreparedStatments

params - InsertNamedGraphParams input Interface

Throws:

AnzoException

java.sql.SQLException

insertNamedGraph

public static void insertNamedGraph(PreparedStatementCache sqlCache,
                                    java.lang.Long modified,
                                    long namedgraphid,
                                    long metaId,
                                    long aclid,
                                    long createdBy,
                                    long revision,
                                    long lastModifiedBy)
                             throws AnzoException,
                                    java.sql.SQLException

Runs the insertNamedGraph prepared statement. INSERT INTO NAMEDGRAPHS (HSTART, ID, METAID,ACLID, CREATEDBY, REVISION,LASTMODIFIEDBY) VALUES (?, ?,?, ?, ?, ?,?);

Parameters:

sqlCache - factory and cache of PreparedStatments

modified - template parameter

namedgraphid - template parameter

metaId - template parameter

aclid - template parameter

createdBy - template parameter

revision - template parameter

lastModifiedBy - template parameter

Throws:

AnzoException

java.sql.SQLException

prepareInsertNamedGraph

public static void prepareInsertNamedGraph(java.sql.PreparedStatement ps,
                                           java.lang.Long modified,
                                           long namedgraphid,
                                           long metaId,
                                           long aclid,
                                           long createdBy,
                                           long revision,
                                           long lastModifiedBy)
                                    throws java.sql.SQLException

Sets the input parameters for the insertNamedGraph prepared statement.

Parameters:

ps - PreparedStatement to whose parameters are set

modified - template parameter

namedgraphid - template parameter

metaId - template parameter

aclid - template parameter

createdBy - template parameter

revision - template parameter

lastModifiedBy - template parameter

Throws:

java.sql.SQLException

deleteNamedGraph

public static void deleteNamedGraph(PreparedStatementCache sqlCache,
                                    NamedGraphRdbWrapper.DeleteNamedGraphParams params)
                             throws AnzoException,
                                    java.sql.SQLException

Runs the deleteNamedGraph prepared statement. UPDATE NAMEDGRAPHS SET HEND=? WHERE ID = ?;

Parameters:

sqlCache - factory and cache of PreparedStatments

params - DeleteNamedGraphParams input Interface

Throws:

AnzoException

java.sql.SQLException

deleteNamedGraph

public static void deleteNamedGraph(PreparedStatementCache sqlCache,
                                    java.lang.Long hend,
                                    long id)
                             throws AnzoException,
                                    java.sql.SQLException

Runs the deleteNamedGraph prepared statement. UPDATE NAMEDGRAPHS SET HEND=? WHERE ID = ?;

Parameters:

sqlCache - factory and cache of PreparedStatments

hend - template parameter

id - template parameter

Throws:

AnzoException

java.sql.SQLException

prepareDeleteNamedGraph

public static void prepareDeleteNamedGraph(java.sql.PreparedStatement ps,
                                           java.lang.Long hend,
                                           long id)
                                    throws java.sql.SQLException

Sets the input parameters for the deleteNamedGraph prepared statement.

Parameters:

ps - PreparedStatement to whose parameters are set

hend - template parameter

id - template parameter

Throws:

java.sql.SQLException

deleteStatementsForNamedGraph

public static void deleteStatementsForNamedGraph(PreparedStatementCache sqlCache,
                                                 NamedGraphRdbWrapper.DeleteStatementsForNamedGraphParams params)
                                          throws AnzoException,
                                                 java.sql.SQLException

Runs the deleteStatementsForNamedGraph prepared statement. UPDATE STATEMENTS SET HEND=? WHERE NAMEDGRAPHID = ?;

Parameters:

sqlCache - factory and cache of PreparedStatments

params - DeleteStatementsForNamedGraphParams input Interface

Throws:

AnzoException

java.sql.SQLException

deleteStatementsForNamedGraph

public static void deleteStatementsForNamedGraph(PreparedStatementCache sqlCache,
                                                 java.lang.Long hend,
                                                 long id)
                                          throws AnzoException,
                                                 java.sql.SQLException

Runs the deleteStatementsForNamedGraph prepared statement. UPDATE STATEMENTS SET HEND=? WHERE NAMEDGRAPHID = ?;

Parameters:

sqlCache - factory and cache of PreparedStatments

hend - template parameter

id - template parameter

Throws:

AnzoException

java.sql.SQLException

prepareDeleteStatementsForNamedGraph

public static void prepareDeleteStatementsForNamedGraph(java.sql.PreparedStatement ps,
                                                        java.lang.Long hend,
                                                        long id)
                                                 throws java.sql.SQLException

Sets the input parameters for the deleteStatementsForNamedGraph prepared statement.

Parameters:

ps - PreparedStatement to whose parameters are set

hend - template parameter

id - template parameter

Throws:

java.sql.SQLException

getNamedGraphAtRevision

public static NamedGraphRdbWrapper.GetNamedGraphAtRevisionResult getNamedGraphAtRevision(PreparedStatementCache sqlCache,
                                                                                         NamedGraphRdbWrapper.GetNamedGraphAtRevisionParams params)
                                                                                  throws AnzoException,
                                                                                         java.sql.SQLException

Runs the getNamedGraphAtRevision prepared statement. SELECT METAID,HSTART,ACLID,CREATEDBY,LASTMODIFIEDBY FROM NAMEDGRAPHS WHERE ID=? AND REVISION=?

Parameters:

sqlCache - factory and cache of PreparedStatments

params - GetNamedGraphAtRevisionParams input Interface

Returns:

GetNamedGraphAtRevisionResult containing the results of the SQL operation

Throws:

AnzoException

java.sql.SQLException

getNamedGraphAtRevision

public static NamedGraphRdbWrapper.GetNamedGraphAtRevisionResult getNamedGraphAtRevision(PreparedStatementCache sqlCache,
                                                                                         long namedGraphId,
                                                                                         long revision)
                                                                                  throws AnzoException,
                                                                                         java.sql.SQLException

Runs the getNamedGraphAtRevision prepared statement. SELECT METAID,HSTART,ACLID,CREATEDBY,LASTMODIFIEDBY FROM NAMEDGRAPHS WHERE ID=? AND REVISION=?

Parameters:

sqlCache - factory and cache of PreparedStatments

namedGraphId - template parameter

revision - template parameter

Returns:

GetNamedGraphAtRevisionResult containing the results of the SQL operation

Throws:

AnzoException

java.sql.SQLException

getNamedGraphAtRevision

public static NamedGraphRdbWrapper.GetNamedGraphAtRevisionResult getNamedGraphAtRevision(PreparedStatementCache sqlCache,
                                                                                         long namedGraphId,
                                                                                         long revision,
                                                                                         NamedGraphRdbWrapper.GetNamedGraphAtRevisionResult result)
                                                                                  throws AnzoException,
                                                                                         java.sql.SQLException

Runs the getNamedGraphAtRevision prepared statement. SELECT METAID,HSTART,ACLID,CREATEDBY,LASTMODIFIEDBY FROM NAMEDGRAPHS WHERE ID=? AND REVISION=?

Parameters:

sqlCache - factory and cache of PreparedStatments

namedGraphId - template parameter

revision - template parameter

result - GetNamedGraphAtRevisionResult result object

Returns:

GetNamedGraphAtRevisionResult

Throws:

AnzoException

java.sql.SQLException

prepareGetNamedGraphAtRevision

public static void prepareGetNamedGraphAtRevision(java.sql.PreparedStatement ps,
                                                  long namedGraphId,
                                                  long revision)
                                           throws java.sql.SQLException

Sets the input parameters for the getNamedGraphAtRevision prepared statement.

Parameters:

ps - PreparedStatement to whose parameters are set

namedGraphId - template parameter

revision - template parameter

Throws:

java.sql.SQLException

getNamedGraphCurrentRevision

public static java.lang.Long getNamedGraphCurrentRevision(PreparedStatementCache sqlCache,
                                                          long namedGraphId)
                                                   throws AnzoException,
                                                          java.sql.SQLException

Runs the getNamedGraphCurrentRevision prepared statement. SELECT REVISION FROM NAMEDGRAPHS WHERE ID=? AND HEND IS NULL;

Parameters:

sqlCache - factory and cache of PreparedStatments

namedGraphId - template parameter

Returns:

Long

Throws:

AnzoException

java.sql.SQLException

prepareGetNamedGraphCurrentRevision

public static void prepareGetNamedGraphCurrentRevision(java.sql.PreparedStatement ps,
                                                       long namedGraphId)
                                                throws java.sql.SQLException

Sets the input parameters for the getNamedGraphCurrentRevision prepared statement.

Parameters:

ps - PreparedStatement to whose parameters are set

namedGraphId - template parameter

Throws:

java.sql.SQLException

lookupNamedGraphRevision

public static void lookupNamedGraphRevision(PreparedStatementCache sqlCache,
                                            NamedGraphRdbWrapper.LookupNamedGraphRevisionParams params,
                                            java.lang.String sessionPrefix)
                                     throws AnzoException,
                                            java.sql.SQLException

Runs the lookupNamedGraphRevision prepared statement. INSERT INTO ${a}RESULTS_TMP (ID, NAMEDGRAPHID, SUBJ, PROP, OBJ) SELECT SH.ID,SH.NAMEDGRAPHID,SH.SUBJ, SH.PROP, SH.OBJ FROM STATEMENTS SH,NAMEDGRAPHS NG,ACIS WHERE NG.ID=? AND SH.NAMEDGRAPHID = ? AND SH.HSTART <= ? AND (SH.HEND IS NULL OR SH.HEND > ?) AND SH.NAMEDGRAPHID = NG.ID AND NG.HSTART <= ? AND (NG.HEND IS NULL OR NG.HEND > ?) AND NG.ACLID=ACIS.ACLID AND ACIS.HSTART <= ? AND (ACIS.HEND IS NULL OR ACIS.HEND > ?) AND ACIS.ROLEID IN(SELECT UR.ROLEID FROM USERSROLES UR WHERE UR.HSTART <= ? AND (UR.HEND IS NULL OR UR.HEND > ?) AND UR.USERID = ? ) AND ACIS.CANREAD = 1

Parameters:

sqlCache - factory and cache of PreparedStatments

params - LookupNamedGraphRevisionParams input Interface

sessionPrefix - template parameter

Throws:

AnzoException

java.sql.SQLException

lookupNamedGraphRevision

public static void lookupNamedGraphRevision(PreparedStatementCache sqlCache,
                                            long namedGraphId,
                                            long namedGraphId2,
                                            java.lang.Long start1,
                                            java.lang.Long end1,
                                            java.lang.Long start2,
                                            java.lang.Long end2,
                                            java.lang.Long start3,
                                            java.lang.Long end3,
                                            java.lang.Long start4,
                                            java.lang.Long end4,
                                            long userId,
                                            java.lang.String sessionPrefix)
                                     throws AnzoException,
                                            java.sql.SQLException

Runs the lookupNamedGraphRevision prepared statement. INSERT INTO ${a}RESULTS_TMP (ID, NAMEDGRAPHID, SUBJ, PROP, OBJ) SELECT SH.ID,SH.NAMEDGRAPHID,SH.SUBJ, SH.PROP, SH.OBJ FROM STATEMENTS SH,NAMEDGRAPHS NG,ACIS WHERE NG.ID=? AND SH.NAMEDGRAPHID = ? AND SH.HSTART <= ? AND (SH.HEND IS NULL OR SH.HEND > ?) AND SH.NAMEDGRAPHID = NG.ID AND NG.HSTART <= ? AND (NG.HEND IS NULL OR NG.HEND > ?) AND NG.ACLID=ACIS.ACLID AND ACIS.HSTART <= ? AND (ACIS.HEND IS NULL OR ACIS.HEND > ?) AND ACIS.ROLEID IN(SELECT UR.ROLEID FROM USERSROLES UR WHERE UR.HSTART <= ? AND (UR.HEND IS NULL OR UR.HEND > ?) AND UR.USERID = ? ) AND ACIS.CANREAD = 1

Parameters:

sqlCache - factory and cache of PreparedStatments

namedGraphId - template parameter

namedGraphId2 - template parameter

start1 - template parameter

end1 - template parameter

start2 - template parameter

end2 - template parameter

start3 - template parameter

end3 - template parameter

start4 - template parameter

end4 - template parameter

userId - template parameter

sessionPrefix - template parameter

Throws:

AnzoException

java.sql.SQLException

prepareLookupNamedGraphRevision

public static void prepareLookupNamedGraphRevision(java.sql.PreparedStatement ps,
                                                   long namedGraphId,
                                                   long namedGraphId2,
                                                   java.lang.Long start1,
                                                   java.lang.Long end1,
                                                   java.lang.Long start2,
                                                   java.lang.Long end2,
                                                   java.lang.Long start3,
                                                   java.lang.Long end3,
                                                   java.lang.Long start4,
                                                   java.lang.Long end4,
                                                   long userId)
                                            throws java.sql.SQLException

Sets the input parameters for the lookupNamedGraphRevision prepared statement.

Parameters:

ps - PreparedStatement to whose parameters are set

namedGraphId - template parameter

namedGraphId2 - template parameter

start1 - template parameter

end1 - template parameter

start2 - template parameter

end2 - template parameter

start3 - template parameter

end3 - template parameter

start4 - template parameter

end4 - template parameter

userId - template parameter

Throws:

java.sql.SQLException

purgeNamedGraphRevisionTmp

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

Runs the purgeNamedGraphRevisionTmp prepared statement. DELETE FROM ${a}RESULTS_TMP

Parameters:

sqlCache - factory and cache of PreparedStatments

sessionPrefix - template parameter

Returns:

int

Throws:

AnzoException

java.sql.SQLException

preparePurgeNamedGraphRevisionTmp

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

Sets the input parameters for the purgeNamedGraphRevisionTmp prepared statement.

Parameters:

ps - PreparedStatement to whose parameters are set

Throws:

java.sql.SQLException

selectNamedGraphRevision

public static ClosableIterator<NamedGraphRdbWrapper.SelectNamedGraphRevisionResult> selectNamedGraphRevision(PreparedStatementCache sqlCache,
                                                                                                             java.lang.String sessionPrefix)
                                                                                                      throws AnzoException,
                                                                                                             java.sql.SQLException

Runs the selectNamedGraphRevision prepared statement with the default transformer. SELECT ID,SUBJ,PROP,OBJ,NAMEDGRAPHID FROM ${a}RESULTS_TMP WHERE ID IS NOT NULL;

Parameters:

sqlCache - factory and cache of PreparedStatments

sessionPrefix - template parameter

Returns:

org.openanzo.jdbc.utils.ClosableIterator

Throws:

AnzoException

java.sql.SQLException

selectNamedGraphRevision

public static ClosableIterator<NamedGraphRdbWrapper.SelectNamedGraphRevisionResult> selectNamedGraphRevision(PreparedStatementCache sqlCache,
                                                                                                             java.lang.String sessionPrefix,
                                                                                                             Transformer<NamedGraphRdbWrapper.SelectNamedGraphRevisionResult> transform)
                                                                                                      throws AnzoException,
                                                                                                             java.sql.SQLException

Runs the selectNamedGraphRevision prepared statement. SELECT ID,SUBJ,PROP,OBJ,NAMEDGRAPHID FROM ${a}RESULTS_TMP WHERE ID IS NOT NULL;

Parameters:

sqlCache - factory and cache of PreparedStatments

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

prepareSelectNamedGraphRevision

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

Sets the input parameters for the selectNamedGraphRevision prepared statement.

Parameters:

ps - PreparedStatement to whose parameters are set

Throws:

java.sql.SQLException