Example of a Forest Smart Segment on Express Sequelize

forestSmartSegmentExpress.js

// forest/candidate.js
'use strict';
const _ = require('lodash');
const Liana = require('forest-express-sequelize');
const models = require('../models');
const { Op } = models.Sequelize;

Liana.collection('candidate', {
  segments: [{
    name: 'Elections 2017',
    where: () => {
      const query = 'SELECT DISTINCT(candidates.id) FROM candidates WHERE EXISTS (SELECT * FROM "election_candidates" WHERE "election_candidates"."candidate_id" = candidates.id AND "election_candidates".election_id = 2)';

      return models.sequelize
        .query(query)
        .then((candidates) => {
          return { id: { [Op.in]: _.map(candidates[0], 'id') }};
        });
    }
  }]
});