CODEWITHSUNDEEP
node.jspostgresqlstronglooploopback
Nayank
Nayank

Reputation: 101

Cannot read property 'connector' of undefined

 {
  "error": {
    "statusCode": 500,
    "name": "TypeError",
    "message": "Cannot read property 'connector' of undefined",
    "stack": "TypeError: Cannot read property 'connector' of undefined\n    at Function.Projects.getProjectData (F:\\SanWork\\AngularWorkSpace\\jobMngt\\common\\models\\projects.js:7:44)\n    at SharedMethod.invoke (F:\\SanWork\\AngularWorkSpace\\jobMngt\\node_modules\\strong-remoting\\lib\\shared-method.js:263:25)\n    at HttpContext.invoke (F:\\SanWork\\AngularWorkSpace\\jobMngt\\node_modules\\strong-remoting\\lib\\http-context.js:389:12)\n    at phaseInvoke (F:\\SanWork\\AngularWorkSpace\\jobMngt\\node_modules\\strong-remoting\\lib\\remote-objects.js:654:9)\n    at runHandler (F:\\SanWork\\AngularWorkSpace\\jobMngt\\node_modules\\loopback-phase\\lib\\phase.js:135:5)\n    at iterate (F:\\SanWork\\AngularWorkSpace\\jobMngt\\node_modules\\loopback-phase\\node_modules\\async\\lib\\async.js:146:13)\n    at Object.async.eachSeries (F:\\SanWork\\AngularWorkSpace\\jobMngt\\node_modules\\loopback-phase\\node_modules\\async\\lib\\async.js:162:9)\n    at runHandlers (F:\\SanWork\\AngularWorkSpace\\jobMngt\\node_modules\\loopback-phase\\lib\\phase.js:144:13)\n    at iterate (F:\\SanWork\\AngularWorkSpace\\jobMngt\\node_modules\\loopback-phase\\node_modules\\async\\lib\\async.js:146:13)\n    at F:\\SanWork\\AngularWorkSpace\\jobMngt\\node_modules\\loopback-phase\\node_modules\\async\\lib\\async.js:157:25\n    at F:\\SanWork\\AngularWorkSpace\\jobMngt\\node_modules\\loopback-phase\\node_modules\\async\\lib\\async.js:154:25\n    at execStack (F:\\SanWork\\AngularWorkSpace\\jobMngt\\node_modules\\strong-remoting\\lib\\remote-objects.js:493:7)\n    at RemoteObjects.execHooks (F:\\SanWork\\AngularWorkSpace\\jobMngt\\node_modules\\strong-remoting\\lib\\remote-objects.js:497:10)\n    at phaseBeforeInvoke (F:\\SanWork\\AngularWorkSpace\\jobMngt\\node_modules\\strong-remoting\\lib\\remote-objects.js:650:10)\n    at runHandler (F:\\SanWork\\AngularWorkSpace\\jobMngt\\node_modules\\loopback-phase\\lib\\phase.js:135:5)\n    at iterate (F:\\SanWork\\AngularWorkSpace\\jobMngt\\node_modules\\loopback-phase\\node_modules\\async\\lib\\async.js:146:13)"
  }
}

Getting this error when using this code, I would like to know what is causing the error and any possible fixes.

model code:

  'use strict';

module.exports = function(Projects) {
Projects.getProjectData = function(cb) {
        var sql = 'select * from projects';
        // call sql query from postreSQL
        Projects.app.datasources.postgres.connector.query(sql, function(err, result) {
            if (err) {
                console.log('Error retrieving projects result ...');
                console.log(err);
                return cb(err);
            }
            cb(err, result[0].jsondata);
        });
    }
    Projects.remoteMethod(
        'getProjectData', {
            returns: [{
                type: 'string',
                required: true,
                root: true
            }],
            http: {
                verb: 'get'
            }
        }
    );
};

I already installed loopback-connector-postgresql & generated the models but when I tried for writing custom api getting error.

Upvotes: 0

Views: 1273

Answers (1)

itssajan
itssajan

Reputation: 830

before the module.exports declare 

var app = require('../../server/server.js');

this is from the assumption that you are in the model directory in common folder.

then instead of using Projects.app.datasource use app.datasource

Upvotes: 1

Related Questions