doctrine / dbal

        self::assertEquals($this->getAlterTableColumnCommentsSQL(), $this->_platform->getAlterTableSQL($tableDiff));

    }

    public function testCreateTableColumnTypeComments()

    {

        $table = new Table('test');

        $table->addColumn('id', 'integer');

        $table->addColumn('data', 'array');

        $table->setPrimaryKey(array('id'));

        self::assertEquals($this->getCreateTableColumnTypeCommentsSQL(), $this->_platform->getCreateTableSQL($table));

    }

    public function getCreateTableColumnCommentsSQL()

    {

    /**

     * @group DBAL-374

     */

    public function testQuotedColumnInPrimaryKeyPropagation()

    {

        $table = new Table('`quoted`');

        $table->addColumn('create', 'string');

        $table->setPrimaryKey(array('create'));

        $sql = $this->_platform->getCreateTableSQL($table);

        self::assertEquals($this->getQuotedColumnInPrimaryKeySQL(), $sql);

    }

    abstract protected function getQuotedColumnInPrimaryKeySQL();

    abstract protected function getQuotedColumnInIndexSQL();

    /**

     * @group DBAL-374

     */

    public function testQuotedColumnInIndexPropagation()

    {

        $table = new Table('`quoted`');

        $table->addColumn('create', 'string');

        $table->addIndex(array('create'));

        $sql = $this->_platform->getCreateTableSQL($table);

        self::assertEquals($this->getQuotedColumnInIndexSQL(), $sql);

    }

    public function testQuotedNameInIndexSQL()

    {

        self::assertEquals($this->getQuotedColumnInIndexSQL(), $sql);

    }

    public function testQuotedNameInIndexSQL()

    {

        $table = new Table('test');

        $table->addColumn('column1', 'string');

        $table->addIndex(array('column1'), '`key`');

        $sql = $this->_platform->getCreateTableSQL($table);

        self::assertEquals($this->getQuotedNameInIndexSQL(), $sql);

    }

    /**

     * @group DBAL-374

        self::assertEquals('DROP TABLE foobar', $this->_platform->getDropTableSQL('foobar'));

    }

    public function testGenerateTableWithAutoincrement()

    {

        $table = new \Doctrine\DBAL\Schema\Table('autoinc_table');

        $column = $table->addColumn('id', 'integer');

        $column->setAutoincrement(true);

        self::assertEquals(array('CREATE TABLE autoinc_table (id SERIAL NOT NULL)'), $this->_platform->getCreateTableSQL($table));

    }

    public static function serialTypes() : array

    {