Database Access
Db Module
Powerful database connectivity for automation. SQLite, MSSQL, Oracle, PostgreSQL, MS Access
var db = Db.connect("sqlite", "Data Source=C:\\Data\\foo.db");
var products = db.query(
"SELECT id, name, price FROM Products WHERE price > @price",
{
"@price": 100,
},
);
for (var i = 0; i < products.length; i++) {
Log.info("Product: " + products[i].name);
}
db.exec("CREATE TABLE Customers (id INT, name TEXT, email TEXT)");
db.exec("INSERT INTO Customers VALUES (@id, @name, @email)", {
"@id": 1,
"@name": "John Smith",
"@email": "john@example.com",
});