• Installation
  • Step 1-2: Programs Required
• Running
• Features
  • genOrder
  • syncCollection

Installation

Step 1-2: Programs Required

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

Running

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

Features

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

genOrder

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 |

syncCollection

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 |