方法(findOne、findAll、create 等)不起作用但 sequelize.query 方法在 SQL Server 2008 数据库上工作"/>
Sequelize 模型方法(findOne、findAll、create 等)不起作用但 sequelize.query 方法在 SQL Server 2008 数据库上工作
我用 Postgres 数据库做了同样的 sequelize 方法,所有事情都工作正常。每当我连接到 SQL Server 2008 数据库并点击模型方法时,我得到了错误,我真的被卡住了
enter code here
。我做了很多研发部,找不到任何解决方案。请帮忙。
这是代码:-
const Sequelize = require('sequelize');
const sequelize = new Sequelize(
process.env.DB_DATBASE,
process.env.DB_USERNAME,
process.env.DB_PASSWORD,
{
host: process.env.DB_HOST,
dialect: 'mssql',
dialectOptions: {
options: {
encrypt: false,
enableArithAbort: false,
}
},
},);
try {
sequelize
.authenticate()
.then(async () => {
console.log('Connection has been established successfully.');
})
.catch((err) => {
console.log('Unable to connect to the database:', `enter code here`err);
});
} catch (err) {
console.log('an error occured', err);
}
const highRiskModel = sequelize.define(
'QuestionTypes',
{
QuestionTypeID: Sequelize.INTEGER,
QuestionTypeName: Sequelize.STRING
// ...modelCommonAttributes
},
{
paranoid: false,
timestamps: true,
freezeTableName: true,
schema: 'dba',
// ...modelRenameDateAttributes
},
);
console.log("-------------------", highRiskModel.findAll())
I got this error:
执行(默认):SELECT[id], [QuestionTypeID][QuestionTypeName], [createdAt], [updatedAt] FROM[QuestionTypes] AS[QuestionTypes];
node: internal / process / promises: 279
triggerUncaughtException(err, true /* fromPromise */); ^
Error
at Query.run(/var/www / html / project / db_migrate_conserve / node_modules / sequelize / lib / dialects / mssql / query.js: 107: 25)at /var/www/html / project / db_migrate_conserve / node_modules / sequelize / lib / sequelize.js: 315: 28 at processTicksAndRejections(node: internal / process / task_queues: 96: 5)at async MSSqlQueryInterface.select(/var/www / html / project / db_migrate_conserve / node_modules / sequelize / lib / dialects / abstract / query - interface.js: 407: 12)
at async Function.findAll(/var/www / html / project / db_migrate_conserve / node_modules / sequelize / lib / model.js: 1140: 21) {
name: 'SequelizeDatabaseError',
parent: AggregateError
at RequestTokenHandler.onErrorMessage(/var/www/html/project/db_mi
enter code here
grate_conserve/node_modules/tedious/lib/token/handler.js:379:30)
在 Readable.< anonymous >(/var/www/html/project/db_migrate_conserve/node_modules/tedious/lib/token/token - stream - parser.js: 26: 33)
在 Readable.emit(节点:事件:526:28)
在 Readable.emit(节点:域:475:12)
在 addChunk(节点:内部/流/可读:315:12)
在 readableAddChunk(节点:内部/流/可读:289:9)
在 Readable.push(node: internal / streams / readable: 228: 10)
在下一个(节点:内部/流/来自:98:31)
在 processTicksAndRejections(节点:内部/进程/task_queues:96:5){
sql: 'SELECT [id], [QuestionTypeID], [QuestionTypeName], [createdAt], [updatedAt] FROM [QuestionTypes] AS [QuestionTypes];',
参数:未定义
},
原文:AggregateError
在 RequestTokenHandler.onErrorMessage(/var/www/html/project/db_migrate_conserve/node_modules/tedious/lib/token/handler.js:379:30)
在 Readable.< anonymous >(/var/www/html/project/db_migrate_conserve/node_modules/tedious/lib/token/token - stream - parser.js: 26: 33)
在 Readable.emit(节点:事件:526:28)
在 Readable.emit(节点:域:475:12)
在 addChunk(节点:内部/流/可读:315:12)
在 readableAddChunk(节点:内部/流/可读:289:9)
在 Readable.push(node: internal / streams / readable: 228: 10)
在下一个(节点:内部/流/来自:98:31)
在 processTicksAndRejections(节点:内部/进程/task_queues:96:5){
sql: 'SELECT [id], [QuestionTypeID], [QuestionTypeName], [createdAt], [updatedAt] FROM [QuestionTypes] AS [QuestionTypes];',
参数:未定义
},
sql: 'SELECT [id], [QuestionTypeID], [QuestionTypeName], [createdAt], [updatedAt] FROM [QuestionTypes] AS [QuestionTypes];',
参数: { }
}
回答如下:
更多推荐
Sequelize 模型方法(findOne、findAll、create 等)不起作用但 sequelize.query 方法在 SQL Server 200
发布评论