From fb778e5bfce132b0d0d1c66f949b982fa6a64552 Mon Sep 17 00:00:00 2001 From: Marcin Haba Date: Tue, 26 Sep 2023 11:32:27 +0200 Subject: [PATCH] baculum: Add regex operator support in queries --- gui/baculum/protected/API/Modules/Database.php | 4 ++++ 1 file changed, 4 insertions(+) diff --git a/gui/baculum/protected/API/Modules/Database.php b/gui/baculum/protected/API/Modules/Database.php index 0cda1f51c..78528ccbb 100644 --- a/gui/baculum/protected/API/Modules/Database.php +++ b/gui/baculum/protected/API/Modules/Database.php @@ -207,6 +207,10 @@ class Database extends APIModule { $cond[] = "{$key} {$value[$i]['operator']} :{$kval}{$i}"; $vals[":{$kval}{$i}"] = $value[$i]['vals']; $value[$i]['operator'] = ''; + } elseif (in_array($value[$i]['operator'], ['REGEXP', 'REGEXP BINARY', '~', '~*'])) { + $cond[] = "{$key} {$value[$i]['operator']} :{$kval}{$i}"; + $vals[":{$kval}{$i}"] = $value[$i]['vals']; + $value[$i]['operator'] = ''; } else { $cond[] = "$key = :{$kval}{$i}"; $vals[":{$kval}{$i}"] = $value[$i]['vals']; -- 2.47.3