yorm

Releases

1.0.2, 1.0.3: Readme update

1.0.1: Major upgrade

Transaction support of mysql can be used now by just pass a connection object to saveone and savemany.
Bufferinit has to be called first now if it is the first time to call any function.
No more Bluebird dependency since it is part of node now.
Better module exports organization.
Config file name changed to config/db.js

0.1.20: Previous one

Install Locally is recommended

npm install yorm -s

Usage

Create your database configuration in db.js in your project root/config folder. There is a sample with yorm module folder.

Then create your application tables. You can also define your own structure types as well.

Below example will call parallelly saveone and savemany.

create table aa(id1 int, id2 int, val1 char(20), primary key(id1, id2)

var yorm = require('yorm')
var onerecord = {}
onerecord.id1 = '1'
onerecord.id2 = '20'
onerecord.val1 = 'Testing value'

var test = function() {
    yorm.saveone('aa', onerecord)
    var records = []
    for (var i = 0; i < 10, i++) {
      for (var j = 0; j < 3, j++ {
        onerecord = {'id1': i, 'id2':j, 'val1': 'value: ' + i + '/' + 'j'}
        records.push(onerecord)
      }
    }
    yorm.savemany('aa', records).then(function() {
      console.log('Table aa had been inserted many records.'
    }
}

#Now you have to call bufferinit for first time call. So change setTimeout(test, 1000) to below:
yorm.bufferinit().then(test)

Run the test and check table data by

select * from aa;

Your will see the value inserted. Also in the above example, savemany will assemble sql statemnets in batch in the form of insert into ... on duplicate update ... But you have to enable on duplicate update by set relevant parameter to true.

I will deliver an API document if more persons are interested in this project.