egg2操作mysql报this.app.mysql.query is not a function

治电小白菜

发布于 2020-08-25 15:14:32

1.7K0

发布于 2020-08-25 15:14:32

文章被收录于专栏：技术综合技术综合

犯错原因，文档没看好，，，https://eggjs.org/zh-cn/basics/config.html

问题

按照官网配置mysql好后，操作数据库，报错

TIM截图20180417172710.png

问题复现

config.default.js

exports.mysql = {
  client: {
    host: 'localhost',
    port: '3306',
    user: 'root',
    password: '123456',
    database:'nodemysql'
  },
  app: true,
  agent: false,
};

service/data.js

'use strict';
const Service = require('egg').Service;
class DataService extends Service {
  async getData() {
    const result = await this.app.mysql.select('pet');
    return {result};
  }
}
module.exports = DataService;

controller/mysql.js

'use strict';
const Controller = require('egg').Controller;
class MysqlController extends Controller {
  async index() {
    let {ctx,service} = this;
    let result = await ctx.service.data.getData()；
    ctx.body=result;
  }
}
module.exports = MysqlController;

问题解决

注意文档

通过把配置放到

'use strict';
module.exports = appInfo => {
  const config = exports = {};
  // use for cookie sign key, should change to your own and keep security
  config.keys = appInfo.name + '_1523879140687_7825';
  // add your config here
  config.middleware = [];
  config.mysql = {
    client: {
      host: 'localhost',
      port: '3306',
      user: 'root',
      password: 'zzzzzzz',
      database:'nodemysql'
    },
    app: true,
    agent: false,
  }
  return config;
};

本文参与腾讯云自媒体分享计划，分享自作者个人站点/博客。

如有侵权请联系 cloudcommunity@tencent.com 删除

javascript