org.apache.ibatis.annotations.Delete Java Examples

@Delete({"DELETE FROM deviceGroups " +
        "WHERE deviceId=#{deviceId} " +
        "  AND groupId IN ( " +
        "      SELECT groups.id " +
        "      FROM groups " +
        "      INNER JOIN users ON users.id = #{userId} " +
        "      WHERE groups.customerId = #{customerId} " +
        "      AND (users.allDevicesAvailable AND users.customerId = #{customerId} " +
        "           OR " +
        "           EXISTS (SELECT 1 FROM userDeviceGroupsAccess access WHERE groups.id = access.groupId AND access.userId = users.id)" +
        "      )" +
        "  )"})
void removeDeviceGroupsByDeviceId(
        @Param("userId") int userId,
        @Param("customerId") int customerId,
        @Param("deviceId") Integer deviceId);
 

@Delete("DELETE FROM configurationApplications " +
        "WHERE configurationId = #{configurationId} " +
        "AND applicationId IN ( " +
        "            SELECT id FROM applications " +
        "            WHERE pkg = (" +
        "                SELECT pkg " +
        "                FROM applications " +
        "                WHERE id=#{applicationId} " +
        "            ) AND id != #{applicationId} " +
        ")")
int deleteApplicationConfigurationLinksForSamePkg(@Param("applicationId") int applicationId,
                                                  @Param("configurationId") int configurationId);
 

@Delete({"DELETE FROM configurationApplications " +
        "WHERE applicationVersionId=#{id} " +
        "AND configurationId IN (SELECT configurations.id " +
        "                        FROM configurations " +
        "                        WHERE configurations.customerId=#{customerId})"})
void removeApplicationVersionConfigurationsById(@Param("customerId") int customerId,
                                                @Param("id") Integer applicationVersionId);
 

@Delete("delete from tv_series where id=#{id}")
public int delete(int id);
 

@Delete("delete from student where sno=#{sno}")
void deleteStudentBySno(String sno);
 

@Delete("delete from tv_character where id=#{id}")
public int delete(int id);
 

@Delete("delete from person")
public int deleteAll();
 

@Delete("delete from person where id=#{id}")
public int delete(int id);
 

@Delete("delete from t_user where id=#{id}")
void deleteUser(int id);
 

@Delete("delete from tv_character where id=#{id}")
public int delete(int id);
 

@Delete("delete from student where sno=#{sno}")
int deleteBysno(String sno);
 

@Delete("delete from tv_series where id=#{id}")
public int delete(int id);
 

@Delete("delete from user where id=#{id}")
public boolean deleteById(int id);
 

@Delete("DELETE FROM role_binding WHERE role_id = #{roleId} and user_id = #{userId}")
void delete(@Param("roleId") long roleId, @Param("userId") long userId);
 

@Delete("DELETE FROM users WHERE name=#{name}")
void delete(String name);
 

@Delete("delete from log where log_type = #{logType}")
void deleteByLogType(@Param("logType") String logType);
 

/**
 * <p>Deletes the log records which are older than number of days configured in customer's profile.</p>
 *
 * @return a number of deleted records.
 */
@Delete("DELETE FROM plugin_devicelog_log " +
        "WHERE createTime < (SELECT EXTRACT(EPOCH FROM DATE_TRUNC('day', NOW() - (pds.logsPreservePeriod || ' day')::INTERVAL)) * 1000 " +
        "                    FROM plugin_devicelog_settings pds " +
        "                    WHERE pds.customerId = plugin_devicelog_log.customerId)")
int purgeLogRecords();
 

@Delete("delete from role where id=#{id}")
public boolean deleteOne(int id);
 

@Delete("delete from illust_history where create_at < (SELECT DATE_ADD(now(),INTERVAL -3 MONTH))")
void deleteIllustHistory();
 

@Delete("DELETE FROM plugin_devicelog_settings_rules WHERE id = #{id}")
void deletePluginSettingRule(@Param("id") int id);
 

@Delete("DELETE FROM pluginsDisabled WHERE customerId = #{customerId}")
int cleanUpDisabledPlugins(@Param("customerId") int customerId);
 

@Delete("delete from jurisdiction where id=#{id}")
public boolean deleteOne(int id);
 

@Delete("DELETE FROM uploadedFiles WHERE id = #{id}")
void deleteFile(@Param("id") int fileId);
 

@Delete("delete from user where id=#{id}")
void deleteById(@Param("id")String id);
 

@Delete("delete from tv_character where id=#{id}")
public int delete(int id);
 

@Delete({"DELETE FROM configurationApplications WHERE configurationId=#{id}"})
void removeConfigurationApplicationsById(@Param("id") Integer id);
 

@Delete({"DELETE FROM configurations WHERE id=#{id}"})
void removeConfigurationById(@Param("id") Integer id);
 

@Delete("DELETE FROM deviceApplicationSettings WHERE extRefId = #{id}")
void deleteDeviceApplicationSettings(@Param("id") Integer deviceId);
 

@Delete({"DELETE FROM groups WHERE id = #{id}"})
void removeGroupById(@Param("id") Integer id);
 

@Delete({"DELETE FROM devices WHERE id = #{id}"})
void removeDevice(@Param("id") Integer id);