package domain.db;

import domain.model.Background;
import java.util.Collection;
import java.util.List;
import javax.persistence.EntityManager;
import javax.persistence.EntityManagerFactory;
import javax.persistence.Persistence;

/**
 *
 * @author Max
 */
public class BackgroundRepositorySQL implements BackgroundRepository {

    EntityManagerFactory entityManagerFactory = Persistence.createEntityManagerFactory("backgrounds_db_pu");
    EntityManager entityManager = entityManagerFactory.createEntityManager();

    public BackgroundRepositorySQL() {
        //entityManagerFactory = Persistence.createEntityManagerFactory("backgrounds_db_pu");
        //entityManager = entityManagerFactory.createEntityManager();
    }

    @Override
    public void create(Background background) {
        entityManager.getTransaction().begin();
        entityManager.persist(background);
        entityManager.getTransaction().commit();
    }

    @Override
    public Background read(long id) {
        return entityManager.find(Background.class, id);
    }

    @Override
    public void update(Background background) {
        Background bg = entityManager.find(Background.class, background.getId());
        entityManager.getTransaction().begin();
        bg.update(background);
        entityManager.getTransaction().commit();
    }

    @Override
    public void delete(long id) {
        Background bg = entityManager.find(Background.class, id);
        entityManager.getTransaction().begin();
        entityManager.remove(bg);
        entityManager.getTransaction().commit();
    }

    @Override
    public Collection<Background> getAll() {
        return entityManager.createQuery("Select c from Background c", Background.class).getResultList();
    }

    @Override
    public double getAverageRating() {
        return 0;
    }
}