NodeJS MySql 查询工具 非ORM

Why make this

Sometimes, for some small projects, we do not need to synchronize the table by model setting, just add, delete, modify and query. We do not need to use the ORM framework, so we get this library.

Installation

npm i easier_query

Usage

Initialization

const EasyQuery = require('easy_query')
const myQuery = new EasyQuery({
    host: "127.0.0.1",      // the mysql host
    user: "root",           // the mysql user
    port: "3306",           // the mysql server port
    database: "test",       // the database you will use
    password: "root",       // the password
    debug:true              // true means the built sql string will be printed in the console
})

select

const res1 = await myQuery.table('profile').field('id,name,gender,phone').where('id','<',100).order('id desc').limit(3).select()
console.log(res1)
// group select
const res2 = await myQuery.table('profile').field('gender,count(1) as cnt').group('gender').having('cnt','>',3).select()
console.log(res2)

find

const res = await myQuery.table('profile').field('id,name,gender,phone').where('id','<',100).find()
console.log(res)

update

const res = await myQuery.table('profile').where('id','<',100).save({gender:"female"})
console.log(res)

delete

const res = await myQuery.table('profile').where('id','<',100).delete()
console.log(res)    // the changedRows

insert

let data = {
    name:"lucy",
    age:"18",
    gender:"female"
}
const res = await myQuery.table('profile').insert(data)
console.log(res)    // the affectedRows

fetch

fecth() must be used before find、select、delete、save、insert

let data = {
    name:"lucy",
    age:"18",
    gender:"female"
}
const res =  myQuery.table('profile').fetch().insert(data)
console.log(res)    // return the sql string

• version 1.0.3

count

const res1 = await myQuery.table('profile').where('id','<',400).where('gender','=','女').count();
console.log(res1)

page

const res1 = await myQuery.table('profile').where('id','<',400).where('gender','=','女').page(20,3);
console.log(res1)

Changelog

• 1.0.4

add port option,and make ide hinting code

• 1.0.3

add count and page method

• 1.0.2

add group , fetch , having and have method