svr-basic/src/main/java/com/yihu/ehr/basic/apps/dao/UserAppDao.java

package com.yihu.ehr.basic.apps.dao;

import com.yihu.ehr.basic.apps.model.UserApp;
import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.Modifying;
import org.springframework.data.jpa.repository.Query;
import org.springframework.data.repository.query.Param;

import java.util.List;

/**
 * @author yeshijie
 * @version 1.0
 * @created 2017年2月16日18:04:13
 */
public interface UserAppDao extends JpaRepository<UserApp, String> {

    @Query("select userApp from UserApp userApp where userApp.appId = :appId and userApp.userId = :userId" )
    UserApp findByAppIdAndUserId(@Param("appId") String appId, @Param("userId") String userId);

    @Modifying
//    @Query("update UserApp userApp set userApp.status = 1 where userApp.userId = :userId")
    void deleteByUserId(@Param("userId") String userId);

    @Modifying
    void deleteByAppId(@Param("appId") String appId);

    @Query("select userApp from UserApp userApp where userApp.appId = :appId " )
    List<UserApp> findByAppId(@Param("appId") String appId);

    @Query("select userApp from UserApp userApp where userApp.userId in (:userIds) " )
    List<UserApp> findByuserId(@Param("userIds") List<String> userIds);
}