CODEWITHSUNDEEP
node.jssequelize.jssequelize-cli
Gijo Varghese
Gijo Varghese

Reputation: 11780

Get only dataValues from Sequelize ORM

I'm using the sequelize ORM to fetch data from a PSQL DB. However, when I retrieve something, a whole bunch of data is given. The only data I want is inside 'dataValues'. Of course, I can use object.dataValues. But, is there any other good solutions?

I'm using Sequelize 4.10

Upvotes: 93

Views: 135200

Answers (7)

occasl
occasl

Reputation: 5454

If you don't want to change your finder methods (e.g., some consumers may want the Mongo object and some just the data), you can use .toJSON to get the object from the former.

const query = await myQuery(id);
const record = query.toJSON();

Upvotes: 2

Ahmed Adewale
Ahmed Adewale

Reputation: 3133

This is how I solved mine

    let rows = await database.Book.findAll(options);
    rows = JSON.stringify(rows);
    rows = JSON.parse(rows);

Note that the query has 'include childModel' i could've used 'raw:true' if it just one model. Stringifying the result clears out the '_previousDataValues' e.t.c and give you plain object, now parse the stringified obect back to json. Took me a long time before I could figure this out.

Upvotes: 9

defraggled
defraggled

Reputation: 1218

To clarify Masoud Tavakkoli's answer (which is not immediately clear on that github answer): using element.get({ plain: true }) returns an array of objects with each attribute key:value pairs.

If you just want an array of one specific attribute's values (eg user ids) instead of objects, you can use something like this:

const users = await User.findAll({
    attributes: ["id"], 
    where: {} // Your filters here
}).map(u => u.get("id")) // [1,2,3]

Nika Kasradze's answer actually achieves the same outcome as a middle-step; using the JSON stringifier generates the same array output. It's possible this is faster than mapping, but I'm not sure.

const users = await User.findAll({
    attributes: ["id"], 
    where: {} // Your filters here
})
const userIds = JSON.stringify(users)) // [1,2,3]

Upvotes: 7

Masoud Tavakkoli
Masoud Tavakkoli

Reputation: 1020

Finally I found answer after searching a lot. you should do something like this

const users = await db.users.findAll({})
   .map(el => el.get({ plain: true })) // add this line to code

source: github issue

Upvotes: 23

C Deuter
C Deuter

Reputation: 933

Sequelize wraps all it's return values in a virtual object that contains meta data. If you have an object and you just want the undecorated data values, you can unwrap them like so:

Model.findById(1).then(data => {
  console.log(data.get({ plain: true }));
});

Additionally if you just want to print out the object you can use the .toJSON method.

Model.findById(1).then(data => {
  console.log(data.toJSON());
});

Upvotes: 55

Gijo Varghese
Gijo Varghese

Reputation: 11780

The problem occurs only when I log it using:

console.log(Model.findAll());

If I save it to a variable, I can directly access objects inside without using "dataValues"

Upvotes: 2

Shivam
Shivam

Reputation: 3622

Yes you can

Model.findAll({
 raw: true,
 //Other parameters
});

would return just the data and not the model instance

Upvotes: 157

Related Questions