source: trip-planner/src/main/java/finki/diplomska/tripplanner/repository/jpa/JpaPlannerRepository.java

package finki.diplomska.tripplanner.repository.jpa;


import finki.diplomska.tripplanner.models.Planner;
import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.Query;
import org.springframework.data.repository.query.Param;
import org.springframework.stereotype.Repository;

import java.util.List;

@Repository
public interface JpaPlannerRepository extends JpaRepository<Planner, Long> {

        @Query(value = "SELECT * FROM planners AS p left JOIN users AS u ON p.user_id = u.id WHERE u.username like :username", nativeQuery = true)
        List<Planner> getPlannersByUser(@Param("username") String username );

        @Query(value = "DELETE planners_contain " +
                "FROM planners_contain " +
                "JOIN planners ON planners_contain.id_planner = planners.id_planner " +
                "JOIN locations ON planners_contain.id_location = locations.id_location " +
                "WHERE planners_contain.id_planner = :plannerId AND planners_contain.id_location = :locationId", nativeQuery = true)
        void deleteLocationFromPlanner(@Param("plannerId") Long plannerId, @Param("locationId") Long locationId);
}