QueryBuilder

Installation

1npm install nodejs-mysql-querybuilder --save

Documentation

Initialisation

1const QueryBuilder = require('nodejs-mysql-querybuilder');
2
3const db = new QueryBuilder({
4	host: 'localhost',
5	user: 'user',
6	password: 'password',
7	database: 'database'
8});
9
10db.setTable('table');
11db.connect();

Select

The select method take one string parameter

1db.setTable('users');
2db.select('username, password')
3	.where('id', 12)
4	.and('mail', 'test@test.com');
5db.execute();
6const res = db.fetch();

Insert

The select method take an object as parameter

1db.setTable('users');
2db.insert({
3	username: 'johndoe',
4	password: 'foobar',
5	mail: 'johndoe@test.com'
6});
7
8db.execute();

Update

The Update method take an object as parameter and need a where filter

1db.setTable('users');
2db.update({
3	username: 'johndoe',
4	password: 'foobar',
5	mail: 'johndoe@test.com'
6});
7
8db.where('id', 12);
9db.execute();

Delete

The Delete method take two parameters

1db.setTable('users');
2db.delete('id', 12);
3db.execute();

Filters

Where

where filter is unique, you need to use and if you need another filter

1db.setTable('users');
2db.select('username, password').where('id', 12).execute();
3let res = db.fetchAll();

And

1db.setTable('users');
2db.select('username, password').where('id', 12).and('mail', 'test@test.com').execute();
3let res = db.fetchAll();

Or

1db.setTable('users');
2db.select().where('id', 12).or('mail', 'test@test.com').execute();
3let res = db.fetchAll();

Join

1db.setTable('users');
2db.select('users.username, messages.message')
3	.join('INNER', 'messages')
4	.on('messages.iduser', 'users.id');