0.0.5 • Published 4 years ago
pf_bsql v0.0.5
Installation
npm install pf_bsql
Usage
insert
`
const bsql = require("pf_bsql");
var query = bsql._insert("user_info").columns("email","nick","age").values("test@gmail.com","test",11).build();
var query = bsql._insert("user_info").row({"email":"test@gmail.com","nick":"test","age":11}).build();
console.log(query.sql,query.values) `
update
`
var query = bsql._update("uinfo").change("age","+",2).where("email","=","test@gmail.com").build();
console.log(query.sql,query.values);
// UPDATE uinfo
SET age
=age
+? WHERE email
=? , 2,"test@gmail.com"
`
select
`
var query = bsql._query("uinfo").select("id","age").where("id","<",3).build();
console.log(query.sql,query.values);
// SELECT id
,age
FROM uinfo
WHERE id
<? , 3
`