Mapping 2 object and create object based on values

Question

I have an object that is build with from an html form. When i fill the form I obtain this json object we call "jsonObjectForm" :

{
  "inputID1": "content1",
  "inputID2": "content2",
  "inputID3": "content3",
  "beginningDate": "2020-02-02",
  "endingDate": "2022-03-03",
  "inputID4": "content4",
  "inputID5": "content5",
  "inputID6": "content6",
  "inputID7": "content7",
  "inputID8": "content8"
}

I have a second object that i have to use to build a sql query. this object is

let fieldNames = {
    "inputID1": "dbField1",
    "inputID2": "dbField2",
    "inputID3": "dbField3",
    "inputID4": "dbField4",
    "inputID5": "dbField5",
    "inputID6": "dbField6",
    "inputID7": "dbField7",
    "inputID8": "dbField7",
};

I found the way to browse the first object. I defined the form elements i want to "scan" in the form :

const pageFormElements = getAllFormElements(document.getElementById("requestForm"));

for(let [key, value] of Object.entries(jsonObjectForm)) {
    pageFormElements.forEach(element => {
        console.log("key: " + key + " | value: " + value);
    }
}

My question is how do i manage the double forEach in this case and I wonder if there's a way to "map" the values from the first object to the second and build a final object that would look like this:

let fieldNames = {
    "dbField1": "content1",
    "dbField2": "content2",
    "dbField3": "content3",
    "dbField4": "content4",
    "dbField5": "content5",
    "dbField6": "content6",
    "dbField7": "content7",
    "dbField7": "content8",
};

My objective is to create a query like this

query = select * from whatever where dbField1 = content1 AND dbField2 = content2 ... AND dbField8 = content8;

do you have empty values? what happens with numbers? or substrings? — Nina Scholz
– Nina Scholz, Commented Nov 15, 2019 at 10:08
Yes i can have empty values. And the second object do not include the date that are managed separatelly... — davidvera
– davidvera, Commented Nov 15, 2019 at 10:10
why not change the input fields of the form dircty to the names of the database field names? — Nina Scholz
– Nina Scholz, Commented Nov 15, 2019 at 10:12
I can try this way but i don't think it will be appreciated ... — davidvera
– davidvera, Commented Nov 15, 2019 at 10:14
what should happen with the date? which field is associated to it? — Nina Scholz
– Nina Scholz, Commented Nov 15, 2019 at 10:18

Nina Scholz · Accepted Answer · 2019-11-15 10:42:09Z

2

You could iterate the fields and assemble the wanted query by having a look to keys with beginning and ending prefix for BETWEEN expressions.

var data = { inputID1: "content1", inputID2: "content2", inputID3: "content3", beginningDate: "2020-02-02", endingDate: "2022-03-03", inputID4: "content4", inputID5: "content5", inputID6: "content6", inputID7: "content7", inputID8: "content8" },
    fields = { Date: 'date', inputID1: "dbField1", inputID2: "dbField2", inputID3: "dbField3", inputID4: "dbField4", inputID5: "dbField5", inputID6: "dbField6", inputID7: "dbField7", inputID8: "dbField7" },
    result = Object
        .entries(fields)
        .map(([k, v]) => (('beginning' + k) in data) && (('ending' + k) in data)
            ? `${v} BETWEEN '${data['beginning' + k]}' AND '${data['ending' + k]}'`
            : `${v}='${data[k]}'`
        )
        .join(' AND ');

console.log(result);

.as-console-wrapper { max-height: 100% !important; top: 0; }

answered Nov 15, 2019 at 10:42

Nina Scholz

388k26 gold badges367 silver badges417 bronze badges

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

4 Comments

davidvera Over a year ago

this works perfectly thanks ! i should be able from there to manage the "undefined" when field is not set..

Nina Scholz Over a year ago

You could filter first before mapping, or take flatMap and insert an empty array.

davidvera Over a year ago

I used a regex and replace what i want to remove :) i'll have a look at flatmap ! thanks

davidvera Over a year ago

here is the regex i used : (?:[a-zA-Z0-9_]+='undefined' <[/]And>)

Titus · Accepted Answer · 2019-11-15 10:22:15Z

You can use something like this:

const content = {
  "inputID1": "content1",
  "inputID2": "content2",
  "inputID3": "content3",
  "beginningDate": "2020-02-02",
  "endingDate": "2022-03-03",
  "inputID4": "content4",
  "inputID5": "content5",
  "inputID6": "content6",
  "inputID7": "content7",
  "inputID8": "content8"
}

const fieldNames = {
  "inputID1": "dbField1",
  "inputID2": "dbField2",
  "inputID3": "dbField3",
  "inputID4": "dbField4",
  "inputID5": "dbField5",
  "inputID6": "dbField6",
  "inputID7": "dbField7",
  "inputID8": "dbField7",
};

const result = Object.entries(fieldNames).reduce((a, [k, v]) => (a[v] = content[k], a), {});

console.log(result);

This will go through fieldNames entries and generate a new object using the entry's value as key and as value, the value from the content object that matches the entry's key.

Serlox · Accepted Answer · 2019-11-15 10:44:40Z

1

This code can do it for you:

const content = {
  "inputID1": "content1",
  "inputID2": "content2",
  "inputID3": "content3",
  "beginningDate": "2020-02-02",
  "endingDate": "2022-03-03",
  "inputID4": "content4",
  "inputID5": "content5",
  "inputID6": "content6",
  "inputID7": "content7",
  "inputID8": "content8"
}

const fieldNames = {
  "inputID1": "dbField1",
  "inputID2": "dbField2",
  "inputID3": "dbField3",
  "inputID4": "dbField4",
  "inputID5": "dbField5",
  "inputID6": "dbField6",
  "inputID7": "dbField7",
  "inputID8": "dbField7",
};
const result = {};
Object.keys(fieldNames).forEach(key => result[fieldNames[key]] = content[key]);
console.log(result);

answered Nov 15, 2019 at 10:44

Serlox

473 bronze badges

Collectives™ on Stack Overflow

Mapping 2 object and create object based on values

3 Answers 3

4 Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

4 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related