simple javascript object to sql mapper
npm install fscp-js2sqlThis is NOT an ORM, it's much simpler than that. This module just try to map attribute value to colum name and value.
It just generate sql string and is not related to any database specific dialect. We just use very basic constructs.
`` javascript
var persister = require('fscp-js2sql');
var obj = {
myString:'Hello';
myFloat:31415,
myInt:1,
myDate:new Date()
};
var sql = persister.buildInsert('myTable', obj);
`
` javascript
var persister = require('fscp-js2sql');
var obj = {
id:'ID1',
myString:'Hello';
myFloat:31415,
myInt:1,
myDate:new Date()
};
var sql = persister.buildUpdate('myTable', obj, 'id');
`
` javascript
var persister = require('fscp-js2sql');
var obj = {
id:'ID2',
myString:'Hello';
myFloat:31415,
myInt:1,
myDate:new Date()
};
var sql = persister.buildUpdate('myTable', obj, 'id', 'ID1');
``
Tests may break due to attributes ordering, have to use regexp to validate some tests results.