Merge pull request brianc#182 from eagleshine/master

brianc · brianc · commit 292cf9bf572d · 2014-09-12T11:16:39.000-04:00
Adding two operator for mysql: regexp for 'REGEXP' and rlike for 'RLIKE'.
diff --git a/lib/node/valueExpression.js b/lib/node/valueExpression.js
@@ -138,13 +138,15 @@ var ValueExpressionMixin = function() {
     bitwiseOr  : binaryMethod('|'),
     bitwiseXor : binaryMethod('#'),
     regex      : binaryMethod('~'),
+    regexp     : binaryMethod('REGEXP'),
     notRegex   : binaryMethod('!~'),
     concat     : binaryMethod('||'),
     key        : binaryMethod('->'),
     keyText    : binaryMethod('->>'),
     path       : binaryMethod('#>'),
     pathText   : binaryMethod('#>>'),
     like       : binaryMethod('LIKE'),
+    rlike      : binaryMethod('RLIKE'),
     notLike    : binaryMethod('NOT LIKE'),
     in         : inMethod,
     notIn      : notInMethod,
diff --git a/test/binary-clause-tests.js b/test/binary-clause-tests.js
@@ -34,4 +34,6 @@ test('operators', function() {
   assert.equal(Foo.baz.modulo(1).operator, '%');
   assert.equal(Foo.baz.regex(1).operator, '~');
   assert.equal(Foo.baz.notRegex(1).operator, '!~');
+  assert.equal(Foo.baz.regexp(1).operator, 'REGEXP');
+  assert.equal(Foo.baz.rlike(1).operator, 'RLIKE');
 });
