Sphinx - Revision history

Sebas: /* Querying from SKU */

2020-11-11T15:47:35Z

Querying from SKU

Sebas: /* Querying from SKU */

2020-11-11T15:44:35Z

Querying from SKU

Sebas: /* Querying from SKU */

2020-11-10T21:28:54Z

Querying from SKU

Sebas at 21:22, 10 November 2020

2020-11-10T21:22:01Z

Sebas at 21:17, 10 November 2020

2020-11-10T21:17:26Z

Sebas: /* Setting up a Systemd service */

2020-11-10T17:58:52Z

Setting up a Systemd service

Sebas: /* Setting up a Systemd service */

2020-11-09T17:16:34Z

Setting up a Systemd service

Sebas: /* Setting up a Systemd service */

2020-11-09T16:35:59Z

Setting up a Systemd service

Sebas: /* Setting up a Systemd service */

2020-11-09T16:13:54Z

Setting up a Systemd service

Sebas: /* Setting up a Systemd service */

2020-11-09T16:11:26Z

Setting up a Systemd service

@@ Line 404: / Line 404: @@
 === Querying from SKU ===
-To add a search to a query builder we use the SphinxSearh::join() method.
+To add a search to an Eloquent query builder we use the SphinxSearh::filter() method.
-We need to pass the name of the index we want to join, the query builder to add the filtering to, and the name of the field to join on (fk_field).
+We need to pass the query builder to add the filtering to, the name of the index we want to filter by, and the name of the field to match with the ID's that Sphinx returns (fk_field).
 For the fulltext index "sku_products" the fk_field will usually be "products.id", because the ID of the sphinx resulting records will be a reference to that ID, but we could also join that particular fulltext index to another table that has that same value stored in a column, for instance: "product_attributes.product_id".

@@ Line 425: / Line 425: @@
 -        return $builder->where('products.name', 'like', $query . '%')->orWhere('products.sku', 'like', $query . '%');
 +          if (SphinxSearch::indexEnabled('sku_products')) {
-+            SphinxSearch::join('sku_products',$builder, ['fk_field'=>'products.id','query'=>$query]);
++            SphinxSearch::filter($builder, 'sku_products', ['fk_field'=>'products.id','query'=>$query]);
 +          } else {
 +            $builder->where('products.name', 'like', $query . '%')->orWhere('products.sku', 'like', $query . '%');

← Older revision		Revision as of 21:28, 10 November 2020
Line 403:		Line 403:

	=== Querying from SKU ===		=== Querying from SKU ===
		+
		+	To add a search to a query builder we use the SphinxSearh::join() method.
		+	We need to pass the name of the index we want to join, the query builder to add the filtering to, and the name of the field to join on (fk_field).
		+
		+	For the fulltext index "sku_products" the fk_field will usually be "products.id", because the ID of the sphinx resulting records will be a reference to that ID, but we could also join that particular fulltext index to another table that has that same value stored in a column, for instance: "product_attributes.product_id".

	<syntaxhighlight lang="diff">		<syntaxhighlight lang="diff">

@@ Line 427: / Line 427: @@
         });
+      }
-<syntaxhighlight>
+</syntaxhighlight>

