add regex operator support

rsolomo · rsolomo · commit b8dcbe656bbe · 2014-02-02T11:45:29.000-08:00
diff --git a/lib/node/valueExpression.js b/lib/node/valueExpression.js
@@ -109,6 +109,8 @@ var ValueExpressionMixin = function() {
     bitwiseNot : binaryMethod('~'),
     bitwiseOr  : binaryMethod('|'),
     bitwiseXor : binaryMethod('#'),
+    regex      : binaryMethod('~'),
+    notRegex   : binaryMethod('!~'),
     concat     : binaryMethod('||'),
     key        : binaryMethod('->'),
     keyText    : binaryMethod('->>'),
diff --git a/test/binary-clause-tests.js b/test/binary-clause-tests.js
@@ -32,4 +32,6 @@ test('operators', function() {
   assert.equal(Foo.baz.bitwiseXor(1).operator, '#');
   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.notRegex(1).operator, '!~');
 });
diff --git a/test/dialects/regex-tests.js b/test/dialects/regex-tests.js
@@ -0,0 +1,23 @@
+'use strict';
+
+var Harness = require('./support');
+var customer = Harness.defineCustomerTable();
+var Sql = require('../../lib').setDialect('postgres');
+
+Harness.test({
+  query: customer.select(customer.metadata.regex('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: {
+    text  : 'SELECT ("customer"."metadata" !~ $1) FROM "customer"',
+    string: 'SELECT ("customer"."metadata" !~ \'age\') FROM "customer"'
+  },
+  params: ['age']
+});
