List of usage examples for javax.persistence EntityManager isOpen
public boolean isOpen();
From source file:org.opencastproject.usertracking.impl.UserTrackingServiceImpl.java
public UserActionList getUserActionsByTypeAndMediapackageId(String type, String mediapackageId, int offset, int limit) { UserActionList result = new UserActionListImpl(); result.setTotal(getTotal(type, mediapackageId)); result.setOffset(offset);/*from w ww . j a v a 2 s . c o m*/ result.setLimit(limit); EntityManager em = null; try { em = emf.createEntityManager(); Query q = em.createNamedQuery("findUserActionsByTypeAndMediapackageId"); q.setParameter("type", type); q.setParameter("mediapackageId", mediapackageId); q.setFirstResult(offset); q.setMaxResults(limit); @SuppressWarnings("unchecked") Collection<UserAction> userActions = q.getResultList(); for (UserAction a : userActions) { result.add(a); } return result; } finally { if (em != null && em.isOpen()) { em.close(); } } }
From source file:org.opencastproject.usertracking.impl.UserTrackingServiceImpl.java
@SuppressWarnings("unchecked") public UserActionList getUserActionsByTypeAndDay(String type, String day, int offset, int limit) { UserActionList result = new UserActionListImpl(); int year = Integer.parseInt(day.substring(0, 4)); int month = Integer.parseInt(day.substring(4, 6)) - 1; int date = Integer.parseInt(day.substring(6, 8)); Calendar calBegin = new GregorianCalendar(); calBegin.set(year, month, date, 0, 0); Calendar calEnd = new GregorianCalendar(); calEnd.set(year, month, date, 23, 59); result.setTotal(getTotal(type, calBegin, calEnd)); result.setOffset(offset);/*from w ww.j a v a2s . c o m*/ result.setLimit(limit); EntityManager em = null; try { em = emf.createEntityManager(); Query q = em.createNamedQuery("findUserActionsByTypeAndIntervall"); q.setParameter("type", type); q.setParameter("begin", calBegin, TemporalType.TIMESTAMP); q.setParameter("end", calEnd, TemporalType.TIMESTAMP); q.setFirstResult(offset); q.setMaxResults(limit); Collection<UserAction> userActions = q.getResultList(); for (UserAction a : userActions) { result.add(a); } return result; } finally { if (em != null && em.isOpen()) { em.close(); } } }
From source file:org.opencastproject.usertracking.impl.UserTrackingServiceImpl.java
public UserActionList getUserActionsByTypeAndMediapackageIdByDate(String type, String mediapackageId, int offset, int limit) { UserActionList result = new UserActionListImpl(); result.setTotal(getTotal(type, mediapackageId)); result.setOffset(offset);/*from w w w. j a v a 2 s.c om*/ result.setLimit(limit); EntityManager em = null; try { em = emf.createEntityManager(); Query q = em.createNamedQuery("findUserActionsByMediaPackageAndTypeAscendingByDate"); q.setParameter("type", type); q.setParameter("mediapackageId", mediapackageId); q.setFirstResult(offset); q.setMaxResults(limit); @SuppressWarnings("unchecked") Collection<UserAction> userActions = q.getResultList(); for (UserAction a : userActions) { result.add(a); } return result; } finally { if (em != null && em.isOpen()) { em.close(); } } }
From source file:org.opencastproject.usertracking.impl.UserTrackingServiceImpl.java
public UserActionList getUserActionsByTypeAndMediapackageIdByDescendingDate(String type, String mediapackageId, int offset, int limit) { UserActionList result = new UserActionListImpl(); result.setTotal(getTotal(type, mediapackageId)); result.setOffset(offset);/*from w w w.j a va2s. c o m*/ result.setLimit(limit); EntityManager em = null; try { em = emf.createEntityManager(); Query q = em.createNamedQuery("findUserActionsByMediaPackageAndTypeDescendingByDate"); q.setParameter("type", type); q.setParameter("mediapackageId", mediapackageId); q.setFirstResult(offset); q.setMaxResults(limit); @SuppressWarnings("unchecked") Collection<UserAction> userActions = q.getResultList(); for (UserAction a : userActions) { result.add(a); } return result; } finally { if (em != null && em.isOpen()) { em.close(); } } }
From source file:org.opencastproject.usertracking.impl.UserTrackingServiceImpl.java
@SuppressWarnings("unchecked") public UserSummaryListImpl getUserSummaryByTypeAndMediaPackage(String type, String mediapackageId) { UserSummaryListImpl result = new UserSummaryListImpl(); EntityManager em = null; try {/*w w w . j a v a 2 s. c om*/ em = emf.createEntityManager(); Query q = em.createNamedQuery("userSummaryByMediapackageByType"); q.setParameter("type", type); q.setParameter("mediapackageId", mediapackageId); List<Object[]> users = q.getResultList(); for (Object[] user : users) { UserSummaryImpl userSummary = new UserSummaryImpl(); userSummary.ingest(user); result.add(userSummary); } return result; } catch (Exception e) { logger.warn("Unable to return any results from mediapackage " + mediapackageId + " of type " + type + " because of ", e); return result; } finally { if (em != null && em.isOpen()) { em.close(); } } }
From source file:org.opencastproject.usertracking.impl.UserTrackingServiceImpl.java
private int getTotal(String type, Calendar calBegin, Calendar calEnd) { EntityManager em = null; try {//from ww w . ja va 2s . c o m em = emf.createEntityManager(); Query q = em.createNamedQuery("findTotalByTypeAndIntervall"); q.setParameter("type", type); q.setParameter("begin", calBegin, TemporalType.TIMESTAMP); q.setParameter("end", calEnd, TemporalType.TIMESTAMP); return ((Long) q.getSingleResult()).intValue(); } finally { if (em != null && em.isOpen()) { em.close(); } } }
From source file:org.opencastproject.usertracking.impl.UserTrackingServiceImpl.java
private int getTotal(String type, String mediapackageId) { EntityManager em = null; try {/* w ww. ja v a2s . c o m*/ em = emf.createEntityManager(); Query q = em.createNamedQuery("findTotalByTypeAndMediapackageId"); q.setParameter("type", type); q.setParameter("mediapackageId", mediapackageId); return ((Long) q.getSingleResult()).intValue(); } finally { if (em != null && em.isOpen()) { em.close(); } } }
From source file:org.opencastproject.usertracking.impl.UserTrackingServiceImpl.java
@SuppressWarnings("unchecked") public UserActionList getUserActionsByDay(String day, int offset, int limit) { UserActionList result = new UserActionListImpl(); int year = Integer.parseInt(day.substring(0, 4)); int month = Integer.parseInt(day.substring(4, 6)) - 1; int date = Integer.parseInt(day.substring(6, 8)); Calendar calBegin = new GregorianCalendar(); calBegin.set(year, month, date, 0, 0); Calendar calEnd = new GregorianCalendar(); calEnd.set(year, month, date, 23, 59); result.setTotal(getTotal(calBegin, calEnd)); result.setOffset(offset);//from w w w . jav a 2 s . c o m result.setLimit(limit); EntityManager em = null; try { em = emf.createEntityManager(); Query q = em.createNamedQuery("findUserActionsByIntervall"); q.setParameter("begin", calBegin, TemporalType.TIMESTAMP); q.setParameter("end", calEnd, TemporalType.TIMESTAMP); q.setFirstResult(offset); q.setMaxResults(limit); Collection<UserAction> userActions = q.getResultList(); for (UserAction a : userActions) { result.add(a); } return result; } finally { if (em != null && em.isOpen()) { em.close(); } } }
From source file:org.opencastproject.usertracking.impl.UserTrackingServiceImpl.java
private int getTotal(Calendar calBegin, Calendar calEnd) { EntityManager em = null; try {//from w w w.j a v a 2 s. c o m em = emf.createEntityManager(); Query q = em.createNamedQuery("findTotalByIntervall"); q.setParameter("begin", calBegin, TemporalType.TIMESTAMP); q.setParameter("end", calEnd, TemporalType.TIMESTAMP); return ((Long) q.getSingleResult()).intValue(); } finally { if (em != null && em.isOpen()) { em.close(); } } }
From source file:org.opencastproject.usertracking.impl.UserTrackingServiceImpl.java
public Report getReport(int offset, int limit) { Report report = new ReportImpl(); report.setLimit(limit);//from w w w.ja v a2s .c o m report.setOffset(offset); EntityManager em = null; try { em = emf.createEntityManager(); Query q = em.createNamedQuery("countSessionsGroupByMediapackage"); q.setFirstResult(offset); q.setMaxResults(limit); @SuppressWarnings("unchecked") List<Object[]> result = q.getResultList(); ReportItem item; for (Object[] a : result) { item = new ReportItemImpl(); item.setEpisodeId((String) a[0]); item.setViews((Long) a[1]); item.setPlayed((Long) a[2]); report.add(item); } return report; } finally { if (em != null && em.isOpen()) { em.close(); } } }