Connection with mongolab gives null JSON

Question

This is my server.js.

var express          = require('express'),
    app              = express(),
    bodyParser       = require('body-parser'),
    mongoose         = require('mongoose'),
    CohortController =require('./CohortController');

var MongoURL='mongodb://username:password@ds037395.mongolab.com:37395/abc';

mongoose.connect(MongoURL,function (error) {
    if (error) 
        console.error(error);
    else
        console.log('mongo connected');
});


app.use(bodyParser());

app.get('/api/cohorts',CohortController.list);
app.post('/api/cohorts',CohortController.create);

app.listen(3000,function(){ 
  console.log('Listening...');
})

And my CohortController.js

 var mongoose=require('mongoose');

 var Cohort=mongoose.model('Cohorts',new Schema({
 id:Number,
 name:String
 }));
module.exports.create=function(req,res){
var cohort=new Cohort(req.body);
cohort.save(function(err,result){
res.json(result);
 });
}

module.exports.list=
function(req,res){
  Cohort.find({},function(err,results){
   res.json(results);
 });
}

When I run the node server and use the URL

localhost:3000/api/cohorts

I am getting null JSON i.e [] but when I connect it with the local mongodb instance I get the correct JSON.

second parameter should be instance of schema var Schema = mongoose.Schema; mongoose.model('Cohorts', new Schema({id:Number, name:String}); — Venkat.R, Jan 04 '16 at 17:44
yes @Venkatraman I did that only and I edited the mistake.... — Shubham Pendharkar, Jan 04 '16 at 18:08
The name of the schema over here is same as that I made on monoglab — Shubham Pendharkar, Jan 06 '16 at 04:41

AugustoL · Answer 1 · 2016-01-04T18:26:58.513

0

Try createConnection:

//Connect
var db = mongoose.createConnection(MongoURL);
db.on('error', console.error.bind(console, 'connection error:'));

//Once connected do actions
db.once('open', function callback () {
    console.log('Connected to DB: '+MongoURL); 
});

And add a category sshcema or any schema you want:

    var category = new Schema({
        name : String,
        quantity : Number
    });

    db.categories = db.model('categories', category)

edited Jan 04 '16 at 18:26

answered Jan 04 '16 at 18:18

AugustoL

354
1
7

@Shubham fixed, and I added and example of how you will add an schema – AugustoL Jan 04 '16 at 18:27
It shows that connected to mongodb://username:password@ds037395.mongolab.com:37395/abc. But the json is not fetched....It keeps on loading and loading – Shubham Pendharkar Jan 04 '16 at 18:36
You need teh json? Once it display its connected its because it is connected, just add the shcemas and use the db var. – AugustoL Jan 04 '16 at 20:34

score 0 · Answer 2 · answered Jan 04 '16 at 18:51

0

Add collection in schema.

var schema = new Schema({
  id:Number,
  name:String
}, { collection: 'actor' });

// or

schema.set('collection', 'actor');

// or

var collectionName = 'actor'
var M = mongoose.model('Actor', schema, collectionName)

answered Jan 04 '16 at 18:51

Venkat.R

7,420
5
42
63

what will happen if I add the collection to the schema.... There are already collections in my mongolab account – Shubham Pendharkar Jan 04 '16 at 18:55
When I access the mongolab account with the shell...I get the correct output. – Shubham Pendharkar Jan 04 '16 at 19:09

Connection with mongolab gives null JSON

2 Answers2