PHP Class InsertQuery, fluentpdo

Inheritance: extends BaseQuery
Show file Open project: fpdo/fluentpdo Class Usage Examples

Public Methods

Method Description
__construct ( FluentPDO $fpdo, string $table, $values ) InsertQuery constructor.
delayed ( ) : InsertQuery Force insert operation delay support
execute ( mixed $sequence = null ) : integer Execute insert query
ignore ( ) : InsertQuery Force insert operation to fail silently
onDuplicateKeyUpdate ( array $values ) : InsertQuery Add ON DUPLICATE KEY UPDATE
values ( $values ) : InsertQuery Add VALUES

Protected Methods

Method Description
buildParameters ( ) : array
filterLiterals ( $statements ) : array Removes all FluentLiteral instances from the argument since they are not to be used as PDO parameters but rather injected directly into the query
getClauseInsertInto ( ) : string
getClauseOnDuplicateKeyUpdate ( ) : string
getClauseValues ( ) : string
parameterGetValue ( $param ) : string

Private Methods

Method Description
addOneValue ( array $oneValue )

Method Details

__construct() public method

InsertQuery constructor.
public __construct ( FluentPDO $fpdo, string $table, $values )
$fpdo FluentPDO
$table string
$values

buildParameters() protected method

protected buildParameters ( ) : array
return array

delayed() public method

Force insert operation delay support
public delayed ( ) : InsertQuery
return InsertQuery

execute() public method

Execute insert query
public execute ( mixed $sequence = null ) : integer
$sequence mixed
return integer last inserted id or false

filterLiterals() protected method

Removes all FluentLiteral instances from the argument since they are not to be used as PDO parameters but rather injected directly into the query
protected filterLiterals ( $statements ) : array
$statements
return array

getClauseInsertInto() protected method

protected getClauseInsertInto ( ) : string
return string

getClauseOnDuplicateKeyUpdate() protected method

getClauseValues() protected method

protected getClauseValues ( ) : string
return string

ignore() public method

Force insert operation to fail silently
public ignore ( ) : InsertQuery
return InsertQuery

onDuplicateKeyUpdate() public method

Add ON DUPLICATE KEY UPDATE
public onDuplicateKeyUpdate ( array $values ) : InsertQuery
$values array
return InsertQuery

parameterGetValue() protected method

protected parameterGetValue ( $param ) : string
$param
return string

values() public method

Add VALUES
public values ( $values ) : InsertQuery
$values
return InsertQuery