How to build a SQL query from a json in react?

Question

I have a requirement to modify a JSON to a JSON having the values in a SQL query format. To better explain.

{
 "CASE_0": {"fact_dark":"CHC_Fill"},
 "CASE_2": {"Itc_sun":"SEA_Ont"}
}

The result should be having the json values as an sql query leaving the keys as it is. So the resulting query will be:

{
CASE_0: "fact_dark = 'CHC_Fill'", 
CASE_2: "Itc_sun = 'SEA_Ont'"
}

I could've proceeded with regex but I couldn't figure it out well. Any elegant ES6 based solution to this?. Please folks help me out on this. TIA

You could do it manually or use a query builder like knex.js (if building queries from js objects is a common problem in your app) — Rashomon
– Rashomon, Commented Dec 4, 2020 at 8:23
No idea on knex.js but how to do it manually? will it be messy? — Bratty Neal
– Bratty Neal, Commented Dec 4, 2020 at 8:29

Rashomon · Accepted Answer · 2020-12-04 09:37:48Z

1

Here is a solution using ES6 reduce and entries method, string templates, array destructuring and spread operator:

const input = {
 "CASE_0": {"fact_dark":"CHC_Fill"},
 "CASE_2": {"Itc_sun":"SEA_Ont"}
}

const output = Object.entries(input).reduce((result, [CASE, caseValue]) => {
  const [[key, value]] = Object.entries(caseValue)
  return {...result, [CASE]: `${key} = '${value}'`}
}, {})

console.log(output)

edited Dec 4, 2020 at 9:37

answered Dec 4, 2020 at 8:46

Rashomon

6,8924 gold badges41 silver badges84 bronze badges

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

4 Comments

Bratty Neal Over a year ago

Great solution.... but what if the value for "CASE_0" is {}?

Rashomon Over a year ago

We dont know the expected ouput in that case, could you add it to the question?

Bratty Neal Over a year ago

The output would be just {}

Rashomon Over a year ago

Can't understand. If filled, you get a string. If no value, you get an object? I would suggest to add the case explicitly in the question

Tigran Abrahamyan · Accepted Answer · 2020-12-04 10:44:22Z

0

First, we have to transform the object into the array, for this, we use the Object.entries();.

Then we go through the array and create a new array using map, and inside map we create an object.

Then in the console.log(); we deployment the array using spread operator and get our object.

const data = {
  "CASE_0": {"fact_dark":"CHC_Fill"},
  "CASE_2": {"Itc_sun":"SEA_Ont"}
};

const result = Object.entries(data).map(n => {
  return {
    [n[0]]: `${Object.keys(n[1])} = '${Object.values(n[1])}'`,
  };
});

console.log(Object.assign(...result));

edited Dec 4, 2020 at 10:44

answered Dec 4, 2020 at 8:40

Tigran Abrahamyan

7761 gold badge4 silver badges7 bronze badges

1 Comment

Rashomon Over a year ago

This accepted answer doesnt fit the expected output of the question... Returns an array of objects instead of one object

Collectives™ on Stack Overflow

How to build a SQL query from a json in react?

2 Answers 2

4 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

4 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related