How to store array in mysql using sequelize

by

To store an array in MySQL using Sequelize, we need to define a model that represents our table structure and then use Sequelize methods to perform database operations. Let’s go through the steps with examples:

Step 1: Define Model

const { Sequelize, DataTypes } = require('sequelize');

// Create connection to MySQL database
const sequelize = new Sequelize('database', 'username', 'password', {
  host: 'localhost',
  dialect: 'mysql'
});

// Define Model
const MyModel = sequelize.define('MyModel', {
  arrayField: {
    type: DataTypes.ARRAY(DataTypes.STRING),
    allowNull: false
  }
});

// Sync model with database
(async () => {
  await sequelize.sync();
  console.log('Model synchronized with database');
})();

Step 2: Store Array

To store an array in MySQL, we can simply pass the array as a value to the corresponding field using the model’s create method. Here’s an example:

// Store Array
MyModel.create({ arrayField: ['value1', 'value2', 'value3'] })
  .then((result) => {
    console.log('Array stored successfully:', result);
  })
  .catch((error) => {
    console.error('Error storing array:', error);
  });

Step 3: Retrieve Array

To retrieve the stored array from MySQL, we can use Sequelize’s find or findAll methods. Here’s an example:

// Retrieve Array
MyModel.findOne({ where: { id: 1 } })
  .then((result) => {
    console.log('Retrieved array:', result.arrayField);
  })
  .catch((error) => {
    console.error('Error retrieving array:', error);
  });

Step 4: Update Array

If you need to update the stored array, you can use the model’s update method. Here’s an example:

// Update Array
MyModel.update({ arrayField: ['new value1', 'new value2'] }, { where: { id: 1 } })
  .then((result) => {
    console.log('Array updated successfully:', result);
  })
  .catch((error) => {
    console.error('Error updating array:', error);
  });

Step 5: Delete Array

To delete the stored array, you can use the model’s destroy method. Here’s an example:

// Delete Array
MyModel.destroy({ where: { id: 1 } })
  .then(() => {
    console.log('Array deleted successfully');
  })
  .catch((error) => {
    console.error('Error deleting array:', error);
  });

That’s it! With the above steps, you can store an array in MySQL using Sequelize. Make sure to replace ‘database’, ‘username’, and ‘password’ with your actual database credentials, and modify the model and field names according to your requirements.

Leave a comment