public void saveOrUpdateAttachments(List<AttachmentIfc> list) { for (AttachmentIfc attachment : list) { getHibernateTemplate().saveOrUpdate(attachment); } }
public void saveOrUpdateAttachments(List<AttachmentIfc> list) { for (AttachmentIfc attachment : list) { getHibernateTemplate().saveOrUpdate(attachment); } }
public PublishedAssessmentData loadPublishedAssessment(Long assessmentId) { PublishedAssessmentData ret = null; try { ret = (PublishedAssessmentData) getHibernateTemplate().load( PublishedAssessmentData.class, assessmentId); } catch (DataAccessException e) { log.warn("Error accessing Published Assesment: " + assessmentId + " storage returned: " + e); } return ret; }
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 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 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 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 Long getPublishedAssessmentId(Long assessmentId) { List<PublishedAssessmentData> list = (List<PublishedAssessmentData>) getHibernateTemplate() .findByNamedParam("from PublishedAssessmentData as p where p.assessmentId = :id order by p.createdDate desc", "id", assessmentId); Long publishedId = 0L; if (!list.isEmpty()) { PublishedAssessmentData f = list.get(0); publishedId = f.getPublishedAssessmentId(); } return publishedId; }
public String getPublishedAssessmentOwner(String publishedAssessmentId) { List<AuthorizationData> l = (List<AuthorizationData>) getHibernateTemplate() .findByNamedParam("select a from AuthorizationData a where a.functionId = :fid and a.qualifierId = :id", new String[] {"fid", "id"}, new Object[] {"OWN_PUBLISHED_ASSESSMENT", publishedAssessmentId}); if (!l.isEmpty()) { AuthorizationData a = l.get(0); return a.getAgentIdString(); } return null; }
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 Long getPublishedAssessmentId(Long assessmentId) { List<PublishedAssessmentData> list = (List<PublishedAssessmentData>) getHibernateTemplate() .findByNamedParam("from PublishedAssessmentData as p where p.assessmentId = :id order by p.createdDate desc", "id", assessmentId); Long publishedId = 0L; if (!list.isEmpty()) { PublishedAssessmentData f = list.get(0); publishedId = f.getPublishedAssessmentId(); } return publishedId; }
public List<AssessmentGradingData> getNumberOfSubmissionsOfAllAssessmentsByAgent(final String agentId) { final HibernateCallback<List<AssessmentGradingData>> hcb = session -> session.createQuery( "select new AssessmentGradingData(a.publishedAssessmentId, count(a)) " + "from AssessmentGradingData as a where a.agentId = :agent and a.forGrade= :forgrade " + "group by a.publishedAssessmentId") .setString("agent", agentId) .setBoolean("forgrade", true) .list(); return getHibernateTemplate().execute(hcb); }
public Integer getTotalSubmission(final String agentId, final Long publishedAssessmentId) { final HibernateCallback<List<Number>> hcb = session -> session .createQuery("select count(a) from AssessmentGradingData a where a.forGrade = :forgrade and a.agentId = :agent and a.publishedAssessmentId = :id") .setBoolean("forgrade", true) .setString("agent", agentId) .setLong("id", publishedAssessmentId) .list(); List<Number> l = getHibernateTemplate().execute(hcb); return l.get(0).intValue(); }
public List<AssessmentGradingData> getNumberOfSubmissionsOfAllAssessmentsByAgent(final String agentId) { final HibernateCallback<List<AssessmentGradingData>> hcb = session -> session.createQuery( "select new AssessmentGradingData(a.publishedAssessmentId, count(a)) " + "from AssessmentGradingData as a where a.agentId = :agent and a.forGrade= :forgrade " + "group by a.publishedAssessmentId") .setString("agent", agentId) .setBoolean("forgrade", true) .list(); return getHibernateTemplate().execute(hcb); }
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 saveOrUpdatePublishedAccessControl(AssessmentAccessControlIfc publishedAccessControl) { int retryCount = PersistenceService.getInstance().getPersistenceHelper().getRetryCount(); while (retryCount > 0) { try { getHibernateTemplate().saveOrUpdate(publishedAccessControl); retryCount = 0; } catch (Exception e) { log.warn("problem save or update publishedAccessControl data: {}", e.getMessage()); retryCount = PersistenceService.getInstance().getPersistenceHelper().retryDeadlock(e, retryCount); } } }
public void saveOrUpdateSection(SectionFacade section) { int retryCount = PersistenceService.getInstance().getPersistenceHelper().getRetryCount(); while (retryCount > 0) { try { getHibernateTemplate().saveOrUpdate(section.getData()); retryCount = 0; } catch (Exception e) { log.warn("problem save or update section: " + e.getMessage()); retryCount = PersistenceService.getInstance().getPersistenceHelper().retryDeadlock(e, retryCount); } } }
public void saveOrUpdateSection(SectionFacade section) { int retryCount = PersistenceService.getInstance().getPersistenceHelper().getRetryCount(); while (retryCount > 0) { try { getHibernateTemplate().saveOrUpdate(section.getData()); retryCount = 0; } catch (Exception e) { log.warn("problem save or update section: " + e.getMessage()); retryCount = PersistenceService.getInstance().getPersistenceHelper().retryDeadlock(e, retryCount); } } }
public PublishedAssessmentFacade getPublishedAssessmentInfoForRemove(Long publishedAssessmentId) { PublishedAssessmentData a = getHibernateTemplate().load(PublishedAssessmentData.class, publishedAssessmentId); PublishedAssessmentFacade f = new PublishedAssessmentFacade(a.getAssessmentId(), a.getTitle(), a.getCreatedBy()); return f; }
public PublishedAssessmentFacade getPublishedAssessmentInfoForRemove(Long publishedAssessmentId) { PublishedAssessmentData a = getHibernateTemplate().load(PublishedAssessmentData.class, publishedAssessmentId); PublishedAssessmentFacade f = new PublishedAssessmentFacade(a.getAssessmentId(), a.getTitle(), a.getCreatedBy()); return f; }