@Modifying @Query("UPDATE Role SET IsDeleted=1, DataChange_LastModifiedBy = ?2 WHERE Id in ?1") Integer batchDelete(List<Long> roleIds, String operator); }
@Modifying @Query("UPDATE Permission SET IsDeleted=1, DataChange_LastModifiedBy = ?2 WHERE Id in ?1") Integer batchDelete(List<Long> permissionIds, String operator); }
@Modifying @Query("UPDATE RolePermission SET IsDeleted=1, DataChange_LastModifiedBy = ?2 WHERE PermissionId in ?1") Integer batchDeleteByPermissionIds(List<Long> permissionIds, String operator); }
@Modifying @Query("UPDATE AppNamespace SET IsDeleted=1,DataChange_LastModifiedBy = ?3 WHERE AppId=?1 and Name = ?2") int delete(String appId, String namespaceName, String operator); }
@Modifying @Query("UPDATE AppNamespace SET IsDeleted=1,DataChange_LastModifiedBy = ?3 WHERE AppId=?1 and Name = ?2") int delete(String appId, String namespaceName, String operator); }
@Modifying @Query("UPDATE Favorite SET IsDeleted=1,DataChange_LastModifiedBy = ?2 WHERE AppId=?1") int batchDeleteByAppId(String appId, String operator); }
@Modifying @Query("UPDATE ConsumerRole SET IsDeleted=1, DataChange_LastModifiedBy = ?2 WHERE RoleId in ?1") Integer batchDeleteByRoleIds(List<Long> roleIds, String operator); }
@Modifying @Query("UPDATE App SET IsDeleted=1,DataChange_LastModifiedBy = ?2 WHERE AppId=?1") int deleteApp(String appId, String operator); }
@Modifying @Query("update Commit set isdeleted=1,DataChange_LastModifiedBy = ?4 where appId=?1 and clusterName=?2 and namespaceName = ?3") int batchDelete(String appId, String clusterName, String namespaceName, String operator);
@Modifying @Query("update Release set isdeleted=1,DataChange_LastModifiedBy = ?4 where appId=?1 and clusterName=?2 and namespaceName = ?3") int batchDelete(String appId, String clusterName, String namespaceName, String operator);
@Modifying @Query("UPDATE AppNamespace SET IsDeleted=1,DataChange_LastModifiedBy = ?2 WHERE AppId=?1") int batchDeleteByAppId(String appId, String operator);
@Modifying @Query("update Item set isdeleted=1,DataChange_LastModifiedBy = ?2 where namespaceId = ?1") int deleteByNamespaceId(long namespaceId, String operator);
@Modifying @Query("UPDATE AppNamespace SET IsDeleted=1,DataChange_LastModifiedBy=?2 WHERE AppId=?1") int batchDeleteByAppId(String appId, String operator);
@Modifying @Query("UPDATE UserRole SET IsDeleted=1, DataChange_LastModifiedBy = ?2 WHERE RoleId in ?1") Integer batchDeleteByRoleIds(List<Long> roleIds, String operator);
@Modifying @Query("update ReleaseHistory set isdeleted=1,DataChange_LastModifiedBy = ?4 where appId=?1 and clusterName=?2 and namespaceName = ?3") int batchDelete(String appId, String clusterName, String namespaceName, String operator);
@Modifying @Query("delete from InstanceConfig where ConfigAppId=?1 and ConfigClusterName=?2 and ConfigNamespaceName = ?3") int batchDelete(String appId, String clusterName, String namespaceName);
@Modifying @Query("update Namespace set isdeleted=1,DataChange_LastModifiedBy = ?3 where appId=?1 and clusterName=?2") int batchDelete(String appId, String clusterName, String operator);
/** * Here we demonstrate the use of SecurityContext information in dynamic SpEL parameters in a JPQL update statement. */ @Modifying(clearAutomatically = true) @Query("update BusinessObject b set b.data = upper(b.data), b.lastModifiedBy = :#{#security.principal}, b.lastModifiedDate = :#{new java.util.Date()}") void modifiyDataWithRecordingSecurityContext(); }
@Transactional @Modifying(clearAutomatically = true) @Query("UPDATE TxTimeout t " + "SET t.status = 'DONE' " + "WHERE t.status != 'DONE' AND EXISTS (" + " SELECT t1.globalTxId FROM TxEvent t1 " + " WHERE t1.globalTxId = t.globalTxId " + " AND t1.localTxId = t.localTxId " + " AND t1.type != t.type" + ")") void updateStatusOfFinishedTx(); }
@Transactional @Modifying @Query(value = "INSERT INTO master_lock " + "(serviceName, expireTime, lockedTime, instanceId) " + "VALUES " + "(?1, ?2, ?3, ?4)", nativeQuery = true) int initLock( @Param("serviceName") String serviceName, @Param("expireTime") Date expireTime, @Param("lockedTime") Date lockedTime, @Param("instanceId") String instanceId);