raex_back/src/main/java/com/izouma/nineth/repo/UserRepo.java

package com.izouma.nineth.repo;

import com.izouma.nineth.domain.User;
import com.izouma.nineth.security.Authority;
import org.springframework.cache.annotation.CacheEvict;
import org.springframework.cache.annotation.Cacheable;
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 org.springframework.lang.NonNull;

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

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

    @CacheEvict(value = "user", key = "#user.username", allEntries = true)
    @NonNull
    User save(@NonNull User user);

    @Cacheable("user")
    User findByUsernameAndDelFalse(String username);

    List<User> findAllByAuthoritiesContainsAndDelFalse(Authority authority);

    Optional<User> findByOpenIdAndDelFalse(String openId);

    Optional<User> findByPhoneAndDelFalse(String phone);

    Optional<User> findByIdAndDelFalse(Long userId);

    @Transactional
    @Modifying
    @Query("update User u set u.followers = u.followers + ?1 where u.id = ?1")
    void addFollow(Long userId, int num);

    @Query("select distinct u from User u join Follow f on u.id = f.followUserId " +
            "where f.userId = ?1 and u.del = false ")
    List<User> userFollows(Long userId);

    @Query("select distinct u from User u join Follow f on u.id = f.userId " +
            "where f.followUserId = ?1 and u.del = false ")
    List<User> userFollowers(Long userId);

    @Transactional
    @Modifying
    @Query(value = "update user set follows = (select count(*) from follow " +
            "where follow.user_id = ?1) where user.id = ?1", nativeQuery = true)
    void updateFollows(Long userId);

    @Transactional
    @Modifying
    @Query(value = "update user set followers = (select count(*) from follow " +
            "where follow.follow_user_id = ?1) where user.id = ?1", nativeQuery = true)
    void updateFollowers(Long userId);

    @Transactional
    @Modifying
    @Query(value = "update collection_info join user on collection_info.minter_id = user.id " +
            "set collection_info.minter        = user.nickname, " +
            "    collection_info.minter_avatar = user.avatar " +
            "where user.id = ?1", nativeQuery = true)
    void updateMinterForCollection(Long userId);

    @Transactional
    @Modifying
    @Query(value = "update collection_info join user on collection_info.owner_id = user.id " +
            "set collection_info.owner        = user.nickname, " +
            "    collection_info.owner_avatar = user.avatar " +
            "where user.id = ?1", nativeQuery = true)
    void updateOwnerForCollection(Long userId);

    @Transactional
    @Modifying
    @Query(value = "update order_info join user on order_info.minter_id = user.id " +
            "set order_info.minter        = user.nickname, " +
            "    order_info.minter_avatar = user.avatar " +
            "where user.id = ?1", nativeQuery = true)
    void updateMinterForOrder(Long userId);

    @Transactional
    @Modifying
    @Query(value = "update asset join user on asset.minter_id = user.id " +
            "set asset.minter        = user.nickname, " +
            "    asset.minter_avatar = user.avatar " +
            "where user.id = ?1", nativeQuery = true)
    void updateMinterForAsset(Long userId);

    List<User> findByPhoneInAndDelFalse(Iterable<String> phone);

    List<User> findByIdInAndDelFalse(Iterable<Long> userId);

    @Query(value = "update asset join user on asset.minter_id = user.id " +
            "set asset.minter        = user.nickname, " +
            "    asset.minter_avatar = user.avatar " +
            "where user.id = ?1 ", nativeQuery = true)
    @Modifying
    @Transactional
    void updateAssetMinter(Long userId);

    @Query(value = "update asset join user on asset.owner_id = user.id " +
            "set asset.owner        = user.nickname, " +
            "    asset.owner_avatar = user.avatar " +
            "where user.id = ?1 ", nativeQuery = true)
    @Modifying
    @Transactional
    void updateAssetOwner(Long userId);

    @Query(value = "update collection_info join user on collection_info.minter_id = user.id " +
            "set collection_info.minter        = user.nickname, " +
            "    collection_info.minter_avatar = user.avatar " +
            "where user.id = ?1 ", nativeQuery = true)
    @Modifying
    @Transactional
    void updateCollectionMinter(Long userId);

    @Query(value = "update collection_info join user on collection_info.owner_id = user.id " +
            "set collection_info.owner        = user.nickname, " +
            "    collection_info.owner_avatar = user.avatar " +
            "where user.id = ?1 ", nativeQuery = true)
    @Modifying
    @Transactional
    void updateCollectionOwner(Long userId);

    @Query(value = "update order_info join user on order_info.minter_id = user.id " +
            "set order_info.minter        = user.nickname, " +
            "    order_info.minter_avatar = user.avatar " +
            "where user.id = ?1 ", nativeQuery = true)
    @Modifying
    @Transactional
    void updateOrderMinter(Long userId);

    @Query(value = "update token_history join user on token_history.from_user_id = user.id " +
            "set token_history.from_user        = user.nickname, " +
            "    token_history.from_avatar = user.avatar " +
            "where user.id = ?1 ", nativeQuery = true)
    @Modifying
    @Transactional
    void updateHistoryFromUser(Long userId);

    @Query(value = "update token_history join user on token_history.to_user_id = user.id " +
            "set token_history.to_user        = user.nickname, " +
            "    token_history.to_avatar = user.avatar " +
            "where user.id = ?1 ", nativeQuery = true)
    @Modifying
    @Transactional
    void updateHistoryToUser(Long userId);

    @Transactional
    @Modifying
    @Query("update User u set u.sales = ?2 where u.id = ?1")
    void setSales(Long userId, int sales);

    List<User> findByAuthoritiesContains(Authority authority);

    @Transactional
    @Modifying
    @Query("update User u set u.sales = COALESCE(u.sales, 0) + ?2 where u.id = ?1")
    public void increaseSales(Long id, int num);
}