• 홈
• Prado
• Data
• Common
• TDbCommandBuilder

PHP 클래스 Prado\Data\Common\TDbCommandBuilder

파일 보기 프로젝트 열기: pradosoft/prado 1 사용 예제들

공개 메소드들

메소드	설명
__construct ( $connection = null, $tableInfo = null )
applyCriterias ( $sql, $parameters = [], $ordering = [], $limit, $offset )
applyLimitOffset ( $sql, $limit, $offset ) : string	Alters the sql to apply $limit and $offset. Default implementation is applicable for PostgreSQL, MySQL and SQLite.
applyOrdering ( $sql, $ordering ) : string
bindArrayValues ( $command, $values )
bindColumnValues ( $command, $values )	Bind the name-value pairs of $values where the array keys correspond to column names.
createCommand ( $sql ) : TDbCommand
createCountCommand ( $where = '1=1', $parameters = [], $ordering = [], $limit, $offset ) : TDbCommand	Creates a count(*) command for the table described in {@link setTableInfo TableInfo}.
createDeleteCommand ( $where, $parameters = [] ) : TDbCommand	Creates a delete command for the table described in {@link setTableInfo TableInfo}.
createFindCommand ( $where = '1=1', $parameters = [], $ordering = [], $limit, $offset, $select = '*' ) : TDbCommand	Appends the $where condition to the string "SELECT * FROM tableName WHERE ".
createInsertCommand ( $data ) : TDbCommand	Creates an insert command for the table described in {@link setTableInfo TableInfo} for the given data.
createUpdateCommand ( $data, $where, $parameters = [] ) : TDbCommand	Creates an update command for the table described in {@link setTableInfo TableInfo} for the given data.
getDbConnection ( ) : TDbConnection
getLastInsertID ( ) : mixed	Iterate through all the columns and returns the last insert id of the first column that has a sequence or serial.
getPdoType ( $value ) : integer
getSearchExpression ( $fields, $keywords ) : string	Computes the SQL condition for search a set of column using regular expression (or LIKE, depending on database implementation) to match a string of keywords (default matches all keywords).
getSelectFieldList ( $data = '*' ) : array	Different behavior depends on type of passed data string usage without modification
getTableInfo ( )
setDbConnection ( $value )
setTableInfo ( $value )

보호된 메소드들

메소드	설명
getColumnBindings ( $values, $position = false ) : string	Create a name-value or position-value if $position=true binding strings.
getInsertFieldBindings ( $values ) : array	Returns a list of insert field name and a list of binding names.
getSearchCondition ( $column, $words ) : string
hasIntegerKey ( $array ) : boolean

메소드 상세