FreelanceBot

1
package telegramBot.repository.datajpa;
2

3
import org.springframework.data.jpa.repository.EntityGraph;
4
import org.springframework.data.jpa.repository.Query;
5
import org.springframework.data.repository.CrudRepository;
6
import org.springframework.data.repository.query.Param;
7
import telegramBot.entity.Exchange;
8

9
public interface ExchangeCrudRepository extends CrudRepository<Exchange, Long> {
10
    @Query("SELECT COUNT(e) FROM Exchange e WHERE e.name =:name")
11
    int existByName(@Param("name") String name);
12
    @Query("SELECT e FROM Exchange e WHERE e.name =:name")
13
    @EntityGraph(attributePaths = "orders", type = EntityGraph.EntityGraphType.LOAD)
14
    Exchange getByName(@Param("name") String name);
15
}
16