Sql-tools NPM | npm.io

sql-tools

olap for sql non-olap engines / and other tools

language: English also available in:

Install

$ npm install sql-tools

Main goal

Transfor a SQL sentence in a SQL with totals.

Definitions

Uses a list of field definition with the form:

attribute	mandatory	use
name	yes	name of the field in the database
place	yes	'data' if must be added, 'left' or 'top' if it must apear in the GROUP BY clausule
aggLabel	for pivot	text to insert in the added rows
aggExp	no	the expression when is different to SUM(x)

Example

var olap = require('sql-tools').olap;

var varsDef=[
  {name: "zone", place:"left", aggLabel:"=SUM="}, 
  {name: "kind", place:"left"},
  {name: "sales", place:"data"},
  {name: "calif", place:"data", aggExp:"min(calif)"}
];

var sql_total=olap.cube("select * from sales", 'zone', varsDef);

console.log(sql_total);
/*
WITH "olap cube" AS (
 select * from sales
) SELECT * FROM "olap cube"
UNION SELECT '=SUM=', kind, SUM(sales), min(calif)
  FROM "olap cube"
  GROUP BY kind
*/