{
"create_time": "2023-08-21T08:27:50.146Z",
"update_time": "2023-08-24T07:54:34.000Z",
"id": 1,
"name": "部门 1",
"code": "1111",
"down_dep": [
{
"create_time": "2023-08-21T08:27:50.146Z",
"update_time": "2023-08-24T07:55:25.000Z",
"id": 22,
"name": "部门 2",
"code": "100"
}
],
"up_dep": null
},
这种接口的数据怎么修改?
还有一个问题就是 DTO 中没有 create_time ,update_time 两个字段,修改时传入就会报错。
at Query.onResult (C:\pm-server\src\driver\mysql\MysqlQueryRunner.ts:222:33)
at Query.execute (C:\pm-server\node_modules\mysql2\lib\commands\command.js:36:14)
at PoolConnection.handlePacket (C:\pm-server\node_modules\mysql2\lib\connection.js:478:34)
at PacketParser.onPacket (C:\pm-server\node_modules\mysql2\lib\connection.js:97:12)
at PacketParser.executeStart (C:\pm-server\node_modules\mysql2\lib\packet_parser.js:75:16)
at Socket. (C:\pm-server\node_modules\mysql2\lib\connection.js:104:25)
at Socket.emit (node:events:513:28)
at addChunk (node:internal/streams/readable:324:12)
at readableAddChunk (node:internal/streams/readable:297:9)
at Socket.Readable.push (node:internal/streams/readable:234:10) {
query: 'INSERT INTO `dept`(`create_time`, `update_time`, `id`, `name`, `code`, `upDepId`) VALUES (DEFAULT, DEFAULT, DEFAULT, ?, ?, DEFAULT)',
parameters: [ '456456', '1111' ],
driverError: Error: Duplicate entry '456456' for key 'IDX_5eb4a4c9f25934f105299edffd'
at Packet.asError (C:\pm-server\node_modules\mysql2\lib\packets\packet.js:728:17)
at Query.execute (C:\pm-server\node_modules\mysql2\lib\commands\command.js:29:26)
at PoolConnection.handlePacket (C:\pm-server\node_modules\mysql2\lib\connection.js:478:34)
at PacketParser.onPacket (C:\pm-server\node_modules\mysql2\lib\connection.js:97:12)
at PacketParser.executeStart (C:\pm-server\node_modules\mysql2\lib\packet_parser.js:75:16)
at Socket. (C:\pm-server\node_modules\mysql2\lib\connection.js:104:25)
at Socket.emit (node:events:513:28)
at addChunk (node:internal/streams/readable:324:12)
at readableAddChunk (node:internal/streams/readable:297:9)
at Socket.Readable.push (node:internal/streams/readable:234:10) {
code: 'ER_DUP_ENTRY',
errno: 1062,
sqlState: '23000',
sqlMessage: "Duplicate entry '456456' for key 'IDX_5eb4a4c9f25934f105299edffd'",
sql: "INSERT INTO `dept`(`create_time`, `update_time`, `id`, `name`, `code`, `upDepId`) VALUES (DEFAULT, DEFAULT, DEFAULT, '456456', '1111', DEFAULT)"
},
code: 'ER_DUP_ENTRY',
errno: 1062,
sqlState: '23000',
sqlMessage: "Duplicate entry '456456' for key 'IDX_5eb4a4c9f25934f105299edffd'",
sql: "INSERT INTO `dept`(`create_time`, `update_time`, `id`, `name`, `code`, `upDepId`) VALUES (DEFAULT, DEFAULT, DEFAULT, '456456', '1111', DEFAULT)"
}```
值重复异常如何处理?自己写正则吗?