org.springframework.data.jpa.repository.Modifying Java Examples

@Modifying
@Query(
        "update ModuleInfo set gmtModified =  :#{#moduleInfo.gmtModified}" +
                " where appName =  :#{#moduleInfo.appName}" +
                " and ip = :#{#moduleInfo.ip}"
)
int updateByAppNameAndIp(@Param("moduleInfo") ModuleInfo moduleInfo);
 

@Modifying
@Transactional
public void updateRoleMenu(int rid, Map<String, List<Integer>> menusIds) {
    adminRoleMenuDAO.deleteAllByRid(rid);
    List<AdminRoleMenu> rms = new ArrayList<>();
    for (Integer mid : menusIds.get("menusIds")) {
        AdminRoleMenu rm = new AdminRoleMenu();
        rm.setMid(mid);
        rm.setRid(rid);
        rms.add(rm);
    }

    adminRoleMenuDAO.saveAll(rms);
}
 

@Transactional
@Modifying 
@Query(
    value = "UPDATE RSS_FEED " +
            "SET    RSS_SITE = ?2 " +
            "WHERE  RSS_SITE = ?1 "
  , nativeQuery = true)
public void updateByRssSite(String oriRssSite, String trgRssSite);
 

@Transactional
@Modifying(clearAutomatically = true)
@Query("UPDATE org.apache.servicecomb.saga.alpha.core.TxTimeout t "
    + "SET t.status = :status "
    + "WHERE t.globalTxId = :globalTxId "
    + "  AND t.localTxId = :localTxId")
void updateStatusByGlobalTxIdAndLocalTxId(
    @Param("status") String status,
    @Param("globalTxId") String globalTxId,
    @Param("localTxId") String localTxId);
 

@Transactional
@Modifying(clearAutomatically = true)
@Query("UPDATE org.apache.servicecomb.saga.alpha.core.Command c "
    + "SET c.status = :toStatus "
    + "WHERE c.globalTxId = :globalTxId "
    + "  AND c.localTxId = :localTxId "
    + "  AND c.status = :fromStatus")
void updateStatusByGlobalTxIdAndLocalTxId(
    @Param("fromStatus") String fromStatus,
    @Param("toStatus") String toStatus,
    @Param("globalTxId") String globalTxId,
    @Param("localTxId") String localTxId);
 

@Transactional
@Modifying
@Query("UPDATE TxEventAddition T SET T.compensateStatus = 1 WHERE T.instanceId = ?1 AND T.globalTxId = ?2 AND T.localTxId = ?3 AND T.compensateStatus = 0")
int updateCompensateStatus(String instanceId, String globalTxId, String localTxId);
 

@Modifying
@Transactional
@Query(value = "delete from t_tx_gas_data t where t.group_id = ?1 and t.timestamp < ?2",
        nativeQuery = true)
public int deleteTimeAgo(int groupId, Long time);
 

@Modifying
@Query("DELETE FROM Note n WHERE n.featured = ?1 AND n.id IN ?2")
void bulkDeleteByFeatured(boolean featured, Set<Long> id);
 

@Modifying
@Transactional
@Query(value = "delete from Monitor m where m.timestamp< ?1", nativeQuery = true)
public int deleteTimeAgo(Long time);
 

@Transactional
@Modifying
@Query(value="UPDATE member_wallet SET balance=balance-:normalBalance,frozen_balance=frozen_balance+:normalBalance where coin_id=:coinId AND member_id=:memberId",nativeQuery = true)
int updateMemberWalletByMemberIdAndCoinId(@Param("normalBalance")BigDecimal normalBalance,@Param("coinId")String coinId,@Param("memberId")long memberId);
 

@Modifying
@Query("delete from SysAttachFileSlice where fdSliceSummaryId = ?1")
void deleteBySummaryId(String summaryId);
 

@Modifying
@Query("UPDATE Note n SET n.title = ?1 WHERE n.id IN ?2")
int bulkUpdateTitle(String title, Set<Long> id);
 

