# Eloquent: Getting Started - [Introduction](#introduction) - [Defining Models](#defining-models) - [Eloquent Model Conventions](#eloquent-model-conventions) - [Retrieving Models](#retrieving-models) - [Collections](#collections) - [Chunking Results](#chunking-results) - [Retrieving Single Models / Aggregates](#retrieving-single-models) - [Retrieving Aggregates](#retrieving-aggregates) - [Inserting & Updating Models](#inserting-and-updating-models) - [Inserts](#inserts) - [Updates](#updates) - [Mass Assignment](#mass-assignment) - [Other Creation Methods](#other-creation-methods) - [Deleting Models](#deleting-models) - [Soft Deleting](#soft-deleting) - [Querying Soft Deleted Models](#querying-soft-deleted-models) - [Query Scopes](#query-scopes) - [Global Scopes](#global-scopes) - [Local Scopes](#local-scopes) - [Comparing Models](#comparing-models) - [Events](#events) - [Observers](#observers) ## Introduction The Eloquent ORM included with Laravel provides a beautiful, simple ActiveRecord implementation for working with your database. Each database table has a corresponding "Model" which is used to interact with that table. Models allow you to query for data in your tables, as well as insert new records into the table. Before getting started, be sure to configure a database connection in `config/database.php`. For more information on configuring your database, check out [the documentation](/docs/{{version}}/database#configuration). ## Defining Models To get started, let's create an Eloquent model. Models typically live in the `app` directory, but you are free to place them anywhere that can be auto-loaded according to your `composer.json` file. All Eloquent models extend `Illuminate\Database\Eloquent\Model` class. The easiest way to create a model instance is using the `make:model` [Artisan command](/docs/{{version}}/artisan): php artisan make:model Flight If you would like to generate a [database migration](/docs/{{version}}/migrations) when you generate the model, you may use the `--migration` or `-m` option: php artisan make:model Flight --migration php artisan make:model Flight -m ### Eloquent Model Conventions Now, let's look at an example `Flight` model, which we will use to retrieve and store information from our `flights` database table: ## Retrieving Models Once you have created a model and [its associated database table](/docs/{{version}}/migrations#writing-migrations), you are ready to start retrieving data from your database. Think of each Eloquent model as a powerful [query builder](/docs/{{version}}/queries) allowing you to fluently query the database table associated with the model. For example: name; } #### Adding Additional Constraints The Eloquent `all` method will return all of the results in the model's table. Since each Eloquent model serves as a [query builder](/docs/{{version}}/queries), you may also add constraints to queries, and then use the `get` method to retrieve the results: $flights = App\Flight::where('active', 1) ->orderBy('name', 'desc') ->take(10) ->get(); > {tip} Since Eloquent models are query builders, you should review all of the methods available on the [query builder](/docs/{{version}}/queries). You may use any of these methods in your Eloquent queries. ### Collections For Eloquent methods like `all` and `get` which retrieve multiple results, an instance of `Illuminate\Database\Eloquent\Collection` will be returned. The `Collection` class provides [a variety of helpful methods](/docs/{{version}}/eloquent-collections#available-methods) for working with your Eloquent results: $flights = $flights->reject(function ($flight) { return $flight->cancelled; }); Of course, you may also loop over the collection like an array: foreach ($flights as $flight) { echo $flight->name; } ### Chunking Results If you need to process thousands of Eloquent records, use the `chunk` command. The `chunk` method will retrieve a "chunk" of Eloquent models, feeding them to a given `Closure` for processing. Using the `chunk` method will conserve memory when working with large result sets: Flight::chunk(200, function ($flights) { foreach ($flights as $flight) { // } }); The first argument passed to the method is the number of records you wish to receive per "chunk". The Closure passed as the second argument will be called for each chunk that is retrieved from the database. A database query will be executed to retrieve each chunk of records passed to the Closure. #### Using Cursors The `cursor` method allows you to iterate through your database records using a cursor, which will only execute a single query. When processing large amounts of data, the `cursor` method may be used to greatly reduce your memory usage: foreach (Flight::where('foo', 'bar')->cursor() as $flight) { // } ## Retrieving Single Models / Aggregates Of course, in addition to retrieving all of the records for a given table, you may also retrieve single records using `find` or `first`. Instead of returning a collection of models, these methods return a single model instance: // Retrieve a model by its primary key... $flight = App\Flight::find(1); // Retrieve the first model matching the query constraints... $flight = App\Flight::where('active', 1)->first(); You may also call the `find` method with an array of primary keys, which will return a collection of the matching records: $flights = App\Flight::find([1, 2, 3]); #### Not Found Exceptions Sometimes you may wish to throw an exception if a model is not found. This is particularly useful in routes or controllers. The `findOrFail` and `firstOrFail` methods will retrieve the first result of the query; however, if no result is found, a `Illuminate\Database\Eloquent\ModelNotFoundException` will be thrown: $model = App\Flight::findOrFail(1); $model = App\Flight::where('legs', '>', 100)->firstOrFail(); If the exception is not caught, a `404` HTTP response is automatically sent back to the user. It is not necessary to write explicit checks to return `404` responses when using these methods: Route::get('/api/flights/{id}', function ($id) { return App\Flight::findOrFail($id); }); ### Retrieving Aggregates You may also use the `count`, `sum`, `max`, and other [aggregate methods](/docs/{{version}}/queries#aggregates) provided by the [query builder](/docs/{{version}}/queries). These methods return the appropriate scalar value instead of a full model instance: $count = App\Flight::where('active', 1)->count(); $max = App\Flight::where('active', 1)->max('price'); ## Inserting & Updating Models ### Inserts To create a new record in the database, create a new model instance, set attributes on the model, then call the `save` method: name = $request->name; $flight->save(); } } In this example, we assign the `name` parameter from the incoming HTTP request to the `name` attribute of the `App\Flight` model instance. When we call the `save` method, a record will be inserted into the database. The `created_at` and `updated_at` timestamps will automatically be set when the `save` method is called, so there is no need to set them manually. ### Updates The `save` method may also be used to update models that already exist in the database. To update a model, you should retrieve it, set any attributes you wish to update, and then call the `save` method. Again, the `updated_at` timestamp will automatically be updated, so there is no need to manually set its value: $flight = App\Flight::find(1); $flight->name = 'New Flight Name'; $flight->save(); #### Mass Updates Updates can also be performed against any number of models that match a given query. In this example, all flights that are `active` and have a `destination` of `San Diego` will be marked as delayed: App\Flight::where('active', 1) ->where('destination', 'San Diego') ->update(['delayed' => 1]); The `update` method expects an array of column and value pairs representing the columns that should be updated. > {note} When issuing a mass update via Eloquent, the `saved` and `updated` model events will not be fired for the updated models. This is because the models are never actually retrieved when issuing a mass update. ### Mass Assignment You may also use the `create` method to save a new model in a single line. The inserted model instance will be returned to you from the method. However, before doing so, you will need to specify either a `fillable` or `guarded` attribute on the model, as all Eloquent models protect against mass-assignment by default. A mass-assignment vulnerability occurs when a user passes an unexpected HTTP parameter through a request, and that parameter changes a column in your database you did not expect. For example, a malicious user might send an `is_admin` parameter through an HTTP request, which is then passed into your model's `create` method, allowing the user to escalate themselves to an administrator. So, to get started, you should define which model attributes you want to make mass assignable. You may do this using the `$fillable` property on the model. For example, let's make the `name` attribute of our `Flight` model mass assignable: 'Flight 10']); If you already have a model instance, you may use the `fill` method to populate it with an array of attributes: $flight->fill(['name' => 'Flight 22']); #### Guarding Attributes While `$fillable` serves as a "white list" of attributes that should be mass assignable, you may also choose to use `$guarded`. The `$guarded` property should contain an array of attributes that you do not want to be mass assignable. All other attributes not in the array will be mass assignable. So, `$guarded` functions like a "black list". Of course, you should use either `$fillable` or `$guarded` - not both. In the example below, all attributes **except for `price`** will be mass assignable: ### Other Creation Methods #### `firstOrCreate`/ `firstOrNew` There are two other methods you may use to create models by mass assigning attributes: `firstOrCreate` and `firstOrNew`. The `firstOrCreate` method will attempt to locate a database record using the given column / value pairs. If the model can not be found in the database, a record will be inserted with the attributes from the first parameter, along with those in the optional second parameter. The `firstOrNew` method, like `firstOrCreate` will attempt to locate a record in the database matching the given attributes. However, if a model is not found, a new model instance will be returned. Note that the model returned by `firstOrNew` has not yet been persisted to the database. You will need to call `save` manually to persist it: // Retrieve flight by name, or create it if it doesn't exist... $flight = App\Flight::firstOrCreate(['name' => 'Flight 10']); // Retrieve flight by name, or create it with the name and delayed attributes... $flight = App\Flight::firstOrCreate( ['name' => 'Flight 10'], ['delayed' => 1] ); // Retrieve by name, or instantiate... $flight = App\Flight::firstOrNew(['name' => 'Flight 10']); // Retrieve by name, or instantiate with the name and delayed attributes... $flight = App\Flight::firstOrNew( ['name' => 'Flight 10'], ['delayed' => 1] ); #### `updateOrCreate` You may also come across situations where you want to update an existing model or create a new model if none exists. Laravel provides an `updateOrCreate` method to do this in one step. Like the `firstOrCreate` method, `updateOrCreate` persists the model, so there's no need to call `save()`: // If there's a flight from Oakland to San Diego, set the price to $99. // If no matching model exists, create one. $flight = App\Flight::updateOrCreate( ['departure' => 'Oakland', 'destination' => 'San Diego'], ['price' => 99] ); ## Deleting Models To delete a model, call the `delete` method on a model instance: $flight = App\Flight::find(1); $flight->delete(); #### Deleting An Existing Model By Key In the example above, we are retrieving the model from the database before calling the `delete` method. However, if you know the primary key of the model, you may delete the model without retrieving it. To do so, call the `destroy` method: App\Flight::destroy(1); App\Flight::destroy([1, 2, 3]); App\Flight::destroy(1, 2, 3); #### Deleting Models By Query Of course, you may also run a delete statement on a set of models. In this example, we will delete all flights that are marked as inactive. Like mass updates, mass deletes will not fire any model events for the models that are deleted: $deletedRows = App\Flight::where('active', 0)->delete(); > {note} When executing a mass delete statement via Eloquent, the `deleting` and `deleted` model events will not be fired for the deleted models. This is because the models are never actually retrieved when executing the delete statement. ### Soft Deleting In addition to actually removing records from your database, Eloquent can also "soft delete" models. When models are soft deleted, they are not actually removed from your database. Instead, a `deleted_at` attribute is set on the model and inserted into the database. If a model has a non-null `deleted_at` value, the model has been soft deleted. To enable soft deletes for a model, use the `Illuminate\Database\Eloquent\SoftDeletes` trait on the model and add the `deleted_at` column to your `$dates` property: softDeletes(); }); Now, when you call the `delete` method on the model, the `deleted_at` column will be set to the current date and time. And, when querying a model that uses soft deletes, the soft deleted models will automatically be excluded from all query results. To determine if a given model instance has been soft deleted, use the `trashed` method: if ($flight->trashed()) { // } ### Querying Soft Deleted Models #### Including Soft Deleted Models As noted above, soft deleted models will automatically be excluded from query results. However, you may force soft deleted models to appear in a result set using the `withTrashed` method on the query: $flights = App\Flight::withTrashed() ->where('account_id', 1) ->get(); The `withTrashed` method may also be used on a [relationship](/docs/{{version}}/eloquent-relationships) query: $flight->history()->withTrashed()->get(); #### Retrieving Only Soft Deleted Models The `onlyTrashed` method will retrieve **only** soft deleted models: $flights = App\Flight::onlyTrashed() ->where('airline_id', 1) ->get(); #### Restoring Soft Deleted Models Sometimes you may wish to "un-delete" a soft deleted model. To restore a soft deleted model into an active state, use the `restore` method on a model instance: $flight->restore(); You may also use the `restore` method in a query to quickly restore multiple models. Again, like other "mass" operations, this will not fire any model events for the models that are restored: App\Flight::withTrashed() ->where('airline_id', 1) ->restore(); Like the `withTrashed` method, the `restore` method may also be used on [relationships](/docs/{{version}}/eloquent-relationships): $flight->history()->restore(); #### Permanently Deleting Models Sometimes you may need to truly remove a model from your database. To permanently remove a soft deleted model from the database, use the `forceDelete` method: // Force deleting a single model instance... $flight->forceDelete(); // Force deleting all related models... $flight->history()->forceDelete(); ## Query Scopes ### Global Scopes Global scopes allow you to add constraints to all queries for a given model. Laravel's own [soft delete](#soft-deleting) functionality utilizes global scopes to only pull "non-deleted" models from the database. Writing your own global scopes can provide a convenient, easy way to make sure every query for a given model receives certain constraints. #### Writing Global Scopes Writing a global scope is simple. Define a class that implements the `Illuminate\Database\Eloquent\Scope` interface. This interface requires you to implement one method: `apply`. The `apply` method may add `where` constraints to the query as needed: where('age', '>', 200); } } > {tip} If your global scope is adding columns to the select clause of the query, you should use the `addSelect` method instead of `select`. This will prevent the unintentional replacement of the query's existing select clause. #### Applying Global Scopes To assign a global scope to a model, you should override a given model's `boot` method and use the `addGlobalScope` method: 200 #### Anonymous Global Scopes Eloquent also allows you to define global scopes using Closures, which is particularly useful for simple scopes that do not warrant a separate class: where('age', '>', 200); }); } } #### Removing Global Scopes If you would like to remove a global scope for a given query, you may use the `withoutGlobalScope` method. The method accepts the class name of the global scope as its only argument: User::withoutGlobalScope(AgeScope::class)->get(); Or, if you defined the global scope using a Closure: User::withoutGlobalScope('age')->get(); If you would like to remove several or even all of the global scopes, you may use the `withoutGlobalScopes` method: // Remove all of the global scopes... User::withoutGlobalScopes()->get(); // Remove some of the global scopes... User::withoutGlobalScopes([ FirstScope::class, SecondScope::class ])->get(); ### Local Scopes Local scopes allow you to define common sets of constraints that you may easily re-use throughout your application. For example, you may need to frequently retrieve all users that are considered "popular". To define a scope, prefix an Eloquent model method with `scope`. Scopes should always return a query builder instance: where('votes', '>', 100); } /** * Scope a query to only include active users. * * @param \Illuminate\Database\Eloquent\Builder $query * @return \Illuminate\Database\Eloquent\Builder */ public function scopeActive($query) { return $query->where('active', 1); } } #### Utilizing A Local Scope Once the scope has been defined, you may call the scope methods when querying the model. However, you should not include the `scope` prefix when calling the method. You can even chain calls to various scopes, for example: $users = App\User::popular()->active()->orderBy('created_at')->get(); #### Dynamic Scopes Sometimes you may wish to define a scope that accepts parameters. To get started, just add your additional parameters to your scope. Scope parameters should be defined after the `$query` parameter: where('type', $type); } } Now, you may pass the parameters when calling the scope: $users = App\User::ofType('admin')->get(); ## Comparing Models Sometimes you may need to determine if two models are the "same". The `is` method may be used to quickly verify two models have same primary key, table, and database connection: if ($post->is($anotherPost)) { // } ## Events Eloquent models fire several events, allowing you to hook into the following points in a model's lifecycle: `retrieved`, `creating`, `created`, `updating`, `updated`, `saving`, `saved`, `deleting`, `deleted`, `restoring`, `restored`. Events allow you to easily execute code each time a specific model class is saved or updated in the database. Each event receives the instance of the model through its constructor. The `retrieved` event will fire when an existing model is retrieved from the database. When a new model is saved for the first time, the `creating` and `created` events will fire. If a model already existed in the database and the `save` method is called, the `updating` / `updated` events will fire. However, in both cases, the `saving` / `saved` events will fire. > {note} When issuing a mass update via Eloquent, the `saved` and `updated` model events will not be fired for the updated models. This is because the models are never actually retrieved when issuing a mass update. To get started, define a `$dispatchesEvents` property on your Eloquent model that maps various points of the Eloquent model's lifecycle to your own [event classes](/docs/{{version}}/events): UserSaved::class, 'deleted' => UserDeleted::class, ]; } ### Observers #### Defining Observers If you are listening for many events on a given model, you may use observers to group all of your listeners into a single class. Observers classes have method names which reflect the Eloquent events you wish to listen for. Each of these methods receives the model as their only argument. The `make:observer` Artisan command is the easiest way to create a new observer class: php artisan make:observer UserObserver --model=User This command will place the new observer in your `App/Observers` directory. If this directory does not exist, Artisan will create it for you. Your fresh observer will look like the following: