Decrease value of a column in all rows using ActiveRecord

Archives Yii 1.0.x Discussions
1

Hello,

As it doesnt work this way:


        $attributes=array(

            'column'=>'column-1',

        );

        $update = Post::model();

        $update->updateAll($attributes);

could you point me to an alternative way to increase or decrease value of numeric column using ActiveRecord?

Any help appreciated

2

updateCounters() :) Welcome to the forums!

3 




/**

	 * Postprocessing after the record is saved

	 */

	protected function afterSave()

	{

			MyModel::model()->updateCounters(array('myValue'=>1));

	}

	

	protected function afterDelete()

	{

			MyModel::model()->updateCounters(array('myValue'=>-1));

	}

Not tested, but it should work.

Maybe you should take a look here:

http://www.yiiframework.com/doc/blog/comment.model

greetz from Germany

Sebi

1 Like
4

thanx, somehow i didnt noticed that method before:)

5

and one more thing about this:

if i need some column to have a value of another column, what’s the trick to do that with AR?

for example following sql


update myTable set column=otherColumn

thanx in advance

6

update(array(‘column’=>CDbExpression(‘otherColumn’))); might work, I haven’t tested though.