public List<Long> getMediaInConversion() { final HibernateCallback<List<Long>> hcb = session -> { Query q = session.createQuery("SELECT id FROM MediaData WHERE location = 'CONVERTING'"); return q.list(); }; return getHibernateTemplate().execute(hcb); }
public void saveOrUpdateAttachments(List<AttachmentIfc> list) { for (AttachmentIfc attachment : list) { getHibernateTemplate().saveOrUpdate(attachment); } }
public List<ItemGradingData> getAllItemGradingDataForItemInGrading(final Long assesmentGradingId, final Long publishedItemId) { if (assesmentGradingId == null) { throw new IllegalArgumentException("assesmentGradingId cant' be null"); } if (publishedItemId == null) { throw new IllegalArgumentException("publishedItemId cant' be null"); } return getHibernateTemplate().execute(session -> session.createCriteria(ItemGradingData.class) .add(Restrictions.eq("assessmentGradingId", assesmentGradingId)) .add(Restrictions.eq("publishedItemId", publishedItemId)) .list()); }
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 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 ArrayList getMediaArray(ItemGradingData item) { ArrayList a = new ArrayList(); List list = getHibernateTemplate().findByNamedParam( "from MediaData m where m.itemGradingData = :id", "id", item); for (int i = 0; i < list.size(); i++) { MediaData mediaData = (MediaData) list.get(i); mediaData.setContentResource(getMediaContentResource(mediaData)); a.add(mediaData); } log.debug("*** no. of media = {}", a.size()); return a; }
public List<Long> getMediaConversionBatch() { final HibernateCallback<List<Long>> hcb = session -> { Query q = session.createQuery("SELECT id FROM MediaData WHERE dbMedia IS NOT NULL AND location IS NULL"); q.setMaxResults(10); return q.list(); }; return getHibernateTemplate().execute(hcb); }
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); }
@SuppressWarnings("unchecked") public List<AssessmentGradingData> getAllSubmissions(final String publishedId) { final HibernateCallback<List<AssessmentGradingData>> hcb = session -> { Query q = session.createQuery( "from AssessmentGradingData a where a.publishedAssessmentId = :id and a.forGrade = :forgrade"); q.setLong("id", Long.parseLong(publishedId)); q.setBoolean("forgrade", true); return q.list(); }; return getHibernateTemplate().execute(hcb); }
public boolean markMediaForConversion(final List<Long> mediaIds) { final HibernateCallback<Integer> hcb = session -> { Query q = session.createQuery("UPDATE MediaData SET location = 'CONVERTING' WHERE id in (:ids)"); q.setParameterList("ids", mediaIds); return q.executeUpdate(); }; return getHibernateTemplate().execute(hcb).equals(mediaIds.size()); }
public List<StudentGradingSummaryData> getStudentGradingSummaryData(final Long publishedAssessmentId, final String agentIdString) { final HibernateCallback<List<StudentGradingSummaryData>> hcb = session -> { Query q = session.createQuery( "select s " + "from StudentGradingSummaryData s " + "where s.publishedAssessmentId = :id and s.agentId = :agent"); q.setLong("id", publishedAssessmentId); q.setString("agent", agentIdString); return q.list(); }; return getHibernateTemplate().execute(hcb); }
public Map<Long, List<ItemGradingAttachment>> getItemGradingAttachmentMapByAssessmentGradingId(final Long assessmentGradingId) { final HibernateCallback<List<ItemGradingAttachment>> hcb = session -> { Query q = session.createQuery( "select a from ItemGradingAttachment a, ItemGradingData i " + "where a.itemGrading.itemGradingId = i.itemGradingId " + "and i.assessmentGradingId = :assessmentGradingId"); q.setLong("assessmentGradingId", assessmentGradingId); return q.list(); }; List<ItemGradingAttachment> itemGradingAttachmentList = getHibernateTemplate().execute(hcb); return processItemGradingAttachment(itemGradingAttachmentList); }
public void saveStudentGradingSummaryData(StudentGradingSummaryIfc studentGradingSummaryData) { int retryCount = persistenceHelper.getRetryCount(); while (retryCount > 0) { try { getHibernateTemplate().saveOrUpdate(studentGradingSummaryData); retryCount = 0; } catch (Exception e) { log.warn("problem saving studentGradingSummaryData: " + e.getMessage()); retryCount = persistenceHelper.retryDeadlock(e, retryCount); } } }
public Map<Long, List<ItemGradingAttachment>> getItemGradingAttachmentMap(final Set itemGradingIds) { final HibernateCallback<List<ItemGradingAttachment>> hcb = session -> { Query q = session.createQuery( "from ItemGradingAttachment a where a.itemGrading.itemGradingId in (:itemGradingIds)"); q.setParameterList("itemGradingIds", itemGradingIds); return q.list(); }; List<ItemGradingAttachment> itemGradingAttachmentList = getHibernateTemplate().execute(hcb); return processItemGradingAttachment(itemGradingAttachmentList); }
public Map<Long, List<ItemGradingAttachment>> getItemGradingAttachmentMap(final Long publishedItemId) { final HibernateCallback<List<ItemGradingAttachment>> hcb = session -> { Query q = session.createQuery( "select a from ItemGradingAttachment a where a.itemGrading.publishedItemId = :publishedItemId "); q.setLong("publishedItemId", publishedItemId); return q.list(); }; List<ItemGradingAttachment> itemGradingAttachmentList = getHibernateTemplate().execute(hcb); return processItemGradingAttachment(itemGradingAttachmentList); }
public List<AssessmentGradingData> getUnSubmittedAssessmentGradingDataList(final Long publishedAssessmentId, final String agentIdString) { final HibernateCallback<List<AssessmentGradingData>> hcb = session -> { Query q = session.createQuery( "from AssessmentGradingData a where a.publishedAssessmentId = :id and a.agentId = :agent and a.forGrade = :forgrade order by a.attemptDate desc"); q.setLong("id", publishedAssessmentId); q.setString("agent", agentIdString); q.setBoolean("forgrade", false); return q.list(); }; return getHibernateTemplate().execute(hcb); } }
public List<AssessmentGradingData> getAllAssessmentGradingByAgentId(final Long publishedAssessmentId, final String agentIdString) { final HibernateCallback<List<AssessmentGradingData>> hcb = session -> { Query q = session.createQuery( "from AssessmentGradingData a where a.publishedAssessmentId = :id and a.agentId = :agent and a.forGrade = :forgrade order by a.submittedDate desc"); q.setLong("id", publishedAssessmentId); q.setString("agent", agentIdString); q.setBoolean("forgrade", true); return q.list(); }; return getHibernateTemplate().execute(hcb); }
public List<AssessmentGradingData> getAllAssessmentGradingData(final Long publishedId) { final HibernateCallback<List<AssessmentGradingData>> hcb = session -> { Query q = session.createQuery( "from AssessmentGradingData a where a.publishedAssessmentId = :id and a.status <> :status order by a.agentId asc, a.submittedDate desc"); q.setLong("id", publishedId); q.setInteger("status", AssessmentGradingData.NO_SUBMISSION); return q.list(); }; List<AssessmentGradingData> list = getHibernateTemplate().execute(hcb); list.forEach(agd -> agd.setItemGradingSet(getItemGradingSet(agd.getAssessmentGradingId()))); return list; }
public MediaData getMedia(Long mediaId) { MediaData mediaData = (MediaData) getHibernateTemplate().load(MediaData.class, mediaId); // Only try to read from Content Hosting if this isn't a link and // there is no media content in the database if (mediaData.getLocation() == null && mediaData.getDbMedia() == null) { mediaData.setContentResource(getMediaContentResource(mediaData)); } return mediaData; }