1:  2:  3:  4:  5:  6:  7:  8:  9: 10: 11: 12: 13: 14: 15: 16: 17: 18: 19: 20: 21: 22: 23: 24: 25: 26: 27: 28: 29: 30: 31: 32: 33: 34: 35: 36: 37: 38: 39: 40: 41: 42: 43: 44: 45: 46: 47: 48: 49: 50: 51: 52: 53: 54: 55: 56: 57: 58: 59: 60: 61: 62: 63: 64: 65: 66: 67: 68: 69: 70: 71: 72: 73: 

<?php

    namespace CzProject\SqlGenerator\Drivers;

    use CzProject\SqlGenerator\IDriver;


    class MysqlDriver implements IDriver
    {
        /**
         * @param  string
         * @return string
         */
        public function escapeIdentifier($value)
        {
            // @see http://dev.mysql.com/doc/refman/5.0/en/identifiers.html
            // @see http://api.dibiphp.com/2.3.2/source-drivers.DibiMySqlDriver.php.html#307
            return '`' . str_replace('`', '``', $value) . '`';
        }


        /**
         * @param  string
         * @return string
         */
        public function escapeText($value)
        {
            // https://dev.mysql.com/doc/refman/5.5/en/string-literals.html
            // http://us3.php.net/manual/en/function.mysql-real-escape-string.php#101248
            return '\'' . str_replace(
                array('\\', "\0", "\n", "\r", "\t", "'", '"', "\x1a"),
                array('\\\\', '\\0', '\\n', '\\r', '\\t', "\\'", '\\"', '\\Z'),
                $value
            ) . '\'';
        }


        /**
         * @param  bool
         * @return string
         */
        public function escapeBool($value)
        {
            return $value ? '1' : '0';
        }


        /**
         * @param  string|\DateTime
         * @return string
         */
        public function escapeDate($value)
        {
            if (!($value instanceof \DateTime) && !($value instanceof \DateTimeInterface)) {
                $value = new \DateTime($value);
            }
            return $value->format("'Y-m-d'");
        }


        /**
         * @param  string|\DateTime
         * @return string
         */
        public function escapeDateTime($value)
        {
            if (!($value instanceof \DateTime) && !($value instanceof \DateTimeInterface)) {
                $value = new \DateTime($value);
            }
            return $value->format("'Y-m-d H:i:s'");
        }
    }