Adding handler for empty arrays with eq/neq functions

darkain · darkain · commit 1ae73cdb1e4f · 2022-06-10T18:48:58.000-07:00
diff --git a/test/clause.inc.php b/test/clause.inc.php
@@ -339,6 +339,27 @@
 
 
 
+//SELECT statement where column isnt equal to NULL
+$db->string()->select('*', 'table', ['column'=>pudl::neq([NULL])]);
+pudlTest($db, "SELECT * FROM `table` WHERE `column` NOT IN (NULL)");
+
+
+
+
+//SELECT statement where column isnt equal to NULL
+$db->string()->select('*', 'table', ['column'=>pudl::neq([])]);
+pudlTest($db, "SELECT * FROM `table` WHERE `column` NOT IN (NULL)");
+
+
+
+
+//SELECT statement where column isnt equal to NULL
+$db->string()->select('*', 'table', ['column'=>pudl::eq([])]);
+pudlTest($db, "SELECT * FROM `table` WHERE `column` IN (NULL)");
+
+
+
+
 //SELECT statement where column isnt equal to integer
 $db->string()->select('*', 'table', ['column'=>pudl::neq(5)]);
 pudlTest($db, "SELECT * FROM `table` WHERE `column`!=5");
diff --git a/traits/pudlQuery.php b/traits/pudlQuery.php
@@ -465,6 +465,10 @@ private function _clauseRecurse($clause, $joiner=' AND ', $prefix=false, $encase
 				if ($value instanceof pudlResult && !$value instanceof pudlValue) continue;
 				if ($value instanceof pudlEquals  &&  $value->value instanceof pudlResult) continue;
 
+				if ($value instanceof pudlEquals  &&  $value->value === []) {
+					$value->value = [NULL];
+				}
+
 			} else if ($value instanceof pudlSort  &&  is_int($key)) {
 				$query			.= $this->identifiers($value->column);
 				$query			.= ' ' . $value->value;
