/** * Test getAffectedRows method. * * @return void * * @since 11.1 */ public function testGetAffectedRows() { $query = $this->object->getQuery(true); $query->delete(); $query->from('jos_dbtest'); $this->object->setQuery($query); $result = $this->object->query(); $this->assertThat($this->object->getAffectedRows(), $this->equalTo(4), __LINE__); }
/** * Set documents as favorite/unfavorite * * @param array $ids documents IDs * @param int $value value use constantS JOOMDOC_FAVORITE/JOOMDOC_STANDARD to set as favorite/unfavorite * @return int num of affected rows */ function setFavorite($ids, $value) { if (count($ids)) { JArrayHelper::toInteger($ids); $this->_db->setQuery(sprintf('UPDATE `#__joomdoc` SET `favorite` = %d WHERE `id` IN (%s)', $value, implode(', ', $ids))); $this->_db->query(); JModelLegacy::getInstance(JOOMDOC_DOCUMENTS, JOOMDOC_MODEL_PREFIX)->flat(null, $ids); return $this->_db->getAffectedRows(); } return 0; }