fwolf / fwlib

    /**

     * 3 Add an error SQL

     */

    public function testExecuteErrorSql()

    {

        $this->expectOutputRegex('/Execute abort./');

        self::$sds->setSql(

            43,

            'ALTER TABLE ' . self::$tableUser . '

                ADD COLUMN temp1 INT NOT NULL DEFAULT 0'

        );

        self::$sds->execute();

        $this->assertEquals(43, self::$sds->lastId);

        $this->assertEquals(42, self::$sds->lastIdDone);

    }

    /**

    /**

     * 4 Add SQL with smaller id, will not execute

     */

    public function testExecuteSmallId()

    {

        $this->expectOutputRegex('/No un-done SQL to do./');

        self::$sds->setSql(

            22,

            'ALTER TABLE ' . self::$tableUser . '

                ADD COLUMN temp2 INT NOT NULL DEFAULT 0'

        );

        self::$sds->execute();

        // Error SQL 43 is cleared by execute()

        $this->assertEquals(42, self::$sds->getLastId());

        $this->assertEquals(42, self::$sds->getLastIdDone());

    }

}