gen_sql_sentence

标题

说明

这是一个简单的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语句本身要求的前提下属于合规的输入

相关仓库

跳转到 github 或者 npm