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
var DB = require("topsin.database");
var _ = require("lodash");
var TError = require("topsin.error");
var logger = require('topsin.logger')
var moment = require('moment')
DB.addConnection({
database_type: 'mysql',
database_host: '192.168.2.22:3306',
database_name: 'topbi',
database_user: 'toplinker',
database_pwd: 'TopLinker0510'
}, 'DEMO_CONN');
try {
var result = DB.query('DEMO_CONN', function (query) {
// 测试连接
var ok = query.selectValue("SELECT 1", {});
if (query.lastError().isValid()) {
throw query.lastError().text();
}
print("ok: ", ok);
// 测试prepare
query.replaceRow({
table: 'test',
data: {
// create_time: '2019-07-16 00:09:00',
Date: '2019-07-16 00:00:00',
// RUN: '0'
},
unique_field: 'id'
});
if (query.lastError().isValid()) {
throw query.lastError().text();
}
})
} catch (e) {
print(e);
}