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 List<PublishedAssessmentFacade> getAllPublishedAssessments(String sortString, final Integer status) { final String orderBy = getOrderBy(sortString); final HibernateCallback<List<PublishedAssessmentData>> hcb = session -> { Query q = session.createQuery("from PublishedAssessmentData as p where p.status = :status order by p." + orderBy); q.setInteger("status", status); return q.list(); }; List<PublishedAssessmentData> list = getHibernateTemplate().execute(hcb); 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, final Integer status) { final String orderBy = getOrderBy(sortString); final HibernateCallback<List<PublishedAssessmentData>> hcb = session -> { Query q = session.createQuery("from PublishedAssessmentData as p where p.status = :status order by p." + orderBy); q.setInteger("status", status); return q.list(); }; List<PublishedAssessmentData> list = getHibernateTemplate().execute(hcb); 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(int pageSize, int pageNumber, String sortString, Integer status) { String orderBy = getOrderBy(sortString); String queryString = "from PublishedAssessmentData p order by p." + orderBy; if (!status.equals(PublishedAssessmentFacade.ANY_STATUS)) { queryString = "from PublishedAssessmentData p where p.status = :status order by p." + orderBy; } PagingUtilQueriesAPI pagingUtilQueries = PersistenceService.getInstance().getPagingUtilQueries(); List<PublishedAssessmentData> pageList = pagingUtilQueries.getAll(pageSize, pageNumber, queryString, status); log.debug("**** pageList=" + pageList); List<PublishedAssessmentFacade> assessmentList = new ArrayList(); for (PublishedAssessmentData a : pageList) { a.setSectionSet(getSectionSetForAssessment(a)); log.debug("**** published assessment=" + a.getTitle()); PublishedAssessmentFacade f = new PublishedAssessmentFacade(a); log.debug("**** published assessment title=" + f.getTitle()); assessmentList.add(f); } return assessmentList; }
public PublishedAssessmentFacade getPublishedAssessment(Long assessmentId, boolean withGroupsInfo) { PublishedAssessmentData a = loadPublishedAssessment(assessmentId); a.setSectionSet(getSectionSetForAssessment(a)); // this is making things slow -pbd Map releaseToGroups = new HashMap(); if (withGroupsInfo) { //TreeMap groupsForSite = getGroupsForSite(); // SAM-799 String siteId = getPublishedAssessmentSiteId(assessmentId.toString()); Map groupsForSite = getGroupsForSite(siteId); releaseToGroups = getReleaseToGroups(groupsForSite, assessmentId); } PublishedAssessmentFacade f = new PublishedAssessmentFacade(a, releaseToGroups); return f; }
public List<PublishedAssessmentFacade> getAllPublishedAssessments(int pageSize, int pageNumber, String sortString, Integer status) { String orderBy = getOrderBy(sortString); String queryString = "from PublishedAssessmentData p order by p." + orderBy; if (!status.equals(PublishedAssessmentFacade.ANY_STATUS)) { queryString = "from PublishedAssessmentData p where p.status = :status order by p." + orderBy; } PagingUtilQueriesAPI pagingUtilQueries = PersistenceService.getInstance().getPagingUtilQueries(); List<PublishedAssessmentData> pageList = pagingUtilQueries.getAll(pageSize, pageNumber, queryString, status); log.debug("**** pageList=" + pageList); List<PublishedAssessmentFacade> assessmentList = new ArrayList(); for (PublishedAssessmentData a : pageList) { a.setSectionSet(getSectionSetForAssessment(a)); log.debug("**** published assessment=" + a.getTitle()); PublishedAssessmentFacade f = new PublishedAssessmentFacade(a); log.debug("**** published assessment title=" + f.getTitle()); assessmentList.add(f); } return assessmentList; }
public PublishedAssessmentFacade getPublishedAssessmentIdByMetaLabel(final String label, final String entry) { final HibernateCallback<List<PublishedAssessmentData>> hcb = session -> session .createQuery("select p from PublishedAssessmentData p, PublishedMetaData m where p=m.assessment and m.label = :label and m.entry = :entry") .setString("label", label) .setString("entry", entry) .list(); List<PublishedAssessmentData> l = getHibernateTemplate().execute(hcb); if (!l.isEmpty()) { PublishedAssessmentData p = l.get(0); p.setSectionSet(getSectionSetForAssessment(p)); PublishedAssessmentFacade f = new PublishedAssessmentFacade(p); f.setFeedbackComponentOption(p.getAssessmentFeedback().getFeedbackComponentOption()); return f; } return null; }
public PublishedAssessmentFacade getPublishedAssessmentIdByMetaLabel(final String label, final String entry) { final HibernateCallback<List<PublishedAssessmentData>> hcb = session -> session .createQuery("select p from PublishedAssessmentData p, PublishedMetaData m where p=m.assessment and m.label = :label and m.entry = :entry") .setString("label", label) .setString("entry", entry) .list(); List<PublishedAssessmentData> l = getHibernateTemplate().execute(hcb); if (!l.isEmpty()) { PublishedAssessmentData p = l.get(0); p.setSectionSet(getSectionSetForAssessment(p)); PublishedAssessmentFacade f = new PublishedAssessmentFacade(p); f.setFeedbackComponentOption(p.getAssessmentFeedback().getFeedbackComponentOption()); return f; } return null; }
public PublishedAssessmentFacade getPublishedAssessment(Long assessmentId, boolean withGroupsInfo) { PublishedAssessmentData a = loadPublishedAssessment(assessmentId); a.setSectionSet(getSectionSetForAssessment(a)); // this is making things slow -pbd String releaseToGroups = ""; if (withGroupsInfo) { //TreeMap groupsForSite = getGroupsForSite(); // SAM-799 String siteId = getPublishedAssessmentSiteId(assessmentId.toString()); Map groupsForSite = getGroupsForSite(siteId); releaseToGroups = getReleaseToGroupsAsString(groupsForSite, assessmentId); } PublishedAssessmentFacade f = new PublishedAssessmentFacade(a, releaseToGroups); return f; }
Set<PublishedSectionData> sectionSet = getSectionSetForAssessment(publishedAssessmentId); assessment.setSectionSet(sectionSet);
Set<PublishedSectionData> sectionSet = getSectionSetForAssessment(publishedAssessmentId); assessment.setSectionSet(sectionSet);