one-data-selected

# OneDataSelected

Selected Multi DB Server client for Node.js

Quick Example

var selected = require("one-data-selected");
 
var dbConfig = {
    server: "127.0.0.1",
    database: "Test",
    user: "...",
    password: "...",
    pool: {
        max: 10,
        min: 0,
        idleTimeoutMillis: 30000
    }
};
 
var array = [{
        dbConfig: dbConfig,
        dbType: "mssql",
        isTransaction: false,
        key: "qKey1",
        query: "insert into [Test].[dbo].[table1] values (@val1, @val2, @val3)",
        beforeExec: function(previousResults, database) {
            database.addInputValue("val1", "NVARCHAR", "...");
            database.addInputValue("val2", "INT", 1);
            database.addInputValue("val3", "DATETIME", new Date());
        }
    },
    {
        dbConfig: dbConfig,
        dbType: "mssql",
        isTransaction: false,
        key: "qKey2",
        query: "update [Test].[dbo].[table2] set col1 = @val1 where col2 = @val2",
        beforeExec: function(previousResults, database) {
            database.addInputValue("val1", "NVARCHAR", "...");
            database.addInputValue("val2", "INT", 1);
        }
    },
    {
        dbConfig: dbConfig,
        dbType: "mssql",
        isTransaction: false,
        key: "qKey3",
        query: "delete from [Test].[dbo].[table3] where col2 = @val2",
        beforeExec: function(previousResults, database) {
            database.addInputValue("val2", "INT", 1);
        }
    }
];
 
function useResults(result) {
    console.log(results);
}
 
 
selected.execSelected(["qkey1", "qKey3"], array, useResults);