Clean certain entries in DB through collection

Question

I searched for a way to clean rows in DB, where something, through a resource collection call, but could not find relevant information.

I.e., I have table with fields store_id , path , value and 400 rows and I want to clean the rows where the store_id is 1 (or something else). My question is - is this possible through a collection call, or with the resource model?

The table is custom, and I have resource model for it.

Answer 1

It is possible.

$collection = Mage::getModel('[namespace]/[module]')->getCollection()
    ->addFieldToFilter('store_id', 1);

foreach ($collection as $item) {
    $item->delete();
}

[EDIT]
An alternative is to add this method in your resource model (not collection model, just resource).

public function deleteByStoreId($storeId) {
    $adapter = $this->_getWriteAdapter();
    $condition = array(
        'store_id = ?'     => $storeId,
    );
    $adapter->delete($this->getMainTable(), $condition);
    return $this;
}

and then just call

Mage::getResourceModel('[namespace]/[module]')->deleteByStoreId();

of course this is just an example. You can make a general delete method so you can pass as many filters as you want.