com.codeup.hibernate.repositories.MoviesRepository.java Source code

Introduction

Here is the source code for com.codeup.hibernate.repositories.MoviesRepository.java

Source

/**
 * This source file is subject to the license that is bundled with this package in the file LICENSE.
 */
package com.codeup.hibernate.repositories;

import com.codeup.movies.Movie;
import com.codeup.movies.Movies;
import org.hibernate.Session;
import org.hibernate.Transaction;
import org.hibernate.query.Query;

import java.util.List;

public class MoviesRepository implements Movies {
    private final Session session;

    public MoviesRepository(Session session) {
        this.session = session;
    }

    public void add(Movie movie) {
        Transaction transaction = session.getTransaction();
        if (!transaction.isActive())
            transaction.begin();
        session.save(movie);
        transaction.commit();
    }

    public Movie with(int id) {
        Query query = session.createQuery("FROM Movie WHERE id = ?");
        query.setParameter(0, id);

        return (Movie) query.uniqueResult();
    }

    @Override
    public List<Movie> withTitleSimilarTo(String title) {
        Query query = session.createQuery("FROM Movie WHERE title LIKE ?");
        query.setParameter(0, "%" + title + "%");

        @SuppressWarnings("unchecked")
        List<Movie> movies = query.getResultList();

        return movies;
    }

    @Override
    public List<Movie> underCategory(int categoryId) {
        Query query = session.createQuery("SELECT m FROM Movie m JOIN m.categories c WHERE c.id = ?");
        query.setParameter(0, categoryId);

        @SuppressWarnings("unchecked")
        List<Movie> movies = query.getResultList();

        return movies;
    }
}