← Older revision		Revision as of 21:17, 10 November 2020
Line 401:		Line 401:
	ft_p.query = "simple and easy to install;offset=0;limit=1000"		ft_p.query = "simple and easy to install;offset=0;limit=1000"
	</syntaxhighlight>		</syntaxhighlight>
		+
		+	=== Querying from SKU ===
		+
		+	<syntaxhighlight lang="diff">
		+	--- a/app/Http/Controllers/SupplierProductController.php
		+	+++ b/app/Http/Controllers/SupplierProductController.php
		+
		+	@@ -11,6 +11,7 @@ use App\Response;
		+	+use App\Lib\SphinxSearch\SphinxSearch;
		+
		+	class SupplierProductController extends Controller
		+	{
		+
		+	@@ -47,7 +48,12 @@ class SupplierProductController extends Controller
		+	if($query = $request->query('query')){
		+	// And an 'or' filter for product name and product sku
		+	$supplierProducts->whereHas('product', function(Builder $builder) use ($query) {
		+	- return $builder->where('products.name', 'like', $query . '%')->orWhere('products.sku', 'like', $query . '%');
		+	+ if (SphinxSearch::indexEnabled('sku_products')) {
		+	+ SphinxSearch::join('sku_products',$builder, ['fk_field'=>'products.id','query'=>$query]);
		+	+ } else {
		+	+ $builder->where('products.name', 'like', $query . '%')->orWhere('products.sku', 'like', $query . '%');
		+	+ }
		+	+ return $builder;
		+	});
		+	}
		+	<syntaxhighlight>

@@ Line 134: / Line 134: @@
 Nov 09 08:25:31 cricket env[26565]: Copyright (c) 2001-2020, Andrew Aksyonoff
 Nov 09 08:25:31 cricket env[26565]: Copyright (c) 2008-2016, Sphinx Technologies Inc (http://sphinxsearch.com)
 </syntaxhighlight>

@@ Line 130: / Line 130: @@
             └─26237 searchd --config /var/sphinxsearch/sphinx.conf
 Nov 09 08:25:31 cricket systemd[1]: Started Sphinx Search Service (for SKU searches).
 Nov 09 08:25:31 cricket env[26565]: Sphinx 3.3.1 (commit b72d67b)

@@ Line 117: / Line 117: @@
 <syntaxhighlight>
 $ sudo systemctl start sphinxsearch
-</syntaxhiglhight>
+</syntaxhighlight>
 And check the outcome:
 <syntaxhighlight>
-$ systemctl status sphinxsearch.service
+$ systemctl status sphinxsearch
 ● sphinxsearch.service - Sphinx Search Service (for SKU searches)
-    Loaded: loaded (/lib/systemd/system/sphinxsearch.service; disabled)
+    Loaded: loaded (/lib/systemd/system/sphinxsearch.service; linked)
-    Active: failed (Result: start-limit) since Mon 2020-11-09 07:54:13 PST; 2min 45s ago
+    Active: active (running) since Mon 2020-11-09 08:25:31 PST; 8min ago
-   Process: 23910 ExecStart=/usr/bin/env searchd --config /var/sphinxsearch/sphinx.conf (code=exited, status=0/SUCCESS)
+   Process: 26565 ExecStart=/usr/bin/env searchd --config /var/sphinxsearch/sphinx.conf (code=exited, status=0/SUCCESS)
-  Main PID: 23910 (code=exited, status=0/SUCCESS)
+  Main PID: 26237 (searchd)
-Nov 09 07:54:13 cricket systemd[1]: sphinxsearch.service holdoff time over, scheduling restart.
+Nov 09 08:25:31 cricket env[26565]: Copyright (c) 2008-2016, Sphinx Technologies Inc (http://sphinxsearch.com)
-Nov 09 07:54:13 cricket systemd[1]: Stopping Sphinx Search Service (for SKU searches)...
+Nov 09 08:25:31 cricket env[26565]: FATAL: failed to lock pid file '/var/log/sphinxsearch/searchd.pid': Resource temporarily unavailable (searchd already running?)
-Nov 09 07:54:13 cricket systemd[1]: Starting Sphinx Search Service (for SKU searches)...
+Nov 09 08:25:31 cricket env[26565]: shutdown complete
-Nov 09 07:54:13 cricket systemd[1]: sphinxsearch.service start request repeated too quickly, refusing to start.
+Nov 09 08:25:31 cricket env[26565]: Sphinx 3.3.1 (commit b72d67b)
-Nov 09 07:54:13 cricket systemd[1]: Failed to start Sphinx Search Service (for SKU searches).
+Nov 09 08:25:31 cricket env[26565]: Copyright (c) 2001-2020, Andrew Aksyonoff
-Nov 09 07:54:13 cricket systemd[1]: Unit sphinxsearch.service entered failed state.
+Nov 09 08:25:31 cricket env[26565]: Copyright (c) 2008-2016, Sphinx Technologies Inc (http://sphinxsearch.com)
-Nov 09 07:56:54 cricket systemd[1]: Stopped Sphinx Search Service (for SKU searches).
+Nov 09 08:25:31 cricket systemd[1]: Started Sphinx Search Service (for SKU searches).
 </syntaxhighlight>

@@ Line 96: / Line 96: @@
 [Service]
-Type=simple
+Type=forking
-Restart=always
+User=sphinxsearch
-RestartSec=1
+Group=sphinxsearch
 User=sphinxsearch
 ExecStart=/usr/bin/env searchd --config /var/sphinxsearch/sphinx.conf
@@ Line 104: / Line 110: @@
 [Install]
 WantedBy=multi-user.target
 </syntaxhighlight>