Bulk update records

This example shows how to bulk update users

Please be sure of your agent type and version and pick the right documentation accordingly.

Node.js

This is the documentation of the forest-express-sequelize and forest-express-mongoose Node.js agents that will soon reach end-of-support.

forest-express-sequelize v9 and forest-express-mongoose v9 are replaced by @forestadmin/agent v1.

Please check your agent type and version and read on or switch to the right documentation.

Ruby on Rails

Python

PHP

Anonymize users in bulk

As usual, you must declare the action on your collection.

forest/users.js

// forest/users.js
const Liana = require('forest-express-sequelize');

Liana.collection('users', {
  actions: [
    {
      name: 'Anonymize',
      type: 'single',
    },
  ],
});

ou can then implement the post action as you need. Here the records are simply updated in bulk through the sequelize ORM.

routes/users.js

// routes/users.js
const express = require('express');
const router = express.Router();
const models = require('../models');
const {
  ensureAuthenticated,
  RecordsGetter,
} = require('forest-express-sequelize');

router.post(
  '/actions/anonymize',
  ensureAuthenticated,
  parseRequestBody,
  async (request, response) => {
    const { query, user } = request;
    const recordsGetter = new RecordsGetter(models.user, user, query);
    const records = await recordsGetter.getAll();

    try {
      await models.user.update(
        {
          firstName: '*** Anonymized First Name ***',
          lastName: '*** Anonymized Last Name ***',
        },
        { where: { id: records.map((record) => record.id) } }
      );
      response.send({ success: 'User(s) anonymized' });
    } catch (e) {
      return response
        .status(400)
        .send({ error: `Failure during user anonymization: ${e.message}` });
    }
  }
);

module.exports = router;