PostgresSpecifics.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!
 */

use TYPO3\CMS\Core\Utility\GeneralUtility;
use TYPO3\CMS\Core\Utility\StringUtility;

class PostgresSpecifics extends AbstractSpecifics
{
    protected $specificProperties = [
        self::CAST_FIND_IN_SET => true
    ];

    protected $nativeToMetaFieldTypeOverrides = [
        'TINYBLOB' => 'B',
        'INT' => 'I4',
        'INTEGER' => 'I4',
        'TINYINT' => 'I2',
        'SMALLINT' => 'I2',
        'MEDIUMINT' => 'I4'
    ];

    protected $metaToNativeFieldTypeOverrides = [
        'R' => 'INT',
        'I' => 'INT',
        'I1' => 'SMALLINT',
        'I2' => 'SMALLINT',
        'I4' => 'INT',
    ];

    public function getNativeFieldLength($mysqlType, $maxLength)
    {
        if ($maxLength === -1) {
            return '';
        }
        switch ($mysqlType) {
            case 'DOUBLE':
                return '';
            case 'TINYINT':
                return '(4)';
            case 'SMALLINT':
                return '(6)';
            case 'MEDIUMINT':
                return '(9)';
            case 'INT':
                return '(11)';
            case 'BIGINT':
                return '(20)';
            default:
                return '(' . $maxLength . ')';
        }
    }

    protected function getNativeDefaultValue($fieldDefinition)
    {
        if (!$fieldDefinition['has_default']) {
            $returnValue = null;
        } elseif ($fieldDefinition['type'] === 'SERIAL' && substr($fieldDefinition['default_value'], 0, 7) === 'nextval') {
            $returnValue = null;
        } elseif ($fieldDefinition['type'] === 'varchar') {
            // Strip character class and unquote string
            if (StringUtility::beginsWith($fieldDefinition['default_value'], 'NULL::')) {
                $returnValue = null;
            } else {
                $returnValue = str_replace("\\'", "'", preg_replace('/\'(.*)\'(::(?:character\svarying|varchar|character|char|text)(?:\(\d+\))?)?\z/', '\\1', $fieldDefinition['default_value']));
            }
        } elseif (substr($fieldDefinition['type'], 0, 3) === 'int') {
            $returnValue = (int)preg_replace('/^\(?(\-?\d+)\)?$/', '\\1', $fieldDefinition['default_value']);
        } else {
            $returnValue = $fieldDefinition['default_value'];
        }
        return $returnValue;
    }

    protected function getNativeKeyForField($fieldDefinition)
    {
        if (isset($fieldDefinition['primary_key']) && (bool)$fieldDefinition['primary_key']) {
            $returnValue = 'PRI';
        } elseif (isset($fieldDefinition['unique']) && (bool)$fieldDefinition['unique']) {
            $returnValue = 'UNI';
        } else {
            $returnValue = '';
        }
        return $returnValue;
    }

    protected function getNativeExtraFieldAttributes($fieldDefinition)
    {
        if ($fieldDefinition['type'] === 'SERIAL' || substr($fieldDefinition['default_value'], 0, 7) === 'nextval') {
            return 'auto_increment';
        }
        return '';
    }

    public function transformQueryParts(&$select_fields, &$from_table, &$where_clause, &$groupBy = '', &$orderBy = '', &$limit = '')
    {
        // Strip orderBy part if select statement is a count
        if (preg_match_all('/count\(([^)]*)\)/i', $select_fields, $matches)) {
            $orderByFields = GeneralUtility::trimExplode(',', $orderBy);
            $groupByFields = GeneralUtility::trimExplode(',', $groupBy);
            foreach ($matches[1] as $matchedField) {
                $field = $matchedField;
                // Lookup if the field in COUNT() statement is used in GROUP BY statement
                $index = array_search($field, $groupByFields, true);
                if ($index !== false) {
                    // field is used in GROUP BY, continue with next field
                    continue;
                }
                // If that field isn't used in GROUP BY statement, drop the ordering for compatibility reason
                $index = array_search($field, $orderByFields, true);
                if ($index !== false) {
                    unset($orderByFields[$index]);
                }
            }
            $orderBy = implode(', ', $orderByFields);
        }
    }
}