public abstract static class SqlAction.Impl extends java.lang.Object implements SqlAction
SqlAction.DeleteLog, SqlAction.IdRowMapper, SqlAction.Impl, SqlAction.LoggingSqlAction
修飾子とタイプ | フィールドと説明 |
---|---|
protected org.slf4j.Logger |
log |
コンストラクタと説明 |
---|
SqlAction.Impl() |
修飾子とタイプ | メソッドと説明 |
---|---|
protected abstract org.springframework.jdbc.core.simple.SimpleJdbcOperations |
_jdbc() |
protected abstract java.lang.String |
_lookup(java.lang.String key) |
void |
addChecksumAlgorithm(java.lang.String name)
Add a checksum algorithm of the given name.
|
protected java.lang.String |
addMimetypes(java.util.Collection<java.lang.String> mimetypes,
java.util.Map<java.lang.String,java.lang.Object> params)
Returns the "and_mimetype" clause which must be appended to a given
query.
|
int |
changeGroupPermissions(java.lang.Long id,
java.lang.Long internal) |
int |
changeTablePermissionsForGroup(java.lang.String table,
java.lang.Long id,
java.lang.Long internal) |
int |
closeNode(java.lang.String uuid) |
int |
closeNodeSessions(java.lang.String uuid) |
java.lang.String |
configValue(java.lang.String key) |
java.lang.String |
createIdsTempTable(java.util.Collection<java.lang.Long> ids)
Creates a temporary table filled with the given ids and returns its
name.
|
void |
createInsertTrigger(java.lang.String name,
java.lang.String table,
java.lang.String procedure)
Creates an insert trigger of the given name, for the given table,
with the given procedure.
|
int |
delConfigValue(java.lang.String key) |
void |
delCurrentEventLog(java.lang.String key) |
int |
deleteRepoDeleteLogs(SqlAction.DeleteLog template)
Delete all
SqlAction.DeleteLog entries which match all of the non-null
fields provided in the template. |
java.util.List<java.util.Map<java.lang.String,java.lang.Object>> |
dnExperimenterMaps() |
java.lang.String |
dnForUser(java.lang.Long id) |
java.util.List<java.lang.Long> |
fileIdsInDb(java.lang.String uuid,
java.util.Set<java.lang.String> mimetypes)
Return all IDs matching the given mimetypes, or all IDs if mimetypes is null.
|
java.lang.String |
fileRepo(long fileId) |
java.util.List<SqlAction.DeleteLog> |
findRepoDeleteLogs(SqlAction.DeleteLog template)
Find all
SqlAction.DeleteLog entries which match all of the non-null
fields provided in the template. |
java.lang.Long |
findRepoFile(java.lang.String uuid,
java.lang.String dirname,
java.lang.String basename)
Calls
#findRepoFile(String, String, String, Set
passing null. |
java.lang.Long |
findRepoFile(java.lang.String uuid,
java.lang.String dirname,
java.lang.String basename,
java.util.Set<java.lang.String> mimetypes)
Lookup the id of an
OriginalFile in a given repository or
return null if none is found. |
java.lang.Long |
findRepoFile(java.lang.String uuid,
java.lang.String dirname,
java.lang.String basename,
java.lang.String mimetype)
Calls
#findRepoFile(String, String, String, Set |
java.lang.String |
findRepoFilePath(java.lang.String uuid,
long id) |
java.util.List<java.lang.Long> |
findRepoFiles(java.lang.String uuid,
java.lang.String dirname)
Return a list of original file ids that all have a path value matching
the passed dirname in the given repository.
|
java.lang.String |
findRepoRootPath(java.lang.String uuid)
Find the path of the repository root.
|
java.lang.Long |
getChecksumAlgorithmId(java.lang.String name)
Get the ID of the checksum algorithm of the given name.
|
java.util.List<java.lang.Object[]> |
getEventLogPartitions(java.util.Collection<java.lang.String> types,
java.util.Collection<java.lang.String> actions,
long offset,
long limit)
Loads up to "limit" event logs using partioning so that only the
last event log of a particular (type, id) pair is returned.
|
float |
getEventLogPercent(java.lang.String key)
Returns the percent (e.g. 0-100%) as calculated by the number of rows
represented as completed by the configuration table row of this key
divided by the total number of rows in the event log.
|
java.util.Map<java.lang.String,java.lang.Long> |
getGroupIds(java.util.Collection<java.lang.String> names) |
long |
getGroupPermissions(long groupId)
Returns the permissions for the given group id.
|
java.lang.String |
getPasswordHash(java.lang.Long experimenterID) |
java.util.Map<java.lang.Long,byte[]> |
getShareData(java.util.List<java.lang.Long> ids)
Returns a map of Share ID to Share data blob.
|
java.util.List<java.lang.String> |
getUserGroups(java.lang.String userName) |
java.lang.Long |
getUserId(java.lang.String userName) |
ExperimenterGroup |
groupInfoFor(java.lang.String table,
long id)
Return a mostly unloaded
ExperimenterGroup object containing
only the id, name, and permissions. |
int |
isFileInRepo(java.lang.String uuid,
long id,
java.util.Set<java.lang.String> mimetypes) |
java.util.List<long[]> |
nextPixelsDataLogForRepo(java.lang.String repo,
long lastEventId,
int rows)
Returns arrays of longs for the following SQL return values:
experimenter, eventlog, entityid as pixels, rownumber
The oldest N eventlogs with action = "PIXELDATA" and entitytype = "ome.model.core.Pixels"
is found per user and returned. |
protected java.lang.String |
printThrowable(java.lang.Throwable t) |
int |
repoScriptCount(java.lang.String uuid,
java.util.Set<java.lang.String> mimetypes) |
java.lang.String |
rewriteHql(java.lang.String query,
java.lang.String key,
java.lang.Object value)
Allows the specific database implementations a chance to modify
queries.
|
java.lang.String |
scriptRepo(long fileId,
java.util.Set<java.lang.String> mimetypes)
Similar to
SqlAction.fileRepo(long) , but only returns values for files
which are also scripts. |
long |
selectCurrentEventLog(java.lang.String key) |
void |
setCurrentEventLog(long id,
java.lang.String key) |
long |
setStatsInfo(Channel ch,
StatsInfo si) |
void |
setUserDn(java.lang.Long experimenterID,
java.lang.String dn) |
boolean |
setUserPassword(java.lang.Long experimenterID,
java.lang.String password) |
int |
updateOrInsertConfigValue(java.lang.String name,
java.lang.String value) |
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait
activeSession, closeSessions, countFormat, createSavepoint, currentUserNames, currValue, dbUuid, dbVersion, deferConstraints, findRepoImageFromPixels, findRepoPixels, getDeletedIds, getFileParamKeys, getFileParams, getPixelsNamePathRepo, getPixelsParamKeys, getPixelsParams, getShapeIds, insertFormat, insertLogs, insertSession, nextSessionId, nextValue, nodeId, now, prepareSession, releaseSavepoint, removePassword, repoFile, roiByImageAndNs, rollbackSavepoint, sessionId, setFileParam, setFileParams, setFileRepo, setPixelsNamePathRepo, setPixelsParam, setPixelsParams, synchronizeJobs, updateConfiguration
protected abstract org.springframework.jdbc.core.simple.SimpleJdbcOperations _jdbc()
protected abstract java.lang.String _lookup(java.lang.String key)
protected java.lang.String printThrowable(java.lang.Throwable t)
public void createInsertTrigger(java.lang.String name, java.lang.String table, java.lang.String procedure)
SqlAction
createInsertTrigger
インタフェース内 SqlAction
public java.lang.String rewriteHql(java.lang.String query, java.lang.String key, java.lang.Object value)
SqlAction
rewriteHql
インタフェース内 SqlAction
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.ticket:3961
public java.lang.String createIdsTempTable(java.util.Collection<java.lang.Long> ids)
SqlAction
createIdsTempTable
インタフェース内 SqlAction
public int closeNodeSessions(java.lang.String uuid)
closeNodeSessions
インタフェース内 SqlAction
public boolean setUserPassword(java.lang.Long experimenterID, java.lang.String password)
setUserPassword
インタフェース内 SqlAction
public int changeGroupPermissions(java.lang.Long id, java.lang.Long internal)
changeGroupPermissions
インタフェース内 SqlAction
public int changeTablePermissionsForGroup(java.lang.String table, java.lang.Long id, java.lang.Long internal)
changeTablePermissionsForGroup
インタフェース内 SqlAction
protected java.lang.String addMimetypes(java.util.Collection<java.lang.String> mimetypes, java.util.Map<java.lang.String,java.lang.Object> params)
mimetypes
- If null, then "" will be returned.params
- sql parameter source to be passed to JDBC methods.public java.lang.Long findRepoFile(java.lang.String uuid, java.lang.String dirname, java.lang.String basename)
SqlAction
#findRepoFile(String, String, String, Set)
passing null.findRepoFile
インタフェース内 SqlAction
public java.lang.Long findRepoFile(java.lang.String uuid, java.lang.String dirname, java.lang.String basename, java.lang.String mimetype)
SqlAction
#findRepoFile(String, String, String, Set)
findRepoFile
インタフェース内 SqlAction
public java.lang.Long findRepoFile(java.lang.String uuid, java.lang.String dirname, java.lang.String basename, java.util.Set<java.lang.String> mimetypes)
SqlAction
OriginalFile
in a given repository or
return null if none is found.findRepoFile
インタフェース内 SqlAction
uuid
- The UUID of the repository (originalfile.sha1)dirname
- the full directory path minus the file name.basename
- i.e. the filename without any directory pathOriginalFile
is found, otherwise the id.public int repoScriptCount(java.lang.String uuid, java.util.Set<java.lang.String> mimetypes)
repoScriptCount
インタフェース内 SqlAction
uuid
- repository identifiermimetypes
- file mimetypes to check; if null, all files;public int isFileInRepo(java.lang.String uuid, long id, java.util.Set<java.lang.String> mimetypes)
isFileInRepo
インタフェース内 SqlAction
uuid
- Repository identifierid
- file identifiermimetypes
- Set of mimetypes to check; if null, all files.public java.util.List<java.lang.Long> fileIdsInDb(java.lang.String uuid, java.util.Set<java.lang.String> mimetypes)
SqlAction
fileIdsInDb
インタフェース内 SqlAction
public java.util.List<java.lang.Long> findRepoFiles(java.lang.String uuid, java.lang.String dirname)
SqlAction
findRepoFiles
インタフェース内 SqlAction
public java.util.List<SqlAction.DeleteLog> findRepoDeleteLogs(SqlAction.DeleteLog template)
SqlAction
SqlAction.DeleteLog
entries which match all of the non-null
fields provided in the template.findRepoDeleteLogs
インタフェース内 SqlAction
template
- non-null.public int deleteRepoDeleteLogs(SqlAction.DeleteLog template)
SqlAction
SqlAction.DeleteLog
entries which match all of the non-null
fields provided in the template.deleteRepoDeleteLogs
インタフェース内 SqlAction
template
- not-nullpublic java.lang.String findRepoRootPath(java.lang.String uuid)
SqlAction
findRepoRootPath
インタフェース内 SqlAction
uuid
- a repository UUIDpublic java.lang.String findRepoFilePath(java.lang.String uuid, long id)
findRepoFilePath
インタフェース内 SqlAction
public java.util.List<long[]> nextPixelsDataLogForRepo(java.lang.String repo, long lastEventId, int rows)
SqlAction
experimenter, eventlog, entityid as pixels, rownumber
The oldest N eventlogs with action = "PIXELDATA" and entitytype = "ome.model.core.Pixels"
is found per user and returned. Multiple eventlogs are returned
per user in order to support multi-threading. Duplicate pixel ids
are stripped.nextPixelsDataLogForRepo
インタフェース内 SqlAction
public long getGroupPermissions(long groupId)
SqlAction
getGroupPermissions
インタフェース内 SqlAction
public java.util.Map<java.lang.String,java.lang.Long> getGroupIds(java.util.Collection<java.lang.String> names)
getGroupIds
インタフェース内 SqlAction
public java.lang.String getPasswordHash(java.lang.Long experimenterID)
getPasswordHash
インタフェース内 SqlAction
public java.lang.Long getUserId(java.lang.String userName)
public java.util.List<java.lang.String> getUserGroups(java.lang.String userName)
getUserGroups
インタフェース内 SqlAction
public ExperimenterGroup groupInfoFor(java.lang.String table, long id)
SqlAction
ExperimenterGroup
object containing
only the id, name, and permissions.groupInfoFor
インタフェース内 SqlAction
public java.lang.String scriptRepo(long fileId, java.util.Set<java.lang.String> mimetypes)
SqlAction
SqlAction.fileRepo(long)
, but only returns values for files
which are also scripts. Null may be returnedscriptRepo
インタフェース内 SqlAction
mimetypes
- null implies all files are checkedpublic long setStatsInfo(Channel ch, StatsInfo si)
setStatsInfo
インタフェース内 SqlAction
public java.lang.String configValue(java.lang.String key)
configValue
インタフェース内 SqlAction
public int delConfigValue(java.lang.String key)
delConfigValue
インタフェース内 SqlAction
public int updateOrInsertConfigValue(java.lang.String name, java.lang.String value)
updateOrInsertConfigValue
インタフェース内 SqlAction
public long selectCurrentEventLog(java.lang.String key)
selectCurrentEventLog
インタフェース内 SqlAction
public float getEventLogPercent(java.lang.String key)
SqlAction
getEventLogPercent
インタフェース内 SqlAction
key
- PersistentEventLogLoader key for lookup in the configuration tablepublic java.util.List<java.lang.Object[]> getEventLogPartitions(java.util.Collection<java.lang.String> types, java.util.Collection<java.lang.String> actions, long offset, long limit)
SqlAction
getEventLogPartitions
インタフェース内 SqlAction
types
- Collection of entityType strings which should be queriedactions
- Collection of ACTION strings which should be queriedoffset
- Offset to the row which should be queried firstlimit
- Maximum number of rows (after partionting) which should
be returned.public void setCurrentEventLog(long id, java.lang.String key)
setCurrentEventLog
インタフェース内 SqlAction
public void delCurrentEventLog(java.lang.String key)
delCurrentEventLog
インタフェース内 SqlAction
public java.util.List<java.util.Map<java.lang.String,java.lang.Object>> dnExperimenterMaps()
dnExperimenterMaps
インタフェース内 SqlAction
public void setUserDn(java.lang.Long experimenterID, java.lang.String dn)
public java.util.Map<java.lang.Long,byte[]> getShareData(java.util.List<java.lang.Long> ids)
SqlAction
getShareData
インタフェース内 SqlAction
ids
- IDs of Shares for which data blobs are to be returned.public java.lang.Long getChecksumAlgorithmId(java.lang.String name)
SqlAction
getChecksumAlgorithmId
インタフェース内 SqlAction
name
- a namenull
if one of that name does not existpublic void addChecksumAlgorithm(java.lang.String name)
SqlAction
addChecksumAlgorithm
インタフェース内 SqlAction
name
- a name