Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- // catolico.js
- "use strict"
- const router = require("express").Router();
- exports.router = router;
- const Bookshelf = require("../config").bookshelf;
- const PerfilCatolico = require("./perfilcatolico").perfilcatolico;
- const Catolico = Bookshelf.Model.extend({
- tableName:"catolico",
- idAttribute:"idcatolico",
- perfilcatolico() {
- return this.belongsTo(PerfilCatolico)
- }
- });
- exports.catolico = Catolico;
- router.get("/list", (req, res) => {
- Catolico.where(req.query).fetchAll().then((ret)=>{
- // works ok
- res.send(ret);
- });
- });
- router.get("/:idcatolico", (req, res) => {
- Catolico.where(req.query).fetch({
- // not working
- withRelated:["perfilcatolico"]
- }).then((ret)=>{
- if(!ret){
- res.status(404).send("NOT_FOUND");
- return; }
- res.send(ret);
- });
- });
- // =======================
- // perfilcatolico.js
- "use strict"
- const router = require("express").Router();
- exports.router = router;
- const Bookshelf = require("../config").bookshelf;
- const Catolico = require("./catolico").catolico;
- const PerfilCatolico = Bookshelf.Model.extend({
- tableName:"perfilcatolico",
- idAttribute:"idperfilcatolico",
- catolico() {
- return this.hasMany(Catolico)
- }
- });
- exports.perfilcatolico = PerfilCatolico;
- // ========================
- // console error output
- ::ffff:127.0.0.1 - - [14/Dec/2016:17:43:52 +0000] "GET /catolico/2 HTTP/1.1" - -
- Unhandled rejection Error: Undefined binding(s) detected when compiling SELECT query: select "perfilcatolico".* from "perfilcatolico" where "perfilcatolico"."idperfilcatolico" in (?)
- at QueryCompiler_SQLite3.toSQL (/home/sombriks/git/aplicativo-catolico/app-servico/node_modules/knex/lib/query/compiler.js:131:13)
- at Builder.toSQL (/home/sombriks/git/aplicativo-catolico/app-servico/node_modules/knex/lib/query/builder.js:111:44)
- at /home/sombriks/git/aplicativo-catolico/app-servico/node_modules/knex/lib/runner.js:52:32
- at tryCatcher (/home/sombriks/git/aplicativo-catolico/app-servico/node_modules/knex/node_modules/bluebird/js/release/util.js:16:23)
- at /home/sombriks/git/aplicativo-catolico/app-servico/node_modules/knex/node_modules/bluebird/js/release/using.js:185:26
- at tryCatcher (/home/sombriks/git/aplicativo-catolico/app-servico/node_modules/knex/node_modules/bluebird/js/release/util.js:16:23)
- at Promise._settlePromiseFromHandler (/home/sombriks/git/aplicativo-catolico/app-servico/node_modules/knex/node_modules/bluebird/js/release/promise.js:510:31)
- at Promise._settlePromise (/home/sombriks/git/aplicativo-catolico/app-servico/node_modules/knex/node_modules/bluebird/js/release/promise.js:567:18)
- at Promise._settlePromise0 (/home/sombriks/git/aplicativo-catolico/app-servico/node_modules/knex/node_modules/bluebird/js/release/promise.js:612:10)
- at Promise._settlePromises (/home/sombriks/git/aplicativo-catolico/app-servico/node_modules/knex/node_modules/bluebird/js/release/promise.js:691:18)
- at Promise._fulfill (/home/sombriks/git/aplicativo-catolico/app-servico/node_modules/knex/node_modules/bluebird/js/release/promise.js:636:18)
- at PromiseArray._resolve (/home/sombriks/git/aplicativo-catolico/app-servico/node_modules/knex/node_modules/bluebird/js/release/promise_array.js:125:19)
- at PromiseArray._promiseFulfilled (/home/sombriks/git/aplicativo-catolico/app-servico/node_modules/knex/node_modules/bluebird/js/release/promise_array.js:143:14)
- at Promise._settlePromise (/home/sombriks/git/aplicativo-catolico/app-servico/node_modules/knex/node_modules/bluebird/js/release/promise.js:572:26)
- at Promise._settlePromise0 (/home/sombriks/git/aplicativo-catolico/app-servico/node_modules/knex/node_modules/bluebird/js/release/promise.js:612:10)
- at Promise._settlePromises (/home/sombriks/git/aplicativo-catolico/app-servico/node_modules/knex/node_modules/bluebird/js/release/promise.js:691:18)
- at Async._drainQueue (/home/sombriks/git/aplicativo-catolico/app-servico/node_modules/knex/node_modules/bluebird/js/release/async.js:138:16)
- at Async._drainQueues (/home/sombriks/git/aplicativo-catolico/app-servico/node_modules/knex/node_modules/bluebird/js/release/async.js:148:10)
- 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)
- at processImmediate [as _immediateCallback] (timers.js:383:17)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement