Published 2020-05-11
Did you know Sequelize Logging enabled by default? That's why you are able to see your SQL query in your terminal console like below.
Executing (default): SELECT `id`, `name`, `address`, `age`, `gender` FROM `client`;
However, did you know that what you're looking is only the small subset of the logging?
You can see more logging information by spreading the parameters.
const sequelize = new Sequelize(
'database',
'username',
'password',
{
logging: (...msg) => {
console.log(msg);
},
},
);
// Sample Output of Sequelize Logging
[ SELECT `id`, `name`, `address`, `age`, `gender` FROM `client`,
{ plain: true,
raw: false,
logging: [Function: logging],
showWarnings: false,
where: ...,
originalAttributes:
[ 'id', 'age' ... ],
attributes:
[ 'id', 'name', 'age'... ],
tableNames: [ 'client' ],
type: 'SELECT',
model: client } ]
Disable logging is easy as you can just set the logging to false
like below.
const sequelize = new Sequelize(
'database',
'username',
'password',
{
logging: false,
},
);