5 module.exports = function(sequelize, DataTypes) {
7 var Automation = sequelize.define('Automation', {
8 name: DataTypes.STRING,
9 channel: DataTypes.STRING,
10 description: DataTypes.STRING,
12 type: DataTypes.BOOLEAN,
16 type: DataTypes.INTEGER,
20 tableName: 'tools_automations',
21 associate: function(models) {
22 Automation.hasMany(models.ToolsCondition, {
27 foreignKey: 'AutomationAllId',
31 Automation.hasMany(models.ToolsCondition, {
36 foreignKey: 'AutomationAnyId',
40 Automation.hasMany(models.ToolsAction, {
45 Automation.addScope('all', {
47 model: models.ToolsCondition,
49 attributes: ['field', 'operator', 'value']
51 model: models.ToolsCondition,
53 attributes: ['field', 'operator', 'value']
55 model: models.ToolsAction,
57 attributes: ['action', 'data1', 'data2', 'data3', 'data4', 'data5']