Operations with Queries

Methods

• Update All
• Delete All

It's possible to make a query and execute the commands above.

Update All

Syntax

public function updateAll(array $data): int

This method returns the number of rows affected.

Example

PHP's way:

$repository
    ->isBetween('price', 0.99, 1.99)
    ->updateAll([
        'category_id' => 22,  
    ]);

SQL's representation:

UPDATE products SET category_id = 22 WHERE price BETWEEN 0.99 AND 1.99;

Delete All

Syntax

public function deleteAll(): int

This method returns the number of rows affected.

Example

$repository
    ->equals('active', 0)
    ->deleteAll();

SQL's representation:

DELETE FROM users WHERE active = 0;

---

🡄 Aggregation | Advanced Queries 🡆