FreelanceBot

1
package telegramBot.repository.datajpa;
2

3
import org.springframework.data.jpa.repository.Modifying;
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.Order;
8

9
import java.time.LocalDate;
10
import java.util.List;
11

12
public interface OrderCrudRepository extends CrudRepository<Order, Long> {
13

14
    @Query("SELECT COUNT(o) FROM Order o WHERE o.link =:link")
15
    int existByLink(@Param("link") String link);
16
    @Modifying
17
    @Query("DELETE FROM Order o WHERE o.exchange.id IN (SELECT e.id FROM Exchange e " +
18
            "WHERE e.name =:exchange) and o.initDate <=:date")
19
    int deleteByExchangeAndDate(@Param("exchange") String exchange, @Param("date") LocalDate date);
20
    @Modifying
21
    @Query("DELETE FROM Order o WHERE o.id =:id")
22
    int delete(long id);
23
    @Query("SELECT o FROM Order o WHERE o.subscription.language =:language ORDER BY o.id DESC")
24
    List<Order> getAllByLanguage(String language);
25
    @Query("SELECT COUNT(o) FROM Order o WHERE o.title =:title")
26
    int existByTitle(@Param("title") String title);
27

28
}
29