-
Notifications
You must be signed in to change notification settings - Fork 656
/
test309.js
35 lines (31 loc) · 911 Bytes
/
test309.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
if (typeof exports === 'object') {
var assert = require('assert');
var alasql = require('..');
} else {
__dirname = '.';
}
describe('Test 309 # operator and graphs', function () {
it('0. Create database ', function (done) {
alasql('CREATE DATABASE test309;USE test309');
done();
});
it('1. SET selector', function (done) {
alasql('CREATE VERTEX #Andrey SET age = 44');
alasql('CREATE VERTEX #Olga SET age = 35');
alasql('CREATE VERTEX #Maria SET age = 28');
var res = alasql('SELECT VALUE #Andrey->age');
assert(res == 44);
var res = alasql('SEARCH age FROM #Olga');
assert.deepEqual(res, [35]);
var res = alasql('SEARCH / AS @p #Olga age');
assert.deepEqual(res, [35]);
var res = alasql('SEARCH VALUE / #Olga age');
// console.log(res);
assert(res == 35);
done();
});
it('99. Drop database ', function (done) {
alasql('DROP DATABASE test309');
done();
});
});