public function create_view($row)
{
$ret = "";
if (!isset($row['Create View'])) {
throw new Exception("Error getting view structure, unknown output");
}
$triggerStmt = $row['Create View'];
$triggerStmtReplaced1 = str_replace("CREATE ALGORITHM", "/*!50001 CREATE ALGORITHM", $triggerStmt);
$triggerStmtReplaced2 = str_replace(" DEFINER=", " */" . PHP_EOL . "/*!50013 DEFINER=", $triggerStmtReplaced1);
$triggerStmtReplaced3 = str_replace(" VIEW ", " */" . PHP_EOL . "/*!50001 VIEW ", $triggerStmtReplaced2);
if (false === $triggerStmtReplaced1 || false === $triggerStmtReplaced2 || false === $triggerStmtReplaced3) {
$triggerStmtReplaced = $triggerStmt;
} else {
$triggerStmtReplaced = $triggerStmtReplaced3 . " */;";
}
$ret .= $triggerStmtReplaced . PHP_EOL . PHP_EOL;
return $ret;
}