Laravel Eloquent ORM Query and Model Feature

Laravel Eloquent feature is object Oriented paradigm approach of database communication. In Eloquent we create Model for each Table in the database, which set the communication (Fetching, Inserting, Deleting, Modifying the Record ) with database.

You can create the Model with Migration or without migration with the help of Artisan Command. We can use -m or --migration after the artisan command to create the Model with Migration. Below code  is the Example.

Eloquent Model with Database Migration

Create Model with migration using Artisan Command. Below is the command to create Model with migration.

  php artisan make:model model-Name  -m (-m is for migration )

                  php artisan make:model model-Name  --migration (--migration is for migration )

This above two Artisan Command will create Table migration file in your databaese / migration directory which you can modify further.

Create Model without Migration. Below is the Artisan command to create Model.

  php artisan make:model model-Name 

Lets Take Example, We will create Model Named with CategoryMaster 

php artisan make:model CategoryMaster  -m

This above Artisan Command will create the Model named with CategoryMaster.  Below is the code for your reference   

<?php
namespace App;
use Illuminate\Database\Eloquent\Model;
class CategoryMaster extends Model
{     // }

Eloquent Model Property

In the above model, we didn't mention the table. So we have to declare the table in CategoryMaster Model.

protected  $table = '"category_table";

In Eloquent Model, Eloquent consider by default each table has a primary key id with incrementing integer Value. How to Define a protected Primary key property:

protected  $primaryKey = '"id";

protected  $incrementing = '"false";

if Primary Key is not an integer then you must set the KeyType a string.

protected $keyType = 'string';

Once the Table is declared in the Model, By Default timestamp (Created_at, updated_at) will be true. If you don't want them then you have to set the timestamp to false.

protected $timeStamp = "false";

Eloquent Model and Database Connection

Eloquent model will use Default Database which got configured with your laravel Application. if you wish to have your model connected with other database then you have to use $connection Property. Code is below for your reference.

protected $connection = "Connection-Database-Name"; 

Fetch / Retrieve Model In Eloquent

Once the Model is Created with Associated table, We can perform all the database operation(CRUD) on it. We will Query / fetch database table associated with model step by step.

Above we have created CategoryMaster  Model, Now we will use this model for writing our Eloquent Query as a Example.

$data= App\CategoryMaster::all();

all() method in Eloquent will return all result from the specified model table. We can use various constraint on the all method to filter the table record.

$data = App\CategoryMaster::where('status', 1)->orderBy('id', 'desc')
        ->take(5)->get();

As Eloquent is Query Builder you can use all the Query Builder method for database Operation.