Adding iregex and notIregex.

Paul King · Paul King · commit 5850bf07b2ef · 2015-04-13T11:33:14.000-06:00
diff --git a/lib/node/valueExpression.js b/lib/node/valueExpression.js
@@ -138,8 +138,10 @@ var ValueExpressionMixin = function() {
     bitwiseOr  : binaryMethod('|'),
     bitwiseXor : binaryMethod('#'),
     regex      : binaryMethod('~'),
+    iregex     : binaryMethod('~*'),
     regexp     : binaryMethod('REGEXP'),
     notRegex   : binaryMethod('!~'),
+    notIregex   : binaryMethod('!~*'),
     concat     : binaryMethod('||'),
     key        : binaryMethod('->'),
     keyText    : binaryMethod('->>'),
diff --git a/test/binary-clause-tests.js b/test/binary-clause-tests.js
@@ -33,7 +33,9 @@ test('operators', function() {
   assert.equal(Foo.baz.divide(1).operator, '/');
   assert.equal(Foo.baz.modulo(1).operator, '%');
   assert.equal(Foo.baz.regex(1).operator, '~');
+  assert.equal(Foo.baz.iregex(1).operator, '~*');
   assert.equal(Foo.baz.notRegex(1).operator, '!~');
+  assert.equal(Foo.baz.notIregex(1).operator, '!~*');
   assert.equal(Foo.baz.regexp(1).operator, 'REGEXP');
   assert.equal(Foo.baz.rlike(1).operator, 'RLIKE');
   assert.equal(Foo.baz.ilike('asdf').operator, 'ILIKE');
diff --git a/test/dialects/regex-tests.js b/test/dialects/regex-tests.js
@@ -13,6 +13,15 @@ Harness.test({
   params: ['age']
 });
 
+Harness.test({
+  query: customer.select(customer.metadata.iregex('age')),
+  pg: {
+    text  : 'SELECT ("customer"."metadata" ~* $1) FROM "customer"',
+    string: 'SELECT ("customer"."metadata" ~* \'age\') FROM "customer"'
+  },
+  params: ['age']
+});
+
 Harness.test({
   query: customer.select(customer.metadata.notRegex('age')),
   pg: {
@@ -21,3 +30,12 @@ Harness.test({
   },
   params: ['age']
 });
+
+Harness.test({
+  query: customer.select(customer.metadata.notIregex('age')),
+  pg: {
+    text  : 'SELECT ("customer"."metadata" !~* $1) FROM "customer"',
+    string: 'SELECT ("customer"."metadata" !~* \'age\') FROM "customer"'
+  },
+  params: ['age']
+});
