mattbit / mysql-compat

class InsertTest extends BridgeTestCase

{

    public function testLastInsertedId()

    {

        $this->assertEquals(0, $this->bridge->insertId());

        $this->bridge->query('INSERT INTO test_table VALUES (100, "test insert")');

        $this->assertEquals(100, $this->bridge->insertId());

        $this->bridge->query('INSERT INTO test_table (testfield) VALUES ("test insert")');

        $this->assertEquals(101, $this->bridge->insertId());

    }

}

        $this->assertEquals(5, $this->bridge->affectedRows());

    }

    public function testInsertAffectedRows()

    {

        $this->assertEquals(0, $this->bridge->affectedRows());

        $this->bridge->query("INSERT INTO test_table VALUES (100, 'test insert 100')");

        $this->assertEquals(1, $this->bridge->affectedRows());

        $this->bridge->query("INSERT INTO test_table VALUES (101, 'test insert 101'), (102, 'test insert 102')");

        $this->assertEquals(2, $this->bridge->affectedRows());

    }

    public function testDeleteAffectedRows()

    {

        $this->assertEquals(2, $this->bridge->affectedRows());

    }

    public function testDeleteAffectedRows()

    {

        $this->assertEquals(0, $this->bridge->affectedRows());

        $this->bridge->query('DELETE FROM test_table WHERE id = 1');

        $this->assertEquals(1, $this->bridge->affectedRows());

        $this->bridge->query('DELETE FROM test_table WHERE id > 5');

        $this->assertEquals(5, $this->bridge->affectedRows());

    }

    public function testNumRows()

    {