Merge branch 'sqlite-fixes' into oni

1 files changed, 16 insertions, 0 deletions

diff --git a/src/SemanticScuttle/db/sqlite.querybuilder.php b/src/SemanticScuttle/db/sqlite.querybuilder.php
new file mode 100644
index 0000000..91cabcf
--- /dev/null
+++ b/src/SemanticScuttle/db/sqlite.querybuilder.php
@@ -0,0 +1,16 @@
+<?php
+require_once 'QueryBuilder.php';
+
+class SQLiteQueryBuilder extends QueryBuilder
+{
+    public function isNotNull($query)
+    {
+        return " IIF({$query}, true, false) ";
+    }
+
+    public function left($query, $length)
+    {
+        $endIndex = $length + 1;
+        return " SUBSTRING({$query}, 0, {$endIndex}) ";
+    }
+}