增加redis通道

648540858

2023-06-27 c7d15150237c946fbb4f5547dab0018a5f573d88

 src/main/java/com/genersoft/iot/vmp/storager/dao/DeviceMapper.java

@@ -42,7 +42,9 @@
            "asMessageChannel," +
            "geoCoordSys," +
            "treeType," +
            "online" +
            "online," +
            "mediaServerId," +
            "(SELECT count(0) FROM device_channel WHERE deviceId=device.deviceId) as channelCount "+
            " FROM device WHERE deviceId = #{deviceId}")
    Device getDeviceByDeviceId(String deviceId);

@@ -159,6 +161,7 @@
            "geoCoordSys," +
            "treeType," +
            "online," +
            "mediaServerId," +
            "(SELECT count(0) FROM device_channel WHERE deviceId=de.deviceId) as channelCount  FROM device de" +
            "<if test=\"online != null\"> where online=${online}</if>"+
            " </script>"
@@ -167,9 +170,6 @@

    @Delete("DELETE FROM device WHERE deviceId=#{deviceId}")
    int del(String deviceId);

    @Update("UPDATE device SET online=0")
    int outlineForAll();

    @Select("SELECT " +
            "deviceId, " +
@@ -255,7 +255,7 @@
            "<if test=\"mediaServerId != null\">, mediaServerId=#{mediaServerId}</if>" +
            "WHERE deviceId=#{deviceId}"+
            " </script>"})
    int updateCustom(Device device);
    void updateCustom(Device device);

    @Insert("INSERT INTO device (" +
            "deviceId, " +
@@ -269,7 +269,8 @@
            "asMessageChannel," +
            "geoCoordSys," +
            "treeType," +
            "online" +
            "online," +
            "mediaServerId" +
            ") VALUES (" +
            "#{deviceId}," +
            "#{name}," +
@@ -282,7 +283,8 @@
            "#{asMessageChannel}," +
            "#{geoCoordSys}," +
            "#{treeType}," +
            "#{online}" +
            "#{online}," +
            "#{mediaServerId}" +
            ")")
    void addCustomDevice(Device device);