webchemistry/doctrine-extras

There is no license information available for the latest version (dev-master) of this package.

dev-master 2024-09-02 13:19 UTC

Requires

• php: >= 8.1
• doctrine/orm: ^2.14
• nette/utils: ^3.2 || ^4.0

Requires (Dev)

• nette/tester: ^2.4
• phpstan/phpstan: ^1.9

Unknown License

README

$factory = new BulkFactory($em);

// insert
$bulk = $factory->createInsert(Entity::class, ['id', 'firstName']);

$bulk->setReplace(true); // REPLACE INTO ...
$bulk->setSkipConflicts(true); // INSERT IGNORE ...
$bulk->setUpsert(true); // INSERT INTO ... ON DUPLICATE KEY UPDATE

$bulk->addValues([
    'id' => 1,
    'firstName' => 'Jane',
]);
$bulk->execute();

// update
$bulk = $factory->createUpdate(Entity::class, ['firstName'], ['id']); // updates only firstName, field id is in where clause
$bulk->addValues([
    'id' => 1,
    'firstName' => 'Jane',
]);
$bulk->execute();