| | |
| | | "mediaServerId=#{mediaServerId}," + |
| | | "status=${status} " + |
| | | "WHERE app=#{app} AND stream=#{stream}") |
| | | int updateByAppAndStream(GbStream gbStream); |
| | | |
| | | @Update("UPDATE gb_stream " + |
| | | "SET app=#{app}," + |
| | | "stream=#{stream}," + |
| | | "gbId=#{gbId}," + |
| | | "name=#{name}," + |
| | | "streamType=#{streamType}," + |
| | | "longitude=#{longitude}, " + |
| | | "latitude=#{latitude}," + |
| | | "mediaServerId=#{mediaServerId}," + |
| | | "status=${status} " + |
| | | "WHERE gbStreamId=#{gbStreamId}") |
| | | int update(GbStream gbStream); |
| | | |
| | | @Delete("DELETE FROM gb_stream WHERE app=#{app} AND stream=#{stream}") |
| | |
| | | List<GbStream> selectByGBId(String gbId); |
| | | |
| | | @Select("SELECT gs.*, pgs.platformId as platformId, pgs.catalogId as catalogId FROM gb_stream gs " + |
| | | "LEFT JOIN platform_gb_stream pgs ON gs.gbStreamId = pgs.catalogId " + |
| | | "LEFT JOIN platform_gb_stream pgs ON gs.gbStreamId = pgs.gbStreamId " + |
| | | "WHERE gs.gbId = '${gbId}' AND pgs.platformId = '${platformId}'") |
| | | GbStream queryStreamInPlatform(String platformId, String gbId); |
| | | |