TournamentRepository.java

package net.olemartin.repository;

import net.olemartin.domain.Tournament;
import net.olemartin.domain.view.TournamentView;
import org.springframework.data.neo4j.annotation.Query;
import org.springframework.data.neo4j.repository.GraphRepository;
import org.springframework.data.repository.query.Param;
import org.springframework.stereotype.Repository;

import java.util.List;

@Repository
public interface TournamentRepository extends GraphRepository<Tournament> {

    @Query("MATCH (p1:Player) -[:PLAYS_IN]- (t:Tournament)\n" +
            "where id(p1) = {who}\n" +
            "return t")
    Tournament findPlayersTournament(@Param("who") long playerId);

    @Query("MATCH (t:Tournament) " +
            "RETURN id(t) as id, t.name as name, t.finished as finished")
    List<TournamentView> retrieveAllTournaments();
}