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.User;
8

9
import java.util.List;
10

11
public interface UserCrudRepository extends CrudRepository<User, Long> {
12
    @Query("SELECT u FROM User u WHERE u.chatId =:chat_id")
13
    @EntityGraph(attributePaths = "subscriptions", type = EntityGraph.EntityGraphType.LOAD)
14
    User getByChatId(@Param("chat_id") String chatId);
15
    @Query("SELECT u FROM User u WHERE u.active = true")
16
    @EntityGraph(attributePaths = "subscriptions", type = EntityGraph.EntityGraphType.LOAD)
17
    List<User> getAllActive();
18
}
19