/** * 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()); }