Tips on converting Sequelize response to an array of strings instead of objects

Question

Tips on converting Sequelize response to an array of strings instead of objects

When utilizing Sequelize on a join query, I am currently facing the issue where the data from the join table is presented as an array of objects instead of strings. The client specifically needs an array of strings.

Is it possible and advisable to achieve this with Sequelize? Or should I manually transform the data before sending it to the client?

Query

movie.findOne({
        include: [
          {
            model: db.genre,
            attributes: ['name'],
            through: {
              attributes: [],
            },
          },
      })

Output

{
  "id": 52,
  "type": "movie",
  "Genres": [
      {
          "name": "Action"
      },
      {
          "name": "Comedy"
      }
  ]
}

My ideal format for Genres would be:

"Genres": ["Action", "Comedy"]

javascript express orm sequelize.js

Answer 1

Answer №1

Although not achievable directly with pure sequelize, it can be easily accomplished by formatting the object post-query.

ob.Genres = ob.Genres.map(x=>x.name);
 // { id: 52, type: 'movie', Genres: [ 'Action', 'Comedy' ] }

Alternatively, you could utilize a sequelize literal to group the desired data as a separate attribute, but this approach is needlessly complex.

movie.findOne({
    where:{
        id:52
    },
    attributes: [
            'id','type',
            [Sequelize.literal(`
                (
                SELECT GROUP_CONCAT(name)
                    FROM Genres
                    WHERE
                        movieId = 52
                )`), 'Genres'],
            ] 
})

Assuming certain aspects of your database structure, this method allows for grouping all names from a query result and storing them in a new attribute.

It is recommended to manually map the value after querying instead.

Answer 2

Although not achievable directly with pure sequelize, it can be easily accomplished by formatting the object post-query.

ob.Genres = ob.Genres.map(x=>x.name);
 // { id: 52, type: 'movie', Genres: [ 'Action', 'Comedy' ] }

Alternatively, you could utilize a sequelize literal to group the desired data as a separate attribute, but this approach is needlessly complex.

movie.findOne({
    where:{
        id:52
    },
    attributes: [
            'id','type',
            [Sequelize.literal(`
                (
                SELECT GROUP_CONCAT(name)
                    FROM Genres
                    WHERE
                        movieId = 52
                )`), 'Genres'],
            ] 
})

Assuming certain aspects of your database structure, this method allows for grouping all names from a query result and storing them in a new attribute.

It is recommended to manually map the value after querying instead.

Answer 3

Answer №2

Utilize Sequelize's pluck method to easily extract specific properties from an array of objects. This method allows you to specify the property you wish to extract and returns an array containing those values.

const result = movie.findByPk({
    include: [
      {
        model: db.genre,
        attributes: ['name'],
        through: {
          attributes: [],
        },
      },
  });

  const extractedValues = result.map(obj => obj.property);
  console.log(extractedValues);

Answer 4

Utilize Sequelize's pluck method to easily extract specific properties from an array of objects. This method allows you to specify the property you wish to extract and returns an array containing those values.

const result = movie.findByPk({
    include: [
      {
        model: db.genre,
        attributes: ['name'],
        through: {
          attributes: [],
        },
      },
  });

  const extractedValues = result.map(obj => obj.property);
  console.log(extractedValues);

Tips on converting Sequelize response to an array of strings instead of objects

Answer №1

Answer №2

Similar questions

What is the best way to set up CORS in IE11 using C# with JQuery.ajax?

Firefox 44 experiencing issue with HTML 5 Video playing sounds unexpectedly

verifying the presence of offspring in knockout js

Rollup does not allow the use of self-written component imports in a component library

Steps for referencing an autogenerated id in a Firestore collection

unable to update database using jquery ajax

Is there a way to verify the existence of an email address, generate an error if it does, and create a user only if there is no match

Calculating grand total upon form initialization

Display upon hovering, conceal with a button located within a popup container

Encountering the error message "Type '{ theme: Theme; }' is not compatible with type" while attempting to pass it as a prop to the App component

Retrieve the HTML code from a file and store it in a JavaScript variable

Implementing Decimal Input in Bootstrap-Vue for Google Chrome on Android

Troubleshooting Problem with NodeJS Https.request

Streamline user access with automatic JWT authentication in Vue application

Is it possible for Express JS to receive incoming requests from external sources and then transmit the retrieved data to the front end of

Retrieve props in a Vue component using the available context

Changing the string "2012-04-10T15:57:51.013" into a Date object using JavaScript

Tips for running multiple JavaScript functions in ASP.NET using Button's OnClientClick property

After switching from jQuery to pure JavaScript, the code is now up and

Error message "Uncaught TypeError: Unable to read property 'defaultView' of undefined" was encountered while using Google Maps