Package io.kadai.task.internal

Interface AttachmentMapper

public interface AttachmentMapper
This class is the mybatis mapping of Attachment.

  • Method Details

    • insert

      @Insert("INSERT INTO ATTACHMENT (ID, TASK_ID, CREATED, MODIFIED, CLASSIFICATION_KEY, CLASSIFICATION_ID, REF_COMPANY, REF_SYSTEM, REF_INSTANCE, REF_TYPE, REF_VALUE, CHANNEL, RECEIVED, CUSTOM_ATTRIBUTES) VALUES (#{att.id}, #{att.taskId}, #{att.created}, #{att.modified}, #{att.classificationSummary.key}, #{att.classificationSummary.id}, #{att.objectReferenceImpl.company}, #{att.objectReferenceImpl.system}, #{att.objectReferenceImpl.systemInstance}, #{att.objectReferenceImpl.type}, #{att.objectReferenceImpl.value}, #{att.channel}, #{att.received}, #{att.customAttributes,jdbcType=CLOB,javaType=java.util.Map,typeHandler=io.kadai.common.internal.persistence.MapTypeHandler} )") void insert(@Param("att") AttachmentImpl att)

    • findAttachmentsByTaskId

      @Select("<script> SELECT ID, TASK_ID, CREATED, MODIFIED, CLASSIFICATION_KEY, CLASSIFICATION_ID, REF_COMPANY, REF_SYSTEM, REF_INSTANCE, REF_TYPE, REF_VALUE, CHANNEL, RECEIVED, CUSTOM_ATTRIBUTES FROM ATTACHMENT WHERE TASK_ID = #{taskId} <if test=\"_databaseId == \'db2\'\">with UR </if> </script>") @Result(property="id",column="ID") @Result(property="taskId",column="TASK_ID") @Result(property="created",column="CREATED") @Result(property="modified",column="MODIFIED") @Result(property="classificationSummaryImpl.key",column="CLASSIFICATION_KEY") @Result(property="classificationSummaryImpl.id",column="CLASSIFICATION_ID") @Result(property="objectReferenceImpl.company",column="REF_COMPANY") @Result(property="objectReferenceImpl.system",column="REF_SYSTEM") @Result(property="objectReferenceImpl.systemInstance",column="REF_INSTANCE") @Result(property="objectReferenceImpl.type",column="REF_TYPE") @Result(property="objectReferenceImpl.value",column="REF_VALUE") @Result(property="channel",column="CHANNEL") @Result(property="received",column="RECEIVED") @Result(property="customAttributes",column="CUSTOM_ATTRIBUTES",javaType=java.util.Map.class,typeHandler=io.kadai.common.internal.persistence.MapTypeHandler.class) List<AttachmentImpl> findAttachmentsByTaskId(@Param("taskId") String taskId)

    • findAttachmentSummariesByTaskIds

      @Select("<script>SELECT ID, TASK_ID, CREATED, MODIFIED, CLASSIFICATION_KEY, CLASSIFICATION_ID, REF_COMPANY, REF_SYSTEM, REF_INSTANCE, REF_TYPE, REF_VALUE, CHANNEL, RECEIVED FROM ATTACHMENT <where><choose><when test=\'taskIds == null\'> 1 = 2 </when><otherwise>TASK_ID IN (<foreach collection=\'taskIds\' item=\'item\' separator=\',\' >#{item}</foreach>) </otherwise></choose></where><if test=\"_databaseId == \'db2\'\">with UR </if> </script>") @Result(property="id",column="ID") @Result(property="taskId",column="TASK_ID") @Result(property="created",column="CREATED") @Result(property="modified",column="MODIFIED") @Result(property="classificationSummaryImpl.key",column="CLASSIFICATION_KEY") @Result(property="classificationSummaryImpl.id",column="CLASSIFICATION_ID") @Result(property="objectReferenceImpl.company",column="REF_COMPANY") @Result(property="objectReferenceImpl.system",column="REF_SYSTEM") @Result(property="objectReferenceImpl.systemInstance",column="REF_INSTANCE") @Result(property="objectReferenceImpl.type",column="REF_TYPE") @Result(property="objectReferenceImpl.value",column="REF_VALUE") @Result(property="channel",column="CHANNEL") @Result(property="received",column="RECEIVED") List<AttachmentSummaryImpl> findAttachmentSummariesByTaskIds(@Param("taskIds") Collection<String> taskIds)

    • delete

      @Delete("DELETE FROM ATTACHMENT WHERE ID=#{attachmentId}") void delete(@Param("attachmentId") String attachmentId)

    • deleteMultipleByTaskIds

      @Delete("<script>DELETE FROM ATTACHMENT WHERE TASK_ID IN(<foreach item=\'item\' collection=\'taskIds\' separator=\',\' >#{item}</foreach>)</script>") void deleteMultipleByTaskIds(@Param("taskIds") List<String> taskIds)

    • update

      @Update("UPDATE ATTACHMENT SET TASK_ID = #{taskId}, CREATED = #{created}, MODIFIED = #{modified}, CLASSIFICATION_KEY = #{classificationSummary.key}, CLASSIFICATION_ID = #{classificationSummary.id}, REF_COMPANY = #{objectReferenceImpl.company}, REF_SYSTEM = #{objectReferenceImpl.system}, REF_INSTANCE = #{objectReferenceImpl.systemInstance}, REF_TYPE = #{objectReferenceImpl.type}, REF_VALUE = #{objectReferenceImpl.value}, CHANNEL = #{channel}, RECEIVED = #{received}, CUSTOM_ATTRIBUTES = #{customAttributes,jdbcType=CLOB,javaType=java.util.Map,typeHandler=io.kadai.common.internal.persistence.MapTypeHandler} WHERE ID = #{id}") void update(AttachmentImpl attachment)

    • getCustomAttributesAsString

      @Select("<script> select CUSTOM_ATTRIBUTES from ATTACHMENT where id = #{attachmentId}<if test=\"_databaseId == \'db2\'\">with UR </if> </script>") @Result(property="customAttributes", column="CUSTOM_ATTRIBUTES", javaType=java.lang.String.class, typeHandler=org.apache.ibatis.type.ClobTypeHandler.class) String getCustomAttributesAsString(@Param("attachmentId") String attachmentId)

    • findTaskIdsAndPlannedAffectedByClassificationChange

      @Select("<script> SELECT DISTINCT t.ID, t.PLANNED FROM TASK t LEFT JOIN ATTACHMENT a on a.TASK_ID = t.ID WHERE a.CLASSIFICATION_ID = #{classificationId} <if test=\"_databaseId == \'db2\'\">with UR </if> </script>") @Result(property="left",column="ID") @Result(property="right",column="PLANNED") List<io.kadai.common.internal.util.Pair<String,Instant>> findTaskIdsAndPlannedAffectedByClassificationChange(@Param("classificationId") String classificationId)