@simtech/vrp-tools NPM

Installation

Step 1: Install Nodejs - Install the latest stable version (at least 8.10.0) of Nodejs via nodejs.org

Step 2: Install vrp-tools - npm install vrp-tools -g

For example, create 50 orders in Logistics_Test table in 127.0.0.1 SQL server

If running via source code,

node ./bin/vrpTools.js genOrder -n 50 -d Logistics_Test -S 127.0.0.1 -U sa -P mypassword

If running directly using published vrp-tools,

vrp-tools genOrder -n 50 -d Logistics_Test -S 127.0.0.1 -U sa -P mypassword

ACTION	DESCRIPTION
genOrder	generates n number of delivery orders and inserts into SQL DB
syncCollection	syncs mongoDB collections of given server and azure cloud server

vrp-tools genOrder -n <n> -U [username] -P [password] -S [server] -d [database]

Option	Description
-U, --user	username of sql db to be connected
-n, --numOfOrders	number of orders to be generated
-P, --pass	password of sql db to be connected
-S, --server	server ip of db to be connected
-d, --database	name of sql db to be connected

vrp-tools syncCollection -U [username] -c[collection] -P [password] -S[serverport] -d [databasename] -t [clouddbname] -r [cloudservername]

Option	Description
-U, --user	username of mongodb to be connected
-c, --collection	name of collection to be synced
-P, --pass	password of mongodb to be connected
-S, --serverPort	ip and port of server to which mongo collection to be imported
-d, --database	name of mongodb to be connected
-t, --cloudDbName	name of the DB to which mongo collection to be imported
-r, --cloudServer	name of the cloud server