-
Notifications
You must be signed in to change notification settings - Fork 656
/
test311.js
65 lines (55 loc) · 1.86 KB
/
test311.js
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
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
if (typeof exports === 'object') {
var assert = require('assert');
var alasql = require('..');
} else {
__dirname = '.';
}
describe('Test 311 Special SEARCHors', function () {
it.skip('0. Create database ', function (done) {
alasql('CREATE DATABASE test311;USE test311');
done();
});
it.skip('1. SEARCH DISTINCT, UNION ALL, and other selectors', function (done) {
// var res = alasql.parse('CREATE GRAPH #Andrey');
var data = [
{a: 1, b: 10},
{a: 2, b: 20},
{a: 3, b: 30},
{a: 4, b: 40},
{a: 5, b: 50},
{a: 5, b: 50},
];
var res = alasql('SEARCH DISTINCT(/b) FROM ?', [data]);
assert.deepEqual(res, [10, 20, 30, 40, 50]);
var res = alasql('SEARCH UNION ALL(/a,/b) FROM ?', [data]);
assert.deepEqual(res, [1, 2, 3, 4, 5, 5, 10, 20, 30, 40, 50, 50]);
// Ala UNION
var res = alasql('SEARCH DISTINCT(UNION ALL(/a,/b)) FROM ?', [data]);
assert.deepEqual(res, [1, 2, 3, 4, 5, 10, 20, 30, 40, 50]);
var res = alasql('SEARCH UNION(/a,/b) FROM ?', [data]);
assert.deepEqual(res, [1, 2, 3, 4, 5, 10, 20, 30, 40, 50]);
//
/*
var res = alasql('SEARCH INTERSECT(a,b)');
var res = alasql('SEARCH EXCEPT(a,b)');
var res = alasql('SEARCH CROSS JOIN(a,b,c)');
var res = alasql('SEARCH MERGE(@a,@b)');
var res = alasql('SEARCH DELETE(@a,@b)'); // properties
var res = alasql('SEARCH REMOVE(@a,@b)'); // graphs
var res = alasql('SEARCH RETURNS(a AS b, b+1 AS c)'); // graphs
// Post processors
var res = alasql('SEARCH ORDER BY() '); // graphs
var res = alasql('SEARCH EVEN()'); // graphs
var res = alasql('SEARCH ODD()'); // graphs
var res = alasql('SEARCH NTH(2)'); // graphs -??
var res = alasql('SEARCH SLICE(2,2)'); // graphs -??
// selector ORDER BY (a,b,c)
console.log(res);
*/
done();
});
it.skip('99. Drop database ', function (done) {
alasql('DROP DATABASE test311');
done();
});
});