我在一个使用MySQL数据库的小型nodejs项目中使用Sequelize。
使用findOrCreate,我可以找到现有对象并插入新对象,但是当创建并返回新对象时,主键为“未定义”。
定义
module.exports = function(sequelize, DataTypes) {
var Student = sequelize.define('Student', {
id : {
type : DataTypes.BIGINT,
primaryKey : true
},
wxid : DataTypes.STRING,
client : DataTypes.STRING,
nick : DataTypes.STRING,
wallet : {type: DataTypes.INTEGER, defaultValue: 0},
mcount : {type: DataTypes.INTEGER, defaultValue: 0},
qcount : {type: DataTypes.INTEGER, defaultValue: 0},
status : {type: DataTypes.INTEGER, defaultValue: 0},
premium_type : {type: DataTypes.INTEGER, defaultValue: 0},
createtime : DataTypes.DATE,
lastqtime : DataTypes.DATE,
lastmtime : DataTypes.DATE
}, {
freezeTableName : true,
timestamps : false,
tableName : 'student_student',
associate: function(models) {
Student.hasMany(models.Question, {as:'questions', foreignKey: 'student_id'});
}
});
return Student;
};
findOrCreate
db.Student.findOrCreate( { wxid : info.uid },
{
client: client_name,
createtime: new Date(),
lastmtime: new Date()
}).success(
function(stu, created) {
if (!stu) {
console.log('Stu[' + info.uid + '] not found.'.red);
} else {
if (created) {
stu.created = true;
console.log(stu.values);
//// Here, stu.id is 'undefined'
}
}
});
日志:
[app-0 (out) 2014-01-10T21:54:32] { id: undefined,
[app-0 (out) 2014-01-10T21:54:32] wxid: 'o6ssct7SHGXN1zlyD6vvfk3TMr68',
[app-0 (out) 2014-01-10T21:54:32] client: 'wxcs',
[app-0 (out) 2014-01-10T21:54:32] nick: undefined,
[app-0 (out) 2014-01-10T21:54:32] wallet: 0,
[app-0 (out) 2014-01-10T21:54:32] mcount: 0,
[app-0 (out) 2014-01-10T21:54:32] qcount: 0,
[app-0 (out) 2014-01-10T21:54:32] status: 0,
[app-0 (out) 2014-01-10T21:54:32] premium_type: 0,
[app-0 (out) 2014-01-10T21:54:32] createtime: Fri Jan 10 2014 21:54:32 GMT+0800 (CST),
[app-0 (out) 2014-01-10T21:54:32] lastqtime: undefined,
[app-0 (out) 2014-01-10T21:54:32] lastmtime: Fri Jan 10 2014 21:54:32 GMT+0800 (CST) }
但是,当我查看数据库时,发现该行已正确插入。
如何找到ID已设置的FindOrCreate?谢谢。
最佳答案
将autoIncrement: true
添加到ID字段中,即可解决此问题。