From 2eb5a432d2229788ce2fdb09f36c6f4bebdea813 Mon Sep 17 00:00:00 2001
From: Laria Carolin Chabowski <laria@laria.me>
Date: Fri, 7 Feb 2020 09:44:59 +0100
Subject: Initial commit

---
 src/Search/AbstractFTSExpr.php | 31 +++++++++++++++++++++++++++++++
 1 file changed, 31 insertions(+)
 create mode 100644 src/Search/AbstractFTSExpr.php

(limited to 'src/Search/AbstractFTSExpr.php')

diff --git a/src/Search/AbstractFTSExpr.php b/src/Search/AbstractFTSExpr.php
new file mode 100644
index 0000000..b72b1b6
--- /dev/null
+++ b/src/Search/AbstractFTSExpr.php
@@ -0,0 +1,31 @@
+<?php
+
+
+namespace Micropoly\Search;
+
+
+abstract class AbstractFTSExpr implements SearchExpr
+{
+    abstract protected function fts4Query(): string;
+
+    public function toSQL(string $bindPrefix, bool $singleFTS): SQLSearchExpr
+    {
+        $sqlex = new SQLSearchExpr();
+
+        $sqlex->sql = $singleFTS
+            ? "nc.note_contents MATCH :{$bindPrefix}match"
+            : "n.content_row IN (
+                SELECT rowid
+                FROM note_contents
+                WHERE note_contents MATCH :{$bindPrefix}match
+            )";
+        $sqlex->bindings["{$bindPrefix}match"] = $this->fts4Query();
+
+        return $sqlex;
+    }
+
+    public function countFTSQueries(): int
+    {
+        return 1;
+    }
+}
\ No newline at end of file
-- 
cgit v1.2.3-70-g09d2