thinkjs3.0 数据库返回字段只有下划线问题，能否设置映射

[handoudou]

DESC

ENV

OS Platform: mac

Node.js Version: v14.15.5

ThinkJS Version: 3.2.10

code

// your code here

error message

// your error message here

more description

// your detail description

#529

[lizheming]

看了一下，似乎没有支持。不过我觉得你可以使用 afterSelect 和 afterFind 钩子自行实现。类似下面这样

module.exports = class extends think.Model {
  camelize(obj) {
    for(const k in obj) {
      if(!k.includes('_')) {
        continue;
      }
      const newKey = k.replace(/([-_][a-z])/ig, ($1) => {
        return $1.toUpperCase()
          .replace('_', '');
      });
      obj[newKey] = obj[k];
      delete obj[k];
    }
    return obj;
  }

  afterSelect(data) { return data.map(item => this.camelize(item)); }
  afterFind(data) { return this.camelize(data); }
}

[XiaoPuO]

看了一下，似乎没有支持。不过我觉得你可以使用 afterSelect 和 afterFind 钩子自行实现。类似下面这样

module.exports = class extends think.Model {
  camelize(obj) {
    for(const k in obj) {
      if(!k.includes('_')) {
        continue;
      }
      const newKey = k.replace(/([-_][a-z])/ig, ($1) => {
        return $1.toUpperCase()
          .replace('_', '');
      });
      obj[newKey] = obj[k];
      delete obj[k];
    }
    return obj;
  }

  afterSelect(data) { return data.map(item => this.camelize(item)); }
  afterFind(data) { return this.camelize(data); }
}

  if (!k.includes('_')) {
    continue; // 使用 continue 不然会出现null
  }