MySQL query builder


Keywords
mysql, query, builder, orm
License
MIT
Install
npm install mysql-qb@0.6.7

Documentation

MySQL Query builder

Build Status npm version codecov

Designed to make SQL-queries easier to use. With this builder you don't have to write raw-queries. In this version you can build simple SQL-queries: SELECT (with joins), CREATE, UPDATE, DELETE.

I'm using this builder for my projects so it updates few times a week. It is not stable for now and very young. v1.0 release is planned for September 1st.

Contents

Changelog

Unreleased (roadmap)

  • INSERT ... SELECT
  • 0.7.3 - Added UNION, LIMIT by default is empty array, Fixed tests
  • 0.7.2 - Fixes and new features in where. Updated MySQL adapter
  • Details

Usage example

More detailed usage:

As builder

var conn = require('mysql');
conn.connect();

var qb = require('mysql-qb');

var SQL = qb.select('id, name')
            .from('my_table')
            .where('id', 5)
            .build();
conn.query(SQL, function(error, rows){
  // ... Data processing
});

As builder and executor

Passing db config

You can pass config in nodejs mysql format: More info on mysql package page. Query builder will create new connection and execute query.

var config = {
  host: '127.0.0.1',
  user: 'root',
  password: 'mySecurePassword123',
  database: 'MyDB'
};

var QueryBuilder = require('mysql-qb');
var mqb = new QueryBuilder(config);

// Query builder unlike the mysql module returns Promise. Not a callback
var query = mqb.select('id, name')
            .from('my_table')
            .where('id', 5)
            .exec();

query.then( result => {
  console.log('DB result: ', result);
}).catch(error => {
  console.log('DB error: ', error);
})

Passing db connection

You can pass to constructor mysql module connection object instead of config. If connection state == 'disconnected' builder will try to get config from connection object and reconnect automatically.

var config = {
  host: '127.0.0.1',
  user: 'root',
  password: 'mySecurePassword123',
  database: 'MyDB'
};
var mysql = require('mysql');
var connection = mysql.createConnection(config);
connection.connect();

var QueryBuilder = require('mysql-qb');
var mqb = new QueryBuilder(connection); // Passing connection.

// Query builder unlike the mysql module returns Promise. Not a callback
var query = mqb.select('id, name')
            .from('my_table')
            .where('id', 5)
            .exec();

query.then( result => {
  console.log('DB result: ', result);
}).catch(error => {
  console.log('DB error: ', error);
})

Commands

Order of method calls in pipeline doesn't matter. They all return this so you can use them UNTIL build() method is called. After that query is immutable.

Method build() returns a string and pushes last query in queries array, so you can always get it by lastQuery() call.

All methods are described in the Methods API docs.

Installation

npm install --save mysql-qb

Tests

To run tests — where they are belong (tests/unit folder).