relmapper

Map a relational model to JSON and back.

This library is a light-weight tool, that is only concerned with converting between a hierarchical representation and a flat column-like representation of the data. The idea behind this is, that a server is essentially an adapter transforming data from a database to a web based interface such as REST over HTTP and vice versa. relmapper facilitates this transformation while not interfering with your queries. This library is for all developers that have decided on a particular relational db technology and want to leverage its full potential without being limited by the abstraction of an ORM.

Support for transforming join results into arrays is planned but not yet implemented.

Getting started

npm install relmapper --save

Convert json to a db record:

varmapper=require('relmapper').defaultMapper;varjson={myJsonProperty: 5,myNested: {jsonProperty: 'with text'}};mapper.apply(json);/*returns { my_json_property: 5, my_nested__json_property: 'with_text'} */

Convert the result from a db query to nested json from a table looking like this:

CREATE TABLE(
my_json_property: INTEGER,
my_nested__json_property: VARCHAR(512)
);

varqueryResult=query('SELECT * FROM mytable');mapper.unapply(queryResult);/*returns [{ myJsonProperty: 5, myNested: { jsonProperty: 'with text' } },...] */

API

The basic concept of this library is that of a mapper. A mapper is a plain javascript object with two methods: apply and unapply. The transformation between the hierarchical and the relation representation is performed by applying a pipeline of mappers:

json -> mapper1.apply -> mapper2.apply -> mapper3.apply -> db object
db object -> mapper3.unapply -> mapper2.unapply -> mapper1.unapply -> json

A mapper can either transform a single object or an array of objects. The module exposes the following mappers:

flatten(delimiter)

Transforms a hierarchical structure to a flat property where the path is indicated by the given delimiter.

Examples:

varrelmapper=require('relmapper');varjson={a: {b: {c: 1}}};relmapper.flatten('__').apply(json);/*returns { a__b__c: 1 } */varresult={a__b__c: 1};relmapper.flatten('__').unapply(result);/*returns { a: { b: { c: 1 }}} */

camelCase

Transforms camel case to snake case and vice versa. This is needed since most relational database systems are case insensitive.

Examples:

varrelmapper=require('relmapper');varjson={aCamelCaseProperty: 1};relmapper.camelCase.apply(json);/*returns { a_camel_case_property: 1 } */varresult={a_camel_case_property: 1};relmapper.camelCase.unapply(result);/*returns { aCamelCaseProperty: 1 } */

Mappers can be combined to form more complex mappers:

sequence(...mappers)

Creates a pipeline of mappers that are applied in sequence. The order is reversed when unapplying.

The library also publishes a defaultMapper which is defined as a sequence of flatten and camelCase:

vardefaultMapper=relmapper.sequence(relmapper.flatten('__'),relmapper.camelCase);

See the getting started section for an example of this mapper.

fromObjectMapper(mapper)

Creates a mapper that can handle both arrays and objects from a simpler mapper that only processes objects.

Changelog

0.3.0

• Reimplemented the existing functionality in typescript.
• Changed the following names due to collisions with keywords:
  • default becomes defaultMapper
  • case becomes camelCase

0.2.0

• Changed the mapper interface to also support arrays as arguments to apply and unapply.