Package edu.cnm.deepdive.dominionendpointtestspring.model.dao

Interface GameRepository

All Superinterfaces:

org.springframework.data.repository.CrudRepository<Game,java.lang.Long>, org.springframework.data.repository.Repository<Game,java.lang.Long>

@Repository
public interface GameRepository
extends org.springframework.data.repository.CrudRepository<Game,java.lang.Long>

Method Summary

Modifier and Type	Method	Description
java.util.Optional<Game>	findByIdAndPlayer(long gameId, long playerId)
java.util.Optional<Game>	findFirstByCurrentState(GameState state)

Methods inherited from interface org.springframework.data.repository.CrudRepository

count, delete, deleteAll, deleteAll, deleteById, existsById, findAll, findAllById, findById, save, saveAll

Method Detail

findFirstByCurrentState

java.util.Optional<Game> findFirstByCurrentState(GameState state)

findByIdAndPlayer

@Query(value="SELECT DISTINCT * FROM game g INNER JOIN game_player gp ON gp.game_id = g.game_id WHERE g.game_id = :gameId AND gp.player_id = :playerId",
       nativeQuery=true)
java.util.Optional<Game> findByIdAndPlayer(long gameId,
                                           long playerId)