forked from brianc/node-sql
-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathtable-tests.js
More file actions
41 lines (32 loc) · 988 Bytes
/
table-tests.js
File metadata and controls
41 lines (32 loc) · 988 Bytes
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
var assert = require('assert');
var Table = require(__dirname + '/../lib/table');
var Column = require(__dirname + '/../lib/column');
var table = new Table({
name: 'bang'
})
assert.equal(table.getName(), 'bang');
assert.equal(table.columns.length, 0);
var col = new Column({
table: table,
name: 'boom'
})
assert.equal(col.name, 'boom');
assert.equal(col.table.getName(), 'bang');
table.addColumn(col);
assert.equal(table.columns.length, 1);
assert.equal(table.boom, col);
console.log('table creates query node');
var sel = table.select(table.boom);
assert.equal(sel.type, 'QUERY');
console.log('table can be defined');
var user = Table.define({
name: 'user',
columns: ['id', 'name']
})
assert.equal(user.getName(), 'user');
assert.equal(user.columns.length, 2);
assert.equal(user.columns[0].name, 'id');
assert.equal(user.columns[1].name, 'name');
assert.equal(user.columns[0].name, user.id.name)
assert.equal(user.id.table, user);
assert.equal(user.name.table, user);