SequelizeHelperTest.js
3.93 KB
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
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
require(__dirname + "/../sequelize")
var h = SequelizeHelper
module.exports = {
'log should be defined': function(assert) {
assert.isNotNull(h.log)
assert.isNotUndefined(h.log)
},
'evaluateTemplate': function(assert) {
assert.equal(h.evaluateTemplate("hallo %{foo}!", {foo: 'welt'}), "hallo welt!")
assert.equal(h.evaluateTemplate("hallo %{foo}!", {foo: 'welt', bar: 'asd'}), "hallo welt!")
},
'SQL: manyToManyTableName': function(assert) {
assert.equal(h.SQL.manyToManyTableName({tableName: 'foo'}, {tableName: 'bar'}), 'barfoo')
assert.equal(h.SQL.manyToManyTableName({tableName: 'bar'}, {tableName: 'foo'}), 'barfoo')
},
'SQL: asTableIdentifier': function(assert) {
assert.equal(h.SQL.asTableIdentifier('Users'), 'userId')
},
'SQL: asTableName': function(assert) {
assert.equal(h.SQL.asTableName('User'), 'Users')
},
'SQL: asSqlDate': function(assert) {
var d = new Date(Date.parse("Tue, 1 Jan 2000 00:00:00 GMT"))
assert.equal(h.SQL.asSqlDate(d), '2000-01-01 01:00:00')
},
'SQL: valuesForInsertQuery': function(assert) {
var s = new Sequelize('sequelize_test', 'test', 'test')
var Day = s.define('Day', { name: Sequelize.TEXT })
var result = h.SQL.valuesForInsertQuery(new Day({name: 'asd'}))
assert.eql(result, ["'asd'", 'NULL', 'NULL'])
},
'SQL: fieldsForInsertQuery': function(assert) {
var s = new Sequelize('sequelize_test', 'test', 'test')
var Day = s.define('Day', { name: Sequelize.TEXT })
var result = h.SQL.fieldsForInsertQuery(new Day({name: 'asd'}))
assert.eql(result, 'name, createdAt, updatedAt')
},
'SQL: transformValueByDataType': function(assert) {
assert.equal(h.SQL.transformValueByDataType('asd', Sequelize.STRING), "'asd'")
assert.equal(h.SQL.transformValueByDataType('asd', Sequelize.TEXT), "'asd'")
assert.equal(h.SQL.transformValueByDataType(6, Sequelize.INTEGER), "6")
assert.equal(h.SQL.transformValueByDataType(null, Sequelize.INTEGER), "NULL")
assert.equal(h.SQL.transformValueByDataType(null, Sequelize.STRING), "NULL")
assert.equal(h.SQL.transformValueByDataType(null, Sequelize.TEXT), "NULL")
var d = new Date(Date.parse("Tue, 1 Jan 2000 00:00:00 GMT"))
assert.equal(h.SQL.transformValueByDataType(d, Sequelize.DATE), "'2000-01-01 01:00:00'")
},
'SQL: valuesForUpdate': function(assert) {
var s = new Sequelize('sequelize_test', 'test', 'test')
var Day = s.define('Day', { name: Sequelize.TEXT })
var day = new Day({name: 'asd'})
assert.equal(h.SQL.valuesForUpdate(day), "name = 'asd', createdAt = NULL, updatedAt = NULL")
assert.equal(h.SQL.valuesForUpdate(day, {seperator: '; '}), "name = 'asd'; createdAt = NULL; updatedAt = NULL")
},
'SQL: hashToWhereConditions': function(assert) {
var s = new Sequelize('sequelize_test', 'test', 'test')
var Day = s.define('Day', { name: Sequelize.TEXT })
var day = new Day({name: 'asd'})
assert.equal(h.SQL.hashToWhereConditions(5, Day.attributes), 'id = 5')
assert.equal(h.SQL.hashToWhereConditions({name: 'asd'}, Day.attributes), "name='asd'")
},
'Hash: forEach': function(assert) {
var values = []
var keys = []
h.Hash.forEach({a:1, b:2, c:3}, function(value, key) {
values.push(value)
keys.push(key)
})
assert.eql(values, [1,2,3])
assert.eql(keys, ['a', 'b', 'c'])
},
'Hash: map': function(assert) {
var hash = {a:1, b:2, c:3}
assert.eql(h.Hash.map(hash, function(value, key) {return value}), [1,2,3])
assert.eql(h.Hash.map(hash, function(value, key) {return key}), ['a','b','c'])
},
'Hash: keys': function(assert) {
assert.eql(h.Hash.keys({a:1,b:2}), ['a', 'b'])
},
'Hash: values': function(assert) {
assert.eql(h.Hash.values({a:1,b:2}), [1,2])
},
'Hash: merge': function(assert) {
var src = {a:1, b:2}
var target = {b:3, c:3}
assert.eql(h.Hash.merge(src, target), {a:1, b:3, c:3})
assert.eql(h.Hash.merge(src, target, true), {a:1, b:2, c:3})
}
}