MySql Generator
A Library which to generate mysql statements.
Getting started
- Make sure you have mysql-generator installed:
npm install mysql-generator
- Usage:
const sqlHelper = require('mysql-generator');
- Four Class: select, insert, update, delete
Examples
-
select
const sqlHelper = ;let selectSql = sqlHelperSelect;console;//SELECT u.name, c.name AS companyName FROM `user` AS u LEFT JOIN `company` AS c ON u.companyId = c.id WHERE u.id = 22; -
update
let updateSql = sqlHelperUpdate;console;//UPDATE `user` SET password = MD5('abcd'), name = 'kyo' WHERE id IN (1, 2, 3); -
insert
let insertSql = sqlHelperInsert;console;//INSERT INTO `user` (name, sex, age, email, password) VALUES ('kyo', 1, 20, 'some@qq.com', SHA('abcd'));insertSql = sqlHelperInsert;console;//INSERT INTO `user` (sex, age, email, password) VALUES (1, 20, 'some1@qq.com', MD5('abcd')), (0, 18, 'some2@qq.com', MD5('hjkl')); -
delete
let deleteSql = sqlHelperDelete;console;//DELETE FROM user WHERE id IN (1, 2, 3);
Testing
We prepare some test, coming soon.
Contributing
Contributors are welcome, please fork and send pull requests! If you have any ideas on how to make this project better then please submit an issue.