Download the PHP package iksaku/laravel-mass-update without Composer

On this page you can find all versions of the php package iksaku/laravel-mass-update. It is possible to download/install these versions without Composer. Possible dependencies are resolved automatically.

FAQ

After the download, you have to make one include require_once('vendor/autoload.php');. After that you have to import the classes with use statements.

Example:
If you use only one package a project is not needed. But if you use more then one package, without a project it is not possible to import the classes with use statements.

In general, it is recommended to use always a project to download your libraries. In an application normally there is more than one library needed.
Some PHP packages are not free to download and because of that hosted in private repositories. In this case some credentials are needed to access such packages. Please use the auth.json textarea to insert credentials, if a package is coming from a private repository. You can look here for more information.

  • Some hosting areas are not accessible by a terminal or SSH. Then it is not possible to use Composer.
  • To use Composer is sometimes complicated. Especially for beginners.
  • Composer needs much resources. Sometimes they are not available on a simple webspace.
  • If you are using private repositories you don't need to share your credentials. You can set up everything on our site and then you provide a simple download link to your team member.
  • Simplify your Composer build process. Use our own command line tool to download the vendor folder as binary. This makes your build process faster and you don't need to expose your credentials for private repositories.
Please rate this library. Is it a good library?

Informations about the package laravel-mass-update

Laravel Mass Update

Latest Version on Packagist GitHub Tests Action Status GitHub Code Style Action Status Total Downloads

Update multiple Laravel Model records, each with its own set of values, sending a single query to your database!

Installation

You can install the package via composer:

Usage

In your model class, add the Iksaku\Laravel\MassUpdate\MassUpdatable trait:

And that's all! Your model is now ready to update multiple records with varying values in a single query!

Let's take a look at some possible use cases for this new query:

Simple use case: Update the values of multiple records

Imagine that you have the following users table:

id name username
1 Jorge Gonzales iksaku
2 Gladys Martines gm_mtz

But, we want to update both records since those users have told us that their legal last name was misspelled:

Well, we can mass update those specific records:

Now, both records will be updated with their corresponding values in a single query, resulting in:

id name username
1 Jorge González iksaku
2 Gladys Martínez gm_mtz

By default, the massUpdate query will grab your model's primary key name and apply it as part of the query to not affect other records.

If you want to use another column as an index to separate value types, you could pass it as a second argument to the function call:

Simple use case #2: Updating multiple Eloquent Models

If you need to update the values in some Model classes and want to automatically mass update those changes, then this is for you!

The existing masUpdate query is capable of identifying the dirty attributes of Eloquent model classes and compile them properly. You don't need to manually convert the models into an array, you just pass the list of models you want to update, and it takes care of the rest.

Tip: If you pass a full list of Eloquent models, only those with dirty values will be updated, so you don't actually need to filter the unchanged ones manually.

Let's recreate the previous example, but using Eloquent models...

Pretty cool, right?

Note: It is only possible to mass update instances of the same Eloquent model, it is not possible to mix the Query Builder with different Eloquent model classes.

Complicated use case: Using multiple indexes to differentiate records

Let's say that we just created expenses table to track how much we spend across time, and we manually filled the following values:

id year quarter total_expenses
.. .. .. ..
.. 2019 Q3 216.70
.. 2019 Q4 216.70
.. 2020 Q1 416.70
.. 2020 Q2 211.12
.. 2020 Q3 113.17
.. 2020 Q4 422.89
.. 2021 Q1 431.35

Above information is not real, I don't track my expenses quarterly.

Oops... We made a little mistake... Expenses from Q1 of 2020 and 2021 are switched, and in order to fix it we could only pass the quarter column as an index, but if we only pass down the quarter column as an index, we'll modify ALL Q1 records. So, for this, we should also pass down the year column as an index:

Tip: If you ever need to specify more than one or two indexes, just include all of them in the values and uniqueBy parameters.

The result in the table will be properly updated:

id year quarter total_expenses
.. .. .. ..
.. 2020 Q1 431.35
.. .. .. ..
.. 2021 Q1 416.70

NOTE: It is important that you always include the uniqueBy columns in your values array, exceptions will be thrown otherwise.

NOTE #2: It is not possible to update the values of the uniqueBy columns. Every column specified in this parameter will be filtered from the ones that are going to be updated.

This prevents unexpected side effects from happening while updating values in array shape and passed as Eloquent models.

Advanced use case: Chaining with other query statements

Let's try to keep things simple and imagine a system that tracks To-Do items for multiple users:

id user_id content order
1 1 Pick up my daughter 2
2 1 Buy a new ThinkPad 1
3 1 Drink water 3

Like every To-Do system, we let our users order their To-Do items to see the most important ones at the top of the list, and to do this, we may be using a simple sorting package that allows the user to drag items up and down the list.

Once the user moves one item in the list, in the backend we may receive an array with a specific key-value shape: ['position' => 'id']. With this, we're going to update the records' position based on the given id.

We can simply call our massUpdate query function and everything will be done... Well, sort of...

In this specific scenario, we're dealing with multiple lists for multiple users, that means that we may not be always able to control which id columns are sent to the server, maybe some malicious actor wants to hijack our To-Do list and lower the priority for buying ThinkPads. This is a pretty serious security concern.

There are many ways to solve this kind of issues, and a simple one is to chain query statements to our massUpdate function.

In this case, we're going to add a where() statement to only update those items that belong to the currently logged in user. And it's as simple as in any other Laravel query builder:

Tip: Did you know you can pass Collections, LazyCollections, Eloquent Collections and basically any Arrayable instance as values to the massUpdate query function?

This can be used as an extra layer to ensure data integrity when dealing with User-provided input that affects multiple records in the database.

Testing

Changelog

Please see CHANGELOG for more information on what has changed recently.

Contributing

Please see CONTRIBUTING for details.

Security Vulnerabilities

If you discover any security related issues, please email [email protected] instead of using the issue tracker.

Credits

License

The MIT License (MIT). Please see License File for more information.


All versions of laravel-mass-update with dependencies

PHP Build Version
Package Version
Requires php Version ^8.0
illuminate/database Version ^8.71|^9.0|^10.0|^11.0
illuminate/support Version ^8.71|^9.0|^10.0|^11.0
Composer command for our command line client (download client) This client runs in each environment. You don't need a specific PHP version etc. The first 20 API calls are free. Standard composer command

The package iksaku/laravel-mass-update contains the following files

Loading the files please wait ....