dao-factory.spec.js
3.72 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
113
114
115
116
117
118
if(typeof require === 'function') {
const buster = require("buster")
, Sequelize = require("../index")
, config = require("./config/config")
, dialects = ['sqlite', 'mysql', 'postgres']
}
buster.spec.expose()
dialects.forEach(function(dialect) {
describe('DAOFactory@' + dialect, function() {
before(function(done) {
var self = this
this.sequelize = new Sequelize(config.database, config.username, config.password, {
logging: false
})
this.User = this.sequelize.define('User', {
username: Sequelize.STRING,
secretValue: Sequelize.STRING
})
self.sequelize
.getQueryInterface()
.dropAllTables()
.success(function() {
self.sequelize.daoFactoryManager.daos = []
self.User
.sync({ force: true })
.success(done)
.error(function(err) {
console.log(err)
})
})
.error(function(err) { console.log(err) })
})
describe('create with whitelist', function() {
before(function() {
this.data = {
username: 'Peter',
secretValue: '42'
}
})
it('should only store the values passed in the witelist', function(done) {
var self = this;
this.User.create(this.data, ['username']).success(function(user) {
self.User.find(user.id).success(function(_user) {
expect(_user.username).toEqual(self.data.username);
expect(_user.secretValue).not.toEqual(self.data.secretValue);
expect(_user.secretValue).toEqual(null);
done();
})
})
})
it('should store all values if no whitelist is specified', function(done) {
var self = this;
this.User.create(this.data).success(function(user) {
self.User.find(user.id).success(function(_user) {
expect(_user.username).toEqual(self.data.username);
expect(_user.secretValue).toEqual(self.data.secretValue);
done();
})
})
})
describe('handle quoted data', function() {
it('saves data with single quote', function() {
setup({ data: {type: Sequelize.STRING} })
var quote = "single'quote"
Helpers.async(function(done) {
User.create({ data: quote}).success(function(user) {
expect(user.data).toEqual(quote, 'memory single quote')
User.find({where: { id: user.id }}).success(function(user) {
expect(user.data).toEqual(quote, 'SQL single quote')
done()
})
})
})
})
it('saves data with double quote', function() {
setup({ data: {type: Sequelize.STRING} })
var quote = 'double"quote'
Helpers.async(function(done) {
User.create({ data: quote}).success(function(user) {
expect(user.data).toEqual(quote, 'memory double quote')
User.find({where: { id: user.id }}).success(function(user) {
expect(user.data).toEqual(quote, 'SQL double quote')
done()
})
})
})
})
it('saves stringified JSON data', function() {
setup({ data: {type: Sequelize.STRING} })
var json = JSON.stringify({ key: 'value' })
Helpers.async(function(done) {
User.create({ data: json}).success(function(user) {
expect(user.data).toEqual(json, 'memory data')
User.find({where: { id: user.id }}).success(function(user) {
expect(user.data).toEqual(json, 'SQL data')
done()
})
})
})
})
})
})
})
})