source: src/main/java/com/example/moviezone/repository/EventRepository.java

package com.example.moviezone.repository;

import com.example.moviezone.model.Event;
import com.example.moviezone.model.Film;
import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.query.Procedure;

import javax.transaction.Transactional;
import java.util.List;
@Transactional
public interface EventRepository extends JpaRepository<Event,Integer> {
    @Procedure("project.getEventsFromCinema")
    List<Event> getFilmsFromCinema(int id);
    @Procedure("project.getEventsFromNow")
    List<Event> getFilmsFromCinemaNow();
    @Procedure("project.getEventsForCustomer")
    List<Event> getEventsForCustomer(int id);
}