fobia/laravel-sphinx

A Laravel query builder for SphinxQL

Sphinx Query Builder for Laravel

, _(*1)

Laravel-Sphinx Database connector, providing an expressive query builder, Eloquent, ActiveRecord style ORM, _(*2)

• Config
• Usage
• Query Builder
  • MATCH
  • WITHIN GROUP, ORDER, OPTION
• Api SphinxConnection
• Resources

Installation

laravel-sphinx can be installed with Composer by adding it as a dependency to your project's composer.json file., _(*3)

{
    "require": {
        "fobia/laravel-sphinx": "*"
    }
}

Please refer to Composer's documentation for more detailed installation and usage instructions., _(*4)

Config

After updating composer, add the ServiceProvider to the providers array in config/app.php, _(*5)

Fobia\Database\SphinxConnection\SphinxServiceProvider::class,

Finally you can just add Sphinx Connection to the database array in config/database.php, _(*6)

    'sphinx' => [
        'driver'   => 'sphinx',
        'host'     => env('SPHINX_HOST', env('DB_HOST','127.0.0.1')),
        'port' => 9306,
        'database' => '',
    ],

Usage

Get a connection and build queries, _(*7)

    $db = \DB::connection('sphinx');

Using The Query Builder, _(*8)

$users = $db->table('rt')->where('votes', '>', 100)->get();

Using The Eloquent ORM, _(*9)

class Product extends \Fobia\Database\SphinxConnection\Eloquent\Model {} 

$product = Product::find(1);

$products = Product::where('votes', '>', 1)->get();
$products = Product::match('name', 'match text')->get();

Attribute Casting For the results of the column attr_multi can choose the format, which is converted to an array., _(*10)

The values of '(1, 2, 3)' for column type attr_multi converted to an array [1, 2, 3], _(*11)

class Product extends \Fobia\Database\SphinxConnection\Eloquent\Model 
{
    protected $casts = [
        'tags' => 'mva',
    ];
}

Query Builder

    $sq = $db->table('rt');

For the build a query, using strong typing of values (how in SphinxQl)., _(*12)

Notice: id = 1 and id = '1' not the same, _(*13)

• integer It is used to type integer attr_uint, _(*14)

• float It is used to type float attr_float, _(*15)

• __bool__ (integer) It is used to type bool attr_bool, will be converted to integer (0 or 1), _(*16)

• __array__ (MVA) It is used to type MVA attr_multi, _(*17)

  $sq->insert([
      'id' => 1,
      'tags' => [1, 2, 3]
  ]);
  // Output: INSERT INTO rt (id, tags) VALUES(1, (1, 2, 3))
  

• string - string values, escaped when requested, _(*18)

  $sq->insert([
      'id' => 1,
      'name' => "name 'text'"
  ]);
  // Output: INSERT INTO rt (id, name) VALUES(1, 'name \'text\'')
  

MATCH

• $sq->match($column, $value, $half = false), _(*19)

  Search in full-text fields. Can be used multiple times in the same query. Column can be an array. Value can be an Expression to bypass escaping (and use your own custom solution)., _(*20)

  <?php
  $sq->match('title', 'Otoshimono')
      ->match('character', 'Nymph')
      ->match(array('hates', 'despises'), 'Oregano');
  
  $sq->match(function(\Foolz\SphinxQL\Match $m) {
        $m->not('text');
  });
  

  For a function match used library SphinxQL::match, _(*21)

WITHIN GROUP, ORDER, OPTION

• $sq->withinGroupOrderBy($column, $direction = 'ASC'), _(*22)

  WITHIN GROUP ORDER BY $column [$direction], _(*23)

  Direction can be omitted with null, or be ASC or DESC case insensitive., _(*24)

• $sq->orderBy($column, $direction = null), _(*25)

  ORDER BY $column [$direction], _(*26)

  Direction can be omitted with null, or be ASC or DESC case insensitive., _(*27)

• $sq->option($name, $value), _(*28)

  OPTION $name = $value, _(*29)

  Set a SphinxQL option such as max_matches or reverse_scan for the query., _(*30)

whereMulti

• $sq->whereMulti($column, $operator, $values), _(*31)

  All parameters converted to a flat array, _(*32)

  $sq->whereMulti('id', '=', [1, 2, 3, [4, 5]]);
  // Output: WHERE id = 1 and id = 2 and id = 3 and id = 4 and id = 5
  

  For the in and not in is different, _(*33)

  $sq->whereMulti('id', 'in', [1, 2, 3]);
  // Output: WHERE id in (1) and id in (2) and id in (3) 
  

  $sq->whereMulti('id', 'in', [1, [20, 21], [30, 31]]);
  // Output: WHERE id in (1) and id in (20, 21) and id in (30, 31) 
  
  // Equivalently
  $sq->whereMulti('id', 'in', 1, [20, 21], [30, 31]);
  // Output: WHERE id in (1) and id in (20, 21) and id in (30, 31) 
  

Replace

• $sq->replace($values), _(*34)

  $sq->replace([
      'id' => 1,
      'name' => 'text name'
  ]);
  

API SphinxConnection

• \Foolz\SphinxQL\Drivers\Pdo\Connection $db->getSphinxQLDriversConnection()
• \Foolz\SphinxQL\Helper $db->getSphinxQLHelper()
• \Foolz\SphinxQL\SphinxQL $db->createSphinxQL()

Resources

• SphinxSearch
• SphinxQL
• Laravel Eloquent