databaseAccess.js
3.14 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
var Sequelize = require(__dirname + "/../../lib/sequelize/Sequelize").Sequelize
var s = new Sequelize('sequelize_test', 'root', null, {disableLogging: true})
var Day = s.define('Day', { name: Sequelize.TEXT })
var assert = require("assert")
module.exports = {
'save should set the id of a newly created object': function(beforeExit) {
var subject = null
var SaveTest = s.define('SaveTest', {name: Sequelize.STRING})
SaveTest.drop(function(){
SaveTest.sync(function() {
new SaveTest({name:'s'}).save(function(_saveTest){
subject = _saveTest
})
})
})
beforeExit(function() {
assert.isNotNull(subject.id)
})
},
'updateAttributes should update available attributes': function(beforeExit) {
var subject = null
var UpdateMe = s.define('UpdateMe', {name: Sequelize.STRING})
Sequelize.chainQueries([{drop: UpdateMe}, {sync: UpdateMe}], function() {
new UpdateMe({name:'Monday'}).save(function(u) {
u.updateAttributes({name: 'Sunday', foo: 'bar'}, function(u) {
subject = u
})
})
})
beforeExit(function() {
assert.isNotNull(subject)
assert.equal(subject.name, 'Sunday')
assert.isUndefined(subject.foo)
})
},
'destroy should make the object unavailable': function(beforeExit) {
var subject = 1
var UpdateAttributesTest = s.define('UpdateAttributeTest', {name: Sequelize.STRING})
Sequelize.chainQueries([{drop: UpdateAttributesTest}, {sync: UpdateAttributesTest}], function() {
new UpdateAttributesTest({name:'Monday'}).save(function(day) {
day.destroy(function() {
UpdateAttributesTest.find(day.id, function(result) {
subject = result
})
})
})
})
beforeExit(function() {
assert.isNull(subject)
})
},
'boolean ==> save': function(beforeExit) {
var BooleanTest = s.define("BooleanTest", {flag: Sequelize.BOOLEAN})
var testIsFinished = false
BooleanTest.sync(function() {
new BooleanTest({flag: true}).save(function(obj) {
assert.equal(obj.flag, true)
obj.updateAttributes({flag: false}, function(obj2) {
assert.equal(obj2.flag, false)
testIsFinished = true
})
})
})
beforeExit(function() { assert.equal(true, testIsFinished) })
},
'sync ==> failure': function(beforeExit) {
var testIsFinished = false,
sequelizeWithInvalidCredentials = new Sequelize('foo', 'bar', 'barfoos'),
Fail = sequelizeWithInvalidCredentials.define('Fail', {})
Fail.sync(function(table, err) {
assert.isDefined(err)
assert.isDefined(err.message)
testIsFinished = true
})
beforeExit(function() { assert.equal(testIsFinished, true) })
},
'drop ==> failure': function(beforeExit) {
var testIsFinished = false,
sequelizeWithInvalidCredentials = new Sequelize('foo', 'bar', 'barfoos'),
Fail = sequelizeWithInvalidCredentials.define('Fail', {})
Fail.drop(function(table, err) {
assert.isDefined(err)
assert.isDefined(err.message)
testIsFinished = true
})
beforeExit(function() { assert.equal(testIsFinished, true) })
}
}