@Modifying
@Transactional
@Query(value = "delete from CallOutNames where orgi = ?1 and batid = ?2")
public abstract void deleteByOrgiAndBatid(String orgi , String batid ) ;
 

@Modifying
@Query("update Advertise a set a.status=?1 where a.id=?2 and a.member.id=?3 and a.status<>?4")
int updateAdvertiseStatus(AdvertiseControlStatus status, Long id, Long mid, AdvertiseControlStatus advertiseControlStatus);
 

@Transactional
@Modifying
@Query(nativeQuery = true,value = "delete from t_sys_relation where roleid=?1")
int deleteByRoleId(Long roleId);
 

@Modifying
@Query("update ExchangeOrder  exchange set exchange.status = :status where exchange.orderId = :orderId")
int updateStatus(@Param("orderId") String orderId, @Param("status") ExchangeOrderStatus status);
 

@Transactional
@Modifying
@Query("DELETE FROM BusinessDBLatestDetail T WHERE T.timestamp < ?1 AND T.node = ?2 AND T.dbschema = ?3")
int deleteHistoryInfo(long timestamp, String node, String dbSchema);
 

@Modifying
@Transactional
@Query(value = "delete from CallOutNames where orgi = ?1 and dataid = ?2")
public abstract void deleteByOrgiAndDataid(String orgi , String dataid ) ;
 

@Transactional
@Modifying
@Query(value = "insert INTO member_wallet_:weekDay SELECT * FROM member_wallet",nativeQuery = true)
int createWeekTable(@Param("weekDay")int weekDay);
 

@Modifying
@Transactional
@Query(nativeQuery = true,value = "delete from t_sys_login_log")
int clear();
 

@Transactional
@Modifying
@Query(value = "delete from t_permission where broker_id =:brokerId", nativeQuery = true)
void deletePermissionByBrokerId(@Param("brokerId") Integer brokerId);
 

@Transactional
@Modifying
@Query(value="UPDATE member_wallet SET balance=balance+:teamBalance where coin_id = 'BHB' AND member_id=:teamId",nativeQuery = true)
int updateTeamWallet(@Param("teamBalance")BigDecimal teamBalance,@Param("teamId")long teamId);
 

@Transactional
@Modifying
@Query(nativeQuery = true,value = "delete from t_sys_relation where roleid=?1")
int deleteByRoleId(Long roleId);
 

@Modifying
@Transactional
@Query(nativeQuery = true,value = "delete from t_sys_relation where menuid=?1")
void deleteRelationByMenu(Long menuId);
 

@Modifying(clearAutomatically = true)
@Query("update Account account set account.email = :email, account.confirmedAndActive = true where account.id = :id")
@Transactional
int updateEmailAndActivateById(@Param("email") String email, @Param("id") String id);
 

@Transactional
@Modifying
@Query(value = "update t_topic set delete_at=:deleteAt  where broker_id =:brokerId", nativeQuery = true)
void deleteByBrokerId(@Param("brokerId") Integer brokerId, @Param("deleteAt") Long deleteAt);
 

@Transactional
@Modifying(clearAutomatically = true)
@Query(value = "DELETE FROM txle_sample_merchant WHERE id = ?1", nativeQuery = true)
int deleteById(@Param("merchantid") long merchantid);
 

@Modifying
@Query("update Advertise a set a.status = :status,a.updateTime=:updateTime where a.id in :ids")
int alterStatusBatch(@Param("status")AdvertiseControlStatus status,@Param("updateTime")Date updateTime,@Param("ids")Long[] ids) ;
 

@Transactional
@Modifying
@Query(value = "update t_rule_engine  set status=2 , delete_at=:deleteAt where id =:id", nativeQuery = true)
void deleteRuleEngine(@Param("id") Integer id, @Param("deleteAt") Long deleteAt);
 

@Transactional
@Modifying
@Query(value = "delete from  #{#entityName} where block_height >= ?1 and block_height< ?2", nativeQuery = true)
public void rollback(long startBlockHeight, long endBlockHeight);