💡 Elegant and efficient way to delete and update more entities at once about orm HOT 3 OPEN

It looks like a request for a new interface Cycle\ORM\QueryBuilderInterface with methods select($role): Select, update(...) and delete(...)

The select() method just returns the Cycle\ORM\Select class.
update() and delete() methods must provide fields mappings and relation joins like in the Select class.

from orm.

Hello. Please share how you imagine the API. What would the end user code look like?

Btw, you might be interested in looking at a small example of how it's possible to implement ActiveRecord based on the Cycle
https://github.com/roxblnfk/cycle-active-record

from orm.

Something like

$orm->getRepository(User::class)->update([
    'name' => 'foo'
])->where('name', '!=', 'bar')->run();

or since repositories are read only:

$manager = new \Cycle\ORM\EntityManager($orm);
$manager->update(User::class)
        ->set([
            'name' => 'foo'
        ])
        ->where('name', '!=', 'bar')
        ->run()
;

But I'm not sure if this would be possible

from orm.