|  |  | 
 |  |  |             "(gbStreamId, platformId, catalogId) " + | 
 |  |  |             "values " + | 
 |  |  |             "<foreach collection='streamPushItems' index='index' item='item' separator=','> " + | 
 |  |  |             "(${item.gbStreamId}, '${item.platformId}', '${item.catalogId}')" + | 
 |  |  |             "(#{item.gbStreamId}, #{item.platformId}, #{item.catalogId})" + | 
 |  |  |             "</foreach> " + | 
 |  |  |             "</script>") | 
 |  |  |     int batchAdd(List<StreamPushItem> streamPushItems); | 
 |  |  | 
 |  |  |             "left join platform_gb_stream pgs on " + | 
 |  |  |             "pp.serverGBId = pgs.platformId " + | 
 |  |  |             "left join gb_stream gs " + | 
 |  |  |             "gs.gbStreamId = pgs.gbStreamId " + | 
 |  |  |             "on gs.gbStreamId = pgs.gbStreamId " + | 
 |  |  |             "WHERE " + | 
 |  |  |             "gs.app = #{app} " + | 
 |  |  |             "AND gs.stream = #{stream}" + | 
 |  |  | 
 |  |  |             "</foreach>" + | 
 |  |  |             "</script>") | 
 |  |  |     void delByAppAndStreamsByPlatformId(List<GbStream> gbStreams, String platformId); | 
 |  |  |  | 
 |  |  |     @Delete("DELETE FROM platform_gb_stream WHERE platformId=#{platformId} and catalogId=#{catalogId}") | 
 |  |  |     int delByPlatformAndCatalogId(String platformId, String catalogId); | 
 |  |  | } |