1. Go to this page and download the library: Download prahsys/laravel-supabase library. Choose the download type require.
2. Extract the ZIP file and open the index.php.
3. Add this code to the index.php.
<?php
require_once('vendor/autoload.php');
/* Start to develop here. Best regards https://php-download.com/ */
prahsys / laravel-supabase example snippets
// These work automatically with the Supabase driver
$user = User::find($uuidString);
$user = User::where('id', $uuidString)->first();
$users = User::whereIn('id', [$uuid1, $uuid2])->get();
// Joins also work automatically
$posts = Post::join('users', 'posts.user_id', '=', 'users.id')
->where('users.email', '[email protected]')
->get();
use Prahsys\Supabase\Traits\CastsUuidColumns;
class Post extends Model
{
use CastsUuidColumns;
// Define additional UUID columns beyond the primary key
protected $uuidColumns = [
'user_id',
'other_uuid_column',
];
}
use Prahsys\Supabase\Database\Query\Grammars\PostgresGrammar;
// In a service provider or bootstrap file
PostgresGrammar::detectUuidColumnsWith(function ($columnName, $query) {
// Your custom logic to determine if a column is a UUID
// For example, use a specific naming pattern or check against a list
return str_contains($columnName, 'uuid_') || in_array($columnName, ['custom_uuid_field']);
});