dotzero/yii-insertupdate-behavior

This package is abandoned and no longer maintained. No replacement package was suggested.

The Yii InsertUpdateCommandBehavior extension adds up some functionality to the default possibilites of yii´s CDbCommand implementation

Maintainers

Details

github.com/zero-archive/yii-insertupdate-behavior

Source

Issues

Installs: 34

Dependents: 0

Suggesters: 0

Security: 0

Stars: 1

Watchers: 2

Forks: 0

Open Issues: 0

v1.0.0 2016-04-30 07:41 UTC

Requires

MIT 455a210332a1a27c8d89257dc3c1c4954beb90b6

  • dotzero <mail.woop@dotzero.ru>

mysqlextensionBehavioryii

This package is auto-updated.

Last update: 2022-06-04 08:33:56 UTC

README

Latest Stable Version License

The InsertUpdateCommandBehavior extension adds up some functionality to the default possibilites of yii´s CDbCommand implementation. Creates and executes an INSERT with ON DUPLICATE KEY UPDATE MySQL statement.

Requirements:

Install

Via composer:

$ composer require dotzero/yii-insertupdate-behavior

Add vendor path and import path to your configuration file:

'aliases' => array(
    ...
    'vendor' => realpath(__DIR__ . '/../../vendor'),
),
'import' => array(
    ...
    'vendor.dotzero.yii-insertupdate-behavior.*',
),

Basic usage:

$command = Yii::app()->db->createCommand();
$command->attachBehavior('InsertUpdateCommandBehavior', new InsertUpdateCommandBehavior);
$command->insertUpdate('tbl_user', array(
    'name'=>'Tester',
    'email'=>'tester@example.com',
    'counter'=>'1'
), array(
    'name'=>'Tester',
    'email'=>'tester@example.com'
));

Creates and executes an INSERT with ON DUPLICATE KEY UPDATE MySQL statement

INSERT INTO `tbl_user` (`name`, `email`, `counter`)
VALUES ('Tester', 'tester@example.com', 1)
ON DUPLICATE KEY UPDATE `name`='Tester', `email`='tester@example.com';

Advanced usage:

$command = Yii::app()->db->createCommand();
$command->attachBehavior('InsertUpdateCommandBehavior', new InsertUpdateCommandBehavior);
$command->insertUpdate('tbl_user', array(
    'name'=>'Tester',
    'email'=>'tester@example.com',
    'counter'=>'1'
), array(
    'name'=>'Tester',
    'email'=>'tester@example.com'
    'counter'=>new CDbExpression('LAST_INSERT_ID(counter)');
));

Creates and executes an INSERT with ON DUPLICATE KEY UPDATE MySQL statement

INSERT INTO `tbl_user` (`name`, `email`, `counter`)
VALUES ('Tester', 'tester@example.com', 1)
ON DUPLICATE KEY UPDATE `name`='Tester', `email`='tester@example.com', `counter`=LAST_INSERT_ID(counter);

License

Licensed under the MIT license: http://www.opensource.org/licenses/mit-license.php