0

Here i am working on typescript mysql rest api, i am looped values are storing in object.assign.if i console give inside loop data is come but i need inside loop values return to otside function. Here i attachecd my code.

let s = async() => {
  
   return sqlQuery.forEach(async(outer:any)=>{
   
    let k1 = outer.keyword1.replace("[","").replace("]","") ;
    let k2 = outer.keyword1.replace("[","").replace("]","") ;
    let k3 = outer.keyword1.replace("[","").replace("]","") ;
    let k4 = outer.keyword1.replace("[","").replace("]","") ;
    let k5 = outer.keyword1.replace("[","").replace("]","") ;
    let k6 = outer.keyword1.replace("[","").replace("]","") ;
    let k7 = outer.keyword1.replace("[","").replace("]","") ;
       var district:any = `select slug from foa_section_content where foa_section_content_id IN (${k1})`;
    var comune:any = `select slug from foa_section_content where foa_section_content_id IN (${k2})`;
    var professional:any = `select slug from foa_section_content where foa_section_content_id IN (${k3})`;
    var branch:any = `select slug from foa_section_content where foa_section_content_id IN (${k4})`;
    var employment:any = `select slug from foa_section_content where foa_section_content_id IN (${k5})`;
    var position:any = `select slug from foa_section_content where foa_section_content_id IN (${k6})`;
    var benefits:any = `select slug from foa_section_content where foa_section_content_id IN (${k7})`;
      var [district1]: any = await connection.execute(district) ;
      var [comune1]: any = await connection.execute(comune) ;
      var [professional1]: any = await connection.execute(professional) ;
      var [branch1]: any = await connection.execute(branch) ;
      var [employment1]: any = await connection.execute(employment) ;
      var [position1]: any = await connection.execute(position) ;
      var [benefits1]: any = await connection.execute(benefits) ;
     return await Object.assign(outer,{district1},{comune1},{professional1},{branch1},{employment1},{position1},{benefits1})
   
})

  }

 var jjj= s();
 console.log(jjj);
jaga b
  • 21
  • 4

0 Answers0