Question: transaction about nano-sql HOT 4 CLOSED

There isn't documentation since the transaction system isn't very robust.

Really the biggest thing it does at the moment is suppress events to speed up the processing.

In any case, the API looks like this:

nSQL().doTransaction((db, complete) => {

    // "db" variable is very close to nSQL() but doesn't call real queries, only queues them.
    db(table).query("upsert", {...}).exec();
    db(table).query("upsert", {...}).exec();

    // call complete() when you want all the queries to execute.
    complete();
}).then(() => {
    console.log("transaction done..");
});

There are plans to support native transactions on the databases that have them like IndexedDB, LevelDB and MySQL but that hasn't been put in place yet.

from nano-sql.

Ok, thanks for the info.
Does this mean it does not roll back on errors ?

from nano-sql.

That's right, the transaction system is very limited at the moment.

from nano-sql.

ok, thx for the quick response

from nano-sql.