新增根据mac查询sensor的sql

ZhuDongming

2019-08-06 c00fd90a440e17954791061f4f8ee604cf99ea5b

新增根据mac查询sensor的sql

 src/main/resources/mapper/SensorMapper.xml

@@ -144,4 +144,19 @@
        AND dvs.sensor_id = s.id
        AND d.monitor_point_id = #{monitor_point_id}
    </select>

    <select id="getSensorsByMac" resultMap="BaseResultMap">
        SELECT
        DISTINCT s.*
        FROM
        sensor s,
        device_version_sensor dvs,
        device d
        WHERE
        s.id = dvs.sensor_id
        AND dvs.device_version_id = d.device_version_id
        <if test="mac != null">
            AND d.mac =    #{mac}
        </if>
    </select>
</mapper>