Add code, tests and docs for inequality operators: where_gt, where_lt, where_gte, where_lte

1 files changed, 27 insertions, 0 deletions

diff --git a/idiorm.php b/idiorm.php
index 365fa00..89ddd1a 100644
--- a/idiorm.php
+++ b/idiorm.php
@@ -341,6 +341,33 @@
             return $this->add_where($column_name, $value, 'LIKE');
         }
 
+        /**
+         * Add a WHERE ... > clause to your query
+         */
+        public function where_gt($column_name, $value) {
+            return $this->add_where($column_name, $value, '>');
+        }
+
+        /**
+         * Add a WHERE ... < clause to your query
+         */
+        public function where_lt($column_name, $value) {
+            return $this->add_where($column_name, $value, '<');
+        }
+
+        /**
+         * Add a WHERE ... >= clause to your query
+         */
+        public function where_gte($column_name, $value) {
+            return $this->add_where($column_name, $value, '>=');
+        }
+
+        /**
+         * Add a WHERE ... <= clause to your query
+         */
+        public function where_lte($column_name, $value) {
+            return $this->add_where($column_name, $value, '<=');
+        }
 
         /**
          * Add a raw WHERE clause to the query. The clause should