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 = const options = dbId: 000000 viewName: 'xxxxx.sql' user: 'xxxxx' password: 'xxxx'; DBViewer
Add: in your package.json
"scripts": ,
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----------------------------------------------------------------------------------[ ] insert---------------------------------------------------------------------------------- Enter new DB in json format: ----------------------------------------------------
Help
Note: Not all options are currently supported.