如何在 sequelize 连接对象中设置应用程序名称? [英] How to set application name in sequelize connection object?
问题描述
总结:
我想在初始化一个新的sequalize对象时更改connection string
的application name
.基于
如何正确设置应用程序名称
?
你必须在选项对象中设置appName,这样语法才是正确的
let conn = new Sequelize(this.models.sequelize.config.database, this.models.sequelize.config.username,this.models.sequelize.config.password,{主机:this.models.sequelize.config.host,方言:this.models.sequelize.getDialect(),方言选项:{选项: {appName: "userid=-2@gid=" + gid}}});
Summary:
I want to change the application name
of the connection string
when initialize a new sequalize object. based on this stackoverflow question, I set the appName of dialectOptions as follows:
let conn = new Sequelize(this.models.sequelize.config.database, this.models.sequelize.config.username,
this.models.sequelize.config.password, {
host: this.models.sequelize.config.host,
dialect: this.models.sequelize.getDialect(),
dialectOptions: {
appName: "userid=-2@gid=" + gid
}
});
Question:
When I execute a transaction like the following code, the application name
does not pass to the SQL server. When I monitor the execution of SQL queries, the following picture shows that Tedious
was sent to the application name.
transaction code:
await conn.transaction(async t => {
for(let i in this.collect){
let queryBuilder = this.collect[i];
let options = {replacements: queryBuilder.replacement, transaction: t};
if(queryBuilder.type === 'insert'){
options.type = conn.QueryTypes.INSERT;
}
let row = await conn.query(queryBuilder.query + ';select @@IDENTITY as id', options);
progressBar.update(parseInt(i) + 1);
}
and the SQL Profiler picture is:
How can I set the Application Name
properly?
you must set appName in options object so correct syntax is
let conn = new Sequelize(this.models.sequelize.config.database, this.models.sequelize.config.username,
this.models.sequelize.config.password, {
host: this.models.sequelize.config.host,
dialect: this.models.sequelize.getDialect(),
dialectOptions: {
options: {
appName: "userid=-2@gid=" + gid
}
}
});
这篇关于如何在 sequelize 连接对象中设置应用程序名称?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!