Sqlie
简单的SQL语句构建工具。 A simple SQL query builder.
内置简单模型,支持MySQL的联合主键。
Install
$ npm install sqlie --save
API
- ModelBuilder 构建模型
- createModel 构建模型
- setQueryHandler 设置SQL语句执行函数
- execute 执行SQL语句
- DeleteBuilder 构建删除语句
- InsertBuilder 构建插入数据语句
- SelectBuilder 构建查询语句
- JoinBuilder 构建JOIN表语句
- JoinSelectBuilder 构建JOIN查询语句
- UpdateBuilder 构建更新语句
Examples
SELECT
-
A base SELECT:
const SelectBuilder = ;const builder =;builder;// => SELECT `name`, `age`, `address` FROM `users` WHERE `name` = 'Swat' AND `age` = 22 -
SELECT with a simple JOIN:
const SelectBuilder = ;const builder =// alias 'u' for table 'users'// optional with select all;builder;// => SELECT `u`.*, `h`.`hobby`, `c`.favorite FROM `users`// JOIN `hobbies` ON `h`.`id` = `u`.`id`// JOIN `colors` ON `c`.`user_id` = `u`.`id`// WHERE `u`.`name` = 'Jon Snow' AND `u`.`age` = 22 -
INSERT
const InsertBuilder = ;const builder =;builder;// => INSERT INTO `users` (`name`, `age`, `gender`) VALUES ('Super Girl', 18, 'female') -
UPDATE
const UpdateBuilder = ;const builder =;builder;// => UPDATE `users` SET `age` = 22 WHERE `name` = 'Super Girl' -
设置SQL执行函数
const createConnection =const setQueryHandler execute =const connection = ;// 设置 MySQL 语句执行函数;// 下面可以调用 execute 函数执行 SQL 语句了 -
模型
const createModel = ;const user = ;// 联合主键 'gid'、'uid'const msg = ;
TODO
- 完善测试用例
- 编写开发文档
Licence
MIT © Frge frge@mail.com