This packages extend the Laravel Query Builder, has a nice Base Repository
and has a collection of helpful Criteria
to build queries.
The Basereposity has various helpful methods.
return $this->transaction(function () use ($data) {
User::update($data);
});
A Criterion
is a way to build custom query logic in its own class and reuse within your project.
Use it together with the BaseRepository to
$this->criteriaCollection = new CriteriaCollection();
$this->criteriaCollection
->reset()
->add(new WithRelationCriterion('contentGroups'))
->add(new WithRelatedUserCriterion($request->user()))
->add(new WithSearchQueryCriterion('foobar', 'name'));
$forms = $this->formsRepository->getAllMatchingCriteria($this->criteriaCollection);
This package extends the Laravel QueryBuilder by the following methods:
Makes it possible to use the REPLACE INTO
MySQL grammar in Laravel. Simply do:
User::replace($data);
Call insertOnDuplicateKey
or insertIgnore
from a model with the array of data to insert in its table.
$data = [
['id' => 1, 'name' => 'name1', 'email' => '[email protected]'],
['id' => 2, 'name' => 'name2', 'email' => '[email protected]'],
];
User::insertOnDuplicateKey($data);
User::insertIgnore($data);
If you want to update only certain columns, pass them as the 2nd argument.
User::insertOnDuplicateKey([
'id' => 1,
'name' => 'new name',
'email' => '[email protected]',
], ['name']);
// The name will be updated but not the email.
You can customize the value with which the columns will be updated when a row already exists by passing an associative array.
In the following example, if a user with id = 1 doesn't exist, it will be created with name = 'created user'. If it already exists, it will be updated with name = 'updated user'.
User::insertOnDuplicateKey([
'id' => 1,
'name' => 'created user',
], ['name' => 'updated user']);
The generated SQL is:
INSERT INTO `users` (`id`, `name`) VALUES (1, "created user") ON DUPLICATE KEY UPDATE `name` = "updated user"
You may combine key/value pairs and column names in the 2nd argument to specify the columns to update with a custom literal or expression or with the default VALUES(column)
. For example:
User::insertOnDuplicateKey([
'id' => 1,
'name' => 'created user',
'email' => '[email protected]',
'password' => 'secret',
], ['name' => 'updated user', 'email]);
will generate
INSERT INTO `users` (`id`, `name`, `email`, `password`)
VALUES (1, "created user", "[email protected]", "secret")
ON DUPLICATE KEY UPDATE `name` = "updated user", `email` = VALUES(`email`)
Call attachOnDuplicateKey
and attachIgnore
from a BelongsToMany
relation to run the inserts in its pivot table. You can pass the data in all of the formats accepted by attach
.
$pivotData = [
1 => ['expires_at' => Carbon::today()],
2 => ['expires_at' => Carbon::tomorrow()],
];
$user->roles()->attachOnDuplicateKey($pivotData);
$user->roles()->attachIgnore($pivotData);