Advertisement
sombriks

bookshelf problem

Dec 14th, 2016
135
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. // catolico.js
  2. "use strict"
  3.  
  4. const router = require("express").Router();
  5. exports.router = router;
  6.  
  7. const Bookshelf = require("../config").bookshelf;
  8.  
  9. const PerfilCatolico = require("./perfilcatolico").perfilcatolico;
  10.  
  11. const Catolico = Bookshelf.Model.extend({
  12.   tableName:"catolico",
  13.   idAttribute:"idcatolico",
  14.   perfilcatolico() {
  15.     return this.belongsTo(PerfilCatolico)
  16.   }
  17. });
  18. exports.catolico = Catolico;
  19.  
  20. router.get("/list", (req, res) => {
  21.   Catolico.where(req.query).fetchAll().then((ret)=>{
  22.     // works ok
  23.     res.send(ret);
  24.   });
  25. });
  26.  
  27. router.get("/:idcatolico", (req, res) => {
  28.   Catolico.where(req.query).fetch({
  29.     // not working
  30.     withRelated:["perfilcatolico"]
  31.   }).then((ret)=>{
  32.     if(!ret){
  33.       res.status(404).send("NOT_FOUND");
  34.       return;    }
  35.     res.send(ret);
  36.   });
  37. });
  38.  
  39.  
  40. // =======================
  41.  
  42. // perfilcatolico.js
  43.  
  44. "use strict"
  45.  
  46. const router = require("express").Router();
  47. exports.router = router;
  48.  
  49. const Bookshelf = require("../config").bookshelf;
  50.  
  51. const Catolico = require("./catolico").catolico;
  52.  
  53. const PerfilCatolico = Bookshelf.Model.extend({
  54.   tableName:"perfilcatolico",
  55.   idAttribute:"idperfilcatolico",
  56.   catolico() {
  57.     return this.hasMany(Catolico)
  58.   }
  59. });
  60. exports.perfilcatolico = PerfilCatolico;
  61.  
  62.  
  63. // ========================
  64.  
  65. // console error output
  66.  
  67. ::ffff:127.0.0.1 - - [14/Dec/2016:17:43:52 +0000] "GET /catolico/2 HTTP/1.1" - -
  68. Unhandled rejection Error: Undefined binding(s) detected when compiling SELECT query: select "perfilcatolico".* from "perfilcatolico" where "perfilcatolico"."idperfilcatolico" in (?)
  69.     at QueryCompiler_SQLite3.toSQL (/home/sombriks/git/aplicativo-catolico/app-servico/node_modules/knex/lib/query/compiler.js:131:13)
  70.     at Builder.toSQL (/home/sombriks/git/aplicativo-catolico/app-servico/node_modules/knex/lib/query/builder.js:111:44)
  71.     at /home/sombriks/git/aplicativo-catolico/app-servico/node_modules/knex/lib/runner.js:52:32
  72.     at tryCatcher (/home/sombriks/git/aplicativo-catolico/app-servico/node_modules/knex/node_modules/bluebird/js/release/util.js:16:23)
  73.     at /home/sombriks/git/aplicativo-catolico/app-servico/node_modules/knex/node_modules/bluebird/js/release/using.js:185:26
  74.     at tryCatcher (/home/sombriks/git/aplicativo-catolico/app-servico/node_modules/knex/node_modules/bluebird/js/release/util.js:16:23)
  75.     at Promise._settlePromiseFromHandler (/home/sombriks/git/aplicativo-catolico/app-servico/node_modules/knex/node_modules/bluebird/js/release/promise.js:510:31)
  76.     at Promise._settlePromise (/home/sombriks/git/aplicativo-catolico/app-servico/node_modules/knex/node_modules/bluebird/js/release/promise.js:567:18)
  77.     at Promise._settlePromise0 (/home/sombriks/git/aplicativo-catolico/app-servico/node_modules/knex/node_modules/bluebird/js/release/promise.js:612:10)
  78.     at Promise._settlePromises (/home/sombriks/git/aplicativo-catolico/app-servico/node_modules/knex/node_modules/bluebird/js/release/promise.js:691:18)
  79.     at Promise._fulfill (/home/sombriks/git/aplicativo-catolico/app-servico/node_modules/knex/node_modules/bluebird/js/release/promise.js:636:18)
  80.     at PromiseArray._resolve (/home/sombriks/git/aplicativo-catolico/app-servico/node_modules/knex/node_modules/bluebird/js/release/promise_array.js:125:19)
  81.     at PromiseArray._promiseFulfilled (/home/sombriks/git/aplicativo-catolico/app-servico/node_modules/knex/node_modules/bluebird/js/release/promise_array.js:143:14)
  82.     at Promise._settlePromise (/home/sombriks/git/aplicativo-catolico/app-servico/node_modules/knex/node_modules/bluebird/js/release/promise.js:572:26)
  83.     at Promise._settlePromise0 (/home/sombriks/git/aplicativo-catolico/app-servico/node_modules/knex/node_modules/bluebird/js/release/promise.js:612:10)
  84.     at Promise._settlePromises (/home/sombriks/git/aplicativo-catolico/app-servico/node_modules/knex/node_modules/bluebird/js/release/promise.js:691:18)
  85.     at Async._drainQueue (/home/sombriks/git/aplicativo-catolico/app-servico/node_modules/knex/node_modules/bluebird/js/release/async.js:138:16)
  86.     at Async._drainQueues (/home/sombriks/git/aplicativo-catolico/app-servico/node_modules/knex/node_modules/bluebird/js/release/async.js:148:10)
  87.     at Immediate.Async.drainQueues [as _onImmediate] (/home/sombriks/git/aplicativo-catolico/app-servico/node_modules/knex/node_modules/bluebird/js/release/async.js:17:14)
  88.     at processImmediate [as _immediateCallback] (timers.js:383:17)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement