/** * Get a list of all the pools in the site. Note that questions in each pool will not * be populated. We must keep this list updated. */ public List getAllPools() { return getHibernateTemplate().find("from QuestionPoolData"); }
/** * fetch a list of TypeD from the DB or cache (Hibernate decides) * @return a list of TypeD */ @SuppressWarnings("unchecked") private List<TypeD> getAllTypes() { return (List<TypeD>) getHibernateTemplate().find("from TypeD"); }
/** * Get a list of all the pools in the site. Note that questions in each pool will not * be populated. We must keep this list updated. */ public List getAllPools() { return getHibernateTemplate().find("from QuestionPoolData"); }
/** * This method return a list of ItemData belings to the section with the * given sectionId * * @param sectionId * @return */ private List loadAllItems(Long sectionId) { return getHibernateTemplate().find( "from ItemData i where i.section.sectionId=" + sectionId); }
/** * fetch a list of TypeD from the DB or cache (Hibernate decides) * @return a list of TypeD */ @SuppressWarnings("unchecked") private List<TypeD> getAllTypes() { return (List<TypeD>) getHibernateTemplate().find("from TypeD"); }
/** * This method return a list of ItemData belings to the section with the * given sectionId * * @param sectionId * @return */ private List loadAllItems(Long sectionId) { return getHibernateTemplate().find( "from ItemData i where i.section.sectionId=" + sectionId); }
private Locking getEntityByResourceId(final String entityName, String resourceId) { LOG.trace("getEntityByResourceId({})", entityName); List result = getHibernateTemplate().find(String.format("from %s where resourceIdentifier = '%s'", entityName, resourceId)); return (result == null || result.size() == 0) ? null : (Locking) result.get(0); }
public List list() { return getHibernateTemplate().find("from ItemData"); }
public List list() { return getHibernateTemplate().find("from ItemData"); }
public Map getQuestionPoolItemMap(){ Map h = new HashMap(); String query = "from QuestionPoolItemData"; List l = getHibernateTemplate().find(query); for (int i = 0; i < l.size(); i++) { QuestionPoolItemData q = (QuestionPoolItemData) l.get(i); h.put(q.getItemId(), q); } return h; }
public Map getQuestionPoolItemMap(){ Map h = new HashMap(); String query = "from QuestionPoolItemData"; List l = getHibernateTemplate().find(query); for (int i = 0; i < l.size(); i++) { QuestionPoolItemData q = (QuestionPoolItemData) l.get(i); h.put(q.getItemId(), q); } return h; }
public List<Locking> getInvalidLocks() { CharSequence lHqlQuery = String.format("from %s where (%s - creation) > lifetime", sEntityName, getSystemTime()); return (List<Locking>) getHibernateTemplate().find(lHqlQuery.toString(), Collections.EMPTY_LIST.toArray()); }
@Override @RequiresServiceRole(roleName = "READ") @SuppressWarnings("unchecked") public List<AnnotationData> getAllAnnotationVersions(final String id) { final ArrayList<AnnotationData> ret = new ArrayList<AnnotationData>(); for (final AnnotationHibernateModel model : (List<AnnotationHibernateModel>) hibernateTemplate.find("from AnnotationHibernateModel where key.id = ?", id)) { ret.add(model.translateToAnnotationData()); } return ret; }
public List<AssessmentFacade> getAllAssessments(String orderBy) { List<AssessmentData> list = (List<AssessmentData>) getHibernateTemplate().find("from AssessmentData a order by a." + orderBy); List<AssessmentFacade> assessmentList = new ArrayList<>(); for (AssessmentData a : list) {; assessmentList.add(new AssessmentFacade(a)); } return assessmentList; }
public List<AssessmentFacade> getAllAssessments(String orderBy) { List<AssessmentData> list = (List<AssessmentData>) getHibernateTemplate().find("from AssessmentData a order by a." + orderBy); List<AssessmentFacade> assessmentList = new ArrayList<>(); for (AssessmentData a : list) {; assessmentList.add(new AssessmentFacade(a)); } return assessmentList; }
public List<PublishedAssessmentFacade> getAllPublishedAssessments(String sortString) { String orderBy = getOrderBy(sortString); List<PublishedAssessmentData> list = (List<PublishedAssessmentData>) getHibernateTemplate().find("from PublishedAssessmentData p order by p." + orderBy); List<PublishedAssessmentFacade> assessmentList = new ArrayList<>(); for (PublishedAssessmentData a : list) { a.setSectionSet(getSectionSetForAssessment(a)); PublishedAssessmentFacade f = new PublishedAssessmentFacade(a); assessmentList.add(f); } return assessmentList; }
public List<PublishedAssessmentFacade> getAllPublishedAssessments(String sortString) { String orderBy = getOrderBy(sortString); List<PublishedAssessmentData> list = (List<PublishedAssessmentData>) getHibernateTemplate().find("from PublishedAssessmentData p order by p." + orderBy); List<PublishedAssessmentFacade> assessmentList = new ArrayList<>(); for (PublishedAssessmentData a : list) { a.setSectionSet(getSectionSetForAssessment(a)); PublishedAssessmentFacade f = new PublishedAssessmentFacade(a); assessmentList.add(f); } return assessmentList; }
public void removeAuthorizationByQualifier(String qualifierId, boolean isPublishedAssessment) { String query="select a from AuthorizationData a where a.qualifierId="+qualifierId; String clause=""; if (isPublishedAssessment){ clause = " and (a.functionId='OWN_PUBLISHED_ASSESSMENT'"+ " or a.functionId='TAKE_PUBLISHED_ASSESSMENT'"+ " or a.functionId='VIEW_PUBLISHED_ASSESSMENT_FEEDBACK'"+ " or a.functionId='GRADE_PUBLISHED_ASSESSMENT'"+ " or a.functionId='VIEW_PUBLISHED_ASSESSMENT')"; } else{ clause = " and a.functionId='EDIT_ASSESSMENT'"; } List l = getHibernateTemplate().find(query+clause); getHibernateTemplate().deleteAll(l); }
/** * Method executes a find on the pagination template. * Sub classes don't need to set max /first result this does this method. * * @param hqlqery the hqlqery. * @param params the params. * @return List. */ private List executeFind(final CharSequence hqlqery, final Collection params, final int maxresults) { if (maxresults > 0) { getHibernateTemplate().setMaxResults(maxresults); // ensure that this is the same like the expected results? getHibernateTemplate().setFetchSize(maxresults); } return getHibernateTemplate().find(hqlqery.toString(), params.toArray()); }
public void removeAuthorizationByQualifier(String qualifierId, boolean isPublishedAssessment) { String query="select a from AuthorizationData a where a.qualifierId="+qualifierId; String clause=""; if (isPublishedAssessment){ clause = " and (a.functionId='OWN_PUBLISHED_ASSESSMENT'"+ " or a.functionId='TAKE_PUBLISHED_ASSESSMENT'"+ " or a.functionId='VIEW_PUBLISHED_ASSESSMENT_FEEDBACK'"+ " or a.functionId='GRADE_PUBLISHED_ASSESSMENT'"+ " or a.functionId='VIEW_PUBLISHED_ASSESSMENT')"; } else{ clause = " and a.functionId='EDIT_ASSESSMENT'"; } List l = getHibernateTemplate().find(query+clause); getHibernateTemplate().deleteAll(l); }