| | |
| | | <resultMap type="YwThreshold" id="YwThresholdResult"> |
| | | <result property="id" column="id"/> |
| | | <result property="monitorType" column="monitor_type"/> |
| | | <result property="timeout" column="timeout"/> |
| | | <result property="indicator" column="indicator"/> |
| | | <result property="createTime" column="create_time"/> |
| | | <result property="updateTime" column="update_time"/> |
| | | <result property="deleted" column="deleted"/> |
| | | </resultMap> |
| | | |
| | | <sql id="selectYwThresholdVo"> |
| | | select id, monitor_type, timeout, indicator, create_time, update_time, deleted |
| | | select id, monitor_type, create_time, update_time, deleted |
| | | from t_yw_threshold |
| | | </sql> |
| | | |
| | |
| | | insert into t_yw_threshold |
| | | <trim prefix="(" suffix=")" suffixOverrides=","> |
| | | <if test="monitorType != null and monitorType != ''">monitor_type,</if> |
| | | <if test="timeout != null">timeout,</if> |
| | | <if test="indicator != null">indicator,</if> |
| | | <if test="createTime != null">create_time,</if> |
| | | <if test="updateTime != null">update_time,</if> |
| | | <if test="deleted != null">deleted,</if> |
| | | </trim> |
| | | <trim prefix="values (" suffix=")" suffixOverrides=","> |
| | | <if test="monitorType != null and monitorType != ''">#{monitorType},</if> |
| | | <if test="timeout != null">#{timeout},</if> |
| | | <if test="indicator != null">#{indicator},</if> |
| | | <if test="createTime != null">#{createTime},</if> |
| | | <if test="updateTime != null">#{updateTime},</if> |
| | | <if test="deleted != null">#{deleted},</if> |
| | |
| | | update t_yw_threshold |
| | | <trim prefix="SET" suffixOverrides=","> |
| | | <if test="monitorType != null and monitorType != ''">monitor_type = #{monitorType},</if> |
| | | <if test="timeout != null">timeout = #{timeout},</if> |
| | | <if test="indicator != null">indicator = #{indicator},</if> |
| | | <if test="createTime != null">create_time = #{createTime},</if> |
| | | <if test="updateTime != null">update_time = #{updateTime},</if> |
| | | <if test="deleted != null">deleted = #{deleted},</if> |