How to make multiple update or insert in Yii1?

Question

Yii

Hello.
Given :

1. yii1.1.15
2. Table with columns id, user_id, meta_key, meta_val

There was a need to make a multiple addition of records to the table with user_id == 3, but if there is a row with an equal meta_key, then it needs to be updated.
Question : how to implement it correctly?

Answer 1

With createMultipleInsertCommand

Answer 2

Tabular input
Manual on the link is quite abstract, but conveys the essence. Going through the data, look at the meta_key and determine whether you need to update the record or add it. Transactions can be used to avoid partial processing.

Answer 3

yii has an updateall function. She is best suited for this task.