public class PostgresSqlAction extends SqlAction.Impl
SqlAction.DeleteLog, SqlAction.IdRowMapper, SqlAction.Impl, SqlAction.LoggingSqlAction
修飾子とタイプ | フィールドと説明 |
---|---|
static java.lang.String |
insertFormatSql |
log
コンストラクタと説明 |
---|
PostgresSqlAction(org.springframework.jdbc.core.simple.SimpleJdbcOperations jdbc) |
修飾子とタイプ | メソッドと説明 |
---|---|
protected org.springframework.jdbc.core.simple.SimpleJdbcOperations |
_jdbc() |
protected java.lang.String |
_lookup(java.lang.String key) |
boolean |
activeSession(java.lang.String sessionUUID)
Returns true if the given string is the UUID of a session that is
currently active.
|
int |
closeSessions(java.lang.String uuid) |
long |
countFormat(java.lang.String name) |
void |
createSavepoint(java.lang.String savepoint) |
java.util.Set<java.lang.String> |
currentUserNames() |
long |
currValue(java.lang.String segmentName) |
java.lang.String |
dbUuid() |
java.lang.String |
dbVersion() |
void |
deferConstraints() |
void |
delCurrentEventLog(java.lang.String key) |
java.lang.Long |
findRepoImageFromPixels(long id) |
java.util.List<java.lang.Long> |
findRepoPixels(java.lang.String uuid,
java.lang.String dirname,
java.lang.String basename) |
java.util.List<java.lang.Long> |
getDeletedIds(java.lang.String entityType) |
java.util.List<java.lang.String> |
getFileParamKeys(long id)
Returns only the (possibly empty) keys which are set on the given
original file.
|
java.util.Map<java.lang.String,java.lang.String> |
getFileParams(long id)
Loads all the (possibly empty) params for the given original file.
|
java.util.List<java.lang.String> |
getPixelsNamePathRepo(long id)
Retrieves the name, path and repo for the given pixels set.
|
java.util.List<java.lang.String> |
getPixelsParamKeys(long id)
Returns only the (possibly empty) keys which are set on the given
original file.
|
java.util.Map<java.lang.String,java.lang.String> |
getPixelsParams(long id)
Loads all the (possibly empty) params for the given original file.
|
java.util.List<java.lang.Long> |
getShapeIds(long roiId) |
protected void |
handlePotentialPgArrayJarError(org.springframework.jdbc.UncategorizedSQLException e)
If postgresql is installed with an older jdbc jar that is on the
bootstrap classpath, then it's possible that the use of pgarrays will
fail (I think).
|
int |
insertFormat(java.lang.String name) |
void |
insertLogs(java.util.List<java.lang.Object[]> batchData) |
int |
insertSession(java.util.Map<java.lang.String,java.lang.Object> params) |
java.lang.Long |
nextSessionId() |
long |
nextValue(java.lang.String segmentValue,
int incrementSize)
The implementation of this method guarantees that even if the current
transaction fails that the value found will not be used by another
transaction.
|
long |
nodeId(java.lang.String internal_uuid) |
java.util.Date |
now() |
void |
prepareSession(long eventId,
long userId,
long groupId)
Stores the current event context information in a temporary table
so that triggers can make use of them.
|
void |
releaseSavepoint(java.lang.String savepoint) |
int |
removePassword(java.lang.Long id) |
java.util.Map<java.lang.String,java.lang.Object> |
repoFile(long value) |
java.lang.String |
rewriteHql(java.lang.String query,
java.lang.String key,
java.lang.Object value)
The temp_ids infrastructure was never properly put
in place for the "psql" profile.
|
java.util.List<java.util.Map<java.lang.String,java.lang.Object>> |
roiByImageAndNs(long imageId,
java.lang.String ns) |
void |
rollbackSavepoint(java.lang.String savepoint) |
long |
selectCurrentEventLog(java.lang.String key) |
java.lang.Long |
sessionId(java.lang.String uuid) |
void |
setCurrentEventLog(long id,
java.lang.String key) |
int |
setFileParam(long id,
java.lang.String key,
java.lang.String value)
Appends "{key, value}" onto the original file "params" field or replaces
the value if already present.
|
int |
setFileParams(long id,
java.util.Map<java.lang.String,java.lang.String> params)
Resets the entire original file "params" field.
|
void |
setFileRepo(long id,
java.lang.String repoId) |
void |
setPixelsNamePathRepo(long pixId,
java.lang.String name,
java.lang.String path,
java.lang.String repoId) |
int |
setPixelsParam(long id,
java.lang.String key,
java.lang.String value)
Appends "{key, value}" onto the original file "params" field or replaces
the value if already present.
|
int |
setPixelsParams(long id,
java.util.Map<java.lang.String,java.lang.String> params)
Resets the entire original file "params" field.
|
int |
synchronizeJobs(java.util.List<java.lang.Long> ids) |
int |
updateConfiguration(java.lang.String key,
java.lang.String value) |
addChecksumAlgorithm, addMimetypes, changeGroupPermissions, changeTablePermissionsForGroup, closeNode, closeNodeSessions, configValue, createIdsTempTable, createInsertTrigger, delConfigValue, deleteRepoDeleteLogs, dnExperimenterMaps, dnForUser, fileIdsInDb, fileRepo, findRepoDeleteLogs, findRepoFile, findRepoFile, findRepoFile, findRepoFilePath, findRepoFiles, findRepoRootPath, getChecksumAlgorithmId, getEventLogPartitions, getEventLogPercent, getGroupIds, getGroupPermissions, getPasswordHash, getShareData, getUserGroups, getUserId, groupInfoFor, isFileInRepo, nextPixelsDataLogForRepo, printThrowable, repoScriptCount, scriptRepo, setStatsInfo, setUserDn, setUserPassword, updateOrInsertConfigValue
public PostgresSqlAction(org.springframework.jdbc.core.simple.SimpleJdbcOperations jdbc)
protected org.springframework.jdbc.core.simple.SimpleJdbcOperations _jdbc()
_jdbc
クラス内 SqlAction.Impl
protected java.lang.String _lookup(java.lang.String key)
_lookup
クラス内 SqlAction.Impl
public java.lang.String rewriteHql(java.lang.String query, java.lang.String key, java.lang.Object value)
rewriteHql
インタフェース内 SqlAction
rewriteHql
クラス内 SqlAction.Impl
query
- String query (non-null) which is in effect.key
- Key of the argument e.g. (:ids)value
- value which has been passed in for that parameter.3961
,
9077
public void prepareSession(long eventId, long userId, long groupId)
SqlAction
public boolean activeSession(java.lang.String sessionUUID)
SqlAction
sessionUUID
- NOT NULL.public int synchronizeJobs(java.util.List<java.lang.Long> ids)
public java.util.List<java.lang.Long> findRepoPixels(java.lang.String uuid, java.lang.String dirname, java.lang.String basename)
public java.lang.Long findRepoImageFromPixels(long id)
public java.lang.Long nextSessionId()
public java.util.Map<java.lang.String,java.lang.Object> repoFile(long value)
public long countFormat(java.lang.String name)
public int insertFormat(java.lang.String name)
public int closeSessions(java.lang.String uuid)
public long nodeId(java.lang.String internal_uuid)
public int insertSession(java.util.Map<java.lang.String,java.lang.Object> params)
public java.lang.Long sessionId(java.lang.String uuid)
public int removePassword(java.lang.Long id)
public java.util.Date now()
public int updateConfiguration(java.lang.String key, java.lang.String value)
public java.lang.String dbVersion()
public java.lang.String dbUuid()
public long selectCurrentEventLog(java.lang.String key)
selectCurrentEventLog
インタフェース内 SqlAction
selectCurrentEventLog
クラス内 SqlAction.Impl
public void setCurrentEventLog(long id, java.lang.String key)
setCurrentEventLog
インタフェース内 SqlAction
setCurrentEventLog
クラス内 SqlAction.Impl
public void delCurrentEventLog(java.lang.String key)
delCurrentEventLog
インタフェース内 SqlAction
delCurrentEventLog
クラス内 SqlAction.Impl
public long nextValue(java.lang.String segmentValue, int incrementSize)
SqlAction
ticket:3697
,
ticket:3253
public long currValue(java.lang.String segmentName)
public void insertLogs(java.util.List<java.lang.Object[]> batchData)
public java.util.List<java.util.Map<java.lang.String,java.lang.Object>> roiByImageAndNs(long imageId, java.lang.String ns)
public java.util.List<java.lang.Long> getShapeIds(long roiId)
public void setFileRepo(long id, java.lang.String repoId)
public void setPixelsNamePathRepo(long pixId, java.lang.String name, java.lang.String path, java.lang.String repoId)
public java.util.List<java.lang.Long> getDeletedIds(java.lang.String entityType)
public void createSavepoint(java.lang.String savepoint)
public void releaseSavepoint(java.lang.String savepoint)
public void rollbackSavepoint(java.lang.String savepoint)
public void deferConstraints()
public java.util.Set<java.lang.String> currentUserNames()
public int setFileParam(long id, java.lang.String key, java.lang.String value)
SqlAction
public int setFileParams(long id, java.util.Map<java.lang.String,java.lang.String> params)
SqlAction
public java.util.Map<java.lang.String,java.lang.String> getFileParams(long id) throws InternalException
SqlAction
public java.util.List<java.lang.String> getFileParamKeys(long id) throws InternalException
SqlAction
public int setPixelsParam(long id, java.lang.String key, java.lang.String value)
SqlAction
public int setPixelsParams(long id, java.util.Map<java.lang.String,java.lang.String> params)
SqlAction
public java.util.Map<java.lang.String,java.lang.String> getPixelsParams(long id) throws InternalException
SqlAction
public java.util.List<java.lang.String> getPixelsParamKeys(long id) throws InternalException
SqlAction
public java.util.List<java.lang.String> getPixelsNamePathRepo(long id) throws InternalException
SqlAction
protected void handlePotentialPgArrayJarError(org.springframework.jdbc.UncategorizedSQLException e)