• 홈
• yii
• db
• sqlite
• QueryBuilder

PHP 클래스 yii\db\sqlite\QueryBuilder

파일 보기 프로젝트 열기: yiisoft/yii2

공개 프로퍼티들

프로퍼티	타입	설명
$typeMap		mapping from abstract column types (keys) to physical column types (values).

공개 메소드들

메소드	설명
addCommentOnColumn ( $table, $column, $comment )
addCommentOnTable ( $table, $comment )
addForeignKey ( string $name, string $table, string | array $columns, string $refTable, string | array $refColumns, string $delete = null, string $update = null ) : string	Builds a SQL statement for adding a foreign key constraint to an existing table.
addPrimaryKey ( string $name, string $table, string | array $columns ) : string	Builds a SQL statement for adding a primary key constraint to an existing table.
alterColumn ( string $table, string $column, string $type ) : string	Builds a SQL statement for changing the definition of a column.
batchInsert ( string $table, array $columns, array $rows ) : string	Generates a batch INSERT SQL statement.
build ( $query, $params = [] )
buildLimit ( $limit, $offset )
buildUnion ( $unions, &$params )
checkIntegrity ( boolean $check = true, string $schema = '', string $table = '' ) : string	Enables or disables integrity check.
dropColumn ( string $table, string $column ) : string	Builds a SQL statement for dropping a DB column.
dropCommentFromColumn ( $table, $column )
dropCommentFromTable ( $table )
dropForeignKey ( string $name, string $table ) : string	Builds a SQL statement for dropping a foreign key constraint.
dropIndex ( string $name, string $table ) : string	Builds a SQL statement for dropping an index.
dropPrimaryKey ( string $name, string $table ) : string	Builds a SQL statement for removing a primary key constraint to an existing table.
renameColumn ( string $table, string $oldName, string $newName ) : string	Builds a SQL statement for renaming a column.
renameTable ( string $table, string $newName ) : string	Builds a SQL statement for renaming a DB table.
resetSequence ( string $tableName, mixed $value = null ) : string	Creates a SQL statement for resetting the sequence value of a table's primary key.
truncateTable ( string $table ) : string	Builds a SQL statement for truncating a DB table.

보호된 메소드들

메소드	설명
buildCompositeInCondition ( string $operator, array $columns, array $values, array &$params ) : string	Builds SQL for IN condition
buildSubqueryInCondition ( $operator, $columns, $values, &$params )

메소드 상세

프로퍼티 상세