-
-
Notifications
You must be signed in to change notification settings - Fork 104
Expand file tree
/
Copy pathunit.database.js
More file actions
61 lines (54 loc) · 1.62 KB
/
unit.database.js
File metadata and controls
61 lines (54 loc) · 1.62 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
'use strict';
const assert = require('assert').strict;
const path = require('path');
const application = require('../lib/application.js');
application.logger = { log: console.log };
const Database = require('../lib/database.js');
assert(Database);
const Config = require('../lib/config.js');
assert(Config);
const PATH = process.cwd();
(async () => {
const configPath = path.join(PATH, 'application/config');
const config = await new Config(configPath);
const databaseConfig = config.database;
const database = new Database(databaseConfig);
const empty = 'empty';
try {
const user = { login: empty, password: empty, fullName: empty };
const result = await database.insert('SystemUser', user);
assert(result);
assert.equal(result.rowCount, 1);
} catch (err) {
console.log(err.stack);
process.exit(1);
}
try {
const fields = ['login', 'password'];
const cond = { login: empty };
const [record] = await database.select('SystemUser', fields, cond);
assert.equal(record.login, empty);
assert.equal(record.password, empty);
} catch (err) {
console.log(err.stack);
process.exit(1);
}
try {
const delta = { password: empty };
const cond = { login: empty };
const result = await database.update('SystemUser', delta, cond);
assert.equal(result.rowCount, 1);
} catch (err) {
console.log(err.stack);
process.exit(1);
}
try {
const cond = { login: empty };
const result = await database.delete('SystemUser', cond);
assert.equal(result.rowCount, 1);
} catch (err) {
console.log(err.stack);
process.exit(1);
}
database.close();
})();