org.apache.ibatis.annotations.Update Java Examples

/**
 * 更新降级点策略
 *
 * @param strategyDO
 * @return
 */
@Update("<script> update point_strategy <set> " +
        " sds_scheme_name = #{newSdsSchemeName}, status = #{status}, operator_name = #{operatorName}, "
        + "operator_email = #{operatorEmail}  " +
        "<if test='visitThreshold != null'> , visit_threshold = #{visitThreshold} </if> " +
        "<if test='concurrentThreshold != null'> , concurrent_threshold = #{concurrentThreshold} </if> " +
        "<if test='exceptionThreshold != null'> , exception_threshold = #{exceptionThreshold} </if> " +
        "<if test='exceptionRateThreshold != null'> , exception_rate_threshold = #{exceptionRateThreshold} </if> " +
        "<if test='exceptionRateStart != null'> , exception_rate_start = #{exceptionRateStart} </if> " +
        "<if test='timeoutThreshold != null'> , timeout_threshold = #{timeoutThreshold} </if> " +
        "<if test='timeoutCountThreshold != null'> , timeout_count_threshold = #{timeoutCountThreshold} </if> " +
        "<if test='tokenBucketGeneratedTokensInSecond != null'> , token_bucket_generated_tokens_in_second = "
        + "#{tokenBucketGeneratedTokensInSecond} </if> " +
        "<if test='tokenBucketSize != null'> , token_bucket_size = #{tokenBucketSize} </if> " +
        "<if test='delayTime != null'> , delay_time = #{delayTime} </if> " +
        "<if test='retryInterval != null'> , retry_interval = #{retryInterval} </if> " +
        "<if test='downgradeRate != null'> , downgrade_rate = #{downgradeRate} </if> " +
        "<if test='pressureTestDowngrade != null'> , pressure_test_downgrade = #{pressureTestDowngrade} </if> " +
        " </set> " +
        " where app_group_name = #{appGroupName}" +
        " and app_name = #{appName}" +
        " and point = #{point}" +
        " and sds_scheme_name = #{sdsSchemeName}" +
        " </script>")
int updatePointStrategy(PointStrategyDO strategyDO);
 

@Update("UPDATE configurationApplications " +
        "SET applicationId=#{newAppId}, applicationVersionId=#{newAppVerId} " +
        "WHERE applicationId=#{appId} AND applicationVersionId=#{appVerId}")
void changeConfigurationsApplication(@Param("appId") Integer oldAppId,
                                     @Param("appVerId") Integer oldAppVerId,
                                     @Param("newAppId") Integer newAppId,
                                     @Param("newAppVerId") Integer newAppVerId);
 

@Update("UPDATE applications " +
        "SET latestVersion = (" +
        "            SELECT id " +
        "            FROM applicationVersions apv1 " +
        "            WHERE apv1.applicationId = applications.id " +
        "            AND mdm_app_version_comparison_index(apv1.version) = " +
        "                (SELECT MAX(mdm_app_version_comparison_index(apv2.version)) " +
        "                 FROM applicationVersions apv2 " +
        "                 WHERE apv2.applicationId = applications.id) " +
        "            LIMIT 1) " +
        "WHERE id = #{id}")
void recalculateLatestVersion(@Param("id") Integer applicationId);
 

@Update("UPDATE configurationApplications " +
        "SET applicationVersionId = #{newId} " +
        "WHERE applicationId = #{appId} " +
        "AND action <> 2 " +
        "AND EXISTS (SELECT 1 " +
        "            FROM configurations " +
        "            WHERE configurations.id = configurationApplications.configurationId " +
        "            AND configurations.autoUpdate IS TRUE)")
int autoUpdateConfigurationsApplication(@Param("appId") Integer applicationId,
                                        @Param("newId") Integer newAppVersionId);
 

@Update("UPDATE configurations " +
        "SET mainAppId = #{newId} " +
        "WHERE configurations.autoUpdate IS TRUE " +
        "AND EXISTS (SELECT 1 FROM applicationVersions " +
        "            WHERE applicationVersions.id = configurations.mainAppId" +
        "            AND applicationVersions.applicationId = #{appId})")
int autoUpdateConfigurationsMainApplication(@Param("appId") Integer applicationId,
                                            @Param("newId") Integer newAppVersionId);
 

@Update("UPDATE configurations " +
        "SET mainAppId = (" +
        "                 SELECT ca.applicationVersionId " +
        "                 FROM configurationApplications ca " +
        "                 INNER JOIN applications apps ON apps.id = ca.applicationId " +
        "                 WHERE ca.configurationId = configurations.id " +
        "                 AND ca.action = 1 " +
        "                 AND apps.pkg = (SELECT apps2.pkg " +
        "                                 FROM applicationVersions av " +
        "                                 INNER JOIN applications apps2 ON apps2.id = av.applicationId " +
        "                                 WHERE av.id = configurations.mainAppId)" +
        ") " +
        "WHERE configurations.customerId = #{customerId} " +
        "AND NOT configurations.mainAppId IS NULL")
