MWPostgreSqlPlatform.php

Go to the documentation of this file.

<?php
 
namespace Wikimedia\Rdbms;
 
use Doctrine\DBAL\Platforms\PostgreSQL94Platform;
use Wikimedia\Timestamp\ConvertibleTimestamp;
 
class MWPostgreSqlPlatform extends PostgreSQL94Platform {
    public function getDefaultValueDeclarationSQL( $column ) {
        $type = $column['type'];
        $default = $column['default'] ?? null;
 
        if ( $type instanceof TimestampType && $default ) {
            $timestamp = new ConvertibleTimestamp( $default );
            $pgTimestamp = $timestamp->getTimestamp( TS_POSTGRES );
 
            return " DEFAULT '$pgTimestamp' ";
        }
 
        return parent::getDefaultValueDeclarationSQL( $column );
    }
 
    protected function _getCreateTableSQL( $name, $columns, array $options = [] ) {
        // phpcs:enable
        $tableSql = parent::_getCreateTableSQL( $name, $columns, $options );
        foreach ( $columns as $column ) {
            if ( $column['type'] instanceof EnumType && $column['fixed'] ) {
                // PostgreSQL does support ENUM datatype but they need to be
                // created severally with CREATE TYPE command for each column
                // as it's not possible to feed the values directly in the
                // column declaration as it could be done in MySQL.
                $typeSql = $column['type']->makeEnumTypeSql( $column, $this );
                array_unshift( $tableSql, $typeSql );
            }
        }
 
        return $tableSql;
    }
 
    public function getFloatDeclarationSQL( array $column ) {
        return 'FLOAT';
    }
 
    public function getDateTimeTzTypeDeclarationSQL( array $column ) {
        return 'TIMESTAMPTZ';
    }
}