MariaSQL-Promise

A lightweight Promise wrapper for MariaSQL that also works with MySQL. To see the list of available options, please have a look at MariaSQL's README.

Installation

1npm install mariasql-promise

Usage

1import MariaSQL from 'mariasql-promise'
2
3const db = new MariaSQL()
4db.connect({
5  host: '127.0.0.1',
6  user: 'test',
7  password: 'test',
8  db: 'test'
9}).then(function() {
10  console.log('connected')
11
12  const selectQuery = db.query('Select 1 + 1 as result')
13    .then(function(rows) {
14      console.log('result was', rows[0].result)
15    })
16  const escapedQuery = db.query('Select * from users where id = ? LIMIT 1', [1])
17    .then(function(rows) {
18      console.log('the user was', rows.length ? 'found' : 'not found')
19    })
20  const parameterizedQuery = db.query('Select * from users where id = :id and name = :name LIMIT 1', [1, 'steel'])
21    .then(function(rows) {
22      console.log('steel was', rows.length ? 'found' : 'not found')
23    })
24  const preparedQuery = db.query(db.prepare('Select COUNT(users) as count from users as a where EXISTS(Select 1 from users where user.name = a.name AND user.id != a.id)'))
25    .then(function(rows) {
26      console.log('number of users with same name is', rows[0].count)
27    })
28
29  return Promise.all([selectQuery, escapedQuery, parameterizedQuery, preparedQuery])
30}).catch(function(e) {
31  console.log('We have a problem', e.message, e.stack)
32})

API

1export class MariaDB {
2  connect(config): Promise
3  query(query, params = null): Promise<Array<Object>>
4  prepare(query: String)
5  terminate()
6  dispose()
7}

License

This project is licensed under the terms of MIT License. See the LICENSE file for more info.