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.Subscription;
8
import telegramBot.enums.SubscriptionStatus;
9

10
import java.util.List;
11

12
public interface SubscriptionCrudRepository extends CrudRepository<Subscription, Long> {
13
    @Query("SELECT s FROM Subscription s WHERE s.language =:language")
14
    @EntityGraph(attributePaths = "orders", type = EntityGraph.EntityGraphType.LOAD)
15
    Subscription getByLanguage(@Param("language") String language);
16

17
    @Query("SELECT s FROM Subscription s WHERE s.status =:status")
18
    @EntityGraph(attributePaths = "orders", type = EntityGraph.EntityGraphType.LOAD)
19
    List<Subscription> getAllByStatus(@Param("status") SubscriptionStatus status);
20

21
}
22