我对sails很新,我试图在postgresql db中创建一个身份验证模式 .
我有一个用户模型
module.exports = {
attributes: {
firstName: {
type: 'string'
},
lastName: {
type: 'string'
},
email: {
type: 'string',
required: true,
unique: true
},
password: {
type: 'string',
required: true
},
authTokens: {
collection: 'authToken',
via: 'owner'
}
}
}
和用户注册/创建控制器
module.exports = {
create: function (req, res) {
sails.log.info("Message to be logged");
User.create(
{
email: req.body.email,
firstName: req.body.firstName,
lastName: req.body.lastName,
password: req.body.password
}
).exec(function (err) {
if (err) {
return res.status(400).send({err: err});
} else {
return res.status(200).send({message: "it is okay"});
}
});
}
}
Now when im using the default localDiskDb adapter, it works, the user is created by create method . 当我将datastores.js中的默认数据源更改为
default: {
adapter: 'sails-postgresql',
host: 'mydbserver.rds.amazonaws.com',
user: 'myDbRoot',
password: 'pass',
database: 'myDbName'
}
I can see that tables are created in my database . 但是当我尝试调用create方法时,它返回错误:
AdapterError:数据库适配器出现意外错误:没有参数$ 1
我使用这些版本的帆包:
"sails": "^1.0.0-30",
"sails-hook-grunt": "^1.0.4",
"sails-hook-orm": "^2.0.0-0",
"sails-hook-sockets": "^1.0.1",
"sails-postgresql": "1.0.0-1",
有没有人有想法?
1 回答
升级到
解决了它 .