Fisheye: Tag dcdc1487609bd4f00afaa93c09272d84ab0cd325 refers to a dead (removed) revision in file `lams_tool_assessment/conf/hibernate/mappings/org/lamsfoundation/lams/tool/assessment/model/Assessment.hbm.xml'.
Fisheye: No comparison available. Pass `N' to diff?
Fisheye: Tag dcdc1487609bd4f00afaa93c09272d84ab0cd325 refers to a dead (removed) revision in file `lams_tool_assessment/conf/hibernate/mappings/org/lamsfoundation/lams/tool/assessment/model/AssessmentOptionAnswer.hbm.xml'.
Fisheye: No comparison available. Pass `N' to diff?
Fisheye: Tag dcdc1487609bd4f00afaa93c09272d84ab0cd325 refers to a dead (removed) revision in file `lams_tool_assessment/conf/hibernate/mappings/org/lamsfoundation/lams/tool/assessment/model/AssessmentOverallFeedback.hbm.xml'.
Fisheye: No comparison available. Pass `N' to diff?
Fisheye: Tag dcdc1487609bd4f00afaa93c09272d84ab0cd325 refers to a dead (removed) revision in file `lams_tool_assessment/conf/hibernate/mappings/org/lamsfoundation/lams/tool/assessment/model/AssessmentQuestion.hbm.xml'.
Fisheye: No comparison available. Pass `N' to diff?
Fisheye: Tag dcdc1487609bd4f00afaa93c09272d84ab0cd325 refers to a dead (removed) revision in file `lams_tool_assessment/conf/hibernate/mappings/org/lamsfoundation/lams/tool/assessment/model/AssessmentQuestionOption.hbm.xml'.
Fisheye: No comparison available. Pass `N' to diff?
Fisheye: Tag dcdc1487609bd4f00afaa93c09272d84ab0cd325 refers to a dead (removed) revision in file `lams_tool_assessment/conf/hibernate/mappings/org/lamsfoundation/lams/tool/assessment/model/AssessmentQuestionResult.hbm.xml'.
Fisheye: No comparison available. Pass `N' to diff?
Fisheye: Tag dcdc1487609bd4f00afaa93c09272d84ab0cd325 refers to a dead (removed) revision in file `lams_tool_assessment/conf/hibernate/mappings/org/lamsfoundation/lams/tool/assessment/model/AssessmentResult.hbm.xml'.
Fisheye: No comparison available. Pass `N' to diff?
Fisheye: Tag dcdc1487609bd4f00afaa93c09272d84ab0cd325 refers to a dead (removed) revision in file `lams_tool_assessment/conf/hibernate/mappings/org/lamsfoundation/lams/tool/assessment/model/AssessmentSession.hbm.xml'.
Fisheye: No comparison available. Pass `N' to diff?
Fisheye: Tag dcdc1487609bd4f00afaa93c09272d84ab0cd325 refers to a dead (removed) revision in file `lams_tool_assessment/conf/hibernate/mappings/org/lamsfoundation/lams/tool/assessment/model/AssessmentUnit.hbm.xml'.
Fisheye: No comparison available. Pass `N' to diff?
Fisheye: Tag dcdc1487609bd4f00afaa93c09272d84ab0cd325 refers to a dead (removed) revision in file `lams_tool_assessment/conf/hibernate/mappings/org/lamsfoundation/lams/tool/assessment/model/AssessmentUser.hbm.xml'.
Fisheye: No comparison available. Pass `N' to diff?
Fisheye: Tag dcdc1487609bd4f00afaa93c09272d84ab0cd325 refers to a dead (removed) revision in file `lams_tool_assessment/conf/hibernate/mappings/org/lamsfoundation/lams/tool/assessment/model/QuestionReference.hbm.xml'.
Fisheye: No comparison available. Pass `N' to diff?
Index: lams_tool_assessment/src/java/org/lamsfoundation/lams/tool/assessment/assessmentApplicationContext.xml
===================================================================
diff -u -r62aaf160878735888d077bf28fac3c1989bb8fbd -rdcdc1487609bd4f00afaa93c09272d84ab0cd325
--- lams_tool_assessment/src/java/org/lamsfoundation/lams/tool/assessment/assessmentApplicationContext.xml (.../assessmentApplicationContext.xml) (revision 62aaf160878735888d077bf28fac3c1989bb8fbd)
+++ lams_tool_assessment/src/java/org/lamsfoundation/lams/tool/assessment/assessmentApplicationContext.xml (.../assessmentApplicationContext.xml) (revision dcdc1487609bd4f00afaa93c09272d84ab0cd325)
@@ -149,7 +149,7 @@
PROPAGATION_REQUIRED,+java.lang.Exception
PROPAGATION_REQUIRED,+java.lang.Exception
PROPAGATION_REQUIRED,+java.lang.Exception
-
+ readOnly, PROPAGATION_REQUIRED,+java.lang.Exception
Index: lams_tool_assessment/src/java/org/lamsfoundation/lams/tool/assessment/dao/AssessmentQuestionDAO.java
===================================================================
diff -u -r7475d08afc280b5e2e5ddf04e8bf35e3166aaf80 -rdcdc1487609bd4f00afaa93c09272d84ab0cd325
--- lams_tool_assessment/src/java/org/lamsfoundation/lams/tool/assessment/dao/AssessmentQuestionDAO.java (.../AssessmentQuestionDAO.java) (revision 7475d08afc280b5e2e5ddf04e8bf35e3166aaf80)
+++ lams_tool_assessment/src/java/org/lamsfoundation/lams/tool/assessment/dao/AssessmentQuestionDAO.java (.../AssessmentQuestionDAO.java) (revision dcdc1487609bd4f00afaa93c09272d84ab0cd325)
@@ -29,6 +29,4 @@
AssessmentQuestion getByUid(Long assessmentQuestionUid);
- void evict(Object o);
-
}
Index: lams_tool_assessment/src/java/org/lamsfoundation/lams/tool/assessment/dao/hibernate/AssessmentDAOHibernate.java
===================================================================
diff -u -r7475d08afc280b5e2e5ddf04e8bf35e3166aaf80 -rdcdc1487609bd4f00afaa93c09272d84ab0cd325
--- lams_tool_assessment/src/java/org/lamsfoundation/lams/tool/assessment/dao/hibernate/AssessmentDAOHibernate.java (.../AssessmentDAOHibernate.java) (revision 7475d08afc280b5e2e5ddf04e8bf35e3166aaf80)
+++ lams_tool_assessment/src/java/org/lamsfoundation/lams/tool/assessment/dao/hibernate/AssessmentDAOHibernate.java (.../AssessmentDAOHibernate.java) (revision dcdc1487609bd4f00afaa93c09272d84ab0cd325)
@@ -33,8 +33,6 @@
/**
*
* @author Andrey Balan
- *
- * @version $Revision$
*/
@Repository
public class AssessmentDAOHibernate extends LAMSBaseDAO implements AssessmentDAO {
Index: lams_tool_assessment/src/java/org/lamsfoundation/lams/tool/assessment/dao/hibernate/AssessmentQuestionDAOHibernate.java
===================================================================
diff -u -r7475d08afc280b5e2e5ddf04e8bf35e3166aaf80 -rdcdc1487609bd4f00afaa93c09272d84ab0cd325
--- lams_tool_assessment/src/java/org/lamsfoundation/lams/tool/assessment/dao/hibernate/AssessmentQuestionDAOHibernate.java (.../AssessmentQuestionDAOHibernate.java) (revision 7475d08afc280b5e2e5ddf04e8bf35e3166aaf80)
+++ lams_tool_assessment/src/java/org/lamsfoundation/lams/tool/assessment/dao/hibernate/AssessmentQuestionDAOHibernate.java (.../AssessmentQuestionDAOHibernate.java) (revision dcdc1487609bd4f00afaa93c09272d84ab0cd325)
@@ -23,8 +23,6 @@
package org.lamsfoundation.lams.tool.assessment.dao.hibernate;
-import java.util.List;
-
import org.lamsfoundation.lams.dao.hibernate.LAMSBaseDAO;
import org.lamsfoundation.lams.tool.assessment.dao.AssessmentQuestionDAO;
import org.lamsfoundation.lams.tool.assessment.model.AssessmentQuestion;
@@ -38,9 +36,4 @@
return (AssessmentQuestion) this.getObject(AssessmentQuestion.class, assessmentQuestionUid);
}
- @Override
- public void evict(Object o) {
- getSession().evict(o);
- }
-
}
Index: lams_tool_assessment/src/java/org/lamsfoundation/lams/tool/assessment/dao/hibernate/AssessmentQuestionResultDAOHibernate.java
===================================================================
diff -u -r70d1adeee6d96136e69aa91bb50d94c4a3b826d2 -rdcdc1487609bd4f00afaa93c09272d84ab0cd325
--- lams_tool_assessment/src/java/org/lamsfoundation/lams/tool/assessment/dao/hibernate/AssessmentQuestionResultDAOHibernate.java (.../AssessmentQuestionResultDAOHibernate.java) (revision 70d1adeee6d96136e69aa91bb50d94c4a3b826d2)
+++ lams_tool_assessment/src/java/org/lamsfoundation/lams/tool/assessment/dao/hibernate/AssessmentQuestionResultDAOHibernate.java (.../AssessmentQuestionResultDAOHibernate.java) (revision dcdc1487609bd4f00afaa93c09272d84ab0cd325)
@@ -77,14 +77,13 @@
}
@Override
- public Float getQuestionResultMark(Long assessmentUid, Long userId, int questionSequenceId) {
- Query q = getSession().createQuery(GET_ANSWER_MARK);
+ public Float getQuestionResultMark(final Long assessmentUid, final Long userId, final int questionSequenceId) {
+ Query q = getSession().createQuery(GET_ANSWER_MARK, Number.class);
q.setParameter("assessmentUid", assessmentUid);
q.setParameter("userId", userId);
q.setParameter("questionSequenceId", questionSequenceId);
q.setMaxResults(1);
- Object result = q.uniqueResult();
- return result != null ? ((Number) result).floatValue() : null;
-
+ Number result = q.uniqueResult();
+ return result != null ? result.floatValue() : null;
}
}
Index: lams_tool_assessment/src/java/org/lamsfoundation/lams/tool/assessment/dao/hibernate/AssessmentResultDAOHibernate.java
===================================================================
diff -u -rceb74e3b4097cf6461280448f904fa21a176aaa4 -rdcdc1487609bd4f00afaa93c09272d84ab0cd325
--- lams_tool_assessment/src/java/org/lamsfoundation/lams/tool/assessment/dao/hibernate/AssessmentResultDAOHibernate.java (.../AssessmentResultDAOHibernate.java) (revision ceb74e3b4097cf6461280448f904fa21a176aaa4)
+++ lams_tool_assessment/src/java/org/lamsfoundation/lams/tool/assessment/dao/hibernate/AssessmentResultDAOHibernate.java (.../AssessmentResultDAOHibernate.java) (revision dcdc1487609bd4f00afaa93c09272d84ab0cd325)
@@ -40,16 +40,16 @@
public class AssessmentResultDAOHibernate extends LAMSBaseDAO implements AssessmentResultDAO {
private static final String FIND_LAST_BY_ASSESSMENT_AND_USER = "FROM " + AssessmentResult.class.getName()
- + " AS r WHERE r.user.userId = :userId AND r.assessment.uid=:uid AND r.latest=1";
+ + " AS r WHERE r.user.userId =:userId AND r.assessment.uid=:assessmentUid AND r.latest=1";
private static final String FIND_WHETHER_LAST_RESULT_FINISHED = "SELECT (r.finishDate IS NOT NULL) FROM " + AssessmentResult.class.getName()
- + " AS r WHERE r.user.userId = :userId AND r.assessment.uid=:uid AND r.latest=1";
+ + " AS r WHERE r.user.userId =:userId AND r.assessment.uid=:assessmentUid AND r.latest=1";
private static final String FIND_BY_ASSESSMENT_AND_USER_AND_FINISHED = "FROM " + AssessmentResult.class.getName()
+ " AS r WHERE r.user.userId = ? AND r.assessment.uid=? AND (r.finishDate != null) ORDER BY r.startDate ASC";
private static final String FIND_LAST_FINISHED_BY_ASSESSMENT_AND_USER = "FROM " + AssessmentResult.class.getName()
- + " AS r WHERE r.user.userId = :userId AND r.assessment.uid=:uid AND (r.finishDate != null) AND r.latest=1";
+ + " AS r WHERE r.user.userId = :userId AND r.assessment.uid=:assessmentUid AND (r.finishDate != null) AND r.latest=1";
private static final String FIND_BY_SESSION_AND_USER = "FROM " + AssessmentResult.class.getName()
+ " AS r WHERE r.user.userId = ? AND r.sessionId=?";
@@ -68,7 +68,7 @@
+ " AS r WHERE r.user.userId=? AND r.assessment.uid=? AND (r.finishDate != null)";
private static final String LAST_ASSESSMENT_RESULT_GRADE = "select r.grade FROM " + AssessmentResult.class.getName()
- + " AS r WHERE r.user.userId=:userId AND r.assessment.uid=:uid AND (r.finishDate != null) AND r.latest=1";
+ + " AS r WHERE r.user.userId=:userId AND r.assessment.uid=:assessmentUid AND (r.finishDate != null) AND r.latest=1";
private static final String LAST_ASSESSMENT_RESULT_GRADES_BY_CONTENT_ID = "select r.user.userId, r.grade FROM "
+ AssessmentResult.class.getName()
@@ -120,40 +120,38 @@
@Override
public AssessmentResult getLastAssessmentResult(Long assessmentUid, Long userId) {
- Query q = getSession().createQuery(FIND_LAST_BY_ASSESSMENT_AND_USER);
+ Query q = getSession().createQuery(FIND_LAST_BY_ASSESSMENT_AND_USER, AssessmentResult.class);
q.setParameter("userId", userId);
- q.setParameter("uid", assessmentUid);
- return (AssessmentResult) q.uniqueResult();
+ q.setParameter("assessmentUid", assessmentUid);
+ return q.uniqueResult();
}
@Override
public Boolean isLastAttemptFinishedByUser(AssessmentUser user) {
Assessment assessment = user.getAssessment() == null ? user.getSession().getAssessment() : user.getAssessment();
-
- Query q = getSession().createQuery(FIND_WHETHER_LAST_RESULT_FINISHED);
+ Query q = getSession().createQuery(FIND_WHETHER_LAST_RESULT_FINISHED, Boolean.class);
q.setParameter("userId", user.getUserId());
- q.setParameter("uid", assessment.getUid());
- return (Boolean) q.uniqueResult();
+ q.setParameter("assessmentUid", assessment.getUid());
+ return q.uniqueResult();
}
@Override
public AssessmentResult getLastFinishedAssessmentResult(Long assessmentUid, Long userId) {
-
- Query q = getSession().createQuery(FIND_LAST_FINISHED_BY_ASSESSMENT_AND_USER);
+ Query q = getSession().createQuery(FIND_LAST_FINISHED_BY_ASSESSMENT_AND_USER,
+ AssessmentResult.class);
q.setParameter("userId", userId);
- q.setParameter("uid", assessmentUid);
+ q.setParameter("assessmentUid", assessmentUid);
return (AssessmentResult) q.uniqueResult();
}
@Override
public Float getLastTotalScoreByUser(Long assessmentUid, Long userId) {
-
- Query q = getSession().createQuery(LAST_ASSESSMENT_RESULT_GRADE);
+ Query q = getSession().createQuery(LAST_ASSESSMENT_RESULT_GRADE, Float.class);
q.setParameter("userId", userId);
- q.setParameter("uid", assessmentUid);
- Object lastTotalScore = q.uniqueResult();
+ q.setParameter("assessmentUid", assessmentUid);
+ Float lastTotalScore = q.uniqueResult();
- return (lastTotalScore == null) ? 0 : (Float)lastTotalScore;
+ return lastTotalScore == null ? 0 : lastTotalScore;
}
@Override
@@ -165,10 +163,10 @@
@Override
public Float getBestTotalScoreByUser(Long sessionId, Long userId) {
- Query q = getSession().createQuery(BEST_SCORE_BY_SESSION_AND_USER);
+ Query q = getSession().createQuery(BEST_SCORE_BY_SESSION_AND_USER, Float.class);
q.setParameter("userId", userId);
q.setParameter("sessionId", sessionId);
- return ((Float) q.uniqueResult());
+ return q.uniqueResult();
}
@Override
@@ -179,11 +177,11 @@
@Override
public Float getFirstTotalScoreByUser(Long sessionId, Long userId) {
- Query q = getSession().createQuery(FIRST_SCORE_BY_SESSION_AND_USER);
+ Query q = getSession().createQuery(FIRST_SCORE_BY_SESSION_AND_USER, Float.class);
q.setParameter("userId", userId);
q.setParameter("sessionId", sessionId);
q.setMaxResults(1);
- return ((Float) q.uniqueResult());
+ return q.uniqueResult();
}
@Override
@@ -195,19 +193,20 @@
+ "INNER JOIN (SELECT user_uid, MIN(start_date) AS startDate FROM tl_laasse10_assessment_result WHERE finish_date IS NOT NULL GROUP BY user_uid) firstRes "
+ "ON (res.user_uid = firstRes.user_uid AND res.start_date = firstRes.startDate) GROUP BY res.user_uid";
- NativeQuery query = getSession().createNativeQuery(FIRST_SCORES_BY_CONTENT_ID);
+ NativeQuery> query = getSession().createNativeQuery(FIRST_SCORES_BY_CONTENT_ID);
query.setParameter("contentId", toolContentId);
- List