<?php

/*
 * THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS
 * "AS IS" AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT
 * LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR
 * A PARTICULAR PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL THE COPYRIGHT
 * OWNER OR CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL,
 * SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT
 * LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF USE,
 * DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY
 * THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT
 * (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE
 * OF THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.
 *
 * This software consists of voluntary contributions made by many individuals
 * and is licensed under the MIT license. For more information, see
 * <http://www.doctrine-project.org>.
 */
namespace MailPoetVendor\Doctrine\DBAL\Platforms;

if (!defined('ABSPATH')) exit;


use MailPoetVendor\Doctrine\DBAL\DBALException;
use MailPoetVendor\Doctrine\DBAL\Connection;
use MailPoetVendor\Doctrine\DBAL\Schema\Identifier;
use MailPoetVendor\Doctrine\DBAL\Types;
use MailPoetVendor\Doctrine\DBAL\Schema\Constraint;
use MailPoetVendor\Doctrine\DBAL\Schema\Sequence;
use MailPoetVendor\Doctrine\DBAL\Schema\Table;
use MailPoetVendor\Doctrine\DBAL\Schema\Index;
use MailPoetVendor\Doctrine\DBAL\Schema\ForeignKeyConstraint;
use MailPoetVendor\Doctrine\DBAL\Schema\TableDiff;
use MailPoetVendor\Doctrine\DBAL\Schema\Column;
use MailPoetVendor\Doctrine\DBAL\Schema\ColumnDiff;
use MailPoetVendor\Doctrine\DBAL\Types\Type;
use MailPoetVendor\Doctrine\DBAL\Events;
use MailPoetVendor\Doctrine\Common\EventManager;
use MailPoetVendor\Doctrine\DBAL\Event\SchemaCreateTableEventArgs;
use MailPoetVendor\Doctrine\DBAL\Event\SchemaCreateTableColumnEventArgs;
use MailPoetVendor\Doctrine\DBAL\Event\SchemaDropTableEventArgs;
use MailPoetVendor\Doctrine\DBAL\Event\SchemaAlterTableEventArgs;
use MailPoetVendor\Doctrine\DBAL\Event\SchemaAlterTableAddColumnEventArgs;
use MailPoetVendor\Doctrine\DBAL\Event\SchemaAlterTableRemoveColumnEventArgs;
use MailPoetVendor\Doctrine\DBAL\Event\SchemaAlterTableChangeColumnEventArgs;
use MailPoetVendor\Doctrine\DBAL\Event\SchemaAlterTableRenameColumnEventArgs;
/**
 * Base class for all DatabasePlatforms. The DatabasePlatforms are the central
 * point of abstraction of platform-specific behaviors, features and SQL dialects.
 * They are a passive source of information.
 *
 * @link   www.doctrine-project.org
 * @since  2.0
 * @author Guilherme Blanco <guilhermeblanco@hotmail.com>
 * @author Jonathan Wage <jonwage@gmail.com>
 * @author Roman Borschel <roman@code-factory.org>
 * @author Lukas Smith <smith@pooteeweet.org> (PEAR MDB2 library)
 * @author Benjamin Eberlei <kontakt@beberlei.de>
 * @todo   Remove any unnecessary methods.
 */
