Refine search
public List<AssessmentGradingData> getHighestAssessmentGradingList(final Long publishedAssessmentId) { final HibernateCallback<List<AssessmentGradingData>> hcb = session -> { Query q = session.createQuery( "from AssessmentGradingData a where a.publishedAssessmentId = :id order by a.agentId asc, a.finalScore desc"); q.setLong("id", publishedAssessmentId); return q.list(); }; List<AssessmentGradingData> assessmentGradings = getHibernateTemplate().execute(hcb); return new ArrayList<>(assessmentGradings.stream() .collect(Collectors.toMap(AssessmentGradingData::getAgentId, p -> p, (p, q) -> p)) .values()); }
public Map<Long, ItemGradingData> getItemGradingMap(final Long assessmentGradingId) { final HibernateCallback<List<ItemGradingData>> hcb = session -> { Query q = session.createQuery("from ItemGradingData i where i.assessmentGradingId = :id"); q.setLong("id", assessmentGradingId); return q.list(); }; List<ItemGradingData> itemGradingList = getHibernateTemplate().execute(hcb); return itemGradingList.stream().collect(Collectors.toMap(ItemGradingData::getItemGradingId, p -> p)); }
public Long getItemType(final Long publishedItemId) { final HibernateCallback<List<Long>> hcb = session -> session .createQuery("select p.typeId from PublishedItemData p where p.itemId = :id") .setLong("id", publishedItemId) .list(); List<Long> list = getHibernateTemplate().execute(hcb); if (!list.isEmpty()) { return list.get(0); } return null; }
public Set<Section> findInstructingSections(final String userId, final String academicSessionEid) { HibernateCallback<List<Section>> hc = session -> { Query q = session.getNamedQuery("findInstructingSectionsByAcademicSession"); q.setParameter("userId", userId); q.setParameter("academicSessionEid", academicSessionEid); return q.list(); }; return new HashSet<>(getHibernateTemplate().execute(hc)); }
public PublishedAttachmentData getPublishedAttachmentData(Long attachmentId) { final HibernateCallback<List<PublishedAttachmentData>> hcb = session -> session .createQuery("select a from PublishedAttachmentData a where a.attachmentId = :id") .setLong("id", attachmentId) .list(); List<PublishedAttachmentData> l = getHibernateTemplate().execute(hcb); if (!l.isEmpty()) { return l.get(0); } return null; }
public Integer getPublishedSectionCount(final Long publishedAssessmentId) { final HibernateCallback<List<Number>> hcb = session -> session .createQuery("select count(s) from PublishedSectionData s, PublishedAssessmentData p " + "where p.publishedAssessmentId = :id and p = s.assessment") .setLong("id", publishedAssessmentId) .list(); List<Number> list = getHibernateTemplate().execute(hcb); return list.get(0).intValue(); }
public Integer getPublishedAssessmentStatus(Long publishedAssessmentId) { final HibernateCallback<List<Integer>> hcb = session -> session .createQuery("select p.status from PublishedAssessmentData p where p.publishedAssessmentId = :id") .setLong("id", publishedAssessmentId) .list(); List<Integer> l = getHibernateTemplate().execute(hcb); if (!l.isEmpty()) { return l.get(0); } return AssessmentBaseIfc.DEAD_STATUS; }
public Set<CourseOffering> findCourseOfferings(final String courseSetEid, final String academicSessionEid) throws IdNotFoundException { HibernateCallback<List<CourseOffering>> hc = session -> { Query q = session.getNamedQuery("findCourseOfferingsByCourseSetAndAcademicSession"); q.setParameter("courseSetEid", courseSetEid); q.setParameter("academicSessionEid", academicSessionEid); return q.list(); }; return new HashSet<>(getHibernateTemplate().execute(hc)); }
public List getAllItemsIds(final Long questionPoolId) { final HibernateCallback<List> hcb = session -> { Query q = session.createQuery("select qpi.itemId from QuestionPoolItemData qpi where qpi.questionPoolId = ?"); q.setLong(0, questionPoolId.longValue()); return q.list(); }; List list = getHibernateTemplate().execute(hcb); return list; }
public boolean getHasGradingData(final Long publishedAssessmentId) { final HibernateCallback<List<AssessmentGradingData>> hcb = session -> { Query q = session.createQuery( "from AssessmentGradingData a where a.publishedAssessmentId = :id"); q.setLong("id", publishedAssessmentId); return q.list(); }; List<AssessmentGradingData> assessmentGradings = getHibernateTemplate().execute(hcb); return !assessmentGradings.isEmpty(); }
public List<Long> getItemGradingIds(final Long assessmentGradingId) { final HibernateCallback<List<Long>> hcb = session -> { Query q = session.createQuery( "select i.itemGradingId from ItemGradingData i where i.assessmentGradingId = :id"); q.setLong("id", assessmentGradingId); return q.list(); }; return getHibernateTemplate().execute(hcb); }
public List<Long> getPublishedItemIds(final Long publishedAssessmentId) { final HibernateCallback<List<Long>> hcb = session -> session .createQuery("select i.itemId from PublishedItemData i, PublishedSectionData s, PublishedAssessmentData p " + "where p.publishedAssessmentId = :id and p = s.assessment and i.section = s") .setLong("id", publishedAssessmentId) .list(); return getHibernateTemplate().execute(hcb); }
public List getAllPoolsByAgent(final String agentId) { final HibernateCallback<List> hcb = session -> { Query q = session.createQuery("from QuestionPoolData a where a.questionPoolId in (select ac.questionPoolId from QuestionPoolAccessData ac where agentId = :agent) "); q.setString("agent", agentId); return q.list(); }; List list = getHibernateTemplate().execute(hcb); return list; } /**
public List getCategories(final Long gradebookId) throws HibernateException { final HibernateCallback<List<Category>> hc = session -> session .createQuery("from Category as ca where ca.gradebook.id = :gradebookid and ca.removed is false") .setLong("gradebookid", gradebookId) .list(); return getHibernateTemplate().execute(hc); }
public List<QuestionPoolData> getAllPoolsForTransfer(final List<Long> selectedPoolIds) { final HibernateCallback<List> hcb = session -> { Query q = session.createQuery("FROM QuestionPoolData a WHERE a.questionPoolId IN (:ids)"); q. setParameterList("ids", selectedPoolIds); return q.list(); }; return getHibernateTemplate().execute(hcb); }
public List<FavoriteColChoices> getFavoriteColChoicesByAgent(final String siteAgentId) { HibernateCallback<List<FavoriteColChoices>> hcb = session -> { Query q = session.createQuery("from FavoriteColChoices as a where a.ownerStringId = :site"); q.setString("site", siteAgentId); return q.list(); }; return getHibernateTemplate().execute(hcb); } }
public List<AssessmentData> getAssessmentByTemplate(final Long templateId) { HibernateCallback<List<AssessmentData>> hcb = session -> session .createQuery("select new AssessmentData(a.assessmentBaseId, a.title, a.lastModifiedDate) " + "from AssessmentData a where a.assessmentTemplateId = :id") .setLong("id", templateId) .list(); return getHibernateTemplate().execute(hcb); }
public List getQPItems(final Long questionPoolId) { final HibernateCallback<List<ItemData>> hcb = session -> { Query q = session.createQuery("select ab from ItemData ab, QuestionPoolItem qpi where qpi.itemId=ab.itemIdString and qpi.questionPoolId = :id"); q.setLong("id", questionPoolId); return q.list(); }; return getHibernateTemplate().execute(hcb); }