mymssql
Opinionated wrapper around MS SQL client API.
API
"Promises" means "returns promise".
query(sql, paramsArray)
Promises array of results.
db;
querySingle(sql, paramsArray)
Promises first row of results.
insert(tableName, record)
Promises identifier of record that is being inserted.
db;
update(tableName, record)
Promises identifier of record that is being updated. Record must have identifier value.
db;
remove(tableName, id)
Promises removal of record with given identifier from specified table.
db;
find(tableName, id)
Promises record with given identifier taken from specified table.
License
BSD