doctrine / dbal

    /**

     * @group DDC-1657

     */

    public function testAutoIncrementSequences()

    {

        $oldSchema = new Schema();

        $table     = $oldSchema->createTable("foo");

        $table->addColumn("id", "integer", array("autoincrement" => true));

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

        $oldSchema->createSequence("foo_id_seq");

        $newSchema = new Schema();

        $table     = $newSchema->createTable("foo");

        $table->addColumn("id", "integer", array("autoincrement" => true));

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

        $c    = new Comparator();

        $diff = $c->compare($oldSchema, $newSchema);

        self::assertCount(0, $diff->removedSequences);

    }

    /**

     * Check that added autoincrement sequence is not populated in newSequences

     * @group DBAL-562

     */

    public function testAutoIncrementNoSequences()

    {

        $oldSchema = new Schema();

        $table     = $oldSchema->createTable("foo");

        $table->addColumn("id", "integer", array("autoincrement" => true));

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

        $newSchema = new Schema();

        $table     = $newSchema->createTable("foo");

        $table->addColumn("id", "integer", array("autoincrement" => true));

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

        $newSchema->createSequence("foo_id_seq");

        $c    = new Comparator();

        $diff = $c->compare($oldSchema, $newSchema);

        self::assertCount(0, $diff->newSequences);

    }

    /**

     * You can get multiple drops for a FK when a table referenced by a foreign

     * key is deleted, as this FK is referenced twice, once on the orphanedForeignKeys