<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper
        PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
        "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.upyuns.platform.rs.website.mapper.ServiceCapabilityMapper">

    <resultMap id="BaseResultMap" type="com.upyuns.platform.rs.website.entity.ServiceCapability">
            <id property="id" column="id" jdbcType="INTEGER"/>
            <result property="computingPower" column="computing_power" jdbcType="DECIMAL"/>
            <result property="dataVolume" column="data_volume" jdbcType="DECIMAL"/>
            <result property="dataSet" column="data_set" jdbcType="INTEGER"/>
            <result property="libraryData" column="Library_data" jdbcType="DECIMAL"/>
            <result property="storageCapacity" column="storage_capacity" jdbcType="DECIMAL"/>
            <result property="dataCount" column="data_count" jdbcType="INTEGER"/>
            <result property="status" column="status" jdbcType="TINYINT"/>
            <result property="isDel" column="is_del" jdbcType="TINYINT"/>
            <result property="createTime" column="create_time" jdbcType="TIMESTAMP"/>
            <result property="createUser" column="create_user" jdbcType="BIGINT"/>
            <result property="lastUpdateTime" column="last_update_time" jdbcType="TIMESTAMP"/>
            <result property="lastUpdateUser" column="last_update_user" jdbcType="BIGINT"/>
    </resultMap>

    <sql id="Base_Column_List">
        id,computing_power,data_volume,
        data_set,Library_data,storage_capacity,
        data_count,status,is_del,
        create_time,create_user,last_update_time,
        last_update_user
    </sql>
    <select id="selectList" resultType="com.upyuns.platform.rs.website.entity.ServiceCapability">
        SELECT
            *
        FROM
            service_capability
        WHERE
            is_del = 0
        <if test="status != null">
            AND `status` = #{status}
        </if>
        ORDER BY create_time,id desc
    </select>
</mapper>