abstract class AbstractPlatform
{
    /**
     * @var integer
     */
    const CREATE_INDEXES = 1;
    /**
     * @var integer
     */
    const CREATE_FOREIGNKEYS = 2;
    /**
     * @var string
     */
    const DATE_INTERVAL_UNIT_SECOND = 'SECOND';
    /**
     * @var string
     */
    const DATE_INTERVAL_UNIT_MINUTE = 'MINUTE';
    /**
     * @var string
     */
    const DATE_INTERVAL_UNIT_HOUR = 'HOUR';
    /**
     * @var string
     */
    const DATE_INTERVAL_UNIT_DAY = 'DAY';
    /**
     * @var string
     */
    const DATE_INTERVAL_UNIT_WEEK = 'WEEK';
    /**
     * @var string
     */
    const DATE_INTERVAL_UNIT_MONTH = 'MONTH';
    /**
     * @var string
     */
    const DATE_INTERVAL_UNIT_QUARTER = 'QUARTER';
    /**
     * @var string
     */
    const DATE_INTERVAL_UNIT_YEAR = 'YEAR';
    /**
     * @var integer
     */
    const TRIM_UNSPECIFIED = 0;
    /**
     * @var integer
     */
    const TRIM_LEADING = 1;
    /**
     * @var integer
     */
    const TRIM_TRAILING = 2;
    /**
     * @var integer
     */
    const TRIM_BOTH = 3;
    /**
     * @var array|null
     */
    protected $doctrineTypeMapping = null;
    /**
     * Contains a list of all columns that should generate parseable column comments for type-detection
     * in reverse engineering scenarios.
     *
     * @var array|null
     */
    protected $doctrineTypeComments = null;
    /**
     * @var \MailPoetVendor\Doctrine\Common\EventManager
     */
    protected $_eventManager;
    /**
     * Holds the KeywordList instance for the current platform.
     *
     * @var \MailPoetVendor\Doctrine\DBAL\Platforms\Keywords\KeywordList
     */
    protected $_keywords;
    /**
     * Constructor.
     */
    public function __construct()
    {
    }
    /**
     * Sets the EventManager used by the Platform.
     *
     * @param \MailPoetVendor\Doctrine\Common\EventManager $eventManager
     */
    public function setEventManager(\MailPoetVendor\Doctrine\Common\EventManager $eventManager)
    {
        $this->_eventManager = $eventManager;
    }
    /**
     * Gets the EventManager used by the Platform.
     *
     * @return \MailPoetVendor\Doctrine\Common\EventManager
     */
    public function getEventManager()
    {
        return $this->_eventManager;
    }
    /**
     * Returns the SQL snippet that declares a boolean column.
     *
     * @param array $columnDef
     *
     * @return string
     */
    public abstract function getBooleanTypeDeclarationSQL(array $columnDef);
    /**
     * Returns the SQL snippet that declares a 4 byte integer column.
     *
     * @param array $columnDef
     *
     * @return string
     */
    public abstract function getIntegerTypeDeclarationSQL(array $columnDef);
    /**
     * Returns the SQL snippet that declares an 8 byte integer column.
     *
     * @param array $columnDef
     *
     * @return string
     */
    public abstract function getBigIntTypeDeclarationSQL(array $columnDef);
    /**
     * Returns the SQL snippet that declares a 2 byte integer column.
     *
     * @param array $columnDef
     *
     * @return string
     */
    public abstract function getSmallIntTypeDeclarationSQL(array $columnDef);
    /**
     * Returns the SQL snippet that declares common properties of an integer column.
     *
     * @param array $columnDef
     *
     * @return string
     */
    protected abstract function _getCommonIntegerTypeDeclarationSQL(array $columnDef);
    /**
     * Lazy load Doctrine Type Mappings.
     *
     * @return void
     */
    protected abstract function initializeDoctrineTypeMappings();
    /**
     * Initializes Doctrine Type Mappings with the platform defaults
     * and with all additional type mappings.
     *
     * @return void
     */
    private function initializeAllDoctrineTypeMappings()
    {
        $this->initializeDoctrineTypeMappings();
        foreach (\MailPoetVendor\Doctrine\DBAL\Types\Type::getTypesMap() as $typeName => $className) {
            foreach (\MailPoetVendor\Doctrine\DBAL\Types\Type::getType($typeName)->getMappedDatabaseTypes($this) as $dbType) {
                $this->doctrineTypeMapping[$dbType] = $typeName;
            }
        }
    }
    /**
     * Returns the SQL snippet used to declare a VARCHAR column type.
     *
     * @param array $field
     *
     * @return string
     */
    public function getVarcharTypeDeclarationSQL(array $field)
    {
        if (!isset($field['length'])) {
            $field['length'] = $this->getVarcharDefaultLength();
        }
        $fixed = isset($field['fixed']) ? $field['fixed'] : \false;
        if ($field['length'] > $this->getVarcharMaxLength()) {
            return $this->getClobTypeDeclarationSQL($field);
        }
        return $this->getVarcharTypeDeclarationSQLSnippet($field['length'], $fixed);
    }
    /**
     * Returns the SQL snippet used to declare a BINARY/VARBINARY column type.
     *
     * @param array $field The column definition.
     *
     * @return string
     */
    public function getBinaryTypeDeclarationSQL(array $field)
    {
        if (!isset($field['length'])) {
            $field['length'] = $this->getBinaryDefaultLength();
        }
        $fixed = isset($field['fixed']) ? $field['fixed'] : \false;
        if ($field['length'] > $this->getBinaryMaxLength()) {
            return $this->getBlobTypeDeclarationSQL($field);
        }
        return $this->getBinaryTypeDeclarationSQLSnippet($field['length'], $fixed);
    }
    /**
     * Returns the SQL snippet to declare a GUID/UUID field.
     *
     * By default this maps directly to a CHAR(36) and only maps to more
     * special datatypes when the underlying databases support this datatype.
     *
     * @param array $field
     *
     * @return string
     */
    public function getGuidTypeDeclarationSQL(array $field)
    {
        $field['length'] = 36;
        $field['fixed'] = \true;
        return $this->getVarcharTypeDeclarationSQL($field);
    }
    /**
     * Returns the SQL snippet to declare a JSON field.
     *
     * By default this maps directly to a CLOB and only maps to more
     * special datatypes when the underlying databases support this datatype.
     *
     * @param array $field
     *
     * @return string
     */
    public function getJsonTypeDeclarationSQL(array $field)
    {
        return $this->getClobTypeDeclarationSQL($field);
    }
    /**
     * @param integer $length
     * @param boolean $fixed
     *
     * @return string
     *
     * @throws \MailPoetVendor\Doctrine\DBAL\DBALException If not supported on this platform.
     */
    protected function getVarcharTypeDeclarationSQLSnippet($length, $fixed)
    {
        throw \MailPoetVendor\Doctrine\DBAL\DBALException::notSupported('VARCHARs not supported by Platform.');
    }
    /**
     * Returns the SQL snippet used to declare a BINARY/VARBINARY column type.
     *
     * @param integer $length The length of the column.
     * @param boolean $fixed  Whether the column length is fixed.
     *
     * @return string
     *
     * @throws \MailPoetVendor\Doctrine\DBAL\DBALException If not supported on this platform.
     */
    protected function getBinaryTypeDeclarationSQLSnippet($length, $fixed)
    {
        throw \MailPoetVendor\Doctrine\DBAL\DBALException::notSupported('BINARY/VARBINARY column types are not supported by this platform.');
    }
    /**
     * Returns the SQL snippet used to declare a CLOB column type.
     *
     * @param array $field
     *
     * @return string
     */
    public abstract function getClobTypeDeclarationSQL(array $field);
    /**
     * Returns the SQL Snippet used to declare a BLOB column type.
     *
     * @param array $field
     *
     * @return string
     */
    public abstract function getBlobTypeDeclarationSQL(array $field);
    /**
     * Gets the name of the platform.
     *
     * @return string
     */
    public abstract function getName();
    /**
     * Registers a doctrine type to be used in conjunction with a column type of this platform.
     *
     * @param string $dbType
     * @param string $doctrineType
     *
     * @throws \MailPoetVendor\Doctrine\DBAL\DBALException If the type is not found.
     */
    public function registerDoctrineTypeMapping($dbType, $doctrineType)
    {
        if ($this->doctrineTypeMapping === null) {
            $this->initializeAllDoctrineTypeMappings();
        }
        if (!\MailPoetVendor\Doctrine\DBAL\Types\Type::hasType($doctrineType)) {
            throw \MailPoetVendor\Doctrine\DBAL\DBALException::typeNotFound($doctrineType);
        }
        $dbType = \strtolower($dbType);
        $this->doctrineTypeMapping[$dbType] = $doctrineType;
    }
    /**
     * Gets the Doctrine type that is mapped for the given database column type.
     *
     * @param string $dbType
     *
     * @return string
     *
     * @throws \MailPoetVendor\Doctrine\DBAL\DBALException
     */
    public function getDoctrineTypeMapping($dbType)
    {
        if ($this->doctrineTypeMapping === null) {
            $this->initializeAllDoctrineTypeMappings();
        }
        $dbType = \strtolower($dbType);
        if (!isset($this->doctrineTypeMapping[$dbType])) {
            throw new \MailPoetVendor\Doctrine\DBAL\DBALException("Unknown database type " . $dbType . " requested, " . \get_class($this) . " may not support it.");
        }
        return $this->doctrineTypeMapping[$dbType];
    }
    /**
     * Checks if a database type is currently supported by this platform.
     *
     * @param string $dbType
     *
     * @return boolean
     */
    public function hasDoctrineTypeMappingFor($dbType)
    {
        if ($this->doctrineTypeMapping === null) {
            $this->initializeAllDoctrineTypeMappings();
        }
        $dbType = \strtolower($dbType);
        return isset($this->doctrineTypeMapping[$dbType]);
    }
    /**
     * Initializes the Doctrine Type comments instance variable for in_array() checks.
     *
     * @return void
     */
    protected function initializeCommentedDoctrineTypes()
    {
        $this->doctrineTypeComments = array();
        foreach (\MailPoetVendor\Doctrine\DBAL\Types\Type::getTypesMap() as $typeName => $className) {
            $type = \MailPoetVendor\Doctrine\DBAL\Types\Type::getType($typeName);
            if ($type->requiresSQLCommentHint($this)) {
                $this->doctrineTypeComments[] = $typeName;
            }
        }
    }
    /**
     * Is it necessary for the platform to add a parsable type comment to allow reverse engineering the given type?
     *
     * @param \MailPoetVendor\Doctrine\DBAL\Types\Type $doctrineType
     *
     * @return boolean
     */
    public function isCommentedDoctrineType(\MailPoetVendor\Doctrine\DBAL\Types\Type $doctrineType)
    {
        if ($this->doctrineTypeComments === null) {
            $this->initializeCommentedDoctrineTypes();
        }
        return \in_array($doctrineType->getName(), $this->doctrineTypeComments);
    }
    /**
     * Marks this type as to be commented in ALTER TABLE and CREATE TABLE statements.
     *
     * @param string|\Doctrine\DBAL\Types\Type $doctrineType
     *
     * @return void
     */
    public function markDoctrineTypeCommented($doctrineType)
    {
        if ($this->doctrineTypeComments === null) {
            $this->initializeCommentedDoctrineTypes();
        }
        $this->doctrineTypeComments[] = $doctrineType instanceof \MailPoetVendor\Doctrine\DBAL\Types\Type ? $doctrineType->getName() : $doctrineType;
    }
    /**
     * Gets the comment to append to a column comment that helps parsing this type in reverse engineering.
     *
     * @param \MailPoetVendor\Doctrine\DBAL\Types\Type $doctrineType
     *
     * @return string
     */
    public function getDoctrineTypeComment(\MailPoetVendor\Doctrine\DBAL\Types\Type $doctrineType)
    {
        return '(DC2Type:' . $doctrineType->getName() . ')';
    }
    /**
     * Gets the comment of a passed column modified by potential doctrine type comment hints.
     *
     * @param \MailPoetVendor\Doctrine\DBAL\Schema\Column $column
     *
     * @return string
     */
    protected function getColumnComment(\MailPoetVendor\Doctrine\DBAL\Schema\Column $column)
    {
        $comment = $column->getComment();
        if ($this->isCommentedDoctrineType($column->getType())) {
            $comment .= $this->getDoctrineTypeComment($column->getType());
        }
        return $comment;
    }
    /**
     * Gets the character used for identifier quoting.
     *
     * @return string
     */
    public function getIdentifierQuoteCharacter()
    {
        return '"';
    }
    /**
     * Gets the string portion that starts an SQL comment.
     *
     * @return string
     */
    public function getSqlCommentStartString()
    {
        return "--";
    }
    /**
     * Gets the string portion that ends an SQL comment.
     *
     * @return string
     */
    public function getSqlCommentEndString()
    {
        return "\n";
    }
    /**
     * Gets the maximum length of a varchar field.
     *
     * @return integer
     */
    public function getVarcharMaxLength()
    {
        return 4000;
    }
    /**
     * Gets the default length of a varchar field.
     *
     * @return integer
     */
    public function getVarcharDefaultLength()
    {
        return 255;
    }
    /**
     * Gets the maximum length of a binary field.
     *
     * @return integer
     */
    public function getBinaryMaxLength()
    {
        return 4000;
    }
    /**
     * Gets the default length of a binary field.
     *
     * @return integer
     */
    public function getBinaryDefaultLength()
    {
        return 255;
    }
    /**
     * Gets all SQL wildcard characters of the platform.
     *
     * @return array
     */
    public function getWildcards()
    {
        return array('%', '_');
    }
    /**
     * Returns the regular expression operator.
     *
     * @return string
     *
     * @throws \MailPoetVendor\Doctrine\DBAL\DBALException If not supported on this platform.
     */
    public function getRegexpExpression()
    {
        throw \MailPoetVendor\Doctrine\DBAL\DBALException::notSupported(__METHOD__);
    }
    /**
     * Returns the global unique identifier expression.
     *
     * @return string
     *
     * @throws \MailPoetVendor\Doctrine\DBAL\DBALException If not supported on this platform.
     */
    public function getGuidExpression()
    {
        throw \MailPoetVendor\Doctrine\DBAL\DBALException::notSupported(__METHOD__);
    }
    /**
     * Returns the SQL snippet to get the average value of a column.
     *
     * @param string $column The column to use.
     *
     * @return string Generated SQL including an AVG aggregate function.
     */
    public function getAvgExpression($column)
    {
        return 'AVG(' . $column . ')';
    }
    /**
     * Returns the SQL snippet to get the number of rows (without a NULL value) of a column.
     *
     * If a '*' is used instead of a column the number of selected rows is returned.
     *
     * @param string|integer $column The column to use.
     *
     * @return string Generated SQL including a COUNT aggregate function.
     */
    public function getCountExpression($column)
    {
        return 'COUNT(' . $column . ')';
    }
    /**
     * Returns the SQL snippet to get the highest value of a column.
     *
     * @param string $column The column to use.
     *
     * @return string Generated SQL including a MAX aggregate function.
     */
    public function getMaxExpression($column)
    {
        return 'MAX(' . $column . ')';
    }
    /**
     * Returns the SQL snippet to get the lowest value of a column.
     *
     * @param string $column The column to use.
     *
     * @return string Generated SQL including a MIN aggregate function.
     */
    public function getMinExpression($column)
    {
        return 'MIN(' . $column . ')';
    }
    /**
     * Returns the SQL snippet to get the total sum of a column.
     *
     * @param string $column The column to use.
     *
     * @return string Generated SQL including a SUM aggregate function.
     */
    public function getSumExpression($column)
    {
        return 'SUM(' . $column . ')';
    }
    // scalar functions
    /**
     * Returns the SQL snippet to get the md5 sum of a field.
     *
     * Note: Not SQL92, but common functionality.
     *
     * @param string $column
     *
     * @return string
     */
    public function getMd5Expression($column)
    {
        return 'MD5(' . $column . ')';
    }
    /**
     * Returns the SQL snippet to get the length of a text field.
     *
     * @param string $column
     *
     * @return string
     */
    public function getLengthExpression($column)
    {
        return 'LENGTH(' . $column . ')';
    }
    /**
     * Returns the SQL snippet to get the squared value of a column.
     *
     * @param string $column The column to use.
     *
     * @return string Generated SQL including an SQRT aggregate function.
     */
    public function getSqrtExpression($column)
    {
        return 'SQRT(' . $column . ')';
    }
    /**
     * Returns the SQL snippet to round a numeric field to the number of decimals specified.
     *
     * @param string  $column
     * @param integer $decimals
     *
     * @return string
     */
    public function getRoundExpression($column, $decimals = 0)
    {
        return 'ROUND(' . $column . ', ' . $decimals . ')';
    }
    /**
     * Returns the SQL snippet to get the remainder of the division operation $expression1 / $expression2.
     *
     * @param string $expression1
     * @param string $expression2
     *
     * @return string
     */
    public function getModExpression($expression1, $expression2)
    {
        return 'MOD(' . $expression1 . ', ' . $expression2 . ')';
    }
    /**
     * Returns the SQL snippet to trim a string.
     *
     * @param string         $str  The expression to apply the trim to.
     * @param integer        $pos  The position of the trim (leading/trailing/both).
     * @param string|boolean $char The char to trim, has to be quoted already. Defaults to space.
     *
     * @return string
     */
    public function getTrimExpression($str, $pos = self::TRIM_UNSPECIFIED, $char = \false)
    {
        $expression = '';
        switch ($pos) {
            case self::TRIM_LEADING:
                $expression = 'LEADING ';
                break;
            case self::TRIM_TRAILING:
                $expression = 'TRAILING ';
                break;
            case self::TRIM_BOTH:
                $expression = 'BOTH ';
                break;
        }
        if (\false !== $char) {
            $expression .= $char . ' ';
        }
        if ($pos || \false !== $char) {
            $expression .= 'FROM ';
        }
        return 'TRIM(' . $expression . $str . ')';
    }
    /**
     * Returns the SQL snippet to trim trailing space characters from the expression.
     *
     * @param string $str Literal string or column name.
     *
     * @return string
     */
    public function getRtrimExpression($str)
    {
        return 'RTRIM(' . $str . ')';
    }
    /**
     * Returns the SQL snippet to trim leading space characters from the expression.
     *
     * @param string $str Literal string or column name.
     *
     * @return string
     */
    public function getLtrimExpression($str)
    {
        return 'LTRIM(' . $str . ')';
    }
    /**
     * Returns the SQL snippet to change all characters from the expression to uppercase,
     * according to the current character set mapping.
     *
     * @param string $str Literal string or column name.
     *
     * @return string
     */
    public function getUpperExpression($str)
    {
        return 'UPPER(' . $str . ')';
    }
    /**
     * Returns the SQL snippet to change all characters from the expression to lowercase,
     * according to the current character set mapping.
     *
     * @param string $str Literal string or column name.
     *
     * @return string
     */
    public function getLowerExpression($str)
    {
        return 'LOWER(' . $str . ')';
    }
    /**
     * Returns the SQL snippet to get the position of the first occurrence of substring $substr in string $str.
     *
     * @param string          $str      Literal string.
     * @param string          $substr   Literal string to find.
     * @param integer|boolean $startPos Position to start at, beginning of string by default.
     *
     * @return string
     *
     * @throws \MailPoetVendor\Doctrine\DBAL\DBALException If not supported on this platform.
     */
    public function getLocateExpression($str, $substr, $startPos = \false)
    {
        throw \MailPoetVendor\Doctrine\DBAL\DBALException::notSupported(__METHOD__);
    }
    /**
     * Returns the SQL snippet to get the current system date.
     *
     * @return string
     */
    public function getNowExpression()
    {
        return 'NOW()';
    }
    /**
     * Returns a SQL snippet to get a substring inside an SQL statement.
     *
     * Note: Not SQL92, but common functionality.
     *
     * SQLite only supports the 2 parameter variant of this function.
     *
     * @param string       $value  An sql string literal or column name/alias.
     * @param integer      $from   Where to start the substring portion.
     * @param integer|null $length The substring portion length.
     *
     * @return string
     */
    public function getSubstringExpression($value, $from, $length = null)
    {
        if ($length === null) {
            return 'SUBSTRING(' . $value . ' FROM ' . $from . ')';
        }
        return 'SUBSTRING(' . $value . ' FROM ' . $from . ' FOR ' . $length . ')';
    }
    /**
     * Returns a SQL snippet to concatenate the given expressions.
     *
     * Accepts an arbitrary number of string parameters. Each parameter must contain an expression.
     *
     * @return string
     */
    public function getConcatExpression()
    {
        return \join(' || ', \func_get_args());
    }
    /**
     * Returns the SQL for a logical not.
     *
     * Example:
     * <code>
     * $q = new Doctrine_Query();
     * $e = $q->expr;
     * $q->select('*')->from('table')
     *   ->where($e->eq('id', $e->not('null'));
     * </code>
     *
     * @param string $expression
     *
     * @return string The logical expression.
     */
    public function getNotExpression($expression)
    {
        return 'NOT(' . $expression . ')';
    }
    /**
     * Returns the SQL that checks if an expression is null.
     *
     * @param string $expression The expression that should be compared to null.
     *
     * @return string The logical expression.
     */
    public function getIsNullExpression($expression)
    {
        return $expression . ' IS NULL';
    }
    /**
     * Returns the SQL that checks if an expression is not null.
     *
     * @param string $expression The expression that should be compared to null.
     *
     * @return string The logical expression.
     */
    public function getIsNotNullExpression($expression)
    {
        return $expression . ' IS NOT NULL';
    }
    /**
     * Returns the SQL that checks if an expression evaluates to a value between two values.
     *
     * The parameter $expression is checked if it is between $value1 and $value2.
     *
     * Note: There is a slight difference in the way BETWEEN works on some databases.
     * http://www.w3schools.com/sql/sql_between.asp. If you want complete database
     * independence you should avoid using between().
     *
     * @param string $expression The value to compare to.
     * @param string $value1     The lower value to compare with.
     * @param string $value2     The higher value to compare with.
     *
     * @return string The logical expression.
     */
    public function getBetweenExpression($expression, $value1, $value2)
    {
        return $expression . ' BETWEEN ' . $value1 . ' AND ' . $value2;
    }
    /**
     * Returns the SQL to get the arccosine of a value.
     *
     * @param string $value
     *
     * @return string
     */
    public function getAcosExpression($value)
    {
        return 'ACOS(' . $value . ')';
    }
    /**
     * Returns the SQL to get the sine of a value.
     *
     * @param string $value
     *
     * @return string
     */
    public function getSinExpression($value)
    {
        return 'SIN(' . $value . ')';
    }
    /**
     * Returns the SQL to get the PI value.
     *
     * @return string
     */
    public function getPiExpression()
    {
        return 'PI()';
    }
    /**
     * Returns the SQL to get the cosine of a value.
     *
     * @param string $value
     *
     * @return string
     */
    public function getCosExpression($value)
    {
        return 'COS(' . $value . ')';
    }
    /**
     * Returns the SQL to calculate the difference in days between the two passed dates.
     *
     * Computes diff = date1 - date2.
     *
     * @param string $date1
     * @param string $date2
     *
     * @return string
     *
     * @throws \MailPoetVendor\Doctrine\DBAL\DBALException If not supported on this platform.
     */
    public function getDateDiffExpression($date1, $date2)
    {
        throw \MailPoetVendor\Doctrine\DBAL\DBALException::notSupported(__METHOD__);
    }
    /**
     * Returns the SQL to add the number of given seconds to a date.
     *
     * @param string  $date
     * @param integer $seconds
     *
     * @return string
     *
     * @throws \MailPoetVendor\Doctrine\DBAL\DBALException If not supported on this platform.
     */
    public function getDateAddSecondsExpression($date, $seconds)
    {
        return $this->getDateArithmeticIntervalExpression($date, '+', $seconds, self::DATE_INTERVAL_UNIT_SECOND);
    }
    /**
     * Returns the SQL to subtract the number of given seconds from a date.
     *
     * @param string  $date
     * @param integer $seconds
     *
     * @return string
     *
     * @throws \MailPoetVendor\Doctrine\DBAL\DBALException If not supported on this platform.
     */
    public function getDateSubSecondsExpression($date, $seconds)
    {
        return $this->getDateArithmeticIntervalExpression($date, '-', $seconds, self::DATE_INTERVAL_UNIT_SECOND);
    }
    /**
     * Returns the SQL to add the number of given minutes to a date.
     *
     * @param string  $date
     * @param integer $minutes
     *
     * @return string
     *
     * @throws \MailPoetVendor\Doctrine\DBAL\DBALException If not supported on this platform.
     */
    public function getDateAddMinutesExpression($date, $minutes)
    {
        return $this->getDateArithmeticIntervalExpression($date, '+', $minutes, self::DATE_INTERVAL_UNIT_MINUTE);
    }
    /**
     * Returns the SQL to subtract the number of given minutes from a date.
     *
     * @param string  $date
     * @param integer $minutes
     *
     * @return string
     *
     * @throws \MailPoetVendor\Doctrine\DBAL\DBALException If not supported on this platform.
     */
    public function getDateSubMinutesExpression($date, $minutes)
    {
        return $this->getDateArithmeticIntervalExpression($date, '-', $minutes, self::DATE_INTERVAL_UNIT_MINUTE);
    }
    /**
     * Returns the SQL to add the number of given hours to a date.
     *
     * @param string  $date
     * @param integer $hours
     *
     * @return string
     *
     * @throws \MailPoetVendor\Doctrine\DBAL\DBALException If not supported on this platform.
     */
    public function getDateAddHourExpression($date, $hours)
    {
        return $this->getDateArithmeticIntervalExpression($date, '+', $hours, self::DATE_INTERVAL_UNIT_HOUR);
    }
    /**
     * Returns the SQL to subtract the number of given hours to a date.
     *
     * @param string  $date
     * @param integer $hours
     *
     * @return string
     *
     * @throws \MailPoetVendor\Doctrine\DBAL\DBALException If not supported on this platform.
     */
    public function getDateSubHourExpression($date, $hours)
    {
        return $this->getDateArithmeticIntervalExpression($date, '-', $hours, self::DATE_INTERVAL_UNIT_HOUR);
    }
    /**
     * Returns the SQL to add the number of given days to a date.
     *
     * @param string  $date
     * @param integer $days
     *
     * @return string
     *
     * @throws \MailPoetVendor\Doctrine\DBAL\DBALException If not supported on this platform.
     */
    public function getDateAddDaysExpression($date, $days)
    {
        return $this->getDateArithmeticIntervalExpression($date, '+', $days, self::DATE_INTERVAL_UNIT_DAY);
    }
    /**
     * Returns the SQL to subtract the number of given days to a date.
     *
     * @param string  $date
     * @param integer $days
     *
     * @return string
     *
     * @throws \MailPoetVendor\Doctrine\DBAL\DBALException If not supported on this platform.
     */
    public function getDateSubDaysExpression($date, $days)
    {
        return $this->getDateArithmeticIntervalExpression($date, '-', $days, self::DATE_INTERVAL_UNIT_DAY);
    }
    /**
     * Returns the SQL to add the number of given weeks to a date.
     *
     * @param string  $date
     * @param integer $weeks
     *
     * @return string
     *
     * @throws \MailPoetVendor\Doctrine\DBAL\DBALException If not supported on this platform.
     */
    public function getDateAddWeeksExpression($date, $weeks)
    {
        return $this->getDateArithmeticIntervalExpression($date, '+', $weeks, self::DATE_INTERVAL_UNIT_WEEK);
    }
    /**
     * Returns the SQL to subtract the number of given weeks from a date.
     *
     * @param string  $date
     * @param integer $weeks
     *
     * @return string
     *
     * @throws \MailPoetVendor\Doctrine\DBAL\DBALException If not supported on this platform.
     */
    public function getDateSubWeeksExpression($date, $weeks)
    {
        return $this->getDateArithmeticIntervalExpression($date, '-', $weeks, self::DATE_INTERVAL_UNIT_WEEK);
    }
    /**
     * Returns the SQL to add the number of given months to a date.
     *
     * @param string  $date
     * @param integer $months
     *
     * @return string
     *
     * @throws \MailPoetVendor\Doctrine\DBAL\DBALException If not supported on this platform.
     */
    public function getDateAddMonthExpression($date, $months)
    {
        return $this->getDateArithmeticIntervalExpression($date, '+', $months, self::DATE_INTERVAL_UNIT_MONTH);
    }
    /**
     * Returns the SQL to subtract the number of given months to a date.
     *
     * @param string  $date
     * @param integer $months
     *
     * @return string
     *
     * @throws \MailPoetVendor\Doctrine\DBAL\DBALException If not supported on this platform.
     */
    public function getDateSubMonthExpression($date, $months)
    {
        return $this->getDateArithmeticIntervalExpression($date, '-', $months, self::DATE_INTERVAL_UNIT_MONTH);
    }
    /**
     * Returns the SQL to add the number of given quarters to a date.
     *
     * @param string  $date
     * @param integer $quarters
     *
     * @return string
     *
     * @throws \MailPoetVendor\Doctrine\DBAL\DBALException If not supported on this platform.
     */
    public function getDateAddQuartersExpression($date, $quarters)
    {
        return $this->getDateArithmeticIntervalExpression($date, '+', $quarters, self::DATE_INTERVAL_UNIT_QUARTER);
    }
    /**
     * Returns the SQL to subtract the number of given quarters from a date.
     *
     * @param string  $date
     * @param integer $quarters
     *
     * @return string
     *
     * @throws \MailPoetVendor\Doctrine\DBAL\DBALException If not supported on this platform.
     */
    public function getDateSubQuartersExpression($date, $quarters)
    {
        return $this->getDateArithmeticIntervalExpression($date, '-', $quarters, self::DATE_INTERVAL_UNIT_QUARTER);
    }
    /**
     * Returns the SQL to add the number of given years to a date.
     *
     * @param string  $date
     * @param integer $years
     *
     * @return string
     *
     * @throws \MailPoetVendor\Doctrine\DBAL\DBALException If not supported on this platform.
     */
    public function getDateAddYearsExpression($date, $years)
    {
        return $this->getDateArithmeticIntervalExpression($date, '+', $years, self::DATE_INTERVAL_UNIT_YEAR);
    }
    /**
     * Returns the SQL to subtract the number of given years from a date.
     *
     * @param string  $date
     * @param integer $years
     *
     * @return string
     *
     * @throws \MailPoetVendor\Doctrine\DBAL\DBALException If not supported on this platform.
     */
    public function getDateSubYearsExpression($date, $years)
    {
        return $this->getDateArithmeticIntervalExpression($date, '-', $years, self::DATE_INTERVAL_UNIT_YEAR);
    }
    /**
     * Returns the SQL for a date arithmetic expression.
     *
     * @param string  $date     The column or literal representing a date to perform the arithmetic operation on.
     * @param string  $operator The arithmetic operator (+ or -).
     * @param integer $interval The interval that shall be calculated into the date.
     * @param string  $unit     The unit of the interval that shall be calculated into the date.
     *                          One of the DATE_INTERVAL_UNIT_* constants.
     *
     * @return string
     *
     * @throws \MailPoetVendor\Doctrine\DBAL\DBALException If not supported on this platform.
     */
    protected function getDateArithmeticIntervalExpression($date, $operator, $interval, $unit)
    {
        throw \MailPoetVendor\Doctrine\DBAL\DBALException::notSupported(__METHOD__);
    }
    /**
     * Returns the SQL bit AND comparison expression.
     *
     * @param string $value1
     * @param string $value2
     *
     * @return string
     */
    public function getBitAndComparisonExpression($value1, $value2)
    {
        return '(' . $value1 . ' & ' . $value2 . ')';
    }
    /**
     * Returns the SQL bit OR comparison expression.
     *
     * @param string $value1
     * @param string $value2
     *
     * @return string
     */
    public function getBitOrComparisonExpression($value1, $value2)
    {
        return '(' . $value1 . ' | ' . $value2 . ')';
    }
    /**
     * Returns the FOR UPDATE expression.
     *
     * @return string
     */
    public function getForUpdateSQL()
    {
        return 'FOR UPDATE';
    }
    /**
     * Honors that some SQL vendors such as MsSql use table hints for locking instead of the ANSI SQL FOR UPDATE specification.
     *
     * @param string       $fromClause The FROM clause to append the hint for the given lock mode to.
     * @param integer|null $lockMode   One of the Doctrine\DBAL\LockMode::* constants. If null is given, nothing will
     *                                 be appended to the FROM clause.
     *
     * @return string
     */
    public function appendLockHint($fromClause, $lockMode)
    {
        return $fromClause;
    }
    /**
     * Returns the SQL snippet to append to any SELECT statement which locks rows in shared read lock.
     *
     * This defaults to the ANSI SQL "FOR UPDATE", which is an exclusive lock (Write). Some database
     * vendors allow to lighten this constraint up to be a real read lock.
     *
     * @return string
     */
    public function getReadLockSQL()
    {
        return $this->getForUpdateSQL();
    }
    /**
     * Returns the SQL snippet to append to any SELECT statement which obtains an exclusive lock on the rows.
     *
     * The semantics of this lock mode should equal the SELECT .. FOR UPDATE of the ANSI SQL standard.
     *
     * @return string
     */
    public function getWriteLockSQL()
    {
        return $this->getForUpdateSQL();
    }
    /**
     * Returns the SQL snippet to drop an existing database.
     *
     * @param string $database The name of the database that should be dropped.
     *
     * @return string
     */
    public function getDropDatabaseSQL($database)
    {
        return 'DROP DATABASE ' . $database;
    }
    /**
     * Returns the SQL snippet to drop an existing table.
     *
     * @param \MailPoetVendor\Doctrine\DBAL\Schema\Table|string $table
     *
     * @return string
     *
     * @throws \InvalidArgumentException
     */
    public function getDropTableSQL($table)
    {
        $tableArg = $table;
        if ($table instanceof \MailPoetVendor\Doctrine\DBAL\Schema\Table) {
            $table = $table->getQuotedName($this);
        } elseif (!\is_string($table)) {
            throw new \InvalidArgumentException('getDropTableSQL() expects $table parameter to be string or \\Doctrine\\DBAL\\Schema\\Table.');
        }
        if (null !== $this->_eventManager && $this->_eventManager->hasListeners(\MailPoetVendor\Doctrine\DBAL\Events::onSchemaDropTable)) {
            $eventArgs = new \MailPoetVendor\Doctrine\DBAL\Event\SchemaDropTableEventArgs($tableArg, $this);
            $this->_eventManager->dispatchEvent(\MailPoetVendor\Doctrine\DBAL\Events::onSchemaDropTable, $eventArgs);
            if ($eventArgs->isDefaultPrevented()) {
                return $eventArgs->getSql();
            }
        }
        return 'DROP TABLE ' . $table;
    }
    /**
     * Returns the SQL to safely drop a temporary table WITHOUT implicitly committing an open transaction.
     *
     * @param \MailPoetVendor\Doctrine\DBAL\Schema\Table|string $table
     *
     * @return string
     */
    public function getDropTemporaryTableSQL($table)
    {
        return $this->getDropTableSQL($table);
    }
    /**
     * Returns the SQL to drop an index from a table.
     *
     * @param \MailPoetVendor\Doctrine\DBAL\Schema\Index|string $index
     * @param \MailPoetVendor\Doctrine\DBAL\Schema\Table|string $table
     *
     * @return string
     *
     * @throws \InvalidArgumentException
     */
    public function getDropIndexSQL($index, $table = null)
    {
        if ($index instanceof \MailPoetVendor\Doctrine\DBAL\Schema\Index) {
            $index = $index->getQuotedName($this);
        } elseif (!\is_string($index)) {
            throw new \InvalidArgumentException('AbstractPlatform::getDropIndexSQL() expects $index parameter to be string or \\Doctrine\\DBAL\\Schema\\Index.');
        }
        return 'DROP INDEX ' . $index;
    }
    /**
     * Returns the SQL to drop a constraint.
     *
     * @param \MailPoetVendor\Doctrine\DBAL\Schema\Constraint|string $constraint
     * @param \MailPoetVendor\Doctrine\DBAL\Schema\Table|string      $table
     *
     * @return string
     */
    public function getDropConstraintSQL($constraint, $table)
    {
        if (!$constraint instanceof \MailPoetVendor\Doctrine\DBAL\Schema\Constraint) {
            $constraint = new \MailPoetVendor\Doctrine\DBAL\Schema\Identifier($constraint);
        }
        if (!$table instanceof \MailPoetVendor\Doctrine\DBAL\Schema\Table) {
            $table = new \MailPoetVendor\Doctrine\DBAL\Schema\Identifier($table);
        }
        $constraint = $constraint->getQuotedName($this);
        $table = $table->getQuotedName($this);
        return 'ALTER TABLE ' . $table . ' DROP CONSTRAINT ' . $constraint;
    }
    /**
     * Returns the SQL to drop a foreign key.
     *
     * @param \MailPoetVendor\Doctrine\DBAL\Schema\ForeignKeyConstraint|string $foreignKey
     * @param \MailPoetVendor\Doctrine\DBAL\Schema\Table|string                $table
     *
     * @return string
     */
    public function getDropForeignKeySQL($foreignKey, $table)
    {
        if (!$foreignKey instanceof \MailPoetVendor\Doctrine\DBAL\Schema\ForeignKeyConstraint) {
            $foreignKey = new \MailPoetVendor\Doctrine\DBAL\Schema\Identifier($foreignKey);
        }
        if (!$table instanceof \MailPoetVendor\Doctrine\DBAL\Schema\Table) {
            $table = new \MailPoetVendor\Doctrine\DBAL\Schema\Identifier($table);
        }
        $foreignKey = $foreignKey->getQuotedName($this);
        $table = $table->getQuotedName($this);
        return 'ALTER TABLE ' . $table . ' DROP FOREIGN KEY ' . $foreignKey;
    }
    /**
     * Returns the SQL statement(s) to create a table with the specified name, columns and constraints
     * on this platform.
     *
     * @param \MailPoetVendor\Doctrine\DBAL\Schema\Table   $table
     * @param integer                       $createFlags
     *
     * @return array The sequence of SQL statements.
     *
     * @throws \MailPoetVendor\Doctrine\DBAL\DBALException
     * @throws \InvalidArgumentException
     */
    public function getCreateTableSQL(\MailPoetVendor\Doctrine\DBAL\Schema\Table $table, $createFlags = self::CREATE_INDEXES)
    {
        if (!\is_int($createFlags)) {
            throw new \InvalidArgumentException("Second argument of AbstractPlatform::getCreateTableSQL() has to be integer.");
        }
        if (\count($table->getColumns()) === 0) {
            throw \MailPoetVendor\Doctrine\DBAL\DBALException::noColumnsSpecifiedForTable($table->getName());
        }
        $tableName = $table->getQuotedName($this);
        $options = $table->getOptions();
        $options['uniqueConstraints'] = array();
        $options['indexes'] = array();
        $options['primary'] = array();
        if (($createFlags & self::CREATE_INDEXES) > 0) {
            foreach ($table->getIndexes() as $index) {
                /* @var $index Index */
                if ($index->isPrimary()) {
                    $options['primary'] = $index->getQuotedColumns($this);
                    $options['primary_index'] = $index;
                } else {
                    $options['indexes'][$index->getQuotedName($this)] = $index;
                }
            }
        }
        $columnSql = array();
        $columns = array();
        foreach ($table->getColumns() as $column) {
            /* @var \MailPoetVendor\Doctrine\DBAL\Schema\Column $column */
            if (null !== $this->_eventManager && $this->_eventManager->hasListeners(\MailPoetVendor\Doctrine\DBAL\Events::onSchemaCreateTableColumn)) {
                $eventArgs = new \MailPoetVendor\Doctrine\DBAL\Event\SchemaCreateTableColumnEventArgs($column, $table, $this);
                $this->_eventManager->dispatchEvent(\MailPoetVendor\Doctrine\DBAL\Events::onSchemaCreateTableColumn, $eventArgs);
                $columnSql = \array_merge($columnSql, $eventArgs->getSql());
                if ($eventArgs->isDefaultPrevented()) {
                    continue;
                }
            }
            $columnData = $column->toArray();
            $columnData['name'] = $column->getQuotedName($this);
            $columnData['version'] = $column->hasPlatformOption("version") ? $column->getPlatformOption('version') : \false;
            $columnData['comment'] = $this->getColumnComment($column);
            if (\strtolower($columnData['type']) == "string" && $columnData['length'] === null) {
                $columnData['length'] = 255;
            }
            if (\in_array($column->getName(), $options['primary'])) {
                $columnData['primary'] = \true;
            }
            $columns[$columnData['name']] = $columnData;
        }
        if (($createFlags & self::CREATE_FOREIGNKEYS) > 0) {
            $options['foreignKeys'] = array();
            foreach ($table->getForeignKeys() as $fkConstraint) {
                $options['foreignKeys'][] = $fkConstraint;
            }
        }
        if (null !== $this->_eventManager && $this->_eventManager->hasListeners(\MailPoetVendor\Doctrine\DBAL\Events::onSchemaCreateTable)) {
            $eventArgs = new \MailPoetVendor\Doctrine\DBAL\Event\SchemaCreateTableEventArgs($table, $columns, $options, $this);
            $this->_eventManager->dispatchEvent(\MailPoetVendor\Doctrine\DBAL\Events::onSchemaCreateTable, $eventArgs);
            if ($eventArgs->isDefaultPrevented()) {
                return \array_merge($eventArgs->getSql(), $columnSql);
            }
        }
        $sql = $this->_getCreateTableSQL($tableName, $columns, $options);
        if ($this->supportsCommentOnStatement()) {
            foreach ($table->getColumns() as $column) {
                $comment = $this->getColumnComment($column);
                if (null !== $comment && '' !== $comment) {
                    $sql[] = $this->getCommentOnColumnSQL($tableName, $column->getQuotedName($this), $comment);
                }
            }
        }
        return \array_merge($sql, $columnSql);
    }
    /**
     * @param string $tableName
     * @param string $columnName
     * @param string $comment
     *
     * @return string
     */
    public function getCommentOnColumnSQL($tableName, $columnName, $comment)
    {
        $tableName = new \MailPoetVendor\Doctrine\DBAL\Schema\Identifier($tableName);
        $columnName = new \MailPoetVendor\Doctrine\DBAL\Schema\Identifier($columnName);
        $comment = $this->quoteStringLiteral($comment);
        return "COMMENT ON COLUMN " . $tableName->getQuotedName($this) . "." . $columnName->getQuotedName($this) . " IS " . $comment;
    }
    /**
     * Returns the SQL used to create a table.
     *
     * @param string $tableName
     * @param array  $columns
     * @param array  $options
     *
     * @return array
     */
    protected function _getCreateTableSQL($tableName, array $columns, array $options = array())
    {
        $columnListSql = $this->getColumnDeclarationListSQL($columns);
        if (isset($options['uniqueConstraints']) && !empty($options['uniqueConstraints'])) {
            foreach ($options['uniqueConstraints'] as $name => $definition) {
                $columnListSql .= ', ' . $this->getUniqueConstraintDeclarationSQL($name, $definition);
            }
        }
        if (isset($options['primary']) && !empty($options['primary'])) {
            $columnListSql .= ', PRIMARY KEY(' . \implode(', ', \array_unique(\array_values($options['primary']))) . ')';
        }
        if (isset($options['indexes']) && !empty($options['indexes'])) {
            foreach ($options['indexes'] as $index => $definition) {
                $columnListSql .= ', ' . $this->getIndexDeclarationSQL($index, $definition);
            }
        }
        $query = 'CREATE TABLE ' . $tableName . ' (' . $columnListSql;
        $check = $this->getCheckDeclarationSQL($columns);
        if (!empty($check)) {
            $query .= ', ' . $check;
        }
        $query .= ')';
        $sql[] = $query;
        if (isset($options['foreignKeys'])) {
            foreach ((array) $options['foreignKeys'] as $definition) {
                $sql[] = $this->getCreateForeignKeySQL($definition, $tableName);
            }
        }
        return $sql;
    }
    /**
     * @return string
     */
    public function getCreateTemporaryTableSnippetSQL()
    {
        return "CREATE TEMPORARY TABLE";
    }
    /**
     * Returns the SQL to create a sequence on this platform.
     *
     * @param \MailPoetVendor\Doctrine\DBAL\Schema\Sequence $sequence
     *
     * @return string
     *
     * @throws \MailPoetVendor\Doctrine\DBAL\DBALException If not supported on this platform.
     */
    public function getCreateSequenceSQL(\MailPoetVendor\Doctrine\DBAL\Schema\Sequence $sequence)
    {
        throw \MailPoetVendor\Doctrine\DBAL\DBALException::notSupported(__METHOD__);
    }
    /**
     * Returns the SQL to change a sequence on this platform.
     *
     * @param \MailPoetVendor\Doctrine\DBAL\Schema\Sequence $sequence
     *
     * @return string
     *
     * @throws \MailPoetVendor\Doctrine\DBAL\DBALException If not supported on this platform.
     */
    public function getAlterSequenceSQL(\MailPoetVendor\Doctrine\DBAL\Schema\Sequence $sequence)
    {
        throw \MailPoetVendor\Doctrine\DBAL\DBALException::notSupported(__METHOD__);
    }
    /**
     * Returns the SQL to create a constraint on a table on this platform.
     *
     * @param \MailPoetVendor\Doctrine\DBAL\Schema\Constraint   $constraint
     * @param \MailPoetVendor\Doctrine\DBAL\Schema\Table|string $table
     *
     * @return string
     *
     * @throws \InvalidArgumentException
     */
    public function getCreateConstraintSQL(\MailPoetVendor\Doctrine\DBAL\Schema\Constraint $constraint, $table)
    {
        if ($table instanceof \MailPoetVendor\Doctrine\DBAL\Schema\Table) {
            $table = $table->getQuotedName($this);
        }
        $query = 'ALTER TABLE ' . $table . ' ADD CONSTRAINT ' . $constraint->getQuotedName($this);
        $columnList = '(' . \implode(', ', $constraint->getQuotedColumns($this)) . ')';
        $referencesClause = '';
        if ($constraint instanceof \MailPoetVendor\Doctrine\DBAL\Schema\Index) {
            if ($constraint->isPrimary()) {
                $query .= ' PRIMARY KEY';
            } elseif ($constraint->isUnique()) {
                $query .= ' UNIQUE';
            } else {
                throw new \InvalidArgumentException('Can only create primary or unique constraints, no common indexes with getCreateConstraintSQL().');
            }
        } elseif ($constraint instanceof \MailPoetVendor\Doctrine\DBAL\Schema\ForeignKeyConstraint) {
            $query .= ' FOREIGN KEY';
            $referencesClause = ' REFERENCES ' . $constraint->getQuotedForeignTableName($this) . ' (' . \implode(', ', $constraint->getQuotedForeignColumns($this)) . ')';
        }
        $query .= ' ' . $columnList . $referencesClause;
        return $query;
    }
    /**
     * Returns the SQL to create an index on a table on this platform.
     *
     * @param \MailPoetVendor\Doctrine\DBAL\Schema\Index        $index
     * @param \MailPoetVendor\Doctrine\DBAL\Schema\Table|string $table The name of the table on which the index is to be created.
     *
     * @return string
     *
     * @throws \InvalidArgumentException
     */
    public function getCreateIndexSQL(\MailPoetVendor\Doctrine\DBAL\Schema\Index $index, $table)
    {
        if ($table instanceof \MailPoetVendor\Doctrine\DBAL\Schema\Table) {
            $table = $table->getQuotedName($this);
        }
        $name = $index->getQuotedName($this);
        $columns = $index->getQuotedColumns($this);
        if (\count($columns) == 0) {
            throw new \InvalidArgumentException("Incomplete definition. 'columns' required.");
        }
        if ($index->isPrimary()) {
            return $this->getCreatePrimaryKeySQL($index, $table);
        }
        $query = 'CREATE ' . $this->getCreateIndexSQLFlags($index) . 'INDEX ' . $name . ' ON ' . $table;
        $query .= ' (' . $this->getIndexFieldDeclarationListSQL($columns) . ')' . $this->getPartialIndexSQL($index);
        return $query;
    }
    /**
     * Adds condition for partial index.
     *
     * @param \MailPoetVendor\Doctrine\DBAL\Schema\Index $index
     *
     * @return string
     */
    protected function getPartialIndexSQL(\MailPoetVendor\Doctrine\DBAL\Schema\Index $index)
    {
        if ($this->supportsPartialIndexes() && $index->hasOption('where')) {
            return ' WHERE ' . $index->getOption('where');
        }
        return '';
    }
    /**
     * Adds additional flags for index generation.
     *
     * @param \MailPoetVendor\Doctrine\DBAL\Schema\Index $index
     *
     * @return string
     */
    protected function getCreateIndexSQLFlags(\MailPoetVendor\Doctrine\DBAL\Schema\Index $index)
    {
        return $index->isUnique() ? 'UNIQUE ' : '';
    }
    /**
     * Returns the SQL to create an unnamed primary key constraint.
     *
     * @param \MailPoetVendor\Doctrine\DBAL\Schema\Index        $index
     * @param \MailPoetVendor\Doctrine\DBAL\Schema\Table|string $table
     *
     * @return string
     */
    public function getCreatePrimaryKeySQL(\MailPoetVendor\Doctrine\DBAL\Schema\Index $index, $table)
    {
        return 'ALTER TABLE ' . $table . ' ADD PRIMARY KEY (' . $this->getIndexFieldDeclarationListSQL($index->getQuotedColumns($this)) . ')';
    }
    /**
     * Returns the SQL to create a named schema.
     *
     * @param string $schemaName
     *
     * @return string
     * @throws \MailPoetVendor\Doctrine\DBAL\DBALException If not supported on this platform.
     */
    public function getCreateSchemaSQL($schemaName)
    {
        throw \MailPoetVendor\Doctrine\DBAL\DBALException::notSupported(__METHOD__);
    }
    /**
     * Quotes a string so that it can be safely used as a table or column name,
     * even if it is a reserved word of the platform. This also detects identifier
     * chains separated by dot and quotes them independently.
     *
     * NOTE: Just because you CAN use quoted identifiers doesn't mean
     * you SHOULD use them. In general, they end up causing way more
     * problems than they solve.
     *
     * @param string $str The identifier name to be quoted.
     *
     * @return string The quoted identifier string.
     */
    public function quoteIdentifier($str)
    {
        if (\strpos($str, ".") !== \false) {
            $parts = \array_map(array($this, "quoteSingleIdentifier"), \explode(".", $str));
            return \implode(".", $parts);
        }
        return $this->quoteSingleIdentifier($str);
    }
    /**
     * Quotes a single identifier (no dot chain separation).
     *
     * @param string $str The identifier name to be quoted.
     *
     * @return string The quoted identifier string.
     */
    public function quoteSingleIdentifier($str)
    {
        $c = $this->getIdentifierQuoteCharacter();
        return $c . \str_replace($c, $c . $c, $str) . $c;
    }
    /**
     * Returns the SQL to create a new foreign key.
     *
     * @param \MailPoetVendor\Doctrine\DBAL\Schema\ForeignKeyConstraint $foreignKey The foreign key constraint.
     * @param \MailPoetVendor\Doctrine\DBAL\Schema\Table|string         $table      The name of the table on which the foreign key is to be created.
     *
     * @return string
     */
    public function getCreateForeignKeySQL(\MailPoetVendor\Doctrine\DBAL\Schema\ForeignKeyConstraint $foreignKey, $table)
    {
        if ($table instanceof \MailPoetVendor\Doctrine\DBAL\Schema\Table) {
            $table = $table->getQuotedName($this);
        }
        $query = 'ALTER TABLE ' . $table . ' ADD ' . $this->getForeignKeyDeclarationSQL($foreignKey);
        return $query;
    }
    /**
     * Gets the SQL statements for altering an existing table.
     *
     * This method returns an array of SQL statements, since some platforms need several statements.
     *
     * @param \MailPoetVendor\Doctrine\DBAL\Schema\TableDiff $diff
     *
     * @return array
     *
     * @throws \MailPoetVendor\Doctrine\DBAL\DBALException If not supported on this platform.
     */
    public function getAlterTableSQL(\MailPoetVendor\Doctrine\DBAL\Schema\TableDiff $diff)
    {
        throw \MailPoetVendor\Doctrine\DBAL\DBALException::notSupported(__METHOD__);
    }
    /**
     * @param \MailPoetVendor\Doctrine\DBAL\Schema\Column    $column
     * @param \MailPoetVendor\Doctrine\DBAL\Schema\TableDiff $diff
     * @param array                           $columnSql
     *
     * @return boolean
     */
    protected function onSchemaAlterTableAddColumn(\MailPoetVendor\Doctrine\DBAL\Schema\Column $column, \MailPoetVendor\Doctrine\DBAL\Schema\TableDiff $diff, &$columnSql)
    {
        if (null === $this->_eventManager) {
            return \false;
        }
        if (!$this->_eventManager->hasListeners(\MailPoetVendor\Doctrine\DBAL\Events::onSchemaAlterTableAddColumn)) {
            return \false;
        }
        $eventArgs = new \MailPoetVendor\Doctrine\DBAL\Event\SchemaAlterTableAddColumnEventArgs($column, $diff, $this);
        $this->_eventManager->dispatchEvent(\MailPoetVendor\Doctrine\DBAL\Events::onSchemaAlterTableAddColumn, $eventArgs);
        $columnSql = \array_merge($columnSql, $eventArgs->getSql());
        return $eventArgs->isDefaultPrevented();
    }
    /**
     * @param \MailPoetVendor\Doctrine\DBAL\Schema\Column    $column
     * @param \MailPoetVendor\Doctrine\DBAL\Schema\TableDiff $diff
     * @param array                           $columnSql
     *
     * @return boolean
     */
    protected function onSchemaAlterTableRemoveColumn(\MailPoetVendor\Doctrine\DBAL\Schema\Column $column, \MailPoetVendor\Doctrine\DBAL\Schema\TableDiff $diff, &$columnSql)
    {
        if (null === $this->_eventManager) {
            return \false;
        }
        if (!$this->_eventManager->hasListeners(\MailPoetVendor\Doctrine\DBAL\Events::onSchemaAlterTableRemoveColumn)) {
            return \false;
        }
        $eventArgs = new \MailPoetVendor\Doctrine\DBAL\Event\SchemaAlterTableRemoveColumnEventArgs($column, $diff, $this);
        $this->_eventManager->dispatchEvent(\MailPoetVendor\Doctrine\DBAL\Events::onSchemaAlterTableRemoveColumn, $eventArgs);
        $columnSql = \array_merge($columnSql, $eventArgs->getSql());
        return $eventArgs->isDefaultPrevented();
    }
    /**
     * @param \MailPoetVendor\Doctrine\DBAL\Schema\ColumnDiff $columnDiff
     * @param \MailPoetVendor\Doctrine\DBAL\Schema\TableDiff  $diff
     * @param array                            $columnSql
     *
     * @return boolean
     */
    protected function onSchemaAlterTableChangeColumn(\MailPoetVendor\Doctrine\DBAL\Schema\ColumnDiff $columnDiff, \MailPoetVendor\Doctrine\DBAL\Schema\TableDiff $diff, &$columnSql)
    {
        if (null === $this->_eventManager) {
            return \false;
        }
        if (!$this->_eventManager->hasListeners(\MailPoetVendor\Doctrine\DBAL\Events::onSchemaAlterTableChangeColumn)) {
            return \false;
        }
        $eventArgs = new \MailPoetVendor\Doctrine\DBAL\Event\SchemaAlterTableChangeColumnEventArgs($columnDiff, $diff, $this);
        $this->_eventManager->dispatchEvent(\MailPoetVendor\Doctrine\DBAL\Events::onSchemaAlterTableChangeColumn, $eventArgs);
        $columnSql = \array_merge($columnSql, $eventArgs->getSql());
        return $eventArgs->isDefaultPrevented();
    }
    /**
     * @param string                          $oldColumnName
     * @param \MailPoetVendor\Doctrine\DBAL\Schema\Column    $column
     * @param \MailPoetVendor\Doctrine\DBAL\Schema\TableDiff $diff
     * @param array                           $columnSql
     *
     * @return boolean
     */
    protected function onSchemaAlterTableRenameColumn($oldColumnName, \MailPoetVendor\Doctrine\DBAL\Schema\Column $column, \MailPoetVendor\Doctrine\DBAL\Schema\TableDiff $diff, &$columnSql)
    {
        if (null === $this->_eventManager) {
            return \false;
        }
        if (!$this->_eventManager->hasListeners(\MailPoetVendor\Doctrine\DBAL\Events::onSchemaAlterTableRenameColumn)) {
            return \false;
        }
        $eventArgs = new \MailPoetVendor\Doctrine\DBAL\Event\SchemaAlterTableRenameColumnEventArgs($oldColumnName, $column, $diff, $this);
        $this->_eventManager->dispatchEvent(\MailPoetVendor\Doctrine\DBAL\Events::onSchemaAlterTableRenameColumn, $eventArgs);
        $columnSql = \array_merge($columnSql, $eventArgs->getSql());
        return $eventArgs->isDefaultPrevented();
    }
    /**
     * @param \MailPoetVendor\Doctrine\DBAL\Schema\TableDiff $diff
     * @param array                           $sql
     *
     * @return boolean
     */
    protected function onSchemaAlterTable(\MailPoetVendor\Doctrine\DBAL\Schema\TableDiff $diff, &$sql)
    {
        if (null === $this->_eventManager) {
            return \false;
        }
        if (!$this->_eventManager->hasListeners(\MailPoetVendor\Doctrine\DBAL\Events::onSchemaAlterTable)) {
            return \false;
        }
        $eventArgs = new \MailPoetVendor\Doctrine\DBAL\Event\SchemaAlterTableEventArgs($diff, $this);
        $this->_eventManager->dispatchEvent(\MailPoetVendor\Doctrine\DBAL\Events::onSchemaAlterTable, $eventArgs);
        $sql = \array_merge($sql, $eventArgs->getSql());
        return $eventArgs->isDefaultPrevented();
    }
    /**
     * @param \MailPoetVendor\Doctrine\DBAL\Schema\TableDiff $diff
     *
     * @return array
     */
    protected function getPreAlterTableIndexForeignKeySQL(\MailPoetVendor\Doctrine\DBAL\Schema\TableDiff $diff)
    {
        $tableName = $diff->getName($this)->getQuotedName($this);
        $sql = array();
        if ($this->supportsForeignKeyConstraints()) {
            foreach ($diff->removedForeignKeys as $foreignKey) {
                $sql[] = $this->getDropForeignKeySQL($foreignKey, $tableName);
            }
            foreach ($diff->changedForeignKeys as $foreignKey) {
                $sql[] = $this->getDropForeignKeySQL($foreignKey, $tableName);
            }
        }
        foreach ($diff->removedIndexes as $index) {
            $sql[] = $this->getDropIndexSQL($index, $tableName);
        }
        foreach ($diff->changedIndexes as $index) {
            $sql[] = $this->getDropIndexSQL($index, $tableName);
        }
        return $sql;
    }
    /**
     * @param \MailPoetVendor\Doctrine\DBAL\Schema\TableDiff $diff
     *
     * @return array
     */
    protected function getPostAlterTableIndexForeignKeySQL(\MailPoetVendor\Doctrine\DBAL\Schema\TableDiff $diff)
    {
        $tableName = \false !== $diff->newName ? $diff->getNewName()->getQuotedName($this) : $diff->getName($this)->getQuotedName($this);
        $sql = array();
        if ($this->supportsForeignKeyConstraints()) {
            foreach ($diff->addedForeignKeys as $foreignKey) {
                $sql[] = $this->getCreateForeignKeySQL($foreignKey, $tableName);
            }
            foreach ($diff->changedForeignKeys as $foreignKey) {
                $sql[] = $this->getCreateForeignKeySQL($foreignKey, $tableName);
            }
        }
        foreach ($diff->addedIndexes as $index) {
            $sql[] = $this->getCreateIndexSQL($index, $tableName);
        }
        foreach ($diff->changedIndexes as $index) {
            $sql[] = $this->getCreateIndexSQL($index, $tableName);
        }
        foreach ($diff->renamedIndexes as $oldIndexName => $index) {
            $oldIndexName = new \MailPoetVendor\Doctrine\DBAL\Schema\Identifier($oldIndexName);
            $sql = \array_merge($sql, $this->getRenameIndexSQL($oldIndexName->getQuotedName($this), $index, $tableName));
        }
        return $sql;
    }
    /**
     * Returns the SQL for renaming an index on a table.
     *
     * @param string                      $oldIndexName The name of the index to rename from.
     * @param \MailPoetVendor\Doctrine\DBAL\Schema\Index $index        The definition of the index to rename to.
     * @param string                      $tableName    The table to rename the given index on.
     *
     * @return array The sequence of SQL statements for renaming the given index.
     */
    protected function getRenameIndexSQL($oldIndexName, \MailPoetVendor\Doctrine\DBAL\Schema\Index $index, $tableName)
    {
        return array($this->getDropIndexSQL($oldIndexName, $tableName), $this->getCreateIndexSQL($index, $tableName));
    }
    /**
     * Common code for alter table statement generation that updates the changed Index and Foreign Key definitions.
     *
     * @param \MailPoetVendor\Doctrine\DBAL\Schema\TableDiff $diff
     *
     * @return array
     */
    protected function _getAlterTableIndexForeignKeySQL(\MailPoetVendor\Doctrine\DBAL\Schema\TableDiff $diff)
    {
        return \array_merge($this->getPreAlterTableIndexForeignKeySQL($diff), $this->getPostAlterTableIndexForeignKeySQL($diff));
    }
    /**
     * Gets declaration of a number of fields in bulk.
     *
     * @param array $fields A multidimensional associative array.
     *                      The first dimension determines the field name, while the second
     *                      dimension is keyed with the name of the properties
     *                      of the field being declared as array indexes. Currently, the types
     *                      of supported field properties are as follows:
     *
     *      length
     *          Integer value that determines the maximum length of the text
     *          field. If this argument is missing the field should be
     *          declared to have the longest length allowed by the DBMS.
     *
     *      default
     *          Text value to be used as default for this field.
     *
     *      notnull
     *          Boolean flag that indicates whether this field is constrained
     *          to not be set to null.
     *      charset
     *          Text value with the default CHARACTER SET for this field.
     *      collation
     *          Text value with the default COLLATION for this field.
     *      unique
     *          unique constraint
     *
     * @return string
     */
    public function getColumnDeclarationListSQL(array $fields)
    {
        $queryFields = array();
        foreach ($fields as $fieldName => $field) {
            $queryFields[] = $this->getColumnDeclarationSQL($fieldName, $field);
        }
        return \implode(', ', $queryFields);
    }
    /**
     * Obtains DBMS specific SQL code portion needed to declare a generic type
     * field to be used in statements like CREATE TABLE.
     *
     * @param string $name  The name the field to be declared.
     * @param array  $field An associative array with the name of the properties
     *                      of the field being declared as array indexes. Currently, the types
     *                      of supported field properties are as follows:
     *
     *      length
     *          Integer value that determines the maximum length of the text
     *          field. If this argument is missing the field should be
     *          declared to have the longest length allowed by the DBMS.
     *
     *      default
     *          Text value to be used as default for this field.
     *
     *      notnull
     *          Boolean flag that indicates whether this field is constrained
     *          to not be set to null.
     *      charset
     *          Text value with the default CHARACTER SET for this field.
     *      collation
     *          Text value with the default COLLATION for this field.
     *      unique
     *          unique constraint
     *      check
     *          column check constraint
     *      columnDefinition
     *          a string that defines the complete column
     *
     * @return string DBMS specific SQL code portion that should be used to declare the column.
     */
    public function getColumnDeclarationSQL($name, array $field)
    {
        if (isset($field['columnDefinition'])) {
            $columnDef = $this->getCustomTypeDeclarationSQL($field);
        } else {
            $default = $this->getDefaultValueDeclarationSQL($field);
            $charset = isset($field['charset']) && $field['charset'] ? ' ' . $this->getColumnCharsetDeclarationSQL($field['charset']) : '';
            $collation = isset($field['collation']) && $field['collation'] ? ' ' . $this->getColumnCollationDeclarationSQL($field['collation']) : '';
            $notnull = isset($field['notnull']) && $field['notnull'] ? ' NOT NULL' : '';
            $unique = isset($field['unique']) && $field['unique'] ? ' ' . $this->getUniqueFieldDeclarationSQL() : '';
            $check = isset($field['check']) && $field['check'] ? ' ' . $field['check'] : '';
            $typeDecl = $field['type']->getSqlDeclaration($field, $this);
            $columnDef = $typeDecl . $charset . $default . $notnull . $unique . $check . $collation;
            if ($this->supportsInlineColumnComments() && isset($field['comment']) && $field['comment'] !== '') {
                $columnDef .= " COMMENT " . $this->quoteStringLiteral($field['comment']);
            }
        }
        return $name . ' ' . $columnDef;
    }
    /**
     * Returns the SQL snippet that declares a floating point column of arbitrary precision.
     *
     * @param array $columnDef
     *
     * @return string
     */
    public function getDecimalTypeDeclarationSQL(array $columnDef)
    {
        $columnDef['precision'] = !isset($columnDef['precision']) || empty($columnDef['precision']) ? 10 : $columnDef['precision'];
        $columnDef['scale'] = !isset($columnDef['scale']) || empty($columnDef['scale']) ? 0 : $columnDef['scale'];
        return 'NUMERIC(' . $columnDef['precision'] . ', ' . $columnDef['scale'] . ')';
    }
    /**
     * Obtains DBMS specific SQL code portion needed to set a default value
     * declaration to be used in statements like CREATE TABLE.
     *
     * @param array $field The field definition array.
     *
     * @return string DBMS specific SQL code portion needed to set a default value.
     */
    public function getDefaultValueDeclarationSQL($field)
    {
        $default = empty($field['notnull']) ? ' DEFAULT NULL' : '';
        if (isset($field['default'])) {
            $default = " DEFAULT '" . $field['default'] . "'";
            if (isset($field['type'])) {
                if (\in_array((string) $field['type'], array("Integer", "BigInt", "SmallInt"))) {
                    $default = " DEFAULT " . $field['default'];
                } elseif (\in_array((string) $field['type'], array('DateTime', 'DateTimeTz')) && $field['default'] == $this->getCurrentTimestampSQL()) {
                    $default = " DEFAULT " . $this->getCurrentTimestampSQL();
                } elseif ((string) $field['type'] == 'Time' && $field['default'] == $this->getCurrentTimeSQL()) {
                    $default = " DEFAULT " . $this->getCurrentTimeSQL();
                } elseif ((string) $field['type'] == 'Date' && $field['default'] == $this->getCurrentDateSQL()) {
                    $default = " DEFAULT " . $this->getCurrentDateSQL();
                } elseif ((string) $field['type'] == 'Boolean') {
                    $default = " DEFAULT '" . $this->convertBooleans($field['default']) . "'";
                }
            }
        }
        return $default;
    }
    /**
     * Obtains DBMS specific SQL code portion needed to set a CHECK constraint
     * declaration to be used in statements like CREATE TABLE.
     *
     * @param array $definition The check definition.
     *
     * @return string DBMS specific SQL code portion needed to set a CHECK constraint.
     */
    public function getCheckDeclarationSQL(array $definition)
    {
        $constraints = array();
        foreach ($definition as $field => $def) {
            if (\is_string($def)) {
                $constraints[] = 'CHECK (' . $def . ')';
            } else {
                if (isset($def['min'])) {
                    $constraints[] = 'CHECK (' . $field . ' >= ' . $def['min'] . ')';
                }
                if (isset($def['max'])) {
                    $constraints[] = 'CHECK (' . $field . ' <= ' . $def['max'] . ')';
                }
            }
        }
        return \implode(', ', $constraints);
    }
    /**
     * Obtains DBMS specific SQL code portion needed to set a unique
     * constraint declaration to be used in statements like CREATE TABLE.
     *
     * @param string                      $name  The name of the unique constraint.
     * @param \MailPoetVendor\Doctrine\DBAL\Schema\Index $index The index definition.
     *
     * @return string DBMS specific SQL code portion needed to set a constraint.
     *
     * @throws \InvalidArgumentException
     */
    public function getUniqueConstraintDeclarationSQL($name, \MailPoetVendor\Doctrine\DBAL\Schema\Index $index)
    {
        $columns = $index->getQuotedColumns($this);
        $name = new \MailPoetVendor\Doctrine\DBAL\Schema\Identifier($name);
        if (\count($columns) === 0) {
            throw new \InvalidArgumentException("Incomplete definition. 'columns' required.");
        }
        return 'CONSTRAINT ' . $name->getQuotedName($this) . ' UNIQUE (' . $this->getIndexFieldDeclarationListSQL($columns) . ')' . $this->getPartialIndexSQL($index);
    }
    /**
     * Obtains DBMS specific SQL code portion needed to set an index
     * declaration to be used in statements like CREATE TABLE.
     *
     * @param string                      $name  The name of the index.
     * @param \MailPoetVendor\Doctrine\DBAL\Schema\Index $index The index definition.
     *
     * @return string DBMS specific SQL code portion needed to set an index.
     *
     * @throws \InvalidArgumentException
     */
    public function getIndexDeclarationSQL($name, \MailPoetVendor\Doctrine\DBAL\Schema\Index $index)
    {
        $columns = $index->getQuotedColumns($this);
        $name = new \MailPoetVendor\Doctrine\DBAL\Schema\Identifier($name);
        if (\count($columns) === 0) {
            throw new \InvalidArgumentException("Incomplete definition. 'columns' required.");
        }
        return $this->getCreateIndexSQLFlags($index) . 'INDEX ' . $name->getQuotedName($this) . ' (' . $this->getIndexFieldDeclarationListSQL($columns) . ')' . $this->getPartialIndexSQL($index);
    }
    /**
     * Obtains SQL code portion needed to create a custom column,
     * e.g. when a field has the "columnDefinition" keyword.
     * Only "AUTOINCREMENT" and "PRIMARY KEY" are added if appropriate.
     *
     * @param array $columnDef
     *
     * @return string
     */
    public function getCustomTypeDeclarationSQL(array $columnDef)
    {
        return $columnDef['columnDefinition'];
    }
    /**
     * Obtains DBMS specific SQL code portion needed to set an index
     * declaration to be used in statements like CREATE TABLE.
     *
     * @param array $fields
     *
     * @return string
     */
    public function getIndexFieldDeclarationListSQL(array $fields)
    {
        $ret = array();
        foreach ($fields as $field => $definition) {
            if (\is_array($definition)) {
                $ret[] = $field;
            } else {
                $ret[] = $definition;
            }
        }
        return \implode(', ', $ret);
    }
    /**
     * Returns the required SQL string that fits between CREATE ... TABLE
     * to create the table as a temporary table.
     *
     * Should be overridden in driver classes to return the correct string for the
     * specific database type.
     *
     * The default is to return the string "TEMPORARY" - this will result in a
     * SQL error for any database that does not support temporary tables, or that
     * requires a different SQL command from "CREATE TEMPORARY TABLE".
     *
     * @return string The string required to be placed between "CREATE" and "TABLE"
     *                to generate a temporary table, if possible.
     */
    public function getTemporaryTableSQL()
    {
        return 'TEMPORARY';
    }
    /**
     * Some vendors require temporary table names to be qualified specially.
     *
     * @param string $tableName
     *
     * @return string
     */
    public function getTemporaryTableName($tableName)
    {
        return $tableName;
    }
    /**
     * Obtain DBMS specific SQL code portion needed to set the FOREIGN KEY constraint
     * of a field declaration to be used in statements like CREATE TABLE.
     *
     * @param \MailPoetVendor\Doctrine\DBAL\Schema\ForeignKeyConstraint $foreignKey
     *
     * @return string DBMS specific SQL code portion needed to set the FOREIGN KEY constraint
     *                of a field declaration.
     */
    public function getForeignKeyDeclarationSQL(\MailPoetVendor\Doctrine\DBAL\Schema\ForeignKeyConstraint $foreignKey)
    {
        $sql = $this->getForeignKeyBaseDeclarationSQL($foreignKey);
        $sql .= $this->getAdvancedForeignKeyOptionsSQL($foreignKey);
        return $sql;
    }
    /**
     * Returns the FOREIGN KEY query section dealing with non-standard options
     * as MATCH, INITIALLY DEFERRED, ON UPDATE, ...
     *
     * @param \MailPoetVendor\Doctrine\DBAL\Schema\ForeignKeyConstraint $foreignKey The foreign key definition.
     *
     * @return string
     */
    public function getAdvancedForeignKeyOptionsSQL(\MailPoetVendor\Doctrine\DBAL\Schema\ForeignKeyConstraint $foreignKey)
    {
        $query = '';
        if ($this->supportsForeignKeyOnUpdate() && $foreignKey->hasOption('onUpdate')) {
            $query .= ' ON UPDATE ' . $this->getForeignKeyReferentialActionSQL($foreignKey->getOption('onUpdate'));
        }
        if ($foreignKey->hasOption('onDelete')) {
            $query .= ' ON DELETE ' . $this->getForeignKeyReferentialActionSQL($foreignKey->getOption('onDelete'));
        }
        return $query;
    }
    /**
     * Returns the given referential action in uppercase if valid, otherwise throws an exception.
     *
     * @param string $action The foreign key referential action.
     *
     * @return string
     *
     * @throws \InvalidArgumentException if unknown referential action given
     */
    public function getForeignKeyReferentialActionSQL($action)
    {
        $upper = \strtoupper($action);
        switch ($upper) {
            case 'CASCADE':
            case 'SET NULL':
            case 'NO ACTION':
            case 'RESTRICT':
            case 'SET DEFAULT':
                return $upper;
            default:
                throw new \InvalidArgumentException('Invalid foreign key action: ' . $upper);
        }
    }
    /**
     * Obtains DBMS specific SQL code portion needed to set the FOREIGN KEY constraint
     * of a field declaration to be used in statements like CREATE TABLE.
     *
     * @param \MailPoetVendor\Doctrine\DBAL\Schema\ForeignKeyConstraint $foreignKey
     *
     * @return string
     *
     * @throws \InvalidArgumentException
     */
    public function getForeignKeyBaseDeclarationSQL(\MailPoetVendor\Doctrine\DBAL\Schema\ForeignKeyConstraint $foreignKey)
    {
        $sql = '';
        if (\strlen($foreignKey->getName())) {
            $sql .= 'CONSTRAINT ' . $foreignKey->getQuotedName($this) . ' ';
        }
        $sql .= 'FOREIGN KEY (';
        if (\count($foreignKey->getLocalColumns()) === 0) {
            throw new \InvalidArgumentException("Incomplete definition. 'local' required.");
        }
        if (\count($foreignKey->getForeignColumns()) === 0) {
            throw new \InvalidArgumentException("Incomplete definition. 'foreign' required.");
        }
        if (\strlen($foreignKey->getForeignTableName()) === 0) {
            throw new \InvalidArgumentException("Incomplete definition. 'foreignTable' required.");
        }
        $sql .= \implode(', ', $foreignKey->getQuotedLocalColumns($this)) . ') REFERENCES ' . $foreignKey->getQuotedForeignTableName($this) . ' (' . \implode(', ', $foreignKey->getQuotedForeignColumns($this)) . ')';
        return $sql;
    }
    /**
     * Obtains DBMS specific SQL code portion needed to set the UNIQUE constraint
     * of a field declaration to be used in statements like CREATE TABLE.
     *
     * @return string DBMS specific SQL code portion needed to set the UNIQUE constraint
     *                of a field declaration.
     */
    public function getUniqueFieldDeclarationSQL()
    {
        return 'UNIQUE';
    }
    /**
     * Obtains DBMS specific SQL code portion needed to set the CHARACTER SET
     * of a field declaration to be used in statements like CREATE TABLE.
     *
     * @param string $charset The name of the charset.
     *
     * @return string DBMS specific SQL code portion needed to set the CHARACTER SET
     *                of a field declaration.
     */
    public function getColumnCharsetDeclarationSQL($charset)
    {
        return '';
    }
    /**
     * Obtains DBMS specific SQL code portion needed to set the COLLATION
     * of a field declaration to be used in statements like CREATE TABLE.
     *
     * @param string $collation The name of the collation.
     *
     * @return string DBMS specific SQL code portion needed to set the COLLATION
     *                of a field declaration.
     */
    public function getColumnCollationDeclarationSQL($collation)
    {
        return $this->supportsColumnCollation() ? 'COLLATE ' . $collation : '';
    }
    /**
     * Whether the platform prefers sequences for ID generation.
     * Subclasses should override this method to return TRUE if they prefer sequences.
     *
     * @return boolean
     */
    public function prefersSequences()
    {
        return \false;
    }
    /**
     * Whether the platform prefers identity columns (eg. autoincrement) for ID generation.
     * Subclasses should override this method to return TRUE if they prefer identity columns.
     *
     * @return boolean
     */
    public function prefersIdentityColumns()
    {
        return \false;
    }
    /**
     * Some platforms need the boolean values to be converted.
     *
     * The default conversion in this implementation converts to integers (false => 0, true => 1).
     *
     * Note: if the input is not a boolean the original input might be returned.
     *
     * There are two contexts when converting booleans: Literals and Prepared Statements.
     * This method should handle the literal case
     *
     * @param mixed $item A boolean or an array of them.
     *
     * @return mixed A boolean database value or an array of them.
     */
    public function convertBooleans($item)
    {
        if (\is_array($item)) {
            foreach ($item as $k => $value) {
                if (\is_bool($value)) {
                    $item[$k] = (int) $value;
                }
            }
        } elseif (\is_bool($item)) {
            $item = (int) $item;
        }
        return $item;
    }
    /**
     * Some platforms have boolean literals that needs to be correctly converted
     *
     * The default conversion tries to convert value into bool "(bool)$item"
     *
     * @param mixed $item
     *
     * @return bool|null
     */
    public function convertFromBoolean($item)
    {
        return null === $item ? null : (bool) $item;
    }
    /**
     * This method should handle the prepared statements case. When there is no
     * distinction, it's OK to use the same method.
     *
     * Note: if the input is not a boolean the original input might be returned.
     *
     * @param mixed $item A boolean or an array of them.
     *
     * @return mixed A boolean database value or an array of them.
     */
    public function convertBooleansToDatabaseValue($item)
    {
        return $this->convertBooleans($item);
    }
    /**
     * Returns the SQL specific for the platform to get the current date.
     *
     * @return string
     */
    public function getCurrentDateSQL()
    {
        return 'CURRENT_DATE';
    }
    /**
     * Returns the SQL specific for the platform to get the current time.
     *
     * @return string
     */
    public function getCurrentTimeSQL()
    {
        return 'CURRENT_TIME';
    }
    /**
     * Returns the SQL specific for the platform to get the current timestamp
     *
     * @return string
     */
    public function getCurrentTimestampSQL()
    {
        return 'CURRENT_TIMESTAMP';
    }
    /**
     * Returns the SQL for a given transaction isolation level Connection constant.
     *
     * @param integer $level
     *
     * @return string
     *
     * @throws \InvalidArgumentException
     */
    protected function _getTransactionIsolationLevelSQL($level)
    {
        switch ($level) {
            case \MailPoetVendor\Doctrine\DBAL\Connection::TRANSACTION_READ_UNCOMMITTED:
                return 'READ UNCOMMITTED';
            case \MailPoetVendor\Doctrine\DBAL\Connection::TRANSACTION_READ_COMMITTED:
                return 'READ COMMITTED';
            case \MailPoetVendor\Doctrine\DBAL\Connection::TRANSACTION_REPEATABLE_READ:
                return 'REPEATABLE READ';
            case \MailPoetVendor\Doctrine\DBAL\Connection::TRANSACTION_SERIALIZABLE:
                return 'SERIALIZABLE';
            default:
                throw new \InvalidArgumentException('Invalid isolation level:' . $level);
        }
    }
    /**
     * @return string
     *
     * @throws \MailPoetVendor\Doctrine\DBAL\DBALException If not supported on this platform.
     */
    public function getListDatabasesSQL()
    {
        throw \MailPoetVendor\Doctrine\DBAL\DBALException::notSupported(__METHOD__);
    }
    /**
     * Returns the SQL statement for retrieving the namespaces defined in the database.
     *
     * @return string
     *
     * @throws \MailPoetVendor\Doctrine\DBAL\DBALException If not supported on this platform.
     */
    public function getListNamespacesSQL()
    {
        throw \MailPoetVendor\Doctrine\DBAL\DBALException::notSupported(__METHOD__);
    }
    /**
     * @param string $database
     *
     * @return string
     *
     * @throws \MailPoetVendor\Doctrine\DBAL\DBALException If not supported on this platform.
     */
    public function getListSequencesSQL($database)
    {
        throw \MailPoetVendor\Doctrine\DBAL\DBALException::notSupported(__METHOD__);
    }
    /**
     * @param string $table
     *
     * @return string
     *
     * @throws \MailPoetVendor\Doctrine\DBAL\DBALException If not supported on this platform.
     */
    public function getListTableConstraintsSQL($table)
    {
        throw \MailPoetVendor\Doctrine\DBAL\DBALException::notSupported(__METHOD__);
    }
    /**
     * @param string      $table
     * @param string|null $database
     *
     * @return string
     *
     * @throws \MailPoetVendor\Doctrine\DBAL\DBALException If not supported on this platform.
     */
    public function getListTableColumnsSQL($table, $database = null)
    {
        throw \MailPoetVendor\Doctrine\DBAL\DBALException::notSupported(__METHOD__);
    }
    /**
     * @return string
     *
     * @throws \MailPoetVendor\Doctrine\DBAL\DBALException If not supported on this platform.
     */
    public function getListTablesSQL()
    {
        throw \MailPoetVendor\Doctrine\DBAL\DBALException::notSupported(__METHOD__);
    }
    /**
     * @return string
     *
     * @throws \MailPoetVendor\Doctrine\DBAL\DBALException If not supported on this platform.
     */
    public function getListUsersSQL()
    {
        throw \MailPoetVendor\Doctrine\DBAL\DBALException::notSupported(__METHOD__);
    }
    /**
     * Returns the SQL to list all views of a database or user.
     *
     * @param string $database
     *
     * @return string
     *
     * @throws \MailPoetVendor\Doctrine\DBAL\DBALException If not supported on this platform.
     */
    public function getListViewsSQL($database)
    {
        throw \MailPoetVendor\Doctrine\DBAL\DBALException::notSupported(__METHOD__);
    }
    /**
     * Returns the list of indexes for the current database.
     *
     * The current database parameter is optional but will always be passed
     * when using the SchemaManager API and is the database the given table is in.
     *
     * Attention: Some platforms only support currentDatabase when they
     * are connected with that database. Cross-database information schema
     * requests may be impossible.
     *
     * @param string $table
     * @param string $currentDatabase
     *
     * @return string
     *
     * @throws \MailPoetVendor\Doctrine\DBAL\DBALException If not supported on this platform.
     */
    public function getListTableIndexesSQL($table, $currentDatabase = null)
    {
        throw \MailPoetVendor\Doctrine\DBAL\DBALException::notSupported(__METHOD__);
    }
    /**
     * @param string $table
     *
     * @return string
     *
     * @throws \MailPoetVendor\Doctrine\DBAL\DBALException If not supported on this platform.
     */
    public function getListTableForeignKeysSQL($table)
    {
        throw \MailPoetVendor\Doctrine\DBAL\DBALException::notSupported(__METHOD__);
    }
    /**
     * @param string $name
     * @param string $sql
     *
     * @return string
     *
     * @throws \MailPoetVendor\Doctrine\DBAL\DBALException If not supported on this platform.
     */
    public function getCreateViewSQL($name, $sql)
    {
        throw \MailPoetVendor\Doctrine\DBAL\DBALException::notSupported(__METHOD__);
    }
    /**
     * @param string $name
     *
     * @return string
     *
     * @throws \MailPoetVendor\Doctrine\DBAL\DBALException If not supported on this platform.
     */
    public function getDropViewSQL($name)
    {
        throw \MailPoetVendor\Doctrine\DBAL\DBALException::notSupported(__METHOD__);
    }
    /**
     * Returns the SQL snippet to drop an existing sequence.
     *
     * @param Sequence|string $sequence
     *
     * @return string
     *
     * @throws \MailPoetVendor\Doctrine\DBAL\DBALException If not supported on this platform.
     */
    public function getDropSequenceSQL($sequence)
    {
        throw \MailPoetVendor\Doctrine\DBAL\DBALException::notSupported(__METHOD__);
    }
    /**
     * @param string $sequenceName
     *
     * @return string
     *
     * @throws \MailPoetVendor\Doctrine\DBAL\DBALException If not supported on this platform.
     */
    public function getSequenceNextValSQL($sequenceName)
    {
        throw \MailPoetVendor\Doctrine\DBAL\DBALException::notSupported(__METHOD__);
    }
    /**
     * Returns the SQL to create a new database.
     *
     * @param string $database The name of the database that should be created.
     *
     * @return string
     *
     * @throws \MailPoetVendor\Doctrine\DBAL\DBALException If not supported on this platform.
     */
    public function getCreateDatabaseSQL($database)
    {
        throw \MailPoetVendor\Doctrine\DBAL\DBALException::notSupported(__METHOD__);
    }
    /**
     * Returns the SQL to set the transaction isolation level.
     *
     * @param integer $level
     *
     * @return string
     *
     * @throws \MailPoetVendor\Doctrine\DBAL\DBALException If not supported on this platform.
     */
    public function getSetTransactionIsolationSQL($level)
    {
        throw \MailPoetVendor\Doctrine\DBAL\DBALException::notSupported(__METHOD__);
    }
    /**
     * Obtains DBMS specific SQL to be used to create datetime fields in
     * statements like CREATE TABLE.
     *
     * @param array $fieldDeclaration
     *
     * @return string
     *
     * @throws \MailPoetVendor\Doctrine\DBAL\DBALException If not supported on this platform.
     */
    public function getDateTimeTypeDeclarationSQL(array $fieldDeclaration)
    {
        throw \MailPoetVendor\Doctrine\DBAL\DBALException::notSupported(__METHOD__);
    }
    /**
     * Obtains DBMS specific SQL to be used to create datetime with timezone offset fields.
     *
     * @param array $fieldDeclaration
     *
     * @return string
     */
    public function getDateTimeTzTypeDeclarationSQL(array $fieldDeclaration)
    {
        return $this->getDateTimeTypeDeclarationSQL($fieldDeclaration);
    }
    /**
     * Obtains DBMS specific SQL to be used to create date fields in statements
     * like CREATE TABLE.
     *
     * @param array $fieldDeclaration
     *
     * @return string
     *
     * @throws \MailPoetVendor\Doctrine\DBAL\DBALException If not supported on this platform.
     */
    public function getDateTypeDeclarationSQL(array $fieldDeclaration)
    {
        throw \MailPoetVendor\Doctrine\DBAL\DBALException::notSupported(__METHOD__);
    }
    /**
     * Obtains DBMS specific SQL to be used to create time fields in statements
     * like CREATE TABLE.
     *
     * @param array $fieldDeclaration
     *
     * @return string
     *
     * @throws \MailPoetVendor\Doctrine\DBAL\DBALException If not supported on this platform.
     */
    public function getTimeTypeDeclarationSQL(array $fieldDeclaration)
    {
        throw \MailPoetVendor\Doctrine\DBAL\DBALException::notSupported(__METHOD__);
    }
    /**
     * @param array $fieldDeclaration
     *
     * @return string
     */
    public function getFloatDeclarationSQL(array $fieldDeclaration)
    {
        return 'DOUBLE PRECISION';
    }
    /**
     * Gets the default transaction isolation level of the platform.
     *
     * @return integer The default isolation level.
     *
     * @see Doctrine\DBAL\Connection\TRANSACTION_* constants.
     */
    public function getDefaultTransactionIsolationLevel()
    {
        return \MailPoetVendor\Doctrine\DBAL\Connection::TRANSACTION_READ_COMMITTED;
    }
    /* supports*() methods */
    /**
     * Whether the platform supports sequences.
     *
     * @return boolean
     */
    public function supportsSequences()
    {
        return \false;
    }
    /**
     * Whether the platform supports identity columns.
     *
     * Identity columns are columns that receive an auto-generated value from the
     * database on insert of a row.
     *
     * @return boolean
     */
    public function supportsIdentityColumns()
    {
        return \false;
    }
    /**
     * Whether the platform emulates identity columns through sequences.
     *
     * Some platforms that do not support identity columns natively
     * but support sequences can emulate identity columns by using
     * sequences.
     *
     * @return boolean
     */
    public function usesSequenceEmulatedIdentityColumns()
    {
        return \false;
    }
    /**
     * Returns the name of the sequence for a particular identity column in a particular table.
     *
     * @param string $tableName  The name of the table to return the sequence name for.
     * @param string $columnName The name of the identity column in the table to return the sequence name for.
     *
     * @return string
     *
     * @throws \MailPoetVendor\Doctrine\DBAL\DBALException If not supported on this platform.
     *
     * @see    usesSequenceEmulatedIdentityColumns
     */
    public function getIdentitySequenceName($tableName, $columnName)
    {
        throw \MailPoetVendor\Doctrine\DBAL\DBALException::notSupported(__METHOD__);
    }
    /**
     * Whether the platform supports indexes.
     *
     * @return boolean
     */
    public function supportsIndexes()
    {
        return \true;
    }
    /**
     * Whether the platform supports partial indexes.
     *
     * @return boolean
     */
    public function supportsPartialIndexes()
    {
        return \false;
    }
    /**
     * Whether the platform supports altering tables.
     *
     * @return boolean
     */
    public function supportsAlterTable()
    {
        return \true;
    }
    /**
     * Whether the platform supports transactions.
     *
     * @return boolean
     */
    public function supportsTransactions()
    {
        return \true;
    }
    /**
     * Whether the platform supports savepoints.
     *
     * @return boolean
     */
    public function supportsSavepoints()
    {
        return \true;
    }
    /**
     * Whether the platform supports releasing savepoints.
     *
     * @return boolean
     */
    public function supportsReleaseSavepoints()
    {
        return $this->supportsSavepoints();
    }
    /**
     * Whether the platform supports primary key constraints.
     *
     * @return boolean
     */
    public function supportsPrimaryConstraints()
    {
        return \true;
    }
    /**
     * Whether the platform supports foreign key constraints.
     *
     * @return boolean
     */
    public function supportsForeignKeyConstraints()
    {
        return \true;
    }
    /**
     * Whether this platform supports onUpdate in foreign key constraints.
     *
     * @return boolean
     */
    public function supportsForeignKeyOnUpdate()
    {
        return $this->supportsForeignKeyConstraints() && \true;
    }
    /**
     * Whether the platform supports database schemas.
     *
     * @return boolean
     */
    public function supportsSchemas()
    {
        return \false;
    }
    /**
     * Whether this platform can emulate schemas.
     *
     * Platforms that either support or emulate schemas don't automatically
     * filter a schema for the namespaced elements in {@link
     * AbstractManager#createSchema}.
     *
     * @return boolean
     */
    public function canEmulateSchemas()
    {
        return \false;
    }
    /**
     * Returns the default schema name.
     *
     * @return string
     *
     * @throws \MailPoetVendor\Doctrine\DBAL\DBALException If not supported on this platform.
     */
    public function getDefaultSchemaName()
    {
        throw \MailPoetVendor\Doctrine\DBAL\DBALException::notSupported(__METHOD__);
    }
    /**
     * Whether this platform supports create database.
     *
     * Some databases don't allow to create and drop databases at all or only with certain tools.
     *
     * @return boolean
     */
    public function supportsCreateDropDatabase()
    {
        return \true;
    }
    /**
     * Whether the platform supports getting the affected rows of a recent update/delete type query.
     *
     * @return boolean
     */
    public function supportsGettingAffectedRows()
    {
        return \true;
    }
    /**
     * Whether this platform support to add inline column comments as postfix.
     *
     * @return boolean
     */
    public function supportsInlineColumnComments()
    {
        return \false;
    }
    /**
     * Whether this platform support the proprietary syntax "COMMENT ON asset".
     *
     * @return boolean
     */
    public function supportsCommentOnStatement()
    {
        return \false;
    }
    /**
     * Does this platform have native guid type.
     *
     * @return boolean
     */
    public function hasNativeGuidType()
    {
        return \false;
    }
    /**
     * Does this platform have native JSON type.
     *
     * @return boolean
     */
    public function hasNativeJsonType()
    {
        return \false;
    }
    /**
     * @deprecated
     * @todo Remove in 3.0
     */
    public function getIdentityColumnNullInsertSQL()
    {
        return "";
    }
    /**
     * Whether this platform supports views.
     *
     * @return boolean
     */
    public function supportsViews()
    {
        return \true;
    }
    /**
     * Does this platform support column collation?
     *
     * @return boolean
     */
    public function supportsColumnCollation()
    {
        return \false;
    }
    /**
     * Gets the format string, as accepted by the date() function, that describes
     * the format of a stored datetime value of this platform.
     *
     * @return string The format string.
     */
    public function getDateTimeFormatString()
    {
        return 'Y-m-d H:i:s';
    }
    /**
     * Gets the format string, as accepted by the date() function, that describes
     * the format of a stored datetime with timezone value of this platform.
     *
     * @return string The format string.
     */
    public function getDateTimeTzFormatString()
    {
        return 'Y-m-d H:i:s';
    }
    /**
     * Gets the format string, as accepted by the date() function, that describes
     * the format of a stored date value of this platform.
     *
     * @return string The format string.
     */
    public function getDateFormatString()
    {
        return 'Y-m-d';
    }
    /**
     * Gets the format string, as accepted by the date() function, that describes
     * the format of a stored time value of this platform.
     *
     * @return string The format string.
     */
    public function getTimeFormatString()
    {
        return 'H:i:s';
    }
    /**
     * Adds an driver-specific LIMIT clause to the query.
     *
     * @param string       $query
     * @param integer|null $limit
     * @param integer|null $offset
     *
     * @return string
     *
     * @throws DBALException
     */
    public final function modifyLimitQuery($query, $limit, $offset = null)
    {
        if ($limit !== null) {
            $limit = (int) $limit;
        }
        if ($offset !== null) {
            $offset = (int) $offset;
            if ($offset < 0) {
                throw new \MailPoetVendor\Doctrine\DBAL\DBALException("LIMIT argument offset={$offset} is not valid");
            }
            if ($offset > 0 && !$this->supportsLimitOffset()) {
                throw new \MailPoetVendor\Doctrine\DBAL\DBALException(\sprintf("Platform %s does not support offset values in limit queries.", $this->getName()));
            }
        }
        return $this->doModifyLimitQuery($query, $limit, $offset);
    }
    /**
     * Adds an driver-specific LIMIT clause to the query.
     *
     * @param string       $query
     * @param integer|null $limit
     * @param integer|null $offset
     *
     * @return string
     */
    protected function doModifyLimitQuery($query, $limit, $offset)
    {
        if ($limit !== null) {
            $query .= ' LIMIT ' . $limit;
        }
        if ($offset !== null) {
            $query .= ' OFFSET ' . $offset;
        }
        return $query;
    }
    /**
     * Whether the database platform support offsets in modify limit clauses.
     *
     * @return boolean
     */
    public function supportsLimitOffset()
    {
        return \true;
    }
    /**
     * Gets the character casing of a column in an SQL result set of this platform.
     *
     * @param string $column The column name for which to get the correct character casing.
     *
     * @return string The column name in the character casing used in SQL result sets.
     */
    public function getSQLResultCasing($column)
    {
        return $column;
    }
    /**
     * Makes any fixes to a name of a schema element (table, sequence, ...) that are required
     * by restrictions of the platform, like a maximum length.
     *
     * @param string $schemaElementName
     *
     * @return string
     */
    public function fixSchemaElementName($schemaElementName)
    {
        return $schemaElementName;
    }
    /**
     * Maximum length of any given database identifier, like tables or column names.
     *
     * @return integer
     */
    public function getMaxIdentifierLength()
    {
        return 63;
    }
    /**
     * Returns the insert SQL for an empty insert statement.
     *
     * @param string $tableName
     * @param string $identifierColumnName
     *
     * @return string
     */
    public function getEmptyIdentityInsertSQL($tableName, $identifierColumnName)
    {
        return 'INSERT INTO ' . $tableName . ' (' . $identifierColumnName . ') VALUES (null)';
    }
    /**
     * Generates a Truncate Table SQL statement for a given table.
     *
     * Cascade is not supported on many platforms but would optionally cascade the truncate by
     * following the foreign keys.
     *
     * @param string  $tableName
     * @param boolean $cascade
     *
     * @return string
     */
    public function getTruncateTableSQL($tableName, $cascade = \false)
    {
        $tableIdentifier = new \MailPoetVendor\Doctrine\DBAL\Schema\Identifier($tableName);
        return 'TRUNCATE ' . $tableIdentifier->getQuotedName($this);
    }
    /**
     * This is for test reasons, many vendors have special requirements for dummy statements.
     *
     * @return string
     */
    public function getDummySelectSQL()
    {
        return 'SELECT 1';
    }
    /**
     * Returns the SQL to create a new savepoint.
     *
     * @param string $savepoint
     *
     * @return string
     */
    public function createSavePoint($savepoint)
    {
        return 'SAVEPOINT ' . $savepoint;
    }
    /**
     * Returns the SQL to release a savepoint.
     *
     * @param string $savepoint
     *
     * @return string
     */
    public function releaseSavePoint($savepoint)
    {
        return 'RELEASE SAVEPOINT ' . $savepoint;
    }
    /**
     * Returns the SQL to rollback a savepoint.
     *
     * @param string $savepoint
     *
     * @return string
     */
    public function rollbackSavePoint($savepoint)
    {
        return 'ROLLBACK TO SAVEPOINT ' . $savepoint;
    }
    /**
     * Returns the keyword list instance of this platform.
     *
     * @return \MailPoetVendor\Doctrine\DBAL\Platforms\Keywords\KeywordList
     *
     * @throws \MailPoetVendor\Doctrine\DBAL\DBALException If no keyword list is specified.
     */
    public final function getReservedKeywordsList()
    {
        // Check for an existing instantiation of the keywords class.
        if ($this->_keywords) {
            return $this->_keywords;
        }
        $class = $this->getReservedKeywordsClass();
        $keywords = new $class();
        if (!$keywords instanceof \MailPoetVendor\Doctrine\DBAL\Platforms\Keywords\KeywordList) {
            throw \MailPoetVendor\Doctrine\DBAL\DBALException::notSupported(__METHOD__);
        }
        // Store the instance so it doesn't need to be generated on every request.
        $this->_keywords = $keywords;
        return $keywords;
    }
    /**
     * Returns the class name of the reserved keywords list.
     *
     * @return string
     *
     * @throws \MailPoetVendor\Doctrine\DBAL\DBALException If not supported on this platform.
     */
    protected function getReservedKeywordsClass()
    {
        throw \MailPoetVendor\Doctrine\DBAL\DBALException::notSupported(__METHOD__);
    }
    /**
     * Quotes a literal string.
     * This method is NOT meant to fix SQL injections!
     * It is only meant to escape this platform's string literal
     * quote character inside the given literal string.
     *
     * @param string $str The literal string to be quoted.
     *
     * @return string The quoted literal string.
     */
    public function quoteStringLiteral($str)
    {
        $c = $this->getStringLiteralQuoteCharacter();
        return $c . \str_replace($c, $c . $c, $str) . $c;
    }
    /**
     * Gets the character used for string literal quoting.
     *
     * @return string
     */
    public function getStringLiteralQuoteCharacter()
    {
        return "'";
    }
}
