package com.movietime.dao;

import java.util.List;

import javax.persistence.EntityManager;
import javax.persistence.PersistenceContext;
import javax.persistence.Query;

import org.springframework.context.annotation.Scope;
import org.springframework.stereotype.Repository;
import org.springframework.transaction.annotation.Transactional;

import com.movietime.entities.Movie;

@Repository
@Scope(value="singleton")
public class MovieRepository {

    @PersistenceContext
    private EntityManager em;

    //@Transactional
    public void register(Movie mov) {
        // Save employee
        this.em.persist(mov);
    }


    @SuppressWarnings("unchecked")
    public List<Movie> findMoviesByTitle(String title) {

        String queryString = "SELECT m FROM Movie m WHERE m.title LIKE '" + title + "%'";
        Query query = em.createQuery(queryString, Movie.class);

        return query.getResultList();
    }

}