/
Gruntfile.js
125 lines (114 loc) · 2.79 KB
/
Gruntfile.js
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
119
120
121
122
123
124
125
/*
* grunt-pg-utils
* https://github.com/TopCS/grunt-pg-utils
*
* Licensed under the MIT license.
*/
'use strict';
module.exports = function(grunt) {
var defUser = 'postgres',
defPassword = 'postgres',
defHost = '127.0.0.1',
defPort = 5432;
var serverConnection = {
user: defUser,
password: defPassword,
host: defHost,
port: defPort
},
stageConnection = {
user: defUser,
password: defPassword,
database: 'grunt-teststage',
host: defHost,
port: defPort
},
developmentConnection = {
user: defUser,
password: defPassword,
database: 'grunt-testdevel',
host: defHost,
port: defPort
};
// Project configuration.
grunt.initConfig({
jshint: {
all: [
'Gruntfile.js',
'tasks/*.js'
],
options: {
jshintrc: '.jshintrc'
}
},
// Before generating any new files, remove any previously-created files.
clean: {
tests: ['tmp'],
spsql: ['spsql']
},
// Configuration to be run (and then tested).
'backup-sp': {
'backup-testdevel': {
dest: 'tmp/testdevel/',
options: {
connection: developmentConnection,
spRegex: '^(sp_|fn_).*'
}
}
},
'restore-sp': {
'test-procedures': {
src: ['test/spsql/*.sql'],
options: {
connection: developmentConnection
}
},
'restore-teststage': {
src: ['tmp/testdevel/*.sql'],
options: {
connection: stageConnection
}
}
},
dump: {
'dump-testdevel': {
dest: 'tmp/testdevel.sql',
options: {
connection: developmentConnection
}
}
},
restore: {
'restore-testdevel': {
src: 'tmp/dumpdevel.sql',
options: {
connection: serverConnection
}
}
},
'run-sql': {
'create-test-db': {
src: 'test/sqls/create-test-db.sql',
options: {
connection: serverConnection
}
},
'drop-test-db': {
src: 'test/sqls/drop-test-db.sql',
options: {
connection: serverConnection
}
}
}
});
// Actually load this plugin's task(s).
grunt.loadTasks('tasks');
// These plugins provide necessary tasks.
grunt.loadNpmTasks('grunt-contrib-jshint');
grunt.loadNpmTasks('grunt-contrib-clean');
// Whenever the 'test' task is run, first clean the 'tmp' dir, then run this
// plugin's task(s), then test the result.
grunt.registerTask('test', ['clean', 'run-sql:create-test-db', 'restore-sp:test-procedures', 'backup-sp:backup-testdevel', 'dump:dump-testdevel', 'restore-sp:restore-teststage', 'run-sql:drop-test-db']);
// By default, lint and run all tests.
grunt.registerTask('default', ['jshint', 'test']);
};