find-findAll-all.js
3.66 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
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
var assert = require("assert")
, config = require("./../config")
, Sequelize = require("./../../index")
, sequelize = new Sequelize(config.database, config.username, config.password, {logging: false})
var initUsers = function(num, callback) {
var User = sequelize.define('User' + parseInt(Math.random() * 99999999), { name: Sequelize.STRING, bio: Sequelize.TEXT })
var createUser = function() {
User.create({name: 'user' + num, bio: 'foobar'}).on('success', function(user){
if(--num) createUser()
else callback(user, User)
})
}
User.sync({force: true}).on('success', function() {
createUser()
})
}
module.exports = {
'all should return all created models': function(exit) {
initUsers(2, function(_, User) {
User.all.on('success', function(users) {
assert.eql(users.length, 2)
exit(function(){})
})
})
},
'find should return a single model': function(exit) {
initUsers(2, function(lastInsertedUser, User) {
User.find(lastInsertedUser.id).on('success', function(user) {
assert.eql(user.id, lastInsertedUser.id)
exit(function(){})
})
})
},
'find a specific user': function(exit) {
initUsers(2, function(_, User) {
var username = 'user1'
User.find({where: {name: username}}).on('success', function(user) {
assert.eql(user.name, username)
exit(function(){})
})
})
},
'should find no user with invalid conditions': function(exit) {
initUsers(2, function(_, User) {
User.find({where: {name: 'foo'}}).on('success', function(user) {
assert.eql(user, null)
exit(function(){})
})
})
},
'find should ignore passed limit': function(exit) {
initUsers(2, function(_, User) {
User.find({limit: 10}).on('success', function(user) {
// it returns an object instead of an array
assert.eql(user.hasOwnProperty('name'), true)
exit(function(){})
})
})
},
'find should find records by primaryKeys': function(exit) {
var User = sequelize.define('User' + parseInt(Math.random() * 999999999), {
identifier: {type: Sequelize.STRING, primaryKey: true},
name: Sequelize.STRING
})
User.sync({force:true}).on('success', function() {
User.create({identifier: 'an identifier', name: 'John'}).on('success', function(u) {
assert.isUndefined(u.id)
User.find('an identifier').on('success', function(u2) {
assert.eql(u.identifier, 'an identifier')
assert.eql(u.name, 'John')
exit(function(){})
})
})
})
},
'findAll should find all records': function(exit) {
initUsers(2, function(_, User) {
User.findAll().on('success', function(users) {
assert.eql(users.length, 2)
exit(function(){})
})
})
},
'findAll should return the correct elements for passed conditions': function(exit) {
initUsers(2, function(lastUser, User) {
User.findAll({where: "id != " + lastUser.id}).on('success', function(users) {
assert.eql(users.length, 1)
exit(function(){})
})
})
},
'findAll should return the correct order when order is passed': function(exit) {
initUsers(2, function(lastUser, User) {
User.findAll({order: "id DESC"}).on('success', function(users) {
assert.eql(users[0].id > users[1].id, true)
exit(function(){})
})
})
},
'findAll should handle offset and limit correctly': function(exit) {
initUsers(10, function(_, User) {
User.findAll({limit: 2, offset: 2}).on('success', function(users) {
assert.eql(users.length, 2)
assert.eql(users[0].id, 3)
exit(function(){})
})
})
}
}