-
Notifications
You must be signed in to change notification settings - Fork 10
/
AzureMySqlAction.ng.test.ts
95 lines (80 loc) · 3.35 KB
/
AzureMySqlAction.ng.test.ts
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
import * as exec from '@actions/exec';
import AzureMySqlActionHelper from '../src/AzureMySqlActionHelper';
import MySqlConnectionStringBuilder from '../src/MySqlConnectionStringBuilder';
import AzureMySqlAction, { IActionInputs } from '../src/AzureMySqlAction';
describe('AzureMySqlAction.ng tests', () => {
it('executes sql file on target database', async () => {
let inputs = getInputs();
let action = new AzureMySqlAction(inputs);
let getMySqlClientPathSpy = jest.spyOn(AzureMySqlActionHelper, 'getMySqlClientPath').mockResolvedValue('mysql.exe');
let execSpy = jest.spyOn(exec, 'exec').mockResolvedValue(0);
await action.execute();
expect(getMySqlClientPathSpy).toHaveBeenCalledTimes(1);
expect(execSpy).toHaveBeenCalledTimes(1);
expect(execSpy).toHaveBeenCalledWith(`"mysql.exe" -t 10`,
[
"-h", "testmysqlserver.mysql.database.azure.com",
"-u", "testuser@testmysqlserver",
"-e", "source ./testsqlfile.sql",
"-D", "testdb"
], {
env: {
"MYSQL_PWD": "testpassword"
}
})
})
it('executes sql file on target server', async () => {
let inputsNoDB = getInputsNoDatabase();
let action = new AzureMySqlAction(inputsNoDB);
let getMySqlClientPathSpy = jest.spyOn(AzureMySqlActionHelper, 'getMySqlClientPath').mockResolvedValue('mysql.exe');
let execSpy = jest.spyOn(exec, 'exec').mockResolvedValue(0);
await action.execute();
expect(getMySqlClientPathSpy).toHaveBeenCalledTimes(1);
expect(execSpy).toHaveBeenCalledTimes(1);
expect(execSpy).toHaveBeenCalledWith(`"mysql.exe" -t 10`,
[
"-h", "testmysqlserver.mysql.database.azure.com",
"-u", "testuser@testmysqlserver",
"-e", "source ./testsqlfile.sql"
], {
env: {
"MYSQL_PWD": "testpassword"
}
})
})
it('throws if mysql client fails to execute', async () => {
let inputs = getInputs();
let action = new AzureMySqlAction(inputs);
let getMySqlClientPathSpy = jest.spyOn(AzureMySqlActionHelper, 'getMySqlClientPath').mockResolvedValue('mysql.exe');
let execSpy = jest.spyOn(exec, 'exec').mockRejectedValue(1);
expect.assertions(3);
await expect(action.execute()).rejects.toEqual(1);
expect(getMySqlClientPathSpy).toHaveBeenCalledTimes(1);
expect(execSpy).toHaveBeenCalledTimes(1);
})
})
function getInputs() {
return {
serverName: 'testmysqlserver.mysql.database.azure.com',
connectionString: {
server: 'testmysqlserver.mysql.database.azure.com',
userId: 'testuser@testmysqlserver',
password: 'testpassword',
database: 'testdb'
},
sqlFile: './testsqlfile.sql',
additionalArguments: '-t 10'
} as IActionInputs;
}
function getInputsNoDatabase() {
return {
serverName: 'testmysqlserver.mysql.database.azure.com',
connectionString: {
server: 'testmysqlserver.mysql.database.azure.com',
userId: 'testuser@testmysqlserver',
password: 'testpassword'
},
sqlFile: './testsqlfile.sql',
additionalArguments: '-t 10'
} as IActionInputs;
}