Detect when to bind a parameter as a CLOB within formatParams() about nodejs-idb-pconnector HOT 7 CLOSED

#!js
...

else if (typeof value === 'number') { //Number
      let indicator;
      Number.isInteger(value) ? indicator = idbp.SQL_BIND_INT : indicator = idbp.SQL_BIND_NUMERIC;
      boundParams.push( [value, io, indicator] );
}

...

OR:

else if (typeof value === 'number') { //Number
      boundParams.push( [value, io, idbp[`SQL_BIND_${Number.isInteger(value) ? 'INT' : 'NUMERIC'}`] ] );
}

#!js
const {DBPool} = require('idb-pconnector');
const pool = new DBPool({url: '*LOCAL'}, {debug: true});

(async () => {
  let sql = 'call QXMLSERV.iPLUG512K(?,?,?,?)',
    xmlIn = '<xmlservice><sh>system "wrksbs"<\/sh><\/xmlservice>',
    xmlOut = {asClob: true, value: '', io: 'out'},
    params = ['*NA','*here', xmlIn, xmlOut],
    results = await pool.prepareExecute(sql, params, {io: 'in'});

  console.log(results);
})();

#!js

  setupParams(params, options) {
    let boundParams = [],
      me = this,
      {io} = options,
      parameter;

    io = io || 'both';

    for ( parameter of params  ){
      if (typeof parameter === 'object'){
        let {value, asClob = false} = parameter;

        if (typeof value === 'undefined' ){
          throw Error('The parameter object must define a value property');
        }
        // assigning the value of io from the parameter object to the io variable declared before.
        // if io from parameter object is undefined default back to value of io from before.
        ({io = io} = parameter);
        //allows customization of io for an individual parameter.
        me.formatParams(boundParams, value, {io, asClob});
      } else {
        // when just passing values but would like to overide default io (INPUT_OUTPUT)
        me.formatParams(boundParams, parameter, {io});
      }
    }
    me.log(`Size of BoundParams: ${boundParams.length} \n ${JSON.stringify(boundParams)}`);
    return boundParams;
  }

  formatParams(boundParams, value, options){
    let {io, asClob} = options;

    io = idbp[`SQL_PARAM_${io === 'both' ? 'INPUT_OUTPUT': (io.toUpperCase() + 'PUT')}`];

    if (typeof value === 'string'){ //String
      if (asClob){ //as clob
        boundParams.push([value, io, idbp.BIND_CLOB]);
      } else { // as string
        boundParams.push([value, io, idbp.BIND_STRING]);
      }
    } else if (typeof value === 'number') { //Number
      let indicator;
      Number.isInteger(value) ? indicator = idbp.SQL_BIND_INT : indicator = idbp.SQL_BIND_NUMERIC;
      boundParams.push( [value, io, idbp.BIND_INT] );
    } else if (value === null) { //Null
      boundParams.push([value, io, idbp.SQL_BIND_NULL_DATA]);
    } else if (Buffer.isBuffer(value)){ //Binary/blob
      boundParams.push([value, io, idbp.SQL_BIND_BINARY]);
    } else if (typeof value === 'boolean'){ //Boolean
      boundParams.push([value, io, idbp.SQL_BIND_BOOLEAN]);
    } else {
      me.log(`Parameter that caused error was ${JSON.stringify(value)}`);
      throw TypeError('Parameters to bind should be String, Number, null, boolean, or Buffer');
    }
  }

#!javascript
{ value: 'some string', io: 'in', asClob: true }

...
let io = parameter.io || 'both';
boundParams.push([parameter, idbp[`SQL_PARAM_${io === 'both' ? 'INPUT_OUTPUT' : (io.toUpperCase() + 'PUT')}`], bindType);

#!js

else if (typeof parameter === null) { //Null
        boundParams.push([parameter, SQL_PARAM_INPUT_OUTPUT, idbp.SQL_BIND_NULL_DATA]);
      }

#!js

else if (parameter === null) { //Null
        boundParams.push([parameter, SQL_PARAM_INPUT_OUTPUT, idbp.SQL_BIND_NULL_DATA]);
      }