protected function prepareSql($sql)
    {
        $sql = str_replace(";',", "-CODE-", $sql);
        $sql = trim($sql);
        preg_match_all('#DELIMITER (.+?)\n(.+?)DELIMITER ;#s', $sql, $m);
        foreach ($m[0] as $k => $v) {
            if ($m[1][$k] == '|') {
                throw new \RuntimeException('You can not use "|" as delimiter: '.$v);
            }
            $stored = str_replace(';', '|', $m[2][$k]);
            $stored = str_replace($m[1][$k], ";\n", $stored);
            $sql = str_replace($v, $stored, $sql);
        }
        $query = array();

        $tab = explode(";\n", $sql);
        $size = \count($tab);
        for ($i = 0; $i < $size; $i++) {
            $queryTemp = str_replace("-CODE-", ";',", $tab[$i]);
            $queryTemp = str_replace("|", ";", $queryTemp);
            $query[] = $queryTemp;
        }

        return $query;
    }
protected function prepareSql($sql)
    {
        $sql = str_replace(";',", "-CODE-", $sql);
        $sql = trim($sql);
        preg_match_all('#DELIMITER (.+?)\n(.+?)DELIMITER ;#s', $sql, $m);
        foreach ($m[0] as $k => $v) {
            if ($m[1][$k] == '|') {
                throw new \RuntimeException('You can not use "|" as delimiter: '.$v);
            }
            $stored = str_replace(';', '|', $m[2][$k]);
            $stored = str_replace($m[1][$k], ";\n", $stored);
            $sql = str_replace($v, $stored, $sql);
        }
        $query = array();

        $tab = explode(";\n", $sql);
        $size = \count($tab);
        for ($i = 0; $i < $size; $i++) {
            $queryTemp = str_replace("-CODE-", ";',", $tab[$i]);
            $queryTemp = str_replace("|", ";", $queryTemp);
            $query[] = $queryTemp;
        }

        return $query;
    }
protected function prepareSql ( $ sql ) { $ sql = str_replace ( ";'," , "-CODE-" , $ sql ) ; $ sql = trim ( $ sql ) ; preg_match_all ( '#DELIMITER (.+?)\n(.+?)DELIMITER ;#s' , $ sql , $ m ) ; foreach ( $ m [ 0 ] as $ k => $ v ) { if ( $ m [ 1 ] [ $ k ] == '|' ) { throw new \ RuntimeException ( 'You can not use "|" as delimiter: ' . $ v ) ; } $ stored = str_replace ( ';' , '|' , $ m [ 2 ] [ $ k ] ) ; $ stored = str_replace ( $ m [ 1 ] [ $ k ] , ";\n" , $ stored ) ; $ sql = str_replace ( $ v , $ stored , $ sql ) ; } $ query = array ( ) ; $ tab = explode ( ";\n" , $ sql ) ; $ size = \ count ( $ tab ) ; for ( $ i = 0 ; $ i < $ size ; $ i ++ ) { $ queryTemp = str_replace ( "-CODE-" , ";'," , $ tab [ $ i ] ) ; $ queryTemp = str_replace ( "|" , ";" , $ queryTemp ) ; $ query [ ] = $ queryTemp ; } return $ query ; }
Separate each sql instruction in an array

@param $sql
@return array
Separate each sql instruction in an array