create.js
1.59 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
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) {
return sequelize.define('User' + parseInt(Math.random() * 99999999), { name: Sequelize.STRING, bio: Sequelize.TEXT })
}
module.exports = {
'do not allow duplicated records with unique:true': function(exit) {
var User = sequelize.define('User' + parseInt(Math.random() * 99999999), {
username: {type: Sequelize.STRING, unique: true}
})
User.sync({force:true}).on('success', function() {
User.create({username:'foo'}).on('success', function() {
User.create({username: 'foo'}).on('failure', function(err) {
assert.eql(err.message, "Duplicate entry 'foo' for key 'username'")
exit(function(){})
})
})
})
},
'it should raise an error if created object breaks definition constraints': function(exit) {
var User = sequelize.define('User' + parseInt(Math.random() * 99999999), {
username: {type: Sequelize.STRING, unique: true},
smth: {type: Sequelize.STRING, allowNull: false}
})
User.sync({force:true}).on('success', function() {
User.create({username: 'foo', smth: null}).on('failure', function(err) {
assert.eql(err.message, "Column 'smth' cannot be null")
User.create({username: 'foo'}).on('failure', function(err) {
assert.eql(err.message, "Column 'smth' cannot be null")
exit(function(){})
})
})
})
}
}