/**
* 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;
}
