1 | 'use strict';
|
2 |
|
3 | var assert = require('assert');
|
4 | var Table = require(__dirname + '/../lib/table');
|
5 |
|
6 | var Foo = Table.define({
|
7 | name: 'foo',
|
8 | columns: ['baz','bar']
|
9 | });
|
10 |
|
11 | test('operators', function() {
|
12 | assert.equal(Foo.baz.equals(1).operator, '=');
|
13 | assert.equal(Foo.baz.equal(1).operator, '=');
|
14 | assert.equal(Foo.baz.notEqual(1).operator, '<>');
|
15 | assert.equal(Foo.baz.notEquals(1).operator, '<>');
|
16 | assert.equal(Foo.baz.like('asdf').operator, 'LIKE');
|
17 | assert.equal(Foo.baz.notLike('asdf').operator, 'NOT LIKE');
|
18 | assert.equal(Foo.baz.isNull().operator, 'IS NULL');
|
19 | assert.equal(Foo.baz.isNotNull().operator, 'IS NOT NULL');
|
20 | assert.equal(Foo.baz.gt(1).operator, '>');
|
21 | assert.equal(Foo.baz.gte(1).operator, '>=');
|
22 | assert.equal(Foo.baz.lt(1).operator, '<');
|
23 | assert.equal(Foo.baz.lte(1).operator, '<=');
|
24 | assert.equal(Foo.baz.plus(1).operator, '+');
|
25 | assert.equal(Foo.baz.minus(1).operator, '-');
|
26 | assert.equal(Foo.baz.multiply(1).operator, '*');
|
27 | assert.equal(Foo.baz.leftShift(1).operator, '<<');
|
28 | assert.equal(Foo.baz.rightShift(1).operator, '>>');
|
29 | assert.equal(Foo.baz.bitwiseAnd(1).operator, '&');
|
30 | assert.equal(Foo.baz.bitwiseNot(1).operator, '~');
|
31 | assert.equal(Foo.baz.bitwiseOr(1).operator, '|');
|
32 | assert.equal(Foo.baz.bitwiseXor(1).operator, '#');
|
33 | assert.equal(Foo.baz.divide(1).operator, '/');
|
34 | assert.equal(Foo.baz.modulo(1).operator, '%');
|
35 | assert.equal(Foo.baz.regex(1).operator, '~');
|
36 | assert.equal(Foo.baz.iregex(1).operator, '~*');
|
37 | assert.equal(Foo.baz.notRegex(1).operator, '!~');
|
38 | assert.equal(Foo.baz.notIregex(1).operator, '!~*');
|
39 | assert.equal(Foo.baz.regexp(1).operator, 'REGEXP');
|
40 | assert.equal(Foo.baz.rlike(1).operator, 'RLIKE');
|
41 | assert.equal(Foo.baz.ilike('asdf').operator, 'ILIKE');
|
42 | assert.equal(Foo.baz.notIlike('asdf').operator, 'NOT ILIKE');
|
43 | assert.equal(Foo.baz.match('asdf').operator, '@@');
|
44 | });
|