@Transactional(readOnly = true) public Object doWork(Session session, ServiceFactory sf) { return sf.getQueryService().findByQuery( "select o from OriginalFile o " + "where o.id = " + id, null); } });
public final EventLog lastEventLog() { return queryService.findByQuery( "select el from EventLog el order by id desc", new Parameters().page(0, 1)); }
public Pixels getPixels() { return sf.getQueryService().findByQuery("select p from Dataset d " + "join d.imageLinks dil " + "join dil.child img " + "join img.pixels p where d.id = "+d.getId(), null); } }
@Transactional(readOnly = true) public Object doWork(Session session, ServiceFactory sf) { return sf.getQueryService().findByQuery( LOAD_ORIGINAL_FILE+" f.id = :id", new Parameters().addId(repoId)); } });
@Transactional(readOnly = true) public Object doWork(Session session, ServiceFactory sf) { Parameters p = new Parameters().addString("uuid", uuid); Node node = sf.getQueryService().findByQuery(query, p); if (node == null) { return null; } else { return node.getConn(); } } });
@Transactional(readOnly = true) public Object doWork(Session session, ServiceFactory sf) { final ExperimenterGroup group = sf.getQueryService().findByQuery( "select p.details.group from Pixels p where p.id = :id", new ome.parameters.Parameters().addId(mpm.pixelsID)); return group.getId(); } });
protected Pixels getPixels(Long id, ServiceFactory sf) { final IQuery iQuery = sf.getQueryService(); final Pixels pixels = iQuery.findByQuery( "select p from Pixels as p " + "left outer join fetch p.channels ch " + // For statsinfo "join fetch p.pixelsType where p.id = :id ", new Parameters().addId(id)); return pixels; }
@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); }
ByteArrayInputStream s = new ByteArrayInputStream(bytes); IQuery query = sf.getQueryService(); IObject o = query.findByQuery("from Image as i left outer join " + "fetch i.pixels as p where i.id = "+imageId, null);
/** * Returns the {@link EventLog} with the next id after the given argument or * null if none exists. This method will only return "true" {@link EventLog} * instances, with a valid id. */ public final EventLog nextEventLog(long id) { if (query == null) { initQueryString(); } Parameters params = new Parameters().page(0, 1).addId(id); return queryService.findByQuery(query, params); }
@Transactional(readOnly=true) public Object doWork(org.hibernate.Session session, ServiceFactory sf) { return sf.getQueryService().findByQuery( stdfile_query, new Parameters().addId(job.getId().getValue()) .addString("name", name)); } });
@Override protected EventLog query() { if (current == null) { if (more() == 0) { return null; } current = classes.remove(0); } final String query = String.format( "select obj from %s obj where obj.id > %d order by id asc", current, last); final IObject obj = queryService.findByQuery(query, new Parameters().page(0, 1)); if (obj != null) { last = obj.getId(); // Here we pass the string to prevent $$ CGLIB style issues return wrap(current, obj); } else { // If no object, then reset and recurse. current = null; last = -1; return query(); } }
public Node getManagerByUuid(final String managerUuid, ServiceFactory sf) { Parameters p = new Parameters(); p.addString("uuid", managerUuid).setFilter( new Filter().page(0, 1)); return (Node) sf.getQueryService().findByQuery( "select n from Node n where uuid = :uuid", p); };
/** * 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; } } }
/** * Finds the image matching the criteria. * @param pixelsId The pixels set ID. * @return The image Id or -1. */ private long getImage(long pixelsId) { Pixels pixels = service.findByQuery(query, new Parameters().addId(pixelsId)); if (pixels == null) { return -1; } Image image = pixels.getImage(); if (checkEmptyFile) { return image.getId().longValue(); } long creation = image.getDetails().getCreationEvent().getTime().getTime(); long time = -1; if (importedAfter != null) { time = importedAfter.getValue(); } if (time < creation) { if (littleEndian == null || isLittleEndian(pixels) == littleEndian.getValue()) { return image.getId().longValue(); } } return -1; }
/** * Load the {@link Fileset} for the imageId if it exists. */ private void findFileset() { try { IQuery query = helper.getServiceFactory().getQueryService(); Fileset fs = query.findByQuery( "select fs from Image i join i.fileset fs " + "where i.id = :id", new Parameters().addId(imageId)); if (fs != null) { rsp.filesetId = rlong(fs.getId()); } } catch (RootException re) { throw helper.cancel(new ERR(), re, "fileset-load-err", "image-id", "" + imageId); } }
protected Session updateSession() { Session s = helper.getServiceFactory().getQueryService() .findByQuery("select s from Session s where s.uuid = :uuid", new Parameters().addString("uuid", session)); if (s == null) { // we assume that if the session is visible, then // the current user should be able to edit it. throw helper.cancel(new ERR(), null, "no-session"); } boolean isAdmin = current.getCurrentEventContext().isCurrentUserAdmin(); updated |= updateField(s, Session.TIMETOLIVE, timeToLive, isAdmin); updated |= updateField(s, Session.TIMETOIDLE, timeToIdle, isAdmin); if (updated) { security.runAsAdmin(new AdminAction(){ @Override public void runAsAdmin() { update.flush(); }}); return s; } else { throw helper.cancel(new ERR(), null, "no-update-performed", "session", session); } }