int recheckConfigurationMainApplications(@Param("customerId") Integer customerId);
 

@Update("UPDATE configurations " +
        "SET mainAppId = (" +
        "                 SELECT ca.applicationVersionId " +
        "                 FROM configurationApplications ca " +
        "                 INNER JOIN applications apps ON apps.id = ca.applicationId " +
        "                 WHERE ca.configurationId = configurations.id " +
        "                 AND ca.action = 1 " +
        "                 AND apps.pkg = (SELECT apps2.pkg " +
        "                                 FROM applicationVersions av " +
        "                                 INNER JOIN applications apps2 ON apps2.id = av.applicationId " +
        "                                 WHERE av.id = configurations.mainAppId)" +
        ") " +
        "WHERE configurations.id = #{configurationId} " +
        "AND NOT configurations.mainAppId IS NULL")
int recheckConfigurationMainApplication(@Param("configurationId") Integer configurationId);
 

@Update("UPDATE configurations " +
        "SET contentAppId = (" +
        "                 SELECT ca.applicationVersionId " +
        "                 FROM configurationApplications ca " +
        "                 INNER JOIN applications apps ON apps.id = ca.applicationId " +
        "                 WHERE ca.configurationId = configurations.id " +
        "                 AND ca.action = 1 " +
        "                 AND apps.pkg = (SELECT apps2.pkg " +
        "                                 FROM applicationVersions av " +
        "                                 INNER JOIN applications apps2 ON apps2.id = av.applicationId " +
        "                                 WHERE av.id = configurations.contentAppId)" +
        ") " +
        "WHERE configurations.customerId = #{customerId} " +
        "AND NOT configurations.contentAppId IS NULL")
int recheckConfigurationContentApplications(@Param("customerId") Integer customerId);
 

@Update("UPDATE configurations " +
        "SET contentAppId = (" +
        "                 SELECT ca.applicationVersionId " +
        "                 FROM configurationApplications ca " +
        "                 INNER JOIN applications apps ON apps.id = ca.applicationId " +
        "                 WHERE ca.configurationId = configurations.id " +
        "                 AND ca.action = 1 " +
        "                 AND apps.pkg = (SELECT apps2.pkg " +
        "                                 FROM applicationVersions av " +
        "                                 INNER JOIN applications apps2 ON apps2.id = av.applicationId " +
        "                                 WHERE av.id = configurations.contentAppId)" +
        ") " +
        "WHERE configurations.id = #{configurationId} " +
        "AND NOT configurations.contentAppId IS NULL")
int recheckConfigurationContentApplication(@Param("configurationId") Integer configurationId);
 

@Update("UPDATE configurations " +
        "SET contentAppId = #{newId} " +
        "WHERE configurations.autoUpdate IS TRUE " +
        "AND EXISTS (SELECT 1 FROM applicationVersions " +
        "            WHERE applicationVersions.id = configurations.contentAppId" +
        "            AND applicationVersions.applicationId = #{appId})")
int autoUpdateConfigurationsContentApplication(@Param("appId") Integer applicationId,
                                               @Param("newId") Integer newAppVersionId);
 

@Update("INSERT INTO deviceStatuses (deviceId, configFilesStatus, applicationsStatus) " +
        "VALUES (#{deviceId}, #{filesStatus}, #{appsStatus})" +
        "ON CONFLICT ON CONSTRAINT deviceStatuses_pr_key DO " +
        "UPDATE SET configFilesStatus = EXCLUDED.configFilesStatus, applicationsStatus = EXCLUDED.applicationsStatus")
int updateDeviceStatuses(@Param("deviceId") Integer deviceId,
                         @Param("filesStatus") DeviceConfigFilesStatus deviceConfigFilesStatus,
                         @Param("appsStatus") DeviceApplicationsStatus deviceApplicatiosStatus);
 

