public interface SqlAction
SimpleJdbcTemplate
and
Session.createSQLQuery(String)
for the entire OMERO
code base.修飾子とタイプ | インタフェースと説明 |
---|---|
static class |
SqlAction.DeleteLog
Record-class which matches _fs_deletelog.
|
static class |
SqlAction.IdRowMapper |
static class |
SqlAction.Impl
Base implementation which can be used
|
static class |
SqlAction.LoggingSqlAction |
修飾子とタイプ | メソッドと説明 |
---|---|
boolean |
activeSession(java.lang.String sessionUUID)
Returns true if the given string is the UUID of a session that is
currently active.
|
void |
addChecksumAlgorithm(java.lang.String name)
Add a checksum algorithm of the given name.
|
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) |
int |
closeSessions(java.lang.String uuid) |
java.lang.String |
configValue(java.lang.String name) |
long |
countFormat(java.lang.String name) |
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.
|
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() |
int |
delConfigValue(java.lang.String name) |
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 repoUuid,
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.Long |
findRepoImageFromPixels(long id) |
java.util.List<java.lang.Long> |
findRepoPixels(java.lang.String uuid,
java.lang.String dirname,
java.lang.String basename) |
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.Long> |
getDeletedIds(java.lang.String entityType) |
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.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.Map<java.lang.String,java.lang.Long> |
getGroupIds(java.util.Collection<java.lang.String> names) |
long |
getGroupPermissions(long id)
Returns the permissions for the given group id.
|
java.lang.String |
getPasswordHash(java.lang.Long experimenterID) |
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) |
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 |
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) |
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 howmany)
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. |
java.lang.Long |
nextSessionId() |
long |
nextValue(java.lang.String segmentName,
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) |
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.util.List<java.util.Map<java.lang.String,java.lang.Object>> |
roiByImageAndNs(long imageId,
java.lang.String ns) |
void |
rollbackSavepoint(java.lang.String savepoint) |
java.lang.String |
scriptRepo(long fileId,
java.util.Set<java.lang.String> mimetypes)
Similar to
fileRepo(long) , but only returns values for files
which are also scripts. |
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.
|
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 |
synchronizeJobs(java.util.List<java.lang.Long> ids) |
int |
updateConfiguration(java.lang.String key,
java.lang.String value) |
int |
updateOrInsertConfigValue(java.lang.String name,
java.lang.String value) |
void prepareSession(long eventId, long userId, long groupId)
eventId
- userId
- groupId
- java.lang.String rewriteHql(java.lang.String query, java.lang.String key, java.lang.Object value)
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
java.lang.String createIdsTempTable(java.util.Collection<java.lang.Long> ids)
void createInsertTrigger(java.lang.String name, java.lang.String table, java.lang.String procedure)
boolean activeSession(java.lang.String sessionUUID)
sessionUUID
- NOT NULL.long getGroupPermissions(long id)
ExperimenterGroup groupInfoFor(java.lang.String table, long id)
ExperimenterGroup
object containing
only the id, name, and permissions.java.lang.String fileRepo(long fileId)
java.lang.String scriptRepo(long fileId, java.util.Set<java.lang.String> mimetypes)
fileRepo(long)
, but only returns values for files
which are also scripts. Null may be returnedfileId
- mimetypes
- null implies all files are checkedint synchronizeJobs(java.util.List<java.lang.Long> ids)
java.lang.Long findRepoFile(java.lang.String uuid, java.lang.String dirname, java.lang.String basename)
#findRepoFile(String, String, String, Set)
passing null.java.lang.Long findRepoFile(java.lang.String uuid, java.lang.String dirname, java.lang.String basename, java.lang.String mimetype)
#findRepoFile(String, String, String, Set)
java.lang.Long findRepoFile(java.lang.String uuid, java.lang.String dirname, java.lang.String basename, java.util.Set<java.lang.String> mimetypes)
OriginalFile
in a given repository or
return null if none is found.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 pathmimetype
- if null, then no mimetype query fragement will be added.OriginalFile
is found, otherwise the id.java.util.List<java.lang.Long> findRepoFiles(java.lang.String repoUuid, java.lang.String dirname)
uuid
- dirname
- java.lang.Long getChecksumAlgorithmId(java.lang.String name)
name
- a namenull
if one of that name does not existvoid addChecksumAlgorithm(java.lang.String name)
name
- a namejava.util.List<SqlAction.DeleteLog> findRepoDeleteLogs(SqlAction.DeleteLog template)
SqlAction.DeleteLog
entries which match all of the non-null
fields provided in the template.template
- non-null.int deleteRepoDeleteLogs(SqlAction.DeleteLog template)
SqlAction.DeleteLog
entries which match all of the non-null
fields provided in the template.template
- not-nulljava.lang.String findRepoRootPath(java.lang.String uuid)
uuid
- a repository UUIDjava.lang.String findRepoFilePath(java.lang.String uuid, long id)
java.util.List<java.lang.Long> findRepoPixels(java.lang.String uuid, java.lang.String dirname, java.lang.String basename)
java.lang.Long findRepoImageFromPixels(long id)
int repoScriptCount(java.lang.String uuid, java.util.Set<java.lang.String> mimetypes)
uuid
- repository identifiermimetypes
- file mimetypes to check; if null, all files;java.lang.Long nextSessionId()
java.util.List<java.lang.Long> fileIdsInDb(java.lang.String uuid, java.util.Set<java.lang.String> mimetypes)
java.util.Map<java.lang.String,java.lang.Object> repoFile(long value)
java.util.List<long[]> nextPixelsDataLogForRepo(java.lang.String repo, long lastEventId, int howmany)
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.long countFormat(java.lang.String name)
int insertFormat(java.lang.String name)
int closeSessions(java.lang.String uuid)
int closeNodeSessions(java.lang.String uuid)
int closeNode(java.lang.String uuid)
long nodeId(java.lang.String internal_uuid)
int insertSession(java.util.Map<java.lang.String,java.lang.Object> params)
java.lang.Long sessionId(java.lang.String uuid)
int isFileInRepo(java.lang.String uuid, long id, java.util.Set<java.lang.String> mimetypes)
uuid
- Repository identifierid
- file identifiermimetypes
- Set of mimetypes to check; if null, all files.int removePassword(java.lang.Long id)
java.util.Date now()
int updateConfiguration(java.lang.String key, java.lang.String value)
java.lang.String dbVersion()
java.lang.String configValue(java.lang.String name)
int delConfigValue(java.lang.String name)
int updateOrInsertConfigValue(java.lang.String name, java.lang.String value)
java.lang.String dbUuid()
long selectCurrentEventLog(java.lang.String key)
float getEventLogPercent(java.lang.String key)
key
- PersistentEventLogLoader key for lookup in the configuration tablejava.util.List<java.lang.Object[]> getEventLogPartitions(java.util.Collection<java.lang.String> types, java.util.Collection<java.lang.String> actions, long offset, long limit)
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.void setCurrentEventLog(long id, java.lang.String key)
void delCurrentEventLog(java.lang.String key)
long nextValue(java.lang.String segmentName, int incrementSize)
segmentName
- incrementSize
- ticket:3697
,
ticket:3253
long currValue(java.lang.String segmentName)
void insertLogs(java.util.List<java.lang.Object[]> batchData)
java.util.List<java.util.Map<java.lang.String,java.lang.Object>> roiByImageAndNs(long imageId, java.lang.String ns)
java.util.List<java.lang.Long> getShapeIds(long roiId)
java.lang.String dnForUser(java.lang.Long id)
java.util.List<java.util.Map<java.lang.String,java.lang.Object>> dnExperimenterMaps()
void setUserDn(java.lang.Long experimenterID, java.lang.String dn)
boolean setUserPassword(java.lang.Long experimenterID, java.lang.String password)
java.lang.String getPasswordHash(java.lang.Long experimenterID)
java.lang.Long getUserId(java.lang.String userName)
java.util.Map<java.lang.String,java.lang.Long> getGroupIds(java.util.Collection<java.lang.String> names)
java.util.List<java.lang.String> getUserGroups(java.lang.String userName)
void setFileRepo(long id, java.lang.String repoId)
void setPixelsNamePathRepo(long pixId, java.lang.String name, java.lang.String path, java.lang.String repoId)
java.util.List<java.lang.Long> getDeletedIds(java.lang.String entityType)
void createSavepoint(java.lang.String savepoint)
void releaseSavepoint(java.lang.String savepoint)
void rollbackSavepoint(java.lang.String savepoint)
void deferConstraints()
java.util.Map<java.lang.Long,byte[]> getShareData(java.util.List<java.lang.Long> ids)
ids
- IDs of Shares for which data blobs are to be returned.java.util.List<java.lang.String> getPixelsParamKeys(long id) throws InternalException
java.util.Map<java.lang.String,java.lang.String> getPixelsParams(long id) throws InternalException
java.util.List<java.lang.String> getPixelsNamePathRepo(long id) throws InternalException
int setPixelsParams(long id, java.util.Map<java.lang.String,java.lang.String> params)
int setPixelsParam(long id, java.lang.String key, java.lang.String value)
java.util.List<java.lang.String> getFileParamKeys(long id) throws InternalException
java.util.Map<java.lang.String,java.lang.String> getFileParams(long id) throws InternalException
int setFileParams(long id, java.util.Map<java.lang.String,java.lang.String> params)
int setFileParam(long id, java.lang.String key, java.lang.String value)
java.util.Set<java.lang.String> currentUserNames()
int changeGroupPermissions(java.lang.Long id, java.lang.Long internal)
int changeTablePermissionsForGroup(java.lang.String table, java.lang.Long id, java.lang.Long internal)