How to get two tables data in Node.js with object inside other object

Question

I have two tables and I need data in this format. How is this Possible?

Required Output

{
  "id":"1",
  "name":"akhil",
  "pics": [
    {
      "pic1": "123.jpg",
      "pic2": "123.jpg"
    }
  ]
}

Generally I use this for getting data from single table

const express = require('express');
const app = express();
const jwt = require('jsonwebtoken');
const bcrypt = require('bcryptjs');
const config = require('./config');

var VerifyToken = require('./VerifyToken');

const mysql      = require('mysql');

app.use(express.json());
const connection = mysql.createConnection({
   host     : 'localhost',
   user     : 'root',
   password : 'password',
   database : 'sample'
});
    app.get('/usersdata', VerifyToken, (req, res) => {
       let id = req.userId;
       console.log(req.userId);
       connection.query("select * from users", function (error, results, fields) {
          if (error) throw error;
          else {
             res.send({"result": results});
          }
       });
    })

What is connection.query? What module are you using to access your database? — Jordan Running
– Jordan Running, Commented Apr 2, 2019 at 18:41

GRANDHI VENKATA SAI AKHIL · Accepted Answer · 2019-04-03 02:28:14Z

1

My Solution:

app.get('/usersdata', (req, res) => {
   connection.query("select u.id, u.name, p.pic1, p.pic2 from users u, pics p where u.usersid=p.id", function (error, results, fields) {
      if (error) throw error;
      else {
         let data = results;
         let newResult = {};
         results.map(row => {
            if(newResult[row.id]) {
               newResult[row.id].pics.push(row.pic1, row.pic2)
            } else {
               newResult[row.id] = { id: row.id, name: row.name, pics: [row.pic1, row.pic2] };
            }
         })
         res.send({ "result": Object.values(newResult) });
      }
   });
})

answered Apr 3, 2019 at 2:28

GRANDHI VENKATA SAI AKHIL

214 bronze badges

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

Comments

Bharath · Accepted Answer · 2019-04-02 18:21:45Z

0

I would use an ORM instead of writing query myself. Check this link used for a project saved lot of time and code was cleaner.

answered Apr 2, 2019 at 18:21

Bharath

4001 silver badge6 bronze badges

2 Comments

Bharath Over a year ago

See this link for joining two tables in Sequelize

GRANDHI VENKATA SAI AKHIL Over a year ago

This is my client requirement and I cannot change it to some ORM @Bharath

Collectives™ on Stack Overflow

How to get two tables data in Node.js with object inside other object

2 Answers 2

Comments

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related