org.sakaiproject.tool.assessment.facade.SecureDeliveryFacadeQueries Maven / Gradle / Ivy

Go to download
Show more of this group Show more artifacts with this name
Show all versions of samigo-services Show documentation
The newest version!
/**
 * Copyright (c) 2020 The Apereo Foundation
 *
 * Licensed under the Educational Community License, Version 2.0 (the "License");
 * you may not use this file except in compliance with the License.
 * You may obtain a copy of the License at
 *
 *             http://opensource.org/licenses/ecl2
 *
 * Unless required by applicable law or agreed to in writing, software
 * distributed under the License is distributed on an "AS IS" BASIS,
 * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
 * See the License for the specific language governing permissions and
 * limitations under the License.
 */
package org.sakaiproject.tool.assessment.facade;

import lombok.extern.slf4j.Slf4j;
import org.hibernate.query.Query;
import org.sakaiproject.tool.assessment.data.dao.grading.SecureDeliveryData;
import org.springframework.orm.hibernate5.HibernateCallback;
import org.springframework.orm.hibernate5.support.HibernateDaoSupport;

import java.util.Date;
import java.util.List;

@Slf4j
public class SecureDeliveryFacadeQueries extends HibernateDaoSupport implements SecureDeliveryFacadeQueriesAPI {

  public List getUrlsForAssessment(final Long assessmentId) {

    HibernateCallback> hcb = session -> {
      Query q = session.getNamedQuery(QUERY_GET_URLS_FOR_ASSESSMENT);
      q.setParameter("publishedId", assessmentId);
      return q.list();
    };

    return getHibernateTemplate().execute(hcb);
  }

  public List getUrlsForAssessmentAndUser(final Long assessmentId, final String agentId) {

    HibernateCallback> hcb = session -> {
      Query q = session.getNamedQuery(QUERY_GET_URLS_FOR_ASSESSMENT_AND_USER);
      q.setParameter("publishedId", assessmentId);
      q.setParameter("agentId", agentId);
      return q.list();
    };

    return getHibernateTemplate().execute(hcb);
  }

  public void saveUrlsForAssessmentAndUser(Long assessmentId, String agentId, String instructorUrl, String studentUrl) {
    SecureDeliveryData sd = new SecureDeliveryData();
    sd.setPublishedAssessmentId(assessmentId);
    sd.setAgentId(agentId);
    sd.setInstructorUrl(instructorUrl);
    sd.setStudentUrl(studentUrl);
    sd.setCreatedDate(new Date());
    getHibernateTemplate().save(sd);
  }

}