| 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 | });
|