Sequelize Raw Query returns Array of TextRows

Question

I am using sequelize in my project. I am using the following format to get the results. But each row in the result is returned as textRow. Is it ok if I can directly access using the index or Do I need to convert textrow? Need your suggestions.

const testQuery = await sequelizeConn.query(`select * from users where user_name = '${reqParams.userName}'`, {
         raw: true
      })
if(testQuery && testQuery.length > 0 && testQuery[0].length > 0){
}

Hello! I'd like to understand, what resut would you like to get. I only can get that you don't like textrows for now — CoderFF, Nov 23 '20 at 04:06
am ok with text rows. Is it advisable to access text rows like normal objects? — user846445, Nov 23 '20 at 05:20

score 1 · Answer 1 · answered Nov 30 '20 at 17:40

1

You need to remove raw:true because already it's working like raw query and try promise instead of async/await.

    
         sequelize.query(`select * from users where user_name = ${reqParams.userName}`, {model: users})
          .then(function(result) {
         
            if(result && result.length > 0 && result[0].length > 0){
    console.log(result);
    }
            
          }).catch(error=>{
                  console.log(error);
});

answered Nov 30 '20 at 17:40

aum trivedi

129
4

Any specific reason to change to promises? – user846445 Dec 01 '20 at 07:14
1

No , it's not compulsory you can also try with async/await i am just asking for debuging. – aum trivedi Dec 01 '20 at 10:59

Sequelize Raw Query returns Array of TextRows

1 Answers1