0.0.9 • Published 7 years ago
one-data-selected v0.0.9
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);