如何修改接口响应体,将数据库返回的带ca_前缀的字段名去除前缀
问题描述
我的业务场景如下:我需要将多个属性存入数据库,在返回接口响应时,不希望直接使用与数据库存储完全一致的属性名。例如数据库中存储的字段为ca_xyz格式,现在获取响应时我只想将xyz作为字段名返回。
现有代码如下:
const addAddress = async (req, res, next) => { try{ var custid = req.params.id; const data = { ca_email: req.body.email, ca_mobile: req.body.mobile, ca_address1: req.body.address1, ca_address2: req.body.address2, ca_zone_id: req.body.zone_d, ca_city: req.body.city, ca_local: req.body.local, ca_pincode: req.body.pincode, } let results = await Address.create({data}); res.send({ status:'success', message:`Successfully added address ` }) } catch(error){ console.log(error) res.send({ status:'failed', message:"An error occurred" }) } }
实际运行问题:代码本应该遍历dataValues内部的字段,但当前获取到了customer_group对象。
解决方案
从代码逻辑和问题现象判断你使用的是Sequelize ORM,customer_group对象是模型关联配置的自动加载数据,字段名转换可通过键名前缀替换实现,修改后的代码如下:
const addAddress = async (req, res, next) => { try{ const custid = req.params.id; const data = { ca_email: req.body.email, ca_mobile: req.body.mobile, ca_address1: req.body.address1, ca_address2: req.body.address2, ca_zone_id: req.body.zone_d, ca_city: req.body.city, ca_local: req.body.local, ca_pincode: req.body.pincode, } // 创建时关闭关联自动加载,仅返回写入的字段 const results = await Address.create(data, { attributes: Object.keys(data), include: false }); // 转换为纯JS对象,剥离ORM附加属性 const rawResult = results.toJSON(); // 去掉字段的ca_前缀生成响应数据 const formattedResult = Object.fromEntries( Object.entries(rawResult).map(([key, val]) => [key.replace(/^ca_/, ''), val]) ) res.send({ status:'success', message: 'Successfully added address', data: formattedResult }) } catch(error){ console.log(error) res.send({ status:'failed', message: "An error occurred" }) } }
补充说明:如果需要彻底避免关联数据被自动加载,可以在Address模型的关联定义处添加autoLoad: false配置;如果有多处同类字段转换需求,可以将前缀替换逻辑封装为通用工具函数复用。
内容的提问来源于stack exchange,提问作者Nikeeta kurrey
相关产品推荐
相关产品推荐

