for example, I use the
provided by the egg-mysql framework. const results = await this.app.mysql.select("posts", { // post
where: { status: "draft", author: ["author1", "author2"] }, // WHERE
columns: ["author", "title"], //
orders: [["created_at","desc"], ["id","desc"]], //
limit: 10, //
offset: 0, //
});
how can I see the native sql statement executed by this encapsulated statement?
looked at the document and did not find this feature. Can you change the way to deal with it and use mysql log to debug it?
show variables like 'general_log'
set GLOBAL general_log='ON';
SET GLOBAL general_log_file = '/tmp/mysql.log'turn it off when you are not using it, otherwise it will take up a lot of disk space.
the switch can be set directly in the configuration file
config.mysql = {
//
client: {
// host
host: 'x x x x',
//
port: '3306',
//
user: 'x x x x',
//
password: 'x x x x',
//
database: 'x x x',
debug: false //sql
},
// app
app: true,
// agent
agent: false,
}what's the effect of the following?
, you can refer to this article:
Egg, output SQL statement logs?
Previous: Which chart plug-in is this picture from? I looked for several of them, but I couldn't find them.
I use eggjs to try to connect to kafka, so that topic corresponds to the file name under app kafka, and finally executes all the methods under the file name. If I want to deal with the business in a separate directory under the app directory, at first I...
problem description upload excel files at the front end, and receive and process the files at the back end related codes Please paste the code text below (do not replace the code with pictures) async importMember() { const stream = ...
when using the curl that comes with egg, it will report an error intermittently. Why? at errnoException (dns.js:50:10) at GetAddrInfoReqWrap.onlookup [as oncomplete] (dns.js:92:26) code: "ENOTFOUND" errno: "ENOTFOUND" syscall: "...
the front-end page requests the api interface across domains, resulting in the loss of cookies how to solve it? ...
problem description for node applications built with egg, Node serves as an intermediate server, providing server rendering and requesting data from the server. After deployment to the server, memory growth occurs continuously, which is suspected to b...
how Egg supports cross-domain requests for a single interface, but not all interfaces of the service can be cross-domain requests ~ tried the following method: async XXX () { const { ctx } = this; ctx.set( Access-Control-Allow-Origin , * ...
I write authentication interface in middleware authenticate.js module.exports = options => { return async function auth(ctx, next) { console.log( 99999999999999999 ) let { app } = this const { redis } = app; let...
1.publicconfig.default.js question: why http: localhost:9999 cannot directly access the front-end interface, and why I cannot find the http: localhost:9999 device_monitor path at the address. ...