Index: lams_tool_kaltura/src/java/org/lamsfoundation/lams/tool/kaltura/dao/hibernate/KalturaCommentDAO.java
===================================================================
diff -u -r5fd453ea4cb0fa72cb94a5706e75f68a319de46b -r69270cb0d662d3cec3f2170c70fdb574d231a2fe
--- lams_tool_kaltura/src/java/org/lamsfoundation/lams/tool/kaltura/dao/hibernate/KalturaCommentDAO.java (.../KalturaCommentDAO.java) (revision 5fd453ea4cb0fa72cb94a5706e75f68a319de46b)
+++ lams_tool_kaltura/src/java/org/lamsfoundation/lams/tool/kaltura/dao/hibernate/KalturaCommentDAO.java (.../KalturaCommentDAO.java) (revision 69270cb0d662d3cec3f2170c70fdb574d231a2fe)
@@ -25,22 +25,24 @@
import java.util.List;
-import org.lamsfoundation.lams.dao.hibernate.BaseDAO;
+import org.lamsfoundation.lams.dao.hibernate.LAMSBaseDAO;
import org.lamsfoundation.lams.tool.kaltura.dao.IKalturaCommentDAO;
import org.lamsfoundation.lams.tool.kaltura.model.KalturaComment;
+import org.springframework.stereotype.Repository;
/**
* Hibernate implementation of IKalturaCommentDAO
.
*
* @author Andrey Balan
* @see org.lamsfoundation.lams.tool.kaltura.dao.IKalturaCommentDAO
*/
-public class KalturaCommentDAO extends BaseDAO implements IKalturaCommentDAO {
+@Repository
+public class KalturaCommentDAO extends LAMSBaseDAO implements IKalturaCommentDAO {
private static final String FIND_BY_UID = "from " + KalturaComment.class.getName() + " as r where r.uid = ?";
public KalturaComment getCommentByUid(Long commentUid) {
- List list = getHibernateTemplate().find(FIND_BY_UID, commentUid);
+ List list = doFind(FIND_BY_UID, commentUid);
if (list == null || list.size() == 0)
return null;
return (KalturaComment) list.get(0);
Index: lams_tool_kaltura/src/java/org/lamsfoundation/lams/tool/kaltura/dao/hibernate/KalturaDAO.java
===================================================================
diff -u -rccfd66f1abbfc63cd0ed0a044f89914418d67cd1 -r69270cb0d662d3cec3f2170c70fdb574d231a2fe
--- lams_tool_kaltura/src/java/org/lamsfoundation/lams/tool/kaltura/dao/hibernate/KalturaDAO.java (.../KalturaDAO.java) (revision ccfd66f1abbfc63cd0ed0a044f89914418d67cd1)
+++ lams_tool_kaltura/src/java/org/lamsfoundation/lams/tool/kaltura/dao/hibernate/KalturaDAO.java (.../KalturaDAO.java) (revision 69270cb0d662d3cec3f2170c70fdb574d231a2fe)
@@ -26,30 +26,32 @@
import java.util.List;
-import org.lamsfoundation.lams.dao.hibernate.BaseDAO;
+import org.lamsfoundation.lams.dao.hibernate.LAMSBaseDAO;
import org.lamsfoundation.lams.tool.kaltura.dao.IKalturaDAO;
import org.lamsfoundation.lams.tool.kaltura.model.Kaltura;
+import org.springframework.stereotype.Repository;
/**
* DAO for accessing the Kaltura objects - Hibernate specific code.
*/
-public class KalturaDAO extends BaseDAO implements IKalturaDAO {
+@Repository
+public class KalturaDAO extends LAMSBaseDAO implements IKalturaDAO {
private static final String FIND_FORUM_BY_CONTENTID = "from Kaltura kaltura where kaltura.toolContentId=?";
public Kaltura getByContentId(Long toolContentId) {
- List list = getHibernateTemplate().find(KalturaDAO.FIND_FORUM_BY_CONTENTID, toolContentId);
+ List list = doFind(KalturaDAO.FIND_FORUM_BY_CONTENTID, toolContentId);
if (list != null && list.size() > 0) {
return (Kaltura) list.get(0);
} else {
return null;
}
}
- public void saveOrUpdate(Kaltura kaltura) {
- this.getHibernateTemplate().saveOrUpdate(kaltura);
- this.getHibernateTemplate().flush();
- }
+ public void saveOrUpdate(Kaltura kaltura) {
+ getSession().saveOrUpdate(kaltura);
+ getSession().flush();
+ }
public void releaseFromCache(Object o) {
getSessionFactory().getCurrentSession().evict(o);
Index: lams_tool_kaltura/src/java/org/lamsfoundation/lams/tool/kaltura/dao/hibernate/KalturaItemDAO.java
===================================================================
diff -u -rb52f787a7b8d6dc77ef090dc023fc64fa3a9b2f2 -r69270cb0d662d3cec3f2170c70fdb574d231a2fe
--- lams_tool_kaltura/src/java/org/lamsfoundation/lams/tool/kaltura/dao/hibernate/KalturaItemDAO.java (.../KalturaItemDAO.java) (revision b52f787a7b8d6dc77ef090dc023fc64fa3a9b2f2)
+++ lams_tool_kaltura/src/java/org/lamsfoundation/lams/tool/kaltura/dao/hibernate/KalturaItemDAO.java (.../KalturaItemDAO.java) (revision 69270cb0d662d3cec3f2170c70fdb574d231a2fe)
@@ -25,34 +25,35 @@
import java.util.List;
-import org.lamsfoundation.lams.dao.hibernate.BaseDAO;
+import org.lamsfoundation.lams.dao.hibernate.LAMSBaseDAO;
import org.lamsfoundation.lams.tool.kaltura.dao.IKalturaItemDAO;
import org.lamsfoundation.lams.tool.kaltura.model.KalturaItem;
-import org.lamsfoundation.lams.tool.kaltura.model.KalturaItemVisitLog;
+import org.springframework.stereotype.Repository;
-public class KalturaItemDAO extends BaseDAO implements IKalturaItemDAO {
+@Repository
+public class KalturaItemDAO extends LAMSBaseDAO implements IKalturaItemDAO {
private static final String FIND_AUTHORING_ITEMS = "from " + KalturaItem.class.getName()
+ " where kaltura_uid = ? and create_by_author = 1 order by create_date asc";
private static final String FIND_ITEMS_COUNT_BY_USER = "select count(*) from "
+ KalturaItem.class.getName() + " as r where r.createdBy.session.sessionId=? and r.createdBy.userId =?";
- @Override
- public List getAuthoringItems(Long kalturaUid) {
- return this.getHibernateTemplate().find(FIND_AUTHORING_ITEMS, kalturaUid);
- }
+ @Override
+ public List getAuthoringItems(Long kalturaUid) {
+ return this.doFind(FIND_AUTHORING_ITEMS, kalturaUid);
+ }
- @Override
- public KalturaItem getByUid(Long kalturaItemUid) {
- return (KalturaItem) this.getHibernateTemplate().get(KalturaItem.class, kalturaItemUid);
- }
-
- @Override
- public int getItemsCountByUser(Long toolSessionId, Long userId) {
- List list = getHibernateTemplate().find(FIND_ITEMS_COUNT_BY_USER, new Object[] { toolSessionId, userId });
- if (list == null || list.size() == 0)
- return 0;
- return ((Number) list.get(0)).intValue();
- }
+ @Override
+ public KalturaItem getByUid(Long kalturaItemUid) {
+ return (KalturaItem) getSession().get(KalturaItem.class, kalturaItemUid);
+ }
+
+ @Override
+ public int getItemsCountByUser(Long toolSessionId, Long userId) {
+ List list = doFind(FIND_ITEMS_COUNT_BY_USER, new Object[] { toolSessionId, userId });
+ if (list == null || list.size() == 0)
+ return 0;
+ return ((Number) list.get(0)).intValue();
+ }
}
Index: lams_tool_kaltura/src/java/org/lamsfoundation/lams/tool/kaltura/dao/hibernate/KalturaItemVisitDAO.java
===================================================================
diff -u -r2aaccb954583cd8431759dca8e912a8fe863aa0e -r69270cb0d662d3cec3f2170c70fdb574d231a2fe
--- lams_tool_kaltura/src/java/org/lamsfoundation/lams/tool/kaltura/dao/hibernate/KalturaItemVisitDAO.java (.../KalturaItemVisitDAO.java) (revision 2aaccb954583cd8431759dca8e912a8fe863aa0e)
+++ lams_tool_kaltura/src/java/org/lamsfoundation/lams/tool/kaltura/dao/hibernate/KalturaItemVisitDAO.java (.../KalturaItemVisitDAO.java) (revision 69270cb0d662d3cec3f2170c70fdb574d231a2fe)
@@ -25,17 +25,19 @@
import java.util.List;
-import org.lamsfoundation.lams.dao.hibernate.BaseDAO;
+import org.lamsfoundation.lams.dao.hibernate.LAMSBaseDAO;
import org.lamsfoundation.lams.tool.kaltura.dao.IKalturaItemVisitDAO;
import org.lamsfoundation.lams.tool.kaltura.model.KalturaItemVisitLog;
+import org.springframework.stereotype.Repository;
/**
* Hibernate implementation of IKalturaItemVisitDAO
.
*
* @author Andrey Balan
* @see org.lamsfoundation.lams.tool.kaltura.dao.IKalturaItemVisitDAO
*/
-public class KalturaItemVisitDAO extends BaseDAO implements IKalturaItemVisitDAO {
+@Repository
+public class KalturaItemVisitDAO extends LAMSBaseDAO implements IKalturaItemVisitDAO {
private static final String FIND_BY_ITEM_AND_USER = "from " + KalturaItemVisitLog.class.getName()
+ " as r where r.user.userId = ? and r.kalturaItem.uid=?";
@@ -47,14 +49,14 @@
+ KalturaItemVisitLog.class.getName() + " as r where r.sessionId=? and r.user.userId =?";
public KalturaItemVisitLog getKalturaItemLog(Long itemUid, Long userId) {
- List list = getHibernateTemplate().find(FIND_BY_ITEM_AND_USER, new Object[] { userId, itemUid });
+ List list = doFind(FIND_BY_ITEM_AND_USER, new Object[] { userId, itemUid });
if (list == null || list.size() == 0)
return null;
return (KalturaItemVisitLog) list.get(0);
}
public int getUserViewLogCount(Long toolSessionId, Long userId) {
- List list = getHibernateTemplate().find(FIND_VIEW_COUNT_BY_USER, new Object[] { toolSessionId, userId });
+ List list = doFind(FIND_VIEW_COUNT_BY_USER, new Object[] { toolSessionId, userId });
if (list == null || list.size() == 0)
return 0;
return ((Number) list.get(0)).intValue();
@@ -63,7 +65,7 @@
@SuppressWarnings("unchecked")
public List getKalturaItemLogBySession(Long sessionId, Long itemUid) {
- return (List) getHibernateTemplate().find(FIND_BY_ITEM_BYSESSION, new Object[] { sessionId, itemUid });
+ return (List) doFind(FIND_BY_ITEM_BYSESSION, new Object[] { sessionId, itemUid });
}
}
Index: lams_tool_kaltura/src/java/org/lamsfoundation/lams/tool/kaltura/dao/hibernate/KalturaRatingDAO.java
===================================================================
diff -u -r2aaccb954583cd8431759dca8e912a8fe863aa0e -r69270cb0d662d3cec3f2170c70fdb574d231a2fe
--- lams_tool_kaltura/src/java/org/lamsfoundation/lams/tool/kaltura/dao/hibernate/KalturaRatingDAO.java (.../KalturaRatingDAO.java) (revision 2aaccb954583cd8431759dca8e912a8fe863aa0e)
+++ lams_tool_kaltura/src/java/org/lamsfoundation/lams/tool/kaltura/dao/hibernate/KalturaRatingDAO.java (.../KalturaRatingDAO.java) (revision 69270cb0d662d3cec3f2170c70fdb574d231a2fe)
@@ -27,18 +27,20 @@
import java.util.List;
import java.util.Locale;
-import org.lamsfoundation.lams.dao.hibernate.BaseDAO;
+import org.lamsfoundation.lams.dao.hibernate.LAMSBaseDAO;
import org.lamsfoundation.lams.tool.kaltura.dao.IKalturaRatingDAO;
import org.lamsfoundation.lams.tool.kaltura.dto.AverageRatingDTO;
import org.lamsfoundation.lams.tool.kaltura.model.KalturaRating;
+import org.springframework.stereotype.Repository;
/**
* Hibernate implementation of IKalturaRatingDAO
.
*
* @author Andrey Balan
* @see org.lamsfoundation.lams.tool.kaltura.dao.IKalturaRatingDAO
*/
-public class KalturaRatingDAO extends BaseDAO implements IKalturaRatingDAO {
+@Repository
+public class KalturaRatingDAO extends LAMSBaseDAO implements IKalturaRatingDAO {
private static final String FIND_BY_ITEM_AND_USER = "from " + KalturaRating.class.getName()
+ " as r where r.createBy.userId = ? and r.kalturaItem.uid=?";
@@ -51,7 +53,7 @@
@Override
public KalturaRating getKalturaRatingByItemAndUser(Long itemUid, Long userId) {
- List list = getHibernateTemplate().find(FIND_BY_ITEM_AND_USER, new Object[] { userId, itemUid });
+ List list = doFind(FIND_BY_ITEM_AND_USER, new Object[] { userId, itemUid });
if (list == null || list.size() == 0)
return null;
return (KalturaRating) list.get(0);
@@ -60,13 +62,13 @@
@SuppressWarnings("unchecked")
@Override
public List getKalturaRatingsByItemUid(Long itemUid) {
- return (List) getHibernateTemplate().find(FIND_BY_ITEM_UID, itemUid);
+ return (List) doFind(FIND_BY_ITEM_UID, itemUid);
}
@SuppressWarnings("unchecked")
@Override
public AverageRatingDTO getAverageRatingDtoByItem(Long itemUid, Long sessionId) {
- List