sivka-db's Introduction

Nodejs clone of laravel QueryBuilder

This library is very fast and simple querybuilder for nodejs. It do not depends of database server connection timeout, and automatically reconnects when server has gone away. Realized almost all features of laravel DB and some sugar added.

Documentation is available in two languages

Getting Started

Installing

npm i sivka-db

Simple example

const config = {
    host: 'localhost',
    user: 'root',
    password: 'root',
    database: 'test',
    port: 3306 // optional, default is 3306
};

const db = require('sivka-db')(config);

(async () => {
	
	let user = await db.table('users').where('id', 1).first(); // or

	user = await db.table('users').find(1);

	let users = await db.table('users').
		where('name', '!=', 'John').orWhere('surname', 'Dou').get(); 

})();

Full documentation read here

Built With

mysqljs/mysql

License

This project is licensed under the MIT License - see the LICENSE.md file for details

sivka-db's People

Contributors

Watchers

sivka-db's Issues

count bug

count(){
    return this.aggregate( ['COUNT(*) AS num'] );
}

=====>

count(){
    return this.aggregate( this.data.fields = ['COUNT(*) AS num'] );
}

whereIn bug

/**
 * @param {string} column - column name
 * @param {Array} values - array of values
 * @returns this
 */
whereIn(column, values){
    console.log(this.wrapField(column) + " IN (" + values.join(',') + ")")
    return this.where(this.wrapField(column) + " IN ('" + values.join(',') + "')");
}

++++++++++++++++++++++++++++++++
在用 whereIn(name,['我是**人']) 时会有bug，数组里面是字符串的时候会有bug

Recommend Projects