View Javadoc
1   /*
2    * JBoss, Home of Professional Open Source
3    * Copyright 2014, Red Hat, Inc. and/or its affiliates, and individual
4    * contributors by the @authors tag. See the copyright.txt in the
5    * distribution for a full listing of individual contributors.
6    *
7    * Licensed under the Apache License, Version 2.0 (the "License");
8    * you may not use this file except in compliance with the License.
9    * You may obtain a copy of the License at
10   * http://www.apache.org/licenses/LICENSE-2.0
11   * Unless required by applicable law or agreed to in writing, software
12   * distributed under the License is distributed on an "AS IS" BASIS,
13   * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
14   * See the License for the specific language governing permissions and
15   * limitations under the License.
16   */
17  package org.jboss.as.quickstarts.tasks;
18  
19  import java.util.List;
20  
21  import javax.ejb.Stateful;
22  import javax.inject.Inject;
23  import javax.persistence.EntityManager;
24  import javax.persistence.TypedQuery;
25  
26  /**
27   * Provides functionality for manipulation with tasks using the persistence context from {@link Resources}.
28   * 
29   * @author Lukas Fryc
30   * @author Oliver Kiss
31   * 
32   */
33  @Stateful
34  public class TaskDaoImpl implements TaskDao {
35  
36      @Inject
37      EntityManager em;
38  
39      @Override
40      public void createTask(User user, Task task) {
41          if (!em.contains(user)) {
42              user = em.merge(user);
43          }
44          user.getTasks().add(task);
45          task.setOwner(user);
46          em.persist(task);
47      }
48  
49      @Override
50      public List<Task> getAll(User user) {
51          TypedQuery<Task> query = querySelectAllTasksFromUser(user);
52          return query.getResultList();
53      }
54  
55      @Override
56      public List<Task> getRange(User user, int offset, int count) {
57          TypedQuery<Task> query = querySelectAllTasksFromUser(user);
58          query.setMaxResults(count);
59          query.setFirstResult(offset);
60          return query.getResultList();
61      }
62  
63      @Override
64      public List<Task> getForTitle(User user, String title) {
65          String lowerCaseTitle = "%" + title.toLowerCase() + "%";
66          return em.createQuery("SELECT t FROM Task t WHERE t.owner = ?1 AND LOWER(t.title) LIKE ?2", Task.class)
67                  .setParameter(1, user).setParameter(2, lowerCaseTitle).getResultList();
68      }
69  
70      @Override
71      public void deleteTask(Task task) {
72          if (!em.contains(task)) {
73              task = em.merge(task);
74          }
75          em.remove(task);
76      }
77  
78      private TypedQuery<Task> querySelectAllTasksFromUser(User user) {
79          return em.createQuery("SELECT t FROM Task t WHERE t.owner = ?1", Task.class).setParameter(1, user);
80      }
81  }