/*
 * Copyright 2018-2024 adorsys GmbH & Co KG
 *
 * This program is free software: you can redistribute it and/or modify it
 * under the terms of the GNU Affero General Public License as published
 * by the Free Software Foundation, either version 3 of the License, or (at
 * your option) any later version. This program is distributed in the hope that
 * it will be useful, but WITHOUT ANY WARRANTY; without even the implied
 * warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.
 * See the GNU Affero General Public License for more details.
 *
 * You should have received a copy of the GNU Affero General Public License
 * along with this program. If not, see https://www.gnu.org/licenses/.
 *
 * This project is also available under a separate commercial license. You can
 * contact us at sales@adorsys.com.
 */

package de.adorsys.psd2.consent.repository;

import de.adorsys.psd2.consent.domain.AuthorisationEntity;
import de.adorsys.psd2.xs2a.core.authorisation.AuthorisationType;
import org.springframework.data.domain.Pageable;
import org.springframework.data.jpa.repository.JpaSpecificationExecutor;
import org.springframework.data.jpa.repository.Modifying;
import org.springframework.data.jpa.repository.Query;
import org.springframework.data.repository.CrudRepository;
import org.springframework.data.repository.query.Param;

import java.util.List;
import java.util.Optional;
import java.util.Set;

public interface AuthorisationRepository extends CrudRepository<AuthorisationEntity, Long>, JpaSpecificationExecutor<AuthorisationEntity> {

    Optional<AuthorisationEntity> findByExternalId(String externalId);

    Optional<AuthorisationEntity> findByExternalIdAndType(String externalId,
                                                          AuthorisationType authorisationType);

    List<AuthorisationEntity> findAllByParentExternalIdAndType(String parentExternalId,
                                                               AuthorisationType authorisationType);

    List<AuthorisationEntity> findAllByParentExternalIdAndType(String parentExternalId,
                                                               AuthorisationType authorisationType,
                                                               Pageable pageable);

    List<AuthorisationEntity> findAllByParentExternalIdAndTypeIn(String parentExternalId,
                                                                 Set<AuthorisationType> authorisationTypes);

    List<AuthorisationEntity> findAllByParentExternalIdAndTypeIn(String parentExternalId,
                                                                 Set<AuthorisationType> authorisationTypes,
                                                                 Pageable pageable);

    @Query("UPDATE authorisation SET scaStatus='FAILED' WHERE type = 'CONSENT' AND parentExternalId IN :consentIds")
    @Modifying
    void updateAuthorisationByConsentIds(@Param("consentIds") List<String> consentIds);
}
