README
![](https://cdn2.vectorstock.com/i/1000x1000/78/46/blue-database-icon-circle-frame-white-background-v-vector-20757846.jpg)
db-viewer
db-viewer is a package of modules. Its main objective is to easily configure and use different databases.
it also includes:
- - generate credentials using the command line.
Table of contents
Install
Install with npm:npm install db-avatar-init
Introduction
db-viewer is a package of modules. Its main objective is to easily configure and use different databases.
Examples
Usage
'use strict'
const DBViewer = require('db-avatar-init')
const options = {
dbId: 000000,
viewName: 'xxxxx.sql',
user: 'xxxxx',
password: 'xxxx'
};
DBViewer.executeView(options, (error, data) => {
if(error) {
console.log(error.message)
} else {
console.log(data)
}
})
Add: in your package.json
"scripts": {
"init-db": "init-db",
"init-api": "init-api",
"server": "node ./.apiserver/index.js"
},
Execute: Create api folder to root path
npm run init-db
Start: Start server REST API
- default port 3200
- test: http://localhost:3000/
npm run server
Configuration
Environment Variables: Environment Variables API configuration
Environment variable for Authentication
- USER_TEMP_API={{username to login}}
- PASS_TEMP_API={{username passwordto login}}
- SECRET_PASS_API={{secreat to create token}}
Environment variable app
- NODE_API_DB_PORT={{application port}}
Test
Test Api rest using command lineExecute: to call api rest
npm run init-api
Do you want to login? :: [Y, N] :
Enter user body request: {"logonId": "XXXXXXX", "logonPassword": "XXXXXXXXX"}
----------------------------------------------------
status 200
What do you want to do? [LIST, INSERT]
list
----------------------------------------------------------------------------------
[
{
id: 1580319420028,
type: 'MARIADB',
connection: {
id: 12111121,
database: 'xxxxxxx',
hostname: 'xxxx',
port: 'xxxxxx',
user: 'xxxxxx',
password: ''
},
views: [ [Object] ]
}
]
insert
----------------------------------------------------------------------------------
Enter new DB in json format:
----------------------------------------------------
{ "id": 111111, "type": "xxxx", "connection": { "id": 111111,"database": "xxxx", "hostname": "xxxxxx", "port": "xxxx", "user": "xxxx" }, "views": [{ "name": "xxx.sql", "path": "views/mariadb/xxx.sql", "query": "SELECT * FROM xxxxxxx;"}]}
status response: 200
Help
Note: Not all options are currently supported.