简介eloquent 为laravel中的orm模块
以下代码为orm对象生成命令
php artisan make:model Flight //创建Flight orm 对象
php artisan make:model Flight --migration | -m //生成migration数据库迁移文件
# Generate a model and a FlightFactory class...
php artisan make:model Flight --factory
php artisan make:model Flight -f
# Generate a model and a FlightSeeder class...
php artisan make:model Flight --seed
php artisan make:model Flight -s
# Generate a model and a FlightController class...
php artisan make:model Flight --controller
php artisan make:model Flight -c
# Generate a model and a migration, factory, seeder, and controller...
php artisan make:model Flight -mfsc
生成的基本对象：
<?php
namespace App\Models;
use Illuminate\Database\Eloquent\Model;
class Flight extends Model
{
//optional
protected $table = 'my_flights';//指定表名
protected $primaryKey = 'flight_id'; //指定主键
public $incrementing = false; //主键生成模式
protected $keyType = 'string';
//主键数据类型
public $timestamps = false;
//是否有create 和 update 时间
protected $dateFormat = 'U';
//日期格式
const CREATED_AT = 'creation_date';
//创建时间字段名
const UPDATED_AT = 'updated_date';//更新时间字段名
protected $connection = 'sqlite';
//指定该orm数据库连接
protected $fillable = [] //数组 可批量创建的字段
protected $guard = [] //数组 不可批量创建的字段
protected $attributes = [
//字段默认值
'delayed' => false,
];
}
查询方法：
Flight::all
use App\Models\Flight;
foreach (Flight::all() as $flight) {
echo $flight->name;
}
查询构造器
$flights = Flight::where('active', 1)
->orderBy('name')
->take(10)
->get();
聚合函数
$count = Flight::where('active', 1)->count();
$max = Flight::where('active', 1)->max('price');
对象collection reject方法剔除取消的航班 （闭包返回true）
$flights = Flight::where('destination', 'Paris')->get();
$flights = $flights->reject(function ($flight) {
return $flight->cancelled;
});
orm游标
use App\Models\User;
$users = User::cursor()->filter(function ($user) {
return $user->id > 500;
});
子查询
use App\Models\Destination;
use App\Models\Flight;
return Destination::addSelect(['last_flight' => Flight::select('name')
->whereColumn('destination_id', 'destinations.id')
->orderByDesc('arrived_at')
->limit(1)
])->get();
查一条数据
use App\Models\Flight;
// Retrieve a model by its primary key...
$flight = Flight::find(1);
// Retrieve the first model matching the query constraints...
$flight = Flight::where('active', 1)->first();
// Alternative to retrieving the first model matching the query constraints...
$flight = Flight::firstWhere('active', 1);
查到一条或者（闭包）
model = Flight::where('legs', '>', 3)->firstOr(function () {
// ...
});
查询报notFound fail方法
$flight = Flight::findOrFail(1);
$flight = Flight::where('legs', '>', 3)->firstOrFail();
静态创建
use App\Models\Flight;
// Retrieve flight by name or create it if it doesn't exist...
$flight = Flight::firstOrCreate([
'name' => 'London to Paris'
]);
// Retrieve flight by name or create it with the name, delayed, and arrival_time attributes...
$flight = Flight::firstOrCreate(
['name' => 'London to Paris'],
['delayed' => 1, 'arrival_time' => '11:30']
);
// Retrieve flight by name or instantiate a new Flight instance...
$flight = Flight::firstOrNew([
'name' => 'London to Paris'
]);
// Retrieve flight by name or instantiate with the name, delayed, and arrival_time attributes...
$flight = Flight::firstOrNew(
['name' => 'Tokyo to Sydney'],
['delayed' => 1, 'arrival_time' => '11:30']
);
对象创建
<?php
namespace App\Http\Controllers;
use App\Http\Controllers\Controller;
use App\Models\Flight;
use Illuminate\Http\Request;
class FlightController extends Controller
{
/**
* Store a new flight in the database.
*
* @param \Illuminate\Http\Request $request
* @return \Illuminate\Http\Response
*/
public function store(Request $request)
{
// Validate the request...
$flight = new Flight;
$flight->name = $request->name;
$flight->save();
}
}
对象更新
use App\Models\Flight;
$flight = Flight::find(1);
$flight->name = 'Paris to London';
$flight->save();
批量更新
Flight::where('active', 1)
->where('destination', 'San Diego')
->update(['delayed' => 1]);
对象填充数据
$flight->fill(['name' => 'Amsterdam to Frankfurt']);
按条件更新或创建
$flight = Flight::updateOrCreate(
['departure' => 'Oakland', 'destination' => 'San Diego'],//条件
['price' => 99, 'discounted' => 1] //数据
);
Flight::upsert([
['departure' => 'Oakland', 'destination' => 'San Diego', 'price' => 99],
['departure' => 'Chicago', 'destination' => 'New York', 'price' => 150]
], ['departure', 'destination'], ['price']);
删除
use App\Models\Flight;
$flight = Flight::find(1);
$flight->delete();
Flight::destroy(1);
Flight::destroy(1, 2, 3);
Flight::destroy([1, 2, 3]);
Flight::destroy(collect([1, 2, 3]));
查询删除
$deletedRows = Flight::where('active', 0)->delete();
逻辑删除
namespace App\Models;
use Illuminate\Database\Eloquent\Model;
use Illuminate\Database\Eloquent\SoftDeletes;
class Flight extends Model
{
use SoftDeletes; //多一个deleted_at字段
}
迁移文件
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Facades\Schema;
Schema::table('flights', function (Blueprint $table) {
$table->softDeletes();
});
Schema::table('flights', function (Blueprint $table) {
$table->dropSoftDeletes();
});
检查是是否被软删除
if ($flight->trashed()) {
//
}
还原逻辑删除的数据
$flight->restore();
Flight::withTrashed()
->where('airline_id', 1)
->restore();
$flight->history()->restore();
强制物理删除
$flight->forceDelete();
和软删除的数据一起查询
$flights = Flight::withTrashed()
->where('account_id', 1)
->get();
只查询软删除的数据
$flights = Flight::onlyTrashed()
->where('airline_id', 1)
->get();
对象复制replicate
use App\Models\Address;
$shipping = Address::create([
'type' => 'shipping',
'line_1' => '123 Example Street',
'city' => 'Victorville',
'state' => 'CA',
'postcode' => '90001',
]);
$billing = $shipping->replicate()->fill([
'type' => 'billing'
]);
$billing->save();
