kozhemin/yii2-insert-update-behavior

Simple Behavior INSERT ON DUPLICATE KEY UPDATE or INSERT IGNORE

Yii2 Insert Update Behavior

Simple Behavior INSERT ON DUPLICATE KEY UPDATE or INSERT IGNORE, _(*1)

Installation

The preferred way to install this extension is through composer., _(*2)

Either run, _(*3)

php composer.phar require kozhemin/yii2-insert-update-behavior:dev-master

or add, _(*4)

"kozhemin/yii2-insert-update-behavior": "dev-master"

to the require section of your composer.json file., _(*5)

Usage

This behavior allows you to create queries for INSERT ON DUPLICATE KEY UPDATE or INSERT IGNORE, _(*6)

For example:, _(*7)

Attach a new behavior to your model, _(*8)

   public function behaviors()
   {
       return[
            \kozhemin\dbHelper\InsertUpdate::className(),
       ];
   }

usage, _(*9)

   $dataInsert = [ ['title text', 'description'], ['title2 text', 'description2'], ['title3 text', 'descriptio3'] ];
   //Optional column parameter
   $column = ['title', 'description'];

    //INSERT ON DUPLICATE KEY UPDATE
    $model = new Post();
    $model->InsertUpdate($dataInsert, $column)

or, _(*10)

    //INSERT IGNORE
    $model = new Post();
    $model->insertIgnore($dataInsert, $column)