nette / database

💾 A database layer with a familiar PDO-like API but much more powerful. Building queries, advanced joins, drivers for MySQL, PostgreSQL, SQLite, MS SQL Server and Oracle.
https://doc.nette.org/database
Other
502 stars 107 forks source link

UPDATE Multiple rows doesn't work at all #304

Open thekayshawn opened 8 months ago

thekayshawn commented 8 months ago

Version: 3.1

Bug Description

Update multiple, both in core and explorer, doesn't work at all and has really poor documentation, the docs never even mention how to accomplish and the execution gives weird errors such as "Unexpected type array" when the function's PhpDoc clearly says it expects an array. Following is my code:

$this->database->table('questions')->where('id', $ids)->update($questions);

Doesn't matter if $questions is an array or an object or is defined right here instead of being stored in a variable, the same error is thrown, precisely: Nette\InvalidArgumentException: Unexpected type of parameter: array in \Database\SqlPreprocessor.php:316

Edit: The forum's authentication system is bugged and, I believe, many questions are posted here instead of the forum as a consequence.

Steps To Reproduce

Jumpstart a Nette app and try updating multiple rows at once.

Expected Behavior

Multiple rows should be updated.