package by.bsuir.mpp.computershop.repository;

import by.bsuir.mpp.computershop.entity.Provider;
import org.springframework.data.domain.Page;
import org.springframework.data.domain.Pageable;
import org.springframework.data.repository.PagingAndSortingRepository;

public interface ProviderRepository extends PagingAndSortingRepository<Provider, Long> {

    Page<Provider> findAllByRemovedIsFalse(Pageable pageable);

    Page<Provider> findAllByRemovedIsTrue(Pageable pageable);
}

@@ -220,136 +220,442 @@
 ata.
-repository.PagingAndSortingRepository;%0A%0Apublic interface ProviderRepository extends PagingAndSortingRepository%3CProvider, Long%3E %7B
+jpa.repository.Modifying;%0Aimport org.springframework.data.jpa.repository.Query;%0Aimport org.springframework.data.repository.PagingAndSortingRepository;%0Aimport org.springframework.data.repository.query.Param;%0A%0Apublic interface ProviderRepository extends PagingAndSortingRepository%3CProvider, Long%3E %7B%0A%0A    @Override%0A    @Modifying%0A    @Query(value = %22CALL remove_provider(:id);%22, nativeQuery = true)%0A    void delete(@Param(%22id%22) Long id);
 %0A%0A  

Update ProviderRepository