1.0.1 • Published 8 months ago
gen_sql_sentence v1.0.1
标题
说明
这是一个简单的sql语句生成包,目前只支持select
,insert
update
delete
四种基础语句
安装与调用
安装 npm install gen-sql-sentence
调用 import gen_sql from "gen-sql-sentence"
使用示例
select
const sql_select = gen_sql({
operation: "select",
table: "userinfo",
values: ["isAdmin", "status"],
conditions: {
userid: "1",
username: "admin",
},
});
insert
const sql_insert = gen_sql({
operation: "insert",
table: "userinfo",
values: ["admin", "5"],
conditions: {},
});
update
const sql_update = gen_sql({
operation: "update",
table: "userinfo",
values: {
userid: "2",
},
conditions: {
userid: "1",
username: "admin",
},
});
delete
const sql_delete = gen_sql({
operation: "delete",
table: "userinfo",
values: [],
conditions: {
userid: "1",
username: "admin",
},
});
调用结果
sql_select = "select isAdmin, status from userinfo where userid = 1, username = admin;"
sql_insert = "insert into userinfo values (admin, 5);"
sql_update = "update userinfo set userid = 2 where userid = 1, username = admin;"
sql_delete = "delete from userinfo where userid = 1, username = admin;"
参数说明
operation
和table
参数为必要参数,可以是string
或String
类values
和conditions
是否必要可以参考对应的sql
语句本身要求values
在select
语句和insert
语句中可以是Array
或者Object
(若为Object
,value
应存放在值的位置),在update
语句中只能是Object
conditions
只能是Object
参数若不存在,即默认为undefined
,undefined
和{}
在满足对应的sql
语句本身要求的前提下属于合规的输入