How do we get response data in JSON format using node.js

Question

I am trying to get response data from model(database) to controller

here is model

var database = require('../config/db');

exports.getAllBatch = function(done) {
database.query('SELECT batchName from batch', function (err, rows) {
    if (err) return console.log(err);
    else {
        console.log(null, rows);

        return rows;
    }
})
};

here is controller

code to access data from model.

var express = require('express');
var router = express.Router();
var batch=require('../models/BatchModel');
var myParser = require("body-parser");
var app = express();

router.get('/getbatch', function(req, res, next)
{
var resp=batch.getAllBatch();
    res.send(resp);
    //not displaying anything on browser
});
});

How I get response on browser please guide me.Thank you in advance.

jesusbv - user3085938 · Accepted Answer · 2017-01-11 13:34:47Z

2

That is good code, the only thing missing is setting the body parser you have required

app.use(myParser.json())

answered Jan 11, 2017 at 13:34

jesusbv - user3085938

1841 silver badge4 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

bsyk · Accepted Answer · 2017-01-12 08:07:54Z

Your functions are using a callback pattern, but you're not calling or checking the callbacks.

Model

var database = require('../config/db');

exports.getAllBatch = function(done) {
  database.query('SELECT batchName from batch', function (err, rows) {
    if (err) {
      console.log('Err', err);
      return done(err);
    }
    else {
      console.log('Rows', rows);
      return done(null, rows);
    }
  });
};

Controller

var express = require('express');
var router = express.Router();
var batch=require('../models/BatchModel');
var myParser = require("body-parser");
var app = express();

router.get('/getbatch', function(req, res, next) {
  batch.getAllBatch(function(err, rows) {
    if (err) {
      res.status(500).send(err);
    } else {
      res.send(rows);
    }
  });
});

Collectives™ on Stack Overflow

How do we get response data in JSON format using node.js

here is model

here is controller

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

here is model

here is controller

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related