$model->save and ON DUPLICATE KEY UPDATE clause

Yii 2.0 General Discussions
1

Hi all!
I load model and try to save it.
How to add ON DUPLICATE KEY clause for set some instruction if record already exists?

All i want is ‘ON DUPLICATE KEY UPDATE some_col = some_col + some_val’
:))

2

There is yii\db\QueryBuilder::upsert() but I’m not aware of anything like it in Active Record.

What are you trying to accomplish that leads you to ask about ON DUPLICATE KEY UPDATE?

3

Thanx! All in all I stopped on upsert tool.

it is just addToCart functional: if thing already in cart, just update qty

4

If you prefer to use AR, you could implement the logic in PHP instead of the DB using yii\db\BaseActiveRecord::$isNewRecord.

1 Like