mysql-querybuilder-nodejs

mysql query bulder for nodejs

Usage/Examples

first install import package

install package

1    npm i mysql-querybuilder-nodejs

import package

1const query_builder = require('mysql-querybuilder-nodejs');
2const db = query_builder(dbname, username, password,host, port);

Select Data

Single Data (row)

1const query_builder = require('mysql-querybuilder-nodejs');
2const db = query_builder(dbname, username, password,host, port);
3db.select('column').from('tabel').row(callback, 'table if you not using from function');
4
5function callback(error, result){
6    //do something
7}

Single Data (row) async

1    const query_builder = require('mysql-querybuilder-nodejs');
2    const db = query_builder(dbname, username, password,host, port);
3    const result = await db.select('column').from('tabel').row_async('table if you not using from function');
4
5    // You can get data without await
6    const result = await db.select('column').from('tabel').row_async('table if you not using from function').then().catch();

Multiple Data

1    const query_builder = require('mysql-querybuilder-nodejs');
2    const db = query_builder(dbname, username, password,host, port);
3    db.select('column').from('tabel').results(callback, 'table if you not using from function');
4
5    function callback(error, result){
6        //do something
7    }

Multiple Data (async)

1    const query_builder = require('mysql-querybuilder-nodejs');
2    const db = query_builder(dbname, username, password,host, port);
3    const result = await db.select('column').from('tabel').results_async('table if you not using from function');
4
5    // You can get data without await
6    const result = await db.select('column').from('tabel').results_async('table if you not using from function').then().catch();

Filter Data

1    const query_builder = require('mysql-querybuilder-nodejs');
2    const db = query_builder(dbname, username, password,host, port);
3    const result = await db.select('column').from('tabel')
4        .where('column' 'value', 'operator', 'string_value | true or false, default true, use true if the value is string' )
5        .or_where('column' 'value', 'operator', 'string_value | true or false, default true, use true if the value is string' )
6        .results_async('table if you not using from function');

Join Table

1    const query_builder = require('mysql-querybuilder-nodejs');
2    const db = query_builder(dbname, username, password,host, port);
3    const result = await db.select('column').from('tabel')
4        .where('column' 'value', 'operator', 'string_value | true or false, default true, use true if the value is string' )
5        .or_where('column' 'value', 'operator', 'string_value | true or false, default true, use true if the value is string' )
6        .join('table', 'condition', 'type')
7        .results_async('table if you not using from function');
8

Grouping

1    const query_builder = require('mysql-querybuilder-nodejs');
2    const db = query_builder(dbname, username, password,host, port);
3    const result = await db.select('column').from('tabel')
4        .where('column' 'value', 'operator', 'string_value | true or false, default true, use true if the value is string' )
5        .or_where('column' 'value', 'operator', 'string_value | true or false, default true, use true if the value is string' )
6        .group_by('column')
7        .results_async('table if you not using from function');
8

Order

1    const query_builder = require('mysql-querybuilder-nodejs');
2    const db = query_builder(dbname, username, password,host, port);
3    const result = await db.select('column').from('tabel')
4        .where('column' 'value', 'operator', 'string_value | true or false, default true, use true if the value is string' )
5        .or_where('column' 'value', 'operator', 'string_value | true or false, default true, use true if the value is string' )
6        .group_by('column')
7        .order_by('column', 'order type')
8        .results_async('table if you not using from function');
9

Insert Data

1    const query_builder = require('mysql-querybuilder-nodejs');
2    const db = query_builder(dbname, username, password,host, port);
3    db.insert('table', 'inputs (object) , callback);
4
5    // you can use insert_async
6    db.insert_async('table', 'inputs (object) , callback);

Update Data

1    const query_builder = require('mysql-querybuilder-nodejs');
2    const db = query_builder(dbname, username, password,host, port);
3    db.where('id', data.id)
4        .update('table', 'inputs in object', callback);
5
6     // you can use update_async
7    db.delete_async('table', 'inputs (object)');

Delete Data

1    const query_builder = require('mysql-querybuilder-nodejs');
2    const db = query_builder(dbname, username, password,host, port);
3    db.where('id', data.id)
4    .delete('table', callback);
5    
6    // you can use delete_async
7    db.where('id', data.id)
8    .delete('table');