/**
* Set sql file header
*
* @return null
*/
private function _processHeader()
{
$header = '-- Generated by Craft ' . $this->_currentVersion . ' on ' . DateTimeHelper::nice(DateTimeHelper::currentTimeStamp()) . '.' . PHP_EOL . PHP_EOL;
$header .= '--' . PHP_EOL . '-- Disable foreign key checks and autocommit.' . PHP_EOL . '--' . PHP_EOL . PHP_EOL;
$header .= 'SET FOREIGN_KEY_CHECKS = 0;' . PHP_EOL;
$header .= 'SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";' . PHP_EOL;
$header .= 'SET AUTOCOMMIT = 0;' . PHP_EOL;
$header .= 'SET NAMES utf8;' . PHP_EOL . PHP_EOL;
IOHelper::writeToFile($this->_filePath, $header, true, true);
}
/**
* Set sql file header
* @return string
*/
private function _processHeader()
{
$header = '-- Generated by Craft ' . $this->_currentVersion . ' on ' . DateTimeHelper::nice(DateTimeHelper::currentTimeStamp()) . '.' . PHP_EOL . PHP_EOL;
$header .= '--' . PHP_EOL . '-- Disable foreign key checks and autocommit and start a transaction.' . PHP_EOL . '--' . PHP_EOL . PHP_EOL;
$header .= 'SET FOREIGN_KEY_CHECKS = 0;' . PHP_EOL;
$header .= 'SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";' . PHP_EOL;
$header .= 'SET AUTOCOMMIT = 0;' . PHP_EOL;
$header .= 'SET NAMES utf8;' . PHP_EOL;
$header .= 'START TRANSACTION;' . PHP_EOL . PHP_EOL;
$header .= '/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;' . PHP_EOL;
$header .= '/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;' . PHP_EOL;
$header .= '/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;' . PHP_EOL;
$header .= '/*!40101 SET NAMES utf8 */;' . PHP_EOL;
return $header;
}
/**
* Returns a nicely formatted date string for given Datetime string.
*
* @return string
*/
public function nice()
{
return DateTimeHelper::nice($this->getTimestamp());
}
