AbstractSpecifics.php

Go to the documentation of this file.

<?php
namespace TYPO3\CMS\Dbal\Database\Specifics;

/*
 * This file is part of the TYPO3 CMS project.
 *
 * It is free software; you can redistribute it and/or modify it under
 * the terms of the GNU General Public License, either version 2
 * of the License, or any later version.
 *
 * For the full copyright and license information, please read the
 * LICENSE.txt file that was distributed with this source code.
 *
 * The TYPO3 project - inspiring people to share!
 */

abstract class AbstractSpecifics
{
    const TABLE_MAXLENGTH = 'table_maxlength';
    const FIELD_MAXLENGTH = 'field_maxlength';
    const LIST_MAXEXPRESSIONS = 'list_maxexpressions';
    const PARTIAL_STRING_INDEX = 'partial_string_index';
    const CAST_FIND_IN_SET = 'cast_find_in_set';

    protected $specificProperties = [];

    protected $nativeToMetaFieldTypeMap = [
        'STRING' => 'C',
        'CHAR' => 'C',
        'VARCHAR' => 'C',
        'TINYBLOB' => 'C',
        'TINYTEXT' => 'C',
        'ENUM' => 'C',
        'SET' => 'C',
        'TEXT' => 'XL',
        'LONGTEXT' => 'XL',
        'MEDIUMTEXT' => 'XL',
        'IMAGE' => 'B',
        'LONGBLOB' => 'B',
        'BLOB' => 'B',
        'MEDIUMBLOB' => 'B',
        'YEAR' => 'D',
        'DATE' => 'D',
        'TIME' => 'T',
        'DATETIME' => 'T',
        'TIMESTAMP' => 'T',
        'FLOAT' => 'F',
        'DOUBLE' => 'F',
        'INT' => 'I8',
        'INTEGER' => 'I8',
        'TINYINT' => 'I8',
        'SMALLINT' => 'I8',
        'MEDIUMINT' => 'I8',
        'BIGINT' => 'I8',
    ];

    protected $nativeToMetaFieldTypeOverrides = [];

    protected $metaToNativeFieldTypeMap = [
        'C' => 'VARCHAR',
        'C2' => 'VARCHAR',
        'X' => 'LONGTEXT',
        'XL' => 'LONGTEXT',
        'X2' => 'LONGTEXT',
        'B' => 'LONGBLOB',
        'D' => 'DATE',
        'T' => 'DATETIME',
        'L' => 'TINYINT',
        'I' => 'BIGINT',
        'I1' => 'BIGINT',
        'I2' => 'BIGINT',
        'I4' => 'BIGINT',
        'I8' => 'BIGINT',
        'F' => 'DOUBLE',
        'N' => 'NUMERIC'
    ];

    protected $metaToNativeFieldTypeOverrides = [];

    public function __construct()
    {
        $this->nativeToMetaFieldTypeMap = array_merge($this->nativeToMetaFieldTypeMap, $this->nativeToMetaFieldTypeOverrides);
        $this->metaToNativeFieldTypeMap = array_merge($this->metaToNativeFieldTypeMap, $this->metaToNativeFieldTypeOverrides);
    }

    public function specificExists($specific)
    {
        return isset($this->specificProperties[$specific]);
    }

    public function getSpecific($specific)
    {
        return $this->specificProperties[$specific];
    }

    public function splitMaxExpressions($expressionList, $preserveArrayKeys = false)
    {
        if (!$this->specificExists(self::LIST_MAXEXPRESSIONS)) {
            return [$expressionList];
        }

        return array_chunk($expressionList, $this->getSpecific(self::LIST_MAXEXPRESSIONS), $preserveArrayKeys);
    }

    public function truncateIdentifier($identifier, $specific)
    {
        if (!$this->specificExists($specific)) {
            return $identifier;
        }

        $maxLength = $this->getSpecific($specific);
        if (strlen($identifier) > $maxLength) {
            $truncateChars = 10;
            $identifier = substr($identifier, 0, $maxLength - $truncateChars) . '_' . substr(sha1($identifier), 0, $truncateChars - 1);
        }

        return $identifier;
    }

    public function transformQueryParts(&$select_fields, &$from_table, &$where_clause, &$groupBy = '', &$orderBy = '', &$limit = '')
    {
    }

    public function transformFieldRowToMySQL($fieldRow, $metaType)
    {
        $mysqlType = $this->getNativeFieldType($metaType);
        $mysqlType .= $this->getNativeFieldLength($mysqlType, $fieldRow['max_length']);

        $fieldRow['Field'] = $fieldRow['name'];
        $fieldRow['Type'] = strtolower($mysqlType);
        $fieldRow['Null'] = $this->getNativeNotNull($fieldRow['not_null']);
        $fieldRow['Key'] = $this->getNativeKeyForField($fieldRow);
        $fieldRow['Default'] = $this->getNativeDefaultValue($fieldRow);
        $fieldRow['Extra'] = $this->getNativeExtraFieldAttributes($fieldRow);

        return $fieldRow;
    }

    public function getNativeFieldType($metaType)
    {
        $metaType = strtoupper($metaType);
        return empty($this->metaToNativeFieldTypeMap[$metaType]) ? $metaType : $this->metaToNativeFieldTypeMap[$metaType];
    }

    public function getMetaFieldType($nativeType)
    {
        $nativeType = strtoupper($nativeType);
        return empty($this->nativeToMetaFieldTypeMap[$nativeType]) ? 'N' : $this->nativeToMetaFieldTypeMap[$nativeType];
    }

    public function getNativeFieldLength($mysqlType, $maxLength)
    {
        if ($maxLength === -1) {
            return '';
        }
        switch ($mysqlType) {
            case 'INT':
                return '(11)';
            default:
                return '(' . $maxLength . ')';
        }
    }

    protected function getNativeNotNull($notNull)
    {
        return (bool)$notNull ? 'NO' : 'YES';
    }

    protected function getNativeDefaultValue($fieldDefinition)
    {
        return $fieldDefinition['default_value'];
    }

    protected function getNativeKeyForField($fieldRow)
    {
        return '';
    }

    protected function getNativeExtraFieldAttributes($fieldRow)
    {
        return '';
    }
}