travelsoft-util v1.2.0

Install

$ npm install travelsoft-util

Usage

const travelUtil = require("travelsoft-util");

console.log(travel.response.success("Succesfull Request", "Yay"));
// {"respStatus":true,"data":"Succesfull Request","message":"Yay"}

const express = require("express");
const app = express();
const travelUtil = require("travelsoft-util");

app.get("/cats", (req, res) => {
  res.status(200).json(["Zoe", "Kate"]);
});

app.get("/dogs", (req, res) => {
  res.status(200).json(["Max", "Ralf"]);
});

app.use("/", (req, res) => {
  res.status(200).json(travelUtil.listEndpoints(app));
});

app.listen(3001, () => {
  console.log("listening on *:3000");
});

/*
GET http://localhost:3000 will return:
[
  { path: "/cats", methods: ["GET"] },
  { path: "/dogs", methods: ["GET"] },
]*/

let SQLquery = new travelUtil.queryBuilder("procName");
SQLquery.addParameter("param1", "VARCHAR", "value1");
SQLquery.addParameter("param2", "Integer", 2);

console.log(SQLquery.getQuery());

/*
EXEC procName
@param1='value1',
@param2=2
*/

let travelUtil = require("travelsoft-util");

let vars = await travelUtil.getProcessVariables(
  global.iBusCon,
  "market_hnd",
  false
);

cosole.log(vars);

/*
[
    {
        "order": 1,
        "name": "action",
        "type": "NVARCHAR",
        "length": 8000
    },
    {
        "order": 2,
        "name": "market_id",
        "type": "SMALLINT",
        "length": 2
    },
    {
        "order": 3,
        "name": "name",
        "type": "NVARCHAR",
        "length": 8000
    },
    {
        "order": 4,
        "name": "descr",
        "type": "NVARCHAR",
        "length": 8000
    },
    {
        "order": 5,
        "name": "cnt_code",
        "type": "SMALLINT",
        "length": 2
    },
    {
        "order": 6,
        "name": "market_ids",
        "type": "NVARCHAR",
        "length": 8000
    }
]
*/

let vv = travelUtil.variableValidator(vars, skip);

The Query Builder Class

You may utilize the Query Builder Class. It can be used as follows:

let qb = new QueryBuilder("testProc");
qb.addParameter("name", global.types.Date, "value");
qb.addParameter("name2", global.types.Int, "value2");

let query = qb.getQuery();
console.log(query);

Note: The content of the type variable determines if the value will be sent as a string or not in the query

The above code will produce the following string:

EXEC testProc
@name='val',
@name2=val2

Note: The @ symbol must not be added in the addParameter method