asmiarowski/laravel-postgres

Eloquent support for postgreSQL fields

laravel-postgres

Adds support for postgreSQL fields for Eloquent., _(*1)

Installation

composer require asmiarowski/laravel-postgres

Array field

Add trait to your model:, _(*2)

use Illuminate\Database\Eloquent\Model;
use Smiarowski\Postgres\Model\Traits\PostgresArray;

class ExampleModel extends Model
{
    use PostgresArray;
}

, _(*3)

Set up accessor and mutator for your array field like so:, _(*4)

public function setArrayField(array $value)
{
    $this->array_field = self::mutateToPgArray($value);
}
public function getArrayField()
{
    return self::accessPgArray($this->array_field);
}

Query scopes available for builder:, _(*5)

wherePgArrayContains(string $column, mixed $value): Adds where query part, $column has all of the elements in $value. $value can be array, integer or string, _(*6)

wherePgArrayOverlap(string $column, mixed $value): Adds where query part, $column has any (at least one) of the elements in $value. $value can be array, integer or string, _(*7)

For example, let's say you have an array of strings as tags for restaurants. If you would want to find all restaurants that serve pizza or lasagne, you would build your query like so:, _(*8)

$restaurants = Restaurant::wherePgArrayOverlap('tag', ['pizza', 'lasagne'])->get();

Above example would return only thoes restaurants that have tags pizza or lasagne in their defined tags field. If you would want only restaurants that have all of the tags specified, you would use wherePgArrayContains instead., _(*9)