Affected rows?

Question

Affected rows?

Zeniox Nov '13

Created Nov '13	Last Reply Jun '18	Replies 2	Views 2215	Votes 0

Zeniox 6.0k

Nov '13

Hi!!

My question is: In a custom model It's possible to know if a select has affected to some row?

Something like that:


class MyModel extends \Phalcon\Mvc\Model
{
    public function customSQL()
    {
        $mysql = 'DELETE FROM XXX WHERE condition=1';

        $this->getModelsManager()->executeQuery($mysql);
        return ($this->getReadConnection()->affectedRows()!=null) && 
                $this->getReadConnection()->affectedRows()>0;
    }
}

Even on sql success, always $this->getReadConnection()->affectedRows() is null ... :(

Any idea?, what am I doing wrong?

Phalcon · Answer 1 · 2013-11-18T20:49:31-07:00

Currently the query you're executing is processed first by PHQL and then it's executed one by one, so probably that code won't give you the expected result, you could better try:

class MyModel extends \Phalcon\Mvc\Model
{
    public function customSQL()
    {
        $mysql = 'DELETE FROM XXX WHERE condition=1';
        $this->getWriteConnection()->execute($mysql);
        return ($this->getReadConnection()->affectedRows()!=null) && 
                $this->getReadConnection()->affectedRows()>0;
    }
}

Zeniox · Answer 2 · 2013-11-19T04:27:12-07:00

Zeniox
6.0k

Nov '13

Thanks phalcon!!

But.. not works :( again always null and the select is working well.

Zeniox · Answer 3 · 2013-11-19T08:10:30-07:00

Oh! I'm fool!!!

You are right! , I have an active bd transaction and not exists rows affected... If i deactivate transactions return one row.

So... this means , in bd transactions I cannot check If the db operation has worked fine?

sherlock-wong · Answer 4 · 2018-06-25T21:02:04-07:00

I don't think that it's because of your transaction. I also use the Transaction but it works and return 1.