VideoControllerTest.php

public function testMultipleChange1(){
        $video1 = $this->testCase->createTestVideo(9, 'Group');
        $video2 = $this->testCase->createTestVideo(9, 'Group');
        $video3 = $this->testCase->createTestVideo(9, 'Group');

        $multipleUpdate = 'UPDATE video SET order = CASE id ';
        $arr=[];
        $arr[]=$video1;
        $arr[]=$video2;
        $arr[]=$video3;
        $idsStr='';
        foreach($arr as $index => $eachVideo){
            $multipleUpdate .=" WHEN '".$eachVideo->id."' THEN '".$index."' ";
            $id = $eachVideo->id;
            $idsStr.="'$id',";
        }
        if (substr($idsStr, -1, 1) == ',')
        {
            $idsStr = substr($idsStr, 0, -1);
        }
        $multipleUpdate .= "END";
        $multipleUpdate .= "WHERE id IN($idsStr);";
        $multipleUpdate='';

    }