9th/src/main/java/com/izouma/nineth/repo/AirDropRepo.java

package com.izouma.nineth.repo;

import com.izouma.nineth.domain.AirDrop;
import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.JpaSpecificationExecutor;
import org.springframework.data.jpa.repository.Modifying;
import org.springframework.data.jpa.repository.Query;

import javax.transaction.Transactional;
import java.util.List;

public interface AirDropRepo extends JpaRepository<AirDrop, Long>, JpaSpecificationExecutor<AirDrop> {
    @Query("update AirDrop t set t.del = true where t.id = ?1")
    @Modifying
    @Transactional
    void softDelete(Long id);


    @Query(nativeQuery = true,value = "select * from air_drop where air_drop.user_ids like ?1 and name like ?2 ")
    List<AirDrop> findAllByUserIdsAndName(String userIds, String name);
}