/** * Test if affected rows returns the correct value. */ public function testAffectedRows() { $this->assertEquals(1, $this->connection->executeFirstCell('SELECT COUNT(`id`) AS "row_count" FROM `writers` WHERE `name` = ?', 'Leo Tolstoy')); $this->connection->execute('UPDATE `writers` SET `name` = ? WHERE `name` = ?', 'Lev Nikolayevich Tolstoy', 'Leo Tolstoy'); $this->assertEquals(1, $this->connection->affectedRows()); $this->connection->execute('UPDATE `writers` SET `name` = ? WHERE `name` = ?', 'Nothing to Update', 'Leo Tolstoy'); $this->assertEquals(0, $this->connection->affectedRows()); }