yii\sphinx\QueryBuilder::delete PHP Method

QueryBuilder Class Documentation Datei anzeigen Open project: yiisoft/yii2-sphinx

delete() public method

For example, php $sql = $queryBuilder->delete('idx_user', 'status = 0'); The method will properly escape the index and column names.

public delete ( string $index, array \| string $condition, array &$params ) : string
$index	string	the index where the data will be deleted from.
$condition	array \| string	the condition that will be put in the WHERE part. Please refer to [[Query::where()]] on how to specify condition.
$params	array	the binding parameters that will be modified by this method so that they can be bound to the Sphinx command later.
return	string	the DELETE SQL

    public function delete($index, $condition, &$params)
    {
        $sql = 'DELETE FROM ' . $this->db->quoteIndexName($index);
        $where = $this->buildWhere([$index], $condition, $params);
        return $where === '' ? $sql : $sql . ' ' . $where;
    }

QueryBuilder

__construct

batchInsert

batchReplace

build

buildAndCondition

buildBetweenCondition

buildColumns

buildCompositeInCondition

buildCondition

buildFacets

buildFrom