query-interface.spec.js
3 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
var config = require("./config/config")
, Sequelize = require("../index")
, sequelize = new Sequelize(config.mysql.database, config.mysql.username, config.mysql.password, { logging: false })
, Helpers = new (require("./config/helpers"))(sequelize)
, QueryInterface = require("../lib/query-interface")
describe('QueryInterface', function() {
var interface = null
beforeEach(function() {
interface = sequelize.getQueryInterface()
Helpers.dropAllTables()
})
afterEach(function() {
interface = null
Helpers.dropAllTables()
})
describe('dropAllTables', function() {
it("should drop all tables", function() {
Helpers.async(function(done) {
interface.dropAllTables().success(done).error(function(err) { console.log(err) })
})
Helpers.async(function(done) {
interface.showAllTables().success(function(tableNames) {
expect(tableNames.length).toEqual(0)
done()
})
})
Helpers.async(function(done) {
interface.createTable('table', { name: Sequelize.STRING })
.success(done)
.error(function(err){ console.log(err)})
})
Helpers.async(function(done) {
interface.showAllTables().success(function(tableNames) {
expect(tableNames.length).toEqual(1)
done()
})
})
Helpers.async(function(done) {
interface.dropAllTables().success(done).error(function(err) { console.log(err) })
})
Helpers.async(function(done) {
interface.showAllTables().success(function(tableNames) {
expect(tableNames.length).toEqual(0)
done()
})
})
})
})
describe('indexes', function() {
beforeEach(function(){
Helpers.async(function(done) {
interface.createTable('User', {
username: Sequelize.STRING,
isAdmin: Sequelize.BOOLEAN
}).success(done)
})
})
it('adds, reads and removes an index to the table', function() {
Helpers.async(function(done) {
interface.addIndex('User', ['username', 'isAdmin']).success(done).error(function(err) {
console.log(err)
})
})
Helpers.async(function(done) {
interface.showIndex('User').success(function(indexes) {
var indexColumns = indexes.map(function(index) { return index.Column_name }).sort()
expect(indexColumns).toEqual(['isAdmin', 'username'])
done()
}).error(function(err) { console.log(err) })
})
Helpers.async(function(done) {
interface.removeIndex('User', ['username', 'isAdmin']).success(done).error(function(err) {
console.log(err)
})
})
Helpers.async(function(done) {
interface.showIndex('User').success(function(indexes) {
var indexColumns = indexes.map(function(index) { return index.Column_name }).sort()
expect(indexColumns).toEqual([])
done()
}).error(function(err) { console.log(err) })
})
})
})
})