Total.js QueryBuilder: Oracle DB

BETA: A simple QueryBuilder integrator for Oracle database.

• Documentation
• $ npm install querybuilderoracle

Initialization

• Example: oracledb://user:pass@hostname/FREEPDB1

// require('querybuilderoracle').init(name, connectionstring, pooling, [errorhandling]);
// name {String} a name of DB (default: "default")
// connectionstring {String} a connection to the PostgreSQL
// pooling {Number} max. clients (default: "0" (disabled))
// errorhandling {Function(err, cmd)}

require('querybuilderoracle').init('default', CONF.database);
// require('querybuilderpg').init('default', CONF.database, 10);

// Or
require('querybuilderoracle').init('default', { user: '', password: '', connectString: '(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=127.0.0.1)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=FREEPDB1)))' });

Usage:

DATA.find('USER').where('ID', 1234).callback(console.log);