{"ScriptPreparationCode":"function generateInsertStatement1(data) {\r\n let values = [];\r\n Object.keys(data).forEach(subjectId =\u003E {\r\n data[subjectId].forEach((questionId, index) =\u003E {\r\n values.push(\u0060(${index \u002B 1},${subjectId},${questionId})\u0060);\r\n });\r\n });\r\n return \u0060INSERT INTO question (sequence,subjectid,questionId) VALUES ${values.join(\u0027,\u0027)};\u0060;\r\n}\r\nfunction generateInsertStatement2(data) {\r\n const values = Object.entries(data).reduce((acc, [subjectId, questionIds]) =\u003E {\r\n const subjectValues = questionIds.map((questionId, index) =\u003E \u0060(${index \u002B 1},${subjectId},${questionId})\u0060);\r\n return acc.concat(subjectValues);\r\n }, []);\r\n return \u0060INSERT INTO question (sequence,subjectid,questionId) VALUES ${values.join(\u0027,\u0027)};\u0060;\r\n}\r\n","TestCases":[{"Name":"reduce","Code":"const questionsData = {\r\n \u00224\u0022: [4796, 4590],\r\n \u00225\u0022: [1141, 947, 1451, 1343, 943, 1088, 2990, 2971, 1504, 3104]\r\n};\r\nconst sqlStatement2 = generateInsertStatement2(questionsData);","IsDeferred":false},{"Name":"foreach","Code":"const questionsData = {\r\n \u00224\u0022: [4796, 4590],\r\n \u00225\u0022: [1141, 947, 1451, 1343, 943, 1088, 2990, 2971, 1504, 3104]\r\n};\r\nconst sqlStatement1 = generateInsertStatement1(questionsData);","IsDeferred":false}]}