package com.redhat.training.services;

import java.util.List;

import javax.ejb.Stateless;
import javax.persistence.EntityManager;
import javax.persistence.PersistenceContext;
import javax.persistence.TypedQuery;
import javax.persistence.Query;

import com.redhat.training.model.Person;

@Stateless

public class PersonService {

  @PersistenceContext(unitName="hello")
  private EntityManager entityManager;

  // Get all Person objects in the Database
  public List<Person> getAllPersons() {
    TypedQuery<Person> query = entityManager.createQuery("SELECT p FROM Person p", Person.class);
    return query.getResultList();
  }
  /*//Get persons whose name matches the name given in the query -- Named parameters
     public List<Person> getPersonsWithName(String name) {
         TypedQuery<Person> query = entityManager.createQuery("SELECT p from Person p where p.name =:pname", Person.class);
         query.setParameter("pname", name);
         return = query.getResultList();

     }*/
  /* //Get persons whose name matches the name given in the query -- positional parameters
     public List<Person> getPersonsWithName(String name) {
      TypedQuery<Person> query = entityManager.createQuery("SELECT p from Person p where p.name =?1", Person.class);
      query.setParameter(1, name);
      return = query.getResultList();
     }*/
  //Get persons whose name matches the name given in the query
  public List<Person> getPersonsWithName(String name) {
    TypedQuery<Person> query = entityManager.createNamedQuery("getAllPersonsWithName", Person.class);
    query.setParameter("pname", name);
    return query.getResultList();
  }
}