6 module.exports = function(sequelize, DataTypes) {
8 var Automation = sequelize.define('Automation', {
9 name: DataTypes.STRING,
10 channel: DataTypes.STRING,
11 description: DataTypes.STRING,
13 type: DataTypes.BOOLEAN,
17 type: DataTypes.INTEGER,
21 tableName: 'tools_automations',
22 associate: function(models) {
23 Automation.hasMany(models.ToolsCondition, {
28 foreignKey: 'AutomationAllId',
32 Automation.hasMany(models.ToolsCondition, {
37 foreignKey: 'AutomationAnyId',
41 Automation.hasMany(models.ToolsAction, {
46 Automation.addScope('all', {
48 model: models.ToolsCondition,
50 attributes: ['field', 'operator', 'value']
52 model: models.ToolsCondition,
54 attributes: ['field', 'operator', 'value']
56 model: models.ToolsAction,
58 attributes: ['action', 'data1', 'data2', 'data3', 'data4', 'data5']