JSEntity
Simple SQL Generator
Installing
yarn add jsentity # npm install jsentity
How To Use
const entity = ;const sqlhelper = ; const structure = table: 't_user' pk: 'id' fields: 'id' 'name' 'age' 'info_id'; const User = entity; const structure2 = table: 't_user_info' pk: 'id' fields: 'id' 'user_id' 'address'; const UserInfo = entity; // Insert { const data = name: 'Wu' age: 18 ; const user = data; const sql = sqlhelper; console; // INSERT INTO `t_user` (`name`, `age`) VALUES (\'Wu\', 18);SELECT @@IDENTITY;}; // Update { const data = id: 1 name: 'Junjun' age: 18 ; const user = data; username = 'QSir'; userage = 19; const sql = sqlhelper; console; // UPDATE `t_user` SET `name` = \'QSir\', `age` = 19 WHERE `id` = 1;}; // Delete { const data = id: 2 name: 'Yuyu' age: 18 ; const user = data; const sql = sqlhelper; console; // DELETE FROM `t_user` WHERE `id` = 2;}; // Select { const sql1 = sqlhelper; console; // SELECT `id`, `name`, `age` FROM `t_user` WHERE `name` = \'Coral\' AND `age` IN (10, 11, 12, 13, 14, 15, 16, 17, 18) AND `age` BETWEEN 13 AND 18 AND `age` IS NOT NULL OR (`age` < 10 OR `age` < 20) AND `age` <> 100 ORDER BY `name` ASC, `age` DESC LIMIT 0, 10; const sql2 = sqlhelper; console; // SELECT `id`, `name`, `age` FROM `t_user` WHERE `id` = 1 LIMIT 0, 1; const sql3 = sqlhelper; console; // SELECT `t_user`.`id` AS 'owner_id', `t_user`.`name`, `t_user`.`age`, `t_user_info`.`address`, `t_user_info`.`address` AS 'user_address' FROM `t_user` LEFT JOIN `t_user_info` ON `t_user`.`id` = `t_user_info`.`user_id` AND `t_user`.`info_id` = `t_user_info`.`id` RIGHT JOIN `t_user_info` ON `t_user`.`id` = `t_user_info`.`user_id` WHERE `t_user`.`age` > 13 AND `t_user`.`age` < 18 ORDER BY `t_user`.`name` ASC, `t_user`.`name` ASC, `t_user`.`age` DESC, `t_user_info`.`address` ASC LIMIT 0, 10;};