@Override public void markExpiredAccessors() { getHibernateTemplate().execute(session -> { session.createQuery( "UPDATE Accessor a SET a.status=? WHERE a.expirationDate < ?") .setParameter(0, Accessor.Status.EXPIRED) .setDate(1, new Date()) .executeUpdate(); return null; }); }
@Override public void remove(Accessor accessor) { getHibernateTemplate().delete(accessor); } }
public void saveOrUpdateAttachments(List<AttachmentIfc> list) { for (AttachmentIfc attachment : list) { getHibernateTemplate().saveOrUpdate(attachment); } }
/** * Removes an authorization for a specified qualifier and function * @param qualifierId * @param functionId */ public void removeAuthorizationByQualifierAndFunction(String qualifierId, String functionId) { String query="select a from AuthorizationData a where a.qualifierId = :id and a.functionId = :fid"; List l = getHibernateTemplate().findByNamedParam(query, new String[] {"id", "fid"}, new String[] {qualifierId, functionId}); getHibernateTemplate().deleteAll(l); }
public void removeEnrollmentSet(String eid) { EnrollmentSetCmImpl es = (EnrollmentSetCmImpl)getObjectByEid(eid, EnrollmentSetCmImpl.class.getName()); List enrollments = getHibernateTemplate().findByNamedQueryAndNamedParam( "findEnrollments", "enrollmentSetEid", eid); for(Iterator iter = enrollments.iterator(); iter.hasNext();) { getHibernateTemplate().delete(iter.next()); } // Remove the enrollment set getHibernateTemplate().delete(es); }
public void setPropertyValue(final String name, final String value) { final List<?> list = getHibernateTemplate().findByNamedParam("from GradebookProperty as prop where prop.name = :name", "name", name); GradebookProperty property; if (!list.isEmpty()) { property = (GradebookProperty)list.get(0); } else { property = new GradebookProperty(name); } property.setValue(value); getHibernateTemplate().saveOrUpdate(property); this.propertiesMap.put(name, value); }
public boolean removeCourseOfferingFromCourseSet(String courseSetEid, String courseOfferingEid) { CourseSetCmImpl courseSet = (CourseSetCmImpl)getObjectByEid(courseSetEid, CourseSetCmImpl.class.getName()); CourseOffering courseOffering = (CourseOffering)getObjectByEid(courseOfferingEid, CourseOfferingCmImpl.class.getName()); Set offerings = courseSet.getCourseOfferings(); if(offerings == null || ! offerings.contains(courseOffering)) { return false; } offerings.remove(courseOffering); courseSet.setLastModifiedBy(authn.getUserEid()); courseSet.setLastModifiedDate(new Date()); getHibernateTemplate().update(courseSet); return true; }
public AcademicSession createAcademicSession(String eid, String title, String description, Date startDate, Date endDate) throws IdExistsException { AcademicSessionCmImpl academicSession = new AcademicSessionCmImpl(eid, title, description, startDate, endDate); academicSession.setCreatedBy(authn.getUserEid()); academicSession.setCreatedDate(new Date()); try { getHibernateTemplate().save(academicSession); return academicSession; } catch (DataIntegrityViolationException dive) { throw new IdExistsException(eid, AcademicSession.class.getName()); } }
@Override public Long storeMappingConfiguration(MappingConfiguration configurationContext) throws DataAccessException { configurationContext.setUpdatedDateTime(new Date()); this.getHibernateTemplate().saveOrUpdate(configurationContext); return configurationContext.getId(); }
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<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 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 Category getCategory(final Long categoryId) throws HibernateException{ final HibernateCallback<Category> hc = session -> (Category) session .createQuery("from Category as cat where cat.id = :categoryid") .setLong("categoryid", categoryId) .uniqueResult(); return getHibernateTemplate().execute(hc); }
public boolean isEmpty(final String courseSetEid) { HibernateCallback hc = session -> { Query q = session.getNamedQuery("findNonEmptyCourseSet"); q.setParameter("eid", courseSetEid); return Boolean.valueOf( ! q.iterate().hasNext()); }; return ((Boolean)getHibernateTemplate().execute(hc)).booleanValue(); }
@SuppressWarnings("unchecked") @Override public List<ConfigurationType> getAllConfigurationTypes() { DetachedCriteria criteria = DetachedCriteria.forClass(ConfigurationType.class); return (List<ConfigurationType>) this.getHibernateTemplate().findByCriteria(criteria); }
@Override public <T> T get(Class<T> entityClass, Serializable id) throws DataAccessException { return get(entityClass, id, null); }
protected Serializable saveEntity(final String entityName, final Object entityInstance) { if (LOG.isTraceEnabled()) { LOG.trace("saveEntity({}, {})", entityName, entityInstance); } return getHibernateTemplate().save(entityName, entityInstance); }
public void removeAcademicSession(String eid) { AcademicSessionCmImpl as = (AcademicSessionCmImpl)getObjectByEid(eid, AcademicSessionCmImpl.class.getName()); // Remove the course offerings in this academic session List<CourseOffering> courseOfferings = (List<CourseOffering>) getHibernateTemplate().findByNamedParam("select co from CourseOfferingCmImpl as co where co.academicSession.eid = :eid", "eid", eid); for(Iterator<CourseOffering> iter = courseOfferings.iterator(); iter.hasNext();) { removeCourseOffering(iter.next().getEid()); } // Remove the academic session itself getHibernateTemplate().delete(as); }
@Override public CourseGrade getCourseGrade(final Long gradebookId) { return (CourseGrade) getHibernateTemplate() .findByNamedParam("from CourseGrade as cg where cg.gradebook.id = :gradebookid", "gradebookid", gradebookId).get(0); }
public void removeQuestionPoolAccess(Tree tree, String user, final Long questionPoolId, Long accessTypeId) { QuestionPoolAccessData qpad = new QuestionPoolAccessData(questionPoolId, user, accessTypeId); getHibernateTemplate().delete(getHibernateTemplate().merge(qpad)); Iterator citer = (tree.getChildList(questionPoolId)).iterator(); while (citer.hasNext()) { Long childPoolId = (Long) citer.next(); removeQuestionPoolAccess(tree, user, childPoolId, accessTypeId); } }