SQL Server 2008 on Node.js with Sequelize

SQL Server 2008 on Node.js with Sequelize

本文关键字：js with Sequelize Node on Server 2008 SQL      更新时间：2023-09-26

我是新来的!

我试图做一个查询与MS SQL Server2008序列化，但我得到这个错误:

未处理的拒绝SequelizeDatabaseError:无效的列名'id'。在查询。formatError (C: ' xampp '根' Lavori ' Bit_Sense ' API_BS ' node_modules ' sequelize ' lib '方言'该' query.js: 217:10)在请求。userCallback (C: ' xampp '根' Lavori ' Bit_Sense ' API_BS ' node_module年代' sequelize ' lib ' '该方言' query.js: 66:25)在请求。回调(C: ' xampp '根' Lavori ' Bit_Sense ' API_BS ' node_modules ' tedious ' lib ' request.js 30:27):在Connection.STATE.SENT_CLIENT_REQUEST.events。消息(C: ' xampp '根' Lavo国际扶轮' Bit_Sense ' API_BS ' node_modules '乏味' lib ' connection.js: 283:29)在连接。dispatchEvent (C: ' xampp '根' Lavori ' Bit_Sense ' API_BS ' node_modules '乏味' lib ' connection.js 752:59):在MessageIO。(C: ' xampp '根' Lavori ' Bit_Sense ' API_BS ' node_modules '乏味' lib ' connection.js 685:22):在MessageIO。发出(events.js 104:17):在MessageIO。eventData (C: ' xampp '根' Lavori ' Bit_Sense ' API_BS ' node_modules'乏味' lib ' message-io.js 58:21):在套接字。(C: ' xampp '根' Lavori ' Bit_Sense ' API_BS ' node_modules '乏味' lib ' message-io.js:跑)在套接字。发出(events.js 107:17):at readableAddChunk (_stream_readable.js:163:16)at Socket.Readable.push (_stream_readable.js:126:10)在TCP。onread (net.js: 538:20)

我已经安装了这个模块:- sequelize;-乏味;

我在连接上没有问题，只有这个查询:

db.KEY_ARTI.findAll({
  where:{
	      CACODICE: cacodice
	    }
	}).then(function(data) {
		res.send(data);
	});

我能做什么?我没有列id

这是我的表:

var Sequelize = require('sequelize');
var settings = global.settings.databases.DATABASE;
var errors = global.errors;
var utilities = global.utilities; 
var sequelize = new Sequelize(settings.schema, settings.username, settings.password, {
      dialect: settings.dialect,
      host: settings.host,
	  port: settings.port, /* BISOGNA USARE LA DYNAMIC PORT */
      logging: function (str) {
          if(settings.log)
            console.log("querylog: "+str.replace("Executing (default):", "") );
      },
    });
sequelize.authenticate().then(function(err) {
    if (!!err) {
      console.log('Database '+settings.schema+' Connection Error:', err)
    } 
    else {
      console.log('Database '+settings.schema+' Connected')
    }
});
exports.sequelize = sequelize;
/*
 * KEY_ARTI
 */
exports.KEY_ARTI = sequelize.define('KEY_ARTI', {
	CACODICE: Sequelize.CHAR(20),
	CADESART: Sequelize.CHAR(40),
}

默认情况下，如果您自己不做任何操作，sequelize将添加一个名为id的主键。

sequelize.define('model', {}); // Adds an id key
sequelize.define('model', {
  name: {
    primaryKey: true
    type: Sequelize.STRING
  }
}); // Doesn't add an id, because you already marked another column as primary key

没有主键的模型也是可以的，但是我不推荐这样做

相关文章：