Skip to content

Instantly share code, notes, and snippets.

@ScullWM
Created November 29, 2018 12:58
Show Gist options
  • Save ScullWM/9479c1573d8b175617d0b49f6c68cce6 to your computer and use it in GitHub Desktop.
Save ScullWM/9479c1573d8b175617d0b49f6c68cce6 to your computer and use it in GitHub Desktop.
<?php
namespace App\Doctrine\Driver;
use Doctrine\DBAL\Schema\PostgreSqlSchemaManager;
use Doctrine\DBAL\Schema\Sequence;
class Postgre10SqlSchemaManager extends PostgreSqlSchemaManager
{
/**
* {@inheritdoc}
*/
protected function _getPortableSequenceDefinition($sequence)
{
if ($sequence['schemaname'] !== 'public') {
$sequenceName = $sequence['schemaname'] . "." . $sequence['relname'];
} else {
$sequenceName = $sequence['relname'];
}
if ( ! isset($sequence['increment_by'], $sequence['min_value'])) {
$data = $this->_conn->fetchAssoc('SELECT min_value, increment_by FROM ' . $this->_platform->quoteIdentifier($sequenceName));
$sequence += $data;
}
return new Sequence($sequenceName, $sequence['increment_by'], $sequence['min_value']);
}
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment