squl v1.0.0

squl

A collection of SQL utility functions.

setup

npm

npm i squl

es6

import squl from 'squl';

node

let squl = require('squl');

browser

<script src="https://unpkg.com/squl"></script>

The module is globally available as squl.

members

methods

.escape(value)

Escapes a value for safely use in a query.

let escapedUndefined = squl.escape(undefined);
// => 'DEFAULT'
let escapedNull = squl.escape(null);
// => 'NULL'
let escapedBoolean = squl.escape(true);
// => '1'
let escapedInteger = squl.escape(4);
// => '4'
let escapedFloat = squl.escape(0.73);
// => '0.73'
let escapedString = squl.escape('DELETE FROM user');
// => '0x44454c4554452046524f4d2075736572'
let escapedArray = squl.escape(['Eric', 'Lisa', 'Carl']);
// => '0x45726963, 0x4c697361, 0x4361726c'
let escapedBuffer = squl.escape(Buffer.from([1, 2, 3]));
// => '0x010203'

.buildList(array)

Builds a list.

let string = squl.buildList(['a', 'b', 'c']);
// => 'a, b, c'