PHP code example of baril / sqlout

    
        
<?php
require_once('vendor/autoload.php');

/* Start to develop here. Best regards https://php-download.com/ */

    

baril / sqlout example snippets

return [
    // ...
    'providers' => [
        // ...
        Laravel\Scout\ScoutServiceProvider::class,
        Baril\Sqlout\SqloutServiceProvider::class,
    ],
];

return [
    // ...
    'sqlout' => [
        'table_name' => 'my_custom_index_name',
        // ...
    ],
    // ...
];

return [
    // ...
    'sqlout' => [
        'table_name' => '',
        // ...
    ],
    // ...
];

return [
    'prefix' => 'sqlout_',
    'suffix' => '',
];

namespace App\Models;

use Baril\Sqlout\Searchable;

class Post extends Model
{
    use Searchable;

    protected $weights = [
        'title' => 4,
        'excerpt' => 2,
    ];

    public function toSearchableArray()
    {
        return [
            'title' => $this->post_title,
            'excerpt' => $this->post_excerpt,
            'body' => $this->post_content,
        ];
    }

    // Optionally, you can customize the
    // name of the table that the model
    // will be indexed in:
    public function searchableAs(): string
    {
        return 'my_custom_index';
    }
}

$results = Post::search('this rug really tied the room together')->get();
$results = Post::search('the dude abides')->withTrashed()->get();

// Restrict the search to some fields only:
$builder->only('title');
$builder->only(['title', 'excerpt']);
// (use the same names as in the toSearchableArray method)

// Retrieve the total number of results:
$nbHits = $builder->count();

$results = Post::search('you see what happens larry')
    ->published() // the `published` scope is defined in the Post class
    ->where('date', '>', '2010-10-10')
    ->get();

$results = Post::search('ve vant ze money lebowski')
    ->query(function ($query) {
        $query->within('something');
    })
    ->get();

$builder->inNaturalLanguageMode();
$builder->withQueryExpansion();
$builder->inBooleanMode();

$builder->orderBy('post_status', 'asc')->orderByScore();
// "post_status" is a column of the original table

return [
    // ...
    'sqlout' => [
        // ...
        'filters' => [ // anything callable (function name, closure...)
            'strip_tags',
            'html_entity_decode',
            'mb_strtolower',
            'strip_punctuation', // this helper is provided by Sqlout (see helpers.php)
        ],
        'token_delimiter' => '/[\s]+/',
        'minimum_length' => 2,
        'stopwords' => [
            'est',
            'les',
        ],
        'stemmer' => Wamania\Snowball\Stemmer\French::class,
    ],
];

// config/scout.php
return [
    // ...
    'sqlout' => [
        // ...
        'stopwords' => 'storage/app/stopwords/fr.php',
        // ...
    ],
];

// storage/app/stopwords/fr.php
return [
    'à',
    'le',
    'la',
];

bash
php artisan vendor:publish

bash
php artisan sqlout:make-migration
php artisan migrate

bash
php artisan sqlout:make-migration my_other_connection
php artisan migrate

bash
php artisan sqlout:make-migration --model="\\App\\Models\\Post"
php artisan migrate