PHP Class phprs\ezsql\rules\insert\OnDuplicateKeyUpdateRule

Inheritance: extends phprs\ezsql\rules\basic\ExecRule

Show file Open project: caoym/phprs-restful

Public Methods

Method	Description
__construct ( $context )
onDuplicateKeyUpdate ( string $column, mixed $value ) : ExecRule	insertInto('table') ->values(['a'=>1, 'b'=>Sql::native('now()')]) ->onDuplicateKeyUpdate('a', Sql::native('a+1')) => "INSERT INTO table(a,b) VALUES(1,now()) ON DUPLICATE KEY UPDATE a=a+1"
onDuplicateKeyUpdateArgs ( $values ) : ExecRule	insertInto('table') ->values(['a'=>1, 'b'=>Sql::native('now()')]) ->onDuplicateKeyUpdateArgs(['a'=>Sql::native('a+1')]) => "INSERT INTO table(a,b) VALUES(1,now()) ON DUPLICATE KEY UPDATE a=a+1"
onDuplicateKeyUpdateExpr ( $expr, $_ = null ) : ExecRule	insertInto('table') ->values(['a'=>1, 'b'=>Sql::native('now()')]) ->onDuplicateKeyUpdateExpr('a=a+1') => "INSERT INTO table(a,b) VALUES(1,now()) ON DUPLICATE KEY UPDATE a=a+1"

Method Details

__construct() public method

public __construct ( $context )

onDuplicateKeyUpdate() public method

insertInto('table') ->values(['a'=>1, 'b'=>Sql::native('now()')]) ->onDuplicateKeyUpdate('a', Sql::native('a+1')) => "INSERT INTO table(a,b) VALUES(1,now()) ON DUPLICATE KEY UPDATE a=a+1"

public onDuplicateKeyUpdate ( string $column, mixed $value ) : ExecRule
$column	string
$value	mixed
return	phprs\ezsql\rules\basic\ExecRule

onDuplicateKeyUpdateArgs() public method

insertInto('table') ->values(['a'=>1, 'b'=>Sql::native('now()')]) ->onDuplicateKeyUpdateArgs(['a'=>Sql::native('a+1')]) => "INSERT INTO table(a,b) VALUES(1,now()) ON DUPLICATE KEY UPDATE a=a+1"

public onDuplicateKeyUpdateArgs ( $values ) : ExecRule
return	phprs\ezsql\rules\basic\ExecRule

onDuplicateKeyUpdateExpr() public method

insertInto('table') ->values(['a'=>1, 'b'=>Sql::native('now()')]) ->onDuplicateKeyUpdateExpr('a=a+1') => "INSERT INTO table(a,b) VALUES(1,now()) ON DUPLICATE KEY UPDATE a=a+1"

public onDuplicateKeyUpdateExpr ( $expr, $_ = null ) : ExecRule
return	phprs\ezsql\rules\basic\ExecRule