laravel-postgres

KO | EN

gitlite — search

#javascript #python #hacktoberfest #react #ai #typescript #llm #go #golang #android #machine-learning #rust #deep-learning #linux

laravel-postgres

★ 15 Open GitHub ↗

Eloquent support for postgreSQL fields

// repository documentation

Was this content helpful?

★ 0 (0 ratings)

# laravel-postgres

Adds support for postgreSQL fields for Eloquent.

<h3>Installation</h3>
```
composer require asmiarowski/laravel-postgres
```

<h3>Array field</h3>
Add trait to your model:
```
use Illuminate\Database\Eloquent\Model;
use Smiarowski\Postgres\Model\Traits\PostgresArray;

class ExampleModel extends Model
{
 use PostgresArray;
}
```
Set up accessor and mutator for your array field like so:
```
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:
wherePgArrayContains(string $column, mixed $value): Adds where query part, $column has all of the elements in $value. $value can be array, integer or string
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

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:
```
$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.

laravel-postgres

Explore Similar Repositories

Was this content helpful?

Recent Feedback

Download README