# wise-paas-datahub-dbmanager

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

Latest version **2.2.26** (published 2022-11-30) · ISC license · 0 weekly downloads

## Install

```sh
npm install wise-paas-datahub-dbmanager
pnpm add wise-paas-datahub-dbmanager
yarn add wise-paas-datahub-dbmanager
bun add wise-paas-datahub-dbmanager
```

## Health

**Score 15/100 (F)** — status: abandoned.

Positive: no vulnerabilities.

Warnings: low downloads; no types; no esm support.

Negative: abandoned; low maintenance score.

## Facts

| | |
|---|---|
| Version | 2.2.26 |
| Published | 2022-11-30 |
| First published | 2020-02-15 |
| Weekly downloads | 0 |
| License | ISC |
| TypeScript types | none |
| Module format | CommonJS |
| Dependencies | 7 |
| Unpacked size | 251.2 KB |
| Known vulnerabilities | 0 (+11 in 4 direct dependencies) |
| Install scripts | no |
| Author | Steven Li |
| Maintainers | advwacloud |

## Links

- npm: https://www.npmjs.com/package/wise-paas-datahub-dbmanager
- npm.io page: https://npm.io/package/wise-paas-datahub-dbmanager

## Dependencies (7)

- [pg](https://npm.io/package/pg.md) 8.8.0
- [knex](https://npm.io/package/knex.md) 2.3.0
- [lodash](https://npm.io/package/lodash.md) 4.17.21
- [p-limit](https://npm.io/package/p-limit.md) 2.2.2
- [bluebird](https://npm.io/package/bluebird.md) 3.7.2
- [crypto-js](https://npm.io/package/crypto-js.md) 3.1.9-1
- [sequelize](https://npm.io/package/sequelize.md) 6.26.0

## Recent versions

- 2.2.26 (latest) — 2022-11-30
- 2.2.25 — 2022-07-28
- 2.2.24 — 2022-05-03
- 2.2.23 — 2021-09-22
- 2.2.22 — 2021-08-18
- 2.2.21 — 2021-08-17
- 2.2.20 — 2021-08-10
- 2.2.19 — 2021-08-09
- 2.2.18 — 2021-07-28
- 2.2.17 — 2021-07-28
- 2.2.16 — 2021-07-27
- 2.1.6-1 — 2021-07-16
- 2.2.15 — 2021-07-16
- 2.2.14 — 2021-07-14
- 2.2.13 — 2021-07-13
- … 34 more at https://npm.io/package/wise-paas-datahub-dbmanager/versions

## README

# 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`

### Initial

```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
<a name="DBManager"></a>
### DBManager
- `init(postgresConf)`
- `conn()` get sequelize
- `NodeDao`
- `DeviceDao`
- `TagDao`
- `UserDao`

<a name="nodeDao"></a>
### nodeDao
- `getNodeList`
- `getNode(nodeId)`
- `insertNode(nodeObj, transaction)`
- `updateNode(nodeObj, nodeId, transaction)`
- `deleteNode(nodeId, transaction)`

<a name="deviceDao"></a>
### deviceDao
- `getDevice(nodeId, deviceId)`
- `getDeviceListByNodeId(nodeId)`
- `insertDevice(deviceObj, transaction)`
- `updateDevice(deviceObj, nodeId, deviceId, transaction)`
- `deleteDevice(nodeId, deviceId, transaction)`
- `deleteDeviceListByNodeId(nodeId, transaction)`

<a name="tagDao"></a>
### tagDao
- `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)`

<a name="userDao"></a>
### userDao
- `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)`

<a name="roleDao"></a>
### roleDao
- `insertRole(roleObj, trans)`
- `insertRoleScope(roleId, scopeList, trans)`
- `updateRole(roleId, roleObj, trans)`
- `updateRoleScope(roleId, scopeList, trans)`
- `deleteRole(roleId, trans)`
- `deleteRoleScope(roleId, trans)`

## Example
### get node list
```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);
});

```

---
_Source: https://npm.io/package/wise-paas-datahub-dbmanager · Machine-readable twin of the npm.io package page. Health data is recomputed on every publish._