I'm starting to study and practice RethinkDB using Thinky, but I have a problem that takes a couple of days and I can't solve it. Storing or saving data in just one collection works for me normally, even if I save the same data. Now I am testing with two models and thus be able to perform a Join, my models are the following:Storing or saving data in just one collection works for me normally, even if I save the same data. Now I am testing with two models and thus be able to perform a Join, my models are the following...
- This is Post's model:
'use strict'
let thinky = require('../util/thinky')
let type = thinky.type
let Post = thinky.createModel('Post',{
id: type.string(),
title: type.string(),
content: type.string(),
idAutor: type.string()
})
module.exports = Post
- This is Autor's model:
'use strict'
const thinky = require('../util/thinky')
const type = thinky.type
let Autor = thinky.createModel("Autor",{
id: type.string(),
name: type.string()
})
module.exports = Autor
Here is the part where the error that I mentioned to you at the beginning sends me. I'm doing a belongsTo as shown in the Thinky documentation as follows:
'use strict'
const Post = require('../models/postModel')
const Autor = require('../models/autorModel')
async function saludar(req,res){
Post.hasOne(Autor, "autor", "idAutor", "id") //Here is the line where the error sends me
try {
let post = new Post({
title: "title",
content: "content"
})
let autor = new Autor({
name: "name"
})
post.autor = autor
await post.saveAll().then(function(result){
res.status(200).json({
ok: true,
result: result
})
}).catch((error)=>{
res.status(500).json({
ok: false,
message: `Error: ${error}`
})
})
} catch (error) {
res.status(500).json({
ok: false,
message: `Error: ${error}`
})
}
}
The first time I do this operation, it normally saves the data and shows me as follows:
{
"ok": true,
"result": {
"title": "title",
"content": "content",
"autor": {
"name": "name",
"id": "b53ab88e-7130-497f-ab4b-d6973bd640af"
},
"id": "6abef79c-5004-48bc-9e78-6e8f9c8d8b33"
}
}
But when storing other data and even the same data for the second time onwards, it already sends me the error:
POST /api/registro 200 137.700 ms - 170
(node:14378) UnhandledPromiseRejectionWarning: Error: The field `autor` is already used by another relation.
at Function.Model.hasOne (/home/nik/Documents/rest-api-atlanta/node_modules/thinky/lib/model.js:392:11)
at saludar (/home/nik/Documents/rest-api-atlanta/controllers/index.js:10:10)
at Layer.handle [as handle_request] (/home/nik/Documents/rest-api-atlanta/node_modules/express/lib/router/layer.js:95:5)
at next (/home/nik/Documents/rest-api-atlanta/node_modules/express/lib/router/route.js:137:13)
at Route.dispatch (/home/nik/Documents/rest-api-atlanta/node_modules/express/lib/router/route.js:112:3)
at Layer.handle [as handle_request] (/home/nik/Documents/rest-api-atlanta/node_modules/express/lib/router/layer.js:95:5)
at /home/nik/Documents/rest-api-atlanta/node_modules/express/lib/router/index.js:281:22
at Function.process_params (/home/nik/Documents/rest-api-atlanta/node_modules/express/lib/router/index.js:335:12)
at next (/home/nik/Documents/rest-api-atlanta/node_modules/express/lib/router/index.js:275:10)
at Function.handle (/home/nik/Documents/rest-api-atlanta/node_modules/express/lib/router/index.js:174:3)
at router (/home/nik/Documents/rest-api-atlanta/node_modules/express/lib/router/index.js:47:12)
at Layer.handle [as handle_request] (/home/nik/Documents/rest-api-atlanta/node_modules/express/lib/router/layer.js:95:5)
at trim_prefix (/home/nik/Documents/rest-api-atlanta/node_modules/express/lib/router/index.js:317:13)
at /home/nik/Documents/rest-api-atlanta/node_modules/express/lib/router/index.js:284:7
at Function.process_params (/home/nik/Documents/rest-api-atlanta/node_modules/express/lib/router/index.js:335:12)
at next (/home/nik/Documents/rest-api-atlanta/node_modules/express/lib/router/index.js:275:10)
at logger (/home/nik/Documents/rest-api-atlanta/node_modules/morgan/index.js:144:5)
at Layer.handle [as handle_request] (/home/nik/Documents/rest-api-atlanta/node_modules/express/lib/router/layer.js:95:5)
at trim_prefix (/home/nik/Documents/rest-api-atlanta/node_modules/express/lib/router/index.js:317:13)
at /home/nik/Documents/rest-api-atlanta/node_modules/express/lib/router/index.js:284:7
at Function.process_params (/home/nik/Documents/rest-api-atlanta/node_modules/express/lib/router/index.js:335:12)
at next (/home/nik/Documents/rest-api-atlanta/node_modules/express/lib/router/index.js:275:10)
(node:14378) UnhandledPromiseRejectionWarning: Unhandled promise rejection. This error originated either by throwing inside of an async function without a catch block, or by rejecting a promise which was not handled with .catch(). To terminate the node process on unhandled promise rejection, use the CLI flag `--unhandled-rejections=strict` (see https://nodejs.org/api/cli.html#cli_unhandled_rejections_mode). (rejection id: 1)
(node:14378) [DEP0018] DeprecationWarning: Unhandled promise rejections are deprecated. In the future, promise rejections that are not handled will terminate the Node.js process with a non-zero exit code.
If someone could explain why, I haven't understood for days, or maybe I have to do some additional configuration. Thanks in advance...