wise-paas-datahub-dbmanager

wise-paas-datahub-dbmanager is a utility of WISE-PaaS/DataHub for database management.

Installation

npm install wise-paas-datahub-dbmanager

$3

``js
const DBManager = require('wise-paas-datahub-dbmanager');
let conf = {
hostname: '127.0.0.1',
port: 5432,
username: 'admin',
password: '1234',
database: 'postgres'
};
DBManager.init(conf);

`

API

$3

- init(postgresConf)
- conn() get sequelize
- NodeDao
- DeviceDao
- TagDao
- UserDao

$3

- getNodeList
- getNode(nodeId)
- insertNode(nodeObj, transaction)
- updateNode(nodeObj, nodeId, transaction)
- deleteNode(nodeId, transaction)

$3

- getDevice(nodeId, deviceId)
- getDeviceListByNodeId(nodeId)
- insertDevice(deviceObj, transaction)
- updateDevice(deviceObj, nodeId, deviceId, transaction)
- deleteDevice(nodeId, deviceId, transaction)
- deleteDeviceListByNodeId(nodeId, transaction)

$3

- getTag(nodeId, deviceId, tagName)
- getTagListByNodeId(nodeId)
- getTagListBydeviceId(nodeId, deviceId)
- getAnalogTag(nodeId, deviceId, tagName)
- getDiscreteTag(nodeId, deviceId, tagName)
- getTextTag(nodeId, deviceId, tagName)
- getAlarmAnalogTag(nodeId, deviceId, tagName)
- getAlarmDiscreteTag(nodeId, deviceId, tagName)
- getWholeTagListByNodeId(nodeId)
- getWholeTagListByDeviceId(nodeId, deviceId)
- insertTag(tagObj, transaction)
- insertAnalogTag(tagObj, transaction)
- insertDiscreteTag(tagObj, transaction)
- insertTextTag(tagObj, transaction)
- insertAlarmAnalogTag(tagObj, transaction)
- insertAlarmDiscreteTag(tagObj, transaction)
- updateTag(tagObj, nodeId, deviceId, tagName, transaction)
- updateAnalogTag(tagObj, nodeId, deviceId, tagName, transaction)
- updateDiscreteTag(tagObj, nodeId, deviceId, tagName, transaction)
- updateTextTag(tagObj, nodeId, deviceId, tagName, transaction)
- updateAlarmAnalogTag(tagObj, nodeId, deviceId, tagName, transaction)
- updateAlarmDiscreteTag(tagObj, nodeId, deviceId, tagName, transaction)
- deleteTagListByNodeId(nodeId, transaction)
- deleteTagListByDeviceId(nodeId, deviceId, transaction)
- deleteTag(nodeId, deviceId, tagName, transaction)
- deleteAlarmTag(nodeId, deviceId, tagName, type, transaction)

$3

- getUserList()
- getUserById(userId)
- getUserByName(userName)
- getUserScopeById(userId)
- insertUser(userObj, trans)
- insertUserScopeById(userId, scopeList, trans)
- updateUserByName(userName, userObj, trans)
- updateUserScopeByName(userName, scopeList, trans)
- updateUserScopeById(userId, scopeList, trans)
- deleteUserById(userId, trans)
- deleteUserScope(userId, trans)

$3

- insertRole(roleObj, trans)
- insertRoleScope(roleId, scopeList, trans)
- updateRole(roleId, roleObj, trans)
- updateRoleScope(roleId, scopeList, trans)
- deleteRole(roleId, trans)
- deleteRoleScope(roleId, trans)

Example

$3

`js
const DBManager = require('wise-paas-datahub-dbmanager');
let conf = {
hostname: '127.0.0.1',
port: 5432,
username: 'admin',
password: '1234',
database: 'postgres'
};
DBManager.init(conf);
var nodeDao = DBManager.NodeDao;
nodeDao.getNodeList().then((result) => {
console.log(result);
}).catch((error) => {
console.error(error);
});

``