mymysql
v0.1.1
Published
My opinionated wrapper around MySQL client API.
Downloads
7
Readme
mymysql
Opinionated wrapper around MySQL client API.
API
"Promises" means "returns promise".
query(sql, paramsArray)
Promises array of results.
db.query('select * from products where name = ?', ['beer']).then(console.log);
querySingle(sql, paramsArray)
Promises first row of results.
insert(tableName, record)
Promises identifier of record that is being inserted.
db.insert('products', { name: 'beer' }).then(console.log);
update(tableName, record)
Promises identifier of record that is being updated. Record must have identifier value.
db.update('products', { id: 20, name: 'fish' }).then(console.log);
remove(tableName, id)
Promises removal of record with given identifier from specified table.
db.remove('products', 20).then(function () {
console.log('Product 20 was removed');
});
find(tableName, id)
Promises record with given identifier taken from specified table.
License
BSD