Magic api改json格式（Magic-API数据库新增操作）

1. id非自增表结构 CREATE TABLE `test_idms` ( `id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, `name` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ; 2. id自增表结构 CREATE TABLE `test_idms_sub` ( `id` int NOT NULL AUTO_INCREMENT, `sub_name` int DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ;

import log; //1.1 body = { "sub_name":"1.1测试自增insert" } var id = db.table("test_idms_sub").insert(body); log.info("id1.1={}",id) //id1.1=19 //1.2 id = db.insert("insert into test_idms_sub(sub_name) values('1.2测试自增insert SQL')"); log.info("id1.2={}",id) //1.3 body = { "sub_name":"1.3测试自增Save插入" } id = db.table('test_idms_sub').primary('id').save(body); log.info("id1.3={}",id) //1.4 body = { "sub_name":"1.4测试" } id = db.table("test_idms_sub").primary("id").insert(body); log.info("id1.4={}",id)

总结：返回值是id；一般采用1.1的方式操作

//2.1 body = { "id":uuid(), "name":"2.1测试非自增Insert" } id = db.table("test_idms").insert(body); log.info("id2.1={}",id) //2.2 body = { "name":"2.2测试非自增Save/Insert" } id = db.table("test_idms").primary("id",uuid()).save(body); log.info("id2.2={}",id) //2.3 id = db.table("test_idms").primary("id",uuid()).insert(body); log.info("id2.3={}",id) //2.4 id = db.insert("insert into test_idms(id,name) values('" uuid() "','2.4测试非自增Insert SQL')"); log.info("id2.4={}",id)

总结：返回值null,获取不到id；一般采用2.1的方式操作

body=[ { "id":uuid(), "name":"3.1批量插入" }, { "id":uuid(), "name":"3.2批量插入" } ] id = db.table("test_idms").batchInsert(body); //返回的是插入的记录数 log.info("id3={}",id) return id

Magic-Api对于数据库新增操作，非常简单，前端主要组装body结构提交即可，后端只需要几行代码解决。