package dev5.lavishek.trains.dao;

import dev5.lavishek.trains.entity.Ticket;
import java.time.LocalDate;
import java.util.List;
import org.springframework.data.jpa.repository.Query;
import org.springframework.data.repository.CrudRepository;
import org.springframework.data.repository.query.Param;
import org.springframework.stereotype.Repository;

@Repository
public interface TicketRepository extends CrudRepository<Ticket, Integer> {

  @Query(value = "SELECT ticket "
      + "FROM Ticket ticket "
      + "WHERE ((ticket.train.id =:idTrain) AND (ticket.dateDeparture=:departure))")
  List<Ticket> getTicketsByTrainAndDate(@Param("idTrain") Integer idTrain,
      @Param("departure") LocalDate dateDeparture);

}

package dev5.lavishek.trains.dao;

import org.junit.jupiter.api.AfterEach;
import org.junit.jupiter.api.BeforeEach;
import org.junit.jupiter.api.Test;
import org.junit.runner.RunWith;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.boot.test.autoconfigure.orm.jpa.DataJpaTest;
import org.springframework.boot.test.autoconfigure.orm.jpa.TestEntityManager;
import org.springframework.test.context.junit4.SpringRunner;


@RunWith(SpringRunner.class)
@DataJpaTest
class TicketRepositoryTest {

  @Autowired
  private TestEntityManager entityManager;
  @Autowired
  private TicketRepository repository;

  @BeforeEach
  void setUp() {
    repository.findAll();

  }

  @AfterEach
  void tearDown() {
  }

  @Test
  void getTicketsByTrainAndDate() {

  }

}

spring.datasource.url=jdbc:h2:file:C:\Users\Alexander\YandexDisk\NetCracker\TrainsProject\database\database
spring.datasource.username=admin
spring.datasource.password=1234
spring.jpa.show-sql=true
spring.jpa.hibernate.ddl-auto=update
spring.jpa.properties.hibernate.dialect=org.hibernate.dialect.H2Dialect