@Update({"UPDATE configurations SET " +
        "name=#{name}, " +
        "description=#{description}, " +
        "password=#{password}, " +
        "backgroundColor=#{backgroundColor}, " +
        "textColor=#{textColor}, " +
        "backgroundImageUrl=#{backgroundImageUrl}, " +
        "iconSize=#{iconSize}, " +
        "desktopHeader=#{desktopHeader}, " +
        "requestUpdates=#{requestUpdates}, " +
        "pushOptions=#{pushOptions}, " +
        "autoBrightness=#{autoBrightness}, " +
        "brightness=#{brightness}, " +
        "manageTimeout=#{manageTimeout}, " +
        "timeout=#{timeout}, " +
        "lockVolume=#{lockVolume}, " +
        "passwordMode=#{passwordMode}, " +
        "useDefaultDesignSettings=#{useDefaultDesignSettings}, " +
        "gps=#{gps}, " +
        "bluetooth=#{bluetooth}, " +
        "wifi=#{wifi}, " +
        "mobileData=#{mobileData}, " +
        "usbStorage=#{usbStorage}, " +
        "mainAppId=#{mainAppId}, " +
        "contentAppId=#{contentAppId}, " +
        "eventReceivingComponent=#{eventReceivingComponent}, " +
        "kioskMode=#{kioskMode}, " +
        "wifiSSID=#{wifiSSID}, " +
        "wifiPassword=#{wifiPassword}, " +
        "wifiSecurityType=#{wifiSecurityType}, " +
        "autoUpdate=#{autoUpdate}, " +
        "blockStatusBar=#{blockStatusBar}, " +
        "systemUpdateType=#{systemUpdateType}, " +
        "systemUpdateFrom=#{systemUpdateFrom}, " +
        "systemUpdateTo=#{systemUpdateTo} " +
        "WHERE id=#{id}"})
void updateConfiguration(Configuration configuration);
 

@Update("UPDATE plugin_devicelog_settings_rules SET " +
        " settingId = #{settingId}, " +
        " name = #{name}, " +
        " active = #{active}, " +
        " applicationId = #{applicationId}, " +
        " severity = #{severity}, " +
        " filter = #{filter}, " +
        " groupId = #{groupId}, " +
        " configurationId = #{configurationId} " +
        "WHERE id = #{id}")
void updatePluginSettingsRule(PostgresDeviceLogRule rule);
 

@Update("update user set name=#{name},age=#{age}  where id=#{id}")
  //void updataById(@Param("id")String id,@Param("name")String name);
//  void updataById(@Param("id")String id,@Param("name")String name);
int updateById(User user);
 

@Update("update user set name=#{name},age=#{age}  where id=#{id}")
  //void updataById(@Param("id")String id,@Param("name")String name);
//  void updataById(@Param("id")String id,@Param("name")String name);
int updateById(User user);
 

@Update("update store_coupon set use_num=use_num+1 where id=#{id}")
void incUserNum(int id);
 

@Update("update store_member set user_money=user_money-#{money} where id=#{userId}")
int decUserMony(@Param("userId") int userId,@Param("money") double money);
 

@Update("update store_spec_goods_price set store_count=store_count-#{goodsNum} " +
        "where goods_id=#{goodsId} and `key`=#{specKey}")
int decCount(@Param("goodsId") int goodsId,
                @Param("specKey") String specKey,@Param("goodsNum") int goodsNum);
 

@Update("update sys_permission t set t.name = #{name}, t.permission = #{permission}, t.updateTime = #{updateTime} where t.id = #{id}")
int updateByOps(SysPermission sysPermission);
 

@Update("update sys_role t set t.name = #{name} ,t.updateTime = #{updateTime} where t.id = #{id}")
int updateByOps(SysRole sysRole);
 

@Update("update oauth_client_details t set t.client_secret = #{clientSecret},t.client_secret_str = #{clientSecretStr}  where t.id = #{id}")
int update(Client client);
 

@Update("update student set name = #{name}, age = #{age} where id = #{id}")
int update(@Param("name") String name, @Param("age") Integer age, @Param("id") Integer id);
 

@Update("update sys_permission t set t.name = #{name}, t.permission = #{permission}, t.updateTime = #{updateTime} where t.id = #{id}")
int update(SysPermission sysPermission);
 

@Update("update sys_role t set t.name = #{name} ,t.updateTime = #{updateTime} where t.id = #{id}")
int update(SysRole sysRole);
 

@Update("update t_dict_data set is_deleted=1  where dict_code=#{dictCode} ")
void batchDeleteDictDataByDictCode(@Param("dictCode") String dictCode);
 

@Update("update stock set real_stock=real_stock-#{count} where prod_id = #{productId}")
Long deductionStock(@Param("productId") Long productId,@Param("count") int count);
 

@Update({"UPDATE customers SET name=#{name}, description=#{description} WHERE id=#{id} AND master = FALSE"})
void update(Customer customer);
 

@Update("UPDATE customers SET lastLoginTime = #{time} WHERE id = #{id}")
int recordLastLoginTime(@Param("id") int customerId, @Param("time") long time);
 

@Update({"UPDATE applications SET name=#{name}, pkg=#{pkg}, " +
        "showIcon=#{showIcon}, system=#{system}, customerId=#{customerId}, runAfterInstall = #{runAfterInstall}, runAtBoot = #{runAtBoot}, " +
        "type = #{type}, iconText = #{iconText}, iconId = #{iconId} " +
        "WHERE id=#{id}"})
void updateApplication(Application application);
 

@Update({"UPDATE applicationVersions SET version = #{version}, url = #{url}, apkHash = #{apkHash} " +
        "WHERE id=#{id}"})
void updateApplicationVersion(ApplicationVersion applicationVersion);