insert into per_video_room
perVideoRoomId,
comVideoRoomId,
cid,
useid,
attendExpoStatus,
startTime,
endTime,
streamId,
fileId,
videoPath,
isSponsor,
#{perVideoRoomId},
#{comVideoRoomId},
#{cid},
#{useid},
#{attendExpoStatus},
#{startTime},
#{endTime},
#{streamId},
#{fileId},
#{videoPath},
#{isSponsor},
INSERT INTO per_video_room(
perVideoRoomId,
comVideoRoomId,
cid,
useid,
attendExpoStatus,
startTime,
endTime,
streamId,
fileId,
videoPath,
isSponsor,
personId,
domainId)
VALUES
(#{item.perVideoRoomId},
#{item.comVideoRoomId},
#{item.cid},
#{item.useid},
#{item.attendExpoStatus},
#{item.startTime},
#{item.endTime},
#{item.streamId},
#{item.fileId},
#{item.videoPath},
#{item.isSponsor},
#{item.personId},
#{item.domainId})
UPDATE per_video_room SET
startTime=#{startTime},
endTime=#{endTime},
streamId=#{streamId},
fileId=#{fileId},
attendExpoStatus=#{attendExpoStatus},
videoPath=#{videoPath}
WHERE perVideoRoomId = #{perVideoRoomId}
UPDATE per_video_room
SET attendExpoStatus=#{Status}
WHERE perVideoRoomId = #{perVideoRoomId}