1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38
|
<?php
namespace Wikimedia\Rdbms;
use Doctrine\DBAL\Platforms\AbstractPlatform;
use Doctrine\DBAL\Types\Type;
/**
* Handling timestamp edge cases in mediawiki.
* https://www.mediawiki.org/wiki/Manual:Timestamp
*/
class TimestampType extends Type {
public const TIMESTAMP = 'mwtimestamp';
public function getSQLDeclaration( array $fieldDeclaration, AbstractPlatform $platform ) {
if ( $platform->getName() == 'mysql' ) {
// "infinite" (in expiry values has to be VARBINARY)
if ( isset( $fieldDeclaration['allowInfinite'] ) && $fieldDeclaration['allowInfinite'] ) {
return 'VARBINARY(14)';
}
return 'BINARY(14)';
}
if ( $platform->getName() == 'sqlite' ) {
return 'BLOB';
}
if ( $platform->getName() == 'postgresql' ) {
return 'TIMESTAMPTZ';
}
return $platform->getDateTimeTzTypeDeclarationSQL( $fieldDeclaration );
}
public function getName() {
return self::TIMESTAMP;
}
}
|