How to implement TimestampBehavior in batchInsert()?

Question

I have a problem when I use batchInsert() to insert multiple records.

Yii::$app->db->createCommand()->batchInsert($this->model->tableName(), $columns, $rows)->execute()

And I has implemented the TimestampBehavior in my BaseModel

/**
 * @inheritdoc
 */
public function behaviors()
{
    return [
        [
            'class' => TimestampBehavior::className(),
            'createdAtAttribute' => 'createdAt',
            'updatedAtAttribute' => 'updatedAt'
        ]
    ];
}

But when I executed then it's not working?

`it's not working` a little more specificity would be just grand. — BVengerov, Oct 07 '16 at 08:20
See also this related [question](http://stackoverflow.com/questions/39600150/yii2-batch-insert-with-activerecord). — arogachev, Oct 11 '16 at 04:58

score 0 · Answer 1 · answered Oct 07 '16 at 08:09

This behavior is attached to ActiveRecord and executed during its life cycle while batchInsert executes raw SQL query so you can not use it there.

You can generate this columns values though.

Add 'createdAt' and 'updatedAt' to $columns.
For every row in $rows add time() as value for createdAt and updatedAt column.

This simply fills these columns with current unix timestamp.

score 0 · Answer 2 · answered Oct 10 '16 at 22:23

Yii Behaviors are a functionality directly related to Active Record.

And Active Record is fundamentally different than the Query Builder (which you get by calling Yii::$app->db->createCommand()). They are two different ways of working with records in the database.

So the simplest answer to your question is that you can not use Yii Behaviors when working with the Query Builder.

How to implement TimestampBehavior in batchInsert()?

2 Answers2