emiliopedrollo / laravel-postgres-extended-schema
Eloquent Extended, added some PostgreSQL features
Requires
- php: ^8.0.2
- ext-pdo: *
- doctrine/dbal: ^2.12|^3.0
- illuminate/database: ^9.0|^10.0|^11.0
- ramsey/uuid: ^3.9.2|^4.0
Requires (Dev)
- illuminate/container: ^9.0|^10.0|^11.0
- illuminate/support: ^9.0|^10.0|^11.0
- mockery/mockery: ^1.4.2
- phpunit/phpunit: ^9.3
- dev-master
- v4.11.1
- v4.11.0
- v3.1.1
- v3.1.0
- v3.0.0
- v2.9.0
- v2.8.3
- 2.8.2
- v2.8.1
- v2.8.0
- v2.7.0
- v2.6.0
- v2.5.0
- v2.4.0
- v2.3.0
- v2.2.2
- v2.2.1
- v2.2.0
- v2.1.0
- v2.1.0-RC3
- v2.1.0-RC2
- v2.1.0-RC1
- v2.0.0
- v2.0.0-RC1
- v1.2.3
- v1.2.2
- v1.2.1
- v1.2.0
- v1.1.0
- v1.0.0
- 0.19
- 0.18
- 0.17
- 0.16
- 0.15
- 0.14
- 0.13
- 0.12
- 0.11
- 0.10
- 0.9
- 0.8
- 0.7
- 0.6
- 0.5
- 0.4
- 0.3
- 0.2
- 0.1
This package is auto-updated.
Last update: 2024-10-28 20:24:30 UTC
README
Introduction
An extended PostgreSQL driver for Laravel 9+ with support for some aditional PostgreSQL data types: hstore, uuid, geometric types (point, path, circle, line, polygon...) and support for WITH [RECURSIVE] clause
Installation
Simple run composer require emiliopedrollo/laravel-postgres-extended-schema
in your project root directory.
Then you are done.
Usage
SELECT Queries
Use withExpression()
and provide a query builder instance, an SQL string or a closure:
$posts = DB::table('p') ->select('p.*', 'u.name') ->withExpression('p', DB::table('posts')) ->withExpression('u', function ($query) { $query->from('users'); }) ->join('u', 'u.id', '=', 'p.user_id') ->get();
Use withRecursiveExpression()
for recursive expressions:
$query = DB::table('users') ->whereNull('parent_id') ->unionAll( DB::table('users') ->select('users.*') ->join('tree', 'tree.id', '=', 'users.parent_id') ); $tree = DB::table('tree') ->withRecursiveExpression('tree', $query) ->get();
You can provide the expression's columns as the third argument:
$query = 'select 1 union all select number + 1 from numbers where number < 10'; $numbers = DB::table('numbers') ->withRecursiveExpression('numbers', $query, ['number']) ->get();
INSERT/UPDATE/DELETE Queries
You can use common table expressions in INSERT
, UPDATE
and DELETE
queries:
DB::table('profiles') ->withExpression('u', DB::table('users')->select('id', 'name')) ->insertUsing(['user_id', 'name'], DB::table('u'));
DB::table('profiles') ->withExpression('u', DB::table('users')) ->join('u', 'u.id', '=', 'profiles.user_id') ->update(['profiles.name' => DB::raw('u.name')]);
DB::table('profiles') ->withExpression('u', DB::table('users')->where('active', false)) ->whereIn('user_id', DB::table('u')->select('id')) ->delete();
Eloquent
You can use common table expressions in Eloquent queries.
$query = User::whereNull('parent_id') ->unionAll( User::select('users.*') ->join('tree', 'tree.id', '=', 'users.parent_id') ); $tree = User::from('tree') ->withRecursiveExpression('tree', $query) ->get();
Recursive Relationships
If you want to implement recursive relationships, you can use this package: staudenmeir/laravel-adjacency-list