yii\sphinx\Command::batchReplace PHP Метод

Документация по классу Command Показать файл Открыть проект

batchReplace() публичный Метод

For example, php $connection->createCommand()->batchReplace('idx_user', ['name', 'age'], [ ['Tom', 30], ['Jane', 20], ['Linda', 25], ])->execute(); Note that the values in each row must match the corresponding column names.

public batchReplace ( string $index, array $columns, array $rows )
$index	string	the index that new rows will be replaced.
$columns	array	the column names
$rows	array	the rows to be batch replaced in the index

    public function batchReplace($index, $columns, $rows)
    {
        $params = [];
        $sql = $this->db->getQueryBuilder()->batchReplace($index, $columns, $rows, $params);
        return $this->setSql($sql)->bindValues($params);
    }

Command

addColumn

addForeignKey

addPrimaryKey

alterColumn

batchInsert

batchReplace

bindValue

bindValues

callKeywords

callSnippets

checkIntegrity