public class PostgresSqlAction extends SqlAction.Impl
SqlAction.DeleteLog, SqlAction.IdRowMapper, SqlAction.Impl, SqlAction.LoggingSqlAction, SqlAction.StringRowMapper
Modifier and Type | Field and Description |
---|---|
static String |
insertFormatSql
Deprecated.
|
log, MAX_IN_SIZE
Constructor and Description |
---|
PostgresSqlAction(org.springframework.jdbc.core.simple.SimpleJdbcOperations jdbc) |
Modifier and Type | Method and Description |
---|---|
protected org.springframework.jdbc.core.simple.SimpleJdbcOperations |
_jdbc() |
protected String |
_lookup(String key) |
boolean |
activeSession(String sessionUUID)
Returns whether the given string is the UUID of a session that is
currently active.
|
int |
closeSessions(String uuid) |
long |
countFormat(String name) |
void |
createSavepoint(String savepoint) |
Set<String> |
currentUserNames() |
long |
currValue(String segmentName) |
String |
dbUuid() |
String |
dbVersion() |
void |
deferConstraints() |
void |
delCurrentEventLog(String key) |
Long |
findRepoImageFromPixels(long id) |
List<Long> |
findRepoPixels(String uuid,
String dirname,
String basename) |
List<Long> |
getDeletedIds(String entityType) |
List<String> |
getPixelsNamePathRepo(long id)
Retrieves the name, path and repo for the given pixels set.
|
List<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(String name)
Deprecated.
|
void |
insertLogs(List<Object[]> batchData) |
int |
insertSession(Map<String,Object> params) |
Long |
nextSessionId() |
long |
nextValue(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(String internal_uuid) |
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(String savepoint) |
int |
removePassword(Long id) |
Map<String,Object> |
repoFile(long value) |
String |
rewriteHql(String query,
String key,
Object value)
The temp_ids infrastructure was never properly put
in place for the "psql" profile.
|
List<Map<String,Object>> |
roiByImage(long imageId) |
void |
rollbackSavepoint(String savepoint) |
long |
selectCurrentEventLog(String key) |
Long |
sessionId(String uuid) |
void |
setCurrentEventLog(long id,
String key) |
void |
setFileRepo(Collection<Long> ids,
String repoId) |
void |
setPixelsNamePathRepo(long pixId,
String name,
String path,
String repoId) |
int |
synchronizeJobs(List<Long> ids) |
int |
updateConfiguration(String key,
String value) |
addMessageWithinDbPatchEnd, addMessageWithinDbPatchStart, addMimetypes, changeGroupPermissions, changeTablePermissionsForGroup, clearPermissionsBit, closeNode, closeNodeSessions, configValue, createIdsTempTable, createInsertTrigger, delConfigValue, deleteRepoDeleteLogs, fileIdsInDb, fileRepo, filterFileIdsByRepo, findRepoDeleteLogs, findRepoFile, findRepoFile, findRepoFile, findRepoFilePath, findRepoFiles, findRepoFiles, findRepoRootPath, getEventLogPartitions, getEventLogPercent, getGroupIds, getGroupPermissions, getLdapExperimenters, getPasswordHash, getShareData, getUserEmailsByGroup, getUserGroups, getUserId, getUsername, groupInfoFor, hasUnicodeUnits, isFileInRepo, isLdapExperimenter, nextPixelsDataLogForRepo, printThrowable, refreshEventLogFromUpdatedAnnotations, repoScriptCount, scriptRepo, setPermissionsBit, setStatsInfo, setUserPassword, updateOrInsertConfigValue
@Deprecated public static final String insertFormatSql
public PostgresSqlAction(org.springframework.jdbc.core.simple.SimpleJdbcOperations jdbc)
protected org.springframework.jdbc.core.simple.SimpleJdbcOperations _jdbc()
_jdbc
in class SqlAction.Impl
protected String _lookup(String key)
_lookup
in class SqlAction.Impl
public String rewriteHql(String query, String key, Object value)
rewriteHql
in interface SqlAction
rewriteHql
in class 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.public void prepareSession(long eventId, long userId, long groupId)
SqlAction
public boolean activeSession(String sessionUUID)
SqlAction
sessionUUID
- NOT NULL.true
if sessionUUID
is an active session,
false
otherwisepublic Long findRepoImageFromPixels(long id)
public Long nextSessionId()
public long countFormat(String name)
@Deprecated public int insertFormat(String name)
public int closeSessions(String uuid)
public long nodeId(String internal_uuid)
public int removePassword(Long id)
public Date now()
public String dbVersion()
public String dbUuid()
public long selectCurrentEventLog(String key)
selectCurrentEventLog
in interface SqlAction
selectCurrentEventLog
in class SqlAction.Impl
public void setCurrentEventLog(long id, String key)
setCurrentEventLog
in interface SqlAction
setCurrentEventLog
in class SqlAction.Impl
public void delCurrentEventLog(String key)
delCurrentEventLog
in interface SqlAction
delCurrentEventLog
in class SqlAction.Impl
public long nextValue(String segmentValue, int incrementSize)
SqlAction
public long currValue(String segmentName)
public void setFileRepo(Collection<Long> ids, String repoId)
public void setPixelsNamePathRepo(long pixId, String name, String path, String repoId)
public void createSavepoint(String savepoint)
public void releaseSavepoint(String savepoint)
public void rollbackSavepoint(String savepoint)
public void deferConstraints()
public List<String> getPixelsNamePathRepo(long id) throws InternalException
SqlAction
InternalException
protected void handlePotentialPgArrayJarError(org.springframework.jdbc.UncategorizedSQLException e)
Version: 5.3.5-ice35-b73
Copyright © 2017 The University of Dundee & Open Microscopy Environment. All Rights Reserved.