TYPO3\CMS\Dbal\Database\Specifics\PostgresSpecifics Class Reference

Inheritance diagram for TYPO3\CMS\Dbal\Database\Specifics\PostgresSpecifics:

Public Member Functions
	getNativeFieldLength ($mysqlType, $maxLength)
	transformQueryParts (&$select_fields, &$from_table, &$where_clause, &$groupBy='', &$orderBy='', &$limit='')
Public Member Functions inherited from TYPO3\CMS\Dbal\Database\Specifics\AbstractSpecifics
	__construct ()
	specificExists ($specific)
	getSpecific ($specific)
	splitMaxExpressions ($expressionList, $preserveArrayKeys=false)
	truncateIdentifier ($identifier, $specific)
	transformQueryParts (&$select_fields, &$from_table, &$where_clause, &$groupBy='', &$orderBy='', &$limit='')
	transformFieldRowToMySQL ($fieldRow, $metaType)
	getNativeFieldType ($metaType)
	getMetaFieldType ($nativeType)
	getNativeFieldLength ($mysqlType, $maxLength)

Protected Member Functions
	getNativeDefaultValue ($fieldDefinition)
	getNativeKeyForField ($fieldDefinition)
	getNativeExtraFieldAttributes ($fieldDefinition)
Protected Member Functions inherited from TYPO3\CMS\Dbal\Database\Specifics\AbstractSpecifics
	getNativeNotNull ($notNull)
	getNativeDefaultValue ($fieldDefinition)
	getNativeKeyForField ($fieldRow)
	getNativeExtraFieldAttributes ($fieldRow)

Protected Attributes
	$specificProperties
	$nativeToMetaFieldTypeOverrides
	$metaToNativeFieldTypeOverrides
Protected Attributes inherited from TYPO3\CMS\Dbal\Database\Specifics\AbstractSpecifics
	$specificProperties = []
	$nativeToMetaFieldTypeMap
	$nativeToMetaFieldTypeOverrides = []
	$metaToNativeFieldTypeMap
	$metaToNativeFieldTypeOverrides = []

Additional Inherited Members
Public Attributes inherited from TYPO3\CMS\Dbal\Database\Specifics\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'

Detailed Description

This class contains the specifics for PostgreSQL DBMS. Any logic is in AbstractSpecifics.

Definition at line 24 of file PostgresSpecifics.php.

Member Function Documentation

getNativeDefaultValue()

TYPO3\CMS\Dbal\Database\Specifics\PostgresSpecifics::getNativeDefaultValue (   $fieldDefinition )

protected

Return the default value of a field formatted to match the native MySQL SQL dialect

Parameters

array

$fieldDefinition

Returns

mixed

Definition at line 96 of file PostgresSpecifics.php.

References TYPO3\CMS\Core\Utility\StringUtility\beginsWith().

getNativeExtraFieldAttributes()

TYPO3\CMS\Dbal\Database\Specifics\PostgresSpecifics::getNativeExtraFieldAttributes (   $fieldDefinition )

protected

Return the MySQL native extra field information - https://dev.mysql.com/doc/refman/5.5/en/show-columns.html auto_increment for columns that have the AUTO_INCREMENT attribute on update CURRENT_TIMESTAMP for TIMESTAMP columns that have the ON UPDATE CURRENT_TIMESTAMP attribute.

Parameters

array

$fieldDefinition

Returns

string

Definition at line 148 of file PostgresSpecifics.php.

getNativeFieldLength()

TYPO3\CMS\Dbal\Database\Specifics\PostgresSpecifics::getNativeFieldLength	(		$mysqlType,
			$maxLength
	)

Determine the native field length information for a table field.

Parameters

string	$mysqlType
int	$maxLength

Returns

string

Definition at line 67 of file PostgresSpecifics.php.

getNativeKeyForField()

TYPO3\CMS\Dbal\Database\Specifics\PostgresSpecifics::getNativeKeyForField (   $fieldDefinition )

protected

Return the MySQL native key type indicator - https://dev.mysql.com/doc/refman/5.5/en/show-columns.html PRI - the column is a PRIMARY KEY or is one of the columns in a multiple-column PRIMARY KEY UNI - the column is the first column of a UNIQUE index MUL - the column is the first column of a nonunique index If more than one of the values applies return the one with the highest priority, in the order PRI, UNI, MUL If none applies return empty value.

Parameters

array

$fieldDefinition

Returns

string

Definition at line 128 of file PostgresSpecifics.php.

transformQueryParts()

TYPO3\CMS\Dbal\Database\Specifics\PostgresSpecifics::transformQueryParts	(	&	$select_fields,
		&	$from_table,
		&	$where_clause,
		&	$groupBy = '',
		&	$orderBy = '',
		&	$limit = ''
	)

Adjust query parts for various DBMS

Parameters

string	$select_fields
string	$from_table
string	$where_clause
string	$groupBy
string	$orderBy
string	$limit

Returns

void

Definition at line 167 of file PostgresSpecifics.php.

References TYPO3\CMS\Core\Utility\GeneralUtility\trimExplode().

Member Data Documentation

$metaToNativeFieldTypeOverrides

TYPO3\CMS\Dbal\Database\Specifics\PostgresSpecifics::$metaToNativeFieldTypeOverrides

protected

Initial value:

= [
        'R' => 'INT'

Definition at line 52 of file PostgresSpecifics.php.

$nativeToMetaFieldTypeOverrides

TYPO3\CMS\Dbal\Database\Specifics\PostgresSpecifics::$nativeToMetaFieldTypeOverrides

protected

Initial value:

= [
        'TINYBLOB' => 'B'

Contains the DBMS specific mapping overrides for native MySQL to ADOdb meta field types

Definition at line 38 of file PostgresSpecifics.php.

$specificProperties

TYPO3\CMS\Dbal\Database\Specifics\PostgresSpecifics::$specificProperties

protected

Initial value:

= [
        self::CAST_FIND_IN_SET => true
    ]

Definition at line 31 of file PostgresSpecifics.php.