Yii2 How to do batchInsert with ON DUPLICATE KEY UPDATE?

Question

Yii

yii\db\Command batchInsert( $table, $columns, $rows ) does not imply padding.
Tell me how to add to the request at the end
ON DUPLICATE KEY UPDATE
`price_current` = 7,
`price_old` = 2

Answer 1

So far I see only one crutch option
Form an array for batchInsert -> copy it to a string using getRawSql -> add a condition to the string and execute the command through new sql

Answer 2

specially made behavior for this https://github.com/kozhemin/yii2-insert-update-behavior

Answer 3

Starting with Yii 2.0.14, you can use the upsert method of the QueryBuilder class