@Override @RolesAllowed("user") public List<IObject> retrieveAllRndSettings(long pixId, long userId) { Parameters params = new Parameters(); params.addLong("p_id", pixId); String restriction = "rdef.pixels.id = :p_id "; if (userId >= 0) { restriction += "and rdef.details.owner.id = :o_id "; params.addLong("o_id", userId); } List<IObject> l = iQuery.findAllByQuery( RENDERING_DEF_QUERY_PREFIX +restriction + "order by rdef.details.updateEvent.time desc", params); return l; }
private GroupExperimenterMap findLink(ExperimenterGroup group, Experimenter owner) { GroupExperimenterMap m = iQuery.findByQuery( "select m from GroupExperimenterMap m " + "where m.parent.id = :pid " + "and m.child.id = :cid", new Parameters() .addLong("pid", group.getId()) .addLong("cid", owner.getId())); return m; }
/** * Returns a boolean based on the supplied user ID and system property setting. * Returns {@code false} for the guest user, {@code true} for administrators, * otherwise matches the setting of {@code omero.security.password_required}. * * @param id The user ID. * @return boolean <code>true</code> or <code>false</code> */ public boolean isPasswordRequired(Long id) { if (id == null) { return passwordRequired; } else if (id == roles.getGuestId()) { return false; } else if (!(passwordRequired || iQuery == null)) { /* require passwords for administrators */ final String hql = "FROM GroupExperimenterMap WHERE parent.id = :group AND child.id = :user"; final Parameters params = new Parameters().addLong("group", roles.getSystemGroupId()).addLong("user", id); return iQuery.findByQuery(hql, params) != null; } else { return passwordRequired; } } }
/** * Load all scripts that match the name, hash, and format for script */ protected List<OriginalFile> loadScripts(ServiceFactory sf, Parameters p) { p.addLong("gid", roles.getUserGroupId()); List<OriginalFile> files = sf.getQueryService().findAllByQuery( "select f from OriginalFile f where f.hash = :hash " + "and f.details.group.id = :gid " + "and f.name = :name " + "and f.mimetype = 'text/x-python'", p); return files; }
if (po.getExperimenter() != null) { sb.append(" and ann.details.owner.id = :userId"); param.addLong("userId", po.getExperimenter());
params.addLong("instrumentId", id); List<String> names = new ArrayList<String>(); String name;
@Transactional(readOnly = true) public Object doWork(Session session, ServiceFactory sf) { Parameters p = new Parameters(); p.page(0, 1); p.addLong("id", scriptId); return sf .getQueryService() .findByQuery( "select job from ParseJob job " + "join job.originalFileLinks scriptlinks " + "join scriptlinks.child script " + "where job.params is not null " + "and script.id = :id " + "and script.details.updateEvent.id <= job.details.updateEvent.id " + "order by job.details.updateEvent.id desc", p); }
public void runAsAdmin() { String dsQuery; if (force) { dsQuery = dsNotOwnQuery; p.addLong("owner", iAdmin.getEventContext().getCurrentUserId()); } else { dsQuery = dsAllQuery; } rv.addAll(iQuery.findAllByQuery(dsQuery, p)); // TODO What about categories of other users? }
final String membershipQuery = "SELECT id FROM GroupExperimenterMap WHERE parent.id = :group AND child.id = :user"; boolean hasAdminPrivileges = CollectionUtils.isNotEmpty(executeProjection(membershipQuery, new Parameters().addLong("group", roles.getSystemGroupId()).addLong("user", session.getOwner().getId()))); if (session.getSudoer() != null) { hasAdminPrivileges = hasAdminPrivileges && CollectionUtils.isNotEmpty(executeProjection(membershipQuery, new Parameters().addLong("group", roles.getSystemGroupId()).addLong("user", session.getSudoer().getId()))); sessionQuery.append("SELECT id, uuid FROM Session WHERE closed IS NULL"); sessionQuery.append(" AND owner.id = :owner"); params.addLong("owner", session.getOwner().getId()); if (!privileges.contains(adminPrivileges.getPrivilege(AdminPrivilege.VALUE_READ_SESSION))) { } else { sessionQuery.append(" AND sudoer.id = :sudoer"); params.addLong("sudoer", session.getSudoer().getId());
IObject o; Parameters param = new Parameters(); param.addLong("userID", userID); List<IObject> l; StringBuffer sb = new StringBuffer();
p.addLong("active", helper.getServiceFactory().getAdminService() .getSecurityRoles().getUserGroupId());
Roles roles = getRoles(); p.addString("systemGroup", roles.getSystemGroupName()); p.addLong("systemGroupId", roles.getSystemGroupId()); p.addString("userGroup", roles.getUserGroupName()); p.addLong("userGroupId", roles.getUserGroupId()); p.addString("rootUser", roles.getRootName()); p.addLong("rootUserId", roles.getRootId());
params.addInteger("x", (int) dimensions.getWidth()); params.addInteger("y", (int) dimensions.getHeight()); params.addLong("o_id", userId); params.addIds(pixelsIds); StopWatch s1 = new Slf4JStopWatch("omero.bulkLoadMetadata");
/** * Retrieves all thumbnail metadata available in the database for a given * Pixels ID. * @param pixelsId Pixels ID to retrieve thumbnail metadata for. * @return See above. */ public List<Thumbnail> loadAllMetadata(long pixelsId) { Parameters params = new Parameters(); params.addId(pixelsId); params.addLong("o_id", userId); StopWatch s1 = new Slf4JStopWatch("omero.loadAllMetadata"); List<Thumbnail> toReturn = queryService.findAllByQuery( "select t from Thumbnail as t " + "join t.pixels p " + "join fetch t.details.updateEvent " + "where t.details.owner.id = :o_id " + "and p.id = :id", params); if (toReturn.isEmpty()) { toReturn = queryService.findAllByQuery( "select t from Thumbnail as t " + "join t.pixels p " + "join fetch t.details.updateEvent " + "where t.details.owner.id = p.details.owner.id " + "and p.id = :id", params); } s1.stop(); return toReturn; }
params.addLong("o_id", sec.getEffectiveUID()); if (settings != null || iQuery.findByQuery(