node-sql/test/dialects/regex-tests.js at c6786135035e8c5f87fc3a931285d6ad58822305 · brianc/node-sql · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
'use strict';

var Harness = require('./support');
var customer = Harness.defineCustomerTable();

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.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: {
    text  : 'SELECT ("customer"."metadata" !~ $1) FROM "customer"',
    string: 'SELECT ("customer"."metadata" !~ \'age\') FROM "customer"'
  },
  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']
});